media_variant

190 rows where media = 256

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
48451 Radio WSM 256 Schon mal gehört 1 <HARAWS>KOJF unknown  
48452 Radio WSM 256 Hörer in den letzten 14 Tagen 2 <HARAWS>KOJA unknown  
48453 Radio WSM 256 WHK 3 <HARAWS>KOJANEW unknown  
48454 Radio WSM 256 Tagesreichweite 4 <HARAWS>05002400 unknown  
48455 Radio WSM 256 Durchschnitt 6-18 Uhr 5 <HARAWS>D06001800 unknown  
48456 Radio WSM 256 5.00 - 6.00 Uhr 6 <HARAWS>05000600 unknown  
48457 Radio WSM 256 6.00 - 7.00 Uhr 7 <HARAWS>06000700 unknown  
48458 Radio WSM 256 7.00 - 8.00 Uhr 8 <HARAWS>07000800 unknown  
48459 Radio WSM 256 8.00 - 9.00 Uhr 9 <HARAWS>08000900 unknown  
48460 Radio WSM 256 9.00 - 10.00 Uhr 10 <HARAWS>09001000 unknown  
48461 Radio WSM 256 10.00 - 11.00 Uhr 11 <HARAWS>10001100 unknown  
48462 Radio WSM 256 11.00 - 12.00 Uhr 12 <HARAWS>11001200 unknown  
48463 Radio WSM 256 12.00 - 13.00 Uhr 13 <HARAWS>12001300 unknown  
48464 Radio WSM 256 13.00 - 14.00 Uhr 14 <HARAWS>13001400 unknown  
48465 Radio WSM 256 14.00 - 15.00 Uhr 15 <HARAWS>14001500 unknown  
48466 Radio WSM 256 15.00 - 16.00 Uhr 16 <HARAWS>15001600 unknown  
48467 Radio WSM 256 16.00 - 17.00 Uhr 17 <HARAWS>16001700 unknown  
48468 Radio WSM 256 17.00 - 18.00 Uhr 18 <HARAWS>17001800 unknown  
48469 Radio WSM 256 18.00 - 19.00 Uhr 19 <HARAWS>18001900 unknown  
48470 Radio WSM 256 19.00 - 20.00 Uhr 20 <HARAWS>19002000 unknown  
48471 Radio WSM 256 20.00 - 21.00 Uhr 21 <HARAWS>20002100 unknown  
48472 Radio WSM 256 21.00 - 22.00 Uhr 22 <HARAWS>21002200 unknown  
48473 Radio WSM 256 22.00 - 23.00 Uhr 23 <HARAWS>22002300 unknown  
48474 Radio WSM 256 23.00 - 24.00 Uhr 24 <HARAWS>23002400 unknown  
48475 Radio WSM 256 5.00 - 5.15 Uhr 25 <HARAWS>05000515 unknown  
48476 Radio WSM 256 5.15 - 5.30 Uhr 26 <HARAWS>05150530 unknown  
48477 Radio WSM 256 5.30 - 5.45 Uhr 27 <HARAWS>05300545 unknown  
48478 Radio WSM 256 5.45 - 6.00 Uhr 28 <HARAWS>05450600 unknown  
48479 Radio WSM 256 6.00 - 6.15 Uhr 29 <HARAWS>06000615 unknown  
48480 Radio WSM 256 6.15 - 6.30 Uhr 30 <HARAWS>06150630 unknown  
48481 Radio WSM 256 6.30 - 6.45 Uhr 31 <HARAWS>06300645 unknown  
48482 Radio WSM 256 6.45 - 7.00 Uhr 32 <HARAWS>06450700 unknown  
48483 Radio WSM 256 7.00 - 7.15 Uhr 33 <HARAWS>07000715 unknown  
48484 Radio WSM 256 7.15 - 7.30 Uhr 34 <HARAWS>07150730 unknown  
48485 Radio WSM 256 7.30 - 7.45 Uhr 35 <HARAWS>07300745 unknown  
48486 Radio WSM 256 7.45 - 8.00 Uhr 36 <HARAWS>07450800 unknown  
48487 Radio WSM 256 8.00 - 8.15 Uhr 37 <HARAWS>08000815 unknown  
48488 Radio WSM 256 8.15 - 8.30 Uhr 38 <HARAWS>08150830 unknown  
48489 Radio WSM 256 8.30 - 8.45 Uhr 39 <HARAWS>08300845 unknown  
48490 Radio WSM 256 8.45 - 9.00 Uhr 40 <HARAWS>08450900 unknown  
48491 Radio WSM 256 9.00 - 9.15 Uhr 41 <HARAWS>09000915 unknown  
48492 Radio WSM 256 9.15 - 9.30 Uhr 42 <HARAWS>09150930 unknown  
48493 Radio WSM 256 9.30 - 9.45 Uhr 43 <HARAWS>09300945 unknown  
48494 Radio WSM 256 9.45 - 10.00 Uhr 44 <HARAWS>09451000 unknown  
48495 Radio WSM 256 10.00 - 10.15 Uhr 45 <HARAWS>10001015 unknown  
48496 Radio WSM 256 10.15 - 10.30 Uhr 46 <HARAWS>10151030 unknown  
48497 Radio WSM 256 10.30 - 10.45 Uhr 47 <HARAWS>10301045 unknown  
48498 Radio WSM 256 10.45 - 11.00 Uhr 48 <HARAWS>10451100 unknown  
48499 Radio WSM 256 11.00 - 11.15 Uhr 49 <HARAWS>11001115 unknown  
48500 Radio WSM 256 11.15 - 11.30 Uhr 50 <HARAWS>11151130 unknown  
48501 Radio WSM 256 11.30 - 11.45 Uhr 51 <HARAWS>11301145 unknown  
48502 Radio WSM 256 11.45 - 12.00 Uhr 52 <HARAWS>11451200 unknown  
48503 Radio WSM 256 12.00 - 12.15 Uhr 53 <HARAWS>12001215 unknown  
48504 Radio WSM 256 12.15 - 12.30 Uhr 54 <HARAWS>12151230 unknown  
48505 Radio WSM 256 12.30 - 12.45 Uhr 55 <HARAWS>12301245 unknown  
48506 Radio WSM 256 12.45 - 13.00 Uhr 56 <HARAWS>12451300 unknown  
48507 Radio WSM 256 13.00 - 13.15 Uhr 57 <HARAWS>13001315 unknown  
48508 Radio WSM 256 13.15 - 13.30 Uhr 58 <HARAWS>13151330 unknown  
48509 Radio WSM 256 13.30 - 13.45 Uhr 59 <HARAWS>13301345 unknown  
48510 Radio WSM 256 13.45 - 14.00 Uhr 60 <HARAWS>13451400 unknown  
48511 Radio WSM 256 14.00 - 14.15 Uhr 61 <HARAWS>14001415 unknown  
48512 Radio WSM 256 14.15 - 14.30 Uhr 62 <HARAWS>14151430 unknown  
48513 Radio WSM 256 14.30 - 14.45 Uhr 63 <HARAWS>14301445 unknown  
48514 Radio WSM 256 14.45 - 15.00 Uhr 64 <HARAWS>14451500 unknown  
48515 Radio WSM 256 15.00 - 15.15 Uhr 65 <HARAWS>15001515 unknown  
48516 Radio WSM 256 15.15 - 15.30 Uhr 66 <HARAWS>15151530 unknown  
48517 Radio WSM 256 15.30 - 15.45 Uhr 67 <HARAWS>15301545 unknown  
48518 Radio WSM 256 15.45 - 16.00 Uhr 68 <HARAWS>15451600 unknown  
48519 Radio WSM 256 16.00 - 16.15 Uhr 69 <HARAWS>16001615 unknown  
48520 Radio WSM 256 16.15 - 16.30 Uhr 70 <HARAWS>16151630 unknown  
48521 Radio WSM 256 16.30 - 16.45 Uhr 71 <HARAWS>16301645 unknown  
48522 Radio WSM 256 16.45 - 17.00 Uhr 72 <HARAWS>16451700 unknown  
48523 Radio WSM 256 17.00 - 17.15 Uhr 73 <HARAWS>17001715 unknown  
48524 Radio WSM 256 17.15 - 17.30 Uhr 74 <HARAWS>17151730 unknown  
48525 Radio WSM 256 17.30 - 17.45 Uhr 75 <HARAWS>17301745 unknown  
48526 Radio WSM 256 17.45 - 18.00 Uhr 76 <HARAWS>17451800 unknown  
48527 Radio WSM 256 18.00 - 18.15 Uhr 77 <HARAWS>18001815 unknown  
48528 Radio WSM 256 18.15 - 18.30 Uhr 78 <HARAWS>18151830 unknown  
48529 Radio WSM 256 18.30 - 18.45 Uhr 79 <HARAWS>18301845 unknown  
48530 Radio WSM 256 18.45 - 19.00 Uhr 80 <HARAWS>18451900 unknown  
48531 Radio WSM 256 19.00 - 19.15 Uhr 81 <HARAWS>19001915 unknown  
48532 Radio WSM 256 19.15 - 19.30 Uhr 82 <HARAWS>19151930 unknown  
48533 Radio WSM 256 19.30 - 19.45 Uhr 83 <HARAWS>19301945 unknown  
48534 Radio WSM 256 19.45 - 20.00 Uhr 84 <HARAWS>19452000 unknown  
48535 Radio WSM 256 20.00 - 20.15 Uhr 85 <HARAWS>20002015 unknown  
48536 Radio WSM 256 20.15 - 20.30 Uhr 86 <HARAWS>20152030 unknown  
48537 Radio WSM 256 20.30 - 20.45 Uhr 87 <HARAWS>20302045 unknown  
48538 Radio WSM 256 20.45 - 21.00 Uhr 88 <HARAWS>20452100 unknown  
48539 Radio WSM 256 21.00 - 21.15 Uhr 89 <HARAWS>21002115 unknown  
48540 Radio WSM 256 21.15 - 21.30 Uhr 90 <HARAWS>21152130 unknown  
48541 Radio WSM 256 21.30 - 21.45 Uhr 91 <HARAWS>21302145 unknown  
48542 Radio WSM 256 21.45 - 22.00 Uhr 92 <HARAWS>21452200 unknown  
48543 Radio WSM 256 22.00 - 22.15 Uhr 93 <HARAWS>22002215 unknown  
48544 Radio WSM 256 22.15 - 22.30 Uhr 94 <HARAWS>22152230 unknown  
48545 Radio WSM 256 22.30 - 22.45 Uhr 95 <HARAWS>22302245 unknown  
48546 Radio WSM 256 22.45 - 23.00 Uhr 96 <HARAWS>22452300 unknown  
48547 Radio WSM 256 23.00 - 23.15 Uhr 97 <HARAWS>23002315 unknown  
48548 Radio WSM 256 23.15 - 23.30 Uhr 98 <HARAWS>23152330 unknown  
48549 Radio WSM 256 23.30 - 23.45 Uhr 99 <HARAWS>23302345 unknown  
48550 Radio WSM 256 23.45 - 24.00 Uhr 100 <HARAWS>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);