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 (2023-03-08)

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	integer	9,871,310	163671	1320708	2267744
statementID	string	9,871,310	openownership-register-4945895447970560629	openownership-register-758181764517381676	openownership-register-10271069979635540386
statementType	string	9,871,310	personStatement	personStatement	personStatement
personType	string	9,871,310	knownPerson	knownPerson	knownPerson
birthDate	date	8,850,347	370742400000	144547200000	236563200000
missingInfoReason	string	8,070	None	None	None

person_names

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,863,240	1594272.names.0	9125511.names.0	1117370.names.0
_link_person_statement	integer	9,863,240	1594272	9125511	1117370
type	string	9,863,240	individual	individual	individual
fullName	string	9,863,240	Bent Ketelsen	Vikram Pal Singh	Edvinas Fomkinas

person_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	20,192,286	4246084.identifiers.1	1916723.identifiers.1	8054585.identifiers.0
_link_person_statement	integer	20,192,286	4246084	1916723	8054585
schemeName	string	20,192,286	OpenOwnership Register	OpenOwnership Register	GB Persons Of Significant Control Register
id	string	20,192,286	http://register.openownership.org/entities/60772104e0d32d2147b50f81	http://register.openownership.org/entities/5bbca6229dfc3fae18672435	/company/07538151/persons-with-significant-control/individual/9yYMJObioKMsHBRWUS4M9C1tOHw
uri	string	9,863,240	http://register.openownership.org/entities/60772104e0d32d2147b50f81	http://register.openownership.org/entities/5bbca6229dfc3fae18672435	None
scheme	string	465,844	None	None	None

person_nationalities

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	7,857,649	2494398.nationalities.0	6917715.nationalities.0	4642002.nationalities.0
_link_person_statement	integer	7,857,649	2494398	6917715	4642002
name	string	7,857,649	Malaysia	United Kingdom of Great Britain and Northern Ireland	Philippines
code	string	7,857,649	MY	GB	PH

person_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,643,856	1051644.addresses.0	6332647.addresses.0	3827735.addresses.0
_link_person_statement	integer	9,643,856	1051644	6332647	3827735
address	string	9,643,856	Brunel House, 340 Firecrest Court, Centre Park, Warrington, Cheshire, WA1 1RG	25, Churchill Place, London, E14 5RE	68, Nightingales, Bishop's Stortford, CM23 5JQ
country	string	4,343,870	GB	None	None

entity_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	integer	8,960,075	59702	2897927	5045423
statementID	string	8,960,075	openownership-register-4319121063085762913	openownership-register-11602617403019192515	openownership-register-15554147721508028730
statementType	string	8,960,075	entityStatement	entityStatement	entityStatement
entityType	string	8,960,075	registeredEntity	registeredEntity	registeredEntity
name	string	8,756,918	TF 247 TRANSPORT LTD	YNNI TRAINING LTD	BESTCOMMU LTD
foundingDate	date	8,258,679	1405382400000	1578960000000	1658620800000
dissolutionDate	date	2,230,225	1530576000000	1620086400000	None
incorporatedInJurisdiction_name	string	8,902,077	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,902,077	GB	GB	GB

entity_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	27,596,989	6630491.identifiers.1	6043445.identifiers.2	3612202.identifiers.1
_link_entity_statement	integer	27,596,989	6630491	6043445	3612202
scheme	string	8,831,840	None	None	None
schemeName	string	27,596,989	OpenCorporates	OpenOwnership Register	OpenCorporates
id	string	27,596,988	https://opencorporates.com/companies/gb/10545511	http://register.openownership.org/entities/59b9526e67e4ebf340cb32d8	https://opencorporates.com/companies/gb/SC680252
uri	string	17,610,801	https://opencorporates.com/companies/gb/10545511	http://register.openownership.org/entities/59b9526e67e4ebf340cb32d8	https://opencorporates.com/companies/gb/SC680252

entity_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,745,134	766160.addresses.0	3556478.addresses.0	5569115.addresses.0
_link_entity_statement	integer	8,745,134	766160	3556478	5569115
type	string	8,745,134	registered	registered	registered
address	string	8,745,134	10a Station Road, New Barnet, Barnet, EN5 1QW	163 Kempton Road, London, E6 2NF	The Manor Main Street, Grove, Wantage, OX12 7JJ
country	string	8,687,476	GB	GB	GB

