home / data

Menu
  • Dashboards

hearings_changed

7 rows where item_version = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
8,1 TUNCA SEDA v VINCENT LIM MIN SHEN 8 title 1
8,2 TUNCA SEDA v VINCENT LIM MIN SHEN 8 reference 2
8,3 TUNCA SEDA v VINCENT LIM MIN SHEN 8 type 3
8,4 TUNCA SEDA v VINCENT LIM MIN SHEN 8 coram 4
8,5 TUNCA SEDA v VINCENT LIM MIN SHEN 8 venue 5
8,6 TUNCA SEDA v VINCENT LIM MIN SHEN 8 timestamp 6
8,7 TUNCA SEDA v VINCENT LIM MIN SHEN 8 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.52ms · About: choco-up/sg-law-archive-data