media_variant

222 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 RHZAL20_ZH ok 48320.44
28 ARD Sender 2 HpT 4 RHZA214_ZH ok 32370.8
52 Private Sender 3 HpT 4 RHZPR14_ZH ok 35524.94
172 Vermarkter ARD MEDIA Gesamt 8 HpT 4 RHZVA09_ZH ok 36415.68
196 Vermarkter RMS Gesamt 9 HpT 4 RHZVR06_ZH ok 31824.18
220 Vermarkter ENERGY Gesamt 10 HpT 4 RHZVE10_ZH ok 3068.3
244 Vermarkter STUDIO GONG Gesamt 11 HpT 4 RHZVG05_ZH ok 10547.89
268 Vermarkter ad.audio Gesamt 12 HpT 4 RHZVAA1_ZH ok 1643.81
316 Absolut Radio 14 HpT 4 RHZABSS_ZH ok 1512.71
388 ad.audio DAB+ Kombi national Radio 17 HpT 4 RHZADAD_ZH ok 1643.81
436 ARD MEDIA Deutschland-Kombi 19 HpT 4 RHZAS15_ZH ok 35661.76
460 ARD MEDIA Deutschland-Kombi 14-49 20 HpT 4 RHZA015_ZH ok 25802.16
484 ARD MEDIA Deutschland-Kombi 40+ 21 HpT 4 RHZA029_ZH ok 22773.24
508 ARD MEDIA Deutschland-Kombi Young 22 HpT 4 RHZASY9_ZH ok 10462.1
532 ARD MEDIA Deutschland-Kombi Entscheider 23 HpT 4 RHZA030_ZH ok 16937.8
604 bigFM NATIONAL 26 HpT 4 RHCBIGK_ZH ok 2309.75
724 DAB+ Radiokombi Deutschland 31 HpT 4 RHZDAB1_ZH ok 2129.93
772 ENERGY CITY KOMBI 33 HpT 4 RHZEC03_ZH ok 2524.56
796 ENERGY DAB+ National 34 HpT 4 RHZENHM_ZH ok 1465.26
844 ENERGY HIT MUSIC ONLY ! National 36 HpT 4 RHZENHN_ZH ok 2874.43
892 JAM FM 38 HpT 4 RHZJAMF_ZH ok 683.06
988 RMS SUPER KOMBI 42 HpT 4 RHZRS22_ZH ok 31824.18
1036 RMS YOUNG STARS 44 HpT 4 RHZRMY7_ZH ok 8945.79
1060 RMS AFTER WORK 45 HpT 4 RHZRMA8_ZH ok 9747.35
1204 Klassik Radio 51 HpT 4 RHZKLAR_ZH ok 1945.11
1252 Radio Paloma 53 HpT 4 RHERAPA_ZH ok 571.03
1276 Radio Schlagerparadies 54 HpT 4 RHZSCHL_ZH ok 861.62
1324 RTL RADIO 56 HpT 4 RHZRTLR_ZH ok 1154.45
1348 Schwarzwaldradio 57 HpT 4 RHDSWRA_ZH ok 415.34
1420 SUNSHINE LIVE 60 HpT 4 RHZSULI_ZH ok 1272.68
1516 ARD MEDIA West-Kombi 64 HpT 4 RHZAR13_ZH ok 19982.84
1564 Deutsches Städte-Network (DSN) 66 HpT 4 RHZROLP_ZH ok 822.98
1612 RMS WEST KOMBI 68 HpT 4 RHZRWP9_ZH ok 21836.49
1636 ARD MEDIA Bremen/Niedersachsen-Kombi 69 HpT 4 RHAASB1_ZH ok 2281.63
1660 ARD MEDIA Nord-Kombi 70 HpT 4 RHAASK4_ZH ok 5132.02
1684 ARD MEDIA Schleswig-Holstein/Hamburg-Kombi 71 HpT 4 RHAAHHS_ZH ok 481.8
1708 RMS Kombi Hamburg/Schleswig-Holstein 72 HpT 4 RHARMH2_ZH ok 2599.42
1732 Klassik Radio Gebiet Schleswig-Holstein/Hamburg 73 HpT 4 RHAKLSH_ZH ok 174.34
1756 NDR 2 74 HpT 4 RHAND2A_ZH ok 3288.92
1804 delta radio 76 HpT 4 RHADELT_ZH ok 399.8
1876 Kombi Schleswig-Holstein/Hamburg 79 HpT 4 RHASHKB_ZH ok 1622.43
1948 R.SH Radio Schleswig-Holstein 82 HpT 4 RHARASH_ZH ok 1086.31
2020 RADIO BOB! rockt Schleswig-Holstein 85 HpT 4 RHANORA_ZH ok 504.93
2044 ENERGY Hamburg 86 HpT 4 RHAENHH_ZH ok 316.73
2092 Hamburg-Kombi 88 HpT 4 RHAHHK2_ZH ok 1396.01
2140 ROCK ANTENNE Hamburg 90 HpT 4 RHAROHH_ZH ok 311.28
2188 HAMBURG ZWEI 92 HpT 4 RHAOKRA_ZH ok 215.29
2260 Radio Hamburg 95 HpT 4 RHARAHH_ZH ok 1071.49
2308 ARD MEDIA NiedersachsenPlus-Kombi 97 HpT 4 RHANIPL_ZH ok 1614.29
2332 NIEDERSACHSEN FUNKPAKET 98 HpT 4 RHANIFP_ZH ok 252.9
2356 RMS NIEDERSACHSEN KOMBI 14-49 99 HpT 4 RHARMNS_ZH ok 1807.84
2380 RMS NIEDERSACHSEN KOMBI KOMPAKT 100 HpT 4 RHARMNK_ZH ok 1309.91
2428 Antenne Niedersachsen 102 HpT 4 RHAANTE_ZH ok 921.85
2500 radio ffn 105 HpT 4 RHARFFN_ZH ok 1377.03
2596 RADIO 21 109 HpT 4 RHARA21_ZH ok 482.55
2668 ARD MEDIA Bremen Young 112 HpT 4 RHAASBY_ZH ok 818.72
2692 Bremen Total 113 HpT 4 RHARBTO_ZH ok 1114.35
2716 Bremen Eins 114 HpT 4 RHARAB1_ZH ok 665.58
2740 Bremen Vier 115 HpT 4 RHARAB4_ZH ok 507.17
2764 Bremen NEXT 116 HpT 4 RHABRNE_ZH ok 230.76
2788 ENERGY Bremen 117 HpT 4 RHARWVH_ZH ok 311.55
2836 radio NRW 119 HpT 4 RHBRNR2_ZH ok 3244.25
2908 dortmundkombi-westfalen 122 HpT 4 RHBDOKW_ZH ok 480.57
2980 FUNK KOMBI OWL plus 125 HpT 4 RHBFOWL_ZH ok 554.65
3052 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 128 HpT 4 RHBFUK2_ZH ok 679.94
3124 MÜNSTERLAND KOMBI 131 HpT 4 RHBMLKB_ZH ok 341.18
3196 Rheinland Kombi Köln 134 HpT 4 RHBRLKK_ZH ok 620.58
3268 Westfunk Kombi Ruhr 137 HpT 4 RHBRUH3_ZH ok 751.61
3316 WDR Best of 14-49 139 HpT 4 RHBBO15_ZH ok 5235.94
3340 1LIVE plus 140 HpT 4 RHBW1LP_ZH ok 2905.4
3364 1LIVE 141 HpT 4 RHBW1LA_ZH ok 2828.17
3388 WDR 2 142 HpT 4 RHBWD2A_ZH ok 3354.88
3412 100,5 DAS HITRADIO. 143 HpT 4 RHB1005_ZH ok 124.3
3436 RMS SÜDWEST KOMBI 144 HpT 4 RHCRM14_ZH ok 16745.02
3484 FFH Radio Kombi Hessen 146 HpT 4 RHCFHPL_ZH ok 2007.14
3532 HIT RADIO FFH 148 HpT 4 RHCRFFH_ZH ok 1626.21
3604 planet radio 151 HpT 4 RHCPLRA_ZH ok 402.6
3652 harmony.fm 153 HpT 4 RHCHAFM_ZH ok 254.84
3700 RADIO BOB! 155 HpT 4 RHCSKYR_ZH ok 2370.73
3748 RMS RADIO KOMBI HESSEN 157 HpT 4 RHCRMRH_ZH ok 4180.5
3772 hr Hessen Kombi 158 HpT 4 RHCHEK1_ZH ok 2020.38
3796 hr 14-49 Kombi 159 HpT 4 RHC1441_ZH ok 2131.18
3820 hr1+hr3 Kombi 160 HpT 4 RHCH131_ZH ok 1629.71
3844 hr1+hr4 Kombi 161 HpT 4 RHCH141_ZH ok 1181.91
3868 hr1+hr-iNFO Kombi 162 HpT 4 RHCH1S1_ZH ok 1001.12
3892 hr3+YOU FM Kombi 163 HpT 4 RHCH3XX_ZH ok 1702.32
3916 hr1 164 HpT 4 RHCHES1_ZH ok 701.52
3940 hr3 165 HpT 4 RHCHES3_ZH ok 1193.12
3964 hr4 166 HpT 4 RHCHES4_ZH ok 590.63
3988 hr-iNFO 167 HpT 4 RHCHRSL_ZH ok 407.76
4012 YOU FM 168 HpT 4 RHCHXXL_ZH ok 632.5
4036 Radio Frankfurt City 169 HpT 4 RHCRAFR_ZH ok 156.22
4060 RADIO SALÜ plus KOMBI 170 HpT 4 RHCRASC_ZH ok 743.19
4084 RADIO SALÜ 171 HpT 4 RHCRASA_ZH ok 641.48
4108 SR-Kombi 172 HpT 4 RHCSAKB_ZH ok 1176.69
4132 WFS Saarland Kombi 173 HpT 4 RHCWFS1_ZH ok 1505.41
4156 SR 1 174 HpT 4 RHCS1EW_ZH ok 814.34
4180 SR 3 Saarlandwelle 175 HpT 4 RHCS3SW_ZH ok 602.66
4228 bigFM Saarland 177 HpT 4 RHCBIGS_ZH ok 241.45
4276 RMS KOMBI BaWü + Rhl.-Pfalz 179 HpT 4 RHCRMB5_ZH ok 9175.01

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