Open Ownership Register (2022-11-10)

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,501,956 4262153 3139047 4274512
statementID string 9,501,956 openownership-register-13517644144389923189 openownership-register-3766383172711602747 openownership-register-17405045311026209330
statementType string 9,501,956 personStatement personStatement personStatement
personType string 9,501,956 knownPerson knownPerson knownPerson
birthDate string 8,490,407 1969-03-01 1985-02-01 1983-06-01
missingInfoReason string 8,109 None None None
person_names
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,493,847 8144562.names.0 3553423.names.0 5207939.names.0
_link_person_statement string 9,493,847 8144562 3553423 5207939
type string 9,493,847 individual individual individual
fullName string 9,493,847 Philip David Dobson Sarah Anne Maitland Amanda Jane Henderson
person_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 19,440,090 4960523.identifiers.0 8352892.identifiers.0 6727551.identifiers.0
_link_person_statement string 19,440,090 4960523 8352892 6727551
schemeName string 19,440,090 GB Persons Of Significant Control Register GB Persons Of Significant Control Register GB Persons Of Significant Control Register
id string 19,440,090 /company/13848050/persons-with-significant-control/individual/SLHY3MzAL2z3ObvQ7XkJ_8ic7sM /company/10759741/persons-with-significant-control/individual/ZFV4iBXNZ7hy5x_nh_kB6hFm5ek /company/09896238/persons-with-significant-control/individual/DF9HbgPijmWeQLt-ZVo2w4MwJYY
uri string 9,493,847 None None None
scheme string 452,434 None None None
person_nationalities
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 7,546,417 3199262.nationalities.0 2538247.nationalities.0 6819064.nationalities.0
_link_person_statement string 7,546,417 3199262 2538247 6819064
name string 7,546,417 Russian Federation Saudi Arabia United Kingdom of Great Britain and Northern Ireland
code string 7,546,417 RU SA GB
person_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,276,366 7756310.addresses.0 7850108.addresses.0 1992161.addresses.0
_link_person_statement string 9,276,366 7756310 7850108 1992161
address string 9,276,366 32 Green Lane, Copnor, Portsmouth, Hampshire, PO3 5EY The Mountbatten School, Whitenap Lane, Romsey, Hampshire, SO51 5SY 60 Coleshillflats,, Pimlico Road, London, SW1W 8LL
country string 4,201,960 GB None GB
entity_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,655,537 7932090 1667614 2571275
statementID string 8,655,537 openownership-register-8533532670628554999 openownership-register-8851830971535014658 openownership-register-14422323150782945864
statementType string 8,655,537 entityStatement entityStatement entityStatement
entityType string 8,655,537 registeredEntity registeredEntity registeredEntity
name string 8,541,615 PHONE SPOT LIMITED VP MEDIA GROUP LTD YASH RAJ LIMITED
foundingDate datetime 8,046,952 1367193600000 1534809600000 1568246400000
dissolutionDate datetime 1,955,857 1561420800000 1580169600000 None
incorporatedInJurisdiction_name string 8,599,989 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,599,989 GB GB GB
entity_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 26,742,907 2455205.identifiers.0 1607232.identifiers.1 765705.identifiers.2
_link_entity_statement string 26,742,907 2455205 1607232 765705
scheme string 8,532,769 GB-COH None None
schemeName string 26,742,907 Companies House OpenCorporates OpenOwnership Register
id string 26,742,906 12102161 https://opencorporates.com/companies/gb/11413528 http://register.openownership.org/entities/5ab94dda9dfc3fae187aaef0
uri string 17,094,448 None https://opencorporates.com/companies/gb/11413528 http://register.openownership.org/entities/5ab94dda9dfc3fae187aaef0
entity_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,528,618 41894.addresses.0 7474385.addresses.0 1699388.addresses.0
_link_entity_statement string 8,528,618 41894 7474385 1699388
type string 8,528,618 registered registered registered
address string 8,528,618 Astoria House, 165-166 Victoria Road, Swindon, SN1 3BU The Nook, Stoney Lane, Witherslack, Cumbria, LA11 6SN Tir Powell Ddu, Nantyglyn Road, Ammanford, SA18 2YT
country string 8,473,410 GB GB GB
ooc_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 12,221,360 1632809 2107342 8664614
statementID string 12,221,360 openownership-register-1492795194467550190 openownership-register-1055814486145017874 openownership-register-10727738736022699572
statementType string 12,221,360 ownershipOrControlStatement ownershipOrControlStatement ownershipOrControlStatement
statementDate string 11,489,476 2018-04-03 2020-06-24 2016-04-06
subject_describedByEntityStatement string 12,221,360 openownership-register-2851377599448525397 openownership-register-10044848166466753361 openownership-register-14202994134851940922
interestedParty_describedByPersonStatement string 10,927,656 openownership-register-11122934435674740960 openownership-register-11534974981156086597 openownership-register-10962283870356409629
source_type string 12,101,648 officialRegister officialRegister officialRegister
source_description string 12,101,648 GB Persons Of Significant Control Register DK Centrale Virksomhedsregister GB Persons Of Significant Control Register
source_url string 12,101,648 http://download.companieshouse.gov.uk/en_pscdata.html https://cvr.dk http://download.companieshouse.gov.uk/en_pscdata.html
source_retrievedAt datetime 12,101,648 1562582231000 1667767089000 1562582231000
interestedParty_describedByEntityStatement string 746,704 None None None
interestedParty_unspecified_reason string 547,000 None None None
interestedParty_unspecified_description string 547,000 None None None
ooc_interests
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 23,297,214 1906367.interests.0 7332385.interests.0 5452827.interests.0
_link_ooc_statement string 23,297,214 1906367 7332385 5452827
type string 23,297,214 shareholding shareholding shareholding
details string 21,989,010 None ownership-of-shares-25-to-50-percent ownership-of-shares-75-to-100-percent
startDate string 23,296,237 2016-02-26 2016-04-06 2021-02-23
endDate datetime 2,813,229 1567382400000 None None
share_minimum number 17,180,948 10.0 25.0 75.0
share_maximum number 17,180,948 10.0 50.0 100.0
share_exclusiveMinimum boolean 15,872,788 None True False
share_exclusiveMaximum boolean 15,872,788 None False False
share_exact number 1,308,160 10.0 None None