info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where name = "eu_accession_date" and type = "date"
This data as json, CSV (advanced)
Link | rowid ▼ | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 3 | country 19 | 5 | eu_accession_date | date | 0 | 0 | date of EU accession for EU members -- empty for non-members |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE info_variable("id", "table_id", "column_number", "name", "type", "comment_entry", "incomplete", "description", "comment", FOREIGN KEY([table_id]) REFERENCES [info_table]([id]) );