media_variant
190 rows where media = 850
This data as json, CSV (advanced)
| id ▼ | media | variant | study_code | study_status | raw_sample |
|---|---|---|---|---|---|
| 161311 | MDR BASIC 850 | Schon mal gehört 1 | <HGMDRK>KOJF | ok | 13709 |
| 161312 | MDR BASIC 850 | Hörer in den letzten 14 Tagen 2 | <HGMDRK>KOJA | ok | 7282 |
| 161313 | MDR BASIC 850 | WHK 3 | <HGMDRK>KOJANEW | ok | 8905 |
| 161314 | MDR BASIC 850 | Tagesreichweite 4 | <HGMDRK>05002400 | ok | 3194 |
| 161315 | MDR BASIC 850 | Durchschnitt 6-18 Uhr 5 | <HGMDRK>D06001800 | ok | 952.416667 |
| 161316 | MDR BASIC 850 | 5.00 - 6.00 Uhr 6 | <HGMDRK>05000600 | ok | 328 |
| 161317 | MDR BASIC 850 | 6.00 - 7.00 Uhr 7 | <HGMDRK>06000700 | ok | 722 |
| 161318 | MDR BASIC 850 | 7.00 - 8.00 Uhr 8 | <HGMDRK>07000800 | ok | 1253 |
| 161319 | MDR BASIC 850 | 8.00 - 9.00 Uhr 9 | <HGMDRK>08000900 | ok | 1440 |
| 161320 | MDR BASIC 850 | 9.00 - 10.00 Uhr 10 | <HGMDRK>09001000 | ok | 1220 |
| 161321 | MDR BASIC 850 | 10.00 - 11.00 Uhr 11 | <HGMDRK>10001100 | ok | 1047 |
| 161322 | MDR BASIC 850 | 11.00 - 12.00 Uhr 12 | <HGMDRK>11001200 | ok | 1007 |
| 161323 | MDR BASIC 850 | 12.00 - 13.00 Uhr 13 | <HGMDRK>12001300 | ok | 1017 |
| 161324 | MDR BASIC 850 | 13.00 - 14.00 Uhr 14 | <HGMDRK>13001400 | ok | 777 |
| 161325 | MDR BASIC 850 | 14.00 - 15.00 Uhr 15 | <HGMDRK>14001500 | ok | 705 |
| 161326 | MDR BASIC 850 | 15.00 - 16.00 Uhr 16 | <HGMDRK>15001600 | ok | 738 |
| 161327 | MDR BASIC 850 | 16.00 - 17.00 Uhr 17 | <HGMDRK>16001700 | ok | 771 |
| 161328 | MDR BASIC 850 | 17.00 - 18.00 Uhr 18 | <HGMDRK>17001800 | ok | 732 |
| 161329 | MDR BASIC 850 | 18.00 - 19.00 Uhr 19 | <HGMDRK>18001900 | ok | 694 |
| 161330 | MDR BASIC 850 | 19.00 - 20.00 Uhr 20 | <HGMDRK>19002000 | ok | 419 |
| 161331 | MDR BASIC 850 | 20.00 - 21.00 Uhr 21 | <HGMDRK>20002100 | ok | 230 |
| 161332 | MDR BASIC 850 | 21.00 - 22.00 Uhr 22 | <HGMDRK>21002200 | ok | 154 |
| 161333 | MDR BASIC 850 | 22.00 - 23.00 Uhr 23 | <HGMDRK>22002300 | ok | 119 |
| 161334 | MDR BASIC 850 | 23.00 - 24.00 Uhr 24 | <HGMDRK>23002400 | ok | 85 |
| 161335 | MDR BASIC 850 | 5.00 - 5.15 Uhr 25 | <HGMDRK>05000515 | ok | 119 |
| 161336 | MDR BASIC 850 | 5.15 - 5.30 Uhr 26 | <HGMDRK>05150530 | ok | 141 |
| 161337 | MDR BASIC 850 | 5.30 - 5.45 Uhr 27 | <HGMDRK>05300545 | ok | 219 |
| 161338 | MDR BASIC 850 | 5.45 - 6.00 Uhr 28 | <HGMDRK>05450600 | ok | 255 |
| 161339 | MDR BASIC 850 | 6.00 - 6.15 Uhr 29 | <HGMDRK>06000615 | ok | 377 |
| 161340 | MDR BASIC 850 | 6.15 - 6.30 Uhr 30 | <HGMDRK>06150630 | ok | 420 |
| 161341 | MDR BASIC 850 | 6.30 - 6.45 Uhr 31 | <HGMDRK>06300645 | ok | 483 |
| 161342 | MDR BASIC 850 | 6.45 - 7.00 Uhr 32 | <HGMDRK>06450700 | ok | 522 |
| 161343 | MDR BASIC 850 | 7.00 - 7.15 Uhr 33 | <HGMDRK>07000715 | ok | 723 |
| 161344 | MDR BASIC 850 | 7.15 - 7.30 Uhr 34 | <HGMDRK>07150730 | ok | 761 |
| 161345 | MDR BASIC 850 | 7.30 - 7.45 Uhr 35 | <HGMDRK>07300745 | ok | 892 |
| 161346 | MDR BASIC 850 | 7.45 - 8.00 Uhr 36 | <HGMDRK>07450800 | ok | 926 |
| 161347 | MDR BASIC 850 | 8.00 - 8.15 Uhr 37 | <HGMDRK>08000815 | ok | 1088 |
| 161348 | MDR BASIC 850 | 8.15 - 8.30 Uhr 38 | <HGMDRK>08150830 | ok | 1095 |
| 161349 | MDR BASIC 850 | 8.30 - 8.45 Uhr 39 | <HGMDRK>08300845 | ok | 1068 |
| 161350 | MDR BASIC 850 | 8.45 - 9.00 Uhr 40 | <HGMDRK>08450900 | ok | 1020 |
| 161351 | MDR BASIC 850 | 9.00 - 9.15 Uhr 41 | <HGMDRK>09000915 | ok | 1025 |
| 161352 | MDR BASIC 850 | 9.15 - 9.30 Uhr 42 | <HGMDRK>09150930 | ok | 971 |
| 161353 | MDR BASIC 850 | 9.30 - 9.45 Uhr 43 | <HGMDRK>09300945 | ok | 932 |
| 161354 | MDR BASIC 850 | 9.45 - 10.00 Uhr 44 | <HGMDRK>09451000 | ok | 910 |
| 161355 | MDR BASIC 850 | 10.00 - 10.15 Uhr 45 | <HGMDRK>10001015 | ok | 907 |
| 161356 | MDR BASIC 850 | 10.15 - 10.30 Uhr 46 | <HGMDRK>10151030 | ok | 844 |
| 161357 | MDR BASIC 850 | 10.30 - 10.45 Uhr 47 | <HGMDRK>10301045 | ok | 820 |
| 161358 | MDR BASIC 850 | 10.45 - 11.00 Uhr 48 | <HGMDRK>10451100 | ok | 801 |
| 161359 | MDR BASIC 850 | 11.00 - 11.15 Uhr 49 | <HGMDRK>11001115 | ok | 822 |
| 161360 | MDR BASIC 850 | 11.15 - 11.30 Uhr 50 | <HGMDRK>11151130 | ok | 782 |
| 161361 | MDR BASIC 850 | 11.30 - 11.45 Uhr 51 | <HGMDRK>11301145 | ok | 775 |
| 161362 | MDR BASIC 850 | 11.45 - 12.00 Uhr 52 | <HGMDRK>11451200 | ok | 789 |
| 161363 | MDR BASIC 850 | 12.00 - 12.15 Uhr 53 | <HGMDRK>12001215 | ok | 803 |
| 161364 | MDR BASIC 850 | 12.15 - 12.30 Uhr 54 | <HGMDRK>12151230 | ok | 774 |
| 161365 | MDR BASIC 850 | 12.30 - 12.45 Uhr 55 | <HGMDRK>12301245 | ok | 720 |
| 161366 | MDR BASIC 850 | 12.45 - 13.00 Uhr 56 | <HGMDRK>12451300 | ok | 689 |
| 161367 | MDR BASIC 850 | 13.00 - 13.15 Uhr 57 | <HGMDRK>13001315 | ok | 619 |
| 161368 | MDR BASIC 850 | 13.15 - 13.30 Uhr 58 | <HGMDRK>13151330 | ok | 583 |
| 161369 | MDR BASIC 850 | 13.30 - 13.45 Uhr 59 | <HGMDRK>13301345 | ok | 551 |
| 161370 | MDR BASIC 850 | 13.45 - 14.00 Uhr 60 | <HGMDRK>13451400 | ok | 516 |
| 161371 | MDR BASIC 850 | 14.00 - 14.15 Uhr 61 | <HGMDRK>14001415 | ok | 521 |
| 161372 | MDR BASIC 850 | 14.15 - 14.30 Uhr 62 | <HGMDRK>14151430 | ok | 501 |
| 161373 | MDR BASIC 850 | 14.30 - 14.45 Uhr 63 | <HGMDRK>14301445 | ok | 507 |
| 161374 | MDR BASIC 850 | 14.45 - 15.00 Uhr 64 | <HGMDRK>14451500 | ok | 503 |
| 161375 | MDR BASIC 850 | 15.00 - 15.15 Uhr 65 | <HGMDRK>15001515 | ok | 544 |
| 161376 | MDR BASIC 850 | 15.15 - 15.30 Uhr 66 | <HGMDRK>15151530 | ok | 520 |
| 161377 | MDR BASIC 850 | 15.30 - 15.45 Uhr 67 | <HGMDRK>15301545 | ok | 503 |
| 161378 | MDR BASIC 850 | 15.45 - 16.00 Uhr 68 | <HGMDRK>15451600 | ok | 476 |
| 161379 | MDR BASIC 850 | 16.00 - 16.15 Uhr 69 | <HGMDRK>16001615 | ok | 526 |
| 161380 | MDR BASIC 850 | 16.15 - 16.30 Uhr 70 | <HGMDRK>16151630 | ok | 531 |
| 161381 | MDR BASIC 850 | 16.30 - 16.45 Uhr 71 | <HGMDRK>16301645 | ok | 515 |
| 161382 | MDR BASIC 850 | 16.45 - 17.00 Uhr 72 | <HGMDRK>16451700 | ok | 508 |
| 161383 | MDR BASIC 850 | 17.00 - 17.15 Uhr 73 | <HGMDRK>17001715 | ok | 529 |
| 161384 | MDR BASIC 850 | 17.15 - 17.30 Uhr 74 | <HGMDRK>17151730 | ok | 507 |
| 161385 | MDR BASIC 850 | 17.30 - 17.45 Uhr 75 | <HGMDRK>17301745 | ok | 481 |
| 161386 | MDR BASIC 850 | 17.45 - 18.00 Uhr 76 | <HGMDRK>17451800 | ok | 468 |
| 161387 | MDR BASIC 850 | 18.00 - 18.15 Uhr 77 | <HGMDRK>18001815 | ok | 494 |
| 161388 | MDR BASIC 850 | 18.15 - 18.30 Uhr 78 | <HGMDRK>18151830 | ok | 476 |
| 161389 | MDR BASIC 850 | 18.30 - 18.45 Uhr 79 | <HGMDRK>18301845 | ok | 460 |
| 161390 | MDR BASIC 850 | 18.45 - 19.00 Uhr 80 | <HGMDRK>18451900 | ok | 408 |
| 161391 | MDR BASIC 850 | 19.00 - 19.15 Uhr 81 | <HGMDRK>19001915 | ok | 333 |
| 161392 | MDR BASIC 850 | 19.15 - 19.30 Uhr 82 | <HGMDRK>19151930 | ok | 293 |
| 161393 | MDR BASIC 850 | 19.30 - 19.45 Uhr 83 | <HGMDRK>19301945 | ok | 249 |
| 161394 | MDR BASIC 850 | 19.45 - 20.00 Uhr 84 | <HGMDRK>19452000 | ok | 212 |
| 161395 | MDR BASIC 850 | 20.00 - 20.15 Uhr 85 | <HGMDRK>20002015 | ok | 167 |
| 161396 | MDR BASIC 850 | 20.15 - 20.30 Uhr 86 | <HGMDRK>20152030 | ok | 144 |
| 161397 | MDR BASIC 850 | 20.30 - 20.45 Uhr 87 | <HGMDRK>20302045 | ok | 129 |
| 161398 | MDR BASIC 850 | 20.45 - 21.00 Uhr 88 | <HGMDRK>20452100 | ok | 117 |
| 161399 | MDR BASIC 850 | 21.00 - 21.15 Uhr 89 | <HGMDRK>21002115 | ok | 118 |
| 161400 | MDR BASIC 850 | 21.15 - 21.30 Uhr 90 | <HGMDRK>21152130 | ok | 94 |
| 161401 | MDR BASIC 850 | 21.30 - 21.45 Uhr 91 | <HGMDRK>21302145 | ok | 90 |
| 161402 | MDR BASIC 850 | 21.45 - 22.00 Uhr 92 | <HGMDRK>21452200 | ok | 86 |
| 161403 | MDR BASIC 850 | 22.00 - 22.15 Uhr 93 | <HGMDRK>22002215 | ok | 82 |
| 161404 | MDR BASIC 850 | 22.15 - 22.30 Uhr 94 | <HGMDRK>22152230 | ok | 73 |
| 161405 | MDR BASIC 850 | 22.30 - 22.45 Uhr 95 | <HGMDRK>22302245 | ok | 67 |
| 161406 | MDR BASIC 850 | 22.45 - 23.00 Uhr 96 | <HGMDRK>22452300 | ok | 59 |
| 161407 | MDR BASIC 850 | 23.00 - 23.15 Uhr 97 | <HGMDRK>23002315 | ok | 60 |
| 161408 | MDR BASIC 850 | 23.15 - 23.30 Uhr 98 | <HGMDRK>23152330 | ok | 49 |
| 161409 | MDR BASIC 850 | 23.30 - 23.45 Uhr 99 | <HGMDRK>23302345 | ok | 49 |
| 161410 | MDR BASIC 850 | 23.45 - 24.00 Uhr 100 | <HGMDRK>23452400 | ok | 43 |
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);