ooc_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	integer	12,660,987	12281172	10728253	2396302
statementID	string	12,660,987	openownership-register-15501609456432491414	openownership-register-12918206102438252362	openownership-register-2231518007419938790
statementType	string	12,660,987	ownershipOrControlStatement	ownershipOrControlStatement	ownershipOrControlStatement
statementDate	string	11,923,763	2017-09-19	2021-09-30	2018-06-14
subject_describedByEntityStatement	string	12,660,987	openownership-register-15301216103625934815	openownership-register-948216059812195874	openownership-register-16195557385655786608
interestedParty_describedByPersonStatement	string	11,311,671	openownership-register-10099134035030007352	openownership-register-6026026371026165149	None
source_type	string	12,535,888	officialRegister	officialRegister	officialRegister
source_description	string	12,535,888	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register
source_url	string	12,535,888	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	datetime	12,535,888	1595860940000	1645656644000	1562582231000
interestedParty_describedByEntityStatement	string	772,658	None	None	openownership-register-17132193358681640173
interestedParty_unspecified_reason	string	576,658	None	None	None
interestedParty_unspecified_description	string	576,658	None	None	None

ooc_interests

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	24,362,677	5742174.interests.0	10474538.interests.1	8223592.interests.1
_link_ooc_statement	integer	24,362,677	5742174	10474538	8223592
type	string	24,362,677	shareholding	voting-rights	voting-rights
details	string	23,017,329	ownership-of-shares-25-to-50-percent	voting-rights-25-to-50-percent	voting-rights-75-to-100-percent
startDate	date	24,361,700	1620345600000	1459900800000	1674432000000
share_minimum	number	17,938,275	25.0	25.0	75.0
share_maximum	number	17,938,275	50.0	50.0	100.0
share_exclusiveMinimum	boolean	16,592,971	True	True	False
share_exclusiveMaximum	boolean	16,592,971	False	False	False
endDate	date	2,999,638	None	None	None
share_exact	number	1,345,304	None	None	None

_link	statementID	statementType	personType	birthDate	missingInfoReason
163671	openownership-register-4945895447970560629	personStatement	knownPerson	370742400000	None
1320708	openownership-register-758181764517381676	personStatement	knownPerson	144547200000	None
2267744	openownership-register-10271069979635540386	personStatement	knownPerson	236563200000	None
5610492	openownership-register-10862633159836508216	personStatement	knownPerson	170812800000	None
2391832	openownership-register-7148504413668362558	personStatement	knownPerson	-247363200000	None
3242872	openownership-register-8772461058760855675	personStatement	knownPerson	641520000000	None
2725823	openownership-register-8601295675995766009	personStatement	knownPerson	302313600000	None
6205048	openownership-register-17639473407472695924	personStatement	knownPerson	-57974400000	None
6079962	openownership-register-13185015379024446589	personStatement	knownPerson	-23760000000	None
6676314	openownership-register-7528135308900078014	personStatement	knownPerson	-334108800000	None

_link	_link_person_statement	type	fullName
1594272.names.0	1594272	individual	Bent Ketelsen
9125511.names.0	9125511	individual	Vikram Pal Singh
1117370.names.0	1117370	individual	Edvinas Fomkinas
5121209.names.0	5121209	individual	Nicholas Abson
6452921.names.0	6452921	individual	Yasin Amin
2676021.names.0	2676021	individual	Jade N/A Hylton
689877.names.0	689877	individual	герасимов дмитро геннадійович
6747866.names.0	6747866	individual	Peter John Horgan
9144352.names.0	9144352	individual	Barry Stoddart
3741575.names.0	3741575	individual	Ionel Dorin Codrea

