psephology

Data license: Open Parliament Licence · Data source: UK Parliament election results website

Custom SQL query

Tables

boundary_set_general_election_party_performances

id, constituency_contested_count, constituency_won_count, cumulative_vote_count, general_election_id, political_party_id, boundary_set_id

Many rows

boundary_set_legislation_items

id, boundary_set_id, legislation_item_id

83 rows

boundary_sets

id, start_on, end_on, country_id

34 rows

candidacies

id, candidate_given_name, candidate_family_name, candidate_is_sitting_mp, candidate_is_former_mp, is_standing_as_commons_speaker, is_standing_as_independent, is_notional, result_position, is_winning_candidacy, vote_count, vote_share, vote_change, candidate_gender_id, election_id, member_id, democracy_club_person_identifier

22,789 rows

certifications

id, candidacy_id, political_party_id, adjunct_to_certification_id

21,365 rows

commons_library_dashboard_countries

id, commons_library_dashboard_id, country_id

Many rows

commons_library_dashboards

id, title, url

4 rows

constituency_area_overlaps

id, from_constituency_residential, to_constituency_residential, from_constituency_geographical, to_constituency_geographical, from_constituency_population, to_constituency_population, from_constituency_area_id, to_constituency_area_id, formed_from_whole_of, forms_whole_of

1,438 rows

constituency_area_types

id, area_type

3 rows

constituency_areas

id, name, geographic_code, english_region_id, country_id, constituency_area_type_id, boundary_set_id

1,300 rows

constituency_group_set_legislation_items

id, constituency_group_set_id, legislation_item_id

Many rows

constituency_group_sets

id, start_on, end_on, country_id

8 rows

constituency_groups

id, name, constituency_area_id, constituency_group_set_id

1,300 rows

countries

id, name, geographic_code, ons_linked, parent_country_id

6 rows

country_general_election_party_performances

id, constituency_contested_count, constituency_won_count, cumulative_vote_count, general_election_id, political_party_id, country_id

1,229 rows

elections

id, polling_on, is_notional, valid_vote_count, invalid_vote_count, majority, declaration_at, constituency_group_id, general_election_id, result_summary_id, electorate_id, parliament_period_id

3,900 rows

electorates

id, population_count, constituency_group_id

3,899 rows

enablings

id, enabling_legislation_id, enabled_legislation_id

73 rows

english_region_general_election_party_performances

id, constituency_contested_count, constituency_won_count, cumulative_vote_count, general_election_id, political_party_id, english_region_id

1,115 rows

english_regions

id, name, geographic_code, country_id

9 rows

genders

id, gender

3 rows

general_election_in_boundary_sets

id, ordinality, general_election_id, boundary_set_id

20 rows

general_election_party_performances

id, constituency_contested_count, constituency_won_count, cumulative_vote_count, cumulative_valid_vote_count, general_election_id, political_party_id

1,819 rows

general_elections

id, polling_on, is_notional, commons_library_briefing_url, valid_vote_count, invalid_vote_count, electorate_population_count, parliament_period_id

6 rows

legislation_items

id, title, uri, url_key, made_on, royal_assent_on, statute_book_on, legislation_type_id

79 rows

legislation_types

id, label, abbreviation

2 rows

members

id, given_name, family_name, mnis_id

1,543 rows

parliament_periods

id, number, summoned_on, state_opening_on, dissolved_on, wikidata_id, london_gazette, commons_library_briefing_by_election_briefing_url

59 rows

political_parties

id, name, abbreviation, mnis_id, has_been_parliamentary_party, disclaimer

303 rows

political_party_registrations

id, electoral_commission_id, start_on, end_on, political_party_name_last_updated_on, political_party_id, country_id

349 rows

result_summaries

id, short_summary, summary, is_from_commons_speaker, is_from_independent, is_to_commons_speaker, is_to_independent, from_political_party_id, to_political_party_id

56 rows