media_variant

212 rows where variant = 12

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
12 Werbefunk 1 1100-1200 12 RHZAL21_LAMA ok 13113.43
36 ARD Sender 2 1100-1200 12 RHZA214_LAMA ok 6998.6
60 Private Sender 3 1100-1200 12 RHZPR15_LAMA ok 7437.74
180 Vermarkter ARD MEDIA Gesamt 8 1100-1200 12 RHZVA10_LAMA ok 8628.58
204 Vermarkter RMS Gesamt 9 1100-1200 12 RHZVR07_LAMA ok 5480.84
228 Vermarkter ENERGY Gesamt 10 1100-1200 12 RHZVE10_LAMA ok 193.68
252 Vermarkter STUDIO GONG Gesamt 11 1100-1200 12 RHZVG06_LAMA ok 1715.46
276 Vermarkter ad.audio Gesamt 12 1100-1200 12 RHZVAA2_LAMA ok 455.28
324 Absolut Radio 14 1100-1200 12 RHZABSS_LAMA ok 201.09
396 ad.audio DAB+ Kombi national Radio 17 1100-1200 12 RHZADA1_LAMA ok 449.98
468 ARD MEDIA Deutschland-Kombi 20 1100-1200 12 RHZAS16_LAMA ok 8469.08
516 ARD MEDIA Deutschland-Kombi 14-49 22 1100-1200 12 RHZA016_LAMA ok 5057.91
540 ARD MEDIA Deutschland-Kombi 40+ 23 1100-1200 12 RHZA031_LAMA ok 5609.64
564 ARD MEDIA Deutschland-Kombi Young 24 1100-1200 12 RHZASYA_LAMA ok 1824.65
588 ARD MEDIA Deutschland-Kombi Entscheider 25 1100-1200 12 RHZA032_LAMA ok 2752.4
636 ARD MEDIA Privat-Kombi 27 1100-1200 12 RHZARP1_LAMA ok 1928.33
684 bigFM NATIONAL 29 1100-1200 12 RHCBIGK_LAMA ok 226.17
756 DAB+ Deutschlandkombi 32 1100-1200 12 RHZDAB2_LAMA ok 256.93
780 ENERGY CITY KOMBI 33 1100-1200 12 RHZEC03_LAMA ok 149.04
804 ENERGY DAB+ National 34 1100-1200 12 RHZENHM_LAMA ok 78.41
852 ENERGY HIT MUSIC ONLY ! National 36 1100-1200 12 RHZENHN_LAMA ok 177.12
900 ENERGY HIT MUSIC ONLY PLUS 38 1100-1200 12 RHZEHMP_LAMA ok 193.68
924 JAM FM 39 1100-1200 12 RHZJAMF_LAMA ok 46.87
972 RMS SUPER KOMBI 41 1100-1200 12 RHZRS24_LAMA ok 5480.84
996 RMS YOUNG STARS 42 1100-1200 12 RHZRMY8_LAMA ok 558.45
1116 RTL Kids & Family 47 1100-1200 12 RHZRTKF_LAMA ok 101.53
1164 Klassik Radio 49 1100-1200 12 RHZKLAR_LAMA ok 242.42
1212 Radio Holiday Germany 51 1100-1200 12 RHZRAHO_LAMA ok 84.46
1236 Radio Paloma 52 1100-1200 12 RHERAPA_LAMA ok 115.99
1260 Radio Schlagerparadies 53 1100-1200 12 RHZSCHL_LAMA ok 116.2
1284 RTL RADIO 54 1100-1200 12 RHZRTLR_LAMA ok 96.14
1308 Schwarzwaldradio 55 1100-1200 12 RHDSWRA_LAMA ok 44.94
1380 SUNSHINE LIVE 58 1100-1200 12 RHZSULI_LAMA ok 157.9
1476 ARD MEDIA West-Kombi 62 1100-1200 12 RHZAR14_LAMA ok 3743.68
1524 Deutsches Städte-Network (DSN) 64 1100-1200 12 RHZROLP_LAMA ok 149.94
1572 RMS WEST KOMBI 66 1100-1200 12 RHZRWPA_LAMA ok 3226.62
1596 ARD MEDIA Bremen/Niedersachsen-Kombi 67 1100-1200 12 RHAASB1_LAMA ok 444.7
1620 ARD MEDIA Nord-Kombi 68 1100-1200 12 RHAASK5_LAMA ok 1300.61
1644 Hamburg/Schleswig-Holstein-Kombi 69 1100-1200 12 RHAAHH1_LAMA ok 355.46
1668 NDR 2 70 1100-1200 12 RHAND2A_LAMA ok 569.16
1716 delta radio 72 1100-1200 12 RHADELT_LAMA ok 37.84
1788 AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg 75 1100-1200 12 RHASHKB_LAMA ok 339.35
1860 R.SH Radio Schleswig-Holstein 78 1100-1200 12 RHARASH_LAMA ok 226.36
1932 RADIO BOB! rockt Schleswig-Holstein 81 1100-1200 12 RHANORA_LAMA ok 92.53
1956 ENERGY Hamburg 82 1100-1200 12 RHAENHH_LAMA ok 17.7
2004 Hamburg-Kombi 84 1100-1200 12 RHAHHK2_LAMA ok 184.91
2052 ROCK ANTENNE Hamburg 86 1100-1200 12 RHAROHH_LAMA ok 38.71
2100 HAMBURG ZWEI 88 1100-1200 12 RHAOKRA_LAMA ok 30.03
2172 Radio Hamburg 91 1100-1200 12 RHARAHH_LAMA ok 121.49
2220 NiedersachsenPlus-Kombi 93 1100-1200 12 RHANIPL_LAMA ok 197.09
2244 NIEDERSACHSEN FUNKPAKET 94 1100-1200 12 RHANIFP_LAMA ok 27.33
2268 RMS NIEDERSACHSEN KOMBI 14-49 95 1100-1200 12 RHARMNS_LAMA ok 252.9
2292 RMS NIEDERSACHSEN KOMBI KOMPAKT 96 1100-1200 12 RHARMNK_LAMA ok 183.43
2340 Antenne Niedersachsen 98 1100-1200 12 RHAANTE_LAMA ok 116.36
2412 radio ffn 101 1100-1200 12 RHARFFN_LAMA ok 167.02
2508 RADIO 21 105 1100-1200 12 RHARA21_LAMA ok 69.38
2556 ARD MEDIA Bremen Young 107 1100-1200 12 RHAASBY_LAMA ok 132.42
2580 Bremen Total 108 1100-1200 12 RHARBTO_LAMA ok 262.14
2604 Bremen Eins 109 1100-1200 12 RHARAB1_LAMA ok 167.81
2628 Bremen Vier 110 1100-1200 12 RHARAB4_LAMA ok 74.56
2652 Bremen NEXT 111 1100-1200 12 RHABRNE_LAMA ok 34.03
2676 ENERGY Bremen 112 1100-1200 12 RHARWVH_LAMA ok 32.73
2724 radio NRW 114 1100-1200 12 RHBRNR2_LAMA ok 604.18
2772 radio NRW Premium 116 1100-1200 12 RHBRNRP_LAMA ok 602.9
2820 dortmundkombi-westfalen 118 1100-1200 12 RHBDOKW_LAMA ok 77.5
2892 FUNK KOMBI OWL plus 121 1100-1200 12 RHBFOWL_LAMA ok 123.55
2964 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 124 1100-1200 12 RHBFUK2_LAMA ok 120.97
3036 MÜNSTERLAND KOMBI 127 1100-1200 12 RHBMLKB_LAMA ok 60.77
3108 Rheinland Kombi Köln 130 1100-1200 12 RHBRLKK_LAMA ok 93.59
3180 Westfunk Kombi Ruhr 133 1100-1200 12 RHBRUH3_LAMA ok 120.64
3228 WDR Best of 14-49 135 1100-1200 12 RHBBO15_LAMA ok 897.23
3252 1LIVE plus 136 1100-1200 12 RHBW1LP_LAMA ok 354.09
3276 1LIVE 137 1100-1200 12 RHBW1LA_LAMA ok 339.77
3300 WDR 2 138 1100-1200 12 RHBWD2A_LAMA ok 579.9
3324 100,5 DAS HITRADIO. 139 1100-1200 12 RHB1005_LAMA ok 16.11
3372 FFH Radio Kombi Hessen 141 1100-1200 12 RHCFHPL_LAMA ok 279.45
3420 HIT RADIO FFH 143 1100-1200 12 RHCRFFH_LAMA ok 221.59
3492 planet radio 146 1100-1200 12 RHCPLRA_LAMA ok 34.93
3540 harmony.fm 148 1100-1200 12 RHCHAFM_LAMA ok 31.85
3588 RADIO BOB! 150 1100-1200 12 RHCSKYR_LAMA ok 388.13
3636 hr Hessen Kombi 152 1100-1200 12 RHCHEK1_LAMA ok 439.76
3660 hr 14-49 Kombi 153 1100-1200 12 RHC1441_LAMA ok 295.27
3684 hr1+hr3 Kombi 154 1100-1200 12 RHCH131_LAMA ok 263.59
3708 hr1+hr4 Kombi 155 1100-1200 12 RHCH141_LAMA ok 322.86
3732 hr1+hr-iNFO Kombi 156 1100-1200 12 RHCH1S1_LAMA ok 181.67
3756 hr3+YOU FM Kombi 157 1100-1200 12 RHCH3XX_LAMA ok 162.84
3780 hr1 158 1100-1200 12 RHCHES1_LAMA ok 142.25
3804 hr3 159 1100-1200 12 RHCHES3_LAMA ok 130.89
3828 hr4 160 1100-1200 12 RHCHES4_LAMA ok 191.17
3852 hr-iNFO 161 1100-1200 12 RHCHRSL_LAMA ok 43.32
3876 YOU FM 162 1100-1200 12 RHCHXXL_LAMA ok 32.46
3900 Radio Frankfurt City 163 1100-1200 12 RHCRAFR_LAMA ok 20.54
3924 RADIO SALÜ plus KOMBI 164 1100-1200 12 RHCRASC_LAMA ok 96.34
3948 RADIO SALÜ 165 1100-1200 12 RHCRASA_LAMA ok 77.94
3972 SR-Kombi 166 1100-1200 12 RHCSAKB_LAMA ok 190.07
3996 WFS Saarland Kombi 167 1100-1200 12 RHCWFS1_LAMA ok 273.93
4020 SR 1 168 1100-1200 12 RHCS1EW_LAMA ok 71.68
4044 SR 3 Saarlandwelle 169 1100-1200 12 RHCS3SW_LAMA ok 125.58
4092 bigFM Saarland 171 1100-1200 12 RHCBIGS_LAMA ok 44.97
4140 RMS KOMBI BaWü + Rhl.-Pfalz 173 1100-1200 12 RHCRMB6_LAMA ok 1298.34

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