UK Politician data

Version: 0.16.0. This is the latest version. See all versions.

Description

TheyWorkForYou politician data as spreadsheets

Contributors

Licences

Download options

Individual tables

Table: Membership Counts

Description:

Dataset of membership counts by chamber and date

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
start_date string Start date of the membership count No
end_date string End date of the membership count No
members_count integer Number of members in the chamber at this time (negative numbers reflect errors in older data) No
chamber string The chamber the membership count is for No commons, lords, ni, scotland, wales

Table: Alternative membership identifiers

Description:

Map between our membership IDs and other schemes

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
membership_id string The ID of the membership (unique combination of person, post, and time) No
identifier string The identifier of the person in the other scheme No
scheme string Alternate ID scheme No datadotparl_id, historichansard_id, peeragetype, pims_id, wikidata

Table: Memberships

Description:

Table of memberships (a membership is connection between a person, post and time)

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id string The ID of the membership (unique combination of person, post, and time) Yes
person_id string The ID of the person No
organization_id string The ID of the organization this person is a member of (party) No
on_behalf_of_id string The ID of the organization this person is a member of (party) No
end_date string Date this membership ends No
end_reason string Reason for end of membership No
post_id string The ID of the post (e.g. a seat) No
start_date string Date this membership starts No
start_reason string Reason for start of membership No
label string The label of the membership No
role string The role of the person in the organization No
redirect string If one ID remaps to another No
reason string Additional notes (hardly used) No

Table: Organization identifiers

Description:

Map between our organization IDs and other schemes

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
organization_id string Our ID of the organization (party) Yes blaenau-gwent-peoples-voice, brexit-alliance, conservative, independent, john-marek-independent-party, labour, liberal-democrat, non-attached, plaid-cymru, ukip
identifier string The identifier of the organization in the other scheme Yes Q10647, Q10691, Q2415493, Q327591, Q4923798, Q61586635, Q6246716, Q9624, Q9626, Q9630
scheme string Alternate ID scheme No wikidata

Table: Organizations

Description:

List of organizations (parties)

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
classification string The type of organization No
id string The ID of the organization (party) Yes
name string The name of the organization (party) Yes

Table: Person names

Description:

Multiple names for people

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
person_id string The ID of the person No
family_name string The family name of the person No
given_name string The given name of the person No
note string A note about the name No Alternate, Main
end_date string The end date of the name No
honorific_prefix string The honorific prefix of the person No
start_date string The start date of the name No
additional_name string An additional name of the person No
county string The county of the person No
lordname string The lord name of the person No
lordofname string The lord of name of the person No
name string The name of the person No
lordofname_full string The full lord of name of the person No
surname string The surname of the person No
organization_id string The ID of the organization (house) No
honorific_suffix string The honorific suffix of the person No

Table: Person identifiers

Description:

Map between our person IDs and other schemes

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
person_id string Our ID of the person No
identifier string The identifier of the person in the other scheme No
scheme string Alternate ID scheme No data.niassembly.gov.uk, datadotparl_id, historichansard_person_id, historichansard_url, pims_id, senedd, wikidata, yournextmp

Table: Persons table

Description:

List of people (many specific details are in the memberships table)

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id string The ID of the person Yes
redirect string The ID of the person that this person redirects to No
current_constituency string The current constituency of the person No
current_party string The current party of the person No

Table: Post Identifiers

Description:

Map between our IDs for posts and alternative schemes

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
post_id string The ID of the post Yes
identifier string The identifier of the post in the other scheme Yes
scheme string Alternate ID scheme No gss, historichansard_id, wikidata

Table: Posts

Description:

List of posts (generally constituencies, lists)

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
end_date string Date this post ends No
id string The ID of the post Yes
label string The label of the post No
organization_id string The ID of the organization (party) No house-of-commons, london-assembly, northern-ireland-assembly, scottish-parliament, welsh-parliament
role string The role of the person in the post No MLA, MS, MSP, Member of Parliament, london-assembly-member
start_date string Date this post starts No
area_name string The name of the area the post represents No

Table: Simple memberships

Description:

Reduced version of multiple tables to bring together very common columns

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
membership_id string Unique identifier for the membership Yes
person_id string Unique identifier for the person No
constituency string Name of the constituency No
start_date string Start date of the membership No
end_date string End date of the membership No
start_reason string Reason for the start of the membership No
end_reason string Reason for the end of the membership No
party string Name of the party No
chamber string Name of the chamber No
label string Label of the membership No
role string Role of the membership No
first_name string First name of the person No
last_name string Last name of the person No
nice_name string A single string for the full name of a person. No

Change log

0.16.0

Change in data for resource(s): person_identifiers

0.15.0

Change in data for resource(s): membership_counts

0.14.0

Change in data for resource(s): membership_counts,membership_identifiers,memberships,person_alternative_names,person_identifiers,persons,post_identifiers,posts,simple_memberships

0.13.0

Change in data for resource(s): membership_counts,memberships,simple_memberships

0.12.0

Change in data for resource(s): membership_counts

0.11.0

Change in data for resource(s): membership_counts,memberships,person_alternative_names,person_identifiers,persons,simple_memberships

0.10.0

Change in data for resource(s): membership_counts,memberships,person_alternative_names,persons,simple_memberships

0.9.0

Change in data for resource(s): membership_counts,memberships,simple_memberships

0.8.0

Change in data for resource(s): membership_counts,membership_identifiers,memberships,person_alternative_names,person_identifiers,persons,simple_memberships

0.7.1

Minor change in data for resource(s): simple_memberships

0.7.0

Change in data for resource(s): membership_counts,membership_identifiers,memberships,organizations,person_alternative_names,person_identifiers,persons,simple_memberships

0.6.0

New field(s) added to end of resource: first_name,last_name,nice_name

0.5.0

Change in data for resource(s): membership_counts,membership_identifiers,memberships,person_alternative_names,person_identifiers,persons,simple_memberships

0.4.1

Minor change in data for resource(s): membership_counts

0.4.0

New resource(s) added: membership_counts

0.3.0

New resource(s) added: simple_memberships

0.2.0

Change in data for resource(s): membership_identifiers,memberships,organization_identifiers,organizations,person_alternative_names,person_identifiers,persons,post_identifiers,posts

0.1.0