home / data

Menu
  • Dashboards

pdpc_undertakings_changed

7 rows where item_version = 20

✎ View and edit SQL

This data as json, CSV (advanced)

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