UK House of Commons Register of Members' Financial Interests

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

Description

Reformat of the new bulk data release of the UK House of Commons Register of Members’ Financial Interests.

TheyWorkForYou IDs and party added.

Experimental release. Expect to change columns and add more transformations.

Contributors

Licences

Download options

Individual tables

Table: Overall Register of Interests

Description:

Register of interests, text summaries by category,

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
member string Name of the MP No
party string TWFY id of the party No
mnis_id integer Parliamentary ID for the MP No
twfy_id string TWFY ID for the MP No
category string Category of the interest No Donations and other support (including loans) for activities as an MP, Employment and earnings, Employment and earnings - Ad hoc payments, Employment and earnings - Ongoing paid employment, Family members employed, Family members engaged in third-party lobbying, Gifts and benefits from sources outside the UK, Gifts, benefits and hospitality from UK sources, Land and property (within or outside the UK), Miscellaneous, Shareholdings, Visits outside the UK
category_code string Code for the category of the interest No 1, 1.1, 1.2, 10, 2, 3, 4, 5, 6, 7, 8, 9
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
summary string Text summary of the interest No

Table: Category 1

Description:

Employment and earnings

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Employment and earnings
party string Political party of the MP No conservative, dup, green, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, sinn-fein
member string Name of the MP No
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
job_title string Description of the job role No
start_date string Start date of the role No
end_date string End date of the role No
is_until_further_notice boolean Whether the role is until further notice No false, true
payer_name string Name of the payer No
payer_is_private_individual boolean Whether the payer is a private individual No false, true
is_paid_as_director_of_payer boolean Whether the payment is made as a director of the payer No false, true
payer_nature_of_business string Nature of the payer's business No
payer_public_address string Public address of the payer No
has_sought_acoba_advice string Whether the MP has sought advice from the Advisory Committee on Business Appointments No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category of the interest No 1

Table: Category 1.1

Description:

Employment and earnings - Ad hoc payments

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id integer Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Employment and earnings - Ad hoc payments
party string TWFY ID for the party as of this release date No conservative, green, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party
member string Name of the MP No
mnis_id integer Parliament's unique identifier for the member No
twfy_id string TheyWorkForYou ID for the member No
payment_received boolean Whether there was a payment received No false, true
received_date string Date the payment was received No
job_title string Job the MP was paid for No
payment_type string Type of payment No In kind, Monetary
payment_description string Description of the payment No
value number Value of the payment (£) No
hours_worked number Hours worked for the payment No
hours_details string Details of the hours worked No
is_ultimate_payer_different boolean Whether the ultimate payer is different No false, true
ultimate_payer_name string Name of the ultimate payer No
ultimate_payer_protected_by_confidentiality boolean Whether the ultimate payer is protected by confidentiality No false, true
ultimate_payer_address string Address of the ultimate payer No
ultimate_payer_nature_of_business string Nature of business of the ultimate payer No
is_payment_donated boolean Whether the payment was donated No false, true
donatee_paid_by string Who the payment was donated to No
donatee_type string Type of the donatee No
donatee_details string Details of the donatee No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category of the interest No 1.1

Table: Category 1.2

Description:

Employment and earnings - Ongoing paid employment

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id integer Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Employment and earnings - Ongoing paid employment
party string TWFY ID for the party as of this release date No conservative, dup, independent, labour, labourco-operative, liberal-democrat, reform, scottish-national-party, sinn-fein
member string Name of the MP No
mnis_id integer Parliament ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
regularity_of_payment string Regularity of the payment No Monthly, Quarterly, Yearly
start_date string Start date of the payment No
end_date string End date of the payment No
period_for_hours_worked string Period for hours worked No Monthly, Quarterly, Weekly, Yearly
job_title string Job title No
payment_type string Type of payment No In kind, Monetary
payment_description string Description of the payment No
value number Value of the payment (£) No
hours_worked number Hours worked for the payment No
hours_details string Details of the hours worked No
is_ultimate_payer_different boolean Whether the ultimate payer is different No false, true
ultimate_payer_name string Name of the ultimate payer No
ultimate_payer_protected_by_confidentiality boolean Whether the ultimate payer is protected by confidentiality No false
ultimate_payer_address string Address of the ultimate payer No
ultimate_payer_nature_of_business string Nature of business of the ultimate payer No
is_payment_donated boolean Whether the payment was donated No false, true
donatee_paid_by string Who the payment was donated to No
donatee_type string Type of donatee No
donatee_details string Details of the donatee No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category of the interest No 1.2

Table: Category 2

Description:

