15 rows where named_chains_id = 4

View and edit SQL

Link rowid ▼ analysis_id named_chains_id
520 New Establishment Survey 2009 0590013000 NES 4
521 New Establishment Survey 2010 0590013001 NES 4
522 New Establishment Survey 2011 0590013101 NES 4
523 New Establishment Survey 2012 0590013201 NES 4
524 New Establishment Survey 2013 0590013301 NES 4
525 New Establishment Survey 2014 0590013401 NES 4
526 Establishment Survey 2015 0590013501 NES 4
527 Establishment Survey 2016 (Gesamt) 0590013601 NES 4
528 Establishment Survey 2017 (Gesamt) 0590013701 NES 4
529 Establishment Survey 2018 (Gesamt) 0590013801 NES 4
530 Establishment Survey 2019 (Gesamt) 0590013901 NES 4
531 Establishment Survey 2020 (Gesamt) 0590014001 NES 4
532 Establishment Survey 2021 (Gesamt) 0590014101 NES 4
533 Establishment Survey 2022 (Gesamt) 0590014201 NES 4
534 Establishment Survey 2023 (Gesamt) 0590014301 NES 4

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