home / AnalInfo

analysis_infos

6 rows where analyis_id = 0290023501

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
9060 MinFallzahl 80 MACH Consumer 2015 0290023501
9061 AnalysenKennung MACHConsumer2015 MACH Consumer 2015 0290023501
9062 UniversumsID 1 MACH Consumer 2015 0290023501
9063 Analysenname MACH Consumer 2015 MACH Consumer 2015 0290023501
9064 UniversumName Schweiz Gesamt MACH Consumer 2015 0290023501
9065 Tarifjahr 2016 MACH Consumer 2015 0290023501

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE analysis_infos (
	id INTEGER NOT NULL, 
	"key" VARCHAR(250), 
	value VARCHAR(250), 
	analyis_id VARCHAR(10), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(analyis_id) REFERENCES analysis (id)
);
CREATE INDEX ix_analysis_infos_key ON analysis_infos ("key");
Powered by Datasette · Queries took 19.918ms