info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
422 rows sorted by name
This data as json, CSV (advanced)
Link | rowid | id | table_id | column_number | name ▼ | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
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' | |
225 | 225 | 276 | 47 | 2 | datasource_id | integer | 0 | 0 | info_data_source ID | |
11 | 11 | 13 | election 35 | 4 | date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last date. | |
82 | 82 | 96 | party_change 21 | 4 | date | date | 0 | 0 | date party change took place | Coded as 1 July (yyyy-07-01) if exact day and month are unknown and as first day of month if only month is known. |
111 | 111 | 134 | party_name_change 30 | 3 | date | date | 0 | 0 | date of party naming | Coded as 1 July (yyyy-07-01) if exact day and month are unknown. |
134 | 134 | 157 | 40 | 3 | date | date | 0 | 0 | Date of change for party affiliations in parliament | Coded as 1 (yyyy-mm-01) if exact day is unknown and as 1 July (yyyy-07-01) if only year is known. |
361 | 361 | 450 | 68 | 3 | date | 0 | 0 | |||
370 | 370 | 467 | viewcalc_parliament_composition 69 | 2 | date | date | 0 | 0 | date of party composition of parliament | |
378 | 378 | 475 | 70 | 3 | date | date | 0 | 0 | date of party composition parliament | |
68 | 68 | 80 | 49 | 14 | death_date | date | 0 | 0 | date of death | |
241 | 241 | 295 | 49 | 16 | death_place | 0 | 0 | |||
92 | 92 | 113 | info_table 34 | 5 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
124 | 124 | 147 | info_variable 13 | 8 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
214 | 214 | 258 | cabinet 12 | 12 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
219 | 219 | 268 | election 35 | 14 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
227 | 227 | 278 | info_id 48 | 6 | description | text | 0 | 0 | description of id | |
327 | 327 | 411 | party 29 | 13 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
347 | 347 | 436 | 67 | 7 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
359 | 359 | 448 | 68 | 15 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
367 | 367 | 462 | election_result 8 | 12 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
382 | 382 | 481 | cabinet_party 5 | 8 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
397 | 397 | 497 | 72 | 2 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
402 | 402 | 503 | party_name_change 30 | 11 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
403 | 403 | 505 | party_change 21 | 7 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
413 | 413 | 517 | politician_president 73 | 10 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
418 | 418 | 523 | view_variable 74 | 4 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
421 | 421 | 526 | 40 | 8 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
422 | 422 | 527 | 70 | 8 | description | text | 0 | 0 | Information about this observation. | This field should also include a short textual account of all information that is coded in the 'data_json' field. |
365 | 365 | 459 | 68 | 14 | description_cabinet | binary | 0 | 0 | description of confidence vote in description field of cabinet (eg. investiture vote) | |
107 | 107 | 130 | viewcalc_election_parameter 27 | 5 | disproportionality | real | 0 | 0 | disproportionality index (Gallagher 1991) | |
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. |
313 | 313 | 384 | party 29 | 18 | ees | integer | 0 | 0 | European Election Study (2009) party ID | |
314 | 314 | 385 | view_party 52 | 15 | ees | integer | 0 | 0 | European Election Study (2009) party ID | |
364 | 364 | 455 | country 19 | 9 | ees | text | 0 | 0 | European Election Study (2009) country ID | |
47 | 47 | 51 | external_commissioner_doering 20 | 16 | elected | binary | 0 | 0 | career with political position before | |
268 | 268 | 329 | view_election 53 | 4 | election_date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last date. | |
300 | 300 | 371 | view_cabinet 54 | 3 | election_date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last date. | |
3 | 3 | 4 | election_result 8 | 2 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Variable name 'id' in 'election' table and 'election_id' in all other tables. | |
103 | 103 | 126 | viewcalc_election_parameter 27 | 1 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
133 | 133 | 156 | 40 | 2 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
270 | 270 | 331 | view_election 53 | 13 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
299 | 299 | 370 | view_cabinet 54 | 16 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Other tables refer to this variable as 'election_id'. | |
369 | 369 | 466 | viewcalc_parliament_composition 69 | 1 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Variable name 'id' in 'election' table and 'election_id' in all other tables. | |
377 | 377 | 474 | 70 | 2 | election_id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Variable name 'id' in 'election' table and 'election_id' in all other tables. | |
302 | 302 | 373 | view_cabinet 54 | 10 | election_seats_total | integer | 0 | 0 | seats total in parliament | |
267 | 267 | 328 | view_election 53 | 3 | election_type | text | 0 | 0 | type of election -- 'parliament' or 'ep' election | |
15 | 15 | 17 | election 35 | 10 | electorate | integer | 0 | 0 | number citizens eligible to vote | |
319 | 319 | 391 | external_party_ray 56 | 6 | ename | text | 0 | 0 | party name english | |
41 | 41 | 44 | external_commissioner_doering 20 | 8 | end_date | date | 0 | 0 | Commissioner left Commission | |
56 | 56 | 66 | 50 | 13 | end_date | date | 0 | 0 | date person ended the position | |
408 | 408 | 511 | politician_president 73 | 4 | end_date | date | 0 | 0 | ||
108 | 108 | 131 | viewcalc_election_parameter 27 | 4 | enp_seats | real | 0 | 0 | effective number of parties seats – legislative parties (Laakso/Taagepera 1979) | |
109 | 109 | 132 | viewcalc_election_parameter 27 | 3 | enp_votes | real | 0 | 0 | effective number of parties votes – elected parties (Laakso/Taagepera 1979) | |
2 | 2 | 3 | country 19 | 5 | eu_accession_date | date | 0 | 0 | date of EU accession for EU members -- empty for non-members | |
96 | 96 | 118 | viewcalc_party_position 7 | 5 | eu_anti_pro | real | 0 | 0 | 0--10 scale mean value in 'EU integration' dimension with data from Ray 1999, Benoit/Laver 2006 and CHES 2010 | previously variable 'eu_pro_contra' in ParlGov 11/07 |
296 | 296 | 367 | view_party 52 | 12 | eu_anti_pro | real | 0 | 0 | 0--10 scale mean value in 'EU integration' dimension with data from Ray 1999, Benoit/Laver 2006 and CHES 2010 | previously variable 'eu_pro_contra' in ParlGov 11/07 |
147 | 147 | 173 | country 19 | 8 | euprofiler | integer | 0 | 0 | EU Profiler (Trechsel/Mair 2009) country ID -- the two Belgium country IDs (2, 3) are recoded to 222333 | |
149 | 149 | 175 | party 29 | 17 | euprofiler | integer | 0 | 0 | EU Profiler (Trechsel/Mair 2009) party ID | |
263 | 263 | 324 | view_party 52 | 14 | euprofiler | integer | 0 | 0 | EU Profiler (Trechsel/Mair 2009) party ID | |
19 | 19 | 21 | party 29 | 3 | family_id | integer | 0 | 0 | ParlGov unique party family identifier -- see table 'info_id' for a description | |
257 | 257 | 311 | view_party 52 | 23 | family_id | integer | 0 | 0 | ParlGov unique party family identifier -- see table 'info_id' for a description | |
61 | 61 | 73 | 49 | 3 | family_name | text | 0 | 0 | family name of politician | |
261 | 261 | 321 | view_party 52 | 8 | family_name | text | 0 | 0 | party family name | |
242 | 242 | 296 | 49 | 5 | family_name_prefix | 0 | 0 | |||
262 | 262 | 322 | view_party 52 | 7 | family_name_short | text | 0 | 0 | party family abbreviation | |
62 | 62 | 74 | 49 | 6 | family_name_suffix | text | 0 | 0 | additons to family name of politician (e.g. Dr., von) | |
73 | 73 | 86 | external_country_iso 1 | 6 | fips | text | 0 | 0 | Federal Information Processing Standards (FIPS) country code | |
63 | 63 | 75 | 49 | 7 | first_name | text | 0 | 0 | first name of politician | |
243 | 243 | 297 | 49 | 8 | first_name_addition | 0 | 0 | |||
220 | 220 | 269 | election 35 | 5 | first_round_election_id | integer | 0 | 0 | election_id of first round election -- technically, two round elections are coded as two observations in table 'election'. this variable links the two rounds | |
144 | 144 | 167 | info_data_source 41 | 4 | full | text | 0 | 0 | full reference | |
45 | 45 | 49 | external_commissioner_doering 20 | 13 | government_party | category | 0 | 0 | party affiliation at appointment | 10 government, 11 opposition, 12 other |
49 | 49 | 53 | external_commissioner_doering 20 | 18 | highest_position | text | 0 | 0 | highest former position | |
244 | 244 | 298 | 49 | 23 | hix_ea | 0 | 0 | |||
245 | 245 | 299 | 49 | 24 | hoyland_ea | 0 | 0 | |||
28 | 28 | 31 | party 29 | 21 | huber_inglehart | integer | 0 | 0 | Huber/Inglehart (1995) expert survey party ID -- combined from number of country and number of party entry in Appendix 2 (pp. 92--108) | |
98 | 98 | 120 | country 19 | 12 | huber_inglehart | text | 0 | 0 | Huber/Inglehart (1995) expert survey country ID | |
293 | 293 | 359 | view_party 52 | 17 | huber_inglehart | integer | 0 | 0 | Huber/Inglehart (1995) expert survey party ID -- combined from number of country and number of party entry in Appendix 2 (pp. 92--108) | |
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 | |
151 | 151 | 177 | external_party_chess 11 | 1 | id | integer | 0 | 0 | Chapel Hill expert survey series (CHESS) party ID (Hooghe ea. 2010; Marks/Steenbergen 2007) | |
155 | 155 | 181 | external_party_euprofiler 45 | 1 | id | integer | 0 | 0 | EU Profiler party ID (Trechsel/Mair 2009) | |
158 | 158 | 184 | external_party_cmp 37 | 1 | id | integer | 0 | 0 | Comparative Manifestos Project (CMP) party ID (Budge ea. 2001; Klingemann ea. 2006) | |
162 | 162 | 191 | cabinet 12 | 1 | id | integer | 0 | 0 | ParlGov unique identifier for each cabinet. Variable name 'id' in 'cabinet' table and 'cabinet_id' in all other tables. | |
167 | 167 | 198 | external_party_huber_inglehart 28 | 1 | id | integer | 0 | 0 | Huber/Inglehart (1995) expert survey party ID -- combined from number of country and number of party entry in Appendix 2 (pp. 92--108) | |
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 | |
179 | 179 | 212 | election 35 | 1 | id | integer | 0 | 0 | ParlGov unique identifier for national and EP elections. Variable name 'id' in 'election' table and 'election_id' in all other tables. | |
180 | 180 | 213 | party 29 | 1 | id | integer | 0 | 0 | ParlGov unique party identifier. Variable name 'id' in 'party' table and 'party_id' in all other tables. | |
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 | |
193 | 193 | 227 | external_party_castles_mair 3 | 1 | id | integer | 0 | 0 | Castles/Mair (1983) expert survey party ID -- combined from number of country and number of party entry in data table (pp. 75--83) | |
199 | 199 | 233 | info_table 34 | 1 | id | integer | 0 | 0 | unique numeric identifier for each observation in data table |
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]) );