home / OOH_DigitalSpots_2023_1_v1

publisher_configs

16 rows where publisher_id = 135

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ spot_id publisher_id
355 355 355 None 135
528 528 542 None 135
529 529 541 None 135
530 530 540 None 135
531 531 539 None 135
532 532 538 None 135
533 533 537 None 135
534 534 536 None 135
535 535 535 None 135
536 536 534 None 135
537 537 533 None 135
538 538 532 None 135
539 539 531 None 135
540 540 530 None 135
541 541 529 None 135
542 542 528 None 135

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE publisher_configs (
	spot_id VARCHAR(10), 
	publisher_id INTEGER, 
	FOREIGN KEY(spot_id) REFERENCES spot_config (config_id), 
	FOREIGN KEY(publisher_id) REFERENCES publisher (id)
);
Powered by Datasette · Queries took 68.569ms