spot_config
77 rows where weekday = 1
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 |
|---|---|---|---|---|---|---|---|
| 1 | 10 | 10 | Woche 1 | 1 1 | 1 | 1 | |
| 2 | 10 | 10 | Woche 1 | 2 2 | 1 | 1 | |
| 3 | 10 | 10 | Woche 1 | 3 3 | 1 | 1 | |
| 4 | 10 | 10 | Woche 1 | 4 4 | 1 | 1 | |
| 5 | 10 | 10 | Woche 1 | 5 5 | 1 | 1 | |
| 6 | 10 | 10 | Woche 1 | 6 6 | 1 | 1 | |
| 7 | 10 | 10 | Woche 1 | 7 7 | 1 | 1 | |
| 57 | 10 | 20 | Woche 1 | 1 1 | 1 | 1 | |
| 58 | 10 | 20 | Woche 1 | 2 2 | 1 | 1 | |
| 59 | 10 | 20 | Woche 1 | 3 3 | 1 | 1 | |
| 60 | 10 | 20 | Woche 1 | 4 4 | 1 | 1 | |
| 61 | 10 | 20 | Woche 1 | 5 5 | 1 | 1 | |
| 62 | 10 | 20 | Woche 1 | 6 6 | 1 | 1 | |
| 63 | 10 | 20 | Woche 1 | 7 7 | 1 | 1 | |
| 113 | 10 | 40 | Woche 1 | 1 1 | 1 | 1 | |
| 114 | 10 | 40 | Woche 1 | 2 2 | 1 | 1 | |
| 115 | 10 | 40 | Woche 1 | 3 3 | 1 | 1 | |
| 116 | 10 | 40 | Woche 1 | 4 4 | 1 | 1 | |
| 117 | 10 | 40 | Woche 1 | 5 5 | 1 | 1 | |
| 118 | 10 | 40 | Woche 1 | 6 6 | 1 | 1 | |
| 119 | 10 | 40 | Woche 1 | 7 7 | 1 | 1 | |
| 169 | 10 | 60 | Woche 1 | 1 1 | 1 | 1 | |
| 170 | 10 | 60 | Woche 1 | 2 2 | 1 | 1 | |
| 171 | 10 | 60 | Woche 1 | 3 3 | 1 | 1 | |
| 172 | 10 | 60 | Woche 1 | 4 4 | 1 | 1 | |
| 173 | 10 | 60 | Woche 1 | 5 5 | 1 | 1 | |
| 174 | 10 | 60 | Woche 1 | 6 6 | 1 | 1 | |
| 175 | 10 | 60 | Woche 1 | 7 7 | 1 | 1 | |
| 225 | 10 | 80 | Woche 1 | 1 1 | 1 | 1 | |
| 226 | 10 | 80 | Woche 1 | 2 2 | 1 | 1 | |
| 227 | 10 | 80 | Woche 1 | 3 3 | 1 | 1 | |
| 228 | 10 | 80 | Woche 1 | 4 4 | 1 | 1 | |
| 229 | 10 | 80 | Woche 1 | 5 5 | 1 | 1 | |
| 230 | 10 | 80 | Woche 1 | 6 6 | 1 | 1 | |
| 231 | 10 | 80 | Woche 1 | 7 7 | 1 | 1 | |
| 281 | 10 | 1 | Woche 1 | 8 8 | 1 | 1 | |
| 289 | 10 | 18 | Woche 1 | 8 8 | 1 | 1 | |
| 297 | 10 | 36 | Woche 1 | 8 8 | 1 | 1 | |
| 305 | 10 | 54 | Woche 1 | 8 8 | 1 | 1 | |
| 313 | 10 | 72 | Woche 1 | 8 8 | 1 | 1 | |
| 321 | 10 | 90 | Woche 1 | 8 8 | 1 | 1 | |
| 329 | 10 | 20 | Woche 1 | 8 8 | 1 | 1 | |
| 337 | 10 | 30 | Woche 1 | 8 8 | 1 | 1 | |
| 345 | 10 | 60 | Woche 1 | 8 8 | 1 | 1 | |
| 353 | 10 | 60 | Woche 1 | 8 8 | 1 | 1 | |
| 354 | 10 | 90 | Woche 1 | 8 8 | 1 | 1 | |
| 355 | 10 | 60 | Woche 1 | 8 8 | 1 | 1 | |
| 356 | 10 | 60 | Woche 1 | 8 8 | 1 | 1 | |
| 357 | 10 | 20 | Woche 1 | 8 8 | 1 | 1 | |
| 358 | 10 | 20 | Woche 1 | 2 2 | 1 | 1 | |
| 359 | 10 | 20 | Woche 1 | 3 3 | 1 | 1 | |
| 360 | 10 | 20 | Woche 1 | 4 4 | 1 | 1 | |
| 361 | 10 | 20 | Woche 1 | 5 5 | 1 | 1 | |
| 362 | 10 | 20 | Woche 1 | 6 6 | 1 | 1 | |
| 363 | 10 | 20 | Woche 1 | 7 7 | 1 | 1 | |
| 413 | 10 | 30 | Woche 1 | 8 8 | 1 | 1 | |
| 414 | 10 | 30 | Woche 1 | 2 2 | 1 | 1 | |
| 415 | 10 | 30 | Woche 1 | 3 3 | 1 | 1 | |
| 416 | 10 | 30 | Woche 1 | 4 4 | 1 | 1 | |
| 417 | 10 | 30 | Woche 1 | 5 5 | 1 | 1 | |
| 418 | 10 | 30 | Woche 1 | 6 6 | 1 | 1 | |
| 419 | 10 | 30 | Woche 1 | 7 7 | 1 | 1 | |
| 469 | 10 | 40 | Woche 1 | 8 8 | 1 | 1 | |
| 470 | 10 | 40 | Woche 1 | 2 2 | 1 | 1 | |
| 471 | 10 | 40 | Woche 1 | 3 3 | 1 | 1 | |
| 472 | 10 | 40 | Woche 1 | 4 4 | 1 | 1 | |
| 473 | 10 | 40 | Woche 1 | 5 5 | 1 | 1 | |
| 474 | 10 | 40 | Woche 1 | 6 6 | 1 | 1 | |
| 475 | 10 | 40 | Woche 1 | 7 7 | 1 | 1 | |
| 525 | 10 | 20 | Woche 1 | 8 8 | 1 | 1 | |
| 526 | 10 | 30 | Woche 1 | 8 8 | 1 | 1 | |
| 527 | 10 | 40 | Woche 1 | 8 8 | 1 | 1 | |
| 528 | 10 | 20 | Woche 1 | 8 8 | 1 | 1 | |
| 543 | 10 | 60 | Woche 1 | 1 1 | 1 | 1 | |
| 544 | 10 | 50 | Woche 1 | 9 9 | 1 | 1 | |
| 545 | 10 | 25 | Woche 1 | 9 9 | 1 | 1 | |
| 546 | 10 | 36 | Woche 1 | 8 8 | 1 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );