Beneficial ownership data analysis tools

UK Persons with significant control (PSC) Register Downloads and Links person_statement person_names person_identifiers person_nationalities person_addresses entity_statement entity_identifiers entity_addresses ooc_statement ooc_interests

UK Persons with significant control (PSC) Register (2023-05-01)

The United Kingdom's Persons with significant control (PSC) Register was launched in April 2016 and contains beneficial ownership details declared for companies registered with Companies House. Search data on UK companies and their beneficial ownership at https://find-and-update.company-information.service.gov.uk or learn about Companies House's APIs at https://developer-specs.company-information.service.gov.uk.

You can see how Open Ownership has ingested, mapped and transformed this data in line with version 0.2 of our Beneficial Ownership Data Standard as well as how we reconcile and enrich this using bulk data from OpenCorporates. These mappings are currently a work in progress and should be treated with caution. This dataset is published under the Open Data Commons Attribution License. Read full details about the UK PSC Register on the Open Ownership Register website or visit our dashboard to gain insights into this data.

Downloads and links to hosted databases

CSV Download SQLite Download Postgresql Dump (gzip) JSON Download Parquet Download Big Query Datasette

Tables

person_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	10,118,379	8883363	7682042	9930473
statementID	number	10,118,379	9.197297189e+18	5.047225549e+18	1.09873954e+19
statementType	string	10,118,379	personStatement	personStatement	personStatement
statementDate	date	10,118,379	2023-03-17	2023-03-16	2023-04-30
isComponent	boolean	10,118,379	False	False	False
personType	string	10,118,379	knownPerson	knownPerson	knownPerson
birthDate	date	10,117,909	1979-03-01	1956-02-01	1965-04-01
publicationDetails_publicationDate	date	10,118,379	2023-03-17	2023-03-16	2023-04-30
publicationDetails_bodsVersion	number	10,118,379	0.2	0.2	0.2
publicationDetails_license	string	10,118,379	https://register.openownership.org/terms-and-conditions	https://register.openownership.org/terms-and-conditions	https://register.openownership.org/terms-and-conditions
publicationDetails_publisher_name	string	10,118,379	OpenOwnership Register	OpenOwnership Register	OpenOwnership Register
publicationDetails_publisher_url	string	10,118,379	https://register.openownership.org	https://register.openownership.org	https://register.openownership.org
source_type	string	10,118,379	officialRegister	officialRegister	officialRegister
source_description	string	10,118,379	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register
source_url	string	10,118,379	http://download.companieshouse.gov.uk/en_pscdata.html	http://download.companieshouse.gov.uk/en_pscdata.html	http://download.companieshouse.gov.uk/en_pscdata.html
source_retrievedAt	date	10,118,379	2023-03-17	2023-03-16	2023-04-30
source_assertedBy	boolean	10,118,379	None	None	None
replacesStatements	string	47	None	None	None

person_names

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	10,118,379	2041654.names.0	1736465.names.0	8244037.names.0
_link_person_statement	string	10,118,379	2041654	1736465	8244037
type	string	10,118,379	individual	individual	individual
fullName	string	10,118,379	Jordan Tugby-Smith	Hassan Sabrah	Jerathinam Jeshree
familyName	string	10,118,379	Tugby-Smith	Sabrah	Jeshree
givenName	string	10,118,311	Jordan	Hassan	Jerathinam

person_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	20,236,758	7128823.identifiers.0	8998514.identifiers.0	5367152.identifiers.0
_link_person_statement	string	20,236,758	7128823	8998514	5367152
id	string	20,236,758	/company/10602280/persons-with-significant-control/individual/J_6-iLNUDNx9_FOC2juTVaycC6k	/company/04237761/persons-with-significant-control/individual/AfVqVHE5Zfoe0lD1USubNkAMW3g	/company/10706886/persons-with-significant-control/individual/2ePAB425-Z-oCW4-6LgYWdfatmg
schemeName	string	20,236,758	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register
uri	string	10,118,379	None	None	None

person_nationalities

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,974,149	4711402.nationalities.0	1616636.nationalities.0	943813.nationalities.0
_link_person_statement	string	8,974,149	4711402	1616636	943813
name	string	8,974,149	Ireland	United Kingdom of Great Britain and Northern Ireland	United Kingdom of Great Britain and Northern Ireland
code	string	8,974,149	IE	GB	GB

