media_variant

190 rows where media = 825

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
156561 HIT 104 825 Schon mal gehört 1 <HFHI10>KOJF ok 0
156562 HIT 104 825 Hörer in den letzten 14 Tagen 2 <HFHI10>KOJA ok 0
156563 HIT 104 825 WHK 3 <HFHI10>KOJANEW ok 0
156564 HIT 104 825 Tagesreichweite 4 <HFHI10>05002400 ok 0
156565 HIT 104 825 Durchschnitt 6-18 Uhr 5 <HFHI10>D06001800 ok 0
156566 HIT 104 825 5.00 - 6.00 Uhr 6 <HFHI10>05000600 ok 0
156567 HIT 104 825 6.00 - 7.00 Uhr 7 <HFHI10>06000700 ok 0
156568 HIT 104 825 7.00 - 8.00 Uhr 8 <HFHI10>07000800 ok 0
156569 HIT 104 825 8.00 - 9.00 Uhr 9 <HFHI10>08000900 ok 0
156570 HIT 104 825 9.00 - 10.00 Uhr 10 <HFHI10>09001000 ok 0
156571 HIT 104 825 10.00 - 11.00 Uhr 11 <HFHI10>10001100 ok 0
156572 HIT 104 825 11.00 - 12.00 Uhr 12 <HFHI10>11001200 ok 0
156573 HIT 104 825 12.00 - 13.00 Uhr 13 <HFHI10>12001300 ok 0
156574 HIT 104 825 13.00 - 14.00 Uhr 14 <HFHI10>13001400 ok 0
156575 HIT 104 825 14.00 - 15.00 Uhr 15 <HFHI10>14001500 ok 0
156576 HIT 104 825 15.00 - 16.00 Uhr 16 <HFHI10>15001600 ok 0
156577 HIT 104 825 16.00 - 17.00 Uhr 17 <HFHI10>16001700 ok 0
156578 HIT 104 825 17.00 - 18.00 Uhr 18 <HFHI10>17001800 ok 0
156579 HIT 104 825 18.00 - 19.00 Uhr 19 <HFHI10>18001900 ok 0
156580 HIT 104 825 19.00 - 20.00 Uhr 20 <HFHI10>19002000 ok 0
156581 HIT 104 825 20.00 - 21.00 Uhr 21 <HFHI10>20002100 ok 0
156582 HIT 104 825 21.00 - 22.00 Uhr 22 <HFHI10>21002200 ok 0
156583 HIT 104 825 22.00 - 23.00 Uhr 23 <HFHI10>22002300 ok 0
156584 HIT 104 825 23.00 - 24.00 Uhr 24 <HFHI10>23002400 ok 0
156585 HIT 104 825 5.00 - 5.15 Uhr 25 <HFHI10>05000515 ok 0
156586 HIT 104 825 5.15 - 5.30 Uhr 26 <HFHI10>05150530 ok 0
156587 HIT 104 825 5.30 - 5.45 Uhr 27 <HFHI10>05300545 ok 0
156588 HIT 104 825 5.45 - 6.00 Uhr 28 <HFHI10>05450600 ok 0
156589 HIT 104 825 6.00 - 6.15 Uhr 29 <HFHI10>06000615 ok 0
156590 HIT 104 825 6.15 - 6.30 Uhr 30 <HFHI10>06150630 ok 0
156591 HIT 104 825 6.30 - 6.45 Uhr 31 <HFHI10>06300645 ok 0
156592 HIT 104 825 6.45 - 7.00 Uhr 32 <HFHI10>06450700 ok 0
156593 HIT 104 825 7.00 - 7.15 Uhr 33 <HFHI10>07000715 ok 0
156594 HIT 104 825 7.15 - 7.30 Uhr 34 <HFHI10>07150730 ok 0
156595 HIT 104 825 7.30 - 7.45 Uhr 35 <HFHI10>07300745 ok 0
156596 HIT 104 825 7.45 - 8.00 Uhr 36 <HFHI10>07450800 ok 0
156597 HIT 104 825 8.00 - 8.15 Uhr 37 <HFHI10>08000815 ok 0
156598 HIT 104 825 8.15 - 8.30 Uhr 38 <HFHI10>08150830 ok 0
156599 HIT 104 825 8.30 - 8.45 Uhr 39 <HFHI10>08300845 ok 0
156600 HIT 104 825 8.45 - 9.00 Uhr 40 <HFHI10>08450900 ok 0
156601 HIT 104 825 9.00 - 9.15 Uhr 41 <HFHI10>09000915 ok 0
156602 HIT 104 825 9.15 - 9.30 Uhr 42 <HFHI10>09150930 ok 0
156603 HIT 104 825 9.30 - 9.45 Uhr 43 <HFHI10>09300945 ok 0
156604 HIT 104 825 9.45 - 10.00 Uhr 44 <HFHI10>09451000 ok 0
156605 HIT 104 825 10.00 - 10.15 Uhr 45 <HFHI10>10001015 ok 0
156606 HIT 104 825 10.15 - 10.30 Uhr 46 <HFHI10>10151030 ok 0
156607 HIT 104 825 10.30 - 10.45 Uhr 47 <HFHI10>10301045 ok 0
156608 HIT 104 825 10.45 - 11.00 Uhr 48 <HFHI10>10451100 ok 0
156609 HIT 104 825 11.00 - 11.15 Uhr 49 <HFHI10>11001115 ok 0
156610 HIT 104 825 11.15 - 11.30 Uhr 50 <HFHI10>11151130 ok 0
156611 HIT 104 825 11.30 - 11.45 Uhr 51 <HFHI10>11301145 ok 0
156612 HIT 104 825 11.45 - 12.00 Uhr 52 <HFHI10>11451200 ok 0
156613 HIT 104 825 12.00 - 12.15 Uhr 53 <HFHI10>12001215 ok 0
156614 HIT 104 825 12.15 - 12.30 Uhr 54 <HFHI10>12151230 ok 0
156615 HIT 104 825 12.30 - 12.45 Uhr 55 <HFHI10>12301245 ok 0
156616 HIT 104 825 12.45 - 13.00 Uhr 56 <HFHI10>12451300 ok 0
156617 HIT 104 825 13.00 - 13.15 Uhr 57 <HFHI10>13001315 ok 0
156618 HIT 104 825 13.15 - 13.30 Uhr 58 <HFHI10>13151330 ok 0
156619 HIT 104 825 13.30 - 13.45 Uhr 59 <HFHI10>13301345 ok 0
156620 HIT 104 825 13.45 - 14.00 Uhr 60 <HFHI10>13451400 ok 0
156621 HIT 104 825 14.00 - 14.15 Uhr 61 <HFHI10>14001415 ok 0
156622 HIT 104 825 14.15 - 14.30 Uhr 62 <HFHI10>14151430 ok 0
156623 HIT 104 825 14.30 - 14.45 Uhr 63 <HFHI10>14301445 ok 0
156624 HIT 104 825 14.45 - 15.00 Uhr 64 <HFHI10>14451500 ok 0
156625 HIT 104 825 15.00 - 15.15 Uhr 65 <HFHI10>15001515 ok 0
156626 HIT 104 825 15.15 - 15.30 Uhr 66 <HFHI10>15151530 ok 0
156627 HIT 104 825 15.30 - 15.45 Uhr 67 <HFHI10>15301545 ok 0
156628 HIT 104 825 15.45 - 16.00 Uhr 68 <HFHI10>15451600 ok 0
156629 HIT 104 825 16.00 - 16.15 Uhr 69 <HFHI10>16001615 ok 0
156630 HIT 104 825 16.15 - 16.30 Uhr 70 <HFHI10>16151630 ok 0
156631 HIT 104 825 16.30 - 16.45 Uhr 71 <HFHI10>16301645 ok 0
156632 HIT 104 825 16.45 - 17.00 Uhr 72 <HFHI10>16451700 ok 0
156633 HIT 104 825 17.00 - 17.15 Uhr 73 <HFHI10>17001715 ok 0
156634 HIT 104 825 17.15 - 17.30 Uhr 74 <HFHI10>17151730 ok 0
156635 HIT 104 825 17.30 - 17.45 Uhr 75 <HFHI10>17301745 ok 0
156636 HIT 104 825 17.45 - 18.00 Uhr 76 <HFHI10>17451800 ok 0
156637 HIT 104 825 18.00 - 18.15 Uhr 77 <HFHI10>18001815 ok 0
156638 HIT 104 825 18.15 - 18.30 Uhr 78 <HFHI10>18151830 ok 0
156639 HIT 104 825 18.30 - 18.45 Uhr 79 <HFHI10>18301845 ok 0
156640 HIT 104 825 18.45 - 19.00 Uhr 80 <HFHI10>18451900 ok 0
156641 HIT 104 825 19.00 - 19.15 Uhr 81 <HFHI10>19001915 ok 0
156642 HIT 104 825 19.15 - 19.30 Uhr 82 <HFHI10>19151930 ok 0
156643 HIT 104 825 19.30 - 19.45 Uhr 83 <HFHI10>19301945 ok 0
156644 HIT 104 825 19.45 - 20.00 Uhr 84 <HFHI10>19452000 ok 0
156645 HIT 104 825 20.00 - 20.15 Uhr 85 <HFHI10>20002015 ok 0
156646 HIT 104 825 20.15 - 20.30 Uhr 86 <HFHI10>20152030 ok 0
156647 HIT 104 825 20.30 - 20.45 Uhr 87 <HFHI10>20302045 ok 0
156648 HIT 104 825 20.45 - 21.00 Uhr 88 <HFHI10>20452100 ok 0
156649 HIT 104 825 21.00 - 21.15 Uhr 89 <HFHI10>21002115 ok 0
156650 HIT 104 825 21.15 - 21.30 Uhr 90 <HFHI10>21152130 ok 0
156651 HIT 104 825 21.30 - 21.45 Uhr 91 <HFHI10>21302145 ok 0
156652 HIT 104 825 21.45 - 22.00 Uhr 92 <HFHI10>21452200 ok 0
156653 HIT 104 825 22.00 - 22.15 Uhr 93 <HFHI10>22002215 ok 0
156654 HIT 104 825 22.15 - 22.30 Uhr 94 <HFHI10>22152230 ok 0
156655 HIT 104 825 22.30 - 22.45 Uhr 95 <HFHI10>22302245 ok 0
156656 HIT 104 825 22.45 - 23.00 Uhr 96 <HFHI10>22452300 ok 0
156657 HIT 104 825 23.00 - 23.15 Uhr 97 <HFHI10>23002315 ok 0
156658 HIT 104 825 23.15 - 23.30 Uhr 98 <HFHI10>23152330 ok 0
156659 HIT 104 825 23.30 - 23.45 Uhr 99 <HFHI10>23302345 ok 0
156660 HIT 104 825 23.45 - 24.00 Uhr 100 <HFHI10>23452400 ok 0

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