spot_config
48 rows where publisher = 525
This data as json, copyable, CSV (advanced)
Suggested facets: count_plays, weekday, published, is_standard
| config_id ▼ | length_spot | length_loop | count_plays | weekday | time_range | publisher | published | is_standard |
|---|---|---|---|---|---|---|---|---|
| 281 | 10 | 60 | 1 | Woche 1 | 1 1 | None 525 | 0 | 0 |
| 282 | 10 | 60 | 1 | Mo 2 | 1 1 | None 525 | 0 | 0 |
| 283 | 10 | 60 | 1 | Di 3 | 1 1 | None 525 | 0 | 0 |
| 284 | 10 | 60 | 1 | Mi 4 | 1 1 | None 525 | 0 | 0 |
| 285 | 10 | 60 | 1 | Do 5 | 1 1 | None 525 | 0 | 0 |
| 286 | 10 | 60 | 1 | Fr 6 | 1 1 | None 525 | 0 | 0 |
| 287 | 10 | 60 | 1 | Sa 7 | 1 1 | None 525 | 0 | 0 |
| 288 | 10 | 60 | 1 | So 8 | 1 1 | None 525 | 0 | 0 |
| 289 | 10 | 60 | 18 | Woche 1 | 1 1 | None 525 | 1 | 0 |
| 290 | 10 | 60 | 18 | Mo 2 | 1 1 | None 525 | 1 | 0 |
| 291 | 10 | 60 | 18 | Di 3 | 1 1 | None 525 | 1 | 0 |
| 292 | 10 | 60 | 18 | Mi 4 | 1 1 | None 525 | 1 | 0 |
| 293 | 10 | 60 | 18 | Do 5 | 1 1 | None 525 | 1 | 0 |
| 294 | 10 | 60 | 18 | Fr 6 | 1 1 | None 525 | 1 | 0 |
| 295 | 10 | 60 | 18 | Sa 7 | 1 1 | None 525 | 1 | 0 |
| 296 | 10 | 60 | 18 | So 8 | 1 1 | None 525 | 1 | 0 |
| 297 | 10 | 60 | 36 | Woche 1 | 1 1 | None 525 | 1 | 0 |
| 298 | 10 | 60 | 36 | Mo 2 | 1 1 | None 525 | 1 | 0 |
| 299 | 10 | 60 | 36 | Di 3 | 1 1 | None 525 | 1 | 0 |
| 300 | 10 | 60 | 36 | Mi 4 | 1 1 | None 525 | 1 | 0 |
| 301 | 10 | 60 | 36 | Do 5 | 1 1 | None 525 | 1 | 0 |
| 302 | 10 | 60 | 36 | Fr 6 | 1 1 | None 525 | 1 | 0 |
| 303 | 10 | 60 | 36 | Sa 7 | 1 1 | None 525 | 1 | 0 |
| 304 | 10 | 60 | 36 | So 8 | 1 1 | None 525 | 1 | 0 |
| 305 | 10 | 60 | 54 | Woche 1 | 1 1 | None 525 | 1 | 1 |
| 306 | 10 | 60 | 54 | Mo 2 | 1 1 | None 525 | 1 | 0 |
| 307 | 10 | 60 | 54 | Di 3 | 1 1 | None 525 | 1 | 0 |
| 308 | 10 | 60 | 54 | Mi 4 | 1 1 | None 525 | 1 | 0 |
| 309 | 10 | 60 | 54 | Do 5 | 1 1 | None 525 | 1 | 0 |
| 310 | 10 | 60 | 54 | Fr 6 | 1 1 | None 525 | 1 | 0 |
| 311 | 10 | 60 | 54 | Sa 7 | 1 1 | None 525 | 1 | 0 |
| 312 | 10 | 60 | 54 | So 8 | 1 1 | None 525 | 1 | 0 |
| 313 | 10 | 60 | 72 | Woche 1 | 1 1 | None 525 | 1 | 0 |
| 314 | 10 | 60 | 72 | Mo 2 | 1 1 | None 525 | 1 | 0 |
| 315 | 10 | 60 | 72 | Di 3 | 1 1 | None 525 | 1 | 0 |
| 316 | 10 | 60 | 72 | Mi 4 | 1 1 | None 525 | 1 | 0 |
| 317 | 10 | 60 | 72 | Do 5 | 1 1 | None 525 | 1 | 0 |
| 318 | 10 | 60 | 72 | Fr 6 | 1 1 | None 525 | 1 | 0 |
| 319 | 10 | 60 | 72 | Sa 7 | 1 1 | None 525 | 1 | 0 |
| 320 | 10 | 60 | 72 | So 8 | 1 1 | None 525 | 1 | 0 |
| 321 | 10 | 60 | 90 | Woche 1 | 1 1 | None 525 | 1 | 0 |
| 322 | 10 | 60 | 90 | Mo 2 | 1 1 | None 525 | 1 | 0 |
| 323 | 10 | 60 | 90 | Di 3 | 1 1 | None 525 | 1 | 0 |
| 324 | 10 | 60 | 90 | Mi 4 | 1 1 | None 525 | 1 | 0 |
| 325 | 10 | 60 | 90 | Do 5 | 1 1 | None 525 | 1 | 0 |
| 326 | 10 | 60 | 90 | Fr 6 | 1 1 | None 525 | 1 | 0 |
| 327 | 10 | 60 | 90 | Sa 7 | 1 1 | None 525 | 1 | 0 |
| 328 | 10 | 60 | 90 | So 8 | 1 1 | None 525 | 1 | 0 |
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, publisher 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), FOREIGN KEY(publisher) REFERENCES publisher (id) );