UK Politician data
Version: 0.14.0. This is not the latest version of this document. 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
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
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)
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
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)
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
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 | |
| additional_names | string | Additional names of the person | No | |
| additional__name | string | Additional name of the person | No |
Table: Person identifiers
Description:
Map between our person IDs and other schemes
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)
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
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)
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 | |
| 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
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.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