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