APPG Groups and Memberships

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

Description

APPG register with experimental ML membership scrapers.

DO NOT RELY ON ‘ai_search’ MEMBERSHIP DATA YET - needs further validation.

Contributors

Licences

Download options

Individual tables

Table: Categories

Description:

Categories added to APPG by mySociety

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
appg_slug string Slugified name of the APPG No
category_slug string Slugified name of the category No
category_name string Nice name of the category No

Table: APPG Memberships

Description:

APPG Memberships scraped using experimental ML scraper.
DO NOT RELY ON ‘ai_search’ MEMBERSHIP DATA YET - needs further validation.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
name string Original name from the scraper (may contain typos) No
officer_role string Role of the member in the APPG No Assistant Chair, Chair & Registered Contact, Co-Chair, Co-Vice-Chair, Deputy Chair, Honorary President, Honorary Secretary, Officer, President, Secretary, Senior Vice Chair, Treasurer, Vice Chair
twfy_id string TheyWorkForYou ID for the member No
mnis_id string Parliamentary ID for the member No
canon_name string Name from the TWFY database No
appg string Slugified name of the APPG No
is_officer boolean Is the member an officer of the APPG? No false, true
member_type string Type of member (trusting source, not always right) No lord, mp, other
source string Source of the data No ai_search, manual, parliament
last_updated string Date the data was last updated No 2024-12-01, 2025-04-28, 2025-04-29, 2025-04-30, 2025-05-08, 2025-06-18, 2025-06-19
url_source string URL of the source of the data No
removed string Is this a previous member who is no longer a member. No False

Table: APPG Register

Description:

APPG Register as a spreadsheet

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
slug string Slugified name of the APPG Yes
title string Title of the APPG Yes
purpose string Purpose of the APPG Yes
category string Category of the APPG No Country, Area or Region Group, Subject Group
registrable_benefits string Registrable benefits of the APPG No , Financial Benefits
source_url string URL of the APPG on the Parliament website Yes
categories string Pipe seperated list of (mysociety added) categories for the APPG No
registered_contact_name string Name of the registered contact No
registered_contact_address string Address of the registered contact No
registered_contact_email string Email of the registered contact No
public_enquiry_point_name string Name of the public enquiry point No
public_enquiry_point_email string Email of the public enquiry point No
secretariat string Name of the secretariat No
website string URL of the APPG website No
website_status string Status of the APPG website No bad_search, manual, no_search, register, search
date_of_most_recent_agm string Date of the most recent AGM No
published_income_expenditure_statement boolean Published income and expenditure statement No false
reporting_year string Reporting year of the APPG No
next_reporting_deadline string Next reporting deadline for the APPG No
detailed_benefits string Json dict of the benefits of the APPG No

Change log

0.6.0

Change in data for resource(s): categories,members,register

0.5.4

description changed from 'APPG register with experimental ML membership scrapers. DO NOT REPLY ON 'ai_search' MEMBERSHIP DATA YET - needs further validation. ' to 'APPG register with experimental ML membership scrapers. DO NOT RELY ON 'ai_search' MEMBERSHIP DATA YET - needs further validation. '

0.5.3

description changed from 'APPG register with experimental ML membership scrapers. ' to 'APPG register with experimental ML membership scrapers. DO NOT REPLY ON 'ai_search' MEMBERSHIP DATA YET - needs further validation. '

0.5.2

Minor change in data for resource(s): members

0.5.1

Minor change in data for resource(s): members

0.5.0

Change in data for resource(s): categories,members,register

0.4.0

Existing resource field(s) type changed: published_income_expenditure_statement

0.3.0

New field(s) added to resource: categories

0.2.0

New field(s) added to end of resource: removed

0.1.0

Don't need to increment, first version