info_variable
Data source: ParlGov · About: simonw/parlgov-datasette
21 rows where type = "date" sorted by description
This data as json, CSV (advanced)
Suggested facets: table_id, column_number, name, description, comment
Link | rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description ▼ | comment |
---|---|---|---|---|---|---|---|---|---|---|
407 | 407 | 510 | politician_president 73 | 3 | start_date | date | 0 | 0 | ||
408 | 408 | 511 | politician_president 73 | 4 | end_date | date | 0 | 0 | ||
40 | 40 | 43 | external_commissioner_doering 20 | 7 | start_date | date | 0 | 0 | Commissioner entered Commission | |
41 | 41 | 44 | external_commissioner_doering 20 | 8 | end_date | date | 0 | 0 | Commissioner left Commission | |
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. |
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. | |
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. | |
374 | 374 | 471 | viewcalc_parliament_composition 69 | 7 | calculation_date | date | 0 | 0 | date and time calculation was performed with ParlGov R script | |
2 | 2 | 3 | country 19 | 5 | eu_accession_date | date | 0 | 0 | date of EU accession for EU members -- empty for non-members | |
130 | 130 | 153 | country 19 | 4 | oecd_accession_date | date | 0 | 0 | date of OECD accession for OECD members -- empty for non-members | |
67 | 67 | 79 | 49 | 13 | born_date | date | 0 | 0 | date of birth | |
68 | 68 | 80 | 49 | 14 | death_date | date | 0 | 0 | date of death | |
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 | |
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. |
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. |
56 | 56 | 66 | 50 | 13 | end_date | date | 0 | 0 | date person ended the position | |
55 | 55 | 65 | 50 | 12 | start_date | date | 0 | 0 | date person took up position | |
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. |
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]) );