home / data

Menu
  • Dashboards

hearings_changed

7 rows where item_version = 67

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
67,1 FC/D 4862/2021 67 title 1
67,2 FC/D 4862/2021 67 reference 2
67,3 FC/D 4862/2021 67 type 3
67,4 FC/D 4862/2021 67 coram 4
67,5 FC/D 4862/2021 67 venue 5
67,6 FC/D 4862/2021 67 timestamp 6
67,7 FC/D 4862/2021 67 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 7.61ms · About: choco-up/sg-law-archive-data