16 rows where family = 012

View and edit SQL

Suggested facets: name

id ▼ name family
0120011700 FAME I VGM 012
0120011701 FAME 97/98 VGM 012
0120011702 FAME 97/98 VGM 012
0120011735 FAME 20.10. VGM 012
0120011802 FAME 98/99 VGM 012
0120011803 VGM FAME 98/99 VGM 012
0120011804 FAME 99 VGM 012
0120011806 VGM FAME 99* VGM 012
0120011902 VGM FAME 99 update VGM 012
0120011903 FAME 99 update VGM 012
0120011935 FAME 99 update Internet VGM 012
0120012000 FAME 2000/2001 VGM 012
0120012001 VGM-FAME 2000 VGM 012
0120012002 IfD-FAME 2000 VGM 012
0120012035 FAME 2000 Internet VGM 012
0120991700 FAME 2.10. VGM 012

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