home / OOH_DigitalSpots_2023_1

publisher_spotsets

22 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 11 None 831
12 12 12 None 449
13 13 13 None 449
14 14 14 None 525
15 15 15 None 368
16 16 16 None 525
17 17 17 None 271
18 18 18 None 525
19 19 19 None 222
20 20 20 None 668
21 21 21 None 525
22 22 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 8.809ms