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.

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