person_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	4,240,567	371396.addresses.0	9419857.addresses.0	8986576.addresses.0
_link_person_statement	string	4,240,567	371396	9419857	8986576
type	string	4,240,567	registered	registered	registered
address	string	4,240,567	71 The Hundred, Romsey, Hampshire, SO51 8BZ	78, Arundel Avenue, Liverpool, L17 2AX	22, Via Eugenio Curiel, Casaguidi, Pistoia, 51034
country	string	4,240,567	GB	GB	IT

entity_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,932,035	7854273	1257042	3019712
statementID	number	8,932,035	1.088510088e+19	1.31736103e+19	1.209734251e+19
statementType	string	8,932,035	entityStatement	entityStatement	entityStatement
statementDate	date	8,932,035	2023-03-17	2023-03-15	2023-03-15
isComponent	boolean	8,932,035	False	False	False
entityType	string	8,932,035	registeredEntity	registeredEntity	registeredEntity
name	string	8,890,299	WHAT TRADING LTD	DRAGON DIGITAL BRANDS LIMITED	Dh Team Ltd
foundingDate	date	8,751,188	2017-06-01	2018-09-04	2017-02-23
incorporatedInJurisdiction_name	string	8,835,767	United Kingdom of Great Britain and Northern Ireland	United Kingdom of Great Britain and Northern Ireland	United Kingdom of Great Britain and Northern Ireland
incorporatedInJurisdiction_code	string	8,835,767	GB	GB	GB
publicationDetails_publicationDate	date	8,932,035	2023-03-17	2023-03-15	2023-03-15
publicationDetails_bodsVersion	number	8,932,035	0.2	0.2	0.2
publicationDetails_license	string	8,932,035	https://register.openownership.org/terms-and-conditions	https://register.openownership.org/terms-and-conditions	https://register.openownership.org/terms-and-conditions
publicationDetails_publisher_name	string	8,932,035	OpenOwnership Register	OpenOwnership Register	OpenOwnership Register
publicationDetails_publisher_url	string	8,932,035	https://register.openownership.org	https://register.openownership.org	https://register.openownership.org
dissolutionDate	date	2,865,052	2022-04-26	None	None
source_type	string	794,688	None	None	officialRegister
source_description	string	794,688	None	None	GB Persons Of Significant Control Register
source_url	string	794,688	None	None	http://download.companieshouse.gov.uk/en_pscdata.html
source_retrievedAt	date	794,688	None	None	2023-03-15
source_assertedBy	boolean	794,688	None	None	None
replacesStatements	string	547,265	None	None	4702387256373068205

entity_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	27,336,085	6868276.identifiers.2	7692496.identifiers.1	3767905.identifiers.0
_link_entity_statement	string	27,336,085	6868276	7692496	3767905
id	string	27,336,085	/entities/5278094072929424616	08193412	/company/OC437950/persons-with-significant-control/corporate-entity/QZgP-BTswJjsDYfsTovthujpExk
scheme	string	8,137,347	None	None	None
schemeName	string	27,336,085	OpenOwnership Register	GB Persons Of Significant Control Register - Registration numbers	GB Persons Of Significant Control Register
uri	string	17,688,845	/entities/5278094072929424616	None	None

entity_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,890,299	4930272.addresses.0	5486147.addresses.0	6499352.addresses.0
_link_entity_statement	string	8,890,299	4930272	5486147	6499352
type	string	8,890,299	registered	registered	registered
address	string	8,890,299	910 The Crescent Colchester Business Park, Colchester, Essex, CO4 9YQ	85 Wilmot Way Wilmot Way, Banstead, Surrey, SM7 2QA	6 North Street, Oundle, Peterborough, PE8 4AL
country	string	8,794,031	GB	GB	GB

