home / PUP_Spotconfigs_2022_01

spotset_timeranges

32 rows where spotset_id = 54

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id timerange_id
54,1 Goldbach Germany (8) 54 00-01 Uhr 1
54,2 Goldbach Germany (8) 54 00-06 Uhr 2
54,3 Goldbach Germany (8) 54 01-02 Uhr 3
54,4 Goldbach Germany (8) 54 02-03 Uhr 4
54,5 Goldbach Germany (8) 54 03-04 Uhr 5
54,6 Goldbach Germany (8) 54 04-05 Uhr 6
54,8 Goldbach Germany (8) 54 05-06 Uhr 8
54,9 Goldbach Germany (8) 54 06-07 Uhr 9
54,11 Goldbach Germany (8) 54 06-09 Uhr 11
54,13 Goldbach Germany (8) 54 07-08 Uhr 13
54,14 Goldbach Germany (8) 54 08-09 Uhr 14
54,16 Goldbach Germany (8) 54 09-10 Uhr 16
54,17 Goldbach Germany (8) 54 09-12 Uhr 17
54,19 Goldbach Germany (8) 54 10-11 Uhr 19
54,21 Goldbach Germany (8) 54 11-12 Uhr 21
54,22 Goldbach Germany (8) 54 12-13 Uhr 22
54,24 Goldbach Germany (8) 54 12-15 Uhr 24
54,25 Goldbach Germany (8) 54 13-14 Uhr 25
54,26 Goldbach Germany (8) 54 14-15 Uhr 26
54,28 Goldbach Germany (8) 54 15-16 Uhr 28
54,29 Goldbach Germany (8) 54 15-18 Uhr 29
54,30 Goldbach Germany (8) 54 16-17 Uhr 30
54,32 Goldbach Germany (8) 54 17-18 Uhr 32
54,33 Goldbach Germany (8) 54 18-19 Uhr 33
54,35 Goldbach Germany (8) 54 18-21 Uhr 35
54,36 Goldbach Germany (8) 54 19-20 Uhr 36
54,37 Goldbach Germany (8) 54 20-21 Uhr 37
54,39 Goldbach Germany (8) 54 21-22 Uhr 39
54,40 Goldbach Germany (8) 54 21-24 Uhr 40
54,41 Goldbach Germany (8) 54 22-23 Uhr 41
54,43 Goldbach Germany (8) 54 23-24 Uhr 43
54,44 Goldbach Germany (8) 54 ganztägig 44

Advanced export

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

CSV options:

CREATE TABLE spotset_timeranges (
	spotset_id INTEGER NOT NULL, 
	timerange_id INTEGER NOT NULL, 
	PRIMARY KEY (spotset_id, timerange_id), 
	FOREIGN KEY(spotset_id) REFERENCES spotset (id), 
	FOREIGN KEY(timerange_id) REFERENCES time_range (id)
);
Powered by Datasette · Queries took 7.656ms