Parliamentary Register of Interests

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
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-08-27, 2024-09-25, 2024-09-30, 2024-10-03, 2024-12-05, 2024-12-18
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, plaid-cymru, 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 Adaptation of authored works., Councillor, Guest presenting LBC Radio programme, Institutional Investor Event - guest speaker, Italian translation of a book, Speaking, Speaking engagement, Speech and workshop at LGA Black, Asian and Minority Ethnic Councillors Masterclass Weekender, Writing, medical practice
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 Elizabeth Garrett Anderson School, Fee allocated to my staffing budget.
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, labourco-operative, 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, Deputy Leader of the Council and Cabinet Member, Project management and delivery, 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, true
ultimate_payer_name string Name of the ultimate payer No Evans Derry Solicitors, SSE
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 133 Long Street Atherstone Warwickshire CV9 1AD, Inveralmond House, 200 Dunkeld Rd, Perth, PH1 3AQ
ultimate_payer_nature_of_business string Nature of business of the ultimate payer No High Street Solicitors Practice, Multinational energy company headquartered in Perth, Scotland
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-05-15, 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, scottish-national-party, speaker, traditional-unionist-voice, uup
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, 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 Identifier of the donor company No
donor_company_identifier_source string Source of the donor company identifier No Companies House
donor_trust_details string Details of the donor trust No TLC is a Trust, raising funds for political campaigning activities of the South Hams Liberal Democratic Party, The Port Isaac Liberal Club is administered as a trust., Trust created before 27 July 1999, Trust supporting unionist campaigns, Trust supporting unionist candidates
donor_other_details string 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 2024-08-01, 2024-10-18, 2024-12-02
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, green, independent, labour, labourco-operative, liberal-democrat, reform, sinn-fein
member string Name of the MP No
appg string Payment made via an All-Party Parliamentary Group No APPG Aviation, Aerospace and Travel (This event was during my time as Chair), APPG on Beer, British Busses, Food and Drink APPG, Music, Tennis APPG, Ukraine
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, 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
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-04-11, 2024-10-25
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
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
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
donors__name_3 string Name of the donor No British Embassy Berne, Irish American Unity Conference, Kyivstar, The Arkin Group, 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, 1147 Lindsay Rd, Carnegie, PA 15106, 25 Mala Berdichivska str., Zhytomyr, Ukraine, 10014, 3 Orchard Pl, London SW1H 0BF, P.O. Box : 309 Girne- Kıbrıs, 99300, 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 Costs, Accommodation, meals, Daytrip to Zhytomyr (approx.), Flights: £500 (Cyprus Premier) Accommodation (for three nights): £300 (The Arkin Group) Subsistence (across three days): £350 (The Turkish Cypriot Chamber of Commerce, the British Residents Society, Turkish Airlines). Total: £1,150, Formal Dinner and receptions, Hotel (£350), Food (£20), Meal £50.00, Transport and buffet lunch
donors__value_3 number Value of the payment No 25.0, NaN, 50.0, 160.0, 370.0, 670.28, 1150.0
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, The British Residents Society, 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, Mustafa Cagatay Avenue, Girne, 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.), Flights: £500 (Cyprus Premier) Accommodation (for three nights): £300 (The Arkin Group) Subsistence (across three days): £350 (The Turkish Cypriot Chamber of Commerce, the British Residents Society, Turkish Airlines). Total: £1,150
donors__value_4 number Value of the payment No 25.0, NaN, 25.86, 150.0, 1150.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, Turkish Airlines, 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, Istanbul Atatürk Airport, Yeşilköy, Bakırköy, Istanbul, Türkiye
donors__payment_type_5 string Type of payment No In kind
donors__payment_description_5 string Description of the payment No Dinner in Lviv, Flights: £500 (Cyprus Premier) Accommodation (for three nights): £300 (The Arkin Group) Subsistence (across three days): £350 (The Turkish Cypriot Chamber of Commerce, the British Residents Society, Turkish Airlines). Total: £1,150, YES Conference
donors__value_5 number Value of the payment No 92.11, NaN, 86.2, 1150.0
donors__is_sole_beneficiary_5 string Whether the MP is the sole beneficiary No True
link string Link to the interest Yes
visit_locations__country_2 string Country of the visit No Azerbaijan, Israel, Palestine, Poland, Singapore
visit_locations__destination_2 string Destination of the visit No Baku, Hebron, Ramallah
visit_locations__country_3 string Country of the visit No Georgia, Moldova
visit_locations__destination_3 string Destination of the visit No Tbilisi airport (transfer)
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 10723, 10782, 11267, 11809, 12043
summary string Text summary of the interest Yes Ayita LLC - £836.00, Azad Government of the State of Jammu & Kashmir - £707.00, Leiden University - £350.00, Mr Ronald Chagoury - £1,440.00, Trump Vance Inaugural Committee - £712.87
parent_interest_id number Unique identifier for the parent interest No NaN
registered string Registered date Yes 2024-09-17, 2024-09-25, 2024-11-14, 2025-02-14, 2025-03-18
published string Published date Yes 2024-09-17, 2024-09-25, 2024-11-18, 2025-02-14, 2025-03-19
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 Yes 4018, 4356, 4475, 4598, 5296
twfy_id string TheyWorkForYou ID of the MP Yes 24796, 25272, 25429, 25649, 26540
party string Political party of the MP No conservative, labour, liberal-democrat
member string Name of the MP Yes Angela Rayner, Freddie van Mierlo, Helen Grant, Mohammad Yasin, Suella Braverman
appg number Linked to an All-Party Parliamentary Group No NaN
payment_type string Type of payment No In kind
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, Hospitality - visit to DJ booth, Hï Ibiza, 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
value number Value of the payment (£) Yes 350.0, 707.0, 712.87, 836.0, 1440.0
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 Yes Ayita LLC, Azad Government of the State of Jammu & Kashmir, Leiden University, Mr Ronald Chagoury, Trump Vance Inaugural Committee
donor_public_address string Public address of the donor Yes Ayita LLC 10351 Washington Blvd, Culver City, CA 90232, Floor 4, General Services Administration at National Capitol Region 301 7th Street SW, Washington, DC 20024 USA, Leiden University, PO Box 9500, 2300 RA Leiden. The Netherlands, 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, University
link string Link to the interest in the Parliament API 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/11267, https://interests-api.parliament.uk/api/v1/Interests/11809, https://interests-api.parliament.uk/api/v1/Interests/12043
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
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 2021-07-22, 2022-02-25, 2023-04-18, 2024-02-05, 2024-07-12, 2024-07-19, 2024-09-09, 2024-09-24, 2024-10-28, 2025-03-11
updated_3 string Date the third interest was updated No 2022-09-28, 2024-07-10
updated_4 string Date the fourth interest was updated No 2023-08-15
updated_5 string Date the fifth interest was updated No 2024-07-11
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 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
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
updated_1 string Date the interest was updated No 2021-05-11, 2022-12-09, 2024-12-16, 2025-01-13
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
category_code string Code for the category No 10

Change log

0.1.0

Minor change in data for resource(s): overall,category_1.1,category_2,category_3,category_4,category_5,category_8