home

gleif

Custom SQL query

Tables

entity_addresses

_link, _link_entity_statement, type, address, country, postcode

5,226,472 rows

entity_identifiers

_link, _link_entity_statement, id, scheme, schemename

5,226,472 rows

entity_statement

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

4,729,920 rows

ooc_annotations

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

3,483,061 rows

ooc_interests

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

3,901,936 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,901,936 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,366,377 rows

Download SQLite DB: gleif.db 5.9 GB

Powered by Datasette · Queries took 8.151ms