spot_config

65 rows where weekday = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: count_plays, time_range

config_id ▼ length_spot length_loop count_plays weekday time_range published is_standard
8 10   10 Mo 2 1 1 1 1
9 10   10 Mo 2 2 2 1 1
10 10   10 Mo 2 3 3 1 1
11 10   10 Mo 2 4 4 1 1
12 10   10 Mo 2 5 5 1 1
13 10   10 Mo 2 6 6 1 1
14 10   10 Mo 2 7 7 1 1
64 10   20 Mo 2 1 1 1 1
65 10   20 Mo 2 2 2 1 1
66 10   20 Mo 2 3 3 1 1
67 10   20 Mo 2 4 4 1 1
68 10   20 Mo 2 5 5 1 1
69 10   20 Mo 2 6 6 1 1
70 10   20 Mo 2 7 7 1 1
120 10   40 Mo 2 1 1 1 1
121 10   40 Mo 2 2 2 1 1
122 10   40 Mo 2 3 3 1 1
123 10   40 Mo 2 4 4 1 1
124 10   40 Mo 2 5 5 1 1
125 10   40 Mo 2 6 6 1 1
126 10   40 Mo 2 7 7 1 1
176 10   60 Mo 2 1 1 1 1
177 10   60 Mo 2 2 2 1 1
178 10   60 Mo 2 3 3 1 1
179 10   60 Mo 2 4 4 1 1
180 10   60 Mo 2 5 5 1 1
181 10   60 Mo 2 6 6 1 1
182 10   60 Mo 2 7 7 1 1
232 10   80 Mo 2 1 1 1 1
233 10   80 Mo 2 2 2 1 1
234 10   80 Mo 2 3 3 1 1
235 10   80 Mo 2 4 4 1 1
236 10   80 Mo 2 5 5 1 1
237 10   80 Mo 2 6 6 1 1
238 10   80 Mo 2 7 7 1 1
282 10   1 Mo 2 8 8 1 1
290 10   18 Mo 2 8 8 1 1
298 10   36 Mo 2 8 8 1 1
306 10   54 Mo 2 8 8 1 1
314 10   72 Mo 2 8 8 1 1
322 10   90 Mo 2 8 8 1 1
330 10   20 Mo 2 8 8 1 1
338 10   30 Mo 2 8 8 1 1
346 10   60 Mo 2 8 8 1 1
364 10   20 Mo 2 8 8 1 1
365 10   20 Mo 2 2 2 1 1
366 10   20 Mo 2 3 3 1 1
367 10   20 Mo 2 4 4 1 1
368 10   20 Mo 2 5 5 1 1
369 10   20 Mo 2 6 6 1 1
370 10   20 Mo 2 7 7 1 1
420 10   30 Mo 2 8 8 1 1
421 10   30 Mo 2 2 2 1 1
422 10   30 Mo 2 3 3 1 1
423 10   30 Mo 2 4 4 1 1
424 10   30 Mo 2 5 5 1 1
425 10   30 Mo 2 6 6 1 1
426 10   30 Mo 2 7 7 1 1
476 10   40 Mo 2 8 8 1 1
477 10   40 Mo 2 2 2 1 1
478 10   40 Mo 2 3 3 1 1
479 10   40 Mo 2 4 4 1 1
480 10   40 Mo 2 5 5 1 1
481 10   40 Mo 2 6 6 1 1
482 10   40 Mo 2 7 7 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)
);