Beneficial ownership data analysis tools

GLEIF Downloads and Links ooc_statement ooc_interests ooc_annotations person_statement person_annotations entity_statement entity_identifiers entity_addresses entity_annotations

GLEIF (2024-08-16)

The Global Legal Entity Identifier Foundation (GLEIF) is tasked with supporting the implementation and use of the_Legal Entity Identifier (LEI). GLEIF “enables smarter, less costly and more reliable decisions about who to do business with” by providing “open, standardised and high quality legal entity reference data” to uniquely identify companies. This open data includes its Level 2 Data on who owns whom.

The corporate ownership data collected and published openly by GLEIF is not beneficial ownership data as it does not identify the natural persons at the end of ownership chains but Open Ownership has mapped a combination of Level 1 and Level 2 Data to version 0.2 of our Beneficial Ownership Data Standard in order to analyse and learn more from layering this data on top of beneficial ownership data sources.

We have published a data use guide with information about how we have represented change over time and how specific fields have been mapped. Our blog post about updating this mapping shares some of our learnings from this work, including particular challenges of mapping to BODS 0.2.

You can see how Open Ownership has ingested, mapped and transformed this data in line with the Beneficial Ownership Data Standard. These mappings are currently a work in progress and should be treated with caution. This dataset is published under the Creative Commons CC0 1.0 Universal (CC0 1.0) Public Domain Dedication licence.

Downloads and links to hosted databases

CSV Download SQLite Download Postgresql Dump (gzip) JSON Download Parquet Download Big Query Datasette

Tables

ooc_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	5,457,578	2656456	3545109	4544380
statementID	string	5,457,578	3a86c927-ec13-9c2c-28ff-f7c7a17793e8	e542bc8e-fd65-d4b9-1c84-8b4baf8e904a	98334083-966c-e9ff-59e6-71b9bc7fe4ab
statementType	string	5,457,578	ownershipOrControlStatement	ownershipOrControlStatement	ownershipOrControlStatement
statementDate	date	5,457,578	2024-06-06	2024-06-06	2024-06-06
subject_describedByEntityStatement	string	5,457,578	71b04186-fc27-6359-296b-fd9017f17d3a	ccabfa23-89ce-3e64-e746-8c0dc1c00aec	d9293664-4c52-b90b-b55c-e87cf72c690d
interestedParty_describedByPersonStatement	string	2,701,929	None	6866dbbd-2468-b639-0ab2-2ae71c32e3ba	None
publicationDetails_publicationDate	date	5,457,578	2024-08-16	2024-08-16	2024-08-16
publicationDetails_bodsVersion	number	5,457,578	0.2	0.2	0.2
publicationDetails_license	string	5,452,507	https://creativecommons.org/publicdomain/zero/1.0/	https://creativecommons.org/publicdomain/zero/1.0/	https://creativecommons.org/publicdomain/zero/1.0/
publicationDetails_publisher_name	string	5,457,578	Open Ownership	Open Ownership	Open Ownership
publicationDetails_publisher_url	string	5,452,507	https://www.openownership.org	https://www.openownership.org	https://www.openownership.org
source_type	string	5,452,507	officialRegister	officialRegister	officialRegister
source_description	string	5,452,507	GLEIF	GLEIF	GLEIF
interestedParty_describedByEntityStatement	string	2,755,649	b8e26fa2-8f99-6b1b-f011-86b769ef3dd5	None	9c51657f-7290-4421-e366-6b7b990b2c57
replacesStatements	string	154,105	None	None	None
isComponent	boolean	5,071	None	None	None

ooc_interests

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	5,452,507	63365.interests.0	128454.interests.0	1095925.interests.0
_link_ooc_statement	string	5,452,507	63365	128454	1095925
type	string	5,452,507	other-influence-or-control	other-influence-or-control	other-influence-or-control
interestLevel	string	5,452,507	direct	indirect	direct
beneficialOwnershipOrControl	boolean	5,452,507	False	False	False
details	string	5,452,507	A controlling interest.	A controlling interest.	A controlling interest.
startDate	datetime	557,414	None	None	None

ooc_annotations

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	10,352,891	5047164.annotations.1	4947470.annotations.1	1789852.annotations.1
_link_ooc_statement	string	10,352,891	5047164	4947470	1789852
motivation	string	10,352,891	commenting	commenting	commenting
description	string	10,352,891	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 724500JGV6VZJB299N29	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 254900ASUEZVFL3JHZ84	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 8156002DC26B47899640
statementPointerTarget	string	10,352,891	/	/	/
creationDate	date	10,352,891	2024-08-16	2024-08-16	2024-08-16
createdBy_name	string	10,352,891	Open Ownership	Open Ownership	Open Ownership
createdBy_uri	string	10,352,891	https://www.openownership.org	https://www.openownership.org	https://www.openownership.org

person_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	2,720,461	1267868	64291	2302795
statementID	string	2,720,461	ebcfb7c5-d03f-720d-0629-0fdc903bfb87	a174e74d-ce52-846b-5f8a-003b5ed40823	8ef4fc57-2998-87db-ac62-b25a7121def2
statementType	string	2,720,461	personStatement	personStatement	personStatement
statementDate	date	2,720,461	2024-06-06	2024-06-06	2024-06-06
personType	string	2,720,461	unknownPerson	unknownPerson	unknownPerson
publicationDetails_publicationDate	date	2,720,461	2024-08-16	2024-08-16	2024-08-16
publicationDetails_bodsVersion	number	2,720,461	0.2	0.2	0.2
publicationDetails_license	string	2,701,929	https://creativecommons.org/publicdomain/zero/1.0/	https://creativecommons.org/publicdomain/zero/1.0/	https://creativecommons.org/publicdomain/zero/1.0/
publicationDetails_publisher_name	string	2,720,461	Open Ownership	Open Ownership	Open Ownership
publicationDetails_publisher_url	string	2,701,929	https://www.openownership.org	https://www.openownership.org	https://www.openownership.org
source_type	string	2,701,929	officialRegister	officialRegister	officialRegister
source_description	string	2,701,929	GLEIF	GLEIF	GLEIF
unspecifiedPersonDetails_reason	string	2,701,929	interested-party-exempt-from-disclosure	interested-party-exempt-from-disclosure	interested-party-exempt-from-disclosure
unspecifiedPersonDetails_description	string	2,701,929	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	From LEI ExemptionReason `NO_KNOWN_PERSON`. There is no known person(s) controlling the entity.
isComponent	boolean	18,532	None	None	None
replacesStatements	string	18,532	None	None	None

person_annotations

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	2,720,461	2462992.annotations.0	351581.annotations.0	1066009.annotations.0
_link_person_statement	string	2,720,461	2462992	351581	1066009
motivation	string	2,720,461	commenting	commenting	commenting
description	string	2,720,461	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 894500VZ3HKCLXUEML26	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 335800KMEH9MBZVYPM54	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 254900TYTLDJZQJC9467
statementPointerTarget	string	2,720,461	/	/	/
creationDate	date	2,720,461	2024-08-16	2024-08-16	2024-08-16
createdBy_name	string	2,720,461	Open Ownership	Open Ownership	Open Ownership
createdBy_uri	string	2,720,461	https://www.openownership.org	https://www.openownership.org	https://www.openownership.org

