home

parlgov

Data source: ParlGov

Custom SQL query

cabinet

id, country_id, start_date, name, caretaker, wikipedia, data_source, description, comment...

1,457 rows

cabinet_party

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

3,534 rows

country

id, name, name_short, oecd_accession_date, eu_accession_date, iso_numeric, cmp, euprofiler, ees...

37 rows

election

id, type_id, country_id, date, first_round_election_id, early, wikipedia, seats_total, electorate...

927 rows

election_result

id, election_id, party_id, alliance_id, seats, vote_share, votes, data_source, description...

8,509 rows

external_commissioner_doering

comment, commission_year, elected, portfolio, id, one_seat, country_id, commission_name, incumbent...

282 rows

external_country_iso

id, continent, region, country, capital, fips, iso2, iso3, isonumeric...

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...

300 rows

external_party_ray

natid, nation, partyid, party, ename, name

191 rows

info_data_source

id, key, short, full, url

260 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

419 rows

party

id, country_id, family_id, name_short, name_english, name, name_ascii, name_nonlatin, wikipedia...

1,548 rows

party_change

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

832 rows

party_family

id, party_id, type_id

721 rows

party_name_change

comment, data_source, name, name_english, party_change, name_short, party_id, name_ascii, date...

608 rows

politician_president

id, country_id, start_date, end_date, person_id, person_id_source, party_id, data_source, description...

312 rows

sqlite_stat1

tbl, idx, stat

24 rows

viewcalc_country_year_share

id_type, year, id, share

8,197 rows

viewcalc_election_parameter

election_id, turnout, enp_votes, enp_seats, disproportionality, advantage_ratio, polarization_vote, polarization_seats, calculation_date

926 rows

viewcalc_parliament_composition

election_id, date, party_id, seats, cabinet_id, cabinet_formation, calculation_date

18,463 rows

viewcalc_party_position

party_id, left_right, state_market, liberty_authority, eu_anti_pro, calculation_date

1,545 rows

Views

Download SQLite DB: parlgov.db

Powered by Datasette · Query took 0.085ms · Data source: ParlGov