spot_config
76 rows where time_range = 8
This data as json, copyable, CSV (advanced)
Suggested facets: length_loop, count_plays, weekday
| config_id ▼ | length_spot | length_loop | count_plays | weekday | time_range | published | is_standard |
|---|---|---|---|---|---|---|---|
| 281 | 10 | 60 | 1 | Woche 1 | 8 8 | 1 | 1 |
| 282 | 10 | 60 | 1 | Mo 2 | 8 8 | 1 | 1 |
| 283 | 10 | 60 | 1 | Di 3 | 8 8 | 1 | 1 |
| 284 | 10 | 60 | 1 | Mi 4 | 8 8 | 1 | 1 |
| 285 | 10 | 60 | 1 | Do 5 | 8 8 | 1 | 1 |
| 286 | 10 | 60 | 1 | Fr 6 | 8 8 | 1 | 1 |
| 287 | 10 | 60 | 1 | Sa 7 | 8 8 | 1 | 1 |
| 288 | 10 | 60 | 1 | So 8 | 8 8 | 1 | 1 |
| 289 | 10 | 60 | 18 | Woche 1 | 8 8 | 1 | 1 |
| 290 | 10 | 60 | 18 | Mo 2 | 8 8 | 1 | 1 |
| 291 | 10 | 60 | 18 | Di 3 | 8 8 | 1 | 1 |
| 292 | 10 | 60 | 18 | Mi 4 | 8 8 | 1 | 1 |
| 293 | 10 | 60 | 18 | Do 5 | 8 8 | 1 | 1 |
| 294 | 10 | 60 | 18 | Fr 6 | 8 8 | 1 | 1 |
| 295 | 10 | 60 | 18 | Sa 7 | 8 8 | 1 | 1 |
| 296 | 10 | 60 | 18 | So 8 | 8 8 | 1 | 1 |
| 297 | 10 | 60 | 36 | Woche 1 | 8 8 | 1 | 1 |
| 298 | 10 | 60 | 36 | Mo 2 | 8 8 | 1 | 1 |
| 299 | 10 | 60 | 36 | Di 3 | 8 8 | 1 | 1 |
| 300 | 10 | 60 | 36 | Mi 4 | 8 8 | 1 | 1 |
| 301 | 10 | 60 | 36 | Do 5 | 8 8 | 1 | 1 |
| 302 | 10 | 60 | 36 | Fr 6 | 8 8 | 1 | 1 |
| 303 | 10 | 60 | 36 | Sa 7 | 8 8 | 1 | 1 |
| 304 | 10 | 60 | 36 | So 8 | 8 8 | 1 | 1 |
| 305 | 10 | 60 | 54 | Woche 1 | 8 8 | 1 | 1 |
| 306 | 10 | 60 | 54 | Mo 2 | 8 8 | 1 | 1 |
| 307 | 10 | 60 | 54 | Di 3 | 8 8 | 1 | 1 |
| 308 | 10 | 60 | 54 | Mi 4 | 8 8 | 1 | 1 |
| 309 | 10 | 60 | 54 | Do 5 | 8 8 | 1 | 1 |
| 310 | 10 | 60 | 54 | Fr 6 | 8 8 | 1 | 1 |
| 311 | 10 | 60 | 54 | Sa 7 | 8 8 | 1 | 1 |
| 312 | 10 | 60 | 54 | So 8 | 8 8 | 1 | 1 |
| 313 | 10 | 60 | 72 | Woche 1 | 8 8 | 1 | 1 |
| 314 | 10 | 60 | 72 | Mo 2 | 8 8 | 1 | 1 |
| 315 | 10 | 60 | 72 | Di 3 | 8 8 | 1 | 1 |
| 316 | 10 | 60 | 72 | Mi 4 | 8 8 | 1 | 1 |
| 317 | 10 | 60 | 72 | Do 5 | 8 8 | 1 | 1 |
| 318 | 10 | 60 | 72 | Fr 6 | 8 8 | 1 | 1 |
| 319 | 10 | 60 | 72 | Sa 7 | 8 8 | 1 | 1 |
| 320 | 10 | 60 | 72 | So 8 | 8 8 | 1 | 1 |
| 321 | 10 | 60 | 90 | Woche 1 | 8 8 | 1 | 1 |
| 322 | 10 | 60 | 90 | Mo 2 | 8 8 | 1 | 1 |
| 323 | 10 | 60 | 90 | Di 3 | 8 8 | 1 | 1 |
| 324 | 10 | 60 | 90 | Mi 4 | 8 8 | 1 | 1 |
| 325 | 10 | 60 | 90 | Do 5 | 8 8 | 1 | 1 |
| 326 | 10 | 60 | 90 | Fr 6 | 8 8 | 1 | 1 |
| 327 | 10 | 60 | 90 | Sa 7 | 8 8 | 1 | 1 |
| 328 | 10 | 60 | 90 | So 8 | 8 8 | 1 | 1 |
| 329 | 10 | 20 | Woche 1 | 8 8 | 1 | 1 | |
| 330 | 10 | 20 | Mo 2 | 8 8 | 1 | 1 | |
| 331 | 10 | 20 | Di 3 | 8 8 | 1 | 1 | |
| 332 | 10 | 20 | Mi 4 | 8 8 | 1 | 1 | |
| 333 | 10 | 20 | Do 5 | 8 8 | 1 | 1 | |
| 334 | 10 | 20 | Fr 6 | 8 8 | 1 | 1 | |
| 335 | 10 | 20 | Sa 7 | 8 8 | 1 | 1 | |
| 336 | 10 | 20 | So 8 | 8 8 | 1 | 1 | |
| 337 | 10 | 30 | Woche 1 | 8 8 | 1 | 1 | |
| 338 | 10 | 30 | Mo 2 | 8 8 | 1 | 1 | |
| 339 | 10 | 30 | Di 3 | 8 8 | 1 | 1 | |
| 340 | 10 | 30 | Mi 4 | 8 8 | 1 | 1 | |
| 341 | 10 | 30 | Do 5 | 8 8 | 1 | 1 | |
| 342 | 10 | 30 | Fr 6 | 8 8 | 1 | 1 | |
| 343 | 10 | 30 | Sa 7 | 8 8 | 1 | 1 | |
| 344 | 10 | 30 | So 8 | 8 8 | 1 | 1 | |
| 345 | 10 | 60 | Woche 1 | 8 8 | 1 | 1 | |
| 346 | 10 | 60 | Mo 2 | 8 8 | 1 | 1 | |
| 347 | 10 | 60 | Di 3 | 8 8 | 1 | 1 | |
| 348 | 10 | 60 | Mi 4 | 8 8 | 1 | 1 | |
| 349 | 10 | 60 | Do 5 | 8 8 | 1 | 1 | |
| 350 | 10 | 60 | Fr 6 | 8 8 | 1 | 1 | |
| 351 | 10 | 60 | Sa 7 | 8 8 | 1 | 1 | |
| 352 | 10 | 60 | So 8 | 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 |
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) );