Open Ownership Register (2023-05-01)

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 10,055,248 383599 8027650 2648849
statementID string 10,055,248 openownership-register-5010689077948065988 openownership-register-13421355193217557070 openownership-register-221729124962585248
statementType string 10,055,248 personStatement personStatement personStatement
personType string 10,055,248 knownPerson knownPerson knownPerson
birthDate date 9,030,032 1977-05-01 1991-12-01 1990-08-01
missingInfoReason string 8,064 None None None
person_names
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 10,047,184 5195756.names.0 7418314.names.0 7288495.names.0
_link_person_statement string 10,047,184 5195756 7418314 7288495
type string 10,047,184 individual individual individual
fullName string 10,047,184 Marta Zajac Sarah Jane Robinson Jayant Bhimji Ladwa
person_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 20,564,423 5121584.identifiers.1 7591401.identifiers.0 7273328.identifiers.1
_link_person_statement string 20,564,423 5121584 7591401 7273328
schemeName string 20,564,423 OpenOwnership Register GB Persons Of Significant Control Register OpenOwnership Register
id string 20,564,423 http://register.openownership.org/entities/624391d3438d71487e7b7666 /company/SC353206/persons-with-significant-control/individual/BqNXmGxP6HVYJpOjca7ewLAtBGk http://register.openownership.org/entities/633e084083d77cf9df94d4b6
uri string 10,047,184 http://register.openownership.org/entities/624391d3438d71487e7b7666 None http://register.openownership.org/entities/633e084083d77cf9df94d4b6
scheme string 470,093 None None None
person_nationalities
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,011,668 2529356.nationalities.0 295478.nationalities.0 9632403.nationalities.0
_link_person_statement string 8,011,668 2529356 295478 9632403
name string 8,011,668 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 8,011,668 GB GB GB
person_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,827,483 3898535.addresses.0 2160323.addresses.0 3816604.addresses.0
_link_person_statement string 9,827,483 3898535 2160323 3816604
address string 9,827,483 13 St. Marys, Lynholm Road, Polegate, BN26 6JZ 23a, Greenhill Parade, New Barnet, Barnet, EN5 1EU 20, Elmhurst Road, Aylesbury, HP20 2EA
country string 4,415,254 None None None
entity_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,100,188 5443614 5345418 6162853
statementID string 9,100,188 openownership-register-12565564881140664824 openownership-register-4248441964768014357 openownership-register-9324258319451065148
statementType string 9,100,188 entityStatement entityStatement entityStatement
entityType string 9,100,188 registeredEntity registeredEntity registeredEntity
name string 8,888,201 TANTALLON PRODUCTIONS LTD 2ASPIRETO.COM LIMITED TRANSPOSE LIMITED
foundingDate date 8,388,706 2015-09-28 2006-09-14 1990-10-12
dissolutionDate date 2,238,282 2020-10-13 None None
incorporatedInJurisdiction_name string 9,041,131 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 9,041,131 GB GB GB
entity_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 28,023,583 2569043.identifiers.2 7887804.identifiers.2 886530.identifiers.1
_link_entity_statement string 28,023,583 2569043 7887804 886530
scheme string 8,969,896 None None None
schemeName string 28,023,583 OpenOwnership Register OpenOwnership Register OpenCorporates
id string 28,023,582 http://register.openownership.org/entities/5d8b791f9dfc3fae18f2d042 http://register.openownership.org/entities/59b9b7c167e4ebf3407acd71 https://opencorporates.com/companies/gb/10990081
uri string 17,880,979 http://register.openownership.org/entities/5d8b791f9dfc3fae18f2d042 http://register.openownership.org/entities/59b9b7c167e4ebf3407acd71 https://opencorporates.com/companies/gb/10990081
entity_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,876,802 8978937.addresses.0 524269.addresses.0 1308625.addresses.0
_link_entity_statement string 8,876,802 8978937 524269 1308625
type string 8,876,802 registered registered registered
address string 8,876,802 Україна, 08362, Київська обл., Бориспільський р-н, село Старе, ВУЛИЦЯ ГЕРАСИМЕНКА, будинок 138 C/O Mclintocks Hilliards Court, Chester Business Park, Chester, Cheshire, CH4 9PX c/o Lasse Hyldgaard Andersen, Strandparken 2, 2, Aarhus C, 8000
country string 8,818,085 UA GB DK
ooc_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 12,866,353 10386349 11837460 8930291
statementID string 12,866,353 openownership-register-11983054737134255972 openownership-register-2360646325007763837 openownership-register-9904865033467745231
statementType string 12,866,353 ownershipOrControlStatement ownershipOrControlStatement ownershipOrControlStatement
statementDate string 12,127,072 2016-04-06 2016-04-06 2016-07-18
subject_describedByEntityStatement string 12,866,353 openownership-register-14196153485223454458 openownership-register-2936198348245129318 openownership-register-6373433066551264563
interestedParty_describedByPersonStatement string 11,501,190 openownership-register-5769477945478843582 openownership-register-13305152045132197085 openownership-register-4013220407733310814
source_type string 12,739,201 officialRegister officialRegister officialRegister
source_description string 12,739,201 GB Persons Of Significant Control Register GB Persons Of Significant Control Register GB Persons Of Significant Control Register
source_url string 12,739,201 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,739,201 1562582231000 1562582231000 1571242628000
interestedParty_describedByEntityStatement string 785,114 None None None
interestedParty_unspecified_reason string 580,049 None None None
interestedParty_unspecified_description string 580,049 None None None
ooc_interests
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 24,896,300 7786281.interests.0 10158040.interests.1 5061282.interests.0
_link_ooc_statement string 24,896,300 7786281 10158040 5061282
type string 24,896,300 shareholding voting-rights shareholding
details string 23,537,183 ownership-of-shares-75-to-100-percent voting-rights-75-to-100-percent ownership-of-shares-75-to-100-percent
startDate date 24,895,323 2016-04-06 2017-02-23 2022-05-17
share_minimum number 18,316,420 75.0 75.0 75.0
share_maximum number 18,316,420 100.0 100.0 100.0
share_exclusiveMinimum boolean 16,957,347 False False False
share_exclusiveMaximum boolean 16,957,347 False False False
endDate date 3,086,602 None None 2023-01-01
share_exact number 1,359,073 None None None