UK_PSC
Tables
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,432,946 rows
ooc_interests
_link, _link_ooc_statement, details, type, startdate, share_exclusivemaximum, share_exclusiveminimum, share_maximum, share_minimum, enddate
30,575,253 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,576,915 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,466,802 rows
Download SQLite DB: UK_PSC.db 28.3 GB