entity_statement

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	5,206,047	4821346	5164511	1117926
statementID	string	5,206,047	1ba116fe-5293-f923-8e74-e186b7134a46	02ec726e-bab1-23ad-49fe-6f0462e7078d	caa6c600-784c-db26-8dc7-7efb9fc2e7a1
statementType	string	5,206,047	entityStatement	entityStatement	entityStatement
statementDate	date	5,206,047	2024-06-06	2024-06-06	2024-06-06
entityType	string	5,206,047	unknownEntity	unknownEntity	unknownEntity
name	string	2,974,117	None	None	None
foundingDate	datetime	2,247,568	None	None	None
replacesStatements	string	318,863	None	None	None
incorporatedInJurisdiction_name	string	2,974,117	None	None	None
incorporatedInJurisdiction_code	string	2,974,117	None	None	None
publicationDetails_publicationDate	date	5,206,047	2024-08-16	2024-08-16	2024-08-16
publicationDetails_bodsVersion	number	5,206,047	0.2	0.2	0.2
publicationDetails_license	string	5,167,281	https://creativecommons.org/publicdomain/zero/1.0/	https://creativecommons.org/publicdomain/zero/1.0/	https://creativecommons.org/publicdomain/zero/1.0/
publicationDetails_publisher_name	string	5,206,047	Open Ownership	Open Ownership	Open Ownership
publicationDetails_publisher_url	string	5,167,281	https://www.openownership.org	https://www.openownership.org	https://www.openownership.org
source_type	string	5,167,281	officialRegister	officialRegister	officialRegister
source_description	string	5,167,281	GLEIF	GLEIF	GLEIF
isComponent	boolean	38,766	None	None	None
unspecifiedEntityDetails_reason	string	2,193,164	interested-party-exempt-from-disclosure	interested-party-exempt-from-disclosure	interested-party-exempt-from-disclosure
unspecifiedEntityDetails_description	string	2,193,164	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.

entity_identifiers

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	5,948,234	3177740.identifiers.1	840724.identifiers.1	1174133.identifiers.1
_link_entity_statement	string	5,948,234	3177740	840724	1174133
id	string	5,652,458	4764045	U67100HR2007PTC037355	2350810
scheme	string	2,974,117	None	None	None
schemeName	string	5,948,234	RA000602	RA000394	RA000629

entity_addresses

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	5,948,234	2412239.addresses.1	119465.addresses.1	4793760.addresses.0
_link_entity_statement	string	5,948,234	2412239	119465	4793760
type	string	5,948,234	business	business	registered
address	string	5,948,234	Gewerbering 6a, Bexbach	AU GARMENDI NULL, Azpeitia	Chicheley Hall, Newport Pagnell
country	string	5,948,234	DE	ES	GB
postCode	string	5,865,110	66450	20730	MK16 9JJ

entity_annotations

Field Name	Field Type	Field Count	Sample 1	Sample 2	Sample 3
_link	string	5,206,047	4728592.annotations.0	3955648.annotations.0	2662529.annotations.0
_link_entity_statement	string	5,206,047	4728592	3955648	2662529
motivation	string	5,206,047	commenting	commenting	commenting
description	string	5,206,047	This statement was created due to a NON_CONSOLIDATING GLEIF Reporting Exception for 959800YMEE4QSBBF7817	GLEIF data for this entity - LEI: 98450038X6F639CC8G79; Registration Status: ISSUED	This statement was created due to a NON_CONSOLIDATING GLEIF Reporting Exception for 959800SCWXTKD36AXQ46
statementPointerTarget	string	5,206,047	/	/	/
creationDate	date	5,206,047	2024-08-16	2024-08-16	2024-08-16
createdBy_name	string	5,206,047	Open Ownership	Open Ownership	Open Ownership
createdBy_uri	string	5,206,047	https://www.openownership.org	https://www.openownership.org	https://www.openownership.org

