Beneficial ownership data analysis tools

Open Ownership Register Downloads and Links person_statement person_names person_identifiers person_nationalities person_addresses entity_statement entity_identifiers entity_addresses ooc_statement ooc_interests

Open Ownership Register (2022-11-10)

The Open Ownership Register imports data from the beneficial ownership registers of Denmark, Slovakia and the UK and connects data across jurisdictions by structuring the data in line with v0.1 of our Beneficial Ownership Data Standard before offering it for anyone to download under the Open Data Commons Attribution License.

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	9,501,956	4262153	3139047	4274512
statementID	string	9,501,956	openownership-register-13517644144389923189	openownership-register-3766383172711602747	openownership-register-17405045311026209330
statementType	string	9,501,956	personStatement	personStatement	personStatement
personType	string	9,501,956	knownPerson	knownPerson	knownPerson
birthDate	string	8,490,407	1969-03-01	1985-02-01	1983-06-01
missingInfoReason	string	8,109	None	None	None

person_names

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,493,847	8144562.names.0	3553423.names.0	5207939.names.0
_link_person_statement	string	9,493,847	8144562	3553423	5207939
type	string	9,493,847	individual	individual	individual
fullName	string	9,493,847	Philip David Dobson	Sarah Anne Maitland	Amanda Jane Henderson

person_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	19,440,090	4960523.identifiers.0	8352892.identifiers.0	6727551.identifiers.0
_link_person_statement	string	19,440,090	4960523	8352892	6727551
schemeName	string	19,440,090	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register
id	string	19,440,090	/company/13848050/persons-with-significant-control/individual/SLHY3MzAL2z3ObvQ7XkJ_8ic7sM	/company/10759741/persons-with-significant-control/individual/ZFV4iBXNZ7hy5x_nh_kB6hFm5ek	/company/09896238/persons-with-significant-control/individual/DF9HbgPijmWeQLt-ZVo2w4MwJYY
uri	string	9,493,847	None	None	None
scheme	string	452,434	None	None	None

person_nationalities

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	7,546,417	3199262.nationalities.0	2538247.nationalities.0	6819064.nationalities.0
_link_person_statement	string	7,546,417	3199262	2538247	6819064
name	string	7,546,417	Russian Federation	Saudi Arabia	United Kingdom of Great Britain and Northern Ireland
code	string	7,546,417	RU	SA	GB

person_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,276,366	7756310.addresses.0	7850108.addresses.0	1992161.addresses.0
_link_person_statement	string	9,276,366	7756310	7850108	1992161
address	string	9,276,366	32 Green Lane, Copnor, Portsmouth, Hampshire, PO3 5EY	The Mountbatten School, Whitenap Lane, Romsey, Hampshire, SO51 5SY	60 Coleshillflats,, Pimlico Road, London, SW1W 8LL
country	string	4,201,960	GB	None	GB

entity_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,655,537	7932090	1667614	2571275
statementID	string	8,655,537	openownership-register-8533532670628554999	openownership-register-8851830971535014658	openownership-register-14422323150782945864
statementType	string	8,655,537	entityStatement	entityStatement	entityStatement
entityType	string	8,655,537	registeredEntity	registeredEntity	registeredEntity
name	string	8,541,615	PHONE SPOT LIMITED	VP MEDIA GROUP LTD	YASH RAJ LIMITED
foundingDate	datetime	8,046,952	1367193600000	1534809600000	1568246400000
dissolutionDate	datetime	1,955,857	1561420800000	1580169600000	None
incorporatedInJurisdiction_name	string	8,599,989	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,599,989	GB	GB	GB

entity_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	26,742,907	2455205.identifiers.0	1607232.identifiers.1	765705.identifiers.2
_link_entity_statement	string	26,742,907	2455205	1607232	765705
scheme	string	8,532,769	GB-COH	None	None
schemeName	string	26,742,907	Companies House	OpenCorporates	OpenOwnership Register
id	string	26,742,906	12102161	https://opencorporates.com/companies/gb/11413528	http://register.openownership.org/entities/5ab94dda9dfc3fae187aaef0
uri	string	17,094,448	None	https://opencorporates.com/companies/gb/11413528	http://register.openownership.org/entities/5ab94dda9dfc3fae187aaef0

entity_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,528,618	41894.addresses.0	7474385.addresses.0	1699388.addresses.0
_link_entity_statement	string	8,528,618	41894	7474385	1699388
type	string	8,528,618	registered	registered	registered
address	string	8,528,618	Astoria House, 165-166 Victoria Road, Swindon, SN1 3BU	The Nook, Stoney Lane, Witherslack, Cumbria, LA11 6SN	Tir Powell Ddu, Nantyglyn Road, Ammanford, SA18 2YT
country	string	8,473,410	GB	GB	GB

ooc_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	12,221,360	1632809	2107342	8664614
statementID	string	12,221,360	openownership-register-1492795194467550190	openownership-register-1055814486145017874	openownership-register-10727738736022699572
statementType	string	12,221,360	ownershipOrControlStatement	ownershipOrControlStatement	ownershipOrControlStatement
statementDate	string	11,489,476	2018-04-03	2020-06-24	2016-04-06
subject_describedByEntityStatement	string	12,221,360	openownership-register-2851377599448525397	openownership-register-10044848166466753361	openownership-register-14202994134851940922
interestedParty_describedByPersonStatement	string	10,927,656	openownership-register-11122934435674740960	openownership-register-11534974981156086597	openownership-register-10962283870356409629
source_type	string	12,101,648	officialRegister	officialRegister	officialRegister
source_description	string	12,101,648	GB Persons Of Significant Control Register	DK Centrale Virksomhedsregister	GB Persons Of Significant Control Register
source_url	string	12,101,648	http://download.companieshouse.gov.uk/en_pscdata.html	https://cvr.dk	http://download.companieshouse.gov.uk/en_pscdata.html
source_retrievedAt	datetime	12,101,648	1562582231000	1667767089000	1562582231000
interestedParty_describedByEntityStatement	string	746,704	None	None	None
interestedParty_unspecified_reason	string	547,000	None	None	None
interestedParty_unspecified_description	string	547,000	None	None	None

ooc_interests

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	23,297,214	1906367.interests.0	7332385.interests.0	5452827.interests.0
_link_ooc_statement	string	23,297,214	1906367	7332385	5452827
type	string	23,297,214	shareholding	shareholding	shareholding
details	string	21,989,010	None	ownership-of-shares-25-to-50-percent	ownership-of-shares-75-to-100-percent
startDate	string	23,296,237	2016-02-26	2016-04-06	2021-02-23
endDate	datetime	2,813,229	1567382400000	None	None
share_minimum	number	17,180,948	10.0	25.0	75.0
share_maximum	number	17,180,948	10.0	50.0	100.0
share_exclusiveMinimum	boolean	15,872,788	None	True	False
share_exclusiveMaximum	boolean	15,872,788	None	False	False
share_exact	number	1,308,160	10.0	None	None

_link	statementID	statementType	personType	birthDate	missingInfoReason
4262153	openownership-register-13517644144389923189	personStatement	knownPerson	1969-03-01	None
3139047	openownership-register-3766383172711602747	personStatement	knownPerson	1985-02-01	None
4274512	openownership-register-17405045311026209330	personStatement	knownPerson	1983-06-01	None
3810226	openownership-register-17871332159014407757	personStatement	knownPerson	1977-03-01	None
5879451	openownership-register-18232639746310812665	personStatement	knownPerson	1972-09-01	None
4612851	openownership-register-13080667707487566765	personStatement	knownPerson	1990-09-01	None
9302778	openownership-register-3297384042461405921	personStatement	knownPerson	None	None
4208858	openownership-register-6722239694455930637	personStatement	knownPerson	1979-08-01	None
1352931	openownership-register-3773994161379160350	personStatement	knownPerson	None	None
1104588	openownership-register-4603859117352895528	personStatement	knownPerson	1996-03-01	None

_link	_link_person_statement	type	fullName
8144562.names.0	8144562	individual	Philip David Dobson
3553423.names.0	3553423	individual	Sarah Anne Maitland
5207939.names.0	5207939	individual	Amanda Jane Henderson
4998662.names.0	4998662	individual	George Payne
8972757.names.0	8972757	individual	Shuk Ching Phyllis Leung
6745952.names.0	6745952	individual	Felix Major Buxton
815774.names.0	815774	individual	Ashok Sheth
5558893.names.0	5558893	individual	Angela Ifeoma Appah
2096271.names.0	2096271	individual	Taylor Pearce
469785.names.0	469785	individual	Lorraine Frew

