analysis
3 rows where family = 014
This data as json, copyable, CSV (advanced)
| id ▼ | name | family |
|---|---|---|
| 0140011700 | CrossMedia | CrossMedia 014 |
| 0140022000 | CrossMedia II | CrossMedia 014 |
| 0140022201 | CrossMedia 3 | CrossMedia 014 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );