info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where description = "Commissioner entered Commission" and type = "date"
This data as json, CSV (advanced)
Link | rowid ▼ | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
40 | 40 | 43 | external_commissioner_doering 20 | 7 | start_date | date | 0 | 0 | Commissioner entered Commission |
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]) );