Open Ownership Register (2023-01-09)

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 string 9,672,329 7366598 8136808 8348605
statementID string 9,672,329 openownership-register-8698931419705717117 openownership-register-7309202726427286641 openownership-register-14528435899325948870
statementType string 9,672,329 personStatement personStatement personStatement
personType string 9,672,329 knownPerson knownPerson knownPerson
birthDate string 8,655,645 1969-01-01 1958-12-01 1980-03-01
missingInfoReason string 8,089 None None None
person_names
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,664,240 9363563.names.0 148889.names.0 8462675.names.0
_link_person_statement string 9,664,240 9363563 148889 8462675
type string 9,664,240 individual individual individual
fullName string 9,664,240 Kevin Charles Miree Philip John Moxom Raymond Owen Wareham
person_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 19,788,798 1838659.identifiers.0 4100348.identifiers.1 4145761.identifiers.0
_link_person_statement string 19,788,798 1838659 4100348 4145761
schemeName string 19,788,798 GB Persons Of Significant Control Register OpenOwnership Register GB Persons Of Significant Control Register
id string 19,788,798 /company/11445800/persons-with-significant-control/individual/8uy3pIjB09EQ9kpp_dRkZJAxYoU http://register.openownership.org/entities/604ba715fcb54a9955e88ab5 /company/13206213/persons-with-significant-control/individual/PLOO6DX5fPRY8fsLTjKEhcAoVTI
uri string 9,664,240 None http://register.openownership.org/entities/604ba715fcb54a9955e88ab5 None
scheme string 460,356 None None None
person_nationalities
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 7,689,084 1976521.nationalities.0 7377095.nationalities.0 8997575.nationalities.0
_link_person_statement string 7,689,084 1976521 7377095 8997575
name string 7,689,084 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,689,084 GB GB GB
person_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,445,314 279938.addresses.0 7248898.addresses.0 1380362.addresses.0
_link_person_statement string 9,445,314 279938 7248898 1380362
address string 9,445,314 18 Egan Way, Hayes, UB3 1LG Bhi Parkside, Stourbridge Road, Bromsgrove, B61 0AZ Vænget 14, Hillerød, 3400
country string 4,269,477 GB GB DK
entity_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,793,112 8737390 1661625 8280959
statementID string 8,793,112 openownership-register-27031132602572933 openownership-register-5600594043062890368 openownership-register-7614121442392797580
statementType string 8,793,112 entityStatement entityStatement entityStatement
entityType string 8,793,112 registeredEntity registeredEntity registeredEntity
name string 8,638,363 ТОВАРИСТВО З ОБМЕЖЕНОЮ ВІДПОВІДАЛЬНІСТЮ "ТОКА УКРАЇНА" CAMBRIDGE CAPITAL PARTNERS LIMITED LECRAM LIMITED
foundingDate datetime 8,142,038 None 1534464000000 1504137600000
dissolutionDate datetime 2,222,398 None None None
incorporatedInJurisdiction_name string 8,736,352 Ukraine United Kingdom of Great Britain and Northern Ireland United Kingdom of Great Britain and Northern Ireland
incorporatedInJurisdiction_code string 8,736,352 UA GB GB
entity_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 27,129,516 5902784.identifiers.2 1317910.identifiers.2 3691415.identifiers.1
_link_entity_statement string 27,129,516 5902784 1317910 3691415
scheme string 8,667,631 None None None
schemeName string 27,129,516 OpenOwnership Register OpenOwnership Register OpenCorporates
id string 27,129,515 http://register.openownership.org/entities/59b9540e67e4ebf340d277aa http://register.openownership.org/entities/5b5f325b9dfc3fae1816d34e https://opencorporates.com/companies/gb/13054916
uri string 17,327,144 http://register.openownership.org/entities/59b9540e67e4ebf340d277aa http://register.openownership.org/entities/5b5f325b9dfc3fae1816d34e https://opencorporates.com/companies/gb/13054916
entity_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,626,027 7851733.addresses.0 7001450.addresses.0 1474101.addresses.0
_link_entity_statement string 8,626,027 7851733 7001450 1474101
type string 8,626,027 registered registered registered
address string 8,626,027 First Floor Rear Office, 13 Comberton Hill, Kidderminster, DY10 1QG 92 Norwich Road, Salhouse, Norwich, Norfolk, NR13 6PB c/o Mikkel Hjuler, Bakkegårdsvej 2, Brøndby, 2605
country string 8,569,607 GB GB DK
ooc_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 12,423,629 2895194 11807278 3777741
statementID string 12,423,629 openownership-register-13533817558687811296 openownership-register-15506007862764878289 openownership-register-2352710816561922389
statementType string 12,423,629 ownershipOrControlStatement ownershipOrControlStatement ownershipOrControlStatement
statementDate string 11,689,128 2019-06-02 2022-04-26 2019-10-01
subject_describedByEntityStatement string 12,423,629 openownership-register-5706740620930347129 openownership-register-9352528057918020300 openownership-register-693075140732460979
interestedParty_describedByPersonStatement string 11,106,220 openownership-register-1730734416164937589 openownership-register-3335207602553841578 openownership-register-15119111458086967927
source_type string 12,301,300 officialRegister officialRegister officialRegister
source_description string 12,301,300 GB Persons Of Significant Control Register SK Register Partnerov Verejného Sektora GB Persons Of Significant Control Register
source_url string 12,301,300 http://download.companieshouse.gov.uk/en_pscdata.html https://rpvs.gov.sk/ http://download.companieshouse.gov.uk/en_pscdata.html
source_retrievedAt datetime 12,301,300 1639678054000 1673107260000 1603708816000
interestedParty_describedByEntityStatement string 759,578 None None None
interestedParty_unspecified_reason string 557,831 None None None
interestedParty_unspecified_description string 557,831 None None None
ooc_interests
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 23,787,517 4273297.interests.1 8637873.interests.2 7671746.interests.1
_link_ooc_statement string 23,787,517 4273297 8637873 7671746
type string 23,787,517 voting-rights appointment-of-board voting-rights
details string 22,458,787 voting-rights-25-to-50-percent right-to-appoint-and-remove-directors voting-rights-25-to-50-percent
startDate string 23,786,540 2020-01-27 2016-04-06 2016-04-06
endDate datetime 2,906,732 None None None
share_minimum number 17,530,568 25.0 None 25.0
share_maximum number 17,530,568 50.0 None 50.0
share_exclusiveMinimum boolean 16,201,882 True None True
share_exclusiveMaximum boolean 16,201,882 False None False
share_exact number 1,328,686 None None None