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
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
summary string Text summary of the interest No
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Registered date No
published string Published date No
updated_1 string Updated date No
category string Category of the interest No Employment and earnings
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
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
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 False, True
link string Link to the interest in the Parliament API Yes
updated_2 string Date the interest was updated No 2015-10-02, 2017-07-06, 2022-04-25, 2023-04-14, 2023-06-30, 2023-10-19, 2024-01-03, 2024-04-12, 2024-07-30, 2024-10-15, 2025-03-07, 2025-07-14, 2025-09-15
updated_3 string Date the interest was updated No 2020-03-13, 2024-08-02
updated_4 string Date the interest was updated No 2021-11-16
updated_5 string Date the interest was updated No 2022-06-21
updated_6 string Date the interest was updated No 2022-10-07
updated_7 string Date the interest was updated No 2023-10-26
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
summary string Text summary of the interest No
parent_interest_id integer Unique identifier for the parent interest No
registered string registered date No
published string published date No
updated_1 string updated date No 2024-09-25, 2024-09-30, 2024-10-03, 2024-12-05, 2024-12-18, 2025-05-22
category string Category of the interest No Employment and earnings - Ad hoc payments
mnis_id integer Parliament's unique identifier for the member No
twfy_id string TheyWorkForYou ID for the member No
party string TWFY ID for the party as of this release date No conservative, green, independent, labour, labourco-operative, liberal-democrat, reform, scottish-national-party
member string Name of the MP 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 Donated by the Member to the recipient, Paid direct to the recipient by the payer
donatee_type string Type of the donatee No Charity, Community organisation, Other
donatee_details string Details of the donatee No All Party Parliamentary Group secretariat Beyond Pills, Elizabeth Garrett Anderson School
link string Link to 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
summary string Text summary of the interest No
parent_interest_id integer Unique identifier for the parent interest No
registered string Registered date No
published string Published date No
updated_1 string Updated date No
category string Category of the interest No Employment and earnings - Ongoing paid employment
mnis_id integer Parliament ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
party string TWFY ID for the party as of this release date No conservative, dup, independent, labour, liberal-democrat, reform, scottish-national-party, sinn-fein
member string Name 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 Councillor, Special Responsibility Allowance - Sutton Local Committee Chair, This post is solely focused on the School of International Relations., advice and scrutiny
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
ultimate_payer_name number Name of the ultimate payer No NaN
ultimate_payer_protected_by_confidentiality boolean Whether the ultimate payer is protected by confidentiality No false
ultimate_payer_address number Address of the ultimate payer No NaN
ultimate_payer_nature_of_business number Nature of business of the ultimate payer No NaN
is_payment_donated boolean Whether the payment was donated No false, true
donatee_paid_by string Who the payment was donated to No Donated by the Member to the recipient, Paid direct to the recipient by the payer
donatee_type string Type of donatee No Charity, Community organisation, Local party organisation, Other
donatee_details string Details of the donatee No Kemyel Ltd
link string URL to the interest on the interests API Yes
updated_2 string Date the interest was updated No
updated_3 string Date the interest was updated No 2020-11-11, 2024-10-14, 2025-03-07
updated_4 string Date the interest was updated No 2022-11-22
updated_5 string Date the interest was updated No 2025-01-03
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
summary string Text summary of the interest No
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Registered date No
published string Published date No
updated_1 string Updated date No
category string Category of the interest No Donations and other support (including loans) for activities as an MP
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
party string Political party of the MP No conservative, green, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, traditional-unionist-voice
member string Name 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 In kind, Monetary
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, Unincorporated association
donor_company_name string Name of the donor company No
donor_company_url number URL of the donor company No NaN
donor_company_identifier string Identifier of the donor company No
donor_company_identifier_source string Source of the donor company identifier No Companies House
donor_trust_details number Details of the donor trust No NaN
donor_other_details string Details of the donor No Charity, Labour Council Group, Mutual society, University, charity, registration 1169558
link string Link to the interest in the Parliament API Yes
updated_2 string Date the second interest was updated No 2024-08-01, 2024-10-18, 2024-12-02, 2025-08-28, 2025-09-04
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
summary string Text summary of the interest No
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Date the interest was registered No
published string Date the interest was published No
updated_1 string Date the interest was updated No
category string Category of the interest No Gifts, benefits and hospitality from UK sources
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
party string Political party of the MP No conservative, dup, green, independent, labour, labourco-operative, liberal-democrat, reform, scottish-national-party, sinn-fein, social-democratic-and-labour-party, traditional-unionist-voice
member string Name of the MP No
appg string Payment made via an All-Party Parliamentary Group 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
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, 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 NaN
donor_company_identifier string Company id of the donor No
donor_company_identifier_source string Identifer category of company number No Companies House
donor_trust_details number Trust details of the donor No NaN
donor_other_details string Other details of the donor No
link string Link to the interest in the Parliament API Yes
updated_2 string Date the second interest was updated No 2023-01-11, 2024-12-12, 2024-12-18, 2025-07-14
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
summary string Text summary of the interest No
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Registered date No
published string Published date No
updated_1 string Updated date No 2024-10-25, 2025-04-10, 2025-06-25, 2025-08-28
category string Category of the interest No Visits outside the UK
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
party string TWFY Party ID No conservative, dup, independent, labour, labourco-operative, liberal-democrat, reform, scottish-national-party, sinn-fein
member string Name of the MP No
visit_locations__country_1 string Country of the visit No
visit_locations__destination_1 string Destination of the visit 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__name_1 string Name of the donor No
donors__is_private_individual_1 boolean Whether the donor is a private individual No false, true
donors__public_address_1 string Public address of the donor No
donors__payment_type_1 string Type of payment No In kind, Monetary
donors__payment_description_1 string Description of the payment No
donors__value_1 number Value of the payment No
donors__is_sole_beneficiary_1 boolean Whether the MP is the sole beneficiary No false, true
link string Link to the interest Yes
visit_locations__country_2 string Country of the visit No Azerbaijan, Guernsey, Israel, Palestine, Poland, Syria
visit_locations__destination_2 string Destination of the visit No Baku, Hebron, Ramallah, Palestine (Occupied Palestinian Territory) and Israel, Rojava, Warsaw
donors__name_2 string Name of the donor No
donors__is_private_individual_2 string Whether the donor is a private individual No False, True
donors__public_address_2 string Public address of the donor No
donors__payment_type_2 string Type of payment No In kind, Monetary
donors__payment_description_2 string Description of the payment No
donors__value_2 number Value of the payment No
donors__is_sole_beneficiary_2 string Whether the MP is the sole beneficiary No False, True
visit_locations__country_3 string Country of the visit No Georgia, Israel, Moldova, Ukraine
visit_locations__destination_3 string Destination of the visit No Tbilisi airport (transfer)
donors__name_3 string Name of the donor No British Embassy Berne, Kyivstar, UK-India Business Council, Zhytomyr Administration
donors__is_private_individual_3 string Whether the donor is a private individual No False
donors__public_address_3 string Public address of the donor No 03113, m. Kyiv, vul. Dehtiarivska, 53, 25 Mala Berdichivska str., Zhytomyr, Ukraine, 10014, 3 Orchard Pl, London SW1H 0BF, 53 Degtyarivska St, Kiev, Kyiv City, 03113, Ukraine, S.P. Korolova Square, 4/2, Zhytomyr, Zhytomyr Oblast, Ukraine, 10002, Thunstrasse 50, CH - 3005 Bern
donors__payment_type_3 string Type of payment No In kind
donors__payment_description_3 string Description of the payment No Accommodation, meals, Daytrip to Zhytomyr (approx.), Dinner and briefing in Kyiv with delegation,, Formal Dinner and receptions, Hotel (£350), Food (£20), Meal £50.00, Transport and buffet lunch
donors__value_3 number Value of the payment No NaN, 25.0, 50.0, 370.0, 670.28
donors__is_sole_beneficiary_3 string Whether the MP is the sole beneficiary No False, True
donors__name_4 string Name of the donor No Kyivstar, UK Friends of Ukraine, Yes Foundation
donors__is_private_individual_4 string Whether the donor is a private individual No False
donors__public_address_4 string Public address of the donor No 01601, Ukraine, Кyiv, Shovkovychna Street, 42-44, 81 High Street, Cosham, Portsmouth PO6 3BL, 81 High Street, Cosham, Portsmouth, PO6 3BL, Vikentiya Khvoiky St, 15/15
donors__payment_type_4 string Type of payment No In kind
donors__payment_description_4 string Description of the payment No Bus transport in Kyiv and Lviv, Conference £150, Dinner in Kyiv (approx.)
donors__value_4 number Value of the payment No NaN, 25.0, 25.86, 150.0
donors__is_sole_beneficiary_4 string Whether the MP is the sole beneficiary No True
donors__name_5 string Name of the donor No Bulldog Political Consulting, YES Foundation
donors__is_private_individual_5 string Whether the donor is a private individual No False
donors__public_address_5 string Public address of the donor No 19-20 Bourne Court, Southend Road, Woodford Green, Essex IG8 8HD, 81 High Street, Cosham, Portsmouth PO6 3BL
donors__payment_type_5 string Type of payment No In kind
donors__payment_description_5 string Description of the payment No Dinner in Lviv, YES Conference
donors__value_5 number Value of the payment No NaN, 86.2, 92.11
donors__is_sole_beneficiary_5 string Whether the MP is the sole beneficiary No True
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
summary string Text summary of the interest Yes
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Registered date Yes
published string Published date Yes
updated_1 number Updated date No NaN
category string Category of the interest No Gifts and benefits from sources outside the UK
mnis_id integer Parliamentary ID of the MP No 39, 4018, 4107, 4119, 4356, 4441, 4475, 4598, 5141, 5282, 5284, 5294, 5296, 5325
twfy_id string TheyWorkForYou ID of the MP No 10632, 24785, 24796, 24929, 25272, 25323, 25429, 25649, 26395, 26430, 26502, 26518, 26540, 26544
party string Political party of the MP No conservative, labour, labourco-operative, liberal-democrat
member string Name of the MP No Alex Mayer, Amanda Martin, Angela Rayner, Charlie Maynard, Dame Harriett Baldwin, Dan Tomlinson, David Chadwick, Freddie van Mierlo, Helen Grant, Jonathan Reynolds, Mohammad Yasin, Sir John Whittingdale, Sir Oliver Dowden, Suella Braverman
appg string Linked to an All-Party Parliamentary Group No APPG GIBRALTAR
payment_type string Type of payment No In kind
payment_description string Description of the payment No 4 Tickets and Hospitality for SM Town Live, A ticket to the Cash in the UK conference, 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 taking part in the US-UK legislative exchange in Cambridge, hospitality and accommodation, Attendance at conference in the UK, including one night hotel accommodation and food and drink while in attendance., Flights (£558), accommodation for 3 nights (£700), meals (£250), taxi (£200), Free accommodation in a family member’s flat since my election. The estimated rental value is £3,500 per month, Hospitality - visit to DJ booth, Hï Ibiza, I took part in the Duolingo Westminster Language Challenge. Winners were asked to nominate a charity to receive payment direct from Duolingo. I chose Home Start Bedfordshire for the £2500 donation. Registered charity no. 1109262., Photography for alumni magazine; permission granted for other use, Tickets for my husband and I to attend the Trump Victory Rally on 19th January, the President's Inauguration on 20th January and the Liberty Ball on 21st January 2025, Transport was provided for me and up to six other family members during my recent trip to Pakistan, Two tickets to the Qatar Goodwood Festival 2025 and to the Goodwood Regency Ball including hospitality and accommodation for one night, Two tickets to the Real Madrid v Valencia football match on Saturday 5 April 2025. It was not possible to purchase the tickets therefore a donation of 500 euros, a higher value than the tickets, was made to the Real Madrid Foundation
value number Value of the payment (£) Yes
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 Ailsa Roell, Association of Marshall Scholars, Ayita LLC, Azad Government of the State of Jammu & Kashmir, CMS Analytics, Duolingo, Embassy of the State of Qatar, HM Government of Gibraltar, Leiden University, Mr Ronald Chagoury, Real Madrid CF, SM Entertainment, Stripe Matter, Inc, Trump Vance Inaugural Committee
donor_public_address string Public address of the donor No 1 South Audley Street London W1K 1NB, 1515 Ringling Blvd, Suite 250 Sarasota, FL, 34236 USA, 354 Oyster Point Boulevard South San Francisco CA 94080 US, 67 35th Street, Unit B-513 Brooklyn, NY 11232, Acro Seoul Forest D-Tower, 83-21 Wangsimni-Ro, Seongdong-Gu, Seoul, Korea, Ayita LLC 10351 Washington Blvd, Culver City, CA 90232, Duolingo, Inc. of 5900 Penn Avenue, Pittsburgh, PA 15206, Floor 4, General Services Administration at National Capitol Region 301 7th Street SW, Washington, DC 20024 USA, Gibraltar House, 150 The Strand, London WC2R 1JA, Leiden University, PO Box 9500, 2300 RA Leiden. The Netherlands, Santiago Bernabeu Stadium, Madrid, Spain, Services & General Administration Department, Central Transport Pool G0, Azad Government of the State of Jammu & Kashmir, Muzzadarabad
donor_status string Type of donor No Company, Individual, Other
donor_company_name number Name of the donor company No NaN
donor_company_url number URL of the donor company No NaN
donor_company_identifier number Identifier of the donor company No NaN
donor_company_identifier_source number Donor company identifier register No NaN
donor_trust_details number Details of the donor trust No NaN
donor_other_details string Other details of the donor No Government, Member owned sports association, US non-profit endowment, University
link string Link to the interest in the Parliament API Yes
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
summary string Text summary of the interest No
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Date the interest was registered No
published string Date the interest was published No
updated_1 string Date the interest was updated No
category string Category of the interest No Land and property (within or outside the UK)
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MPss No
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
start_date string Date the interest started No
end_date string Date the interest ended No
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
registrable_rental_income boolean Is the rental income registrable No false, true
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
number_of_properties number Number of properties owned No 1.0, NaN, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 15.0
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 Agricultural, Other
property_type string Type of property No Agricultural, Business, Commercial, Other, Residential
link string Link to the interest Yes
updated_2 string Date the interest was updated No 2016-10-11, 2017-04-03, 2019-01-18, 2024-09-09, 2024-11-28, 2024-12-04, 2025-02-19
updated_3 string Date the interest was updated No 2020-01-09, 2025-03-07, 2025-05-12
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
summary string Text summary of the interest Yes
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Date the interest was registered No
published string Date the interest was published No
updated_1 string Date the interest was updated No
category string Category of the interest No Shareholdings
mnis_id integer Unique identifier for the MP No
twfy_id string TWFY identifier for the MP No
party string TWFY party of the MP No conservative, independent, labour, labourco-operative, liberal-democrat, plaid-cymru, reform, scottish-national-party, sinn-fein, unknown
member string Name of 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
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 Delegated management company, Trust
link string Link to the interest in the Parliament API Yes
updated_2 string Date the second interest was updated No 2015-11-02, 2021-05-13
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
summary string Text summary of the interest No
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Date the interest was registered No
published string Date the interest was published No
updated_1 string Date the interest was updated No
category string Category of the interest No Miscellaneous
mnis_id integer Parliamentary ID of the MP No
twfy_id string TheyWorkForYou ID of the MP No
party string Political party of the MP No
member string Name 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
link string Link to the interest in the Parliament API Yes
updated_2 string Date the second interest was updated No 2022-02-25, 2024-02-05, 2024-09-09, 2024-09-24, 2024-10-28, 2025-03-11, 2025-04-25, 2025-06-24, 2025-07-17
updated_3 string Date the third interest was updated No 2025-08-20
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
summary string Text summary of the interest Yes
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Date the interest was registered No 2015-06-04, 2016-01-19, 2016-02-29, 2016-03-15, 2016-04-18, 2016-04-20, 2016-04-21, 2016-05-16, 2016-06-03, 2016-06-10, 2016-08-01
published string Date the interest was published No 2023-12-30, 2024-01-23, 2024-01-28, 2024-04-15, 2024-07-23, 2024-07-26
updated_1 string Date the interest was updated No
category string Category of the interest No Family members employed
mnis_id integer Unique identifier for the MP Yes
twfy_id string TheyWorkForYou ID of the MP Yes
party string TWFY party_id No conservative, dup, labour, labourco-operative, scottish-national-party
member string Name 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 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
link string Link to the interest in the Parliament API Yes
updated_2 string Date the second interest was updated No 2017-06-30, 2020-12-14, 2023-11-14, 2024-04-15
updated_3 string Date the third interest was updated No 2024-02-14, 2024-07-23
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
summary string Text summary of the interest Yes
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Date the interest was registered No
published string Date the interest was published No 2023-12-17, 2024-07-15, 2024-07-22, 2024-07-26, 2024-07-29, 2024-08-04, 2024-10-31, 2024-11-13, 2025-02-04, 2025-02-27, 2025-08-03
updated_1 string Date the interest was updated No 2021-05-11, 2022-12-09, 2024-12-16, 2025-01-13, 2025-04-28, 2025-06-05, 2025-07-22
category string Category of the interest No Family members engaged in third-party lobbying
mnis_id integer Unique identifier for the MP Yes
twfy_id string TWFY identifier for the MP Yes
party string TWFY party id of the MP No conservative, labour, labourco-operative, liberal-democrat
member string Name of the MP Yes
job_title string Job title of the family member No
employer string Name of the employer No
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
link string Link to the interest in the Parliament API Yes
updated_2 string Date the (second) interest was updated No 2024-11-19, 2025-04-24, 2025-08-04
category_code string Code for the category No 10

Change log

0.1.0

Existing resource field(s) type changed: appg