home / OOH_DigitalSpots_2021_2

publisher_spotsets

14 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: gaia_spotsets, publisher_id

Link rowid ▼ gaia_spotsets publisher_id
1 1 1 None 368
2 2 2 None 525
3 3 3 None 525
4 4 4 None 271
5 5 5 None 89
6 6 6 None 290
7 7 7 None 135
8 8 7 None 603
9 9 8 None 222
10 10 9 None 525
11 11 10 None 271
12 12 11 None 368
13 13 12 None 525
14 14 13 None 525

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE publisher_spotsets (
	gaia_spotsets VARCHAR(10), 
	publisher_id INTEGER, 
	FOREIGN KEY(gaia_spotsets) REFERENCES gaia_spotsets (spotset_id), 
	FOREIGN KEY(publisher_id) REFERENCES publisher (id)
);
Powered by Datasette · Queries took 58.29ms