uk_version_0_4
Tables
entity_annotations
_link, _link_entity_statement, motivation, description, statementpointertarget, creationdate, url, createdby_name, createdby_uri
5,626,630 rows
entity_recordDetails_addresses
_link, _link_entity_statement, type, address, postcode, country_name, country_code
5,790,763 rows
entity_recordDetails_identifiers
_link, _link_entity_statement, id, scheme, schemename, uri
5,698,012 rows
entity_statement
_link, statementid, declarationsubject, statementdate, recordid, recordstatus, recordtype, recorddetails_iscomponent, recorddetails_foundingdate, recorddetails_name, recorddetails_entitytype_type, recorddetails_jurisdiction_name, recorddetails_jurisdiction_code, recorddetails_publiclisting_haspubliclisting, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_url, recorddetails_uri, recorddetails_entitytype_details, recorddetails_alternatenames
5,790,763 rows
person_annotations
_link, _link_person_statement, motivation, description, statementpointertarget, creationdate, createdby_name, createdby_uri
1,598,703 rows
person_recordDetails_addresses
_link, _link_person_statement, type, address, postcode, country_name, country_code
12,152,361 rows
person_recordDetails_names
_link, _link_person_statement, type, fullname, familyname, givenname
12,152,361 rows
person_statement
_link, statementid, declarationsubject, statementdate, recordid, recordstatus, recordtype, recorddetails_iscomponent, recorddetails_persontype, recorddetails_birthdate, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_url
12,152,361 rows
relationship_annotations
_link, _link_relationship_statement, motivation, description, statementpointertarget, creationdate, createdby_name, createdby_uri
2,070,899 rows
relationship_recordDetails_interests
_link, _link_relationship_statement, directorindirect, type, beneficialownershiporcontrol, startdate, details, share_maximum, share_minimum, enddate
29,636,778 rows
relationship_statement
_link, statementid, declarationsubject, statementdate, recordid, recordstatus, recordtype, recorddetails_subject, recorddetails_interestedparty, recorddetails_iscomponent, publicationdetails_publicationdate, publicationdetails_bodsversion, publicationdetails_license, publicationdetails_publisher_name, publicationdetails_publisher_url, source_type, source_url, recorddetails_interestedparty_reason, recorddetails_interestedparty_description
13,925,340 rows
Download SQLite DB: uk_version_0_4.db 35.4 GB