ooc_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	10,993,351	8192545	6708624	9998075
statementID	number	10,993,351	1.521715134e+19	4.389146111e+18	4.996964467e+18
statementType	string	10,993,351	ownershipOrControlStatement	ownershipOrControlStatement	ownershipOrControlStatement
statementDate	date	10,993,351	2017-03-12	2022-10-25	2016-08-08
isComponent	boolean	10,993,351	False	False	False
subject_describedByEntityStatement	number	10,993,351	2.557980442e+18	1.765282427e+19	6.412028536e+18
interestedParty_describedByPersonStatement	number	10,223,818	1.624044271e+19	None	1.793484914e+19
publicationDetails_publicationDate	date	10,993,351	2023-03-16	2023-03-16	2023-03-17
publicationDetails_bodsVersion	number	10,993,351	0.2	0.2	0.2
publicationDetails_license	string	10,993,351	https://register.openownership.org/terms-and-conditions	https://register.openownership.org/terms-and-conditions	https://register.openownership.org/terms-and-conditions
publicationDetails_publisher_name	string	10,993,351	OpenOwnership Register	OpenOwnership Register	OpenOwnership Register
publicationDetails_publisher_url	string	10,993,351	https://register.openownership.org	https://register.openownership.org	https://register.openownership.org
source_type	string	10,993,351	officialRegister	officialRegister	officialRegister
source_description	string	10,993,351	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register
source_url	string	10,993,351	http://download.companieshouse.gov.uk/en_pscdata.html	http://download.companieshouse.gov.uk/en_pscdata.html	http://download.companieshouse.gov.uk/en_pscdata.html
source_retrievedAt	date	10,993,351	2023-03-16	2023-03-16	2023-03-17
source_assertedBy	boolean	10,993,351	None	None	None

ooc_interests

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	24,113,360	6663334.interests.2	6748470.interests.1	3193193.interests.1
_link_ooc_statement	string	24,113,360	6663334	6748470	3193193
type	string	24,113,360	appointment-of-board	voting-rights	voting-rights
details	string	24,113,360	right-to-appoint-and-remove-directors	voting-rights-25-to-50-percent	voting-rights-75-to-100-percent
startDate	date	24,113,360	2022-11-04	2022-09-30	2020-05-13
share_maximum	number	17,370,782	None	50.0	100.0
share_minimum	number	17,370,787	None	25.0	75.0
share_exclusiveMinimum	boolean	17,370,787	None	True	False
share_exclusiveMaximum	boolean	17,370,782	None	False	False
endDate	date	2,677,617	None	None	None

_link	statementID	statementType	statementDate	isComponent	personType	birthDate	publicationDetails_publicationDate	publicationDetails_bodsVersion	publicationDetails_license	publicationDetails_publisher_name	publicationDetails_publisher_url	source_type	source_description	source_url	source_retrievedAt	source_assertedBy	replacesStatements
8883363	9.197297189e+18	personStatement	2023-03-17	False	knownPerson	1979-03-01	2023-03-17	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-17	None	None
7682042	5.047225549e+18	personStatement	2023-03-16	False	knownPerson	1956-02-01	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None	None
9930473	1.09873954e+19	personStatement	2023-04-30	False	knownPerson	1965-04-01	2023-04-30	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-04-30	None	None
5638872	7.838128515e+18	personStatement	2023-03-16	False	knownPerson	1984-05-01	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None	None
3934423	1.698289225e+19	personStatement	2023-03-15	False	knownPerson	1950-11-01	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None	None
1665460	8.447832897e+18	personStatement	2023-03-15	False	knownPerson	1966-01-01	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None	None
1775272	1.60010396e+19	personStatement	2023-03-15	False	knownPerson	1977-03-01	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None	None
2719166	4.992768715e+17	personStatement	2023-03-15	False	knownPerson	1990-07-01	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None	None
8823968	1.404901405e+19	personStatement	2023-03-17	False	knownPerson	1985-10-01	2023-03-17	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-17	None	None
2242840	5.735956815e+18	personStatement	2023-03-15	False	knownPerson	1965-11-01	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None	None

_link	_link_person_statement	type	fullName	familyName	givenName
2041654.names.0	2041654	individual	Jordan Tugby-Smith	Tugby-Smith	Jordan
1736465.names.0	1736465	individual	Hassan Sabrah	Sabrah	Hassan
8244037.names.0	8244037	individual	Jerathinam Jeshree	Jeshree	Jerathinam
9934292.names.0	9934292	individual	Gershon Hochhauser	Hochhauser	Gershon
2822766.names.0	2822766	individual	Nitish Singh	Singh	Nitish
8535749.names.0	8535749	individual	Oliver English	English	Oliver
8848144.names.0	8848144	individual	William Dixon	Dixon	William
2582863.names.0	2582863	individual	Jane Walker	Walker	Jane
5713327.names.0	5713327	individual	Nicholas Dowdeswell	Dowdeswell	Nicholas
188933.names.0	188933	individual	Sampada Ithape	Ithape	Sampada

