home / data

Menu
  • Dashboards

pdpc_undertakings_changed

7 rows where item_version = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
30,27 30 30 organisation 27
30,28 30 30 description 28
30,29 30 30 id 29
30,30 30 30 pdf-content 30
30,31 30 30 url 31
30,32 30 30 pdf-url 32
30,33 30 30 timestamp 33

Advanced export

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

CSV options:

CREATE TABLE [pdpc_undertakings_changed] (
   [item_version] INTEGER REFERENCES [pdpc_undertakings_version]([_id]),
   [column] INTEGER REFERENCES [columns]([id]),
   PRIMARY KEY ([item_version], [column])
);
Powered by Datasette · Queries took 6.862ms · About: choco-up/sg-law-archive-data