20 rows where named_chains_id = 9

View and edit SQL

Link rowid ▼ analysis_id named_chains_id
449 IfD-ACTA 97 0110011700 ACTAIfD 9
451 IfD-ACTA 98 0110011800 ACTAIfD 9
453 IfD-ACTA 99 0110011900 ACTAIfD 9
456 IfD-ACTA 2000 0110022001 ACTAIfD 9
458 IfD-ACTA 2001 0110012100 ACTAIfD 9
459 IfD-ACTA 2002 0110012200 ACTAIfD 9
461 IfD-ACTA 2003 0110012300 ACTAIfD 9
463 ACTA 2004 (IfD-Version) 0110012400 ACTAIfD 9
465 ACTA 2005 (IfD-Version) 0110012500 ACTAIfD 9
467 ACTA 2006 (IfD-Version) 0110012600 ACTAIfD 9
469 ACTA 2007 (IfD-Version) 0110012700 ACTAIfD 9
471 ACTA 2008 (IfD-Version) 0110012800 ACTAIfD 9
473 ACTA 2009 (IfD-Version) 0110012900 ACTAIfD 9
475 ACTA 2010 (IfD-Version) 0110013000 ACTAIfD 9
477 ACTA 2011 (IfD-Version) 0110013100 ACTAIfD 9
479 ACTA 2012 (IfD-Version) 0110013200 ACTAIfD 9
481 ACTA 2013 (IfD-Version) 0110013300 ACTAIfD 9
483 ACTA 2014 (IfD-Version) 0110013400 ACTAIfD 9
485 ACTA 2015 (IfD-Version) 0110013500 ACTAIfD 9
487 ACTA 2016 (IfD-Version) 0110013600 ACTAIfD 9

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)
);