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-08-31)

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) Big Query Datasette

Tables

person_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,319,930	8602106	287430	6865154
statementID	string	9,319,930	openownership-register-7115732461209686625	openownership-register-9767528387337291356	openownership-register-952282870874405199
statementType	string	9,319,930	personStatement	personStatement	personStatement
personType	string	9,319,930	knownPerson	knownPerson	knownPerson
birthDate	string	8,312,169	1961-09-01	1963-12-01	1966-05-01
missingInfoReason	string	8,120	None	None	None

person_names

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,311,810	6816784.names.0	7295115.names.0	6397160.names.0
_link_person_statement	string	9,311,810	6816784	7295115	6397160
type	string	9,311,810	individual	individual	individual
fullName	string	9,311,810	John Martin Langcaster	Robson Krapp Guimaraes	Victoria Jane Holmes

person_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	19,070,812	2103447.identifiers.1	6806124.identifiers.1	9067375.identifiers.1
_link_person_statement	string	19,070,812	2103447	6806124	9067375
schemeName	string	19,070,812	OpenOwnership Register	OpenOwnership Register	OpenOwnership Register
id	string	19,070,812	http://register.openownership.org/entities/5c3d35129dfc3fae180a17bf	http://register.openownership.org/entities/59b9733367e4ebf34069b68d	http://register.openownership.org/entities/5c11e0069dfc3fae18f3fad8
uri	string	9,311,810	http://register.openownership.org/entities/5c3d35129dfc3fae180a17bf	http://register.openownership.org/entities/59b9733367e4ebf34069b68d	http://register.openownership.org/entities/5c11e0069dfc3fae18f3fad8
scheme	string	447,230	None	None	None

person_nationalities

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	7,392,558	8878482.nationalities.0	5557062.nationalities.0	5954194.nationalities.0
_link_person_statement	string	7,392,558	8878482	5557062	5954194
name	string	7,392,558	United Kingdom of Great Britain and Northern Ireland	United Kingdom of Great Britain and Northern Ireland	United Kingdom of Great Britain and Northern Ireland
code	string	7,392,558	GB	GB	GB

person_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	9,095,703	3505973.addresses.0	2161127.addresses.0	7697136.addresses.0
_link_person_statement	string	9,095,703	3505973	2161127	7697136
address	string	9,095,703	73, Woodhill Park, Pembury, Tunbridge Wells, TN2 4NP	Packwood House, Guild Street, Stratford-Upon-Avon, Warwickshire, CV37 6RP	4, Bankmore Way East, Doogary, Omagh, Co. Tyrone, BT79 0NZ
country	string	4,133,500	None	AU	None

entity_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,513,457	2343298	1965604	248579
statementID	string	8,513,457	openownership-register-12453001269840376759	openownership-register-10202818848227112218	openownership-register-5155414218848716024
statementType	string	8,513,457	entityStatement	entityStatement	entityStatement
entityType	string	8,513,457	registeredEntity	registeredEntity	registeredEntity
name	string	8,466,088	Hyttel Holding ApS	KK FOODS LTD	American International Group, Inc
foundingDate	datetime	7,972,156	1557100800000	1543449600000	1402531200000
dissolutionDate	datetime	1,939,454	None	None	None
incorporatedInJurisdiction_name	string	8,459,137	Denmark	United Kingdom of Great Britain and Northern Ireland	United States of America
incorporatedInJurisdiction_code	string	8,459,137	DK	GB	US

entity_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	26,368,118	3059506.identifiers.1	4344149.identifiers.1	189473.identifiers.1
_link_entity_statement	string	26,368,118	3059506	4344149	189473
scheme	string	8,393,881	None	None	None
schemeName	string	26,368,118	OpenCorporates	OpenCorporates	OpenCorporates
id	string	26,368,117	https://opencorporates.com/companies/gb/05066579	https://opencorporates.com/companies/gb/13647472	https://opencorporates.com/companies/gb/04274599
uri	string	16,877,536	https://opencorporates.com/companies/gb/05066579	https://opencorporates.com/companies/gb/13647472	https://opencorporates.com/companies/gb/04274599

entity_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	8,450,708	4337104.addresses.0	5321096.addresses.0	1668007.addresses.0
_link_entity_statement	string	8,450,708	4337104	5321096	1668007
type	string	8,450,708	registered	registered	registered
address	string	8,450,708	Kongevejen 120, Virum, 2830	7 Park Mews, Spark Street, Stoke On Trent, Staffordshire, ST4 7QF	97 Chelsfield Grove, Chorlton, Manchester, M21 7BD
country	string	8,396,728	DK	GB	GB

