hearings_version

723,766 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Next page

CREATE TABLE [hearings_version] (
   [_id] INTEGER PRIMARY KEY,
   [_item] INTEGER REFERENCES [hearings]([_id]),
   [_version] INTEGER,
   [_commit] INTEGER REFERENCES [commits]([id]),
   [title] TEXT,
   [link] TEXT,
   [type] TEXT,
   [reference] TEXT,
   [timestamp] TEXT,
   [venue] TEXT,
   [coram] TEXT,
   [_item_full_hash] TEXT
, [hearing-type] TEXT, [charge-number] TEXT, [offence-description] TEXT, [parties] TEXT, [nature-of-case] TEXT, [hearing-outcome] TEXT, [nature_of_case] TEXT, [hearing_type] TEXT, [charge_number] TEXT, [offence_description] TEXT, [hearing_outcome] TEXT);
CREATE INDEX [idx_hearings_version__item]
    ON [hearings_version] ([_item]);