latvia

Custom SQL query

Tables

entity_addresses

_link, _link_entity_statement, type, address, country

121,462 rows

entity_identifiers

_link, _link_entity_statement, id, scheme

123,719 rows

entity_source_assertedBy

_link, _link_entity_statement, name

121,832 rows

entity_statement

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

121,832 rows

ooc_interests

_link, _link_ooc_statement, type, interestlevel, beneficialownershiporcontrol, details, share_exact

5,669 rows

ooc_source_assertedBy

_link, _link_ooc_statement, name

150,389 rows

ooc_statement

_link, statementid, statementtype, statementdate, iscomponent, subject_describedbyentitystatement, interestedparty_describedbypersonstatement, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, interestedparty_describedbyentitystatement, componentstatementids, interestedparty_unspecified_reason, interestedparty_unspecified_description

150,389 rows

person_addresses

_link, _link_person_statement, type, country

135,557 rows

person_identifiers

_link, _link_person_statement, id, scheme

124,153 rows

person_names

_link, _link_person_statement, type, fullname, familyname, givenname

135,557 rows

person_nationalities

_link, _link_person_statement, name, code

135,557 rows

person_source_assertedBy

_link, _link_person_statement, name

135,591 rows

person_statement

_link, statementid, statementtype, statementdate, iscomponent, persontype, birthdate, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, unspecifiedpersondetails_reason

135,591 rows

Download SQLite DB: latvia.db 250.8 MB