ooc_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	12,014,755	9701501	8898210	10810973
statementID	string	12,014,755	openownership-register-9259440536334019357	openownership-register-15178857599401544630	openownership-register-13514220932619045596
statementType	string	12,014,755	ownershipOrControlStatement	ownershipOrControlStatement	ownershipOrControlStatement
statementDate	string	11,286,010	2017-03-21	2016-12-28	2016-04-06
subject_describedByEntityStatement	string	12,014,755	openownership-register-4692750792766831726	openownership-register-7124415246898303264	openownership-register-5292602370645798218
interestedParty_describedByPersonStatement	string	10,740,059	openownership-register-11447001103226135661	openownership-register-6569388391078189657	openownership-register-17457356540832578892
source_type	string	11,898,183	officialRegister	officialRegister	officialRegister
source_description	string	11,898,183	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register	GB Persons Of Significant Control Register
source_url	string	11,898,183	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	11,898,183	1562582231000	1562582231000	1562582231000
interestedParty_describedByEntityStatement	string	734,114	None	None	None
interestedParty_unspecified_reason	string	540,582	None	None	None
interestedParty_unspecified_description	string	540,582	None	None	None

ooc_interests

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	22,774,076	3933804.interests.1	4571388.interests.2	9460380.interests.0
_link_ooc_statement	string	22,774,076	3933804	4571388	9460380
type	string	22,774,076	voting-rights	appointment-of-board	shareholding
details	string	21,479,975	voting-rights-75-to-100-percent	right-to-appoint-and-remove-directors	ownership-of-shares-25-to-50-percent
startDate	string	22,773,099	2019-10-18	2020-06-01	2017-03-06
endDate	datetime	2,713,128	None	None	None
share_minimum	number	16,809,720	75.0	None	25.0
share_maximum	number	16,809,720	100.0	None	50.0
share_exclusiveMinimum	boolean	15,515,663	False	None	True
share_exclusiveMaximum	boolean	15,515,663	False	None	False
share_exact	number	1,294,057	None	None	None

_link	statementID	statementType	personType	birthDate	missingInfoReason
8602106	openownership-register-7115732461209686625	personStatement	knownPerson	1961-09-01	None
287430	openownership-register-9767528387337291356	personStatement	knownPerson	1963-12-01	None
6865154	openownership-register-952282870874405199	personStatement	knownPerson	1966-05-01	None
7804913	openownership-register-18402281315301246453	personStatement	knownPerson	1978-06-01	None
3854456	openownership-register-391298613564591510	personStatement	knownPerson	1981-03-01	None
6446194	openownership-register-13030930839729270961	personStatement	knownPerson	1980-12-01	None
2496376	openownership-register-606880708154499578	personStatement	knownPerson	None	None
7765694	openownership-register-3214973270574490609	personStatement	knownPerson	1961-08-01	None
2856075	openownership-register-2803760073424061098	personStatement	knownPerson	None	None
1009248	openownership-register-15822940167462520860	personStatement	knownPerson	1960-11-01	None

_link	_link_person_statement	type	fullName
6816784.names.0	6816784	individual	John Martin Langcaster
7295115.names.0	7295115	individual	Robson Krapp Guimaraes
6397160.names.0	6397160	individual	Victoria Jane Holmes
547197.names.0	547197	individual	Nicholas William Malyan
412996.names.0	412996	individual	Catherine Alice Stearn
1422158.names.0	1422158	individual	Arne Holm
1120702.names.0	1120702	individual	Gary Paul Wilson
4925424.names.0	4925424	individual	Ian Arnott Thirlwell
1774587.names.0	1774587	individual	Rajan Patel
5986371.names.0	5986371	individual	Tommy Wing-Hon Lai

