media_variant

216 rows where variant = 13

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
13 Werbefunk 1 1200-1300 13 RHZAL21_MANA ok 13257.87
37 ARD Sender 2 1200-1300 13 RHZA214_MANA ok 7126.71
61 Private Sender 3 1200-1300 13 RHZPR15_MANA ok 7549.42
181 Vermarkter ARD MEDIA Gesamt 8 1200-1300 13 RHZVA10_MANA ok 8801.05
205 Vermarkter RMS Gesamt 9 1200-1300 13 RHZVR07_MANA ok 5559.57
229 Vermarkter ENERGY Gesamt 10 1200-1300 13 RHZVE10_MANA ok 259.04
253 Vermarkter STUDIO GONG Gesamt 11 1200-1300 13 RHZVG06_MANA ok 1836.2
277 Vermarkter ad.audio Gesamt 12 1200-1300 13 RHZVAA2_MANA ok 442.58
325 Absolut Radio 14 1200-1300 13 RHZABSS_MANA ok 226.75
397 ad.audio DAB+ Kombi national Radio 17 1200-1300 13 RHZADA1_MANA ok 436.97
469 ARD MEDIA Deutschland-Kombi 20 1200-1300 13 RHZAS16_MANA ok 8651.8
517 ARD MEDIA Deutschland-Kombi 14-49 22 1200-1300 13 RHZA016_MANA ok 5248.18
541 ARD MEDIA Deutschland-Kombi 40+ 23 1200-1300 13 RHZA031_MANA ok 5615.09
565 ARD MEDIA Deutschland-Kombi Young 24 1200-1300 13 RHZASYA_MANA ok 1932.22
589 ARD MEDIA Deutschland-Kombi Entscheider 25 1200-1300 13 RHZA032_MANA ok 2821.67
637 ARD MEDIA Privat-Kombi 27 1200-1300 13 RHZARP1_MANA ok 2004.2
685 bigFM NATIONAL 29 1200-1300 13 RHCBIGK_MANA ok 234.83
757 DAB+ Deutschlandkombi 32 1200-1300 13 RHZDAB2_MANA ok 256.91
781 ENERGY CITY KOMBI 33 1200-1300 13 RHZEC03_MANA ok 174.04
805 ENERGY DAB+ National 34 1200-1300 13 RHZENHM_MANA ok 99.4
853 ENERGY HIT MUSIC ONLY ! National 36 1200-1300 13 RHZENHN_MANA ok 231.29
901 ENERGY HIT MUSIC ONLY PLUS 38 1200-1300 13 RHZEHMP_MANA ok 259.04
925 JAM FM 39 1200-1300 13 RHZJAMF_MANA ok 46.39
973 RMS SUPER KOMBI 41 1200-1300 13 RHZRS24_MANA ok 5559.57
997 RMS YOUNG STARS 42 1200-1300 13 RHZRMY8_MANA ok 577.09
1117 RTL Kids & Family 47 1200-1300 13 RHZRTKF_MANA ok 130.95
1165 Klassik Radio 49 1200-1300 13 RHZKLAR_MANA ok 203.23
1213 Radio Holiday Germany 51 1200-1300 13 RHZRAHO_MANA ok 82.44
1237 Radio Paloma 52 1200-1300 13 RHERAPA_MANA ok 97.17
1261 Radio Schlagerparadies 53 1200-1300 13 RHZSCHL_MANA ok 125.69
1285 RTL RADIO 54 1200-1300 13 RHZRTLR_MANA ok 125.08
1309 Schwarzwaldradio 55 1200-1300 13 RHDSWRA_MANA ok 59.73
1381 SUNSHINE LIVE 58 1200-1300 13 RHZSULI_MANA ok 162.5
1477 ARD MEDIA West-Kombi 62 1200-1300 13 RHZAR14_MANA ok 3870.72
1525 Deutsches Städte-Network (DSN) 64 1200-1300 13 RHZROLP_MANA ok 124.2
1573 RMS WEST KOMBI 66 1200-1300 13 RHZRWPA_MANA ok 3333.37
1597 ARD MEDIA Bremen/Niedersachsen-Kombi 67 1200-1300 13 RHAASB1_MANA ok 441.15
1621 ARD MEDIA Nord-Kombi 68 1200-1300 13 RHAASK5_MANA ok 1266.12
1645 Hamburg/Schleswig-Holstein-Kombi 69 1200-1300 13 RHAAHH1_MANA ok 356.77
1669 NDR 2 70 1200-1300 13 RHAND2A_MANA ok 539.7
1717 delta radio 72 1200-1300 13 RHADELT_MANA ok 49.21
1789 AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg 75 1200-1300 13 RHASHKB_MANA ok 337.19
1861 R.SH Radio Schleswig-Holstein 78 1200-1300 13 RHARASH_MANA ok 215.36
1933 RADIO BOB! rockt Schleswig-Holstein 81 1200-1300 13 RHANORA_MANA ok 92.22
1957 ENERGY Hamburg 82 1200-1300 13 RHAENHH_MANA ok 21.46
2005 Hamburg-Kombi 84 1200-1300 13 RHAHHK2_MANA ok 208.31
2053 ROCK ANTENNE Hamburg 86 1200-1300 13 RHAROHH_MANA ok 38.41
2101 HAMBURG ZWEI 88 1200-1300 13 RHAOKRA_MANA ok 22.13
2173 Radio Hamburg 91 1200-1300 13 RHARAHH_MANA ok 154.74
2221 NiedersachsenPlus-Kombi 93 1200-1300 13 RHANIPL_MANA ok 208.46
2245 NIEDERSACHSEN FUNKPAKET 94 1200-1300 13 RHANIFP_MANA ok 36.59
2269 RMS NIEDERSACHSEN KOMBI 14-49 95 1200-1300 13 RHARMNS_MANA ok 233.13
2293 RMS NIEDERSACHSEN KOMBI KOMPAKT 96 1200-1300 13 RHARMNK_MANA ok 168.37
2341 Antenne Niedersachsen 98 1200-1300 13 RHAANTE_MANA ok 117.3
2413 radio ffn 101 1200-1300 13 RHARFFN_MANA ok 180.12
2509 RADIO 21 105 1200-1300 13 RHARA21_MANA ok 53.14
2557 ARD MEDIA Bremen Young 107 1200-1300 13 RHAASBY_MANA ok 121.87
2581 Bremen Total 108 1200-1300 13 RHARBTO_MANA ok 246.55
2605 Bremen Eins 109 1200-1300 13 RHARAB1_MANA ok 160.49
2629 Bremen Vier 110 1200-1300 13 RHARAB4_MANA ok 59.7
2653 Bremen NEXT 111 1200-1300 13 RHABRNE_MANA ok 38.9
2677 ENERGY Bremen 112 1200-1300 13 RHARWVH_MANA ok 30.23
2725 radio NRW 114 1200-1300 13 RHBRNR2_MANA ok 582.78
2773 radio NRW Premium 116 1200-1300 13 RHBRNRP_MANA ok 582.37
2821 dortmundkombi-westfalen 118 1200-1300 13 RHBDOKW_MANA ok 79.48
2893 FUNK KOMBI OWL plus 121 1200-1300 13 RHBFOWL_MANA ok 109.63
2965 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 124 1200-1300 13 RHBFUK2_MANA ok 106.37
3037 MÜNSTERLAND KOMBI 127 1200-1300 13 RHBMLKB_MANA ok 77.58
3109 Rheinland Kombi Köln 130 1200-1300 13 RHBRLKK_MANA ok 85.38
3181 Westfunk Kombi Ruhr 133 1200-1300 13 RHBRUH3_MANA ok 121.49
3229 WDR Best of 14-49 135 1200-1300 13 RHBBO15_MANA ok 845.07
3253 1LIVE plus 136 1200-1300 13 RHBW1LP_MANA ok 358.83
3277 1LIVE 137 1200-1300 13 RHBW1LA_MANA ok 344.82
3301 WDR 2 138 1200-1300 13 RHBWD2A_MANA ok 524.6
3325 100,5 DAS HITRADIO. 139 1200-1300 13 RHB1005_MANA ok 15.13
3373 FFH Radio Kombi Hessen 141 1200-1300 13 RHCFHPL_MANA ok 262.58
3421 HIT RADIO FFH 143 1200-1300 13 RHCRFFH_MANA ok 215.58
3493 planet radio 146 1200-1300 13 RHCPLRA_MANA ok 37.21
3541 harmony.fm 148 1200-1300 13 RHCHAFM_MANA ok 17.56
3589 RADIO BOB! 150 1200-1300 13 RHCSKYR_MANA ok 433.41
3637 hr Hessen Kombi 152 1200-1300 13 RHCHEK1_MANA ok 466.37
3661 hr 14-49 Kombi 153 1200-1300 13 RHC1441_MANA ok 325.48
3685 hr1+hr3 Kombi 154 1200-1300 13 RHCH131_MANA ok 293.6
3709 hr1+hr4 Kombi 155 1200-1300 13 RHCH141_MANA ok 342.68
3733 hr1+hr-iNFO Kombi 156 1200-1300 13 RHCH1S1_MANA ok 212.54
3757 hr3+YOU FM Kombi 157 1200-1300 13 RHCH3XX_MANA ok 175.66
3781 hr1 158 1200-1300 13 RHCHES1_MANA ok 163.11
3805 hr3 159 1200-1300 13 RHCHES3_MANA ok 143.25
3829 hr4 160 1200-1300 13 RHCHES4_MANA ok 190.96
3853 hr-iNFO 161 1200-1300 13 RHCHRSL_MANA ok 54.87
3877 YOU FM 162 1200-1300 13 RHCHXXL_MANA ok 33.61
3901 Radio Frankfurt City 163 1200-1300 13 RHCRAFR_MANA ok 15.24
3925 RADIO SALÜ plus KOMBI 164 1200-1300 13 RHCRASC_MANA ok 100.59
3949 RADIO SALÜ 165 1200-1300 13 RHCRASA_MANA ok 84.49
3973 SR-Kombi 166 1200-1300 13 RHCSAKB_MANA ok 230.88
3997 WFS Saarland Kombi 167 1200-1300 13 RHCWFS1_MANA ok 314.22
4021 SR 1 168 1200-1300 13 RHCS1EW_MANA ok 96.61
4045 SR 3 Saarlandwelle 169 1200-1300 13 RHCS3SW_MANA ok 146.2
4093 bigFM Saarland 171 1200-1300 13 RHCBIGS_MANA ok 21.47
4141 RMS KOMBI BaWü + Rhl.-Pfalz 173 1200-1300 13 RHCRMB6_MANA ok 1412.49

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