view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where comment = "In versions prior to ParlGov 11/07, the number of seats was based on seats won at the last election (table 'election_result'). It does now take into account changes in parliament -- see documentation for table 'viewcalc_parliament_composition'."
This data as json, CSV (advanced)
table_name | type | name | description | comment |
---|---|---|---|---|
view_cabinet | integer | seats | number of seats in parliament | In versions prior to ParlGov 11/07, the number of seats was based on seats won at the last election (table 'election_result'). It does now take into account changes in parliament -- see documentation for table 'viewcalc_parliament_composition'. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_variable AS SELECT tbl.name AS table_name, var.type AS type, var.name AS name, var.description AS description, var.comment AS comment FROM info_variable var INNER JOIN (SELECT * FROM info_table) tbl ON var.table_id = tbl.id WHERE SUBSTR(tbl.name, 1, 5) ='view_' ORDER BY tbl.name DESC, var.column_number ASC;
comment 1 ✖