_link	_link_person_statement	schemeName	id	uri	scheme
2103447.identifiers.1	2103447	OpenOwnership Register	http://register.openownership.org/entities/5c3d35129dfc3fae180a17bf	http://register.openownership.org/entities/5c3d35129dfc3fae180a17bf	None
6806124.identifiers.1	6806124	OpenOwnership Register	http://register.openownership.org/entities/59b9733367e4ebf34069b68d	http://register.openownership.org/entities/59b9733367e4ebf34069b68d	None
9067375.identifiers.1	9067375	OpenOwnership Register	http://register.openownership.org/entities/5c11e0069dfc3fae18f3fad8	http://register.openownership.org/entities/5c11e0069dfc3fae18f3fad8	None
8020609.identifiers.0	8020609	GB Persons Of Significant Control Register	/company/NI645378/persons-with-significant-control/individual/vk4m8x-PtfVuTdGXFKfOVdAl1UE	None	None
4018612.identifiers.0	4018612	GB Persons Of Significant Control Register	/company/13119936/persons-with-significant-control/individual/hzVVzCN3ZYZtriJ9QhBEmROGIBw	None	None
779136.identifiers.0	779136	UA Edinyy Derzhavnyj Reestr	32578255-живчик мирослав орестович	None	None
2325225.identifiers.0	2325225	GB Persons Of Significant Control Register	/company/11913751/persons-with-significant-control/individual/l0hklcTZhmLBQkyDDNsEDqzwhrM	None	None
7855383.identifiers.1	7855383	OpenOwnership Register	http://register.openownership.org/entities/59b9aaf667e4ebf340493b4b	http://register.openownership.org/entities/59b9aaf667e4ebf340493b4b	None
6719854.identifiers.0	6719854	GB Persons Of Significant Control Register	/company/10536129/persons-with-significant-control/individual/UFji2wlQiI8OX-7WlIYQHFV0Gj0	None	None
7978168.identifiers.0	7978168	GB Persons Of Significant Control Register	/company/08987370/persons-with-significant-control/individual/2x0AAH0IdQrZfBHeQzSO1ms4yko	None	None

_link	_link_person_statement	name	code
8878482.nationalities.0	8878482	United Kingdom of Great Britain and Northern Ireland	GB
5557062.nationalities.0	5557062	United Kingdom of Great Britain and Northern Ireland	GB
5954194.nationalities.0	5954194	United Kingdom of Great Britain and Northern Ireland	GB
1684104.nationalities.0	1684104	United Kingdom of Great Britain and Northern Ireland	GB
1692355.nationalities.0	1692355	United Kingdom of Great Britain and Northern Ireland	GB
7867621.nationalities.0	7867621	United Kingdom of Great Britain and Northern Ireland	GB
4228162.nationalities.0	4228162	United Kingdom of Great Britain and Northern Ireland	GB
5104952.nationalities.0	5104952	United Kingdom of Great Britain and Northern Ireland	GB
2429422.nationalities.0	2429422	United Kingdom of Great Britain and Northern Ireland	GB
1758726.nationalities.0	1758726	United Kingdom of Great Britain and Northern Ireland	GB

_link	_link_person_statement	address	country
3505973.addresses.0	3505973	73, Woodhill Park, Pembury, Tunbridge Wells, TN2 4NP	None
2161127.addresses.0	2161127	Packwood House, Guild Street, Stratford-Upon-Avon, Warwickshire, CV37 6RP	AU
7697136.addresses.0	7697136	4, Bankmore Way East, Doogary, Omagh, Co. Tyrone, BT79 0NZ	None
7932097.addresses.0	7932097	International House, 24 Holborn Viaduct, London, EC1A 2BN	GB
3872436.addresses.0	3872436	13, Mervyn Road, Bristol, BS7 9EL	GB
6790768.addresses.0	6790768	14, Bosden Close, Handforth, Wilmslow, SK9 3TG	None
8944676.addresses.0	8944676	7, Erskine Lane, Broughty Ferry, Dundee, Angus, DD5 1DG	GB
519924.addresses.0	519924	82, Savernake Road, London, NW3 2JR	None
4773792.addresses.0	4773792	Suite 3d, Epos House - Heage Road Ind. Estate, Heage Road, Ripley, DE5 3GH	PH
4223468.addresses.0	4223468	88a, Fairbairn Road, Peterlee, SR8 5EW	None

