home / data

Menu
  • Dashboards

hearings_changed

7 rows where item_version = 91

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
91,1 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 title 1
91,2 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 reference 2
91,3 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 type 3
91,4 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 coram 4
91,5 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 venue 5
91,6 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 timestamp 6
91,7 PUBLIC PROSECUTOR v Colin Chan Wei Ming 91 link 7

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [hearings_changed] (
   [item_version] INTEGER REFERENCES [hearings_version]([_id]),
   [column] INTEGER REFERENCES [columns]([id]),
   PRIMARY KEY ([item_version], [column])
);
Powered by Datasette · Queries took 6.9ms · About: choco-up/sg-law-archive-data