data
Tables
hearings
_id, _item_id, title, link, type, reference, timestamp, venue, coram, _commit, charge-number, nature-of-case, parties, hearing-outcome, hearing-type, offence-description, nature_of_case, hearing_type, charge_number, offence_description, hearing_outcome
575,357 rows
lss_dt_reports
_id, _item_id, title, content, pdf-link, pdf-content, timestamp, url, unique_id, _commit
55 rows
pdpc_decisions
_id, _item_id, description, tags, date, pdf-url, nature, title, url, timestamp, pdf-content, decision, _commit, financial_penalties
243 rows
pdpc_undertakings
_id, _item_id, id, organisation, url, timestamp, description, pdf-url, pdf-content, _commit
33 rows
sc
_id, _item_id, title, name, judge-of-appeal, honoris-causa, deceased, organisation, appointment-provision, appointment-date, _commit
105 rows
... and 30 hidden tables
Views
- hearings_version_detail
- sc_version_detail
- pdpc_decisions_version_detail
- lss_dt_reports_version_detail
- pdpc_undertakings_version_detail
Download SQLite DB: data.db 1.0 GB