Open Ownership Register (2023-09-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.2 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,031,695 8942646 689305 7159702
statementID string 9,031,695 13238643525365230536 14465169703992185012 7165236470419619281
statementType string 9,031,695 personStatement personStatement personStatement
statementDate date 9,031,695 2023-09-05 2023-06-18 2023-06-20
isComponent boolean 9,031,695 False False False
personType string 9,031,695 knownPerson knownPerson knownPerson
birthDate date 8,600,660 1974-05-01 1941-06-01 1986-02-01
publicationDetails_publicationDate date 9,031,695 2023-09-05 2023-06-18 2023-06-20
publicationDetails_bodsVersion number 9,031,695 0.2 0.2 0.2
publicationDetails_license string 9,031,695 https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions
publicationDetails_publisher_name string 9,031,695 OpenOwnership Register OpenOwnership Register OpenOwnership Register
publicationDetails_publisher_url string 9,031,695 https://register.openownership.org https://register.openownership.org https://register.openownership.org
source_type string 9,031,695 officialRegister officialRegister officialRegister
source_description string 9,031,695 GB Persons Of Significant Control Register GB Persons Of Significant Control Register GB Persons Of Significant Control Register
source_url string 9,031,695 https://api.company-information.service.gov.uk/company/12783564/persons-with-significant-control/individual/6Dfp2kV1-IvBmQrMtd2FQpO6DGo https://api.company-information.service.gov.uk/company/01992237/persons-with-significant-control/individual/u35_A6TS2xU51fnj_YDcJtNBsBY https://api.company-information.service.gov.uk/company/04771316/persons-with-significant-control/individual/S3Ll1Rc8zV_ZwM2nA0zFtC6d06E
source_retrievedAt date 9,031,695 2023-09-05 2023-06-18 2023-06-20
source_assertedBy boolean 9,031,695 None None None
replacesStatements string 272,885 None None None
person_names
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,031,695 8259018.names.0 2600447.names.0 7730551.names.0
_link_person_statement string 9,031,695 8259018 2600447 7730551
type string 9,031,695 individual individual individual
fullName string 9,031,695 Clara Tabase Bogdan Gabriel Rossi Marinescu Paula Maria Hay -Plumb
familyName string 8,491,367 Tabase Rossi Marinescu Hay -Plumb
givenName string 8,491,304 Clara Bogdan Paula
person_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,572,023 2517947.identifiers.0 7676119.identifiers.0 2482873.identifiers.0
_link_person_statement string 9,572,023 2517947 7676119 2482873
id string 9,572,023 /entities/10705928358624278668 /entities/13800043295733718050 /entities/13215226715485127555
schemeName string 9,572,023 OpenOwnership Register OpenOwnership Register OpenOwnership Register
uri string 9,031,695 /entities/10705928358624278668 /entities/13800043295733718050 /entities/13215226715485127555
person_nationalities
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 7,988,740 7826638.nationalities.0 6709362.nationalities.0 1367431.nationalities.0
_link_person_statement string 7,988,740 7826638 6709362 1367431
name string 7,988,740 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,988,740 GB GB GB
person_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 4,530,944 3147606.addresses.0 8713025.addresses.0 6046419.addresses.0
_link_person_statement string 4,530,944 3147606 8713025 6046419
type string 4,530,944 registered registered registered
address string 4,530,944 Flat 16 Granary Court, 1 Millstone Close, London, E15 1PD Flat 4, 1 Trevor Street, Bedford, MK40 2FP Broom House, 39-43 London Road, Hadleigh, Benfleet, Essex, SS72QL
country string 4,530,944 PK GB GB
entity_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,706,973 9575992 7438136 5986175
statementID string 9,706,973 6441226399360187860 5901060103480780655 16420752208974046077
statementType string 9,706,973 entityStatement entityStatement entityStatement
statementDate date 9,706,973 2023-09-05 2023-06-20 2023-06-19
isComponent boolean 9,706,973 False False False
entityType string 9,706,973 registeredEntity registeredEntity registeredEntity
name string 9,672,196 SEICLO DYFI CYCLE CIC Sorba Projects Bv BONI LTD
foundingDate date 9,577,958 2023-08-31 None 2007-11-28
incorporatedInJurisdiction_name string 9,677,625 United Kingdom of Great Britain and Northern Ireland Netherlands United Kingdom of Great Britain and Northern Ireland
incorporatedInJurisdiction_code string 9,677,625 GB NL GB
publicationDetails_publicationDate date 9,706,973 2023-09-05 2023-06-20 2023-06-19
publicationDetails_bodsVersion number 9,706,973 0.2 0.2 0.2
publicationDetails_license string 9,706,973 https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions
publicationDetails_publisher_name string 9,706,973 OpenOwnership Register OpenOwnership Register OpenOwnership Register
publicationDetails_publisher_url string 9,706,973 https://register.openownership.org https://register.openownership.org https://register.openownership.org
dissolutionDate date 3,111,256 None None None
source_type string 564,360 None officialRegister None
source_description string 564,360 None GB Persons Of Significant Control Register None
source_url string 564,360 None https://api.company-information.service.gov.uk/company/01945217/persons-with-significant-control/corporate-entity/84HevVHfm80GdaWTgjpfAYAYmY4 None
source_retrievedAt date 564,360 None 2023-06-20 None
source_assertedBy boolean 564,360 None None None
replacesStatements string 671,986 None None 16628262739028549000
entity_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 28,893,794 6730642.identifiers.2 9234541.identifiers.2 6385819.identifiers.1
_link_entity_statement string 28,893,794 6730642 9234541 6385819
id string 28,893,794 /entities/452812445365093801 /entities/3698534007714729849 https://opencorporates.com/companies/gb/09373841
scheme string 9,574,390 None None None
schemeName string 28,893,794 OpenOwnership Register OpenOwnership Register OpenCorporates
uri string 19,437,843 /entities/452812445365093801 /entities/3698534007714729849 https://opencorporates.com/companies/gb/09373841
entity_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 9,671,853 4454311.addresses.0 8408490.addresses.0 5408601.addresses.0
_link_entity_statement string 9,671,853 4454311 8408490 5408601
type string 9,671,853 registered registered registered
address string 9,671,853 16 The Woodlands, Cottingham, East Yorkshire, HU16 5RP 10884366: COMPANIES HOUSE DEFAULT ADDRESS, Cardiff, CF14 8LH 4 South House Bond Avenue, Bletchley, Milton Keynes, MK1 1SW
country string 9,642,569 GB GB GB
ooc_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 12,860,770 7285810 609654 12797459
statementID string 12,860,770 12159524870750792026 4614790663003179428 6506005350498745675
statementType string 12,860,770 ownershipOrControlStatement ownershipOrControlStatement ownershipOrControlStatement
statementDate date 12,860,770 2016-04-06 2016-09-20 2023-08-22
isComponent boolean 12,860,770 False False False
subject_describedByEntityStatement string 12,860,770 9218148777382509703 2252131738654476750 15187022472664999501
interestedParty_describedByPersonStatement string 12,007,469 None 7119611754560896477 8507722520627557571
publicationDetails_publicationDate date 12,860,770 2023-06-19 2023-06-18 2023-09-05
publicationDetails_bodsVersion number 12,860,770 0.2 0.2 0.2
publicationDetails_license string 12,860,770 https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions
publicationDetails_publisher_name string 12,860,770 OpenOwnership Register OpenOwnership Register OpenOwnership Register
publicationDetails_publisher_url string 12,860,770 https://register.openownership.org https://register.openownership.org https://register.openownership.org
source_type string 12,860,770 officialRegister officialRegister officialRegister
source_description string 12,860,770 GB Persons Of Significant Control Register GB Persons Of Significant Control Register GB Persons Of Significant Control Register
source_url string 12,860,770 https://api.company-information.service.gov.uk/company/09323877/persons-with-significant-control/corporate-entity/lQBlIdM71pkxl19VDSq0CTkmcwg https://api.company-information.service.gov.uk/company/10385224/persons-with-significant-control/individual/tCdxmSU3YiVFsj04gg9phaDl0OY https://api.company-information.service.gov.uk/company/15089201/persons-with-significant-control/individual/soQ7sX4TWFpl9PwPJMD1-PTdIUQ
source_retrievedAt date 12,860,770 2023-06-19 2023-06-18 2023-09-05
source_assertedBy boolean 12,860,770 None None None
interestedParty_describedByEntityStatement string 853,301 8619504060751482404 None None
ooc_interests
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 27,657,271 7841165.interests.2 1255996.interests.0 6691007.interests.1
_link_ooc_statement string 27,657,271 7841165 1255996 6691007
type string 27,657,271 appointment-of-board shareholding voting-rights
details string 26,066,733 right-to-appoint-and-remove-directors ownership-of-shares-75-to-100-percent voting-rights-75-to-100-percent
startDate date 27,657,271 2017-02-02 2018-05-02 2022-11-18
share_maximum string 20,344,075 None 100.0 100.0
share_minimum string 20,344,086 None 75.0 75.0
share_exclusiveMinimum boolean 18,753,548 None False False
share_exclusiveMaximum boolean 18,753,537 None False False
endDate date 3,369,270 None None None
share_exact string 1,590,538 None None None