spot_config

44 rows where weekday = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: length_loop, count_plays, time_range

config_id ▼ length_spot length_loop count_plays weekday time_range published is_standard
15 10 180 10 Di 3 1 1 1 1
16 10 180 10 Di 3 2 2 1 1
17 10 180 10 Di 3 3 3 1 1
18 10 180 10 Di 3 4 4 1 1
19 10 180 10 Di 3 5 5 1 1
20 10 180 10 Di 3 6 6 1 1
21 10 180 10 Di 3 7 7 1 1
71 10 180 20 Di 3 1 1 1 1
72 10 180 20 Di 3 2 2 1 1
73 10 180 20 Di 3 3 3 1 1
74 10 180 20 Di 3 4 4 1 1
75 10 180 20 Di 3 5 5 1 1
76 10 180 20 Di 3 6 6 1 1
77 10 180 20 Di 3 7 7 1 1
127 10 180 40 Di 3 1 1 1 1
128 10 180 40 Di 3 2 2 1 1
129 10 180 40 Di 3 3 3 1 1
130 10 180 40 Di 3 4 4 1 1
131 10 180 40 Di 3 5 5 1 1
132 10 180 40 Di 3 6 6 1 1
133 10 180 40 Di 3 7 7 1 1
183 10 180 60 Di 3 1 1 1 1
184 10 180 60 Di 3 2 2 1 1
185 10 180 60 Di 3 3 3 1 1
186 10 180 60 Di 3 4 4 1 1
187 10 180 60 Di 3 5 5 1 1
188 10 180 60 Di 3 6 6 1 1
189 10 180 60 Di 3 7 7 1 1
239 10 180 80 Di 3 1 1 1 1
240 10 180 80 Di 3 2 2 1 1
241 10 180 80 Di 3 3 3 1 1
242 10 180 80 Di 3 4 4 1 1
243 10 180 80 Di 3 5 5 1 1
244 10 180 80 Di 3 6 6 1 1
245 10 180 80 Di 3 7 7 1 1
283 10 60 1 Di 3 8 8 1 1
291 10 60 18 Di 3 8 8 1 1
299 10 60 36 Di 3 8 8 1 1
307 10 60 54 Di 3 8 8 1 1
315 10 60 72 Di 3 8 8 1 1
323 10 60 90 Di 3 8 8 1 1
331 10   20 Di 3 8 8 1 1
339 10   30 Di 3 8 8 1 1
347 10   60 Di 3 8 8 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)
);