hearings_changed

7 rows where item_version = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
4,1 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 title 1
4,2 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 reference 2
4,3 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 type 3
4,4 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 coram 4
4,5 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 venue 5
4,6 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 timestamp 6
4,7 VINCENT NG (HUANG RONGMING) v LIM HAN JOO 4 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])
);