_link	statementID	statementType	statementDate	subject_describedByEntityStatement	interestedParty_describedByPersonStatement	publicationDetails_publicationDate	publicationDetails_bodsVersion	publicationDetails_license	publicationDetails_publisher_name	publicationDetails_publisher_url	source_type	source_description	interestedParty_describedByEntityStatement	replacesStatements	isComponent
2656456	3a86c927-ec13-9c2c-28ff-f7c7a17793e8	ownershipOrControlStatement	2024-06-06	71b04186-fc27-6359-296b-fd9017f17d3a	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	b8e26fa2-8f99-6b1b-f011-86b769ef3dd5	None	None
3545109	e542bc8e-fd65-d4b9-1c84-8b4baf8e904a	ownershipOrControlStatement	2024-06-06	ccabfa23-89ce-3e64-e746-8c0dc1c00aec	6866dbbd-2468-b639-0ab2-2ae71c32e3ba	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
4544380	98334083-966c-e9ff-59e6-71b9bc7fe4ab	ownershipOrControlStatement	2024-06-06	d9293664-4c52-b90b-b55c-e87cf72c690d	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	9c51657f-7290-4421-e366-6b7b990b2c57	None	None
1022317	a9e00942-f2c6-8b10-24e6-eac8c5dedd01	ownershipOrControlStatement	2024-06-06	41ac2c4b-c287-cbdd-4fb1-b5dabaae99cf	d905c540-3b4e-edad-88de-8d95f44f3e41	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
914361	f2e2dea5-883a-af33-8433-2e1f453afdb2	ownershipOrControlStatement	2024-05-14	d98dc184-e8e5-91f0-412a-e6ab5714e1b3	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	a82108a4-72a8-732b-857f-810c9e496e68	ead0ef91-bc9c-bb9a-f920-ee32cb112a31	None
3411630	c23b7c7c-971d-0b29-cc37-de34c7646ea3	ownershipOrControlStatement	2024-06-06	77e93f20-6f63-c08b-3c24-0e4c799ba743	80b8cd72-b39e-578e-3f43-a1da09a177d4	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
1064866	92ec2a35-91ba-a604-1bb2-33d7127fadbf	ownershipOrControlStatement	2024-06-06	2274ea93-6def-76c6-91e8-4c2547ddf151	e0b90d0a-ff56-9a99-eb6c-1a825d05ff58	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
1257562	a791b0c6-5c39-ae36-665c-ce9b8af9f019	ownershipOrControlStatement	2024-06-06	fda01a64-1282-2108-9198-09d83018cb5c	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	a4c3e53b-1b31-543b-a306-b0bc174140be	None	None
2549227	1290dee2-1a7f-e21e-e8d9-272898fce819	ownershipOrControlStatement	2024-06-06	7c9304e7-2bc9-3eec-1606-d75be83ac5dc	0e539cf8-63ad-8fcd-acd8-0568176e97e0	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
2253676	2145ecd9-d385-1e11-1e1e-0501e4a7ad8e	ownershipOrControlStatement	2024-06-06	1150aee6-78b4-2f3b-6c7d-215a5d5ba2d6	043e6aa1-7ed9-213b-ee06-162bff0f2232	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None

_link	_link_ooc_statement	type	interestLevel	beneficialOwnershipOrControl	details	startDate
63365.interests.0	63365	other-influence-or-control	direct	False	A controlling interest.	None
128454.interests.0	128454	other-influence-or-control	indirect	False	A controlling interest.	None
1095925.interests.0	1095925	other-influence-or-control	direct	False	A controlling interest.	None
1930819.interests.0	1930819	other-influence-or-control	direct	False	A controlling interest.	None
1398138.interests.0	1398138	other-influence-or-control	indirect	False	A controlling interest.	None
1802665.interests.0	1802665	other-influence-or-control	direct	False	A controlling interest.	None
3715592.interests.0	3715592	other-influence-or-control	direct	False	A controlling interest.	None
794222.interests.0	794222	other-influence-or-control	indirect	False	A controlling interest.	None
1110311.interests.0	1110311	other-influence-or-control	indirect	False	A controlling interest.	None
2468391.interests.0	2468391	other-influence-or-control	direct	False	A controlling interest.	None

