media_variant

215 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 RHZAL20_LAMA ok 12939.56
36 ARD Sender 2 1100-1200 12 RHZA214_LAMA ok 7035.37
60 Private Sender 3 1100-1200 12 RHZPR14_LAMA ok 7240.69
180 Vermarkter ARD MEDIA Gesamt 8 1100-1200 12 RHZVA09_LAMA ok 7967.15
204 Vermarkter RMS Gesamt 9 1100-1200 12 RHZVR06_LAMA ok 6331.21
228 Vermarkter ENERGY Gesamt 10 1100-1200 12 RHZVE10_LAMA ok 207.06
252 Vermarkter STUDIO GONG Gesamt 11 1100-1200 12 RHZVG05_LAMA ok 1662.26
276 Vermarkter ad.audio Gesamt 12 1100-1200 12 RHZVAA1_LAMA ok 188.12
324 Absolut Radio 14 1100-1200 12 RHZABSS_LAMA ok 181.01
396 ad.audio DAB+ Kombi national Radio 17 1100-1200 12 RHZADAD_LAMA ok 188.12
444 ARD MEDIA Deutschland-Kombi 19 1100-1200 12 RHZAS15_LAMA ok 7790.75
468 ARD MEDIA Deutschland-Kombi 14-49 20 1100-1200 12 RHZA015_LAMA ok 4393.46
492 ARD MEDIA Deutschland-Kombi 40+ 21 1100-1200 12 RHZA029_LAMA ok 5243.74
516 ARD MEDIA Deutschland-Kombi Young 22 1100-1200 12 RHZASY9_LAMA ok 1224.73
540 ARD MEDIA Deutschland-Kombi Entscheider 23 1100-1200 12 RHZA030_LAMA ok 2942.33
612 bigFM NATIONAL 26 1100-1200 12 RHCBIGK_LAMA ok 276.68
732 DAB+ Radiokombi Deutschland 31 1100-1200 12 RHZDAB1_LAMA ok 286.03
780 ENERGY CITY KOMBI 33 1100-1200 12 RHZEC03_LAMA ok 167.19
804 ENERGY DAB+ National 34 1100-1200 12 RHZENHM_LAMA ok 95.57
852 ENERGY HIT MUSIC ONLY ! National 36 1100-1200 12 RHZENHN_LAMA ok 188.94
900 JAM FM 38 1100-1200 12 RHZJAMF_LAMA ok 49.87
996 RMS SUPER KOMBI 42 1100-1200 12 RHZRS22_LAMA ok 6331.21
1044 RMS YOUNG STARS 44 1100-1200 12 RHZRMY7_LAMA ok 1138.78
1212 Klassik Radio 51 1100-1200 12 RHZKLAR_LAMA ok 217.56
1260 Radio Paloma 53 1100-1200 12 RHERAPA_LAMA ok 90.32
1284 Radio Schlagerparadies 54 1100-1200 12 RHZSCHL_LAMA ok 126.78
1332 RTL RADIO 56 1100-1200 12 RHZRTLR_LAMA ok 156.43
1356 Schwarzwaldradio 57 1100-1200 12 RHDSWRA_LAMA ok 45.95
1428 SUNSHINE LIVE 60 1100-1200 12 RHZSULI_LAMA ok 108.8
1524 ARD MEDIA West-Kombi 64 1100-1200 12 RHZAR13_LAMA ok 3344.49
1572 Deutsches Städte-Network (DSN) 66 1100-1200 12 RHZROLP_LAMA ok 109.51
1620 RMS WEST KOMBI 68 1100-1200 12 RHZRWP9_LAMA ok 3999.02
1644 ARD MEDIA Bremen/Niedersachsen-Kombi 69 1100-1200 12 RHAASB1_LAMA ok 435.36
1668 ARD MEDIA Nord-Kombi 70 1100-1200 12 RHAASK4_LAMA ok 971.54
1692 ARD MEDIA Schleswig-Holstein/Hamburg-Kombi 71 1100-1200 12 RHAAHHS_LAMA ok 34.1
1716 RMS Kombi Hamburg/Schleswig-Holstein 72 1100-1200 12 RHARMH2_LAMA ok 489.45
1740 Klassik Radio Gebiet Schleswig-Holstein/Hamburg 73 1100-1200 12 RHAKLSH_LAMA ok 14.12
1764 NDR 2 74 1100-1200 12 RHAND2A_LAMA ok 533.08
1812 delta radio 76 1100-1200 12 RHADELT_LAMA ok 36.22
1884 Kombi Schleswig-Holstein/Hamburg 79 1100-1200 12 RHASHKB_LAMA ok 312.24
1956 R.SH Radio Schleswig-Holstein 82 1100-1200 12 RHARASH_LAMA ok 207.23
2028 RADIO BOB! rockt Schleswig-Holstein 85 1100-1200 12 RHANORA_LAMA ok 83.2
2052 ENERGY Hamburg 86 1100-1200 12 RHAENHH_LAMA ok 19.99
2100 Hamburg-Kombi 88 1100-1200 12 RHAHHK2_LAMA ok 194.27
2148 ROCK ANTENNE Hamburg 90 1100-1200 12 RHAROHH_LAMA ok 26.8
2196 HAMBURG ZWEI 92 1100-1200 12 RHAOKRA_LAMA ok 20.48
2268 Radio Hamburg 95 1100-1200 12 RHARAHH_LAMA ok 151.68
2316 ARD MEDIA NiedersachsenPlus-Kombi 97 1100-1200 12 RHANIPL_LAMA ok 180.46
2340 NIEDERSACHSEN FUNKPAKET 98 1100-1200 12 RHANIFP_LAMA ok 22.32
2364 RMS NIEDERSACHSEN KOMBI 14-49 99 1100-1200 12 RHARMNS_LAMA ok 262.24
2388 RMS NIEDERSACHSEN KOMBI KOMPAKT 100 1100-1200 12 RHARMNK_LAMA ok 193.48
2436 Antenne Niedersachsen 102 1100-1200 12 RHAANTE_LAMA ok 116.78
2508 radio ffn 105 1100-1200 12 RHARFFN_LAMA ok 161.49
2604 RADIO 21 109 1100-1200 12 RHARA21_LAMA ok 79.73
2676 ARD MEDIA Bremen Young 112 1100-1200 12 RHAASBY_LAMA ok 148.61
2700 Bremen Total 113 1100-1200 12 RHARBTO_LAMA ok 266.41
2724 Bremen Eins 114 1100-1200 12 RHARAB1_LAMA ok 148.18
2748 Bremen Vier 115 1100-1200 12 RHARAB4_LAMA ok 100.59
2772 Bremen NEXT 116 1100-1200 12 RHABRNE_LAMA ok 33.89
2796 ENERGY Bremen 117 1100-1200 12 RHARWVH_LAMA ok 20.1
2844 radio NRW 119 1100-1200 12 RHBRNR2_LAMA ok 638.15
2916 dortmundkombi-westfalen 122 1100-1200 12 RHBDOKW_LAMA ok 103.22
2988 FUNK KOMBI OWL plus 125 1100-1200 12 RHBFOWL_LAMA ok 127.2
3060 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 128 1100-1200 12 RHBFUK2_LAMA ok 118.44
3132 MÜNSTERLAND KOMBI 131 1100-1200 12 RHBMLKB_LAMA ok 48.29
3204 Rheinland Kombi Köln 134 1100-1200 12 RHBRLKK_LAMA ok 106.23
3276 Westfunk Kombi Ruhr 137 1100-1200 12 RHBRUH3_LAMA ok 135.83
3324 WDR Best of 14-49 139 1100-1200 12 RHBBO15_LAMA ok 932.94
3348 1LIVE plus 140 1100-1200 12 RHBW1LP_LAMA ok 372.81
3372 1LIVE 141 1100-1200 12 RHBW1LA_LAMA ok 351.34
3396 WDR 2 142 1100-1200 12 RHBWD2A_LAMA ok 598.04
3420 100,5 DAS HITRADIO. 143 1100-1200 12 RHB1005_LAMA ok 24.35
3444 RMS SÜDWEST KOMBI 144 1100-1200 12 RHCRM14_LAMA ok 2895.66
3492 FFH Radio Kombi Hessen 146 1100-1200 12 RHCFHPL_LAMA ok 300.88
3540 HIT RADIO FFH 148 1100-1200 12 RHCRFFH_LAMA ok 234.15
3612 planet radio 151 1100-1200 12 RHCPLRA_LAMA ok 41.04
3660 harmony.fm 153 1100-1200 12 RHCHAFM_LAMA ok 34.32
3708 RADIO BOB! 155 1100-1200 12 RHCSKYR_LAMA ok 315.52
3756 RMS RADIO KOMBI HESSEN 157 1100-1200 12 RHCRMRH_LAMA ok 610.93
3780 hr Hessen Kombi 158 1100-1200 12 RHCHEK1_LAMA ok 407.46
3804 hr 14-49 Kombi 159 1100-1200 12 RHC1441_LAMA ok 298.14
3828 hr1+hr3 Kombi 160 1100-1200 12 RHCH131_LAMA ok 262.09
3852 hr1+hr4 Kombi 161 1100-1200 12 RHCH141_LAMA ok 279.22
3876 hr1+hr-iNFO Kombi 162 1100-1200 12 RHCH1S1_LAMA ok 157.95
3900 hr3+YOU FM Kombi 163 1100-1200 12 RHCH3XX_LAMA ok 180.53
3924 hr1 164 1100-1200 12 RHCHES1_LAMA ok 126.76
3948 hr3 165 1100-1200 12 RHCHES3_LAMA ok 144.26
3972 hr4 166 1100-1200 12 RHCHES4_LAMA ok 158.77
3996 hr-iNFO 167 1100-1200 12 RHCHRSL_LAMA ok 33.83
4020 YOU FM 168 1100-1200 12 RHCHXXL_LAMA ok 37.32
4044 Radio Frankfurt City 169 1100-1200 12 RHCRAFR_LAMA ok 15.06
4068 RADIO SALÜ plus KOMBI 170 1100-1200 12 RHCRASC_LAMA ok 85.62
4092 RADIO SALÜ 171 1100-1200 12 RHCRASA_LAMA ok 70.1
4116 SR-Kombi 172 1100-1200 12 RHCSAKB_LAMA ok 221.59
4140 WFS Saarland Kombi 173 1100-1200 12 RHCWFS1_LAMA ok 293.8
4164 SR 1 174 1100-1200 12 RHCS1EW_LAMA ok 100.31
4188 SR 3 Saarlandwelle 175 1100-1200 12 RHCS3SW_LAMA ok 132.48
4236 bigFM Saarland 177 1100-1200 12 RHCBIGS_LAMA ok 52.23
4284 RMS KOMBI BaWü + Rhl.-Pfalz 179 1100-1200 12 RHCRMB5_LAMA ok 1386.67
4308 SWR3 180 1100-1200 12 RHCSW32_LAMA ok 935.85

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