_link	_link_person_statement	schemeName	id	uri	scheme
4246084.identifiers.1	4246084	OpenOwnership Register	http://register.openownership.org/entities/60772104e0d32d2147b50f81	http://register.openownership.org/entities/60772104e0d32d2147b50f81	None
1916723.identifiers.1	1916723	OpenOwnership Register	http://register.openownership.org/entities/5bbca6229dfc3fae18672435	http://register.openownership.org/entities/5bbca6229dfc3fae18672435	None
8054585.identifiers.0	8054585	GB Persons Of Significant Control Register	/company/07538151/persons-with-significant-control/individual/9yYMJObioKMsHBRWUS4M9C1tOHw	None	None
5243797.identifiers.0	5243797	GB Persons Of Significant Control Register	/company/14041141/persons-with-significant-control/individual/gFZXI_58U9Q6ZeQId_k_cVFU2Mc	None	None
537340.identifiers.1	537340	OpenOwnership Register	http://register.openownership.org/entities/59b935db67e4ebf3404b02b7	http://register.openownership.org/entities/59b935db67e4ebf3404b02b7	None
6633229.identifiers.1	6633229	OpenOwnership Register	http://register.openownership.org/entities/59b9524867e4ebf340caa165	http://register.openownership.org/entities/59b9524867e4ebf340caa165	None
4578659.identifiers.1	4578659	OpenOwnership Register	http://register.openownership.org/entities/610bef6a7b8c39f3d2f4aa67	http://register.openownership.org/entities/610bef6a7b8c39f3d2f4aa67	None
2399946.identifiers.1	2399946	OpenOwnership Register	http://register.openownership.org/entities/5cccbf579dfc3fae18f62754	http://register.openownership.org/entities/5cccbf579dfc3fae18f62754	None
4333473.identifiers.0	4333473	GB Persons Of Significant Control Register	/company/13346434/persons-with-significant-control/individual/Mk2v53usKhYd508oyqu-ToHhChc	None	None
2898519.identifiers.1	2898519	OpenOwnership Register	http://register.openownership.org/entities/5dae30839dfc3fae18816cf7	http://register.openownership.org/entities/5dae30839dfc3fae18816cf7	None

_link	_link_person_statement	name	code
2494398.nationalities.0	2494398	Malaysia	MY
6917715.nationalities.0	6917715	United Kingdom of Great Britain and Northern Ireland	GB
4642002.nationalities.0	4642002	Philippines	PH
5528966.nationalities.0	5528966	United Kingdom of Great Britain and Northern Ireland	GB
3922897.nationalities.0	3922897	Morocco	MA
8070964.nationalities.0	8070964	United Kingdom of Great Britain and Northern Ireland	GB
8040301.nationalities.0	8040301	Lithuania	LT
2245269.nationalities.0	2245269	United Kingdom of Great Britain and Northern Ireland	GB
2941020.nationalities.0	2941020	Spain	ES
5477960.nationalities.0	5477960	United Kingdom of Great Britain and Northern Ireland	GB

_link	_link_person_statement	address	country
1051644.addresses.0	1051644	Brunel House, 340 Firecrest Court, Centre Park, Warrington, Cheshire, WA1 1RG	GB
6332647.addresses.0	6332647	25, Churchill Place, London, E14 5RE	None
3827735.addresses.0	3827735	68, Nightingales, Bishop's Stortford, CM23 5JQ	None
5523339.addresses.0	5523339	20, Shaftesbury Avenue, Bradford, BD9 6AJ	None
7191071.addresses.0	7191071	472 West Wycombe Road, High Wycombe, Buckinghamshire, HP12 4AH	None
5912822.addresses.0	5912822	17, Millbank Avenue, Bishopton, PA5 7NE	None
2118273.addresses.0	2118273	5, Brampton Gardens, Hatch Warren, Basingstoke, RG22 4RL	GB
2630754.addresses.0	2630754	71/1, Topsia Road South, Gobinda Khatick Road, Kolkata, 700046	IN
7525233.addresses.0	7525233	446 Cheetham Hill Road, Manchester, M8 9LE	None
4600731.addresses.0	4600731	Thrunscoe House, Thrunscoe Road, Cleethorpes, Lincolnshire, DN35 8TA	None

