home / data

Menu
  • Dashboards

pdpc_undertakings_changed

7 rows where item_version = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Link item_version column
1,27 1 1 organisation 27
1,28 1 1 description 28
1,29 1 1 id 29
1,30 1 1 pdf-content 30
1,31 1 1 url 31
1,32 1 1 pdf-url 32
1,33 1 1 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 7.742ms · About: choco-up/sg-law-archive-data