chain_analysis

21 rows where named_chains_id = 20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ analysis_id named_chains_id
269 269 MA 98 Radio 1 0020091800 AllMARadio1 20
276 276 MA 99 Radio 0020061900 AllMARadio1 20
281 281 MA 2000 Radio 0020062001 AllMARadio1 20
285 285 MA 2001 Radio I (WMK) 0020062101 AllMARadio1 20
291 291 MA 2002 Radio I 0020062200 AllMARadio1 20
297 297 ma 2003 Radio I 0020062300 AllMARadio1 20
303 303 ma 2004 Radio I 0020062400 AllMARadio1 20
309 309 ma 2005 Radio I 0020062500 AllMARadio1 20
315 315 ma 2006 Radio I 0020062600 AllMARadio1 20
321 321 ma 2007 Radio I 0020062700 AllMARadio1 20
327 327 ma 2008 Radio I 0020062800 AllMARadio1 20
333 333 ma 2009 Radio I 0020062900 AllMARadio1 20
339 339 ma 2010 Radio I 0020063000 AllMARadio1 20
345 345 ma 2011 Radio I 0020063100 AllMARadio1 20
352 352 ma 2012 Radio I 0020063200 AllMARadio1 20
358 358 ma 2013 Radio I 0020063300 AllMARadio1 20
364 364 ma 2014 Radio I 0020063400 AllMARadio1 20
370 370 ma 2015 Radio I 0020063500 AllMARadio1 20
376 376 ma 2016 Radio I 0020063600 AllMARadio1 20
378 378 ma 2016 Radio II 0020113600 AllMARadio1 20
382 382 ma 2017 Radio I 0020063700 AllMARadio1 20

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE chain_analysis (
	analysis_id VARCHAR(10), 
	named_chains_id INTEGER, 
	FOREIGN KEY(analysis_id) REFERENCES analysis (id), 
	FOREIGN KEY(named_chains_id) REFERENCES named_chains (id)
);