_link	statementID	statementType	entityType	name	foundingDate	dissolutionDate	incorporatedInJurisdiction_name	incorporatedInJurisdiction_code
2343298	openownership-register-12453001269840376759	entityStatement	registeredEntity	Hyttel Holding ApS	1557100800000	None	Denmark	DK
1965604	openownership-register-10202818848227112218	entityStatement	registeredEntity	KK FOODS LTD	1543449600000	None	United Kingdom of Great Britain and Northern Ireland	GB
248579	openownership-register-5155414218848716024	entityStatement	registeredEntity	American International Group, Inc	1402531200000	None	United States of America	US
2980019	openownership-register-11603085387206751716	entityStatement	registeredEntity	ТОВАРИСТВО З ОБМЕЖЕНОЮ ВІДПОВІДАЛЬНІСТЮ "ЕКО ГАРАНТ ПЛЮС"	None	None	Ukraine	UA
8172595	openownership-register-829398765547664507	entityStatement	registeredEntity	ROTHERWOOD RECRUITMENT LLP	1039392000000	None	United Kingdom of Great Britain and Northern Ireland	GB
4413984	openownership-register-11337267988591890454	entityStatement	registeredEntity	FLY LIMITLESS LTD	1635465600000	None	United Kingdom of Great Britain and Northern Ireland	GB
6108040	openownership-register-10743413103013484722	entityStatement	registeredEntity	FOS BRAND MANAGEMENT LIMITED	1261094400000	None	United Kingdom of Great Britain and Northern Ireland	GB
5682968	openownership-register-4035927151359229427	entityStatement	registeredEntity	FARMECO LIMITED	877996800000	None	United Kingdom of Great Britain and Northern Ireland	GB
6673326	openownership-register-5337953621274673285	entityStatement	registeredEntity	VISCERAL OCCLUSION LTD	1392249600000	None	United Kingdom of Great Britain and Northern Ireland	GB
4290138	openownership-register-15223664743684195899	entityStatement	registeredEntity	EASTLAND’S HAULAGE LIMITED	1630972800000	None	United Kingdom of Great Britain and Northern Ireland	GB

_link	_link_entity_statement	scheme	schemeName	id	uri
3059506.identifiers.1	3059506	None	OpenCorporates	https://opencorporates.com/companies/gb/05066579	https://opencorporates.com/companies/gb/05066579
4344149.identifiers.1	4344149	None	OpenCorporates	https://opencorporates.com/companies/gb/13647472	https://opencorporates.com/companies/gb/13647472
189473.identifiers.1	189473	None	OpenCorporates	https://opencorporates.com/companies/gb/04274599	https://opencorporates.com/companies/gb/04274599
6085232.identifiers.0	6085232	GB-COH	Companies House	10532355	None
362662.identifiers.1	362662	None	OpenCorporates	https://opencorporates.com/companies/gb/07938691	https://opencorporates.com/companies/gb/07938691
1248980.identifiers.1	1248980	None	OpenCorporates	https://opencorporates.com/companies/gb/11379069	https://opencorporates.com/companies/gb/11379069
2014652.identifiers.2	2014652	None	OpenOwnership Register	http://register.openownership.org/entities/5c3d2dce9dfc3fae18fc8fb8	http://register.openownership.org/entities/5c3d2dce9dfc3fae18fc8fb8
2329943.identifiers.2	2329943	None	OpenOwnership Register	http://register.openownership.org/entities/5ce703039dfc3fae1822cd98	http://register.openownership.org/entities/5ce703039dfc3fae1822cd98
1885101.identifiers.2	1885101	None	OpenOwnership Register	http://register.openownership.org/entities/5bf41f349dfc3fae18438a07	http://register.openownership.org/entities/5bf41f349dfc3fae18438a07
6747867.identifiers.2	6747867	None	OpenOwnership Register	http://register.openownership.org/entities/59b9957c67e4ebf340faf0f8	http://register.openownership.org/entities/59b9957c67e4ebf340faf0f8

_link	_link_entity_statement	type	address	country
4337104.addresses.0	4337104	registered	Kongevejen 120, Virum, 2830	DK
5321096.addresses.0	5321096	registered	7 Park Mews, Spark Street, Stoke On Trent, Staffordshire, ST4 7QF	GB
1668007.addresses.0	1668007	registered	97 Chelsfield Grove, Chorlton, Manchester, M21 7BD	GB
2347134.addresses.0	2347134	registered	5 Ingham Grove, Hartlepool, Cleveland, TS25 2LH	GB
2216238.addresses.0	2216238	registered	2nd Floor College House, 17 King Edwards Road, Ruislip, London, HA4 7AE	GB
1762598.addresses.0	1762598	registered	Brunel House 340 Firecrest Court, Centre Park, Warrington, Cheshire, WA1 1RG	GB
4936880.addresses.0	4936880	registered	Sycamore House Sutton Quays Business Park, Sutton Weaver, Runcorn, Cheshire, WA7 3EH	GB
3031657.addresses.0	3031657	registered	Apartment 601 Lumiere Building 38 City Road East, Manchester, M15 4QN	GB
600066.addresses.0	600066	registered	Україна, 04086, місто Київ, ВУЛИЦЯ ОЛЕНИ ТЕЛІГИ, будинок 39, квартира 16	UA
4756841.addresses.0	4756841	registered	Vorgodvej 29, Videbæk, 6920	DK

