parlgov

Table actions

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

Custom SQL query

cabinet

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

1,560 rows

cabinet_party

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

3,835 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...

994 rows

election_result

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

9,299 rows

external_commissioner_doering

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

308 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

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

1,651 rows

party_change

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

881 rows

party_family

id, party_id, type_id

781 rows

party_name_change

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

684 rows

politician_president

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

333 rows

sqlite_stat1

tbl, idx, stat

24 rows

viewcalc_country_year_share

id_type, year, id, share

8,687 rows

viewcalc_election_parameter

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

994 rows

viewcalc_parliament_composition

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

20,107 rows

viewcalc_party_position

party_id, left_right, state_market, liberty_authority, eu_anti_pro, calculation_date

1,651 rows

cabinet_fts (hidden)

name, description, comment, cabinet_fts, rank

1,560 rows

cabinet_fts_config (hidden)

k, v

1 row

cabinet_fts_data (hidden)

id, block

32 rows

cabinet_fts_docsize (hidden)

id, sz

1,560 rows

cabinet_fts_idx (hidden)

segid, term, pgno

30 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

994 rows

election_fts_config (hidden)

k, v

1 row

election_fts_data (hidden)

id, block

5 rows

election_fts_docsize (hidden)

id, sz

994 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

276 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

276 rows

info_data_source_fts_idx (hidden)

segid, term, pgno

7 rows

party_change_fts (hidden)

description, comment, party_change_fts, rank

881 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

881 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,651 rows

party_fts_config (hidden)

k, v

1 row

party_fts_data (hidden)

id, block

37 rows

party_fts_docsize (hidden)

id, sz

1,651 rows

party_fts_idx (hidden)

segid, term, pgno

34 rows

politician_president_fts (hidden)

person_id_source, description, comment, politician_president_fts, rank

333 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

333 rows

politician_president_fts_idx (hidden)

segid, term, pgno

2 rows

Views

Download SQLite DB: parlgov.db 6.9 MB