_link	_link_ooc_statement	motivation	description	statementPointerTarget	creationDate	createdBy_name	createdBy_uri
5047164.annotations.1	5047164	commenting	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 724500JGV6VZJB299N29	/	2024-08-16	Open Ownership	https://www.openownership.org
4947470.annotations.1	4947470	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 254900ASUEZVFL3JHZ84	/	2024-08-16	Open Ownership	https://www.openownership.org
1789852.annotations.1	1789852	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 8156002DC26B47899640	/	2024-08-16	Open Ownership	https://www.openownership.org
3110664.annotations.0	3110664	commenting	The nature of this interest is unknown	/interests/0/type	2024-08-16	Open Ownership	https://www.openownership.org
2749865.annotations.1	2749865	commenting	This statement was created due to a NO_LEI GLEIF Reporting Exception for 254900WX5IAXL1RWPZ18	/	2024-08-16	Open Ownership	https://www.openownership.org
3024951.annotations.0	3024951	commenting	The nature of this interest is unknown	/interests/0/type	2024-08-16	Open Ownership	https://www.openownership.org
4285528.annotations.0	4285528	commenting	Describes GLEIF relationship: 5493002NQSYK6RZLJF82 is subject, 549300TNCM74R36XKV37 is interested party	/	2024-08-16	Open Ownership	https://www.openownership.org
4766487.annotations.1	4766487	commenting	This statement was created due to a NON_CONSOLIDATING GLEIF Reporting Exception for 315700K8OGQPTZ5D5G51	/	2024-08-16	Open Ownership	https://www.openownership.org
4097048.annotations.0	4097048	commenting	The nature of this interest is unknown	/interests/0/type	2024-08-16	Open Ownership	https://www.openownership.org
4758118.annotations.1	4758118	commenting	This statement was created due to a CONSENT_NOT_OBTAINED GLEIF Reporting Exception for 549300NPMUX5N1FD2L05	/	2024-08-16	Open Ownership	https://www.openownership.org

_link	statementID	statementType	statementDate	personType	publicationDetails_publicationDate	publicationDetails_bodsVersion	publicationDetails_license	publicationDetails_publisher_name	publicationDetails_publisher_url	source_type	source_description	unspecifiedPersonDetails_reason	unspecifiedPersonDetails_description	isComponent	replacesStatements
1267868	ebcfb7c5-d03f-720d-0629-0fdc903bfb87	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	None	None
64291	a174e74d-ce52-846b-5f8a-003b5ed40823	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	None	None
2302795	8ef4fc57-2998-87db-ac62-b25a7121def2	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NO_KNOWN_PERSON`. There is no known person(s) controlling the entity.	None	None
244831	d91f5e1a-1dd3-6838-b2d0-24edbf9422de	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NO_KNOWN_PERSON`. There is no known person(s) controlling the entity.	None	None
922424	174b4864-1c44-67b7-48f6-a8d09c259be4	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	None	None
1820416	1b7575b1-0f6e-782d-af47-abf76137a770	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NO_KNOWN_PERSON`. There is no known person(s) controlling the entity.	None	None
98550	5966e4fa-adc6-2815-6a9f-4fc6f55dfe89	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NO_KNOWN_PERSON`. There is no known person(s) controlling the entity.	None	None
1567665	d94dcbf4-0e6e-3199-259c-d56d4b5a71b2	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	None	None
953890	4d871b7f-82f1-c879-21be-4f442d22f7bb	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NO_KNOWN_PERSON`. There is no known person(s) controlling the entity.	None	None
2285409	3bce5d68-d460-fffa-8d7c-505a650954a5	personStatement	2024-06-06	unknownPerson	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NATURAL_PERSONS`. An unknown natural person or persons controls an entity.	None	None

_link	_link_person_statement	motivation	description	statementPointerTarget	creationDate	createdBy_name	createdBy_uri
2462992.annotations.0	2462992	commenting	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 894500VZ3HKCLXUEML26	/	2024-08-16	Open Ownership	https://www.openownership.org
351581.annotations.0	351581	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 335800KMEH9MBZVYPM54	/	2024-08-16	Open Ownership	https://www.openownership.org
1066009.annotations.0	1066009	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 254900TYTLDJZQJC9467	/	2024-08-16	Open Ownership	https://www.openownership.org
1599456.annotations.0	1599456	commenting	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 959800N968KMETFLLB08	/	2024-08-16	Open Ownership	https://www.openownership.org
2584151.annotations.0	2584151	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 54930053Y3MERJ8N2V75	/	2024-08-16	Open Ownership	https://www.openownership.org
213937.annotations.0	213937	commenting	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 894500S7LQ86QI2VEC26	/	2024-08-16	Open Ownership	https://www.openownership.org
2278806.annotations.0	2278806	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 5493009UELDTOFPOJZ06	/	2024-08-16	Open Ownership	https://www.openownership.org
1914894.annotations.0	1914894	commenting	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 213800IUF5WB899ML657	/	2024-08-16	Open Ownership	https://www.openownership.org
2390610.annotations.0	2390610	commenting	This statement was created due to a NATURAL_PERSONS GLEIF Reporting Exception for 2549008KHTH9GRGQWP85	/	2024-08-16	Open Ownership	https://www.openownership.org
1924998.annotations.0	1924998	commenting	This statement was created due to a NO_KNOWN_PERSON GLEIF Reporting Exception for 894500CIZ4GX03HHF586	/	2024-08-16	Open Ownership	https://www.openownership.org