_link	_link_person_statement	id	schemeName	uri
7128823.identifiers.0	7128823	/company/10602280/persons-with-significant-control/individual/J_6-iLNUDNx9_FOC2juTVaycC6k	GB Persons Of Significant Control Register	None
8998514.identifiers.0	8998514	/company/04237761/persons-with-significant-control/individual/AfVqVHE5Zfoe0lD1USubNkAMW3g	GB Persons Of Significant Control Register	None
5367152.identifiers.0	5367152	/company/10706886/persons-with-significant-control/individual/2ePAB425-Z-oCW4-6LgYWdfatmg	GB Persons Of Significant Control Register	None
4078043.identifiers.0	4078043	/company/02840750/persons-with-significant-control/individual/7F2PTAgMaNtCxqkK7dD9oXWeOzw	GB Persons Of Significant Control Register	None
7254958.identifiers.0	7254958	/company/04641489/persons-with-significant-control/individual/va0T68ZEbl_pOxYsaLVqvrwLzY0	GB Persons Of Significant Control Register	None
9772365.identifiers.1	9772365	/entities/11367944054257851884	OpenOwnership Register	/entities/11367944054257851884
9019481.identifiers.1	9019481	/entities/14389767027964102613	OpenOwnership Register	/entities/14389767027964102613
8264918.identifiers.1	8264918	/entities/16910688527685105481	OpenOwnership Register	/entities/16910688527685105481
447198.identifiers.1	447198	/entities/12960922317599016364	OpenOwnership Register	/entities/12960922317599016364
5713696.identifiers.1	5713696	/entities/10548436320610048088	OpenOwnership Register	/entities/10548436320610048088

_link	_link_person_statement	name	code
4711402.nationalities.0	4711402	Ireland	IE
1616636.nationalities.0	1616636	United Kingdom of Great Britain and Northern Ireland	GB
943813.nationalities.0	943813	United Kingdom of Great Britain and Northern Ireland	GB
9111828.nationalities.0	9111828	United Kingdom of Great Britain and Northern Ireland	GB
447771.nationalities.0	447771	United Kingdom of Great Britain and Northern Ireland	GB
2055905.nationalities.0	2055905	United Kingdom of Great Britain and Northern Ireland	GB
3253969.nationalities.0	3253969	United Kingdom of Great Britain and Northern Ireland	GB
3592076.nationalities.0	3592076	United Kingdom of Great Britain and Northern Ireland	GB
229599.nationalities.0	229599	Brazil	BR
3921708.nationalities.0	3921708	United Kingdom of Great Britain and Northern Ireland	GB

_link	_link_person_statement	type	address	country
371396.addresses.0	371396	registered	71 The Hundred, Romsey, Hampshire, SO51 8BZ	GB
9419857.addresses.0	9419857	registered	78, Arundel Avenue, Liverpool, L17 2AX	GB
8986576.addresses.0	8986576	registered	22, Via Eugenio Curiel, Casaguidi, Pistoia, 51034	IT
1579295.addresses.0	1579295	registered	144 Pendlebury Drive, Leicester, LE2 6GX	GB
6682038.addresses.0	6682038	registered	34, Windermere Avenue, Poulton-Le-Fylde, FY6 8FS	FR
9546838.addresses.0	9546838	registered	Flat 1, 64 Blackthorn Road, Southampton, SO19 7LR	GB
7509497.addresses.0	7509497	registered	Office 8, Mills Hill Works, Corbrook Road, Chadderton, Oldham, OL9 9SD	PH
4583040.addresses.0	4583040	registered	25, Moreton Way, Slough, SL1 5LS	GB
4821769.addresses.0	4821769	registered	Suite 702 Crown House, North Circular Road, London, NW10 7PN	GB
1211667.addresses.0	1211667	registered	301, Staines Road West, Ashford, Middlesex, TW15 1RS	GB

