view_variable (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where comment = "Seats coded for alliance members if information available. Coded as 0 for parties that won no seats and as missing value for electoral alliances if seats are coded at the level of alliance members." sorted by description
This data as json, CSV (advanced)
table_name | type | name | description ▼ | comment |
---|---|---|---|---|
view_election | integer | seats | number of seats won by party | Seats coded for alliance members if information available. Coded as 0 for parties that won no seats and as missing value for electoral alliances if seats are coded at the level of alliance members. |
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 ✖