home

Menu
  • Search all tables
  • GraphQL API

parlgov

Table actions
  • GraphQL API for parlgov

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,609 rows

cabinet_party

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

3,994 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,021 rows

election_result

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

9,716 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

289 rows

info_id

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

100 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,699 rows

party_change

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

918 rows

party_family

id, party_id, type_id

776 rows

party_name_change

comment, data_source, name, name_english, party_change, name_short, party_id, name_ascii, date, name_nonlatin, id, description

726 rows

politician_president

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

343 rows

viewcalc_country_year_share

id_type, year, id, share

9,069 rows

viewcalc_election_parameter

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

1,021 rows

viewcalc_parliament_composition

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

20,841 rows

viewcalc_party_position

party_id, left_right, state_market, liberty_authority, eu_anti_pro, calculation_date

1,699 rows

cabinet_fts (hidden)

name, description, comment, cabinet_fts, rank

1,609 rows

cabinet_fts_config (hidden)

k, v

1 row

cabinet_fts_data (hidden)

id, block

36 rows

cabinet_fts_docsize (hidden)

id, sz

1,609 rows

cabinet_fts_idx (hidden)

segid, term, pgno

33 rows

country_fts (hidden)

name, name_short, country_fts, rank

37 rows

country_fts_config (hidden)

k, v

1 row

country_fts_data (hidden)

id, block

3 rows

country_fts_docsize (hidden)

id, sz

37 rows

country_fts_idx (hidden)

segid, term, pgno

1 row

election_fts (hidden)

comment, election_fts, rank

1,021 rows

election_fts_config (hidden)

k, v

1 row

election_fts_data (hidden)

id, block

5 rows

election_fts_docsize (hidden)

id, sz

1,021 rows

election_fts_idx (hidden)

segid, term, pgno

3 rows

external_commissioner_doering_fts (hidden)

comment, portfolio, highest_position, person_id_source, external_commissioner_doering_fts, rank

308 rows

external_commissioner_doering_fts_config (hidden)

k, v

1 row

external_commissioner_doering_fts_data (hidden)

id, block

7 rows

external_commissioner_doering_fts_docsize (hidden)

id, sz

308 rows

external_commissioner_doering_fts_idx (hidden)

segid, term, pgno

5 rows

external_country_iso_fts (hidden)

country, capital, external_country_iso_fts, rank

239 rows

external_country_iso_fts_config (hidden)

k, v

1 row

external_country_iso_fts_data (hidden)

id, block

4 rows

external_country_iso_fts_docsize (hidden)

id, sz

239 rows

external_country_iso_fts_idx (hidden)

segid, term, pgno

2 rows

external_party_benoit_laver_fts (hidden)

PartyName, external_party_benoit_laver_fts, rank

387 rows

external_party_benoit_laver_fts_config (hidden)

k, v

1 row

external_party_benoit_laver_fts_data (hidden)

id, block

4 rows

external_party_benoit_laver_fts_docsize (hidden)

id, sz

387 rows

external_party_benoit_laver_fts_idx (hidden)

segid, term, pgno

2 rows

external_party_castles_mair_fts (hidden)

name, name_english, external_party_castles_mair_fts, rank

119 rows

external_party_castles_mair_fts_config (hidden)

k, v

1 row

external_party_castles_mair_fts_data (hidden)

id, block

3 rows

external_party_castles_mair_fts_docsize (hidden)

id, sz

119 rows

external_party_castles_mair_fts_idx (hidden)

segid, term, pgno

1 row

external_party_chess_fts (hidden)

name, name_english, external_party_chess_fts, rank

324 rows

external_party_chess_fts_config (hidden)

k, v

1 row

external_party_chess_fts_data (hidden)

id, block

6 rows

external_party_chess_fts_docsize (hidden)

id, sz

324 rows

external_party_chess_fts_idx (hidden)

segid, term, pgno

4 rows

external_party_cmp_fts (hidden)

name, name_english, comment, external_party_cmp_fts, rank

755 rows

external_party_cmp_fts_config (hidden)

k, v

1 row

external_party_cmp_fts_data (hidden)

id, block

13 rows

external_party_cmp_fts_docsize (hidden)

id, sz

755 rows

external_party_cmp_fts_idx (hidden)

segid, term, pgno

11 rows

external_party_ees_fts (hidden)

name, name_english, external_party_ees_fts, rank

211 rows

external_party_ees_fts_config (hidden)

k, v

1 row

external_party_ees_fts_data (hidden)

id, block

5 rows

external_party_ees_fts_docsize (hidden)

id, sz

211 rows

external_party_ees_fts_idx (hidden)

segid, term, pgno

3 rows

external_party_euprofiler_fts (hidden)

name, external_party_euprofiler_fts, rank

274 rows

external_party_euprofiler_fts_config (hidden)

k, v

1 row

external_party_euprofiler_fts_data (hidden)

id, block

4 rows

external_party_euprofiler_fts_docsize (hidden)

id, sz

274 rows

external_party_euprofiler_fts_idx (hidden)

segid, term, pgno

2 rows

external_party_huber_inglehart_fts (hidden)

name, name_english, external_party_huber_inglehart_fts, rank

300 rows

external_party_huber_inglehart_fts_config (hidden)

k, v

1 row

external_party_huber_inglehart_fts_data (hidden)

id, block

5 rows

external_party_huber_inglehart_fts_docsize (hidden)

id, sz

300 rows

external_party_huber_inglehart_fts_idx (hidden)

segid, term, pgno

3 rows

external_party_ray_fts (hidden)

ename, name, external_party_ray_fts, rank

191 rows

external_party_ray_fts_config (hidden)

k, v

1 row

external_party_ray_fts_data (hidden)

id, block

4 rows

external_party_ray_fts_docsize (hidden)

id, sz

191 rows

external_party_ray_fts_idx (hidden)

segid, term, pgno

2 rows

info_data_source_fts (hidden)

key, short, full, info_data_source_fts, rank

289 rows

info_data_source_fts_config (hidden)

k, v

1 row

info_data_source_fts_data (hidden)

id, block

9 rows

info_data_source_fts_docsize (hidden)

id, sz

289 rows

info_data_source_fts_idx (hidden)

segid, term, pgno

7 rows

party_change_fts (hidden)

description, comment, party_change_fts, rank

918 rows

party_change_fts_config (hidden)

k, v

1 row

party_change_fts_data (hidden)

id, block

4 rows

party_change_fts_docsize (hidden)

id, sz

918 rows

party_change_fts_idx (hidden)

segid, term, pgno

2 rows

party_fts (hidden)

name_short, name_english, name, name_nonlatin, description, comment, party_fts, rank

1,699 rows

party_fts_config (hidden)

k, v

1 row

party_fts_data (hidden)

id, block

40 rows

party_fts_docsize (hidden)

id, sz

1,699 rows

party_fts_idx (hidden)

segid, term, pgno

37 rows

politician_president_fts (hidden)

person_id_source, description, comment, politician_president_fts, rank

343 rows

politician_president_fts_config (hidden)

k, v

1 row

politician_president_fts_data (hidden)

id, block

4 rows

politician_president_fts_docsize (hidden)

id, sz

343 rows

politician_president_fts_idx (hidden)

segid, term, pgno

2 rows

sqlite_stat1 (hidden)

tbl, idx, stat

24 rows

Views

  • view_party
  • view_election
  • view_cabinet
  • view_variable

Download SQLite DB: parlgov.db 7.1 MB

Powered by Datasette · Queries took 189.929ms · Data source: ParlGov · About: simonw/parlgov-datasette