_link	statementID	statementType	entityType	name	foundingDate	dissolutionDate	incorporatedInJurisdiction_name	incorporatedInJurisdiction_code
59702	openownership-register-4319121063085762913	entityStatement	registeredEntity	TF 247 TRANSPORT LTD	1405382400000	1530576000000	United Kingdom of Great Britain and Northern Ireland	GB
2897927	openownership-register-11602617403019192515	entityStatement	registeredEntity	YNNI TRAINING LTD	1578960000000	1620086400000	United Kingdom of Great Britain and Northern Ireland	GB
5045423	openownership-register-15554147721508028730	entityStatement	registeredEntity	BESTCOMMU LTD	1658620800000	None	United Kingdom of Great Britain and Northern Ireland	GB
5931513	openownership-register-7928188503874355816	entityStatement	registeredEntity	HBLR LIMITED	1675814400000	None	United Kingdom of Great Britain and Northern Ireland	GB
6026695	openownership-register-2480676392733134990	entityStatement	registeredEntity	COLCHESTER TRUCK HIRE LIMITED	1441065600000	1508198400000	United Kingdom of Great Britain and Northern Ireland	GB
5696638	openownership-register-1782595191737700295	entityStatement	registeredEntity	None	None	None	United Kingdom of Great Britain and Northern Ireland	GB
7822469	openownership-register-17801708760542154948	entityStatement	registeredEntity	CHOBE HOMES LIMITED	800064000000	None	United Kingdom of Great Britain and Northern Ireland	GB
4864216	openownership-register-993230360817630192	entityStatement	registeredEntity	KATHON HEALTHCARE LTD	1651708800000	None	United Kingdom of Great Britain and Northern Ireland	GB
6643804	openownership-register-10604199494494931332	entityStatement	registeredEntity	DANCE IN MOTION LTD	1294185600000	None	United Kingdom of Great Britain and Northern Ireland	GB
6082281	openownership-register-1833297963940505451	entityStatement	registeredEntity	CEP ANALYTICS LTD	1430438400000	1658188800000	United Kingdom of Great Britain and Northern Ireland	GB

_link	_link_entity_statement	scheme	schemeName	id	uri
6630491.identifiers.1	6630491	None	OpenCorporates	https://opencorporates.com/companies/gb/10545511	https://opencorporates.com/companies/gb/10545511
6043445.identifiers.2	6043445	None	OpenOwnership Register	http://register.openownership.org/entities/59b9526e67e4ebf340cb32d8	http://register.openownership.org/entities/59b9526e67e4ebf340cb32d8
3612202.identifiers.1	3612202	None	OpenCorporates	https://opencorporates.com/companies/gb/SC680252	https://opencorporates.com/companies/gb/SC680252
7798287.identifiers.2	7798287	None	OpenOwnership Register	http://register.openownership.org/entities/59b9bad267e4ebf34086a3f8	http://register.openownership.org/entities/59b9bad267e4ebf34086a3f8
6164939.identifiers.1	6164939	None	OpenCorporates	https://opencorporates.com/companies/gb/10616262	https://opencorporates.com/companies/gb/10616262
5242716.identifiers.2	5242716	None	OpenOwnership Register	http://register.openownership.org/entities/59b93c1b67e4ebf34067ce6d	http://register.openownership.org/entities/59b93c1b67e4ebf34067ce6d
3863013.identifiers.2	3863013	None	OpenOwnership Register	http://register.openownership.org/entities/604bcedffcb54a9955307ac0	http://register.openownership.org/entities/604bcedffcb54a9955307ac0
1397867.identifiers.1	1397867	None	OpenCorporates	https://opencorporates.com/companies/dk/26463912	https://opencorporates.com/companies/dk/26463912
7771120.identifiers.0	7771120	GB-COH	Companies House	10145845	None
8585363.identifiers.1	8585363	None	OpenCorporates	https://opencorporates.com/companies/gb/10458669	https://opencorporates.com/companies/gb/10458669