_link	statementID	statementType	statementDate	entityType	name	foundingDate	replacesStatements	incorporatedInJurisdiction_name	incorporatedInJurisdiction_code	publicationDetails_publicationDate	publicationDetails_bodsVersion	publicationDetails_license	publicationDetails_publisher_name	publicationDetails_publisher_url	source_type	source_description	isComponent	unspecifiedEntityDetails_reason	unspecifiedEntityDetails_description
4821346	1ba116fe-5293-f923-8e74-e186b7134a46	entityStatement	2024-06-06	unknownEntity	None	None	None	None	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.
5164511	02ec726e-bab1-23ad-49fe-6f0462e7078d	entityStatement	2024-06-06	unknownEntity	None	None	None	None	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.
1117926	caa6c600-784c-db26-8dc7-7efb9fc2e7a1	entityStatement	2024-06-06	unknownEntity	None	None	None	None	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.
2278485	0a8fa8b9-d2c1-7646-dceb-4439729962bf	entityStatement	2022-03-14	registeredEntity	Geco Concepts Ltd	None	None	United Kingdom	GB	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
2526253	fb54a284-6c8f-1547-6f09-c9ad8abb4096	entityStatement	2024-06-06	unknownEntity	None	None	None	None	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.
476936	42e95d8a-f66d-822e-9261-8c3e6aa3f0b6	entityStatement	2024-06-06	unknownEntity	None	None	None	None	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.
2870157	41787b92-d10e-b4a8-6951-2e505823e8a4	entityStatement	2024-06-06	unknownEntity	None	None	None	None	None	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	interested-party-exempt-from-disclosure	From LEI ExemptionReason `NON_CONSOLIDATING`. The legal entity or entities are not obliged to provide consolidated accounts in relation to the entity they control.
3327083	66dab9e4-cbed-714f-b616-f781be9ce0b8	entityStatement	2023-07-31	registeredEntity	BETASHARES DIGITAL HEALTH AND TELEMEDICINE ETF	1635138000000	None	Australia	AU	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister,verified	GLEIF	None	None	None
4305287	51ebbdc2-5d6c-3d91-0078-af9defede8e9	entityStatement	2019-11-14	registeredEntity	JOHN MARRON EXECUTIVE PENSION SCHEME	None	None	Ireland	IE	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister	GLEIF	None	None	None
4926441	5189be47-6e15-fbb0-9810-abe96e499077	entityStatement	2024-05-10	registeredEntity	Gemeente Emmen	883609200000	None	Netherlands	NL	2024-08-16	0.2	https://creativecommons.org/publicdomain/zero/1.0/	Open Ownership	https://www.openownership.org	officialRegister,verified	GLEIF	None	None	None

_link	_link_entity_statement	id	scheme	schemeName
3177740.identifiers.1	3177740	4764045	None	RA000602
840724.identifiers.1	840724	U67100HR2007PTC037355	None	RA000394
1174133.identifiers.1	1174133	2350810	None	RA000629
185418.identifiers.1	185418	CHE107740966	None	RA000548
3338101.identifiers.1	3338101	01535880155	None	RA000407
871681.identifiers.0	871681	335800MWYYUKAY4L7D33	XI-LEI	Global Legal Entity Identifier Index
337842.identifiers.1	337842	878576768	None	RA000192
1575468.identifiers.0	1575468	213800LPW2PLRQ3HIQ29	XI-LEI	Global Legal Entity Identifier Index
4325520.identifiers.0	4325520	836800WBQZU5BWEMKO48	XI-LEI	Global Legal Entity Identifier Index
396252.identifiers.1	396252	IC-371887	None	RA000086

