home / data

Menu
  • Dashboards

pdpc_undertakings_changed

7 rows where item_version = 16

✎ View and edit SQL

This data as json, CSV (advanced)

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