UK_PSC

Custom SQL query

Tables

entity_addresses

_link, _link_entity_statement, address, country, type

10,212,238 rows

entity_identifiers

_link, _link_entity_statement, id, scheme, schemename, uri

30,527,459 rows

entity_statement

_link, statementtype, dissolutiondate, entitytype, foundingdate, statementid, statementdate, iscomponent, name, incorporatedinjurisdiction_code, incorporatedinjurisdiction_name, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publicationdate, publicationdetails_publisher_name, publicationdetails_publisher_url, source_assertedby, source_description, source_retrievedat, source_type, source_url, replacesstatements, alternatenames

10,249,069 rows

ooc_interests

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

29,985,745 rows

ooc_statement

_link, statementtype, statementdate, iscomponent, statementid, interestedparty_describedbypersonstatement, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publicationdate, publicationdetails_publisher_name, publicationdetails_publisher_url, source_assertedby, source_description, source_retrievedat, source_type, source_url, subject_describedbyentitystatement, interestedparty_describedbyentitystatement

13,341,502 rows

person_addresses

_link, _link_person_statement, address, country, type

4,486,771 rows

person_identifiers

_link, _link_person_statement, id, schemename, uri

9,347,974 rows

person_names

_link, _link_person_statement, familyname, fullname, givenname, type

9,347,974 rows

person_nationalities

_link, _link_person_statement, code, name

8,178,854 rows

person_statement

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

9,347,974 rows

Download SQLite DB: UK_PSC.db 27.8 GB