media_variant
190 rows where media = 772
This data as json, CSV (advanced)
| id ▼ | media | variant | study_code | study_status | raw_sample |
|---|---|---|---|---|---|
| 146491 | 104.6 RTL 772 | Schon mal gehört 1 | <HF1046>KOJF | ok | 4304 |
| 146492 | 104.6 RTL 772 | Hörer in den letzten 14 Tagen 2 | <HF1046>KOJA | ok | 1807 |
| 146493 | 104.6 RTL 772 | WHK 3 | <HF1046>KOJANEW | ok | 2413 |
| 146494 | 104.6 RTL 772 | Tagesreichweite 4 | <HF1046>05002400 | ok | 492 |
| 146495 | 104.6 RTL 772 | Durchschnitt 6-18 Uhr 5 | <HF1046>D06001800 | ok | 144.083333 |
| 146496 | 104.6 RTL 772 | 5.00 - 6.00 Uhr 6 | <HF1046>05000600 | ok | 68 |
| 146497 | 104.6 RTL 772 | 6.00 - 7.00 Uhr 7 | <HF1046>06000700 | ok | 153 |
| 146498 | 104.6 RTL 772 | 7.00 - 8.00 Uhr 8 | <HF1046>07000800 | ok | 187 |
| 146499 | 104.6 RTL 772 | 8.00 - 9.00 Uhr 9 | <HF1046>08000900 | ok | 198 |
| 146500 | 104.6 RTL 772 | 9.00 - 10.00 Uhr 10 | <HF1046>09001000 | ok | 171 |
| 146501 | 104.6 RTL 772 | 10.00 - 11.00 Uhr 11 | <HF1046>10001100 | ok | 149 |
| 146502 | 104.6 RTL 772 | 11.00 - 12.00 Uhr 12 | <HF1046>11001200 | ok | 135 |
| 146503 | 104.6 RTL 772 | 12.00 - 13.00 Uhr 13 | <HF1046>12001300 | ok | 127 |
| 146504 | 104.6 RTL 772 | 13.00 - 14.00 Uhr 14 | <HF1046>13001400 | ok | 124 |
| 146505 | 104.6 RTL 772 | 14.00 - 15.00 Uhr 15 | <HF1046>14001500 | ok | 128 |
| 146506 | 104.6 RTL 772 | 15.00 - 16.00 Uhr 16 | <HF1046>15001600 | ok | 116 |
| 146507 | 104.6 RTL 772 | 16.00 - 17.00 Uhr 17 | <HF1046>16001700 | ok | 137 |
| 146508 | 104.6 RTL 772 | 17.00 - 18.00 Uhr 18 | <HF1046>17001800 | ok | 104 |
| 146509 | 104.6 RTL 772 | 18.00 - 19.00 Uhr 19 | <HF1046>18001900 | ok | 100 |
| 146510 | 104.6 RTL 772 | 19.00 - 20.00 Uhr 20 | <HF1046>19002000 | ok | 63 |
| 146511 | 104.6 RTL 772 | 20.00 - 21.00 Uhr 21 | <HF1046>20002100 | ok | 40 |
| 146512 | 104.6 RTL 772 | 21.00 - 22.00 Uhr 22 | <HF1046>21002200 | ok | 23 |
| 146513 | 104.6 RTL 772 | 22.00 - 23.00 Uhr 23 | <HF1046>22002300 | ok | 22 |
| 146514 | 104.6 RTL 772 | 23.00 - 24.00 Uhr 24 | <HF1046>23002400 | ok | 15 |
| 146515 | 104.6 RTL 772 | 5.00 - 5.15 Uhr 25 | <HF1046>05000515 | ok | 33 |
| 146516 | 104.6 RTL 772 | 5.15 - 5.30 Uhr 26 | <HF1046>05150530 | ok | 36 |
| 146517 | 104.6 RTL 772 | 5.30 - 5.45 Uhr 27 | <HF1046>05300545 | ok | 48 |
| 146518 | 104.6 RTL 772 | 5.45 - 6.00 Uhr 28 | <HF1046>05450600 | ok | 56 |
| 146519 | 104.6 RTL 772 | 6.00 - 6.15 Uhr 29 | <HF1046>06000615 | ok | 85 |
| 146520 | 104.6 RTL 772 | 6.15 - 6.30 Uhr 30 | <HF1046>06150630 | ok | 98 |
| 146521 | 104.6 RTL 772 | 6.30 - 6.45 Uhr 31 | <HF1046>06300645 | ok | 108 |
| 146522 | 104.6 RTL 772 | 6.45 - 7.00 Uhr 32 | <HF1046>06450700 | ok | 110 |
| 146523 | 104.6 RTL 772 | 7.00 - 7.15 Uhr 33 | <HF1046>07000715 | ok | 127 |
| 146524 | 104.6 RTL 772 | 7.15 - 7.30 Uhr 34 | <HF1046>07150730 | ok | 128 |
| 146525 | 104.6 RTL 772 | 7.30 - 7.45 Uhr 35 | <HF1046>07300745 | ok | 121 |
| 146526 | 104.6 RTL 772 | 7.45 - 8.00 Uhr 36 | <HF1046>07450800 | ok | 114 |
| 146527 | 104.6 RTL 772 | 8.00 - 8.15 Uhr 37 | <HF1046>08000815 | ok | 138 |
| 146528 | 104.6 RTL 772 | 8.15 - 8.30 Uhr 38 | <HF1046>08150830 | ok | 142 |
| 146529 | 104.6 RTL 772 | 8.30 - 8.45 Uhr 39 | <HF1046>08300845 | ok | 137 |
| 146530 | 104.6 RTL 772 | 8.45 - 9.00 Uhr 40 | <HF1046>08450900 | ok | 123 |
| 146531 | 104.6 RTL 772 | 9.00 - 9.15 Uhr 41 | <HF1046>09000915 | ok | 127 |
| 146532 | 104.6 RTL 772 | 9.15 - 9.30 Uhr 42 | <HF1046>09150930 | ok | 126 |
| 146533 | 104.6 RTL 772 | 9.30 - 9.45 Uhr 43 | <HF1046>09300945 | ok | 126 |
| 146534 | 104.6 RTL 772 | 9.45 - 10.00 Uhr 44 | <HF1046>09451000 | ok | 119 |
| 146535 | 104.6 RTL 772 | 10.00 - 10.15 Uhr 45 | <HF1046>10001015 | ok | 117 |
| 146536 | 104.6 RTL 772 | 10.15 - 10.30 Uhr 46 | <HF1046>10151030 | ok | 107 |
| 146537 | 104.6 RTL 772 | 10.30 - 10.45 Uhr 47 | <HF1046>10301045 | ok | 110 |
| 146538 | 104.6 RTL 772 | 10.45 - 11.00 Uhr 48 | <HF1046>10451100 | ok | 103 |
| 146539 | 104.6 RTL 772 | 11.00 - 11.15 Uhr 49 | <HF1046>11001115 | ok | 101 |
| 146540 | 104.6 RTL 772 | 11.15 - 11.30 Uhr 50 | <HF1046>11151130 | ok | 98 |
| 146541 | 104.6 RTL 772 | 11.30 - 11.45 Uhr 51 | <HF1046>11301145 | ok | 97 |
| 146542 | 104.6 RTL 772 | 11.45 - 12.00 Uhr 52 | <HF1046>11451200 | ok | 97 |
| 146543 | 104.6 RTL 772 | 12.00 - 12.15 Uhr 53 | <HF1046>12001215 | ok | 94 |
| 146544 | 104.6 RTL 772 | 12.15 - 12.30 Uhr 54 | <HF1046>12151230 | ok | 91 |
| 146545 | 104.6 RTL 772 | 12.30 - 12.45 Uhr 55 | <HF1046>12301245 | ok | 90 |
| 146546 | 104.6 RTL 772 | 12.45 - 13.00 Uhr 56 | <HF1046>12451300 | ok | 86 |
| 146547 | 104.6 RTL 772 | 13.00 - 13.15 Uhr 57 | <HF1046>13001315 | ok | 89 |
| 146548 | 104.6 RTL 772 | 13.15 - 13.30 Uhr 58 | <HF1046>13151330 | ok | 89 |
| 146549 | 104.6 RTL 772 | 13.30 - 13.45 Uhr 59 | <HF1046>13301345 | ok | 93 |
| 146550 | 104.6 RTL 772 | 13.45 - 14.00 Uhr 60 | <HF1046>13451400 | ok | 95 |
| 146551 | 104.6 RTL 772 | 14.00 - 14.15 Uhr 61 | <HF1046>14001415 | ok | 98 |
| 146552 | 104.6 RTL 772 | 14.15 - 14.30 Uhr 62 | <HF1046>14151430 | ok | 95 |
| 146553 | 104.6 RTL 772 | 14.30 - 14.45 Uhr 63 | <HF1046>14301445 | ok | 91 |
| 146554 | 104.6 RTL 772 | 14.45 - 15.00 Uhr 64 | <HF1046>14451500 | ok | 92 |
| 146555 | 104.6 RTL 772 | 15.00 - 15.15 Uhr 65 | <HF1046>15001515 | ok | 88 |
| 146556 | 104.6 RTL 772 | 15.15 - 15.30 Uhr 66 | <HF1046>15151530 | ok | 89 |
| 146557 | 104.6 RTL 772 | 15.30 - 15.45 Uhr 67 | <HF1046>15301545 | ok | 78 |
| 146558 | 104.6 RTL 772 | 15.45 - 16.00 Uhr 68 | <HF1046>15451600 | ok | 79 |
| 146559 | 104.6 RTL 772 | 16.00 - 16.15 Uhr 69 | <HF1046>16001615 | ok | 90 |
| 146560 | 104.6 RTL 772 | 16.15 - 16.30 Uhr 70 | <HF1046>16151630 | ok | 96 |
| 146561 | 104.6 RTL 772 | 16.30 - 16.45 Uhr 71 | <HF1046>16301645 | ok | 98 |
| 146562 | 104.6 RTL 772 | 16.45 - 17.00 Uhr 72 | <HF1046>16451700 | ok | 89 |
| 146563 | 104.6 RTL 772 | 17.00 - 17.15 Uhr 73 | <HF1046>17001715 | ok | 77 |
| 146564 | 104.6 RTL 772 | 17.15 - 17.30 Uhr 74 | <HF1046>17151730 | ok | 67 |
| 146565 | 104.6 RTL 772 | 17.30 - 17.45 Uhr 75 | <HF1046>17301745 | ok | 63 |
| 146566 | 104.6 RTL 772 | 17.45 - 18.00 Uhr 76 | <HF1046>17451800 | ok | 64 |
| 146567 | 104.6 RTL 772 | 18.00 - 18.15 Uhr 77 | <HF1046>18001815 | ok | 72 |
| 146568 | 104.6 RTL 772 | 18.15 - 18.30 Uhr 78 | <HF1046>18151830 | ok | 60 |
| 146569 | 104.6 RTL 772 | 18.30 - 18.45 Uhr 79 | <HF1046>18301845 | ok | 55 |
| 146570 | 104.6 RTL 772 | 18.45 - 19.00 Uhr 80 | <HF1046>18451900 | ok | 53 |
| 146571 | 104.6 RTL 772 | 19.00 - 19.15 Uhr 81 | <HF1046>19001915 | ok | 44 |
| 146572 | 104.6 RTL 772 | 19.15 - 19.30 Uhr 82 | <HF1046>19151930 | ok | 38 |
| 146573 | 104.6 RTL 772 | 19.30 - 19.45 Uhr 83 | <HF1046>19301945 | ok | 35 |
| 146574 | 104.6 RTL 772 | 19.45 - 20.00 Uhr 84 | <HF1046>19452000 | ok | 34 |
| 146575 | 104.6 RTL 772 | 20.00 - 20.15 Uhr 85 | <HF1046>20002015 | ok | 27 |
| 146576 | 104.6 RTL 772 | 20.15 - 20.30 Uhr 86 | <HF1046>20152030 | ok | 20 |
| 146577 | 104.6 RTL 772 | 20.30 - 20.45 Uhr 87 | <HF1046>20302045 | ok | 21 |
| 146578 | 104.6 RTL 772 | 20.45 - 21.00 Uhr 88 | <HF1046>20452100 | ok | 17 |
| 146579 | 104.6 RTL 772 | 21.00 - 21.15 Uhr 89 | <HF1046>21002115 | ok | 15 |
| 146580 | 104.6 RTL 772 | 21.15 - 21.30 Uhr 90 | <HF1046>21152130 | ok | 16 |
| 146581 | 104.6 RTL 772 | 21.30 - 21.45 Uhr 91 | <HF1046>21302145 | ok | 15 |
| 146582 | 104.6 RTL 772 | 21.45 - 22.00 Uhr 92 | <HF1046>21452200 | ok | 15 |
| 146583 | 104.6 RTL 772 | 22.00 - 22.15 Uhr 93 | <HF1046>22002215 | ok | 13 |
| 146584 | 104.6 RTL 772 | 22.15 - 22.30 Uhr 94 | <HF1046>22152230 | ok | 16 |
| 146585 | 104.6 RTL 772 | 22.30 - 22.45 Uhr 95 | <HF1046>22302245 | ok | 12 |
| 146586 | 104.6 RTL 772 | 22.45 - 23.00 Uhr 96 | <HF1046>22452300 | ok | 9 |
| 146587 | 104.6 RTL 772 | 23.00 - 23.15 Uhr 97 | <HF1046>23002315 | ok | 12 |
| 146588 | 104.6 RTL 772 | 23.15 - 23.30 Uhr 98 | <HF1046>23152330 | ok | 8 |
| 146589 | 104.6 RTL 772 | 23.30 - 23.45 Uhr 99 | <HF1046>23302345 | ok | 8 |
| 146590 | 104.6 RTL 772 | 23.45 - 24.00 Uhr 100 | <HF1046>23452400 | ok | 11 |
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 INDEX ix_media_variant_study_status ON media_variant (study_status); CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code); CREATE INDEX ix_media_variant_media ON media_variant (media); CREATE INDEX ix_media_variant_variant ON media_variant (variant);