_link	statementID	statementType	statementDate	isComponent	entityType	name	foundingDate	incorporatedInJurisdiction_name	incorporatedInJurisdiction_code	publicationDetails_publicationDate	publicationDetails_bodsVersion	publicationDetails_license	publicationDetails_publisher_name	publicationDetails_publisher_url	dissolutionDate	source_type	source_description	source_url	source_retrievedAt	source_assertedBy	replacesStatements
7854273	1.088510088e+19	entityStatement	2023-03-17	False	registeredEntity	WHAT TRADING LTD	2017-06-01	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-17	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	2022-04-26	None	None	None	None	None	None
1257042	1.31736103e+19	entityStatement	2023-03-15	False	registeredEntity	DRAGON DIGITAL BRANDS LIMITED	2018-09-04	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	None	None	None	None	None	None
3019712	1.209734251e+19	entityStatement	2023-03-15	False	registeredEntity	Dh Team Ltd	2017-02-23	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None	4702387256373068205
1477752	1.175727321e+19	entityStatement	2023-03-15	False	registeredEntity	RIDGEWAY FOOD VENTURES UK LIMITED	2018-10-05	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	None	None	None	None	None	None
1810337	1.16827896e+19	entityStatement	2023-03-15	False	registeredEntity	THE TASK HUB LIMITED	2019-03-05	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	2021-08-03	None	None	None	None	None	None
514533	1.525887242e+19	entityStatement	2023-03-15	False	registeredEntity	WB DEVELOPMENTS LLP	2011-07-22	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	None	None	None	None	None	None
6327424	1.170361268e+19	entityStatement	2023-03-16	False	registeredEntity	KLANS2012 LTD	2012-12-17	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	None	None	None	None	None	None
8316025	3.024980138e+18	entityStatement	2023-03-17	False	registeredEntity	TIMBER LOGISTICS LTD	2017-09-04	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-17	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	2019-10-22	None	None	None	None	None	None
6272303	1.248425784e+19	entityStatement	2023-03-16	False	registeredEntity	German Swedish & French Car Parts Limited	1999-12-17	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None	13245819558007988194
2356190	1.499339198e+19	entityStatement	2023-03-15	False	registeredEntity	HIGHLAND NEWS AND MEDIA LIMITED	2019-11-20	United Kingdom of Great Britain and Northern Ireland	GB	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	None	None	None	None	None	None	None

_link	_link_entity_statement	id	scheme	schemeName	uri
6868276.identifiers.2	6868276	/entities/5278094072929424616	None	OpenOwnership Register	/entities/5278094072929424616
7692496.identifiers.1	7692496	08193412	None	GB Persons Of Significant Control Register - Registration numbers	None
3767905.identifiers.0	3767905	/company/OC437950/persons-with-significant-control/corporate-entity/QZgP-BTswJjsDYfsTovthujpExk	None	GB Persons Of Significant Control Register	None
3075723.identifiers.1	3075723	https://opencorporates.com/companies/gb/12943443	None	OpenCorporates	https://opencorporates.com/companies/gb/12943443
3494285.identifiers.0	3494285	13278540	GB-COH	Companies House	None
7401622.identifiers.2	7401622	/entities/8475292572765900232	None	OpenOwnership Register	/entities/8475292572765900232
7360526.identifiers.1	7360526	https://opencorporates.com/companies/gb/08506567	None	OpenCorporates	https://opencorporates.com/companies/gb/08506567
1610378.identifiers.0	1610378	11751489	GB-COH	Companies House	None
3085076.identifiers.1	3085076	https://opencorporates.com/companies/gb/12886558	None	OpenCorporates	https://opencorporates.com/companies/gb/12886558
2242946.identifiers.0	2242946	12204972	GB-COH	Companies House	None

_link	_link_entity_statement	type	address	country
4930272.addresses.0	4930272	registered	910 The Crescent Colchester Business Park, Colchester, Essex, CO4 9YQ	GB
5486147.addresses.0	5486147	registered	85 Wilmot Way Wilmot Way, Banstead, Surrey, SM7 2QA	GB
6499352.addresses.0	6499352	registered	6 North Street, Oundle, Peterborough, PE8 4AL	GB
7672035.addresses.0	7672035	registered	Prospect House Bulls Cross, Sheepscombe, Stroud, Gloucestershire, GL6 7HU	GB
4912941.addresses.0	4912941	registered	Rushtons Insolvency Limited, 3 Merchants Quay, Ashley Lane, Shipley, West Yorkshire, BD17 7DB	GB
4620677.addresses.0	4620677	registered	8 Newton Street, Bristol, BS5 0QZ	GB
3367112.addresses.0	3367112	registered	4 Cranleigh, Standish, Wigan, Lancashire, WN6 0EU	GB
8156463.addresses.0	8156463	registered	10856304: COMPANIES HOUSE DEFAULT ADDRESS, Cardiff, CF14 8LH	GB
2774034.addresses.0	2774034	registered	Fairways, Berry Lane, Woking, GU22 0RH	GB
2662697.addresses.0	2662697	registered	75 Orchard Avenue, Southall, Middlesex, UB1 1LQ	GB

