media_variant

190 rows where media = 871

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
165301 89.0 RTL 871 Schon mal gehört 1 <HGP890>KOJF ok 3062
165302 89.0 RTL 871 Hörer in den letzten 14 Tagen 2 <HGP890>KOJA ok 1315
165303 89.0 RTL 871 WHK 3 <HGP890>KOJANEW ok 1758
165304 89.0 RTL 871 Tagesreichweite 4 <HGP890>05002400 ok 301
165305 89.0 RTL 871 Durchschnitt 6-18 Uhr 5 <HGP890>D06001800 ok 78.833333
165306 89.0 RTL 871 5.00 - 6.00 Uhr 6 <HGP890>05000600 ok 36
165307 89.0 RTL 871 6.00 - 7.00 Uhr 7 <HGP890>06000700 ok 68
165308 89.0 RTL 871 7.00 - 8.00 Uhr 8 <HGP890>07000800 ok 92
165309 89.0 RTL 871 8.00 - 9.00 Uhr 9 <HGP890>08000900 ok 88
165310 89.0 RTL 871 9.00 - 10.00 Uhr 10 <HGP890>09001000 ok 84
165311 89.0 RTL 871 10.00 - 11.00 Uhr 11 <HGP890>10001100 ok 78
165312 89.0 RTL 871 11.00 - 12.00 Uhr 12 <HGP890>11001200 ok 75
165313 89.0 RTL 871 12.00 - 13.00 Uhr 13 <HGP890>12001300 ok 74
165314 89.0 RTL 871 13.00 - 14.00 Uhr 14 <HGP890>13001400 ok 77
165315 89.0 RTL 871 14.00 - 15.00 Uhr 15 <HGP890>14001500 ok 66
165316 89.0 RTL 871 15.00 - 16.00 Uhr 16 <HGP890>15001600 ok 93
165317 89.0 RTL 871 16.00 - 17.00 Uhr 17 <HGP890>16001700 ok 84
165318 89.0 RTL 871 17.00 - 18.00 Uhr 18 <HGP890>17001800 ok 67
165319 89.0 RTL 871 18.00 - 19.00 Uhr 19 <HGP890>18001900 ok 59
165320 89.0 RTL 871 19.00 - 20.00 Uhr 20 <HGP890>19002000 ok 39
165321 89.0 RTL 871 20.00 - 21.00 Uhr 21 <HGP890>20002100 ok 29
165322 89.0 RTL 871 21.00 - 22.00 Uhr 22 <HGP890>21002200 ok 18
165323 89.0 RTL 871 22.00 - 23.00 Uhr 23 <HGP890>22002300 ok 16
165324 89.0 RTL 871 23.00 - 24.00 Uhr 24 <HGP890>23002400 ok 13
165325 89.0 RTL 871 5.00 - 5.15 Uhr 25 <HGP890>05000515 ok 14
165326 89.0 RTL 871 5.15 - 5.30 Uhr 26 <HGP890>05150530 ok 12
165327 89.0 RTL 871 5.30 - 5.45 Uhr 27 <HGP890>05300545 ok 20
165328 89.0 RTL 871 5.45 - 6.00 Uhr 28 <HGP890>05450600 ok 28
165329 89.0 RTL 871 6.00 - 6.15 Uhr 29 <HGP890>06000615 ok 38
165330 89.0 RTL 871 6.15 - 6.30 Uhr 30 <HGP890>06150630 ok 29
165331 89.0 RTL 871 6.30 - 6.45 Uhr 31 <HGP890>06300645 ok 39
165332 89.0 RTL 871 6.45 - 7.00 Uhr 32 <HGP890>06450700 ok 43
165333 89.0 RTL 871 7.00 - 7.15 Uhr 33 <HGP890>07000715 ok 57
165334 89.0 RTL 871 7.15 - 7.30 Uhr 34 <HGP890>07150730 ok 52
165335 89.0 RTL 871 7.30 - 7.45 Uhr 35 <HGP890>07300745 ok 51
165336 89.0 RTL 871 7.45 - 8.00 Uhr 36 <HGP890>07450800 ok 52
165337 89.0 RTL 871 8.00 - 8.15 Uhr 37 <HGP890>08000815 ok 55
165338 89.0 RTL 871 8.15 - 8.30 Uhr 38 <HGP890>08150830 ok 53
165339 89.0 RTL 871 8.30 - 8.45 Uhr 39 <HGP890>08300845 ok 53
165340 89.0 RTL 871 8.45 - 9.00 Uhr 40 <HGP890>08450900 ok 57
165341 89.0 RTL 871 9.00 - 9.15 Uhr 41 <HGP890>09000915 ok 65
165342 89.0 RTL 871 9.15 - 9.30 Uhr 42 <HGP890>09150930 ok 65
165343 89.0 RTL 871 9.30 - 9.45 Uhr 43 <HGP890>09300945 ok 57
165344 89.0 RTL 871 9.45 - 10.00 Uhr 44 <HGP890>09451000 ok 61
165345 89.0 RTL 871 10.00 - 10.15 Uhr 45 <HGP890>10001015 ok 61
165346 89.0 RTL 871 10.15 - 10.30 Uhr 46 <HGP890>10151030 ok 60
165347 89.0 RTL 871 10.30 - 10.45 Uhr 47 <HGP890>10301045 ok 55
165348 89.0 RTL 871 10.45 - 11.00 Uhr 48 <HGP890>10451100 ok 53
165349 89.0 RTL 871 11.00 - 11.15 Uhr 49 <HGP890>11001115 ok 51
165350 89.0 RTL 871 11.15 - 11.30 Uhr 50 <HGP890>11151130 ok 58
165351 89.0 RTL 871 11.30 - 11.45 Uhr 51 <HGP890>11301145 ok 54
165352 89.0 RTL 871 11.45 - 12.00 Uhr 52 <HGP890>11451200 ok 57
165353 89.0 RTL 871 12.00 - 12.15 Uhr 53 <HGP890>12001215 ok 58
165354 89.0 RTL 871 12.15 - 12.30 Uhr 54 <HGP890>12151230 ok 49
165355 89.0 RTL 871 12.30 - 12.45 Uhr 55 <HGP890>12301245 ok 52
165356 89.0 RTL 871 12.45 - 13.00 Uhr 56 <HGP890>12451300 ok 49
165357 89.0 RTL 871 13.00 - 13.15 Uhr 57 <HGP890>13001315 ok 51
165358 89.0 RTL 871 13.15 - 13.30 Uhr 58 <HGP890>13151330 ok 52
165359 89.0 RTL 871 13.30 - 13.45 Uhr 59 <HGP890>13301345 ok 50
165360 89.0 RTL 871 13.45 - 14.00 Uhr 60 <HGP890>13451400 ok 50
165361 89.0 RTL 871 14.00 - 14.15 Uhr 61 <HGP890>14001415 ok 48
165362 89.0 RTL 871 14.15 - 14.30 Uhr 62 <HGP890>14151430 ok 51
165363 89.0 RTL 871 14.30 - 14.45 Uhr 63 <HGP890>14301445 ok 47
165364 89.0 RTL 871 14.45 - 15.00 Uhr 64 <HGP890>14451500 ok 45
165365 89.0 RTL 871 15.00 - 15.15 Uhr 65 <HGP890>15001515 ok 60
165366 89.0 RTL 871 15.15 - 15.30 Uhr 66 <HGP890>15151530 ok 67
165367 89.0 RTL 871 15.30 - 15.45 Uhr 67 <HGP890>15301545 ok 64
165368 89.0 RTL 871 15.45 - 16.00 Uhr 68 <HGP890>15451600 ok 58
165369 89.0 RTL 871 16.00 - 16.15 Uhr 69 <HGP890>16001615 ok 51
165370 89.0 RTL 871 16.15 - 16.30 Uhr 70 <HGP890>16151630 ok 49
165371 89.0 RTL 871 16.30 - 16.45 Uhr 71 <HGP890>16301645 ok 52
165372 89.0 RTL 871 16.45 - 17.00 Uhr 72 <HGP890>16451700 ok 50
165373 89.0 RTL 871 17.00 - 17.15 Uhr 73 <HGP890>17001715 ok 44
165374 89.0 RTL 871 17.15 - 17.30 Uhr 74 <HGP890>17151730 ok 46
165375 89.0 RTL 871 17.30 - 17.45 Uhr 75 <HGP890>17301745 ok 40
165376 89.0 RTL 871 17.45 - 18.00 Uhr 76 <HGP890>17451800 ok 42
165377 89.0 RTL 871 18.00 - 18.15 Uhr 77 <HGP890>18001815 ok 35
165378 89.0 RTL 871 18.15 - 18.30 Uhr 78 <HGP890>18151830 ok 32
165379 89.0 RTL 871 18.30 - 18.45 Uhr 79 <HGP890>18301845 ok 33
165380 89.0 RTL 871 18.45 - 19.00 Uhr 80 <HGP890>18451900 ok 28
165381 89.0 RTL 871 19.00 - 19.15 Uhr 81 <HGP890>19001915 ok 29
165382 89.0 RTL 871 19.15 - 19.30 Uhr 82 <HGP890>19151930 ok 25
165383 89.0 RTL 871 19.30 - 19.45 Uhr 83 <HGP890>19301945 ok 22
165384 89.0 RTL 871 19.45 - 20.00 Uhr 84 <HGP890>19452000 ok 21
165385 89.0 RTL 871 20.00 - 20.15 Uhr 85 <HGP890>20002015 ok 24
165386 89.0 RTL 871 20.15 - 20.30 Uhr 86 <HGP890>20152030 ok 19
165387 89.0 RTL 871 20.30 - 20.45 Uhr 87 <HGP890>20302045 ok 17
165388 89.0 RTL 871 20.45 - 21.00 Uhr 88 <HGP890>20452100 ok 12
165389 89.0 RTL 871 21.00 - 21.15 Uhr 89 <HGP890>21002115 ok 13
165390 89.0 RTL 871 21.15 - 21.30 Uhr 90 <HGP890>21152130 ok 12
165391 89.0 RTL 871 21.30 - 21.45 Uhr 91 <HGP890>21302145 ok 15
165392 89.0 RTL 871 21.45 - 22.00 Uhr 92 <HGP890>21452200 ok 13
165393 89.0 RTL 871 22.00 - 22.15 Uhr 93 <HGP890>22002215 ok 13
165394 89.0 RTL 871 22.15 - 22.30 Uhr 94 <HGP890>22152230 ok 8
165395 89.0 RTL 871 22.30 - 22.45 Uhr 95 <HGP890>22302245 ok 9
165396 89.0 RTL 871 22.45 - 23.00 Uhr 96 <HGP890>22452300 ok 8
165397 89.0 RTL 871 23.00 - 23.15 Uhr 97 <HGP890>23002315 ok 8
165398 89.0 RTL 871 23.15 - 23.30 Uhr 98 <HGP890>23152330 ok 9
165399 89.0 RTL 871 23.30 - 23.45 Uhr 99 <HGP890>23302345 ok 12
165400 89.0 RTL 871 23.45 - 24.00 Uhr 100 <HGP890>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);