media_variant
190 rows where media = 524
This data as json, CSV (advanced)
| id ▼ | media | variant | study_code | study_status | raw_sample |
|---|---|---|---|---|---|
| 99371 | SWR1 BW 524 | Schon mal gehört 1 | <HDSWBW>KOJF | ok | 10743 |
| 99372 | SWR1 BW 524 | Hörer in den letzten 14 Tagen 2 | <HDSWBW>KOJA | ok | 5454 |
| 99373 | SWR1 BW 524 | WHK 3 | <HDSWBW>KOJANEW | ok | 6915 |
| 99374 | SWR1 BW 524 | Tagesreichweite 4 | <HDSWBW>05002400 | ok | 2019 |
| 99375 | SWR1 BW 524 | Durchschnitt 6-18 Uhr 5 | <HDSWBW>D06001800 | ok | 568.166667 |
| 99376 | SWR1 BW 524 | 5.00 - 6.00 Uhr 6 | <HDSWBW>05000600 | ok | 175 |
| 99377 | SWR1 BW 524 | 6.00 - 7.00 Uhr 7 | <HDSWBW>06000700 | ok | 478 |
| 99378 | SWR1 BW 524 | 7.00 - 8.00 Uhr 8 | <HDSWBW>07000800 | ok | 735 |
| 99379 | SWR1 BW 524 | 8.00 - 9.00 Uhr 9 | <HDSWBW>08000900 | ok | 754 |
| 99380 | SWR1 BW 524 | 9.00 - 10.00 Uhr 10 | <HDSWBW>09001000 | ok | 716 |
| 99381 | SWR1 BW 524 | 10.00 - 11.00 Uhr 11 | <HDSWBW>10001100 | ok | 639 |
| 99382 | SWR1 BW 524 | 11.00 - 12.00 Uhr 12 | <HDSWBW>11001200 | ok | 605 |
| 99383 | SWR1 BW 524 | 12.00 - 13.00 Uhr 13 | <HDSWBW>12001300 | ok | 593 |
| 99384 | SWR1 BW 524 | 13.00 - 14.00 Uhr 14 | <HDSWBW>13001400 | ok | 471 |
| 99385 | SWR1 BW 524 | 14.00 - 15.00 Uhr 15 | <HDSWBW>14001500 | ok | 437 |
| 99386 | SWR1 BW 524 | 15.00 - 16.00 Uhr 16 | <HDSWBW>15001600 | ok | 414 |
| 99387 | SWR1 BW 524 | 16.00 - 17.00 Uhr 17 | <HDSWBW>16001700 | ok | 474 |
| 99388 | SWR1 BW 524 | 17.00 - 18.00 Uhr 18 | <HDSWBW>17001800 | ok | 502 |
| 99389 | SWR1 BW 524 | 18.00 - 19.00 Uhr 19 | <HDSWBW>18001900 | ok | 416 |
| 99390 | SWR1 BW 524 | 19.00 - 20.00 Uhr 20 | <HDSWBW>19002000 | ok | 260 |
| 99391 | SWR1 BW 524 | 20.00 - 21.00 Uhr 21 | <HDSWBW>20002100 | ok | 151 |
| 99392 | SWR1 BW 524 | 21.00 - 22.00 Uhr 22 | <HDSWBW>21002200 | ok | 93 |
| 99393 | SWR1 BW 524 | 22.00 - 23.00 Uhr 23 | <HDSWBW>22002300 | ok | 89 |
| 99394 | SWR1 BW 524 | 23.00 - 24.00 Uhr 24 | <HDSWBW>23002400 | ok | 52 |
| 99395 | SWR1 BW 524 | 5.00 - 5.15 Uhr 25 | <HDSWBW>05000515 | ok | 63 |
| 99396 | SWR1 BW 524 | 5.15 - 5.30 Uhr 26 | <HDSWBW>05150530 | ok | 83 |
| 99397 | SWR1 BW 524 | 5.30 - 5.45 Uhr 27 | <HDSWBW>05300545 | ok | 109 |
| 99398 | SWR1 BW 524 | 5.45 - 6.00 Uhr 28 | <HDSWBW>05450600 | ok | 135 |
| 99399 | SWR1 BW 524 | 6.00 - 6.15 Uhr 29 | <HDSWBW>06000615 | ok | 226 |
| 99400 | SWR1 BW 524 | 6.15 - 6.30 Uhr 30 | <HDSWBW>06150630 | ok | 251 |
| 99401 | SWR1 BW 524 | 6.30 - 6.45 Uhr 31 | <HDSWBW>06300645 | ok | 309 |
| 99402 | SWR1 BW 524 | 6.45 - 7.00 Uhr 32 | <HDSWBW>06450700 | ok | 341 |
| 99403 | SWR1 BW 524 | 7.00 - 7.15 Uhr 33 | <HDSWBW>07000715 | ok | 445 |
| 99404 | SWR1 BW 524 | 7.15 - 7.30 Uhr 34 | <HDSWBW>07150730 | ok | 461 |
| 99405 | SWR1 BW 524 | 7.30 - 7.45 Uhr 35 | <HDSWBW>07300745 | ok | 500 |
| 99406 | SWR1 BW 524 | 7.45 - 8.00 Uhr 36 | <HDSWBW>07450800 | ok | 494 |
| 99407 | SWR1 BW 524 | 8.00 - 8.15 Uhr 37 | <HDSWBW>08000815 | ok | 561 |
| 99408 | SWR1 BW 524 | 8.15 - 8.30 Uhr 38 | <HDSWBW>08150830 | ok | 547 |
| 99409 | SWR1 BW 524 | 8.30 - 8.45 Uhr 39 | <HDSWBW>08300845 | ok | 539 |
| 99410 | SWR1 BW 524 | 8.45 - 9.00 Uhr 40 | <HDSWBW>08450900 | ok | 525 |
| 99411 | SWR1 BW 524 | 9.00 - 9.15 Uhr 41 | <HDSWBW>09000915 | ok | 562 |
| 99412 | SWR1 BW 524 | 9.15 - 9.30 Uhr 42 | <HDSWBW>09150930 | ok | 545 |
| 99413 | SWR1 BW 524 | 9.30 - 9.45 Uhr 43 | <HDSWBW>09300945 | ok | 537 |
| 99414 | SWR1 BW 524 | 9.45 - 10.00 Uhr 44 | <HDSWBW>09451000 | ok | 532 |
| 99415 | SWR1 BW 524 | 10.00 - 10.15 Uhr 45 | <HDSWBW>10001015 | ok | 541 |
| 99416 | SWR1 BW 524 | 10.15 - 10.30 Uhr 46 | <HDSWBW>10151030 | ok | 499 |
| 99417 | SWR1 BW 524 | 10.30 - 10.45 Uhr 47 | <HDSWBW>10301045 | ok | 488 |
| 99418 | SWR1 BW 524 | 10.45 - 11.00 Uhr 48 | <HDSWBW>10451100 | ok | 482 |
| 99419 | SWR1 BW 524 | 11.00 - 11.15 Uhr 49 | <HDSWBW>11001115 | ok | 492 |
| 99420 | SWR1 BW 524 | 11.15 - 11.30 Uhr 50 | <HDSWBW>11151130 | ok | 489 |
| 99421 | SWR1 BW 524 | 11.30 - 11.45 Uhr 51 | <HDSWBW>11301145 | ok | 472 |
| 99422 | SWR1 BW 524 | 11.45 - 12.00 Uhr 52 | <HDSWBW>11451200 | ok | 480 |
| 99423 | SWR1 BW 524 | 12.00 - 12.15 Uhr 53 | <HDSWBW>12001215 | ok | 485 |
| 99424 | SWR1 BW 524 | 12.15 - 12.30 Uhr 54 | <HDSWBW>12151230 | ok | 439 |
| 99425 | SWR1 BW 524 | 12.30 - 12.45 Uhr 55 | <HDSWBW>12301245 | ok | 421 |
| 99426 | SWR1 BW 524 | 12.45 - 13.00 Uhr 56 | <HDSWBW>12451300 | ok | 400 |
| 99427 | SWR1 BW 524 | 13.00 - 13.15 Uhr 57 | <HDSWBW>13001315 | ok | 385 |
| 99428 | SWR1 BW 524 | 13.15 - 13.30 Uhr 58 | <HDSWBW>13151330 | ok | 353 |
| 99429 | SWR1 BW 524 | 13.30 - 13.45 Uhr 59 | <HDSWBW>13301345 | ok | 346 |
| 99430 | SWR1 BW 524 | 13.45 - 14.00 Uhr 60 | <HDSWBW>13451400 | ok | 334 |
| 99431 | SWR1 BW 524 | 14.00 - 14.15 Uhr 61 | <HDSWBW>14001415 | ok | 342 |
| 99432 | SWR1 BW 524 | 14.15 - 14.30 Uhr 62 | <HDSWBW>14151430 | ok | 319 |
| 99433 | SWR1 BW 524 | 14.30 - 14.45 Uhr 63 | <HDSWBW>14301445 | ok | 308 |
| 99434 | SWR1 BW 524 | 14.45 - 15.00 Uhr 64 | <HDSWBW>14451500 | ok | 306 |
| 99435 | SWR1 BW 524 | 15.00 - 15.15 Uhr 65 | <HDSWBW>15001515 | ok | 329 |
| 99436 | SWR1 BW 524 | 15.15 - 15.30 Uhr 66 | <HDSWBW>15151530 | ok | 318 |
| 99437 | SWR1 BW 524 | 15.30 - 15.45 Uhr 67 | <HDSWBW>15301545 | ok | 295 |
| 99438 | SWR1 BW 524 | 15.45 - 16.00 Uhr 68 | <HDSWBW>15451600 | ok | 298 |
| 99439 | SWR1 BW 524 | 16.00 - 16.15 Uhr 69 | <HDSWBW>16001615 | ok | 326 |
| 99440 | SWR1 BW 524 | 16.15 - 16.30 Uhr 70 | <HDSWBW>16151630 | ok | 320 |
| 99441 | SWR1 BW 524 | 16.30 - 16.45 Uhr 71 | <HDSWBW>16301645 | ok | 333 |
| 99442 | SWR1 BW 524 | 16.45 - 17.00 Uhr 72 | <HDSWBW>16451700 | ok | 318 |
| 99443 | SWR1 BW 524 | 17.00 - 17.15 Uhr 73 | <HDSWBW>17001715 | ok | 371 |
| 99444 | SWR1 BW 524 | 17.15 - 17.30 Uhr 74 | <HDSWBW>17151730 | ok | 358 |
| 99445 | SWR1 BW 524 | 17.30 - 17.45 Uhr 75 | <HDSWBW>17301745 | ok | 327 |
| 99446 | SWR1 BW 524 | 17.45 - 18.00 Uhr 76 | <HDSWBW>17451800 | ok | 308 |
| 99447 | SWR1 BW 524 | 18.00 - 18.15 Uhr 77 | <HDSWBW>18001815 | ok | 312 |
| 99448 | SWR1 BW 524 | 18.15 - 18.30 Uhr 78 | <HDSWBW>18151830 | ok | 282 |
| 99449 | SWR1 BW 524 | 18.30 - 18.45 Uhr 79 | <HDSWBW>18301845 | ok | 250 |
| 99450 | SWR1 BW 524 | 18.45 - 19.00 Uhr 80 | <HDSWBW>18451900 | ok | 234 |
| 99451 | SWR1 BW 524 | 19.00 - 19.15 Uhr 81 | <HDSWBW>19001915 | ok | 211 |
| 99452 | SWR1 BW 524 | 19.15 - 19.30 Uhr 82 | <HDSWBW>19151930 | ok | 189 |
| 99453 | SWR1 BW 524 | 19.30 - 19.45 Uhr 83 | <HDSWBW>19301945 | ok | 164 |
| 99454 | SWR1 BW 524 | 19.45 - 20.00 Uhr 84 | <HDSWBW>19452000 | ok | 146 |
| 99455 | SWR1 BW 524 | 20.00 - 20.15 Uhr 85 | <HDSWBW>20002015 | ok | 116 |
| 99456 | SWR1 BW 524 | 20.15 - 20.30 Uhr 86 | <HDSWBW>20152030 | ok | 98 |
| 99457 | SWR1 BW 524 | 20.30 - 20.45 Uhr 87 | <HDSWBW>20302045 | ok | 88 |
| 99458 | SWR1 BW 524 | 20.45 - 21.00 Uhr 88 | <HDSWBW>20452100 | ok | 81 |
| 99459 | SWR1 BW 524 | 21.00 - 21.15 Uhr 89 | <HDSWBW>21002115 | ok | 71 |
| 99460 | SWR1 BW 524 | 21.15 - 21.30 Uhr 90 | <HDSWBW>21152130 | ok | 59 |
| 99461 | SWR1 BW 524 | 21.30 - 21.45 Uhr 91 | <HDSWBW>21302145 | ok | 58 |
| 99462 | SWR1 BW 524 | 21.45 - 22.00 Uhr 92 | <HDSWBW>21452200 | ok | 59 |
| 99463 | SWR1 BW 524 | 22.00 - 22.15 Uhr 93 | <HDSWBW>22002215 | ok | 57 |
| 99464 | SWR1 BW 524 | 22.15 - 22.30 Uhr 94 | <HDSWBW>22152230 | ok | 58 |
| 99465 | SWR1 BW 524 | 22.30 - 22.45 Uhr 95 | <HDSWBW>22302245 | ok | 55 |
| 99466 | SWR1 BW 524 | 22.45 - 23.00 Uhr 96 | <HDSWBW>22452300 | ok | 44 |
| 99467 | SWR1 BW 524 | 23.00 - 23.15 Uhr 97 | <HDSWBW>23002315 | ok | 36 |
| 99468 | SWR1 BW 524 | 23.15 - 23.30 Uhr 98 | <HDSWBW>23152330 | ok | 32 |
| 99469 | SWR1 BW 524 | 23.30 - 23.45 Uhr 99 | <HDSWBW>23302345 | ok | 32 |
| 99470 | SWR1 BW 524 | 23.45 - 24.00 Uhr 100 | <HDSWBW>23452400 | ok | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE media_variant ( id INTEGER NOT NULL, media INTEGER, variant INTEGER, study_code VARCHAR(100), study_status VARCHAR(7), raw_sample INTEGER, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(media) REFERENCES media (id), FOREIGN KEY(variant) REFERENCES variant (id) ); CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code); CREATE INDEX ix_media_variant_variant ON media_variant (variant); CREATE INDEX ix_media_variant_media ON media_variant (media); CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);