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