register

Custom SQL query

Tables

entity_addresses

_link, _link_entity_statement, type, address, country

8,938,878 rows

entity_identifiers

_link, _link_entity_statement, scheme, schemename, id, uri

28,274,712 rows

entity_statement

_link, statementid, statementtype, entitytype, name, foundingdate, dissolutiondate, incorporatedinjurisdiction_name, incorporatedinjurisdiction_code

9,190,604 rows

ooc_interests

_link, _link_ooc_statement, type, details, startdate, share_minimum, share_maximum, share_exclusiveminimum, share_exclusivemaximum, enddate, share_exact

25,238,850 rows

ooc_statement

_link, statementid, statementtype, statementdate, subject_describedbyentitystatement, interestedparty_describedbypersonstatement, source_type, source_description, source_url, source_retrievedat, interestedparty_describedbyentitystatement, interestedparty_unspecified_reason, interestedparty_unspecified_description

12,999,408 rows

person_addresses

_link, _link_person_statement, address, country

9,946,251 rows

person_identifiers

_link, _link_person_statement, schemename, id, uri, scheme

20,806,877 rows

person_names

_link, _link_person_statement, type, fullname

10,166,232 rows

person_nationalities

_link, _link_person_statement, name, code

8,110,826 rows

person_statement

_link, statementid, statementtype, persontype, birthdate, missinginforeason

10,174,287 rows

Download SQLite DB: register.db 23.8 GB