media_variant

214 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 RHZAL20_KALA ok 13645.89
35 ARD Sender 2 1000-1100 11 RHZA214_KALA ok 7407.15
59 Private Sender 3 1000-1100 11 RHZPR14_KALA ok 7695.25
179 Vermarkter ARD MEDIA Gesamt 8 1000-1100 11 RHZVA09_KALA ok 8470.59
203 Vermarkter RMS Gesamt 9 1000-1100 11 RHZVR06_KALA ok 6685.73
227 Vermarkter ENERGY Gesamt 10 1000-1100 11 RHZVE10_KALA ok 265.01
251 Vermarkter STUDIO GONG Gesamt 11 1000-1100 11 RHZVG05_KALA ok 1776.89
275 Vermarkter ad.audio Gesamt 12 1000-1100 11 RHZVAA1_KALA ok 239.31
323 Absolut Radio 14 1000-1100 11 RHZABSS_KALA ok 226.57
395 ad.audio DAB+ Kombi national Radio 17 1000-1100 11 RHZADAD_KALA ok 239.31
443 ARD MEDIA Deutschland-Kombi 19 1000-1100 11 RHZAS15_KALA ok 8378.28
467 ARD MEDIA Deutschland-Kombi 14-49 20 1000-1100 11 RHZA015_KALA ok 4817.85
491 ARD MEDIA Deutschland-Kombi 40+ 21 1000-1100 11 RHZA029_KALA ok 5584.75
515 ARD MEDIA Deutschland-Kombi Young 22 1000-1100 11 RHZASY9_KALA ok 1394.16
539 ARD MEDIA Deutschland-Kombi Entscheider 23 1000-1100 11 RHZA030_KALA ok 3235.99
611 bigFM NATIONAL 26 1000-1100 11 RHCBIGK_KALA ok 338.53
731 DAB+ Radiokombi Deutschland 31 1000-1100 11 RHZDAB1_KALA ok 337.46
779 ENERGY CITY KOMBI 33 1000-1100 11 RHZEC03_KALA ok 216.67
803 ENERGY DAB+ National 34 1000-1100 11 RHZENHM_KALA ok 139.16
851 ENERGY HIT MUSIC ONLY ! National 36 1000-1100 11 RHZENHN_KALA ok 245.44
899 JAM FM 38 1000-1100 11 RHZJAMF_KALA ok 58.91
995 RMS SUPER KOMBI 42 1000-1100 11 RHZRS22_KALA ok 6685.73
1043 RMS YOUNG STARS 44 1000-1100 11 RHZRMY7_KALA ok 1259.05
1211 Klassik Radio 51 1000-1100 11 RHZKLAR_KALA ok 247.59
1259 Radio Paloma 53 1000-1100 11 RHERAPA_KALA ok 82.05
1283 Radio Schlagerparadies 54 1000-1100 11 RHZSCHL_KALA ok 132.92
1331 RTL RADIO 56 1000-1100 11 RHZRTLR_KALA ok 127.38
1355 Schwarzwaldradio 57 1000-1100 11 RHDSWRA_KALA ok 56.07
1427 SUNSHINE LIVE 60 1000-1100 11 RHZSULI_KALA ok 124.15
1523 ARD MEDIA West-Kombi 64 1000-1100 11 RHZAR13_KALA ok 3685.36
1571 Deutsches Städte-Network (DSN) 66 1000-1100 11 RHZROLP_KALA ok 117.87
1619 RMS WEST KOMBI 68 1000-1100 11 RHZRWP9_KALA ok 4202.96
1643 ARD MEDIA Bremen/Niedersachsen-Kombi 69 1000-1100 11 RHAASB1_KALA ok 434.94
1667 ARD MEDIA Nord-Kombi 70 1000-1100 11 RHAASK4_KALA ok 1040.92
1691 ARD MEDIA Schleswig-Holstein/Hamburg-Kombi 71 1000-1100 11 RHAAHHS_KALA ok 31.19
1715 RMS Kombi Hamburg/Schleswig-Holstein 72 1000-1100 11 RHARMH2_KALA ok 506.59
1739 Klassik Radio Gebiet Schleswig-Holstein/Hamburg 73 1000-1100 11 RHAKLSH_KALA ok 10.81
1763 NDR 2 74 1000-1100 11 RHAND2A_KALA ok 610.64
1811 delta radio 76 1000-1100 11 RHADELT_KALA ok 38.41
1883 Kombi Schleswig-Holstein/Hamburg 79 1000-1100 11 RHASHKB_KALA ok 320.82
1955 R.SH Radio Schleswig-Holstein 82 1000-1100 11 RHARASH_KALA ok 213.18
2027 RADIO BOB! rockt Schleswig-Holstein 85 1000-1100 11 RHANORA_KALA ok 84.47
2051 ENERGY Hamburg 86 1000-1100 11 RHAENHH_KALA ok 20.42
2099 Hamburg-Kombi 88 1000-1100 11 RHAHHK2_KALA ok 202.91
2147 ROCK ANTENNE Hamburg 90 1000-1100 11 RHAROHH_KALA ok 29.02
2195 HAMBURG ZWEI 92 1000-1100 11 RHAOKRA_KALA ok 29.02
2267 Radio Hamburg 95 1000-1100 11 RHARAHH_KALA ok 149.64
2315 ARD MEDIA NiedersachsenPlus-Kombi 97 1000-1100 11 RHANIPL_KALA ok 156.45
2339 NIEDERSACHSEN FUNKPAKET 98 1000-1100 11 RHANIFP_KALA ok 25.21
2363 RMS NIEDERSACHSEN KOMBI 14-49 99 1000-1100 11 RHARMNS_KALA ok 252.37
2387 RMS NIEDERSACHSEN KOMBI KOMPAKT 100 1000-1100 11 RHARMNK_KALA ok 186.61
2435 Antenne Niedersachsen 102 1000-1100 11 RHAANTE_KALA ok 113.6
2507 radio ffn 105 1000-1100 11 RHARFFN_KALA ok 137.94
2603 RADIO 21 109 1000-1100 11 RHARA21_KALA ok 75.62
2675 ARD MEDIA Bremen Young 112 1000-1100 11 RHAASBY_KALA ok 154.75
2699 Bremen Total 113 1000-1100 11 RHARBTO_KALA ok 288.77
2723 Bremen Eins 114 1000-1100 11 RHARAB1_KALA ok 167.94
2747 Bremen Vier 115 1000-1100 11 RHARAB4_KALA ok 111.97
2771 Bremen NEXT 116 1000-1100 11 RHABRNE_KALA ok 28.17
2795 ENERGY Bremen 117 1000-1100 11 RHARWVH_KALA ok 19.28
2843 radio NRW 119 1000-1100 11 RHBRNR2_KALA ok 696.72
2915 dortmundkombi-westfalen 122 1000-1100 11 RHBDOKW_KALA ok 102.68
2987 FUNK KOMBI OWL plus 125 1000-1100 11 RHBFOWL_KALA ok 138.8
3059 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 128 1000-1100 11 RHBFUK2_KALA ok 133.4
3131 MÜNSTERLAND KOMBI 131 1000-1100 11 RHBMLKB_KALA ok 48.28
3203 Rheinland Kombi Köln 134 1000-1100 11 RHBRLKK_KALA ok 125.93
3275 Westfunk Kombi Ruhr 137 1000-1100 11 RHBRUH3_KALA ok 152.08
3323 WDR Best of 14-49 139 1000-1100 11 RHBBO15_KALA ok 1047.81
3347 1LIVE plus 140 1000-1100 11 RHBW1LP_KALA ok 444.3
3371 1LIVE 141 1000-1100 11 RHBW1LA_KALA ok 424.51
3395 WDR 2 142 1000-1100 11 RHBWD2A_KALA ok 652.64
3419 100,5 DAS HITRADIO. 143 1000-1100 11 RHB1005_KALA ok 23.15
3443 RMS SÜDWEST KOMBI 144 1000-1100 11 RHCRM14_KALA ok 3043.83
3491 FFH Radio Kombi Hessen 146 1000-1100 11 RHCFHPL_KALA ok 294.82
3539 HIT RADIO FFH 148 1000-1100 11 RHCRFFH_KALA ok 231.11
3611 planet radio 151 1000-1100 11 RHCPLRA_KALA ok 39.39
3659 harmony.fm 153 1000-1100 11 RHCHAFM_KALA ok 34.07
3707 RADIO BOB! 155 1000-1100 11 RHCSKYR_KALA ok 322.59
3755 RMS RADIO KOMBI HESSEN 157 1000-1100 11 RHCRMRH_KALA ok 611
3779 hr Hessen Kombi 158 1000-1100 11 RHCHEK1_KALA ok 421.79
3803 hr 14-49 Kombi 159 1000-1100 11 RHC1441_KALA ok 315.59
3827 hr1+hr3 Kombi 160 1000-1100 11 RHCH131_KALA ok 273.92
3851 hr1+hr4 Kombi 161 1000-1100 11 RHCH141_KALA ok 287.48
3875 hr1+hr-iNFO Kombi 162 1000-1100 11 RHCH1S1_KALA ok 167.44
3899 hr3+YOU FM Kombi 163 1000-1100 11 RHCH3XX_KALA ok 191.94
3923 hr1 164 1000-1100 11 RHCHES1_KALA ok 133.35
3947 hr3 165 1000-1100 11 RHCHES3_KALA ok 149.87
3971 hr4 166 1000-1100 11 RHCHES4_KALA ok 160.64
3995 hr-iNFO 167 1000-1100 11 RHCHRSL_KALA ok 37.84
4019 YOU FM 168 1000-1100 11 RHCHXXL_KALA ok 42.96
4043 Radio Frankfurt City 169 1000-1100 11 RHCRAFR_KALA ok 17.43
4067 RADIO SALÜ plus KOMBI 170 1000-1100 11 RHCRASC_KALA ok 123.75
4091 RADIO SALÜ 171 1000-1100 11 RHCRASA_KALA ok 109.36
4115 SR-Kombi 172 1000-1100 11 RHCSAKB_KALA ok 272.37
4139 WFS Saarland Kombi 173 1000-1100 11 RHCWFS1_KALA ok 372.07
4163 SR 1 174 1000-1100 11 RHCS1EW_KALA ok 154.5
4187 SR 3 Saarlandwelle 175 1000-1100 11 RHCS3SW_KALA ok 134.15
4235 bigFM Saarland 177 1000-1100 11 RHCBIGS_KALA ok 45.14
4283 RMS KOMBI BaWü + Rhl.-Pfalz 179 1000-1100 11 RHCRMB5_KALA ok 1500.4
4307 SWR3 180 1000-1100 11 RHCSW32_KALA ok 994.59

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