gleif

Custom SQL query

Tables

entity_addresses

_link, _link_entity_statement, type, address, country, postcode

4,713,488 rows

entity_identifiers

_link, _link_entity_statement, id, scheme, schemename

4,713,488 rows

entity_statement

_link, statementid, statementtype, statementdate, entitytype, name, incorporatedinjurisdiction_name, incorporatedinjurisdiction_code, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_description, foundingdate, unspecifiedentitydetails_reason, unspecifiedentitydetails_description

4,264,860 rows

ooc_annotations

_link, _link_ooc_statement, motivation, description, statementpointertarget, creationdate, createdby_name, createdby_uri

3,037,041 rows

ooc_interests

_link, _link_ooc_statement, type, interestlevel, beneficialownershiporcontrol, startdate, details

3,411,077 rows

ooc_statement

_link, statementid, statementtype, statementdate, subject_describedbyentitystatement, interestedparty_describedbyentitystatement, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_description, interestedparty_describedbypersonstatement

3,411,077 rows

person_statement

_link, statementid, statementtype, persontype, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_description, unspecifiedpersondetails_reason, unspecifiedpersondetails_description

1,128,925 rows

Download SQLite DB: gleif.db 5.2 GB