media_variant
1,200 rows where timerange = 43
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 52 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCH_0_000_A_1707_XX | pup | 0 | 4.837164 |
| 76 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCH_0_000_A_1505_XX | pup | 0 | 2.460547 |
| 100 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_17_XX | pup | 0 | 0.706086 |
| 124 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_15_XX | pup | 0 | 0.500786 |
| 148 | Airboards Köln CH_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_06_XX | pup | 0 | 1.51162 |
| 172 | Airboards Köln CH_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_07_XX | pup | 0 | 0.91171 |
| 230 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCI_0_000_A_1707_XX | pup | 0 | 0.22019 |
| 254 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCI_0_000_A_1505_XX | pup | 0 | 0.13103 |
| 278 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_17_XX | pup | 0 | 0.031511 |
| 302 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_15_XX | pup | 0 | 0.026245 |
| 326 | Airboards Paderborn CI_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_06_XX | pup | 0 | 0.079303 |
| 350 | Airboards Paderborn CI_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_07_XX | pup | 0 | 0.009991 |
| 408 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCF_0_000_A_1707_XX | pup | 0 | 13.820397 |
| 432 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCF_0_000_A_1505_XX | pup | 0 | 5.108139 |
| 456 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_17_XX | pup | 0 | 2.233645 |
| 480 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_15_XX | pup | 0 | 1.059308 |
| 504 | CityNet Tube Bochum CF_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_06_XX | pup | 0 | 7.471519 |
| 528 | CityNet Tube Bochum CF_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_07_XX | pup | 0 | 2.351157 |
| 586 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCB_0_000_A_1707_XX | pup | 0 | 16.933615 |
| 610 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCB_0_000_A_1505_XX | pup | 0 | 7.327171 |
| 634 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_17_XX | pup | 0 | 2.437608 |
| 658 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_15_XX | pup | 0 | 1.470852 |
| 682 | King Channel CB_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_06_XX | pup | 0 | 7.647424 |
| 706 | King Channel CB_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_07_XX | pup | 0 | 2.01529 |
| 764 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCC_0_000_A_1707_XX | pup | 0 | 0.0 |
| 788 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCC_0_000_A_1505_XX | pup | 0 | 0.0 |
| 812 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCC_0_000_A_17_XX | pup | 0 | 0.0 |
| 836 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCC_0_000_A_15_XX | pup | 0 | 0.0 |
| 860 | Mall Channel CC_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCC_0_000_A_06_XX | pup | 0 | 0.0 |
| 884 | Mall Channel CC_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCC_0_000_A_07_XX | pup | 0 | 0.0 |
| 942 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCE_1_000_A_1707_XX | pup | 0 | 4.676732 |
| 966 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCE_1_000_A_1505_XX | pup | 0 | 3.60063 |
| 990 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_17_XX | pup | 0 | 0.670971 |
| 1014 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_15_XX | pup | 0 | 0.722875 |
| 1038 | Doorshow Hotel CE_1_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_06_XX | pup | 0 | 0.4545 |
| 1062 | Doorshow Hotel CE_1_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_07_XX | pup | 0 | 0.623055 |
| 1120 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCG_0_000_A_1707_XX | pup | 0 | 5.563671 |
| 1144 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCG_0_000_A_1505_XX | pup | 0 | 3.039005 |
| 1168 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCG_0_000_A_17_XX | pup | 0 | 0.812618 |
| 1192 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCG_0_000_A_15_XX | pup | 0 | 0.618411 |
| 1216 | Mobility Channel gesamt CG_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_0_000_A_06_XX | pup | 0 | 1.859826 |
| 1240 | Mobility Channel gesamt CG_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_0_000_A_07_XX | pup | 0 | 0.701385 |
| 1298 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCG_2_000_A_1707_XX | pup | 0 | 1.541878 |
| 1322 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCG_2_000_A_1505_XX | pup | 0 | 0.858818 |
| 1346 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCG_2_000_A_17_XX | pup | 0 | 0.221564 |
| 1370 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCG_2_000_A_15_XX | pup | 0 | 0.172566 |
| 1394 | Mobility Channel Bistro CG_2_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_2_000_A_06_XX | pup | 0 | 0.493611 |
| 1418 | Mobility Channel Bistro CG_2_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_2_000_A_07_XX | pup | 0 | 0.192041 |
| 1476 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCG_3_000_A_1707_XX | pup | 0 | 2.825143 |
| 1500 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCG_3_000_A_1505_XX | pup | 0 | 1.543238 |
| 1524 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCG_3_000_A_17_XX | pup | 0 | 0.408104 |
| 1548 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCG_3_000_A_15_XX | pup | 0 | 0.311361 |
| 1572 | Mobility Channel Kasse CG_3_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_3_000_A_06_XX | pup | 0 | 0.932762 |
| 1596 | Mobility Channel Kasse CG_3_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_3_000_A_07_XX | pup | 0 | 0.358354 |
| 1654 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCG_5_000_A_1707_XX | pup | 0 | 0.503357 |
| 1678 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCG_5_000_A_1505_XX | pup | 0 | 0.265056 |
| 1702 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCG_5_000_A_17_XX | pup | 0 | 0.072065 |
| 1726 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCG_5_000_A_15_XX | pup | 0 | 0.053103 |
| 1750 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_5_000_A_06_XX | pup | 0 | 0.177461 |
| 1774 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_5_000_A_07_XX | pup | 0 | 0.061193 |
| 1832 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCG_4_000_A_1707_XX | pup | 0 | 0.787256 |
| 1856 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCG_4_000_A_1505_XX | pup | 0 | 0.41457 |
| 1880 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCG_4_000_A_17_XX | pup | 0 | 0.112849 |
| 1904 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCG_4_000_A_15_XX | pup | 0 | 0.083138 |
| 1928 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_4_000_A_06_XX | pup | 0 | 0.277721 |
| 1952 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_4_000_A_07_XX | pup | 0 | 0.095793 |
| 1982 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEQ_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2006 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEQ_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2030 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEQ_0_000_A_17_XX | pup | 0 | 0.0 |
| 2054 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEQ_0_000_A_15_XX | pup | 0 | 0.0 |
| 2078 | UniScreens Deutschland EQ_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEQ_0_000_A_06_XX | pup | 0 | 0.0 |
| 2102 | UniScreens Deutschland EQ_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEQ_0_000_A_07_XX | pup | 0 | 0.0 |
| 2132 | SK2 Apotheken Channel EY_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEY_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2156 | SK2 Apotheken Channel EY_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEY_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2180 | SK2 Apotheken Channel EY_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEY_0_000_A_17_XX | pup | 0 | 0.0 |
| 2204 | SK2 Apotheken Channel EY_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEY_0_000_A_15_XX | pup | 0 | 0.0 |
| 2228 | SK2 Apotheken Channel EY_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEY_0_000_A_06_XX | pup | 0 | 0.0 |
| 2252 | SK2 Apotheken Channel EY_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEY_0_000_A_07_XX | pup | 0 | 0.0 |
| 2282 | Echion real,- ShopKontakt EX_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEX_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2306 | Echion real,- ShopKontakt EX_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEX_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2330 | Echion real,- ShopKontakt EX_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEX_0_000_A_17_XX | pup | 0 | 0.0 |
| 2354 | Echion real,- ShopKontakt EX_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEX_0_000_A_15_XX | pup | 0 | 0.0 |
| 2378 | Echion real,- ShopKontakt EX_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEX_0_000_A_06_XX | pup | 0 | 0.0 |
| 2402 | Echion real,- ShopKontakt EX_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEX_0_000_A_07_XX | pup | 0 | 0.0 |
| 2432 | ECN EC_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEC_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2456 | ECN EC_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEC_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2480 | ECN EC_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEC_0_000_A_17_XX | pup | 0 | 0.0 |
| 2504 | ECN EC_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEC_0_000_A_15_XX | pup | 0 | 0.0 |
| 2528 | ECN EC_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEC_0_000_A_06_XX | pup | 0 | 0.0 |
| 2552 | ECN EC_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEC_0_000_A_07_XX | pup | 0 | 0.0 |
| 2582 | TV-Wartezimmer EB_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEB_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2606 | TV-Wartezimmer EB_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEB_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2630 | TV-Wartezimmer EB_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEB_0_000_A_17_XX | pup | 0 | 0.0 |
| 2654 | TV-Wartezimmer EB_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEB_0_000_A_15_XX | pup | 0 | 0.0 |
| 2678 | TV-Wartezimmer EB_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEB_0_000_A_06_XX | pup | 0 | 0.0 |
| 2702 | TV-Wartezimmer EB_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEB_0_000_A_07_XX | pup | 0 | 0.0 |
| 2732 | Retail TV Food Viewento EA_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEA_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2756 | Retail TV Food Viewento EA_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEA_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2780 | Retail TV Food Viewento EA_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEA_0_000_A_17_XX | pup | 0 | 0.0 |
| 2804 | Retail TV Food Viewento EA_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEA_0_000_A_15_XX | pup | 0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE media_variant ( id INTEGER NOT NULL, media INTEGER, weekdays INTEGER, timerange INTEGER, frequency INTEGER, study_code VARCHAR(100), source VARCHAR(3), extern BOOLEAN, raw_sample FLOAT, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(media) REFERENCES media (id), FOREIGN KEY(weekdays) REFERENCES weekday (id), FOREIGN KEY(timerange) REFERENCES time_range (id), FOREIGN KEY(frequency) REFERENCES frequency (id) ); CREATE INDEX ix_media_variant_raw_sample ON media_variant (raw_sample); CREATE INDEX ix_media_variant_weekdays ON media_variant (weekdays); CREATE INDEX ix_media_variant_extern ON media_variant (extern); CREATE INDEX ix_media_variant_timerange ON media_variant (timerange); CREATE INDEX ix_media_variant_media ON media_variant (media); CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code); CREATE INDEX ix_media_variant_source ON media_variant (source); CREATE INDEX ix_media_variant_frequency ON media_variant (frequency);