media_variant

190 rows where media = 156

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
29451 NDR 90,3 156 Schon mal gehört 1 <HAND90>KOJF ok 3287
29452 NDR 90,3 156 Hörer in den letzten 14 Tagen 2 <HAND90>KOJA ok 1255
29453 NDR 90,3 156 WHK 3 <HAND90>KOJANEW ok 1739
29454 NDR 90,3 156 Tagesreichweite 4 <HAND90>05002400 ok 383
29455 NDR 90,3 156 Durchschnitt 6-18 Uhr 5 <HAND90>D06001800 ok 116.75
29456 NDR 90,3 156 5.00 - 6.00 Uhr 6 <HAND90>05000600 ok 45
29457 NDR 90,3 156 6.00 - 7.00 Uhr 7 <HAND90>06000700 ok 72
29458 NDR 90,3 156 7.00 - 8.00 Uhr 8 <HAND90>07000800 ok 137
29459 NDR 90,3 156 8.00 - 9.00 Uhr 9 <HAND90>08000900 ok 179
29460 NDR 90,3 156 9.00 - 10.00 Uhr 10 <HAND90>09001000 ok 158
29461 NDR 90,3 156 10.00 - 11.00 Uhr 11 <HAND90>10001100 ok 136
29462 NDR 90,3 156 11.00 - 12.00 Uhr 12 <HAND90>11001200 ok 120
29463 NDR 90,3 156 12.00 - 13.00 Uhr 13 <HAND90>12001300 ok 123
29464 NDR 90,3 156 13.00 - 14.00 Uhr 14 <HAND90>13001400 ok 104
29465 NDR 90,3 156 14.00 - 15.00 Uhr 15 <HAND90>14001500 ok 105
29466 NDR 90,3 156 15.00 - 16.00 Uhr 16 <HAND90>15001600 ok 92
29467 NDR 90,3 156 16.00 - 17.00 Uhr 17 <HAND90>16001700 ok 91
29468 NDR 90,3 156 17.00 - 18.00 Uhr 18 <HAND90>17001800 ok 84
29469 NDR 90,3 156 18.00 - 19.00 Uhr 19 <HAND90>18001900 ok 73
29470 NDR 90,3 156 19.00 - 20.00 Uhr 20 <HAND90>19002000 ok 52
29471 NDR 90,3 156 20.00 - 21.00 Uhr 21 <HAND90>20002100 ok 28
29472 NDR 90,3 156 21.00 - 22.00 Uhr 22 <HAND90>21002200 ok 19
29473 NDR 90,3 156 22.00 - 23.00 Uhr 23 <HAND90>22002300 ok 17
29474 NDR 90,3 156 23.00 - 24.00 Uhr 24 <HAND90>23002400 ok 16
29475 NDR 90,3 156 5.00 - 5.15 Uhr 25 <HAND90>05000515 ok 26
29476 NDR 90,3 156 5.15 - 5.30 Uhr 26 <HAND90>05150530 ok 26
29477 NDR 90,3 156 5.30 - 5.45 Uhr 27 <HAND90>05300545 ok 35
29478 NDR 90,3 156 5.45 - 6.00 Uhr 28 <HAND90>05450600 ok 35
29479 NDR 90,3 156 6.00 - 6.15 Uhr 29 <HAND90>06000615 ok 35
29480 NDR 90,3 156 6.15 - 6.30 Uhr 30 <HAND90>06150630 ok 45
29481 NDR 90,3 156 6.30 - 6.45 Uhr 31 <HAND90>06300645 ok 49
29482 NDR 90,3 156 6.45 - 7.00 Uhr 32 <HAND90>06450700 ok 52
29483 NDR 90,3 156 7.00 - 7.15 Uhr 33 <HAND90>07000715 ok 82
29484 NDR 90,3 156 7.15 - 7.30 Uhr 34 <HAND90>07150730 ok 90
29485 NDR 90,3 156 7.30 - 7.45 Uhr 35 <HAND90>07300745 ok 99
29486 NDR 90,3 156 7.45 - 8.00 Uhr 36 <HAND90>07450800 ok 101
29487 NDR 90,3 156 8.00 - 8.15 Uhr 37 <HAND90>08000815 ok 134
29488 NDR 90,3 156 8.15 - 8.30 Uhr 38 <HAND90>08150830 ok 129
29489 NDR 90,3 156 8.30 - 8.45 Uhr 39 <HAND90>08300845 ok 134
29490 NDR 90,3 156 8.45 - 9.00 Uhr 40 <HAND90>08450900 ok 131
29491 NDR 90,3 156 9.00 - 9.15 Uhr 41 <HAND90>09000915 ok 132
29492 NDR 90,3 156 9.15 - 9.30 Uhr 42 <HAND90>09150930 ok 133
29493 NDR 90,3 156 9.30 - 9.45 Uhr 43 <HAND90>09300945 ok 118
29494 NDR 90,3 156 9.45 - 10.00 Uhr 44 <HAND90>09451000 ok 120
29495 NDR 90,3 156 10.00 - 10.15 Uhr 45 <HAND90>10001015 ok 116
29496 NDR 90,3 156 10.15 - 10.30 Uhr 46 <HAND90>10151030 ok 108
29497 NDR 90,3 156 10.30 - 10.45 Uhr 47 <HAND90>10301045 ok 105
29498 NDR 90,3 156 10.45 - 11.00 Uhr 48 <HAND90>10451100 ok 99
29499 NDR 90,3 156 11.00 - 11.15 Uhr 49 <HAND90>11001115 ok 102
29500 NDR 90,3 156 11.15 - 11.30 Uhr 50 <HAND90>11151130 ok 95
29501 NDR 90,3 156 11.30 - 11.45 Uhr 51 <HAND90>11301145 ok 100
29502 NDR 90,3 156 11.45 - 12.00 Uhr 52 <HAND90>11451200 ok 96
29503 NDR 90,3 156 12.00 - 12.15 Uhr 53 <HAND90>12001215 ok 98
29504 NDR 90,3 156 12.15 - 12.30 Uhr 54 <HAND90>12151230 ok 87
29505 NDR 90,3 156 12.30 - 12.45 Uhr 55 <HAND90>12301245 ok 87
29506 NDR 90,3 156 12.45 - 13.00 Uhr 56 <HAND90>12451300 ok 94
29507 NDR 90,3 156 13.00 - 13.15 Uhr 57 <HAND90>13001315 ok 89
29508 NDR 90,3 156 13.15 - 13.30 Uhr 58 <HAND90>13151330 ok 80
29509 NDR 90,3 156 13.30 - 13.45 Uhr 59 <HAND90>13301345 ok 77
29510 NDR 90,3 156 13.45 - 14.00 Uhr 60 <HAND90>13451400 ok 76
29511 NDR 90,3 156 14.00 - 14.15 Uhr 61 <HAND90>14001415 ok 80
29512 NDR 90,3 156 14.15 - 14.30 Uhr 62 <HAND90>14151430 ok 81
29513 NDR 90,3 156 14.30 - 14.45 Uhr 63 <HAND90>14301445 ok 80
29514 NDR 90,3 156 14.45 - 15.00 Uhr 64 <HAND90>14451500 ok 77
29515 NDR 90,3 156 15.00 - 15.15 Uhr 65 <HAND90>15001515 ok 76
29516 NDR 90,3 156 15.15 - 15.30 Uhr 66 <HAND90>15151530 ok 74
29517 NDR 90,3 156 15.30 - 15.45 Uhr 67 <HAND90>15301545 ok 68
29518 NDR 90,3 156 15.45 - 16.00 Uhr 68 <HAND90>15451600 ok 66
29519 NDR 90,3 156 16.00 - 16.15 Uhr 69 <HAND90>16001615 ok 66
29520 NDR 90,3 156 16.15 - 16.30 Uhr 70 <HAND90>16151630 ok 65
29521 NDR 90,3 156 16.30 - 16.45 Uhr 71 <HAND90>16301645 ok 63
29522 NDR 90,3 156 16.45 - 17.00 Uhr 72 <HAND90>16451700 ok 57
29523 NDR 90,3 156 17.00 - 17.15 Uhr 73 <HAND90>17001715 ok 69
29524 NDR 90,3 156 17.15 - 17.30 Uhr 74 <HAND90>17151730 ok 58
29525 NDR 90,3 156 17.30 - 17.45 Uhr 75 <HAND90>17301745 ok 54
29526 NDR 90,3 156 17.45 - 18.00 Uhr 76 <HAND90>17451800 ok 54
29527 NDR 90,3 156 18.00 - 18.15 Uhr 77 <HAND90>18001815 ok 57
29528 NDR 90,3 156 18.15 - 18.30 Uhr 78 <HAND90>18151830 ok 50
29529 NDR 90,3 156 18.30 - 18.45 Uhr 79 <HAND90>18301845 ok 44
29530 NDR 90,3 156 18.45 - 19.00 Uhr 80 <HAND90>18451900 ok 38
29531 NDR 90,3 156 19.00 - 19.15 Uhr 81 <HAND90>19001915 ok 42
29532 NDR 90,3 156 19.15 - 19.30 Uhr 82 <HAND90>19151930 ok 34
29533 NDR 90,3 156 19.30 - 19.45 Uhr 83 <HAND90>19301945 ok 32
29534 NDR 90,3 156 19.45 - 20.00 Uhr 84 <HAND90>19452000 ok 30
29535 NDR 90,3 156 20.00 - 20.15 Uhr 85 <HAND90>20002015 ok 21
29536 NDR 90,3 156 20.15 - 20.30 Uhr 86 <HAND90>20152030 ok 18
29537 NDR 90,3 156 20.30 - 20.45 Uhr 87 <HAND90>20302045 ok 19
29538 NDR 90,3 156 20.45 - 21.00 Uhr 88 <HAND90>20452100 ok 15
29539 NDR 90,3 156 21.00 - 21.15 Uhr 89 <HAND90>21002115 ok 14
29540 NDR 90,3 156 21.15 - 21.30 Uhr 90 <HAND90>21152130 ok 11
29541 NDR 90,3 156 21.30 - 21.45 Uhr 91 <HAND90>21302145 ok 10
29542 NDR 90,3 156 21.45 - 22.00 Uhr 92 <HAND90>21452200 ok 11
29543 NDR 90,3 156 22.00 - 22.15 Uhr 93 <HAND90>22002215 ok 14
29544 NDR 90,3 156 22.15 - 22.30 Uhr 94 <HAND90>22152230 ok 15
29545 NDR 90,3 156 22.30 - 22.45 Uhr 95 <HAND90>22302245 ok 13
29546 NDR 90,3 156 22.45 - 23.00 Uhr 96 <HAND90>22452300 ok 14
29547 NDR 90,3 156 23.00 - 23.15 Uhr 97 <HAND90>23002315 ok 11
29548 NDR 90,3 156 23.15 - 23.30 Uhr 98 <HAND90>23152330 ok 11
29549 NDR 90,3 156 23.30 - 23.45 Uhr 99 <HAND90>23302345 ok 13
29550 NDR 90,3 156 23.45 - 24.00 Uhr 100 <HAND90>23452400 ok 11

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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_variant ON media_variant (variant);
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);