home / PUP_Spotconfigs_2022_02

spotset_frequencies

12 rows where frequency_id = 20

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id frequency_id
12,20 Goldbach Germany 12 20 20
14,20 Goldbach Germany (2) 14 20 20
15,20 Goldbach Germany (3) 15 20 20
22,20 Ströer (3) 22 20 20
23,20 Ströer (4) 23 20 20
24,20 Ströer (5) 24 20 20
25,20 Ströer (6) 25 20 20
44,20 Goldbach Germany (4) 44 20 20
53,20 Ströer (10) 53 20 20
54,20 Ströer (11) 54 20 20
55,20 Ströer (12) 55 20 20
56,20 Ströer (13) 56 20 20

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE spotset_frequencies (
	spotset_id INTEGER NOT NULL, 
	frequency_id INTEGER NOT NULL, 
	PRIMARY KEY (spotset_id, frequency_id), 
	FOREIGN KEY(spotset_id) REFERENCES spotset (id), 
	FOREIGN KEY(frequency_id) REFERENCES frequency (id)
);
Powered by Datasette · Queries took 5.637ms