hearings_changed

7 rows where item_version = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
1,1 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 title 1
1,2 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 reference 2
1,3 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 type 3
1,4 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 coram 4
1,5 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 venue 5
1,6 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 timestamp 6
1,7 JASON LAU CHEE LEONG (LIU ZHILIANG) v AJAY KUMAR JAIN 1 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])
);