info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where description = "date person ended the position" and type = "date"
This data as json, CSV (advanced)
Link | rowid ▼ | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
56 | 56 | 66 | 50 | 13 | end_date | date | 0 | 0 | date person ended the position |
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]) );