UK_PSC

Custom SQL query

Tables

entity_addresses

_link, _link_entity_statement, type, address, country

9,388,227 rows

entity_identifiers

_link, _link_entity_statement, id, scheme, schemename, uri

28,007,289 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, dissolutiondate, source_type, source_description, source_url, source_retrievedat, source_assertedby, replacesstatements

9,423,380 rows

ooc_interests

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

27,498,157 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, source_description, source_url, source_retrievedat, source_assertedby, interestedparty_describedbyentitystatement

12,346,039 rows

person_addresses

_link, _link_person_statement, type, address, country

4,214,230 rows

person_identifiers

_link, _link_person_statement, id, schemename, uri

8,832,106 rows

person_names

_link, _link_person_statement, type, fullname, familyname, givenname

8,832,106 rows

person_nationalities

_link, _link_person_statement, name, code

7,744,139 rows

person_statement

_link, statementid, statementtype, statementdate, iscomponent, persontype, birthdate, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_description, source_url, source_retrievedat, source_assertedby, replacesstatements

8,832,106 rows

Download SQLite DB: UK_PSC.db 25.8 GB