media_variant

190 rows where media = 331

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
62701 NE-WS 89,4 331 Schon mal gehört 1 <HCNEWS>KOJF ok 311
62702 NE-WS 89,4 331 Hörer in den letzten 14 Tagen 2 <HCNEWS>KOJA ok 128
62703 NE-WS 89,4 331 WHK 3 <HCNEWS>KOJANEW ok 175
62704 NE-WS 89,4 331 Tagesreichweite 4 <HCNEWS>05002400 ok 38
62705 NE-WS 89,4 331 Durchschnitt 6-18 Uhr 5 <HCNEWS>D06001800 ok 10.5
62706 NE-WS 89,4 331 5.00 - 6.00 Uhr 6 <HCNEWS>05000600 ok 4
62707 NE-WS 89,4 331 6.00 - 7.00 Uhr 7 <HCNEWS>06000700 ok 12
62708 NE-WS 89,4 331 7.00 - 8.00 Uhr 8 <HCNEWS>07000800 ok 19
62709 NE-WS 89,4 331 8.00 - 9.00 Uhr 9 <HCNEWS>08000900 ok 15
62710 NE-WS 89,4 331 9.00 - 10.00 Uhr 10 <HCNEWS>09001000 ok 9
62711 NE-WS 89,4 331 10.00 - 11.00 Uhr 11 <HCNEWS>10001100 ok 8
62712 NE-WS 89,4 331 11.00 - 12.00 Uhr 12 <HCNEWS>11001200 ok 10
62713 NE-WS 89,4 331 12.00 - 13.00 Uhr 13 <HCNEWS>12001300 ok 8
62714 NE-WS 89,4 331 13.00 - 14.00 Uhr 14 <HCNEWS>13001400 ok 11
62715 NE-WS 89,4 331 14.00 - 15.00 Uhr 15 <HCNEWS>14001500 ok 8
62716 NE-WS 89,4 331 15.00 - 16.00 Uhr 16 <HCNEWS>15001600 ok 5
62717 NE-WS 89,4 331 16.00 - 17.00 Uhr 17 <HCNEWS>16001700 ok 11
62718 NE-WS 89,4 331 17.00 - 18.00 Uhr 18 <HCNEWS>17001800 ok 10
62719 NE-WS 89,4 331 18.00 - 19.00 Uhr 19 <HCNEWS>18001900 ok 4
62720 NE-WS 89,4 331 19.00 - 20.00 Uhr 20 <HCNEWS>19002000 ok 4
62721 NE-WS 89,4 331 20.00 - 21.00 Uhr 21 <HCNEWS>20002100 ok 1
62722 NE-WS 89,4 331 21.00 - 22.00 Uhr 22 <HCNEWS>21002200 ok 0
62723 NE-WS 89,4 331 22.00 - 23.00 Uhr 23 <HCNEWS>22002300 ok 0
62724 NE-WS 89,4 331 23.00 - 24.00 Uhr 24 <HCNEWS>23002400 ok 0
62725 NE-WS 89,4 331 5.00 - 5.15 Uhr 25 <HCNEWS>05000515 ok 3
62726 NE-WS 89,4 331 5.15 - 5.30 Uhr 26 <HCNEWS>05150530 ok 1
62727 NE-WS 89,4 331 5.30 - 5.45 Uhr 27 <HCNEWS>05300545 ok 0
62728 NE-WS 89,4 331 5.45 - 6.00 Uhr 28 <HCNEWS>05450600 ok 1
62729 NE-WS 89,4 331 6.00 - 6.15 Uhr 29 <HCNEWS>06000615 ok 6
62730 NE-WS 89,4 331 6.15 - 6.30 Uhr 30 <HCNEWS>06150630 ok 5
62731 NE-WS 89,4 331 6.30 - 6.45 Uhr 31 <HCNEWS>06300645 ok 6
62732 NE-WS 89,4 331 6.45 - 7.00 Uhr 32 <HCNEWS>06450700 ok 7
62733 NE-WS 89,4 331 7.00 - 7.15 Uhr 33 <HCNEWS>07000715 ok 10
62734 NE-WS 89,4 331 7.15 - 7.30 Uhr 34 <HCNEWS>07150730 ok 12
62735 NE-WS 89,4 331 7.30 - 7.45 Uhr 35 <HCNEWS>07300745 ok 16
62736 NE-WS 89,4 331 7.45 - 8.00 Uhr 36 <HCNEWS>07450800 ok 13
62737 NE-WS 89,4 331 8.00 - 8.15 Uhr 37 <HCNEWS>08000815 ok 11
62738 NE-WS 89,4 331 8.15 - 8.30 Uhr 38 <HCNEWS>08150830 ok 10
62739 NE-WS 89,4 331 8.30 - 8.45 Uhr 39 <HCNEWS>08300845 ok 8
62740 NE-WS 89,4 331 8.45 - 9.00 Uhr 40 <HCNEWS>08450900 ok 7
62741 NE-WS 89,4 331 9.00 - 9.15 Uhr 41 <HCNEWS>09000915 ok 6
62742 NE-WS 89,4 331 9.15 - 9.30 Uhr 42 <HCNEWS>09150930 ok 7
62743 NE-WS 89,4 331 9.30 - 9.45 Uhr 43 <HCNEWS>09300945 ok 5
62744 NE-WS 89,4 331 9.45 - 10.00 Uhr 44 <HCNEWS>09451000 ok 5
62745 NE-WS 89,4 331 10.00 - 10.15 Uhr 45 <HCNEWS>10001015 ok 7
62746 NE-WS 89,4 331 10.15 - 10.30 Uhr 46 <HCNEWS>10151030 ok 7
62747 NE-WS 89,4 331 10.30 - 10.45 Uhr 47 <HCNEWS>10301045 ok 6
62748 NE-WS 89,4 331 10.45 - 11.00 Uhr 48 <HCNEWS>10451100 ok 6
62749 NE-WS 89,4 331 11.00 - 11.15 Uhr 49 <HCNEWS>11001115 ok 6
62750 NE-WS 89,4 331 11.15 - 11.30 Uhr 50 <HCNEWS>11151130 ok 9
62751 NE-WS 89,4 331 11.30 - 11.45 Uhr 51 <HCNEWS>11301145 ok 8
62752 NE-WS 89,4 331 11.45 - 12.00 Uhr 52 <HCNEWS>11451200 ok 8
62753 NE-WS 89,4 331 12.00 - 12.15 Uhr 53 <HCNEWS>12001215 ok 7
62754 NE-WS 89,4 331 12.15 - 12.30 Uhr 54 <HCNEWS>12151230 ok 5
62755 NE-WS 89,4 331 12.30 - 12.45 Uhr 55 <HCNEWS>12301245 ok 6
62756 NE-WS 89,4 331 12.45 - 13.00 Uhr 56 <HCNEWS>12451300 ok 6
62757 NE-WS 89,4 331 13.00 - 13.15 Uhr 57 <HCNEWS>13001315 ok 8
62758 NE-WS 89,4 331 13.15 - 13.30 Uhr 58 <HCNEWS>13151330 ok 8
62759 NE-WS 89,4 331 13.30 - 13.45 Uhr 59 <HCNEWS>13301345 ok 7
62760 NE-WS 89,4 331 13.45 - 14.00 Uhr 60 <HCNEWS>13451400 ok 5
62761 NE-WS 89,4 331 14.00 - 14.15 Uhr 61 <HCNEWS>14001415 ok 5
62762 NE-WS 89,4 331 14.15 - 14.30 Uhr 62 <HCNEWS>14151430 ok 6
62763 NE-WS 89,4 331 14.30 - 14.45 Uhr 63 <HCNEWS>14301445 ok 6
62764 NE-WS 89,4 331 14.45 - 15.00 Uhr 64 <HCNEWS>14451500 ok 3
62765 NE-WS 89,4 331 15.00 - 15.15 Uhr 65 <HCNEWS>15001515 ok 2
62766 NE-WS 89,4 331 15.15 - 15.30 Uhr 66 <HCNEWS>15151530 ok 3
62767 NE-WS 89,4 331 15.30 - 15.45 Uhr 67 <HCNEWS>15301545 ok 2
62768 NE-WS 89,4 331 15.45 - 16.00 Uhr 68 <HCNEWS>15451600 ok 3
62769 NE-WS 89,4 331 16.00 - 16.15 Uhr 69 <HCNEWS>16001615 ok 5
62770 NE-WS 89,4 331 16.15 - 16.30 Uhr 70 <HCNEWS>16151630 ok 5
62771 NE-WS 89,4 331 16.30 - 16.45 Uhr 71 <HCNEWS>16301645 ok 7
62772 NE-WS 89,4 331 16.45 - 17.00 Uhr 72 <HCNEWS>16451700 ok 7
62773 NE-WS 89,4 331 17.00 - 17.15 Uhr 73 <HCNEWS>17001715 ok 5
62774 NE-WS 89,4 331 17.15 - 17.30 Uhr 74 <HCNEWS>17151730 ok 5
62775 NE-WS 89,4 331 17.30 - 17.45 Uhr 75 <HCNEWS>17301745 ok 6
62776 NE-WS 89,4 331 17.45 - 18.00 Uhr 76 <HCNEWS>17451800 ok 6
62777 NE-WS 89,4 331 18.00 - 18.15 Uhr 77 <HCNEWS>18001815 ok 3
62778 NE-WS 89,4 331 18.15 - 18.30 Uhr 78 <HCNEWS>18151830 ok 2
62779 NE-WS 89,4 331 18.30 - 18.45 Uhr 79 <HCNEWS>18301845 ok 1
62780 NE-WS 89,4 331 18.45 - 19.00 Uhr 80 <HCNEWS>18451900 ok 2
62781 NE-WS 89,4 331 19.00 - 19.15 Uhr 81 <HCNEWS>19001915 ok 3
62782 NE-WS 89,4 331 19.15 - 19.30 Uhr 82 <HCNEWS>19151930 ok 1
62783 NE-WS 89,4 331 19.30 - 19.45 Uhr 83 <HCNEWS>19301945 ok 3
62784 NE-WS 89,4 331 19.45 - 20.00 Uhr 84 <HCNEWS>19452000 ok 1
62785 NE-WS 89,4 331 20.00 - 20.15 Uhr 85 <HCNEWS>20002015 ok 1
62786 NE-WS 89,4 331 20.15 - 20.30 Uhr 86 <HCNEWS>20152030 ok 1
62787 NE-WS 89,4 331 20.30 - 20.45 Uhr 87 <HCNEWS>20302045 ok 1
62788 NE-WS 89,4 331 20.45 - 21.00 Uhr 88 <HCNEWS>20452100 ok 1
62789 NE-WS 89,4 331 21.00 - 21.15 Uhr 89 <HCNEWS>21002115 ok 0
62790 NE-WS 89,4 331 21.15 - 21.30 Uhr 90 <HCNEWS>21152130 ok 0
62791 NE-WS 89,4 331 21.30 - 21.45 Uhr 91 <HCNEWS>21302145 ok 0
62792 NE-WS 89,4 331 21.45 - 22.00 Uhr 92 <HCNEWS>21452200 ok 0
62793 NE-WS 89,4 331 22.00 - 22.15 Uhr 93 <HCNEWS>22002215 ok 0
62794 NE-WS 89,4 331 22.15 - 22.30 Uhr 94 <HCNEWS>22152230 ok 0
62795 NE-WS 89,4 331 22.30 - 22.45 Uhr 95 <HCNEWS>22302245 ok 0
62796 NE-WS 89,4 331 22.45 - 23.00 Uhr 96 <HCNEWS>22452300 ok 0
62797 NE-WS 89,4 331 23.00 - 23.15 Uhr 97 <HCNEWS>23002315 ok 0
62798 NE-WS 89,4 331 23.15 - 23.30 Uhr 98 <HCNEWS>23152330 ok 0
62799 NE-WS 89,4 331 23.30 - 23.45 Uhr 99 <HCNEWS>23302345 ok 0
62800 NE-WS 89,4 331 23.45 - 24.00 Uhr 100 <HCNEWS>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 UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);