_link	statementID	statementType	statementDate	subject_describedByEntityStatement	interestedParty_describedByPersonStatement	source_type	source_description	source_url	source_retrievedAt	interestedParty_describedByEntityStatement	interestedParty_unspecified_reason	interestedParty_unspecified_description
9701501	openownership-register-9259440536334019357	ownershipOrControlStatement	2017-03-21	openownership-register-4692750792766831726	openownership-register-11447001103226135661	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
8898210	openownership-register-15178857599401544630	ownershipOrControlStatement	2016-12-28	openownership-register-7124415246898303264	openownership-register-6569388391078189657	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
10810973	openownership-register-13514220932619045596	ownershipOrControlStatement	2016-04-06	openownership-register-5292602370645798218	openownership-register-17457356540832578892	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
8080765	openownership-register-1532387455632780463	ownershipOrControlStatement	2016-10-05	openownership-register-14427788195870197196	openownership-register-13814773646807884657	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
973344	openownership-register-3955897684270914465	ownershipOrControlStatement	None	openownership-register-3696368865563795944	openownership-register-11885728601466128242	officialRegister	UA Edinyy Derzhavnyj Reestr	https://data.gov.ua/dataset/1c7f3815-3259-45e0-bdf1-64dca07ddc10	1598460552000	None	None	None
9956365	openownership-register-8829111801553846878	ownershipOrControlStatement	2016-09-14	openownership-register-12050720731074514617	None	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	openownership-register-8202847275028927926	None	None
10139001	openownership-register-10187866437772785377	ownershipOrControlStatement	2017-04-06	openownership-register-18436603087223977637	openownership-register-8664610966132744818	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1620660465000	None	None	None
2540579	openownership-register-16300007845277686828	ownershipOrControlStatement	2018-09-21	openownership-register-2565816325143147085	openownership-register-5782427469185611443	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
121755	openownership-register-16712676137248234547	ownershipOrControlStatement	2016-07-14	openownership-register-15011723946965410881	openownership-register-17914484410891166920	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1562582231000	None	None	None
6873402	openownership-register-4720075941071966326	ownershipOrControlStatement	2022-06-14	openownership-register-3574353615004427920	openownership-register-8826645185720250168	officialRegister	GB Persons Of Significant Control Register	http://download.companieshouse.gov.uk/en_pscdata.html	1656459201000	None	None	None

_link	_link_ooc_statement	type	details	startDate	endDate	share_minimum	share_maximum	share_exclusiveMinimum	share_exclusiveMaximum	share_exact
3933804.interests.1	3933804	voting-rights	voting-rights-75-to-100-percent	2019-10-18	None	75.0	100.0	False	False	None
4571388.interests.2	4571388	appointment-of-board	right-to-appoint-and-remove-directors	2020-06-01	None	None	None	None	None	None
9460380.interests.0	9460380	shareholding	ownership-of-shares-25-to-50-percent	2017-03-06	None	25.0	50.0	True	False	None
10951177.interests.2	10951177	appointment-of-board	right-to-appoint-and-remove-directors	2017-06-23	None	None	None	None	None	None
4928937.interests.0	4928937	shareholding	ownership-of-shares-25-to-50-percent	2020-09-14	None	25.0	50.0	True	False	None
5084835.interests.2	5084835	appointment-of-board	right-to-appoint-and-remove-directors	2020-10-28	None	None	None	None	None	None
3091482.interests.0	3091482	shareholding	ownership-of-shares-25-to-50-percent	2019-02-22	None	25.0	50.0	True	False	None
7141324.interests.0	7141324	shareholding	ownership-of-shares-75-to-100-percent	2017-04-06	None	75.0	100.0	False	False	None
6701305.interests.0	6701305	shareholding	ownership-of-shares-75-to-100-percent	2022-03-29	None	75.0	100.0	False	False	None
10642482.interests.1	10642482	voting-rights	voting-rights-75-to-100-percent	2017-05-20	None	75.0	100.0	False	False	None

Beneficial ownership data analysis tools

Open Ownership Register (2022-08-31)

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.