_link	_link_person_statement	schemeName	id	uri	scheme
4960523.identifiers.0	4960523	GB Persons Of Significant Control Register	/company/13848050/persons-with-significant-control/individual/SLHY3MzAL2z3ObvQ7XkJ_8ic7sM	None	None
8352892.identifiers.0	8352892	GB Persons Of Significant Control Register	/company/10759741/persons-with-significant-control/individual/ZFV4iBXNZ7hy5x_nh_kB6hFm5ek	None	None
6727551.identifiers.0	6727551	GB Persons Of Significant Control Register	/company/09896238/persons-with-significant-control/individual/DF9HbgPijmWeQLt-ZVo2w4MwJYY	None	None
295829.identifiers.0	295829	GB Persons Of Significant Control Register	/company/09143445/persons-with-significant-control/individual/N2m1-F8ZJfy9R4FN9MU6-ue0arA	None	None
4076495.identifiers.1	4076495	OpenOwnership Register	http://register.openownership.org/entities/6011979a9d490b7de9ca992c	http://register.openownership.org/entities/6011979a9d490b7de9ca992c	None
1753438.identifiers.1	1753438	OpenOwnership Register	http://register.openownership.org/entities/5bbb7e329dfc3fae184b4050	http://register.openownership.org/entities/5bbb7e329dfc3fae184b4050	None
5520987.identifiers.1	5520987	OpenOwnership Register	http://register.openownership.org/entities/6368205a11bc7d69612c7ed4	http://register.openownership.org/entities/6368205a11bc7d69612c7ed4	None
486224.identifiers.0	486224	GB Persons Of Significant Control Register	/company/00688000/persons-with-significant-control/individual/vmDdZTp2AaMuEo3tunnsEI51OEk	None	None
2755599.identifiers.1	2755599	OpenOwnership Register	http://register.openownership.org/entities/5da757c29dfc3fae182af074	http://register.openownership.org/entities/5da757c29dfc3fae182af074	None
5357391.identifiers.0	5357391	GB Persons Of Significant Control Register	/company/14149996/persons-with-significant-control/individual/3j7eJGBvTTzaG03KuktyP1wCYFI	None	None

_link	_link_person_statement	name	code
3199262.nationalities.0	3199262	Russian Federation	RU
2538247.nationalities.0	2538247	Saudi Arabia	SA
6819064.nationalities.0	6819064	United Kingdom of Great Britain and Northern Ireland	GB
6847134.nationalities.0	6847134	United Kingdom of Great Britain and Northern Ireland	GB
2242570.nationalities.0	2242570	United Kingdom of Great Britain and Northern Ireland	GB
5681980.nationalities.0	5681980	United Kingdom of Great Britain and Northern Ireland	GB
6434625.nationalities.0	6434625	United Kingdom of Great Britain and Northern Ireland	GB
4914153.nationalities.0	4914153	Indonesia	ID
8927473.nationalities.0	8927473	United Kingdom of Great Britain and Northern Ireland	GB
8554819.nationalities.0	8554819	Spain	ES

_link	_link_person_statement	address	country
7756310.addresses.0	7756310	32 Green Lane, Copnor, Portsmouth, Hampshire, PO3 5EY	GB
7850108.addresses.0	7850108	The Mountbatten School, Whitenap Lane, Romsey, Hampshire, SO51 5SY	None
1992161.addresses.0	1992161	60 Coleshillflats,, Pimlico Road, London, SW1W 8LL	GB
2150279.addresses.0	2150279	63, Meadowcroft Gardens, Westfield, Sheffield, S20 8EJ	GB
9248474.addresses.0	9248474	Suite 14, Waters Edge Business Centre, Maltkiln Road, Barton-Upon-Humber, DN18 5JR	None
2903411.addresses.0	2903411	02034 , м . київ , деснянський р н , вул . драйзера , буд . 36 , кв . 193	UA
8517201.addresses.0	8517201	130, Old Street, London, EC1V 9BD	None
8439448.addresses.0	8439448	28 West Street, Dunstable, Bedfordshire, LU6 1TA	GB
3006511.addresses.0	3006511	85 Great Portland St, Marylebone, Great Portland Street, London, W1W 7LT	None
3325599.addresses.0	3325599	Office 9, Chenevare Mews, High Street, Kinver, DY7 6HF	PH

