media_variant

190 rows where media = 45

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
8361 Beats Radio 45 Schon mal gehört 1 <HZBEAT>KOJF unknown  
8362 Beats Radio 45 Hörer in den letzten 14 Tagen 2 <HZBEAT>KOJA unknown  
8363 Beats Radio 45 WHK 3 <HZBEAT>KOJANEW unknown  
8364 Beats Radio 45 Tagesreichweite 4 <HZBEAT>05002400 unknown  
8365 Beats Radio 45 Durchschnitt 6-18 Uhr 5 <HZBEAT>D06001800 unknown  
8366 Beats Radio 45 5.00 - 6.00 Uhr 6 <HZBEAT>05000600 unknown  
8367 Beats Radio 45 6.00 - 7.00 Uhr 7 <HZBEAT>06000700 unknown  
8368 Beats Radio 45 7.00 - 8.00 Uhr 8 <HZBEAT>07000800 unknown  
8369 Beats Radio 45 8.00 - 9.00 Uhr 9 <HZBEAT>08000900 unknown  
8370 Beats Radio 45 9.00 - 10.00 Uhr 10 <HZBEAT>09001000 unknown  
8371 Beats Radio 45 10.00 - 11.00 Uhr 11 <HZBEAT>10001100 unknown  
8372 Beats Radio 45 11.00 - 12.00 Uhr 12 <HZBEAT>11001200 unknown  
8373 Beats Radio 45 12.00 - 13.00 Uhr 13 <HZBEAT>12001300 unknown  
8374 Beats Radio 45 13.00 - 14.00 Uhr 14 <HZBEAT>13001400 unknown  
8375 Beats Radio 45 14.00 - 15.00 Uhr 15 <HZBEAT>14001500 unknown  
8376 Beats Radio 45 15.00 - 16.00 Uhr 16 <HZBEAT>15001600 unknown  
8377 Beats Radio 45 16.00 - 17.00 Uhr 17 <HZBEAT>16001700 unknown  
8378 Beats Radio 45 17.00 - 18.00 Uhr 18 <HZBEAT>17001800 unknown  
8379 Beats Radio 45 18.00 - 19.00 Uhr 19 <HZBEAT>18001900 unknown  
8380 Beats Radio 45 19.00 - 20.00 Uhr 20 <HZBEAT>19002000 unknown  
8381 Beats Radio 45 20.00 - 21.00 Uhr 21 <HZBEAT>20002100 unknown  
8382 Beats Radio 45 21.00 - 22.00 Uhr 22 <HZBEAT>21002200 unknown  
8383 Beats Radio 45 22.00 - 23.00 Uhr 23 <HZBEAT>22002300 unknown  
8384 Beats Radio 45 23.00 - 24.00 Uhr 24 <HZBEAT>23002400 unknown  
8385 Beats Radio 45 5.00 - 5.15 Uhr 25 <HZBEAT>05000515 unknown  
8386 Beats Radio 45 5.15 - 5.30 Uhr 26 <HZBEAT>05150530 unknown  
8387 Beats Radio 45 5.30 - 5.45 Uhr 27 <HZBEAT>05300545 unknown  
8388 Beats Radio 45 5.45 - 6.00 Uhr 28 <HZBEAT>05450600 unknown  
8389 Beats Radio 45 6.00 - 6.15 Uhr 29 <HZBEAT>06000615 unknown  
8390 Beats Radio 45 6.15 - 6.30 Uhr 30 <HZBEAT>06150630 unknown  
8391 Beats Radio 45 6.30 - 6.45 Uhr 31 <HZBEAT>06300645 unknown  
8392 Beats Radio 45 6.45 - 7.00 Uhr 32 <HZBEAT>06450700 unknown  
8393 Beats Radio 45 7.00 - 7.15 Uhr 33 <HZBEAT>07000715 unknown  
8394 Beats Radio 45 7.15 - 7.30 Uhr 34 <HZBEAT>07150730 unknown  
8395 Beats Radio 45 7.30 - 7.45 Uhr 35 <HZBEAT>07300745 unknown  
8396 Beats Radio 45 7.45 - 8.00 Uhr 36 <HZBEAT>07450800 unknown  
8397 Beats Radio 45 8.00 - 8.15 Uhr 37 <HZBEAT>08000815 unknown  
8398 Beats Radio 45 8.15 - 8.30 Uhr 38 <HZBEAT>08150830 unknown  
8399 Beats Radio 45 8.30 - 8.45 Uhr 39 <HZBEAT>08300845 unknown  
8400 Beats Radio 45 8.45 - 9.00 Uhr 40 <HZBEAT>08450900 unknown  
8401 Beats Radio 45 9.00 - 9.15 Uhr 41 <HZBEAT>09000915 unknown  
8402 Beats Radio 45 9.15 - 9.30 Uhr 42 <HZBEAT>09150930 unknown  
8403 Beats Radio 45 9.30 - 9.45 Uhr 43 <HZBEAT>09300945 unknown  
8404 Beats Radio 45 9.45 - 10.00 Uhr 44 <HZBEAT>09451000 unknown  
8405 Beats Radio 45 10.00 - 10.15 Uhr 45 <HZBEAT>10001015 unknown  
8406 Beats Radio 45 10.15 - 10.30 Uhr 46 <HZBEAT>10151030 unknown  
8407 Beats Radio 45 10.30 - 10.45 Uhr 47 <HZBEAT>10301045 unknown  
8408 Beats Radio 45 10.45 - 11.00 Uhr 48 <HZBEAT>10451100 unknown  
8409 Beats Radio 45 11.00 - 11.15 Uhr 49 <HZBEAT>11001115 unknown  
8410 Beats Radio 45 11.15 - 11.30 Uhr 50 <HZBEAT>11151130 unknown  
8411 Beats Radio 45 11.30 - 11.45 Uhr 51 <HZBEAT>11301145 unknown  
8412 Beats Radio 45 11.45 - 12.00 Uhr 52 <HZBEAT>11451200 unknown  
8413 Beats Radio 45 12.00 - 12.15 Uhr 53 <HZBEAT>12001215 unknown  
8414 Beats Radio 45 12.15 - 12.30 Uhr 54 <HZBEAT>12151230 unknown  
8415 Beats Radio 45 12.30 - 12.45 Uhr 55 <HZBEAT>12301245 unknown  
8416 Beats Radio 45 12.45 - 13.00 Uhr 56 <HZBEAT>12451300 unknown  
8417 Beats Radio 45 13.00 - 13.15 Uhr 57 <HZBEAT>13001315 unknown  
8418 Beats Radio 45 13.15 - 13.30 Uhr 58 <HZBEAT>13151330 unknown  
8419 Beats Radio 45 13.30 - 13.45 Uhr 59 <HZBEAT>13301345 unknown  
8420 Beats Radio 45 13.45 - 14.00 Uhr 60 <HZBEAT>13451400 unknown  
8421 Beats Radio 45 14.00 - 14.15 Uhr 61 <HZBEAT>14001415 unknown  
8422 Beats Radio 45 14.15 - 14.30 Uhr 62 <HZBEAT>14151430 unknown  
8423 Beats Radio 45 14.30 - 14.45 Uhr 63 <HZBEAT>14301445 unknown  
8424 Beats Radio 45 14.45 - 15.00 Uhr 64 <HZBEAT>14451500 unknown  
8425 Beats Radio 45 15.00 - 15.15 Uhr 65 <HZBEAT>15001515 unknown  
8426 Beats Radio 45 15.15 - 15.30 Uhr 66 <HZBEAT>15151530 unknown  
8427 Beats Radio 45 15.30 - 15.45 Uhr 67 <HZBEAT>15301545 unknown  
8428 Beats Radio 45 15.45 - 16.00 Uhr 68 <HZBEAT>15451600 unknown  
8429 Beats Radio 45 16.00 - 16.15 Uhr 69 <HZBEAT>16001615 unknown  
8430 Beats Radio 45 16.15 - 16.30 Uhr 70 <HZBEAT>16151630 unknown  
8431 Beats Radio 45 16.30 - 16.45 Uhr 71 <HZBEAT>16301645 unknown  
8432 Beats Radio 45 16.45 - 17.00 Uhr 72 <HZBEAT>16451700 unknown  
8433 Beats Radio 45 17.00 - 17.15 Uhr 73 <HZBEAT>17001715 unknown  
8434 Beats Radio 45 17.15 - 17.30 Uhr 74 <HZBEAT>17151730 unknown  
8435 Beats Radio 45 17.30 - 17.45 Uhr 75 <HZBEAT>17301745 unknown  
8436 Beats Radio 45 17.45 - 18.00 Uhr 76 <HZBEAT>17451800 unknown  
8437 Beats Radio 45 18.00 - 18.15 Uhr 77 <HZBEAT>18001815 unknown  
8438 Beats Radio 45 18.15 - 18.30 Uhr 78 <HZBEAT>18151830 unknown  
8439 Beats Radio 45 18.30 - 18.45 Uhr 79 <HZBEAT>18301845 unknown  
8440 Beats Radio 45 18.45 - 19.00 Uhr 80 <HZBEAT>18451900 unknown  
8441 Beats Radio 45 19.00 - 19.15 Uhr 81 <HZBEAT>19001915 unknown  
8442 Beats Radio 45 19.15 - 19.30 Uhr 82 <HZBEAT>19151930 unknown  
8443 Beats Radio 45 19.30 - 19.45 Uhr 83 <HZBEAT>19301945 unknown  
8444 Beats Radio 45 19.45 - 20.00 Uhr 84 <HZBEAT>19452000 unknown  
8445 Beats Radio 45 20.00 - 20.15 Uhr 85 <HZBEAT>20002015 unknown  
8446 Beats Radio 45 20.15 - 20.30 Uhr 86 <HZBEAT>20152030 unknown  
8447 Beats Radio 45 20.30 - 20.45 Uhr 87 <HZBEAT>20302045 unknown  
8448 Beats Radio 45 20.45 - 21.00 Uhr 88 <HZBEAT>20452100 unknown  
8449 Beats Radio 45 21.00 - 21.15 Uhr 89 <HZBEAT>21002115 unknown  
8450 Beats Radio 45 21.15 - 21.30 Uhr 90 <HZBEAT>21152130 unknown  
8451 Beats Radio 45 21.30 - 21.45 Uhr 91 <HZBEAT>21302145 unknown  
8452 Beats Radio 45 21.45 - 22.00 Uhr 92 <HZBEAT>21452200 unknown  
8453 Beats Radio 45 22.00 - 22.15 Uhr 93 <HZBEAT>22002215 unknown  
8454 Beats Radio 45 22.15 - 22.30 Uhr 94 <HZBEAT>22152230 unknown  
8455 Beats Radio 45 22.30 - 22.45 Uhr 95 <HZBEAT>22302245 unknown  
8456 Beats Radio 45 22.45 - 23.00 Uhr 96 <HZBEAT>22452300 unknown  
8457 Beats Radio 45 23.00 - 23.15 Uhr 97 <HZBEAT>23002315 unknown  
8458 Beats Radio 45 23.15 - 23.30 Uhr 98 <HZBEAT>23152330 unknown  
8459 Beats Radio 45 23.30 - 23.45 Uhr 99 <HZBEAT>23302345 unknown  
8460 Beats Radio 45 23.45 - 24.00 Uhr 100 <HZBEAT>23452400 unknown  

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