parlgov
Data source: ParlGov · About: simonw/parlgov-datasette
rowid | id | table_id | column_number | name | type | comment_entry | incomplete | description | comment |
---|---|---|---|---|---|---|---|---|---|
2 | 3 | 19 | 5 | eu_accession_date | date | 0 | 0 | date of EU accession for EU members -- empty for non-members | |
11 | 13 | 35 | 4 | date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last date. | |
40 | 43 | 20 | 7 | start_date | date | 0 | 0 | Commissioner entered Commission | |
41 | 44 | 20 | 8 | end_date | date | 0 | 0 | Commissioner left Commission | |
55 | 65 | 50 | 12 | start_date | date | 0 | 0 | date person took up position | |
56 | 66 | 50 | 13 | end_date | date | 0 | 0 | date person ended the position | |
67 | 79 | 49 | 13 | born_date | date | 0 | 0 | date of birth | |
68 | 80 | 49 | 14 | death_date | date | 0 | 0 | date of death | |
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. |
82 | 96 | 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 | 134 | 30 | 3 | date | date | 0 | 0 | date of party naming | Coded as 1 July (yyyy-07-01) if exact day and month are unknown. |
130 | 153 | 19 | 4 | oecd_accession_date | date | 0 | 0 | date of OECD accession for OECD members -- empty for non-members | |
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. |
268 | 329 | 53 | 4 | election_date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last 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. |
300 | 371 | 54 | 3 | election_date | date | 0 | 0 | Date the election took place. If the election lasted for several days, we code the last date. | |
370 | 467 | 69 | 2 | date | date | 0 | 0 | date of party composition of parliament | |
374 | 471 | 69 | 7 | calculation_date | date | 0 | 0 | date and time calculation was performed with ParlGov R script | |
378 | 475 | 70 | 3 | date | date | 0 | 0 | date of party composition parliament | |
407 | 510 | 73 | 3 | start_date | date | 0 | 0 | ||
408 | 511 | 73 | 4 | end_date | date | 0 | 0 |