parlgov

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

Custom SQL query

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

cabinet_party

id, cabinet_id, party_id, pm, data_source, description, comment

3,935 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_benoit_laver

id, Country, Party, PartyName

387 rows

external_party_castles_mair

id, country, name, name_english, name_short, range_left, range_right, left_right, respondents

119 rows

external_party_chess

id, country, name_short, name, name_english

324 rows

external_party_cmp

id, name_short, name, name_english, comment, country

755 rows

external_party_ees

id, country, name, name_english

211 rows

external_party_euprofiler

id, country, name

274 rows

external_party_huber_inglehart

id, country, name_english, name, name_short, left_right, range_left, range_right, sd, respondents

300 rows

external_party_ray

natid, nation, partyid, party, ename, name

191 rows

info_data_source

id, key, short, full, url

280 rows

info_id

id, table_variable, order, short, name, description, wikipedia, old_id

99 rows

info_table

id, type, name, data_source, description, comment

32 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_change

comment, data_source, description, party_id_new, party_id, date, id

908 rows

party_family

id, party_id, type_id

769 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_country_year_share

id_type, year, id, share

8,938 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

... and 86 hidden tables

Views

Download SQLite DB: parlgov.db 7.1 MB