info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by description descending
This data as json, CSV (advanced)
Suggested facets: column_number, type, comment_entry, comment
Link | rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description ▲ | comment |
---|---|---|---|---|---|---|---|---|---|---|
146 | 146 | 169 | 38 | 6 | year | integer | 0 | 0 | year of party name change | |
36 | 36 | 39 | external_commissioner_doering 20 | 3 | commission_year | integer | 0 | 0 | year Commission formed | |
404 | 404 | 507 | viewcalc_election_parameter 27 | 2 | turnout | real | 0 | 0 | voter turnout – share of 'votes cast' relative to 'electorate' | |
235 | 235 | 286 | info_variable 13 | 6 | comment_entry | binary | 0 | 0 | variable that should also be documented in 'description' field of observation | |
213 | 213 | 257 | info_variable 13 | 7 | incomplete | binary | 0 | 0 | variable that has not been coded for all countries yet | |
145 | 145 | 168 | info_data_source 41 | 5 | url | text | 0 | 0 | url of reference | |
174 | 174 | 205 | external_party_huber_inglehart 28 | 8 | range_right | real | 0 | 0 | upper bound of left/right position | |
187 | 187 | 221 | external_party_castles_mair 3 | 7 | range_right | real | 0 | 0 | upper bound of left/right position | |
117 | 117 | 140 | 38 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
142 | 142 | 165 | info_data_source 41 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
177 | 177 | 208 | 40 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
178 | 178 | 209 | election_result 8 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
181 | 181 | 214 | party_change 21 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
182 | 182 | 215 | party_name_change 30 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
183 | 183 | 217 | cabinet_party 5 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
184 | 184 | 218 | external_commissioner_doering 20 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
199 | 199 | 233 | info_table 34 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
201 | 201 | 235 | info_variable 13 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
222 | 222 | 272 | external_country_iso 1 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
226 | 226 | 277 | 47 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
228 | 228 | 279 | info_id 48 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
237 | 237 | 290 | 50 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
331 | 331 | 417 | party_family 64 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
333 | 333 | 419 | 61 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | ||
336 | 336 | 422 | 65 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
341 | 341 | 428 | 67 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
348 | 348 | 437 | 68 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
376 | 376 | 473 | 70 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
393 | 393 | 493 | 72 | 3 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
405 | 405 | 508 | politician_president 73 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table | |
90 | 90 | 111 | info_table 34 | 2 | type | text | 0 | 0 | type of the table. either table or view | |
267 | 267 | 328 | view_election 53 | 3 | election_type | text | 0 | 0 | type of election -- 'parliament' or 'ep' election | |
123 | 123 | 146 | info_variable 13 | 5 | type | text | 0 | 0 | type of data (text, integer, real, binary, date) | |
417 | 417 | 522 | view_variable 74 | 2 | type | text | 0 | 0 | type of data (text, integer, real, binary, date) | |
12 | 12 | 14 | election 35 | 9 | seats_total | integer | 0 | 0 | total number of seats | |
274 | 274 | 335 | view_election 53 | 7 | seats_total | integer | 0 | 0 | total number of seats | |
86 | 86 | 103 | country 19 | 3 | name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
266 | 266 | 327 | view_election 53 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
279 | 279 | 344 | view_cabinet 54 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
290 | 290 | 355 | view_party 52 | 1 | country_name_short | text | 0 | 0 | three letter abbreviation of country -- iso alpha code | |
39 | 39 | 42 | external_commissioner_doering 20 | 6 | person_id_source | text | 0 | 0 | textual string with the person name in the data source of the observation | |
121 | 121 | 144 | info_variable 13 | 2 | table_id | text | 0 | 0 | table identifier in 'info_table' | |
75 | 75 | 88 | cabinet 12 | 3 | start_date | date | 0 | 0 | start of cabinet defined as the date of the first event that determines a new cabinet | For some (continuation) caretaker cabinet, the date is set to election date. |
283 | 283 | 348 | view_cabinet 54 | 4 | start_date | date | 0 | 0 | start of cabinet defined as the date of the first event that determines a new cabinet | For some (continuation) caretaker cabinet, the date is set to election date. |
175 | 175 | 206 | external_party_huber_inglehart 28 | 9 | sd | real | 0 | 0 | standard deviation of left/right position | |
79 | 79 | 92 | 50 | 14 | resignation_cause | text | 0 | 0 | short textual information on the cause of resignation | |
143 | 143 | 166 | info_data_source 41 | 3 | short | text | 0 | 0 | short reference | |
232 | 232 | 283 | info_id 48 | 4 | short | text | 0 | 0 | short name | |
8 | 8 | 10 | election_result 8 | 11 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
58 | 58 | 68 | 50 | 15 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
126 | 126 | 149 | cabinet 12 | 11 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
127 | 127 | 150 | cabinet_party 5 | 7 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
128 | 128 | 151 | external_commissioner_doering 20 | 19 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
129 | 129 | 152 | election 35 | 13 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
137 | 137 | 160 | 40 | 7 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
206 | 206 | 242 | info_table 34 | 4 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
325 | 325 | 409 | party_change 21 | 6 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
326 | 326 | 410 | party_name_change 30 | 10 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
328 | 328 | 412 | party 29 | 12 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
329 | 329 | 414 | 49 | 17 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
345 | 345 | 433 | 67 | 6 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
356 | 356 | 445 | 68 | 13 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
379 | 379 | 477 | 70 | 7 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
412 | 412 | 516 | politician_president 73 | 9 | data_source | text | 0 | 0 | short list of data sources used to code this variable -- references, except urls, are entries in table 'info_data_source' | |
141 | 141 | 164 | info_data_source 41 | 2 | key | text | 0 | 0 | short key of reference as used in variable 'data_source' | |
392 | 392 | 492 | viewcalc_country_year_share 71 | 4 | share | real | 0 | 0 | share of year observation covers | |
302 | 302 | 373 | view_cabinet 54 | 10 | election_seats_total | integer | 0 | 0 | seats total in parliament | |
48 | 48 | 52 | external_commissioner_doering 20 | 17 | score_position | real | 0 | 0 | score for highest position | |
337 | 337 | 424 | 65 | 3 | salience | 0 | 0 | salience measure | ||
166 | 166 | 197 | 38 | 8 | row_number | integer | 0 | 0 | row number of entry in CMP party table | |
195 | 195 | 229 | external_country_iso 1 | 3 | region | text | 0 | 0 | region name | |
50 | 50 | 54 | external_commissioner_doering 20 | 14 | president | binary | 0 | 0 | president of Commission | |
105 | 105 | 128 | viewcalc_election_parameter 27 | 7 | polarization_vote | real | 0 | 0 | polarization index (Dalton 2008, 906) – vote share based with 'view_calc_party_position' left/right values | |
420 | 420 | 525 | viewcalc_election_parameter 27 | 8 | polarization_seats | real | 0 | 0 | polarization index (Dalton 2008, 906) – seats share based with 'view_calc_party_position' left/right values | |
6 | 6 | 8 | election_result 8 | 7 | vote_share | real | 0 | 0 | percentage of votes for a party | |
272 | 272 | 333 | view_election 53 | 5 | vote_share | real | 0 | 0 | percentage of votes for a party | |
211 | 211 | 247 | 46 | 5 | president | binary | 0 | 0 | party president | |
318 | 318 | 390 | external_party_ray 56 | 5 | party | text | 0 | 0 | party name short | |
319 | 319 | 391 | external_party_ray 56 | 6 | ename | text | 0 | 0 | party name english | |
320 | 320 | 392 | external_party_ray 56 | 7 | name | text | 0 | 0 | party name | |
81 | 81 | 95 | party_change 21 | 3 | party_id_new | integer | 0 | 0 | party id of the successor party | |
255 | 255 | 309 | view_party 52 | 22 | party_id | integer | 0 | 0 | party id | |
261 | 261 | 321 | view_party 52 | 8 | family_name | text | 0 | 0 | party family name | |
262 | 262 | 322 | view_party 52 | 7 | family_name_short | text | 0 | 0 | party family abbreviation | |
45 | 45 | 49 | external_commissioner_doering 20 | 13 | government_party | category | 0 | 0 | party affiliation at appointment | 10 government, 11 opposition, 12 other |
20 | 20 | 22 | party 29 | 4 | name_short | text | 0 | 0 | party abbreviation (original name) | |
112 | 112 | 135 | party_name_change 30 | 5 | name_short | text | 0 | 0 | party abbreviation | |
118 | 118 | 141 | 38 | 3 | name_short | text | 0 | 0 | party abbreviation | |
159 | 159 | 185 | external_party_cmp 37 | 2 | name_short | text | 0 | 0 | party abbreviation | |
163 | 163 | 193 | external_party_chess 11 | 3 | name_short | text | 0 | 0 | party abbreviation | |
171 | 171 | 202 | external_party_huber_inglehart 28 | 5 | name_short | text | 0 | 0 | party abbreviation | |
189 | 189 | 223 | external_party_castles_mair 3 | 5 | name_short | text | 0 | 0 | party abbreviation | |
204 | 204 | 240 | external_party_benoit_laver 4 | 3 | Party | text | 0 | 0 | party abbreviation | |
209 | 209 | 245 | 46 | 3 | Party | text | 0 | 0 | party abbreviation | |
252 | 252 | 306 | view_party 52 | 3 | party_name_short | text | 0 | 0 | party abbreviation | |
275 | 275 | 336 | view_election 53 | 8 | party_name_short | text | 0 | 0 | party abbreviation | |
286 | 286 | 351 | view_cabinet 54 | 11 | party_name_short | text | 0 | 0 | party abbreviation | |
375 | 375 | 472 | viewcalc_parliament_composition 69 | 6 | cabinet_formation | binary | 0 | 0 | parliament composition at the date of a cabinet formation | |
22 | 22 | 24 | party 29 | 7 | name_ascii | text | 0 | 0 | original name of party without special characters (this one may be easier to handle with in statistical packages) | |
254 | 254 | 308 | view_party 52 | 6 | party_name_ascii | text | 0 | 0 | original name of party without special characters (this one may be easier to handle with in statistical packages) |
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]) );