sc_changed

8 rows where item_version = 50

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
50,14 Chief Justice 50 appointment-date 14
50,15 Chief Justice 50 name 15
50,16 Chief Justice 50 title 16
50,17 Chief Justice 50 organisation 17
50,18 Chief Justice 50 appointment-provision 18
50,19 Chief Justice 50 judge-of-appeal 19
50,20 Chief Justice 50 deceased 20
50,21 Chief Justice 50 honoris-causa 21

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [sc_changed] (
   [item_version] INTEGER REFERENCES [sc_version]([_id]),
   [column] INTEGER REFERENCES [columns]([id]),
   PRIMARY KEY ([item_version], [column])
);