UK_PSC
Tables
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_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