media_variant

211 rows where variant = 11

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
11 Werbefunk 1 1000-1100 11 RHZAL21_KALA ok 13831.43
35 ARD Sender 2 1000-1100 11 RHZA214_KALA ok 7382.82
59 Private Sender 3 1000-1100 11 RHZPR15_KALA ok 7904.83
179 Vermarkter ARD MEDIA Gesamt 8 1000-1100 11 RHZVA10_KALA ok 9063.76
203 Vermarkter RMS Gesamt 9 1000-1100 11 RHZVR07_KALA ok 5826.83
227 Vermarkter ENERGY Gesamt 10 1000-1100 11 RHZVE10_KALA ok 231.3
251 Vermarkter STUDIO GONG Gesamt 11 1000-1100 11 RHZVG06_KALA ok 1842.1
275 Vermarkter ad.audio Gesamt 12 1000-1100 11 RHZVAA2_KALA ok 522.72
323 Absolut Radio 14 1000-1100 11 RHZABSS_KALA ok 245.33
395 ad.audio DAB+ Kombi national Radio 17 1000-1100 11 RHZADA1_KALA ok 514.97
467 ARD MEDIA Deutschland-Kombi 20 1000-1100 11 RHZAS16_KALA ok 8962.05
515 ARD MEDIA Deutschland-Kombi 14-49 22 1000-1100 11 RHZA016_KALA ok 5434.95
539 ARD MEDIA Deutschland-Kombi 40+ 23 1000-1100 11 RHZA031_KALA ok 5885.61
563 ARD MEDIA Deutschland-Kombi Young 24 1000-1100 11 RHZASYA_KALA ok 1939.01
587 ARD MEDIA Deutschland-Kombi Entscheider 25 1000-1100 11 RHZA032_KALA ok 2979.6
635 ARD MEDIA Privat-Kombi 27 1000-1100 11 RHZARP1_KALA ok 2013.21
683 bigFM NATIONAL 29 1000-1100 11 RHCBIGK_KALA ok 279.91
755 DAB+ Deutschlandkombi 32 1000-1100 11 RHZDAB2_KALA ok 281.55
779 ENERGY CITY KOMBI 33 1000-1100 11 RHZEC03_KALA ok 179.41
803 ENERGY DAB+ National 34 1000-1100 11 RHZENHM_KALA ok 98.93
851 ENERGY HIT MUSIC ONLY ! National 36 1000-1100 11 RHZENHN_KALA ok 218.05
899 ENERGY HIT MUSIC ONLY PLUS 38 1000-1100 11 RHZEHMP_KALA ok 231.3
923 JAM FM 39 1000-1100 11 RHZJAMF_KALA ok 61.23
971 RMS SUPER KOMBI 41 1000-1100 11 RHZRS24_KALA ok 5826.83
995 RMS YOUNG STARS 42 1000-1100 11 RHZRMY8_KALA ok 639.46
1115 RTL Kids & Family 47 1000-1100 11 RHZRTKF_KALA ok 108.13
1163 Klassik Radio 49 1000-1100 11 RHZKLAR_KALA ok 260.28
1211 Radio Holiday Germany 51 1000-1100 11 RHZRAHO_KALA ok 93.75
1235 Radio Paloma 52 1000-1100 11 RHERAPA_KALA ok 118.29
1259 Radio Schlagerparadies 53 1000-1100 11 RHZSCHL_KALA ok 142.28
1283 RTL RADIO 54 1000-1100 11 RHZRTLR_KALA ok 100.05
1307 Schwarzwaldradio 55 1000-1100 11 RHDSWRA_KALA ok 49.54
1379 SUNSHINE LIVE 58 1000-1100 11 RHZSULI_KALA ok 164.59
1475 ARD MEDIA West-Kombi 62 1000-1100 11 RHZAR14_KALA ok 4065.94
1523 Deutsches Städte-Network (DSN) 64 1000-1100 11 RHZROLP_KALA ok 138.08
1571 RMS WEST KOMBI 66 1000-1100 11 RHZRWPA_KALA ok 3396.61
1595 ARD MEDIA Bremen/Niedersachsen-Kombi 67 1000-1100 11 RHAASB1_KALA ok 479.91
1619 ARD MEDIA Nord-Kombi 68 1000-1100 11 RHAASK5_KALA ok 1388.36
1643 Hamburg/Schleswig-Holstein-Kombi 69 1000-1100 11 RHAAHH1_KALA ok 332.2
1667 NDR 2 70 1000-1100 11 RHAND2A_KALA ok 657.18
1715 delta radio 72 1000-1100 11 RHADELT_KALA ok 27.44
1787 AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg 75 1000-1100 11 RHASHKB_KALA ok 317.74
1859 R.SH Radio Schleswig-Holstein 78 1000-1100 11 RHARASH_KALA ok 212.4
1931 RADIO BOB! rockt Schleswig-Holstein 81 1000-1100 11 RHANORA_KALA ok 93.45
1955 ENERGY Hamburg 82 1000-1100 11 RHAENHH_KALA ok 15.48
2003 Hamburg-Kombi 84 1000-1100 11 RHAHHK2_KALA ok 203.23
2051 ROCK ANTENNE Hamburg 86 1000-1100 11 RHAROHH_KALA ok 47.62
2099 HAMBURG ZWEI 88 1000-1100 11 RHAOKRA_KALA ok 32.93
2171 Radio Hamburg 91 1000-1100 11 RHARAHH_KALA ok 129.54
2219 NiedersachsenPlus-Kombi 93 1000-1100 11 RHANIPL_KALA ok 211.06
2243 NIEDERSACHSEN FUNKPAKET 94 1000-1100 11 RHANIFP_KALA ok 48.48
2267 RMS NIEDERSACHSEN KOMBI 14-49 95 1000-1100 11 RHARMNS_KALA ok 249.66
2291 RMS NIEDERSACHSEN KOMBI KOMPAKT 96 1000-1100 11 RHARMNK_KALA ok 188.73
2339 Antenne Niedersachsen 98 1000-1100 11 RHAANTE_KALA ok 125.01
2411 radio ffn 101 1000-1100 11 RHARFFN_KALA ok 179.39
2507 RADIO 21 105 1000-1100 11 RHARA21_KALA ok 65.35
2555 ARD MEDIA Bremen Young 107 1000-1100 11 RHAASBY_KALA ok 130.61
2579 Bremen Total 108 1000-1100 11 RHARBTO_KALA ok 285.28
2603 Bremen Eins 109 1000-1100 11 RHARAB1_KALA ok 196.32
2627 Bremen Vier 110 1000-1100 11 RHARAB4_KALA ok 75.69
2651 Bremen NEXT 111 1000-1100 11 RHABRNE_KALA ok 28.4
2675 ENERGY Bremen 112 1000-1100 11 RHARWVH_KALA ok 33.56
2723 radio NRW 114 1000-1100 11 RHBRNR2_KALA ok 629.24
2771 radio NRW Premium 116 1000-1100 11 RHBRNRP_KALA ok 627.37
2819 dortmundkombi-westfalen 118 1000-1100 11 RHBDOKW_KALA ok 71
2891 FUNK KOMBI OWL plus 121 1000-1100 11 RHBFOWL_KALA ok 119.48
2963 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 124 1000-1100 11 RHBFUK2_KALA ok 125.57
3035 MÜNSTERLAND KOMBI 127 1000-1100 11 RHBMLKB_KALA ok 67.93
3107 Rheinland Kombi Köln 130 1000-1100 11 RHBRLKK_KALA ok 92.46
3179 Westfunk Kombi Ruhr 133 1000-1100 11 RHBRUH3_KALA ok 146.74
3227 WDR Best of 14-49 135 1000-1100 11 RHBBO15_KALA ok 960.1
3251 1LIVE plus 136 1000-1100 11 RHBW1LP_KALA ok 405.45
3275 1LIVE 137 1000-1100 11 RHBW1LA_KALA ok 392.37
3299 WDR 2 138 1000-1100 11 RHBWD2A_KALA ok 596.09
3323 100,5 DAS HITRADIO. 139 1000-1100 11 RHB1005_KALA ok 14.72
3371 FFH Radio Kombi Hessen 141 1000-1100 11 RHCFHPL_KALA ok 298.41
3419 HIT RADIO FFH 143 1000-1100 11 RHCRFFH_KALA ok 229.94
3491 planet radio 146 1000-1100 11 RHCPLRA_KALA ok 40.47
3539 harmony.fm 148 1000-1100 11 RHCHAFM_KALA ok 36.56
3587 RADIO BOB! 150 1000-1100 11 RHCSKYR_KALA ok 385.54
3635 hr Hessen Kombi 152 1000-1100 11 RHCHEK1_KALA ok 481.83
3659 hr 14-49 Kombi 153 1000-1100 11 RHC1441_KALA ok 335.34
3683 hr1+hr3 Kombi 154 1000-1100 11 RHCH131_KALA ok 302.23
3707 hr1+hr4 Kombi 155 1000-1100 11 RHCH141_KALA ok 339.66
3731 hr1+hr-iNFO Kombi 156 1000-1100 11 RHCH1S1_KALA ok 196.32
3755 hr3+YOU FM Kombi 157 1000-1100 11 RHCH3XX_KALA ok 195.39
3779 hr1 158 1000-1100 11 RHCHES1_KALA ok 154.09
3803 hr3 159 1000-1100 11 RHCHES3_KALA ok 161.99
3827 hr4 160 1000-1100 11 RHCHES4_KALA ok 197.6
3851 hr-iNFO 161 1000-1100 11 RHCHRSL_KALA ok 47.41
3875 YOU FM 162 1000-1100 11 RHCHXXL_KALA ok 34.23
3899 Radio Frankfurt City 163 1000-1100 11 RHCRAFR_KALA ok 17.23
3923 RADIO SALÜ plus KOMBI 164 1000-1100 11 RHCRASC_KALA ok 109.2
3947 RADIO SALÜ 165 1000-1100 11 RHCRASA_KALA ok 93.07
3971 SR-Kombi 166 1000-1100 11 RHCSAKB_KALA ok 225.15
3995 WFS Saarland Kombi 167 1000-1100 11 RHCWFS1_KALA ok 317.38
4019 SR 1 168 1000-1100 11 RHCS1EW_KALA ok 99.87
4043 SR 3 Saarlandwelle 169 1000-1100 11 RHCS3SW_KALA ok 137.1
4091 bigFM Saarland 171 1000-1100 11 RHCBIGS_KALA ok 36.19
4139 RMS KOMBI BaWü + Rhl.-Pfalz 173 1000-1100 11 RHCRMB6_KALA ok 1396.14

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