Parliamentary Register of Interests

All Registers Database

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

Description

Combined datasets of covered registers

Contributors

Licences

Download options

Individual tables

Table: Entries

Description:

This is the main register of interests data. It contains the entries for all
the different registers.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
chamber string The chamber the entry is associated with No house-of-commons, northern-ireland-assembly, scottish-parliament, welsh-parliament
person_id string The ID of the person the entry is associated with No
person_name string The name of the person the entry is associated with No
category_id string The ID of the category the entry is associated with No
category_name string The name of the category the entry is associated with No
entry_id string Unique ID for this entry Yes
parent_id string The ID of the parent entry (if any) No
content string The content of the entry No
date_registered string The date the entry was registered No
date_published string The date the entry was published No
date_updated string The date the entry was last updated No
date_received string The date the entry was received No
null_entry boolean Whether it's just an entry saying 'no interests' or similar. No false, true
details string The details of the entry No
first_register string The register the entry was first registered in No
last_register string The register the entry was last registered in No

Table: Details

Description:

A key-value that can belong to an entry with more specific data.
Some details have sub-details - which come in groups.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
chamber string The chamber the detail is associated with No house-of-commons, welsh-parliament
category_id string The ID of the category the detail is associated with No 1, 1.1, 1.2, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9
person_id string The ID of the person the detail is associated with No
entry_id string The ID of the entry the detail is associated with No
parent_detail_id string The ID of the parent detail (if any) No
detail_row_id string The ID of the detail row (for sub details) No
detail_id string The ID of the detail Yes
source string The source of the detail No official
slug string The slug of the detail type No
value string The value of the detail (always string - but the actual content might not be) No

Table: Categories

Description:

ID to name mapping for categories

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
chamber string The chamber the category is associated with No house-of-commons, northern-ireland-assembly, scottish-parliament, welsh-parliament
category_id string The ID of the category No
category_name string The name of the category No

Table: Detail Types

Description:

This contains more information about the detail types that are used in the
registers. This is mostly reflecting the Commons descriptions.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
chamber string The chamber the detail is associated with No house-of-commons, welsh-parliament
category_id string The ID of the category the detail is associated with No 1, 1.1, 1.2, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9
slug string The slug of the detail type No
display_as string The display name of the detail No
description string A description of the property No
type string The data type of the property No boolean, container, date, decimal, int, string

Change log

0.1.0

Change in data for resource(s): entries,details