media_variant

219 rows where variant = 4

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
4 Werbefunk 1 HpT 4 RHZAL21_ZH ok 49160.42
28 ARD Sender 2 HpT 4 RHZA214_ZH ok 32709.89
52 Private Sender 3 HpT 4 RHZPR15_ZH ok 36326.5
172 Vermarkter ARD MEDIA Gesamt 8 HpT 4 RHZVA10_ZH ok 38688.88
196 Vermarkter RMS Gesamt 9 HpT 4 RHZVR07_ZH ok 29521.78
220 Vermarkter ENERGY Gesamt 10 HpT 4 RHZVE10_ZH ok 2968.09
244 Vermarkter STUDIO GONG Gesamt 11 HpT 4 RHZVG06_ZH ok 10754.76
268 Vermarkter ad.audio Gesamt 12 HpT 4 RHZVAA2_ZH ok 3831.29
316 Absolut Radio 14 HpT 4 RHZABSS_ZH ok 1695.12
388 ad.audio DAB+ Kombi national Radio 17 HpT 4 RHZADA1_ZH ok 3751.77
460 ARD MEDIA Deutschland-Kombi 20 HpT 4 RHZAS16_ZH ok 37916.85
508 ARD MEDIA Deutschland-Kombi 14-49 22 HpT 4 RHZA016_ZH ok 28771.57
532 ARD MEDIA Deutschland-Kombi 40+ 23 HpT 4 RHZA031_ZH ok 24699.9
556 ARD MEDIA Deutschland-Kombi Young 24 HpT 4 RHZASYA_ZH ok 13797.1
580 ARD MEDIA Deutschland-Kombi Entscheider 25 HpT 4 RHZA032_ZH ok 16522.79
628 ARD MEDIA Privat-Kombi 27 HpT 4 RHZARP1_ZH ok 12955.25
676 bigFM NATIONAL 29 HpT 4 RHCBIGK_ZH ok 2323.21
748 DAB+ Deutschlandkombi 32 HpT 4 RHZDAB2_ZH ok 1783.18
772 ENERGY CITY KOMBI 33 HpT 4 RHZEC03_ZH ok 2384.78
796 ENERGY DAB+ National 34 HpT 4 RHZENHM_ZH ok 1327.99
844 ENERGY HIT MUSIC ONLY ! National 36 HpT 4 RHZENHN_ZH ok 2765.7
892 ENERGY HIT MUSIC ONLY PLUS 38 HpT 4 RHZEHMP_ZH ok 2968.09
916 JAM FM 39 HpT 4 RHZJAMF_ZH ok 697.78
964 RMS SUPER KOMBI 41 HpT 4 RHZRS24_ZH ok 29521.78
988 RMS YOUNG STARS 42 HpT 4 RHZRMY8_ZH ok 5234.6
1012 RMS AFTER WORK 43 HpT 4 RHZRMA9_ZH ok 8687.93
1108 RTL Kids & Family 47 HpT 4 RHZRTKF_ZH ok 1209.08
1156 Klassik Radio 49 HpT 4 RHZKLAR_ZH ok 2055.55
1204 Radio Holiday Germany 51 HpT 4 RHZRAHO_ZH ok 676.94
1228 Radio Paloma 52 HpT 4 RHERAPA_ZH ok 627.4
1252 Radio Schlagerparadies 53 HpT 4 RHZSCHL_ZH ok 902.12
1276 RTL RADIO 54 HpT 4 RHZRTLR_ZH ok 1094.85
1300 Schwarzwaldradio 55 HpT 4 RHDSWRA_ZH ok 413.36
1372 SUNSHINE LIVE 58 HpT 4 RHZSULI_ZH ok 1462.25
1468 ARD MEDIA West-Kombi 62 HpT 4 RHZAR14_ZH ok 21860.94
1516 Deutsches Städte-Network (DSN) 64 HpT 4 RHZROLP_ZH ok 987.47
1564 RMS WEST KOMBI 66 HpT 4 RHZRWPA_ZH ok 18607.85
1588 ARD MEDIA Bremen/Niedersachsen-Kombi 67 HpT 4 RHAASB1_ZH ok 2410.19
1612 ARD MEDIA Nord-Kombi 68 HpT 4 RHAASK5_ZH ok 6300.5
1636 Hamburg/Schleswig-Holstein-Kombi 69 HpT 4 RHAAHH1_ZH ok 1852.25
1660 NDR 2 70 HpT 4 RHAND2A_ZH ok 3569.21
1708 delta radio 72 HpT 4 RHADELT_ZH ok 422.56
1780 AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg 75 HpT 4 RHASHKB_ZH ok 1676.48
1852 R.SH Radio Schleswig-Holstein 78 HpT 4 RHARASH_ZH ok 1084.6
1924 RADIO BOB! rockt Schleswig-Holstein 81 HpT 4 RHANORA_ZH ok 562.88
1948 ENERGY Hamburg 82 HpT 4 RHAENHH_ZH ok 254.32
1996 Hamburg-Kombi 84 HpT 4 RHAHHK2_ZH ok 1288.42
2044 ROCK ANTENNE Hamburg 86 HpT 4 RHAROHH_ZH ok 364.79
2092 HAMBURG ZWEI 88 HpT 4 RHAOKRA_ZH ok 197.91
2164 Radio Hamburg 91 HpT 4 RHARAHH_ZH ok 915.8
2212 NiedersachsenPlus-Kombi 93 HpT 4 RHANIPL_ZH ok 1676.02
2236 NIEDERSACHSEN FUNKPAKET 94 HpT 4 RHANIFP_ZH ok 266.48
2260 RMS NIEDERSACHSEN KOMBI 14-49 95 HpT 4 RHARMNS_ZH ok 1975.16
2284 RMS NIEDERSACHSEN KOMBI KOMPAKT 96 HpT 4 RHARMNK_ZH ok 1416.95
2332 Antenne Niedersachsen 98 HpT 4 RHAANTE_ZH ok 986.63
2404 radio ffn 101 HpT 4 RHARFFN_ZH ok 1426.85
2500 RADIO 21 105 HpT 4 RHARA21_ZH ok 523.87
2548 ARD MEDIA Bremen Young 107 HpT 4 RHAASBY_ZH ok 865.72
2572 Bremen Total 108 HpT 4 RHARBTO_ZH ok 1193.97
2596 Bremen Eins 109 HpT 4 RHARAB1_ZH ok 708.91
2620 Bremen Vier 110 HpT 4 RHARAB4_ZH ok 512.68
2644 Bremen NEXT 111 HpT 4 RHABRNE_ZH ok 273.28
2668 ENERGY Bremen 112 HpT 4 RHARWVH_ZH ok 324.49
2716 radio NRW 114 HpT 4 RHBRNR2_ZH ok 3148.53
2764 radio NRW Premium 116 HpT 4 RHBRNRP_ZH ok 3134.47
2812 dortmundkombi-westfalen 118 HpT 4 RHBDOKW_ZH ok 441.1
2884 FUNK KOMBI OWL plus 121 HpT 4 RHBFOWL_ZH ok 554.33
2956 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 124 HpT 4 RHBFUK2_ZH ok 646.82
3028 MÜNSTERLAND KOMBI 127 HpT 4 RHBMLKB_ZH ok 357.51
3100 Rheinland Kombi Köln 130 HpT 4 RHBRLKK_ZH ok 540.75
3172 Westfunk Kombi Ruhr 133 HpT 4 RHBRUH3_ZH ok 733.32
3220 WDR Best of 14-49 135 HpT 4 RHBBO15_ZH ok 4975.5
3244 1LIVE plus 136 HpT 4 RHBW1LP_ZH ok 2661.28
3268 1LIVE 137 HpT 4 RHBW1LA_ZH ok 2592.23
3292 WDR 2 138 HpT 4 RHBWD2A_ZH ok 3233.5
3316 100,5 DAS HITRADIO. 139 HpT 4 RHB1005_ZH ok 108.71
3364 FFH Radio Kombi Hessen 141 HpT 4 RHCFHPL_ZH ok 1946.77
3412 HIT RADIO FFH 143 HpT 4 RHCRFFH_ZH ok 1600.34
3484 planet radio 146 HpT 4 RHCPLRA_ZH ok 368.11
3532 harmony.fm 148 HpT 4 RHCHAFM_ZH ok 228.07
3580 RADIO BOB! 150 HpT 4 RHCSKYR_ZH ok 2724.82
3628 hr Hessen Kombi 152 HpT 4 RHCHEK1_ZH ok 2275.75
3652 hr 14-49 Kombi 153 HpT 4 RHC1441_ZH ok 2252.21
3676 hr1+hr3 Kombi 154 HpT 4 RHCH131_ZH ok 1847.59
3700 hr1+hr4 Kombi 155 HpT 4 RHCH141_ZH ok 1373.35
3724 hr1+hr-iNFO Kombi 156 HpT 4 RHCH1S1_ZH ok 1182.5
3748 hr3+YOU FM Kombi 157 HpT 4 RHCH3XX_ZH ok 1721.53
3772 hr1 158 HpT 4 RHCHES1_ZH ok 861.7
3796 hr3 159 HpT 4 RHCHES3_ZH ok 1311.22
3820 hr4 160 HpT 4 RHCHES4_ZH ok 666.14
3844 hr-iNFO 161 HpT 4 RHCHRSL_ZH ok 452.2
3868 YOU FM 162 HpT 4 RHCHXXL_ZH ok 531.38
3892 Radio Frankfurt City 163 HpT 4 RHCRAFR_ZH ok 172.05
3916 RADIO SALÜ plus KOMBI 164 HpT 4 RHCRASC_ZH ok 710.57
3940 RADIO SALÜ 165 HpT 4 RHCRASA_ZH ok 597.87
3964 SR-Kombi 166 HpT 4 RHCSAKB_ZH ok 1135.24
3988 WFS Saarland Kombi 167 HpT 4 RHCWFS1_ZH ok 1450.21
4012 SR 1 168 HpT 4 RHCS1EW_ZH ok 754.1
4036 SR 3 Saarlandwelle 169 HpT 4 RHCS3SW_ZH ok 598.94
4084 bigFM Saarland 171 HpT 4 RHCBIGS_ZH ok 298.55

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_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
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);