_link	_link_entity_statement	type	address	country
766160.addresses.0	766160	registered	10a Station Road, New Barnet, Barnet, EN5 1QW	GB
3556478.addresses.0	3556478	registered	163 Kempton Road, London, E6 2NF	GB
5569115.addresses.0	5569115	registered	The Manor Main Street, Grove, Wantage, OX12 7JJ	GB
3581489.addresses.0	3581489	registered	3 Adenfield Way, Rhoose, Barry, CF62 3EA	GB
6866834.addresses.0	6866834	registered	Lindsay House, 10 Callender Street, Belfast, BT1 5BN	GB
4881473.addresses.0	4881473	registered	3 Stretton Close, Wigan, Greater Manchester, WN6 0UG	GB
6452114.addresses.0	6452114	registered	Southridge 21 Fontwell Gardens, Horton Heath, Eastleigh, Hampshire, SO50 7NL	GB
7276901.addresses.0	7276901	registered	Wellington House 273-275 High Street, London Colney, St Albans, Hertfordshire, AL2 1HA	GB
1004905.addresses.0	1004905	registered	19 Ringbury, Lymington, Hampshire, SO41 9FH	GB
5158558.addresses.0	5158558	registered	Second Floor 2 The Waterhouse, Waterhouse Street, Hemel Hempstead, HP1 1ES	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
12281172	openownership-register-15501609456432491414	ownershipOrControlStatement	2017-09-19	openownership-register-15301216103625934815	openownership-register-10099134035030007352	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1595860940000	None	None	None
10728253	openownership-register-12918206102438252362	ownershipOrControlStatement	2021-09-30	openownership-register-948216059812195874	openownership-register-6026026371026165149	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1645656644000	None	None	None
2396302	openownership-register-2231518007419938790	ownershipOrControlStatement	2018-06-14	openownership-register-16195557385655786608	None	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	openownership-register-17132193358681640173	None	None
1437065	openownership-register-10719127584262197718	ownershipOrControlStatement	2017-11-22	openownership-register-2342429727275592377	openownership-register-8602560916168953889	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1648592239000	None	None	None
8019501	openownership-register-15234344581987697994	ownershipOrControlStatement	2022-11-07	openownership-register-7803905634447158912	openownership-register-10493107226856491541	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1670198109000	None	None	None
9498925	openownership-register-9349822336995890569	ownershipOrControlStatement	2016-04-06	openownership-register-17701863343267182863	openownership-register-16787482064472972099	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
10312019	openownership-register-85075362417742876	ownershipOrControlStatement	2016-04-06	openownership-register-3045292514310389100	openownership-register-4764229433472563733	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
6026013	openownership-register-12959928972931327244	ownershipOrControlStatement	2021-08-05	openownership-register-926540149724073764	openownership-register-10031757511704861345	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1665009567000	None	None	None
599458	openownership-register-8408900508061773287	ownershipOrControlStatement	2016-04-06	openownership-register-17590042329390564523	openownership-register-10350077599601016243	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
5682562	openownership-register-2092810481016242538	ownershipOrControlStatement	2021-04-16	openownership-register-1875009889145713256	openownership-register-9966601253223153955	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1620660465000	None	None	None

_link	_link_ooc_statement	type	details	startDate	share_minimum	share_maximum	share_exclusiveMinimum	share_exclusiveMaximum	endDate	share_exact
5742174.interests.0	5742174	shareholding	ownership-of-shares-25-to-50-percent	1620345600000	25.0	50.0	True	False	None	None
10474538.interests.1	10474538	voting-rights	voting-rights-25-to-50-percent	1459900800000	25.0	50.0	True	False	None	None
8223592.interests.1	8223592	voting-rights	voting-rights-75-to-100-percent	1674432000000	75.0	100.0	False	False	None	None
485398.interests.0	485398	influence-or-control	significant-influence-or-control	1467331200000	None	None	None	None	None	None
1247774.interests.0	1247774	influence-or-control	significant-influence-or-control	1520985600000	None	None	None	None	None	None
3829108.interests.0	3829108	shareholding	ownership-of-shares-25-to-50-percent	1571097600000	25.0	50.0	True	False	None	None
8827135.interests.1	8827135	voting-rights	voting-rights-75-to-100-percent-as-firm	1479945600000	75.0	100.0	False	False	None	None
9849498.interests.0	9849498	shareholding	ownership-of-shares-50-to-75-percent	1459900800000	50.0	75.0	True	True	None	None
8184765.interests.0	8184765	shareholding	ownership-of-shares-75-to-100-percent	1673308800000	75.0	100.0	False	False	None	None
5876892.interests.2	5876892	appointment-of-board	right-to-appoint-and-remove-directors	1624320000000	None	None	None	None	None	None

Beneficial ownership data analysis tools

Open Ownership Register (2023-03-08)

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.