Open Ownership Register (2024-06-18)

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

ooc_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 15,084,613 14598714 5607426 7324947
statementType string 15,084,613 ownershipOrControlStatement ownershipOrControlStatement ownershipOrControlStatement
statementDate date 15,084,613 2024-03-18 2021-03-17 2022-06-22
isComponent boolean 15,084,613 False False False
statementID string 15,084,613 11079269160850941198 16459976210044917449 14400304533326473357
interestedParty_describedByPersonStatement string 14,128,815 3923861140365841557 12380757740608854422 6552234869357249781
publicationDetails_bodsVersion number 15,084,613 0.2 0.2 0.2
publicationDetails_license string 15,084,613 https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions
publicationDetails_publicationDate date 15,084,613 2024-04-03 2023-06-19 2023-06-19
publicationDetails_publisher_name string 15,084,613 OpenOwnership Register OpenOwnership Register OpenOwnership Register
publicationDetails_publisher_url string 15,084,613 https://register.openownership.org https://register.openownership.org https://register.openownership.org
source_assertedBy boolean 15,084,613 None None None
source_description string 15,084,613 GB Persons Of Significant Control Register GB Persons Of Significant Control Register GB Persons Of Significant Control Register
source_retrievedAt date 15,084,613 2024-04-03 2023-06-19 2023-06-19
source_type string 15,084,613 officialRegister officialRegister officialRegister
source_url string 15,084,613 https://api.company-information.service.gov.uk/company/15574416/persons-with-significant-control/individual/1uy66iOcjg7dAVE0Y6SNNIBG_OY https://api.company-information.service.gov.uk/company/13272765/persons-with-significant-control/individual/heQ5eHZKzpJ3hpd8QAUt97RsJP0 https://api.company-information.service.gov.uk/company/14189959/persons-with-significant-control/individual/HfsWntxOQDlYCvkrgliiRBxQrig
subject_describedByEntityStatement string 15,084,613 9349329336875446110 5972098506185509799 17581226693621971715
interestedParty_describedByEntityStatement string 955,798 None None None
ooc_interests
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 32,844,654 2009417.interests.1 2464062.interests.0 11107531.interests.0
_link_ooc_statement string 32,844,654 2009417 2464062 11107531
type string 32,844,654 voting-rights shareholding shareholding
startDate date 32,844,654 2016-04-06 2018-03-14 2016-10-31
share_exact string 2,269,401 None None None
share_maximum string 24,206,090 50 100 100
share_minimum string 24,206,189 25 75 75
endDate date 4,032,837 None None None
details string 30,575,253 voting-rights-25-to-50-percent ownership-of-shares-75-to-100-percent ownership-of-shares-75-to-100-percent
share_exclusiveMaximum boolean 21,936,689 False False False
share_exclusiveMinimum boolean 21,936,788 True False False
person_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 10,070,749 4152795 4975469 4093777
statementType string 10,070,749 personStatement personStatement personStatement
isComponent boolean 10,070,749 False False False
statementID string 10,070,749 16468606093752000371 5078378675488445542 9086376616539753225
personType string 10,070,749 knownPerson knownPerson knownPerson
statementDate date 10,070,749 2023-06-19 2023-06-19 2023-06-19
publicationDetails_bodsVersion number 10,070,749 0.2 0.2 0.2
publicationDetails_license string 10,070,749 https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions
publicationDetails_publicationDate date 10,070,749 2023-06-19 2023-06-19 2023-06-19
publicationDetails_publisher_name string 10,070,749 OpenOwnership Register OpenOwnership Register OpenOwnership Register
publicationDetails_publisher_url string 10,070,749 https://register.openownership.org https://register.openownership.org https://register.openownership.org
source_assertedBy boolean 10,070,749 None None None
source_description string 10,070,749 GB Persons Of Significant Control Register GB Persons Of Significant Control Register GB Persons Of Significant Control Register
source_retrievedAt date 10,070,749 2023-06-19 2023-06-19 2023-06-19
source_type string 10,070,749 officialRegister officialRegister officialRegister
source_url string 10,070,749 https://api.company-information.service.gov.uk/company/13400643/persons-with-significant-control/individual/hoYp4m0hdtFCS-6bQ028wmG-sBY https://api.company-information.service.gov.uk/company/SC739556/persons-with-significant-control/individual/MAoS2ffoTuoczv8MvtgfaJIGwkk https://api.company-information.service.gov.uk/company/13328638/persons-with-significant-control/individual/DIxehXUjvvU9AHy1gchpe3JXvdQ
replacesStatements string 600,087 None None None
birthDate date 9,586,113 1974-03-01 1991-05-01 1989-04-01
person_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 10,674,696 5064365.identifiers.0 2658924.identifiers.0 8780118.identifiers.0
_link_person_statement string 10,674,696 5064365 2658924 8780118
id string 10,674,696 /entities/4860794984288296730 /entities/10010596766807979374 /entities/11167023982800516482
schemeName string 10,674,696 OpenOwnership Register OpenOwnership Register OpenOwnership Register
uri string 10,070,749 /entities/4860794984288296730 /entities/10010596766807979374 /entities/11167023982800516482
person_names
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 10,070,749 8685333.names.0 2509146.names.0 7402991.names.0
_link_person_statement string 10,070,749 8685333 2509146 7402991
fullName string 10,070,749 Subhpreet Singh Sandhu Christopher Smith Sally Haworth
type string 10,070,749 individual individual individual
familyName string 9,466,802 Sandhu Smith Haworth
givenName string 9,466,733 Subhpreet Christopher Sally
person_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 5,117,551 7180169.addresses.0 7555150.addresses.0 5372706.addresses.0
_link_person_statement string 5,117,551 7180169 7555150 5372706
address string 5,117,551 52, Reede Road, Dagenham, RM10 8DT Downsfold, Little Bognor, Fittleworth, Pulborough, RH20 1JT Unit A3 Broomsleigh Business Park, Worsley Bridge Road, London, SE26 5BN
country string 5,117,551 GB GB GB
type string 5,117,551 registered registered registered
person_nationalities
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 8,872,901 2097598.nationalities.0 5131564.nationalities.0 3606005.nationalities.0
_link_person_statement string 8,872,901 2097598 5131564 3606005
code string 8,872,901 AL GB GB
name string 8,872,901 Albania United Kingdom of Great Britain and Northern Ireland United Kingdom of Great Britain and Northern Ireland
entity_statement
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 11,353,543 2445804 6793299 8317512
statementType string 11,353,543 entityStatement entityStatement entityStatement
entityType string 11,353,543 registeredEntity registeredEntity registeredEntity
foundingDate date 11,196,134 2019-01-07 2017-08-01 2003-05-08
statementID string 11,353,543 14106866824499299304 1745295586065664353 15630829015420662099
statementDate date 11,353,543 2023-06-18 2023-06-19 2023-06-20
isComponent boolean 11,353,543 False False False
name string 11,305,615 COGENT LOGISTICS LTD CI SECURE (UK TRADING) LIMITED REDROCK ASSOCIATES INTERNATIONAL LIMITED
incorporatedInJurisdiction_code string 11,321,757 GB GB GB
incorporatedInJurisdiction_name string 11,321,757 United Kingdom of Great Britain and Northern Ireland United Kingdom of Great Britain and Northern Ireland United Kingdom of Great Britain and Northern Ireland
publicationDetails_bodsVersion number 11,353,543 0.2 0.2 0.2
publicationDetails_license string 11,353,543 https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions https://register.openownership.org/terms-and-conditions
publicationDetails_publicationDate date 11,353,543 2023-06-18 2023-06-19 2023-06-20
publicationDetails_publisher_name string 11,353,543 OpenOwnership Register OpenOwnership Register OpenOwnership Register
publicationDetails_publisher_url string 11,353,543 https://register.openownership.org https://register.openownership.org https://register.openownership.org
dissolutionDate date 3,218,470 None None None
replacesStatements string 1,668,928 None None None
alternateNames string 93,840 None None None
source_assertedBy boolean 657,582 None None None
source_description string 657,582 None None None
source_retrievedAt date 657,582 None None None
source_type string 657,582 None None None
source_url string 657,582 None None None
entity_addresses
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 11,299,602 4429676.addresses.0 9795780.addresses.0 5053353.addresses.0
_link_entity_statement string 11,299,602 4429676 9795780 5053353
address string 11,299,602 Suite 1, Welch House, 90-92 High Street, Henley-In-Arden, B95 5BY 104 Peel Street, Derby, DE22 3GH Vicarage Corner House, 219 Burton Road, Derby, DE23 6AE
country string 11,267,889 GB GB GB
type string 11,299,602 registered registered registered
entity_identifiers
Field Name Field Type Field Count Sample 1 Sample 2 Sample 3
_link string 33,939,408 6664551.identifiers.0 8576294.identifiers.2 9286428.identifiers.0
_link_entity_statement string 33,939,408 6664551 8576294 9286428
id string 33,939,408 10116324 /entities/12847255206647110198 14711856
scheme string 11,255,260 GB-COH None GB-COH
schemeName string 33,939,408 Companies House OpenOwnership Register Companies House
uri string 22,778,304 None /entities/12847255206647110198 None