_link	statementID	statementType	entityType	name	foundingDate	dissolutionDate	incorporatedInJurisdiction_name	incorporatedInJurisdiction_code
7932090	openownership-register-8533532670628554999	entityStatement	registeredEntity	PHONE SPOT LIMITED	1367193600000	1561420800000	United Kingdom of Great Britain and Northern Ireland	GB
1667614	openownership-register-8851830971535014658	entityStatement	registeredEntity	VP MEDIA GROUP LTD	1534809600000	1580169600000	United Kingdom of Great Britain and Northern Ireland	GB
2571275	openownership-register-14422323150782945864	entityStatement	registeredEntity	YASH RAJ LIMITED	1568246400000	None	United Kingdom of Great Britain and Northern Ireland	GB
4788282	openownership-register-1097611733084373976	entityStatement	registeredEntity	HFNRF LTD	1649203200000	None	United Kingdom of Great Britain and Northern Ireland	GB
2945619	openownership-register-1032430847910871067	entityStatement	registeredEntity	AQTREND LTD	1579564800000	None	United Kingdom of Great Britain and Northern Ireland	GB
2659122	openownership-register-3963334062930640783	entityStatement	registeredEntity	ТОВАРИСТВО З ОБМЕЖЕНОЮ ВІДПОВІДАЛЬНІСТЮ "СТРЕЙТКОМПАНІ"	None	None	Ukraine	UA
1324437	openownership-register-10603992523918878041	entityStatement	registeredEntity	Farms Kitcen ApS	1491868800000	None	Denmark	DK
2104396	openownership-register-1504843439873594112	entityStatement	registeredEntity	AQUA SPARKZ LIMITED	1549843200000	1610409600000	United Kingdom of Great Britain and Northern Ireland	GB
2234209	openownership-register-2153628540699641945	entityStatement	registeredEntity	PROJECTED LTD	1554076800000	1662422400000	United Kingdom of Great Britain and Northern Ireland	GB
5901212	openownership-register-16937801392583638985	entityStatement	registeredEntity	INTRABIZ SYSTEMS LIMITED	1163030400000	None	United Kingdom of Great Britain and Northern Ireland	GB

_link	_link_entity_statement	scheme	schemeName	id	uri
2455205.identifiers.0	2455205	GB-COH	Companies House	12102161	None
1607232.identifiers.1	1607232	None	OpenCorporates	https://opencorporates.com/companies/gb/11413528	https://opencorporates.com/companies/gb/11413528
765705.identifiers.2	765705	None	OpenOwnership Register	http://register.openownership.org/entities/5ab94dda9dfc3fae187aaef0	http://register.openownership.org/entities/5ab94dda9dfc3fae187aaef0
5958708.identifiers.2	5958708	None	OpenOwnership Register	http://register.openownership.org/entities/59b95eb567e4ebf34004c114	http://register.openownership.org/entities/59b95eb567e4ebf34004c114
1034795.identifiers.0	1034795	GB-COH	Companies House	11108890	None
5924756.identifiers.2	5924756	None	OpenOwnership Register	http://register.openownership.org/entities/59b9805067e4ebf340aa613e	http://register.openownership.org/entities/59b9805067e4ebf340aa613e
2915659.identifiers.2	2915659	None	OpenOwnership Register	http://register.openownership.org/entities/5e53bc00ac0ca34dfc1c21e8	http://register.openownership.org/entities/5e53bc00ac0ca34dfc1c21e8
7760476.identifiers.3	7760476	None	OpenCorporates	https://opencorporates.com/companies/gb/08083824	https://opencorporates.com/companies/gb/08083824
7109962.identifiers.0	7109962	GB-COH	Companies House	10694204	None
932785.identifiers.35	932785	None	GB Persons Of Significant Control Register	/company/05257193/persons-with-significant-control/corporate-entity/RVBmvPsfHh7NZghQJ_vCTpKU2kY	None

_link	_link_entity_statement	type	address	country
41894.addresses.0	41894	registered	Astoria House, 165-166 Victoria Road, Swindon, SN1 3BU	GB
7474385.addresses.0	7474385	registered	The Nook, Stoney Lane, Witherslack, Cumbria, LA11 6SN	GB
1699388.addresses.0	1699388	registered	Tir Powell Ddu, Nantyglyn Road, Ammanford, SA18 2YT	GB
2124690.addresses.0	2124690	registered	31 Yorath Road, Cardiff, CF14 1QD	GB
8106641.addresses.0	8106641	registered	7 Guilford Street, Brierfield, Nelson, BB9 5LH	GB
5017968.addresses.0	5017968	registered	C/O The Accountancy Partnership Suite 5, 5th Floor, City Reach, 5 Greenwich View Place, London, E14 9NN	GB
3332209.addresses.0	3332209	registered	41 Carisbrooke Road, Mitcham, CR4 1QF	GB
2673608.addresses.0	2673608	registered	Україна, 49000, Дніпропетровська обл., місто Дніпро, ВУЛИЦЯ ФІЛОСОФСЬКА, будинок 16	UA
8651443.addresses.0	8651443	registered	Україна, 77000, Івано-Франківська обл., Рогатинський р-н, місто Рогатин, ВУЛИЦЯ ГАЛИЦЬКА, будинок 126	UA
6661893.addresses.0	6661893	registered	Devonshire House, Manor Way, Borehamwood, Hertfordshire, WD6 1QQ	GB

