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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |