4 rows where family = 043

View and edit SQL

Suggested facets: name

id ▼ name family
0430012700 LA Berlin 2007 LA Berlin 043
0430012701 LA Berlin 2007 LA Berlin 043
0430012900 LA Berlin 2009 LA Berlin 043
0430012901 LA Berlin 2009 LA Berlin 043

Advanced export

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

CSV options:

CREATE TABLE analysis (
	id VARCHAR(10) NOT NULL, 
	name VARCHAR(250), 
	family VARCHAR(3), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(family) REFERENCES families (id)
);