_link	statementID	statementType	statementDate	subject_describedByEntityStatement	interestedParty_describedByPersonStatement	source_type	source_description	source_url	source_retrievedAt	interestedParty_describedByEntityStatement	interestedParty_unspecified_reason	interestedParty_unspecified_description
1632809	openownership-register-1492795194467550190	ownershipOrControlStatement	2018-04-03	openownership-register-2851377599448525397	openownership-register-11122934435674740960	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
2107342	openownership-register-1055814486145017874	ownershipOrControlStatement	2020-06-24	openownership-register-10044848166466753361	openownership-register-11534974981156086597	officialRegister	DK Centrale Virksomhedsregister	https://cvr.dk	1667767089000	None	None	None
8664614	openownership-register-10727738736022699572	ownershipOrControlStatement	2016-04-06	openownership-register-14202994134851940922	openownership-register-10962283870356409629	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
1886327	openownership-register-6264593010516231884	ownershipOrControlStatement	2020-09-03	openownership-register-4132159948317408934	openownership-register-18013693221027109954	officialRegister	DK Centrale Virksomhedsregister	https://cvr.dk	1659032276000	None	None	None
365943	openownership-register-6772080506489997963	ownershipOrControlStatement	2016-04-06	openownership-register-7407855438997466457	openownership-register-4227706913984958555	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1648592239000	None	None	None
11651483	openownership-register-10474934519496810606	ownershipOrControlStatement	2016-07-06	openownership-register-10272216256202299010	None	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	no-beneficial-owners	No person
3970165	openownership-register-3095650599918935519	ownershipOrControlStatement	2019-10-28	openownership-register-11592921120590968331	openownership-register-11954330217321392843	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1573040663000	None	None	None
8127511	openownership-register-17908176862943164776	ownershipOrControlStatement	2020-01-28	openownership-register-10449260048516927286	openownership-register-6417628112859992681	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1627030075000	None	None	None
5765177	openownership-register-12829299339330208311	ownershipOrControlStatement	2022-08-01	openownership-register-8817859920921589403	openownership-register-9848714735345236347	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1661889569000	None	None	None
10152890	openownership-register-12152194388228993009	ownershipOrControlStatement	2017-01-01	openownership-register-18436341357698119550	openownership-register-7939429640582833430	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None

_link	_link_ooc_statement	type	details	startDate	endDate	share_minimum	share_maximum	share_exclusiveMinimum	share_exclusiveMaximum	share_exact
1906367.interests.0	1906367	shareholding	None	2016-02-26	1567382400000	10.0	10.0	None	None	10.0
7332385.interests.0	7332385	shareholding	ownership-of-shares-25-to-50-percent	2016-04-06	None	25.0	50.0	True	False	None
5452827.interests.0	5452827	shareholding	ownership-of-shares-75-to-100-percent	2021-02-23	None	75.0	100.0	False	False	None
8768748.interests.2	8768748	appointment-of-board	right-to-appoint-and-remove-directors	2016-12-22	None	None	None	None	None	None
794483.interests.2	794483	appointment-of-board	right-to-appoint-and-remove-directors	2016-09-01	None	None	None	None	None	None
1757774.interests.0	1757774	shareholding	ownership-of-shares-75-to-100-percent	2021-06-21	None	75.0	100.0	False	False	None
7164771.interests.2	7164771	influence-or-control	significant-influence-or-control	2016-08-01	None	None	None	None	None	None
5009259.interests.2	5009259	appointment-of-board	right-to-appoint-and-remove-directors	2020-10-02	None	None	None	None	None	None
9988175.interests.2	9988175	appointment-of-board	right-to-appoint-and-remove-directors	2016-04-06	None	None	None	None	None	None
4518388.interests.2	4518388	appointment-of-board	right-to-appoint-and-remove-directors	2020-05-20	None	None	None	None	None	None

Beneficial ownership data analysis tools

Open Ownership Register (2022-11-10)

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.