media_variant

209 rows where variant = 19

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
19 Werbefunk 1 1800-1900 19 RHZAL21_SATA ok 10535.78
43 ARD Sender 2 1800-1900 19 RHZA214_SATA ok 5068.89
67 Private Sender 3 1800-1900 19 RHZPR15_SATA ok 6566.87
187 Vermarkter ARD MEDIA Gesamt 8 1800-1900 19 RHZVA10_SATA ok 6676.2
211 Vermarkter RMS Gesamt 9 1800-1900 19 RHZVR07_SATA ok 4584.11
235 Vermarkter ENERGY Gesamt 10 1800-1900 19 RHZVE10_SATA ok 283.02
259 Vermarkter STUDIO GONG Gesamt 11 1800-1900 19 RHZVG06_SATA ok 1386.97
283 Vermarkter ad.audio Gesamt 12 1800-1900 19 RHZVAA2_SATA ok 591.43
331 Absolut Radio 14 1800-1900 19 RHZABSS_SATA ok 244.87
403 ad.audio DAB+ Kombi national Radio 17 1800-1900 19 RHZADA1_SATA ok 580.85
475 ARD MEDIA Deutschland-Kombi 20 1800-1900 19 RHZAS16_SATA ok 6645.19
523 ARD MEDIA Deutschland-Kombi 14-49 22 1800-1900 19 RHZA016_SATA ok 4716.32
547 ARD MEDIA Deutschland-Kombi 40+ 23 1800-1900 19 RHZA031_SATA ok 3222.95
571 ARD MEDIA Deutschland-Kombi Young 24 1800-1900 19 RHZASYA_SATA ok 1963.77
595 ARD MEDIA Deutschland-Kombi Entscheider 25 1800-1900 19 RHZA032_SATA ok 2174.91
643 ARD MEDIA Privat-Kombi 27 1800-1900 19 RHZARP1_SATA ok 1896.01
691 bigFM NATIONAL 29 1800-1900 19 RHCBIGK_SATA ok 279.18
763 DAB+ Deutschlandkombi 32 1800-1900 19 RHZDAB2_SATA ok 171.66
787 ENERGY CITY KOMBI 33 1800-1900 19 RHZEC03_SATA ok 243.88
811 ENERGY DAB+ National 34 1800-1900 19 RHZENHM_SATA ok 98.8
859 ENERGY HIT MUSIC ONLY ! National 36 1800-1900 19 RHZENHN_SATA ok 277.76
907 ENERGY HIT MUSIC ONLY PLUS 38 1800-1900 19 RHZEHMP_SATA ok 283.02
931 JAM FM 39 1800-1900 19 RHZJAMF_SATA ok 62.56
979 RMS SUPER KOMBI 41 1800-1900 19 RHZRS24_SATA ok 4584.11
1003 RMS YOUNG STARS 42 1800-1900 19 RHZRMY8_SATA ok 672.97
1027 RMS AFTER WORK 43 1800-1900 19 RHZRMA9_SATA ok 4584.11
1123 RTL Kids & Family 47 1800-1900 19 RHZRTKF_SATA ok 95.78
1171 Klassik Radio 49 1800-1900 19 RHZKLAR_SATA ok 324.05
1219 Radio Holiday Germany 51 1800-1900 19 RHZRAHO_SATA ok 57.95
1243 Radio Paloma 52 1800-1900 19 RHERAPA_SATA ok 74.45
1267 Radio Schlagerparadies 53 1800-1900 19 RHZSCHL_SATA ok 92.29
1291 RTL RADIO 54 1800-1900 19 RHZRTLR_SATA ok 84.39
1315 Schwarzwaldradio 55 1800-1900 19 RHDSWRA_SATA ok 43.58
1387 SUNSHINE LIVE 58 1800-1900 19 RHZSULI_SATA ok 146.59
1483 ARD MEDIA West-Kombi 62 1800-1900 19 RHZAR14_SATA ok 3446.58
1531 Deutsches Städte-Network (DSN) 64 1800-1900 19 RHZROLP_SATA ok 101.58
1579 RMS WEST KOMBI 66 1800-1900 19 RHZRWPA_SATA ok 2619.95
1603 ARD MEDIA Bremen/Niedersachsen-Kombi 67 1800-1900 19 RHAASB1_SATA ok 375.89
1627 ARD MEDIA Nord-Kombi 68 1800-1900 19 RHAASK5_SATA ok 1009.53
1651 Hamburg/Schleswig-Holstein-Kombi 69 1800-1900 19 RHAAHH1_SATA ok 263.37
1675 NDR 2 70 1800-1900 19 RHAND2A_SATA ok 428.18
1723 delta radio 72 1800-1900 19 RHADELT_SATA ok 53.28
1795 AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg 75 1800-1900 19 RHASHKB_SATA ok 233.89
1867 R.SH Radio Schleswig-Holstein 78 1800-1900 19 RHARASH_SATA ok 151.36
1939 RADIO BOB! rockt Schleswig-Holstein 81 1800-1900 19 RHANORA_SATA ok 43.37
1963 ENERGY Hamburg 82 1800-1900 19 RHAENHH_SATA ok 32.97
2011 Hamburg-Kombi 84 1800-1900 19 RHAHHK2_SATA ok 209.09
2059 ROCK ANTENNE Hamburg 86 1800-1900 19 RHAROHH_SATA ok 63.23
2107 HAMBURG ZWEI 88 1800-1900 19 RHAOKRA_SATA ok 32.18
2179 Radio Hamburg 91 1800-1900 19 RHARAHH_SATA ok 123.58
2227 NiedersachsenPlus-Kombi 93 1800-1900 19 RHANIPL_SATA ok 210.61
2251 NIEDERSACHSEN FUNKPAKET 94 1800-1900 19 RHANIFP_SATA ok 19.9
2275 RMS NIEDERSACHSEN KOMBI 14-49 95 1800-1900 19 RHARMNS_SATA ok 211.97
2299 RMS NIEDERSACHSEN KOMBI KOMPAKT 96 1800-1900 19 RHARMNK_SATA ok 154.73
2347 Antenne Niedersachsen 98 1800-1900 19 RHAANTE_SATA ok 94.39
2419 radio ffn 101 1800-1900 19 RHARFFN_SATA ok 187.83
2515 RADIO 21 105 1800-1900 19 RHARA21_SATA ok 62.09
2563 ARD MEDIA Bremen Young 107 1800-1900 19 RHAASBY_SATA ok 81.25
2587 Bremen Total 108 1800-1900 19 RHARBTO_SATA ok 174.54
2611 Bremen Eins 109 1800-1900 19 RHARAB1_SATA ok 121.84
2635 Bremen Vier 110 1800-1900 19 RHARAB4_SATA ok 45.57
2659 Bremen NEXT 111 1800-1900 19 RHABRNE_SATA ok 15.08
2683 ENERGY Bremen 112 1800-1900 19 RHARWVH_SATA ok 23.96
2731 radio NRW 114 1800-1900 19 RHBRNR2_SATA ok 399.99
2779 radio NRW Premium 116 1800-1900 19 RHBRNRP_SATA ok 396.56
2827 dortmundkombi-westfalen 118 1800-1900 19 RHBDOKW_SATA ok 42.88
2899 FUNK KOMBI OWL plus 121 1800-1900 19 RHBFOWL_SATA ok 77.48
2971 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 124 1800-1900 19 RHBFUK2_SATA ok 67.09
3043 MÜNSTERLAND KOMBI 127 1800-1900 19 RHBMLKB_SATA ok 44.48
3115 Rheinland Kombi Köln 130 1800-1900 19 RHBRLKK_SATA ok 64.62
3187 Westfunk Kombi Ruhr 133 1800-1900 19 RHBRUH3_SATA ok 98.1
3235 WDR Best of 14-49 135 1800-1900 19 RHBBO15_SATA ok 712.32
3259 1LIVE plus 136 1800-1900 19 RHBW1LP_SATA ok 323.07
3283 1LIVE 137 1800-1900 19 RHBW1LA_SATA ok 315.16
3307 WDR 2 138 1800-1900 19 RHBWD2A_SATA ok 429.23
3331 100,5 DAS HITRADIO. 139 1800-1900 19 RHB1005_SATA ok 8.8
3379 FFH Radio Kombi Hessen 141 1800-1900 19 RHCFHPL_SATA ok 228.58
3427 HIT RADIO FFH 143 1800-1900 19 RHCRFFH_SATA ok 160.31
3499 planet radio 146 1800-1900 19 RHCPLRA_SATA ok 45.67
3547 harmony.fm 148 1800-1900 19 RHCHAFM_SATA ok 31.51
3595 RADIO BOB! 150 1800-1900 19 RHCSKYR_SATA ok 439.35
3643 hr Hessen Kombi 152 1800-1900 19 RHCHEK1_SATA ok 304.37
3667 hr 14-49 Kombi 153 1800-1900 19 RHC1441_SATA ok 295.81
3691 hr1+hr3 Kombi 154 1800-1900 19 RHCH131_SATA ok 238.49
3715 hr1+hr4 Kombi 155 1800-1900 19 RHCH141_SATA ok 177.55
3739 hr1+hr-iNFO Kombi 156 1800-1900 19 RHCH1S1_SATA ok 146.39
3763 hr3+YOU FM Kombi 157 1800-1900 19 RHCH3XX_SATA ok 196.71
3787 hr1 158 1800-1900 19 RHCHES1_SATA ok 108.85
3811 hr3 159 1800-1900 19 RHCHES3_SATA ok 138.39
3835 hr4 160 1800-1900 19 RHCHES4_SATA ok 72.37
3859 hr-iNFO 161 1800-1900 19 RHCHRSL_SATA ok 41.2
3883 YOU FM 162 1800-1900 19 RHCHXXL_SATA ok 60.9
3907 Radio Frankfurt City 163 1800-1900 19 RHCRAFR_SATA ok 8.99
3931 RADIO SALÜ plus KOMBI 164 1800-1900 19 RHCRASC_SATA ok 109.05
3955 RADIO SALÜ 165 1800-1900 19 RHCRASA_SATA ok 79.8
3979 SR-Kombi 166 1800-1900 19 RHCSAKB_SATA ok 183.07
4003 WFS Saarland Kombi 167 1800-1900 19 RHCWFS1_SATA ok 272.65
4027 SR 1 168 1800-1900 19 RHCS1EW_SATA ok 97.7
4051 SR 3 Saarlandwelle 169 1800-1900 19 RHCS3SW_SATA ok 92.53
4099 bigFM Saarland 171 1800-1900 19 RHCBIGS_SATA ok 38.03

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