_link	_link_entity_statement	type	address	country	postCode
2412239.addresses.1	2412239	business	Gewerbering 6a, Bexbach	DE	66450
119465.addresses.1	119465	business	AU GARMENDI NULL, Azpeitia	ES	20730
4793760.addresses.0	4793760	registered	Chicheley Hall, Newport Pagnell	GB	MK16 9JJ
3195890.addresses.0	3195890	registered	Principe de Vergara 112, Madrid	ES	28002
4087989.addresses.0	4087989	registered	CALLE DE VINYALS 47, Terrassa	ES	08221
1424449.addresses.0	1424449	registered	Box 1654, Prince Albert	CA	S6V 5T2
259318.addresses.1	259318	business	44 RUE DE FLEURUS, PARIS	FR	75006
1590738.addresses.0	1590738	registered	1010 Northern Boulevard, Great Neck	US	11021
3104253.addresses.0	3104253	registered	Ghana Street Nkwen, Bamenda	CM	786
3765270.addresses.0	3765270	registered	Widenmayerstraße 10, München	DE	80538

_link	_link_entity_statement	motivation	description	statementPointerTarget	creationDate	createdBy_name	createdBy_uri
4728592.annotations.0	4728592	commenting	This statement was created due to a NON_CONSOLIDATING GLEIF Reporting Exception for 959800YMEE4QSBBF7817	/	2024-08-16	Open Ownership	https://www.openownership.org
3955648.annotations.0	3955648	commenting	GLEIF data for this entity - LEI: 98450038X6F639CC8G79; Registration Status: ISSUED	/	2024-08-16	Open Ownership	https://www.openownership.org
2662529.annotations.0	2662529	commenting	This statement was created due to a NON_CONSOLIDATING GLEIF Reporting Exception for 959800SCWXTKD36AXQ46	/	2024-08-16	Open Ownership	https://www.openownership.org
3774597.annotations.0	3774597	commenting	GLEIF data for this entity - LEI: 549300DPGWBCL9GVL627; Registration Status: ISSUED	/	2024-08-16	Open Ownership	https://www.openownership.org
2831569.annotations.0	2831569	commenting	GLEIF data for this entity - LEI: 2549004A1KEZ95XC2N40; Registration Status: ISSUED	/	2024-08-16	Open Ownership	https://www.openownership.org
1859516.annotations.0	1859516	commenting	GLEIF data for this entity - LEI: 549300YEDIM7J82I3W67; Registration Status: RETIRED	/	2024-08-16	Open Ownership	https://www.openownership.org
5162165.annotations.0	5162165	commenting	GLEIF data for this entity - LEI: 25940024WZ3SM55O4N77; Registration Status: ISSUED	/	2024-08-16	Open Ownership	https://www.openownership.org
5156157.annotations.0	5156157	commenting	GLEIF data for this entity - LEI: 315700M54O0W30SQML30; Registration Status: ISSUED	/	2024-08-16	Open Ownership	https://www.openownership.org
2230514.annotations.0	2230514	commenting	GLEIF data for this entity - LEI: 549300I3OCD114MC1K24; Registration Status: ISSUED	/	2024-08-16	Open Ownership	https://www.openownership.org
1229378.annotations.0	1229378	commenting	GLEIF data for this entity - LEI: 549300QK7TDMKA6XGV55; Registration Status: LAPSED	/	2024-08-16	Open Ownership	https://www.openownership.org

Beneficial ownership data analysis tools

GLEIF (2024-08-16)

Downloads and links to hosted databases

Tables

ooc_statement

ooc_interests

ooc_annotations

person_statement

person_annotations

entity_statement

entity_identifiers

entity_addresses

entity_annotations

Sample data from `ooc_statement` table.

Sample data from `ooc_interests` table.

Sample data from `ooc_annotations` table.

Sample data from `person_statement` table.

Sample data from `person_annotations` table.

Sample data from `entity_statement` table.

Sample data from `entity_identifiers` table.

Sample data from `entity_addresses` table.

Sample data from `entity_annotations` table.