_link	statementID	statementType	statementDate	isComponent	subject_describedByEntityStatement	interestedParty_describedByPersonStatement	publicationDetails_publicationDate	publicationDetails_bodsVersion	publicationDetails_license	publicationDetails_publisher_name	publicationDetails_publisher_url	source_type	source_description	source_url	source_retrievedAt	source_assertedBy
8192545	1.521715134e+19	ownershipOrControlStatement	2017-03-12	False	2.557980442e+18	1.624044271e+19	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None
6708624	4.389146111e+18	ownershipOrControlStatement	2022-10-25	False	1.765282427e+19	None	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None
9998075	4.996964467e+18	ownershipOrControlStatement	2016-08-08	False	6.412028536e+18	1.793484914e+19	2023-03-17	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-17	None
1078807	3.54278144e+18	ownershipOrControlStatement	2016-04-06	False	1.586451772e+19	1.021727155e+19	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None
7059360	1.161130078e+19	ownershipOrControlStatement	2016-04-06	False	1.461250393e+19	6.348689322e+18	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None
3087165	9.612956068e+18	ownershipOrControlStatement	2020-02-15	False	1.743131846e+19	7.975206785e+18	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None
9032057	1.055125351e+19	ownershipOrControlStatement	2016-04-06	False	2.740906175e+18	1.292888513e+19	2023-03-17	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-17	None
8589929	8.119684677e+18	ownershipOrControlStatement	2017-02-06	False	9.831835329e+18	1.812271053e+19	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None
6570810	1.51344417e+19	ownershipOrControlStatement	2022-08-04	False	1.661439898e+19	1.718561925e+19	2023-03-16	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-16	None
1542772	1.610013231e+19	ownershipOrControlStatement	2018-07-10	False	4.437981156e+18	1.708442699e+19	2023-03-15	0.2	https://register.openownership.org/terms-and-conditions	OpenOwnership Register	https://register.openownership.org	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	2023-03-15	None

_link	_link_ooc_statement	type	details	startDate	share_maximum	share_minimum	share_exclusiveMinimum	share_exclusiveMaximum	endDate
6663334.interests.2	6663334	appointment-of-board	right-to-appoint-and-remove-directors	2022-11-04	None	None	None	None	None
6748470.interests.1	6748470	voting-rights	voting-rights-25-to-50-percent	2022-09-30	50.0	25.0	True	False	None
3193193.interests.1	3193193	voting-rights	voting-rights-75-to-100-percent	2020-05-13	100.0	75.0	False	False	None
6312274.interests.0	6312274	shareholding	ownership-of-shares-25-to-50-percent	2016-04-06	50.0	25.0	True	False	2021-10-30
6806490.interests.1	6806490	voting-rights	voting-rights-75-to-100-percent	2023-01-11	100.0	75.0	False	False	None
8856330.interests.0	8856330	shareholding	ownership-of-shares-75-to-100-percent	2016-04-08	100.0	75.0	False	False	None
8568665.interests.2	8568665	appointment-of-board	right-to-appoint-and-remove-directors	2016-04-06	None	None	None	None	None
10521794.interests.1	10521794	voting-rights	voting-rights-75-to-100-percent	2023-02-06	100.0	75.0	False	False	None
6591488.interests.1	6591488	voting-rights	voting-rights-75-to-100-percent	2022-11-09	100.0	75.0	False	False	None
6907612.interests.0	6907612	shareholding	ownership-of-shares-75-to-100-percent	2022-12-22	100.0	75.0	False	False	None

Beneficial ownership data analysis tools

UK Persons with significant control (PSC) Register (2023-05-01)

Downloads and links to hosted databases

Tables

person_statement

person_names

person_identifiers

person_nationalities

person_addresses

entity_statement

entity_identifiers

entity_addresses

ooc_statement

ooc_interests

Sample data from `person_statement` table.

Sample data from `person_names` table.

Sample data from `person_identifiers` table.

Sample data from `person_nationalities` table.

Sample data from `person_addresses` table.

Sample data from `entity_statement` table.

Sample data from `entity_identifiers` table.

Sample data from `entity_addresses` table.

Sample data from `ooc_statement` table.

Sample data from `ooc_interests` table.