media_variant

190 rows where media = 80

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
15011 RTL RADIO 80 Schon mal gehört 1 <HZRTLR>KOJF ok 12352
15012 RTL RADIO 80 Hörer in den letzten 14 Tagen 2 <HZRTLR>KOJA ok 3146
15013 RTL RADIO 80 WHK 3 <HZRTLR>KOJANEW ok 4996
15014 RTL RADIO 80 Tagesreichweite 4 <HZRTLR>05002400 ok 484
15015 RTL RADIO 80 Durchschnitt 6-18 Uhr 5 <HZRTLR>D06001800 ok 110.416667
15016 RTL RADIO 80 5.00 - 6.00 Uhr 6 <HZRTLR>05000600 ok 41
15017 RTL RADIO 80 6.00 - 7.00 Uhr 7 <HZRTLR>06000700 ok 95
15018 RTL RADIO 80 7.00 - 8.00 Uhr 8 <HZRTLR>07000800 ok 140
15019 RTL RADIO 80 8.00 - 9.00 Uhr 9 <HZRTLR>08000900 ok 142
15020 RTL RADIO 80 9.00 - 10.00 Uhr 10 <HZRTLR>09001000 ok 125
15021 RTL RADIO 80 10.00 - 11.00 Uhr 11 <HZRTLR>10001100 ok 118
15022 RTL RADIO 80 11.00 - 12.00 Uhr 12 <HZRTLR>11001200 ok 117
15023 RTL RADIO 80 12.00 - 13.00 Uhr 13 <HZRTLR>12001300 ok 116
15024 RTL RADIO 80 13.00 - 14.00 Uhr 14 <HZRTLR>13001400 ok 96
15025 RTL RADIO 80 14.00 - 15.00 Uhr 15 <HZRTLR>14001500 ok 103
15026 RTL RADIO 80 15.00 - 16.00 Uhr 16 <HZRTLR>15001600 ok 85
15027 RTL RADIO 80 16.00 - 17.00 Uhr 17 <HZRTLR>16001700 ok 95
15028 RTL RADIO 80 17.00 - 18.00 Uhr 18 <HZRTLR>17001800 ok 93
15029 RTL RADIO 80 18.00 - 19.00 Uhr 19 <HZRTLR>18001900 ok 87
15030 RTL RADIO 80 19.00 - 20.00 Uhr 20 <HZRTLR>19002000 ok 53
15031 RTL RADIO 80 20.00 - 21.00 Uhr 21 <HZRTLR>20002100 ok 37
15032 RTL RADIO 80 21.00 - 22.00 Uhr 22 <HZRTLR>21002200 ok 36
15033 RTL RADIO 80 22.00 - 23.00 Uhr 23 <HZRTLR>22002300 ok 22
15034 RTL RADIO 80 23.00 - 24.00 Uhr 24 <HZRTLR>23002400 ok 13
15035 RTL RADIO 80 5.00 - 5.15 Uhr 25 <HZRTLR>05000515 ok 21
15036 RTL RADIO 80 5.15 - 5.30 Uhr 26 <HZRTLR>05150530 ok 17
15037 RTL RADIO 80 5.30 - 5.45 Uhr 27 <HZRTLR>05300545 ok 25
15038 RTL RADIO 80 5.45 - 6.00 Uhr 28 <HZRTLR>05450600 ok 29
15039 RTL RADIO 80 6.00 - 6.15 Uhr 29 <HZRTLR>06000615 ok 37
15040 RTL RADIO 80 6.15 - 6.30 Uhr 30 <HZRTLR>06150630 ok 54
15041 RTL RADIO 80 6.30 - 6.45 Uhr 31 <HZRTLR>06300645 ok 53
15042 RTL RADIO 80 6.45 - 7.00 Uhr 32 <HZRTLR>06450700 ok 71
15043 RTL RADIO 80 7.00 - 7.15 Uhr 33 <HZRTLR>07000715 ok 81
15044 RTL RADIO 80 7.15 - 7.30 Uhr 34 <HZRTLR>07150730 ok 82
15045 RTL RADIO 80 7.30 - 7.45 Uhr 35 <HZRTLR>07300745 ok 85
15046 RTL RADIO 80 7.45 - 8.00 Uhr 36 <HZRTLR>07450800 ok 86
15047 RTL RADIO 80 8.00 - 8.15 Uhr 37 <HZRTLR>08000815 ok 102
15048 RTL RADIO 80 8.15 - 8.30 Uhr 38 <HZRTLR>08150830 ok 103
15049 RTL RADIO 80 8.30 - 8.45 Uhr 39 <HZRTLR>08300845 ok 99
15050 RTL RADIO 80 8.45 - 9.00 Uhr 40 <HZRTLR>08450900 ok 90
15051 RTL RADIO 80 9.00 - 9.15 Uhr 41 <HZRTLR>09000915 ok 89
15052 RTL RADIO 80 9.15 - 9.30 Uhr 42 <HZRTLR>09150930 ok 96
15053 RTL RADIO 80 9.30 - 9.45 Uhr 43 <HZRTLR>09300945 ok 93
15054 RTL RADIO 80 9.45 - 10.00 Uhr 44 <HZRTLR>09451000 ok 84
15055 RTL RADIO 80 10.00 - 10.15 Uhr 45 <HZRTLR>10001015 ok 88
15056 RTL RADIO 80 10.15 - 10.30 Uhr 46 <HZRTLR>10151030 ok 91
15057 RTL RADIO 80 10.30 - 10.45 Uhr 47 <HZRTLR>10301045 ok 96
15058 RTL RADIO 80 10.45 - 11.00 Uhr 48 <HZRTLR>10451100 ok 88
15059 RTL RADIO 80 11.00 - 11.15 Uhr 49 <HZRTLR>11001115 ok 89
15060 RTL RADIO 80 11.15 - 11.30 Uhr 50 <HZRTLR>11151130 ok 91
15061 RTL RADIO 80 11.30 - 11.45 Uhr 51 <HZRTLR>11301145 ok 92
15062 RTL RADIO 80 11.45 - 12.00 Uhr 52 <HZRTLR>11451200 ok 89
15063 RTL RADIO 80 12.00 - 12.15 Uhr 53 <HZRTLR>12001215 ok 87
15064 RTL RADIO 80 12.15 - 12.30 Uhr 54 <HZRTLR>12151230 ok 83
15065 RTL RADIO 80 12.30 - 12.45 Uhr 55 <HZRTLR>12301245 ok 87
15066 RTL RADIO 80 12.45 - 13.00 Uhr 56 <HZRTLR>12451300 ok 81
15067 RTL RADIO 80 13.00 - 13.15 Uhr 57 <HZRTLR>13001315 ok 73
15068 RTL RADIO 80 13.15 - 13.30 Uhr 58 <HZRTLR>13151330 ok 72
15069 RTL RADIO 80 13.30 - 13.45 Uhr 59 <HZRTLR>13301345 ok 71
15070 RTL RADIO 80 13.45 - 14.00 Uhr 60 <HZRTLR>13451400 ok 68
15071 RTL RADIO 80 14.00 - 14.15 Uhr 61 <HZRTLR>14001415 ok 67
15072 RTL RADIO 80 14.15 - 14.30 Uhr 62 <HZRTLR>14151430 ok 69
15073 RTL RADIO 80 14.30 - 14.45 Uhr 63 <HZRTLR>14301445 ok 71
15074 RTL RADIO 80 14.45 - 15.00 Uhr 64 <HZRTLR>14451500 ok 73
15075 RTL RADIO 80 15.00 - 15.15 Uhr 65 <HZRTLR>15001515 ok 60
15076 RTL RADIO 80 15.15 - 15.30 Uhr 66 <HZRTLR>15151530 ok 56
15077 RTL RADIO 80 15.30 - 15.45 Uhr 67 <HZRTLR>15301545 ok 53
15078 RTL RADIO 80 15.45 - 16.00 Uhr 68 <HZRTLR>15451600 ok 52
15079 RTL RADIO 80 16.00 - 16.15 Uhr 69 <HZRTLR>16001615 ok 61
15080 RTL RADIO 80 16.15 - 16.30 Uhr 70 <HZRTLR>16151630 ok 60
15081 RTL RADIO 80 16.30 - 16.45 Uhr 71 <HZRTLR>16301645 ok 51
15082 RTL RADIO 80 16.45 - 17.00 Uhr 72 <HZRTLR>16451700 ok 59
15083 RTL RADIO 80 17.00 - 17.15 Uhr 73 <HZRTLR>17001715 ok 54
15084 RTL RADIO 80 17.15 - 17.30 Uhr 74 <HZRTLR>17151730 ok 59
15085 RTL RADIO 80 17.30 - 17.45 Uhr 75 <HZRTLR>17301745 ok 59
15086 RTL RADIO 80 17.45 - 18.00 Uhr 76 <HZRTLR>17451800 ok 52
15087 RTL RADIO 80 18.00 - 18.15 Uhr 77 <HZRTLR>18001815 ok 57
15088 RTL RADIO 80 18.15 - 18.30 Uhr 78 <HZRTLR>18151830 ok 58
15089 RTL RADIO 80 18.30 - 18.45 Uhr 79 <HZRTLR>18301845 ok 51
15090 RTL RADIO 80 18.45 - 19.00 Uhr 80 <HZRTLR>18451900 ok 55
15091 RTL RADIO 80 19.00 - 19.15 Uhr 81 <HZRTLR>19001915 ok 42
15092 RTL RADIO 80 19.15 - 19.30 Uhr 82 <HZRTLR>19151930 ok 32
15093 RTL RADIO 80 19.30 - 19.45 Uhr 83 <HZRTLR>19301945 ok 32
15094 RTL RADIO 80 19.45 - 20.00 Uhr 84 <HZRTLR>19452000 ok 29
15095 RTL RADIO 80 20.00 - 20.15 Uhr 85 <HZRTLR>20002015 ok 28
15096 RTL RADIO 80 20.15 - 20.30 Uhr 86 <HZRTLR>20152030 ok 26
15097 RTL RADIO 80 20.30 - 20.45 Uhr 87 <HZRTLR>20302045 ok 21
15098 RTL RADIO 80 20.45 - 21.00 Uhr 88 <HZRTLR>20452100 ok 21
15099 RTL RADIO 80 21.00 - 21.15 Uhr 89 <HZRTLR>21002115 ok 22
15100 RTL RADIO 80 21.15 - 21.30 Uhr 90 <HZRTLR>21152130 ok 23
15101 RTL RADIO 80 21.30 - 21.45 Uhr 91 <HZRTLR>21302145 ok 25
15102 RTL RADIO 80 21.45 - 22.00 Uhr 92 <HZRTLR>21452200 ok 22
15103 RTL RADIO 80 22.00 - 22.15 Uhr 93 <HZRTLR>22002215 ok 21
15104 RTL RADIO 80 22.15 - 22.30 Uhr 94 <HZRTLR>22152230 ok 14
15105 RTL RADIO 80 22.30 - 22.45 Uhr 95 <HZRTLR>22302245 ok 12
15106 RTL RADIO 80 22.45 - 23.00 Uhr 96 <HZRTLR>22452300 ok 13
15107 RTL RADIO 80 23.00 - 23.15 Uhr 97 <HZRTLR>23002315 ok 10
15108 RTL RADIO 80 23.15 - 23.30 Uhr 98 <HZRTLR>23152330 ok 9
15109 RTL RADIO 80 23.30 - 23.45 Uhr 99 <HZRTLR>23302345 ok 9
15110 RTL RADIO 80 23.45 - 24.00 Uhr 100 <HZRTLR>23452400 ok 9

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_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);