data

Custom SQL query

Tables

fc_judgments

_id, _item_id, tags, date, court, case-number, title, citation, url, counsel, timestamp, coram, html, _commit

105 rows

hearings

_id, _item_id, title, link, type, reference, timestamp, venue, coram, _commit, charge-number, nature-of-case, parties, hearing-outcome, hearing-type, offence-description

403,786 rows

lss_dt_reports

_id, _item_id, title, content, pdf-link, pdf-content, timestamp, url, unique_id, _commit

43 rows

pdpc_decisions

_id, _item_id, description, tags, date, pdf-url, nature, title, url, timestamp, pdf-content, decision, _commit, financial_penalties

257 rows

pdpc_undertakings

_id, _item_id, id, organisation, url, timestamp, description, pdf-url, pdf-content, _commit

63 rows

sal_specialists

_id, _item_id, name, organisation, practice-area, designation, year-of-accreditation, url, _commit

113 rows

sc

_id, _item_id, title, name, judge-of-appeal, honoris-causa, deceased, organisation, appointment-provision, appointment-date, _commit

99 rows

stc_judgments

_id, _item_id, tags, date, court, case-number, title, citation, url, counsel, timestamp, coram, html, _commit

433 rows

telco_fbo

_id, _item_id, name, licence-pdf, _commit, licence-text

85 rows

... and 63 hidden tables

Views

Download SQLite DB: data.db 1003.1 MB