home / OOH_DigitalSpots_2023_1_v1

publisher_spotsets

21 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: 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 290
6 6 6 None 135
7 7 7 None 222
8 8 8 None 222
9 9 9 None 668
10 10 10 None 668
11 11 12 None 449
12 12 13 None 449
13 13 14 None 525
14 14 15 None 368
15 15 16 None 525
16 16 17 None 271
17 17 18 None 525
18 18 19 None 222
19 19 20 None 668
20 20 21 None 525
21 21 22 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 9.114ms