spot_config

40 rows where time_range = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: count_plays, weekday

config_id ▼ length_spot length_loop count_plays weekday time_range published is_standard
2 10 180 10 Woche 1 2 2 1 1
9 10 180 10 Mo 2 2 2 1 1
16 10 180 10 Di 3 2 2 1 1
23 10 180 10 Mi 4 2 2 1 1
30 10 180 10 Do 5 2 2 1 1
37 10 180 10 Fr 6 2 2 1 1
44 10 180 10 Sa 7 2 2 1 1
51 10 180 10 So 8 2 2 1 1
58 10 180 20 Woche 1 2 2 1 1
65 10 180 20 Mo 2 2 2 1 1
72 10 180 20 Di 3 2 2 1 1
79 10 180 20 Mi 4 2 2 1 1
86 10 180 20 Do 5 2 2 1 1
93 10 180 20 Fr 6 2 2 1 1
100 10 180 20 Sa 7 2 2 1 1
107 10 180 20 So 8 2 2 1 1
114 10 180 40 Woche 1 2 2 1 1
121 10 180 40 Mo 2 2 2 1 1
128 10 180 40 Di 3 2 2 1 1
135 10 180 40 Mi 4 2 2 1 1
142 10 180 40 Do 5 2 2 1 1
149 10 180 40 Fr 6 2 2 1 1
156 10 180 40 Sa 7 2 2 1 1
163 10 180 40 So 8 2 2 1 1
170 10 180 60 Woche 1 2 2 1 1
177 10 180 60 Mo 2 2 2 1 1
184 10 180 60 Di 3 2 2 1 1
191 10 180 60 Mi 4 2 2 1 1
198 10 180 60 Do 5 2 2 1 1
205 10 180 60 Fr 6 2 2 1 1
212 10 180 60 Sa 7 2 2 1 1
219 10 180 60 So 8 2 2 1 1
226 10 180 80 Woche 1 2 2 1 1
233 10 180 80 Mo 2 2 2 1 1
240 10 180 80 Di 3 2 2 1 1
247 10 180 80 Mi 4 2 2 1 1
254 10 180 80 Do 5 2 2 1 1
261 10 180 80 Fr 6 2 2 1 1
268 10 180 80 Sa 7 2 2 1 1
275 10 180 80 So 8 2 2 1 1

Advanced export

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

CSV options: 

CREATE TABLE spot_config (
	config_id INTEGER NOT NULL, 
	length_spot INTEGER, 
	length_loop INTEGER, 
	count_plays INTEGER, 
	weekday INTEGER, 
	time_range INTEGER, 
	published BOOLEAN, 
	is_standard BOOLEAN, 
	PRIMARY KEY (config_id), 
	UNIQUE (config_id), 
	FOREIGN KEY(weekday) REFERENCES weekday (id), 
	FOREIGN KEY(time_range) REFERENCES time_range (id)
);