info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
20 rows where type = "binary" sorted by description
This data as json, CSV (advanced)
Suggested facets: table_id, column_number, name, comment_entry, incomplete, description, comment
Link | rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description ▼ | comment |
---|---|---|---|---|---|---|---|---|---|---|
66 | 66 | 78 | 49 | 12 | sex_male | binary | 0 | 0 | ||
116 | 116 | 139 | election 35 | 6 | early | binary | 1 | 1 | Early (snap) election before constitutionally mandated term end | If there is no constitutionally mandated next election date (e.g. UK), an election that takes place 1 year earlier than the maximum feasible period is considered an early election. |
236 | 236 | 287 | 50 | 7 | acting | binary | 0 | 0 | acting minister | |
301 | 301 | 372 | view_cabinet 54 | 7 | cabinet_party | binary | 0 | 0 | cabinet member vs. opposition party | |
47 | 47 | 51 | external_commissioner_doering 20 | 16 | elected | binary | 0 | 0 | career with political position before | |
74 | 74 | 87 | cabinet 12 | 9 | caretaker | binary | 0 | 0 | caretaker cabinet with a limited legislative mandate: non-partisan, provisional, technical or continuation (tree month rule) cabinet | |
284 | 284 | 349 | view_cabinet 54 | 6 | caretaker | binary | 0 | 0 | caretaker cabinet with a limited legislative mandate: non-partisan, provisional, technical or continuation (tree month rule) cabinet | |
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
401 | 401 | 501 | party_name_change 30 | 4 | party_change | binary | 0 | 0 | formation of new party | new party formed that does not meet ParlGov new party coding rule (e.g. successor party) |
84 | 84 | 101 | country 19 | 21 | public | binary | 0 | 0 | indicates if data for this country is included in ParlGov's stable and development version | |
72 | 72 | 84 | cabinet_party 5 | 4 | pm | binary | 0 | 0 | indicates if the party fills the prime minster position | |
298 | 298 | 369 | view_cabinet 54 | 8 | prime_minister | binary | 0 | 0 | indicates if the party fills the prime minster position | |
42 | 42 | 45 | external_commissioner_doering 20 | 9 | incumbent | binary | 0 | 0 | member of previous Commission | |
368 | 368 | 463 | 50 | 19 | validation | binary | 0 | 0 | observation has been validated with an external source | |
43 | 43 | 46 | external_commissioner_doering 20 | 10 | one_seat | binary | 0 | 0 | one seat in Commission | |
375 | 375 | 472 | viewcalc_parliament_composition 69 | 6 | cabinet_formation | binary | 0 | 0 | parliament composition at the date of a cabinet formation | |
211 | 211 | 247 | 46 | 5 | president | binary | 0 | 0 | party president | |
50 | 50 | 54 | external_commissioner_doering 20 | 14 | president | binary | 0 | 0 | president of Commission | |
213 | 213 | 257 | info_variable 13 | 7 | incomplete | binary | 0 | 0 | variable that has not been coded for all countries yet | |
235 | 235 | 286 | info_variable 13 | 6 | comment_entry | binary | 0 | 0 | variable that should also be documented in 'description' field of observation |
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]) );