home / data

Menu
  • Dashboards

hearings_changed

7 rows where item_version = 92

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
92,1 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 title 1
92,2 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 reference 2
92,3 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 type 3
92,4 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 coram 4
92,5 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 venue 5
92,6 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 timestamp 6
92,7 PUBLIC PROSECUTOR v Chan Wei Jie, Clifford 92 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.369ms · About: choco-up/sg-law-archive-data