parlgov
Data source: ParlGov · About: simonw/parlgov-datasette
Tables
cabinet
id, country_id, start_date, name, caretaker, wikipedia, data_source, description, comment, previous_cabinet_id, previous_parliament_election_id, previous_ep_election_id, old_countryID, old_cabID
1,591 rows
country
id, name, name_short, oecd_accession_date, eu_accession_date, iso_numeric, cmp, euprofiler, ees, morgan, castles_mair, huber_inglehart, ray, chess, benoit_laver, public, comment, old_countryID
37 rows
election
id, type_id, country_id, date, first_round_election_id, early, wikipedia, seats_total, electorate, votes_cast, votes_valid, data_source, description, comment, previous_parliament_election_id, previous_ep_election_id, previous_cabinet_id, old_countryID, old_parlID
1,010 rows
election_result
id, election_id, party_id, alliance_id, seats, vote_share, votes, data_source, description, comment
9,523 rows
external_commissioner_doering
comment, commission_year, elected, portfolio, id, one_seat, country_id, commission_name, incumbent, person_id, person_id_source, start_date, end_date, score_position, party_id, president, highest_position, data_source, government_party, previous_cabinet_id
308 rows
external_country_iso
id, continent, region, country, capital, fips, iso2, iso3, isonumeric, internet
239 rows
external_party_castles_mair
id, country, name, name_english, name_short, range_left, range_right, left_right, respondents
119 rows
external_party_huber_inglehart
id, country, name_english, name, name_short, left_right, range_left, range_right, sd, respondents
300 rows
info_variable
id, table_id, column_number, name, type, comment_entry, incomplete, description, comment
422 rows
party
id, country_id, family_id, name_short, name_english, name, name_ascii, name_nonlatin, wikipedia, data_source, description, comment, cmp, euprofiler, ees, morgan, castles_mair, huber_inglehart, ray, benoit_laver, chess, old_countryID, old_partyID
1,666 rows
party_name_change
comment, data_source, name, name_english, party_change, name_short, party_id, name_ascii, date, name_nonlatin, id, description
717 rows
politician_president
id, country_id, start_date, end_date, person_id, person_id_source, party_id, data_source, description, comment
339 rows
viewcalc_election_parameter
election_id, turnout, enp_votes, enp_seats, disproportionality, advantage_ratio, polarization_vote, polarization_seats, calculation_date
1,010 rows
viewcalc_parliament_composition
election_id, date, party_id, seats, cabinet_id, cabinet_formation, calculation_date
20,502 rows
viewcalc_party_position
party_id, left_right, state_market, liberty_authority, eu_anti_pro, calculation_date
1,666 rows
external_commissioner_doering_fts (hidden)
comment, portfolio, highest_position, person_id_source, external_commissioner_doering_fts, rank
308 rows
external_party_castles_mair_fts (hidden)
name, name_english, external_party_castles_mair_fts, rank
119 rows
external_party_huber_inglehart_fts (hidden)
name, name_english, external_party_huber_inglehart_fts, rank
300 rows
party_fts (hidden)
name_short, name_english, name, name_nonlatin, description, comment, party_fts, rank
1,666 rows
politician_president_fts (hidden)
person_id_source, description, comment, politician_president_fts, rank
339 rows
Views
Download SQLite DB: parlgov.db 7.1 MB