Donations and other support (including loans) for activities as an MP

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Donations and other support (including loans) for activities as an MP
party string Political party of the MP No conservative, green, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, speaker, uup
member string Name of the MP No
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
donation_source string Source of the donation No (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation, (b) Any other support not included in Category 2(a)
payment_type string Type of payment No Cash, InKind
payment_description string Description of the payment No
value number Value of the donation No
received_date string Date the payment was received No
accepted_date string Date the payment was accepted No
received_end_date string End date of the payment No
is_sole_beneficiary boolean Whether the MP is the sole beneficiary No false, true
donor_name string Name of the donor No
donor_public_address string Public address of the donor No
donor_status string Status of the donor No Company, Individual, Limited Liability Partnership, Other, Registered Party, Trade Union, Trust, Unincorporated association
donor_company_name string Name of the donor company No
donor_company_url number URL of the donor company No
donor_company_identifier string Identifier of the donor company No
donor_company_identifier_source string Source of the donor company identifier No
donor_trust_details string Details of the donor trust No
donor_other_details string Details of the donor No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category of the interest No 2

Table: Category 3

Description:

Gifts, benefits and hospitality from UK sources

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Gifts, benefits and hospitality from UK sources
party string Political party of the MP No conservative, green, independent, labour, labourco-operative, liberal-democrat, reform, scottish-national-party
member string Name of the MP No
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
appg number Payment made via an All-Party Parliamentary Group No
payment_type string Type of payment No Cash, InKind
payment_description string Description of the payment No
value number Value of the payment No
received_date string Date the payment was received No
accepted_date string Date the payment was accepted No
received_end_date string End date of the payment No
is_sole_beneficiary boolean Whether the MP is the sole beneficiary No false, true
donor_name string Name of the donor No
donor_public_address string Public address of the donor No
donor_status string Type of donor No Company, Friendly society, Individual, Limited Liability Partnership, Other, Trade Union, Unincorporated association
donor_company_name string Name of the donor company No
donor_company_url number URL of the donor company No
donor_company_identifier string Company id of the donor No
donor_company_identifier_source string Identifer category of company number No
donor_trust_details number Trust details of the donor No
donor_other_details string Other details of the donor No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category of the interest No 3

Table: Category 4

Description:

Visits outside the UK

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Visits outside the UK
party string TWFY Party ID No conservative, dup, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, sinn-fein, social-democratic-and-labour-party
member string Name of the MP No
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
visit_locations number Number of locations visited No
visit_locations_1__country string First country visited No
visit_locations_1__destination string First destination visited No
purpose string Purpose of the visit No
start_date string Start date of the visit No
end_date string End date of the visit No
appg string Visit associated with an All-Party Parliamentary Group No
donors number Number of donors No
donors_1__name string Name of the donor No
donors_1__is_private_individual boolean Whether the donor is a private individual No false, true
donors_1__public_address string Public address of the donor No
donors_1__payment_type string Type of payment No In kind, Monetary
donors_1__payment_description string Description of the payment No
donors_1__value number Value of the payment No
donors_1__is_sole_beneficiary boolean Whether the MP is the sole beneficiary No false, true
visit_locations_2__country string Second country visited No
visit_locations_2__destination string Second destination visited No
visit_locations_3__country string Third country visited No
visit_locations_3__destination string Third destination visited No
donors_2__name string Name of the donor No
donors_2__is_private_individual string Whether the donor is a private individual No
donors_2__public_address string Public address of the donor No
donors_2__payment_type string Type of payment No
donors_2__payment_description string Description of the payment No
donors_2__value number Value of the payment No
donors_2__is_sole_beneficiary string Whether the MP is the sole beneficiary No
donors_3__name string Name of the donor No
donors_3__is_private_individual string Whether the donor is a private individual No
donors_3__public_address string Public address of the donor No
donors_3__payment_type string Type of payment No
donors_3__payment_description string Description of the payment No
donors_3__value number Value of the payment No
donors_3__is_sole_beneficiary string Whether the MP is the sole beneficiary No
donors_4__name string Name of the donor No
donors_4__is_private_individual string Whether the donor is a private individual No
donors_4__public_address string Public address of the donor No
donors_4__payment_type string Type of payment No
donors_4__payment_description string Description of the payment No
donors_4__value number Value of the payment No
donors_4__is_sole_beneficiary string Whether the MP is the sole beneficiary No
donors_5__name string Name of the donor No
donors_5__is_private_individual string Whether the donor is a private individual No
donors_5__public_address string Public address of the donor No
donors_5__payment_type string Type of payment No
donors_5__payment_description string Description of the payment No
donors_5__value number Value of the payment No
donors_5__is_sole_beneficiary string Whether the MP is the sole beneficiary No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category No 4

Table: Category 5

Description:

Gifts and benefits from sources outside the UK

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes 591, 596, 3238, 3242, 4566, 9052, 10723, 10782
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No Association of Marshall Scholars - £465.00, Ayita LLC - £836.00, HM Government of Gibraltar - £1,275.00, Mr Ronald Chagoury - £1,440.00, Stripe Press Inc - £414.00, The Lord (Philip) Harris of Peckham - £5,000.00, Viagogo - £838.80
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Gifts and benefits from sources outside the UK
party string Political party of the MP No conservative, labour, labourco-operative
member string Name of the MP Yes Alison Griffiths, Angela Rayner, Dame Harriett Baldwin, Helen Grant, Mr Richard Holden, Neil O'Brien, Stephen Doughty, Stephen Morgan
mnis_id integer Parliamentary ID of the MP Yes 4018, 4107, 4264, 4356, 4653, 4679, 4813, 5203
twfy_id string TheyWorkForYou ID of the MP Yes 24785, 24796, 25166, 25429, 25658, 25679, 25893, 26536
appg number Linked to an All-Party Parliamentary Group No
payment_type string Type of payment No Cash, InKind
payment_description string Description of the payment Yes Accommodation at the Peninsula Hotel, 19 Av. Kléber, 75116 Paris, France - value €1700 Euro - equivalent to GBP @1.18 = £1440. I was accompanied by my husband., Associated with participating in a cross-party conference, accommodation (£315) and hospitality (£150), Associated with taking part in the US-UK legislative exchange in Oxford, hospitality and accommodation, Four nights' accommodation during the Labour Party Conference, Hospitality - visit to DJ booth, Hï Ibiza, Meals and accommodation at small group retreat in Guildford, One ticket with hospitality for England v New Zealand one day cricket match, for general election campaign expenditure
value number Value of the payment (£) No 414.0, 465.0, 836.0, 838.8, 1275.0, 1440.0, 5000.0
received_date string Date the payment was received No 2023-09-15, 2023-10-08, 2024-01-13, 2024-03-04, 2024-06-11, 2024-08-28, 2024-09-02
accepted_date string Date the payment was accepted No 2023-09-15, 2023-10-08, 2024-01-13, 2024-03-04, 2024-06-11, 2024-08-28, 2024-09-02
received_end_date string End date of the payment No , 2023-10-11, 2024-01-14, 2024-03-06, 2024-09-03
is_sole_beneficiary boolean Whether the MP is the sole beneficiary No false, true
donor_name string Name of the donor No Association of Marshall Scholars, Ayita LLC, HM Government of Gibraltar, Mr Ronald Chagoury, Stripe Press Inc, The Lord (Philip) Harris of Peckham, Viagogo
donor_public_address string Public address of the donor No
donor_status string Type of donor No Company, Friendly society, Individual, Other, Unincorporated association
donor_company_name string Name of the donor company No
donor_company_url number URL of the donor company No
donor_company_identifier string Identifier of the donor company No
donor_company_identifier_source string Donor company identifier register No
donor_trust_details number Details of the donor trust No
donor_other_details string Other details of the donor No
api_link string Link to the API endpoint for the interest Yes https://interests-api.parliament.uk/api/v1/Interests/10723, https://interests-api.parliament.uk/api/v1/Interests/10782, https://interests-api.parliament.uk/api/v1/Interests/3238, https://interests-api.parliament.uk/api/v1/Interests/3242, https://interests-api.parliament.uk/api/v1/Interests/4566, https://interests-api.parliament.uk/api/v1/Interests/591, https://interests-api.parliament.uk/api/v1/Interests/596, https://interests-api.parliament.uk/api/v1/Interests/9052
category_code string Code for the category of the interest No 5

Table: Category 6

Description:

Land and property (within or outside the UK)

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Land and property (within or outside the UK)
party string TWFY party id of the MP No conservative, dup, green, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, sinn-fein, traditional-unionist-voice
member string Name of the MP No
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MPss No
start_date string Date the interest started No
end_date string Date the interest ended No , 2023-09-22, 2024-07-18, 2024-07-21, 2024-08-09
is_sole_owner boolean Is the MP the sole owner of the property No false, true
location string Location of the property No
property_description string Description of the property No
property_owner_details string Details of the property owner No
rental_income_details string Details of the rental income No
rental_income_start_date string Date the rental income started No
rental_income_end_date string Date the rental income ended No , 2024-07-17, 2024-07-31
number_of_properties number Number of properties owned No
is_land boolean Is the property land No false, true
is_any_rental_income_paid_to_another_person boolean Is any rental income paid to another person No false, true
country string Country of the property No France, Germany, India, Ireland, Italy, Portugal, Spain, United Kingdom, United States
land_use string Use of the land No
property_type string Type of property No
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category of the interest No 6

Table: Category 7

Description:

Shareholdings

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest Yes
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Shareholdings
party string TWFY party of the MP No conservative, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, sinn-fein
member string Name of the MP No
mnis_id integer Unique identifier for the MP No
twfy_id string TWFY identifier for the MP No
shareholding_threshold string Shareholding threshold No (i) Shareholdings: over 15% of issued share capital, (ii) Other shareholdings, valued at more than £70,000
registrable_date string Date the interest was registered No
end_date string Date the interest ended No , 2004-07-05, 2023-05-09, 2023-08-10, 2023-08-11, 2023-08-29, 2023-11-17, 2024-07-18, 2024-07-25, 2024-07-29
organisation_name string Name of the organisation Yes
organisation_description string Description of the organisation No
held_on_behalf_of string Organisation held on behalf of No
managed_by string Organisation managed by No
api_link string Link to the API endpoint for the interest Yes
category_code string Category code No 7

Table: Category 8

Description:

Miscellaneous

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest No
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Miscellaneous
party string Political party of the MP No conservative, dup, green, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, sinn-fein, social-democratic-and-labour-party, traditional-unionist-voice, uup
member string Name of the MP No
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
arose_on string Date the interest arose No
end_date string Date the interest ended No
donor_name string Name of the donor No
description string Description of the interest No
miscellaneous_interest_type string Type of miscellaneous interest No Financial interest or material benefit, Formal role with a party organisation, Fund to defray legal costs, Other, Unpaid role
api_link string Link to the API endpoint for the interest Yes
category_code string Category code of the interest No 8

Table: Category 9

Description:

Family members employed

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest Yes
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Family members employed
party string TWFY party_id No conservative, dup, labour, labourco-operative, scottish-national-party
member string Name of the MP Yes
mnis_id integer Unique identifier for the MP Yes
twfy_id string TheyWorkForYou ID of the MP Yes
job_title string Job title of the family member No Administrative Manager, Diary Secretary, Executive Office Manager, Executive Officer, Junior Secretary, Office Manager, Parliamentary Assistant, Principal Secretary, Secretary, Senior Caseworker, Senior Communications Officer, Senior Parliamentary Assistant, Senior Researcher, Senior Secretary
working_pattern string Working pattern of the family member No Full time, Part time
person_name string Name of the family member Yes
end_date string Date the interest ended No
family_member_relationship_level string Level of relationship to the MP No Related to member directly, Related to spouse
family_relation_type string Type of family relation No Brother, Daughter, Father, Partner, Sister, Son, Spouse
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category No 9

Table: Category 10

Description:

Family members engaged in third-party lobbying

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
id integer Unique identifier for the interest Yes
parent_interest_id number Unique identifier for the parent interest No
summary string Text summary of the interest Yes
registration_date string Date the interest was registered No
published_date string Date the interest was published No
updated_date string Date the interest was last updated No
category string Category of the interest No Family members engaged in third-party lobbying
party string TWFY party id of the MP No conservative, labour, liberal-democrat
member string Name of the MP Yes
mnis_id integer Unique identifier for the MP Yes
twfy_id string TWFY identifier for the MP Yes
job_title string Job title of the family member No Account Executive, Associate Director, Director, Director and Head of Public Affairs, Director, Community Conversations Ltd., Executive Chairman, Freelance, Freelance public relations consultant, Owner and director, Self-employed political consultant, Senior Consultant, Sole trader, providing policy and public affairs advice to clients, Specialist Partner, Flint Global and Next Chapter Strategy
employer string Name of the employer No BB Partners, Cavendish, Cavendish Consulting, Community Conversations Ltd., Earthcott Limited, Endeavour Advisory Ltd, which provides communications and public affairs advice, Flint Global (which advises international businesses and investors on policy, politics, regulation, and competition issues in European markets), Hanover Communications, Kanda Consultancy, Lodestone Communications; a public relations company, SEC Newgate UK, Self Employed, TB Cardew
person_name string Name of the family member Yes
end_date string Date the interest ended No
family_member_relationship_level string Level of relationship with the family member No Related to member directly, Related to partner, Related to spouse
family_relation_type string Type of family relation No Brother, Daughter, Father, Partner, Son, Spouse
api_link string Link to the API endpoint for the interest Yes
category_code string Code for the category No 10

Change log

0.1.0

Minor change in data for resource(s): overall,category_1,category_2