sc_changed
8 rows where item_version = 42
This data as json, CSV (advanced)
Link | item_version | column |
---|---|---|
42,19 | Justice 42 | honoris-causa 19 |
42,20 | Justice 42 | title 20 |
42,21 | Justice 42 | name 21 |
42,22 | Justice 42 | organisation 22 |
42,23 | Justice 42 | deceased 23 |
42,24 | Justice 42 | appointment-provision 24 |
42,25 | Justice 42 | appointment-date 25 |
42,26 | Justice 42 | judge-of-appeal 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [sc_changed] ( [item_version] INTEGER REFERENCES [sc_version]([_id]), [column] INTEGER REFERENCES [columns]([id]), PRIMARY KEY ([item_version], [column]) );