spot_config
112 rows where time_range = 1
This data as json, copyable, CSV (advanced)
Suggested facets: length_loop, count_plays, weekday, publisher, published, is_standard
| config_id ▼ | length_spot | length_loop | count_plays | weekday | time_range | publisher | published | is_standard |
|---|---|---|---|---|---|---|---|---|
| 1 | 10 | 180 | 10 | Woche 1 | 1 1 | None 368 | 1 | 0 |
| 8 | 10 | 180 | 10 | Mo 2 | 1 1 | None 368 | 1 | 0 |
| 15 | 10 | 180 | 10 | Di 3 | 1 1 | None 368 | 1 | 0 |
| 22 | 10 | 180 | 10 | Mi 4 | 1 1 | None 368 | 1 | 0 |
| 29 | 10 | 180 | 10 | Do 5 | 1 1 | None 368 | 1 | 0 |
| 36 | 10 | 180 | 10 | Fr 6 | 1 1 | None 368 | 1 | 0 |
| 43 | 10 | 180 | 10 | Sa 7 | 1 1 | None 368 | 1 | 0 |
| 50 | 10 | 180 | 10 | So 8 | 1 1 | None 368 | 1 | 0 |
| 57 | 10 | 180 | 20 | Woche 1 | 1 1 | None 368 | 1 | 1 |
| 64 | 10 | 180 | 20 | Mo 2 | 1 1 | None 368 | 1 | 0 |
| 71 | 10 | 180 | 20 | Di 3 | 1 1 | None 368 | 1 | 0 |
| 78 | 10 | 180 | 20 | Mi 4 | 1 1 | None 368 | 1 | 0 |
| 85 | 10 | 180 | 20 | Do 5 | 1 1 | None 368 | 1 | 0 |
| 92 | 10 | 180 | 20 | Fr 6 | 1 1 | None 368 | 1 | 0 |
| 99 | 10 | 180 | 20 | Sa 7 | 1 1 | None 368 | 1 | 0 |
| 106 | 10 | 180 | 20 | So 8 | 1 1 | None 368 | 1 | 0 |
| 113 | 10 | 180 | 40 | Woche 1 | 1 1 | None 368 | 1 | 0 |
| 120 | 10 | 180 | 40 | Mo 2 | 1 1 | None 368 | 1 | 0 |
| 127 | 10 | 180 | 40 | Di 3 | 1 1 | None 368 | 1 | 0 |
| 134 | 10 | 180 | 40 | Mi 4 | 1 1 | None 368 | 1 | 0 |
| 141 | 10 | 180 | 40 | Do 5 | 1 1 | None 368 | 1 | 0 |
| 148 | 10 | 180 | 40 | Fr 6 | 1 1 | None 368 | 1 | 0 |
| 155 | 10 | 180 | 40 | Sa 7 | 1 1 | None 368 | 1 | 0 |
| 162 | 10 | 180 | 40 | So 8 | 1 1 | None 368 | 1 | 0 |
| 169 | 10 | 180 | 60 | Woche 1 | 1 1 | None 368 | 1 | 0 |
| 176 | 10 | 180 | 60 | Mo 2 | 1 1 | None 368 | 1 | 0 |
| 183 | 10 | 180 | 60 | Di 3 | 1 1 | None 368 | 1 | 0 |
| 190 | 10 | 180 | 60 | Mi 4 | 1 1 | None 368 | 1 | 0 |
| 197 | 10 | 180 | 60 | Do 5 | 1 1 | None 368 | 1 | 0 |
| 204 | 10 | 180 | 60 | Fr 6 | 1 1 | None 368 | 1 | 0 |
| 211 | 10 | 180 | 60 | Sa 7 | 1 1 | None 368 | 1 | 0 |
| 218 | 10 | 180 | 60 | So 8 | 1 1 | None 368 | 1 | 0 |
| 225 | 10 | 180 | 80 | Woche 1 | 1 1 | None 368 | 1 | 0 |
| 232 | 10 | 180 | 80 | Mo 2 | 1 1 | None 368 | 1 | 0 |
| 239 | 10 | 180 | 80 | Di 3 | 1 1 | None 368 | 1 | 0 |
| 246 | 10 | 180 | 80 | Mi 4 | 1 1 | None 368 | 1 | 0 |
| 253 | 10 | 180 | 80 | Do 5 | 1 1 | None 368 | 1 | 0 |
| 260 | 10 | 180 | 80 | Fr 6 | 1 1 | None 368 | 1 | 0 |
| 267 | 10 | 180 | 80 | Sa 7 | 1 1 | None 368 | 1 | 0 |
| 274 | 10 | 180 | 80 | So 8 | 1 1 | None 368 | 1 | 0 |
| 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 |
| 329 | 10 | 20 | Woche 1 | 1 1 | None 271 | 1 | 0 | |
| 330 | 10 | 20 | Mo 2 | 1 1 | None 271 | 1 | 0 | |
| 331 | 10 | 20 | Di 3 | 1 1 | None 271 | 1 | 0 | |
| 332 | 10 | 20 | Mi 4 | 1 1 | None 271 | 1 | 0 | |
| 333 | 10 | 20 | Do 5 | 1 1 | None 271 | 1 | 0 | |
| 334 | 10 | 20 | Fr 6 | 1 1 | None 271 | 1 | 0 | |
| 335 | 10 | 20 | Sa 7 | 1 1 | None 271 | 1 | 0 | |
| 336 | 10 | 20 | So 8 | 1 1 | None 271 | 1 | 0 | |
| 337 | 10 | 30 | Woche 1 | 1 1 | None 271 | 1 | 1 | |
| 338 | 10 | 30 | Mo 2 | 1 1 | None 271 | 1 | 0 | |
| 339 | 10 | 30 | Di 3 | 1 1 | None 271 | 1 | 0 | |
| 340 | 10 | 30 | Mi 4 | 1 1 | None 271 | 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) );