media_variant

210 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 RHZAL20_SATA ok 10192.55
43 ARD Sender 2 1800-1900 19 RHZA214_SATA ok 5070.15
67 Private Sender 3 1800-1900 19 RHZPR14_SATA ok 6181.63
187 Vermarkter ARD MEDIA Gesamt 8 1800-1900 19 RHZVA09_SATA ok 6102.93
211 Vermarkter RMS Gesamt 9 1800-1900 19 RHZVR06_SATA ok 5260.11
235 Vermarkter ENERGY Gesamt 10 1800-1900 19 RHZVE10_SATA ok 306.81
259 Vermarkter STUDIO GONG Gesamt 11 1800-1900 19 RHZVG05_SATA ok 1364.53
283 Vermarkter ad.audio Gesamt 12 1800-1900 19 RHZVAA1_SATA ok 242.72
331 Absolut Radio 14 1800-1900 19 RHZABSS_SATA ok 214.65
403 ad.audio DAB+ Kombi national Radio 17 1800-1900 19 RHZADAD_SATA ok 242.72
451 ARD MEDIA Deutschland-Kombi 19 1800-1900 19 RHZAS15_SATA ok 6078.14
475 ARD MEDIA Deutschland-Kombi 14-49 20 1800-1900 19 RHZA015_SATA ok 3950.99
523 ARD MEDIA Deutschland-Kombi Young 22 1800-1900 19 RHZASY9_SATA ok 1323.53
619 bigFM NATIONAL 26 1800-1900 19 RHCBIGK_SATA ok 279.22
739 DAB+ Radiokombi Deutschland 31 1800-1900 19 RHZDAB1_SATA ok 293.53
787 ENERGY CITY KOMBI 33 1800-1900 19 RHZEC03_SATA ok 248.44
811 ENERGY DAB+ National 34 1800-1900 19 RHZENHM_SATA ok 115.68
859 ENERGY HIT MUSIC ONLY ! National 36 1800-1900 19 RHZENHN_SATA ok 301.68
907 JAM FM 38 1800-1900 19 RHZJAMF_SATA ok 59.17
1003 RMS SUPER KOMBI 42 1800-1900 19 RHZRS22_SATA ok 5260.11
1051 RMS YOUNG STARS 44 1800-1900 19 RHZRMY7_SATA ok 1232.22
1075 RMS AFTER WORK 45 1800-1900 19 RHZRMA8_SATA ok 5260.11
1219 Klassik Radio 51 1800-1900 19 RHZKLAR_SATA ok 288.86
1267 Radio Paloma 53 1800-1900 19 RHERAPA_SATA ok 50.65
1291 Radio Schlagerparadies 54 1800-1900 19 RHZSCHL_SATA ok 90.72
1339 RTL RADIO 56 1800-1900 19 RHZRTLR_SATA ok 81.55
1363 Schwarzwaldradio 57 1800-1900 19 RHDSWRA_SATA ok 41.65
1435 SUNSHINE LIVE 60 1800-1900 19 RHZSULI_SATA ok 140.39
1531 ARD MEDIA West-Kombi 64 1800-1900 19 RHZAR13_SATA ok 2950.95
1579 Deutsches Städte-Network (DSN) 66 1800-1900 19 RHZROLP_SATA ok 95.82
1627 RMS WEST KOMBI 68 1800-1900 19 RHZRWP9_SATA ok 3360.67
1651 ARD MEDIA Bremen/Niedersachsen-Kombi 69 1800-1900 19 RHAASB1_SATA ok 323.34
1675 ARD MEDIA Nord-Kombi 70 1800-1900 19 RHAASK4_SATA ok 717.72
1699 ARD MEDIA Schleswig-Holstein/Hamburg-Kombi 71 1800-1900 19 RHAAHHS_SATA ok 35.45
1723 RMS Kombi Hamburg/Schleswig-Holstein 72 1800-1900 19 RHARMH2_SATA ok 368.09
1747 Klassik Radio Gebiet Schleswig-Holstein/Hamburg 73 1800-1900 19 RHAKLSH_SATA ok 15.67
1771 NDR 2 74 1800-1900 19 RHAND2A_SATA ok 386.91
1819 delta radio 76 1800-1900 19 RHADELT_SATA ok 42.51
1891 Kombi Schleswig-Holstein/Hamburg 79 1800-1900 19 RHASHKB_SATA ok 184.31
1963 R.SH Radio Schleswig-Holstein 82 1800-1900 19 RHARASH_SATA ok 119.89
2035 RADIO BOB! rockt Schleswig-Holstein 85 1800-1900 19 RHANORA_SATA ok 28.6
2059 ENERGY Hamburg 86 1800-1900 19 RHAENHH_SATA ok 19.79
2107 Hamburg-Kombi 88 1800-1900 19 RHAHHK2_SATA ok 197.03
2155 ROCK ANTENNE Hamburg 90 1800-1900 19 RHAROHH_SATA ok 41.88
2203 HAMBURG ZWEI 92 1800-1900 19 RHAOKRA_SATA ok 20.18
2275 Radio Hamburg 95 1800-1900 19 RHARAHH_SATA ok 141.64
2323 ARD MEDIA NiedersachsenPlus-Kombi 97 1800-1900 19 RHANIPL_SATA ok 184.15
2347 NIEDERSACHSEN FUNKPAKET 98 1800-1900 19 RHANIFP_SATA ok 33.54
2371 RMS NIEDERSACHSEN KOMBI 14-49 99 1800-1900 19 RHARMNS_SATA ok 187.93
2395 RMS NIEDERSACHSEN KOMBI KOMPAKT 100 1800-1900 19 RHARMNK_SATA ok 132.64
2443 Antenne Niedersachsen 102 1800-1900 19 RHAANTE_SATA ok 72.62
2515 radio ffn 105 1800-1900 19 RHARFFN_SATA ok 152.7
2611 RADIO 21 109 1800-1900 19 RHARA21_SATA ok 61.31
2683 ARD MEDIA Bremen Young 112 1800-1900 19 RHAASBY_SATA ok 94.58
2707 Bremen Total 113 1800-1900 19 RHARBTO_SATA ok 148.51
2731 Bremen Eins 114 1800-1900 19 RHARAB1_SATA ok 88.54
2755 Bremen Vier 115 1800-1900 19 RHARAB4_SATA ok 46.11
2779 Bremen NEXT 116 1800-1900 19 RHABRNE_SATA ok 21.23
2803 ENERGY Bremen 117 1800-1900 19 RHARWVH_SATA ok 33.04
2851 radio NRW 119 1800-1900 19 RHBRNR2_SATA ok 443.42
2923 dortmundkombi-westfalen 122 1800-1900 19 RHBDOKW_SATA ok 52.42
2995 FUNK KOMBI OWL plus 125 1800-1900 19 RHBFOWL_SATA ok 86.8
3067 FUNK-KOMBI WEST - DER BALLUNGSRAUM DÜSSELDORF 128 1800-1900 19 RHBFUK2_SATA ok 87.48
3139 MÜNSTERLAND KOMBI 131 1800-1900 19 RHBMLKB_SATA ok 41.31
3211 Rheinland Kombi Köln 134 1800-1900 19 RHBRLKK_SATA ok 78.27
3283 Westfunk Kombi Ruhr 137 1800-1900 19 RHBRUH3_SATA ok 98.65
3331 WDR Best of 14-49 139 1800-1900 19 RHBBO15_SATA ok 797.3
3355 1LIVE plus 140 1800-1900 19 RHBW1LP_SATA ok 387.98
3379 1LIVE 141 1800-1900 19 RHBW1LA_SATA ok 380.91
3403 WDR 2 142 1800-1900 19 RHBWD2A_SATA ok 445.07
3427 100,5 DAS HITRADIO. 143 1800-1900 19 RHB1005_SATA ok 8.06
3451 RMS SÜDWEST KOMBI 144 1800-1900 19 RHCRM14_SATA ok 2630.09
3499 FFH Radio Kombi Hessen 146 1800-1900 19 RHCFHPL_SATA ok 258.25
3547 HIT RADIO FFH 148 1800-1900 19 RHCRFFH_SATA ok 185.32
3619 planet radio 151 1800-1900 19 RHCPLRA_SATA ok 46.88
3667 harmony.fm 153 1800-1900 19 RHCHAFM_SATA ok 37.74
3715 RADIO BOB! 155 1800-1900 19 RHCSKYR_SATA ok 370.57
3763 RMS RADIO KOMBI HESSEN 157 1800-1900 19 RHCRMRH_SATA ok 621.71
3787 hr Hessen Kombi 158 1800-1900 19 RHCHEK1_SATA ok 278.04
3811 hr 14-49 Kombi 159 1800-1900 19 RHC1441_SATA ok 285.27
3835 hr1+hr3 Kombi 160 1800-1900 19 RHCH131_SATA ok 211.24
3859 hr1+hr4 Kombi 161 1800-1900 19 RHCH141_SATA ok 156.62
3883 hr1+hr-iNFO Kombi 162 1800-1900 19 RHCH1S1_SATA ok 117.33
3907 hr3+YOU FM Kombi 163 1800-1900 19 RHCH3XX_SATA ok 207.31
3931 hr1 164 1800-1900 19 RHCHES1_SATA ok 86.65
3955 hr3 165 1800-1900 19 RHCHES3_SATA ok 132.07
3979 hr4 166 1800-1900 19 RHCHES4_SATA ok 72.93
4003 hr-iNFO 167 1800-1900 19 RHCHRSL_SATA ok 32.71
4027 YOU FM 168 1800-1900 19 RHCHXXL_SATA ok 78.11
4051 Radio Frankfurt City 169 1800-1900 19 RHCRAFR_SATA ok 11.35
4075 RADIO SALÜ plus KOMBI 170 1800-1900 19 RHCRASC_SATA ok 84.13
4099 RADIO SALÜ 171 1800-1900 19 RHCRASA_SATA ok 59.06
4123 SR-Kombi 172 1800-1900 19 RHCSAKB_SATA ok 145.81
4147 WFS Saarland Kombi 173 1800-1900 19 RHCWFS1_SATA ok 214.44
4171 SR 1 174 1800-1900 19 RHCS1EW_SATA ok 81.55
4195 SR 3 Saarlandwelle 175 1800-1900 19 RHCS3SW_SATA ok 69.5
4243 bigFM Saarland 177 1800-1900 19 RHCBIGS_SATA ok 37.42
4291 RMS KOMBI BaWü + Rhl.-Pfalz 179 1800-1900 19 RHCRMB5_SATA ok 1273.84
4315 SWR3 180 1800-1900 19 RHCSW32_SATA ok 860.18
4339 SWR1 Kombi BW/RP 181 1800-1900 19 RHCSW11_SATA ok 510.8

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