media_variant
1,542 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 |
|---|---|---|---|---|---|---|---|---|
| 56 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCA_0_000_A_1707_XX | pup | 0 | 33.327767 |
| 80 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCA_0_000_A_1505_XX | pup | 0 | 17.935849 |
| 104 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCA_0_000_A_17_XX | pup | 0 | 4.863853 |
| 128 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCA_0_000_A_15_XX | pup | 0 | 3.649339 |
| 152 | Goldbach gesamt CA_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCA_0_000_A_06_XX | pup | 0 | 11.859385 |
| 176 | Goldbach gesamt CA_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCA_0_000_A_07_XX | pup | 0 | 3.882215 |
| 234 | 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 | 2.508349 |
| 258 | 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 | 1.58815 |
| 282 | 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.361774 |
| 306 | 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.32076 |
| 330 | Airboards Köln CH_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_06_XX | pup | 0 | 0.580473 |
| 354 | Airboards Köln CH_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_07_XX | pup | 0 | 0.346328 |
| 412 | 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.112319 |
| 436 | 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.051191 |
| 460 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_17_XX | pup | 0 | 0.016054 |
| 484 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_15_XX | pup | 0 | 0.01024 |
| 508 | Airboards Paderborn CI_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_06_XX | pup | 0 | 0.053333 |
| 532 | Airboards Paderborn CI_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_07_XX | pup | 0 | 0.007831 |
| 590 | 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 | 9.57264 |
| 614 | 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.890971 |
| 638 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_17_XX | pup | 0 | 1.451631 |
| 662 | 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.229613 |
| 686 | CityNet Tube Bochum CF_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_06_XX | pup | 0 | 3.159467 |
| 710 | CityNet Tube Bochum CF_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_07_XX | pup | 0 | 0.817285 |
| 768 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCB_0_000_A_1707_XX | pup | 0 | 14.400602 |
| 792 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCB_0_000_A_1505_XX | pup | 0 | 6.503877 |
| 816 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_17_XX | pup | 0 | 2.064013 |
| 840 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_15_XX | pup | 0 | 1.303169 |
| 864 | King Channel CB_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_06_XX | pup | 0 | 6.321023 |
| 888 | King Channel CB_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_07_XX | pup | 0 | 1.599468 |
| 946 | 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 |
| 970 | 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 |
| 994 | 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 |
| 1018 | 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 |
| 1042 | Mall Channel CC_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCC_0_000_A_06_XX | pup | 0 | 0.0 |
| 1066 | Mall Channel CC_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCC_0_000_A_07_XX | pup | 0 | 0.0 |
| 1124 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCD_0_000_A_1707_XX | pup | 0 | 0.0 |
| 1148 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCD_0_000_A_1505_XX | pup | 0 | 0.0 |
| 1172 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCD_0_000_A_17_XX | pup | 0 | 0.0 |
| 1196 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCD_0_000_A_15_XX | pup | 0 | 0.0 |
| 1220 | Instore Channel CD_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCD_0_000_A_06_XX | pup | 0 | 0.0 |
| 1244 | Instore Channel CD_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCD_0_000_A_07_XX | pup | 0 | 0.0 |
| 1302 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSCE_1_000_A_1707_XX | pup | 0 | 3.318204 |
| 1326 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSCE_1_000_A_1505_XX | pup | 0 | 1.536276 |
| 1350 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_17_XX | pup | 0 | 0.47524 |
| 1374 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_15_XX | pup | 0 | 0.307714 |
| 1398 | Doorshow Hotel CE_1_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_06_XX | pup | 0 | 0.999623 |
| 1422 | Doorshow Hotel CE_1_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCE_1_000_A_07_XX | pup | 0 | 0.784848 |
| 1480 | 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 | 3.446603 |
| 1504 | 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 | 2.37425 |
| 1528 | 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.495793 |
| 1552 | 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.478221 |
| 1576 | Mobility Channel gesamt CG_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_0_000_A_06_XX | pup | 0 | 0.748994 |
| 1600 | Mobility Channel gesamt CG_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_0_000_A_07_XX | pup | 0 | 0.326918 |
| 1658 | 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.000377 |
| 1682 | 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.707766 |
| 1706 | 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.143219 |
| 1730 | 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.141874 |
| 1754 | Mobility Channel Bistro CG_2_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_2_000_A_06_XX | pup | 0 | 0.2003 |
| 1778 | Mobility Channel Bistro CG_2_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_2_000_A_07_XX | pup | 0 | 0.092574 |
| 1836 | 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 | 1.742827 |
| 1860 | 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.201159 |
| 1884 | 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.249846 |
| 1908 | 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.241092 |
| 1932 | Mobility Channel Kasse CG_3_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_3_000_A_06_XX | pup | 0 | 0.373541 |
| 1956 | Mobility Channel Kasse CG_3_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_3_000_A_07_XX | pup | 0 | 0.169014 |
| 2014 | 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.286081 |
| 2038 | 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.189889 |
| 2062 | 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.040892 |
| 2086 | 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.037999 |
| 2110 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_5_000_A_06_XX | pup | 0 | 0.070026 |
| 2134 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_5_000_A_07_XX | pup | 0 | 0.026204 |
| 2192 | 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.435059 |
| 2216 | 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.288708 |
| 2240 | 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.062205 |
| 2264 | 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.057791 |
| 2288 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSCG_4_000_A_06_XX | pup | 0 | 0.106566 |
| 2312 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSCG_4_000_A_07_XX | pup | 0 | 0.039869 |
| 2342 | 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 |
| 2366 | 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 |
| 2390 | 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 |
| 2414 | 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 |
| 2438 | UniScreens Deutschland EQ_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEQ_0_000_A_06_XX | pup | 0 | 0.0 |
| 2462 | UniScreens Deutschland EQ_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEQ_0_000_A_07_XX | pup | 0 | 0.0 |
| 2492 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEO_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2516 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEO_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2540 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEO_0_000_A_17_XX | pup | 0 | 0.0 |
| 2564 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEO_0_000_A_15_XX | pup | 0 | 0.0 |
| 2588 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEO_0_000_A_06_XX | pup | 0 | 0.0 |
| 2612 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEO_0_000_A_07_XX | pup | 0 | 0.0 |
| 2642 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEP_0_000_A_1707_XX | pup | 0 | 0.0 |
| 2666 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEP_0_000_A_1505_XX | pup | 0 | 0.0 |
| 2690 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEP_0_000_A_17_XX | pup | 0 | 0.0 |
| 2714 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEP_0_000_A_15_XX | pup | 0 | 0.0 |
| 2738 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 23-24 Uhr 43 | 1 1 | SPPSEP_0_000_A_06_XX | pup | 0 | 0.0 |
| 2762 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 23-24 Uhr 43 | 1 1 | SPPSEP_0_000_A_07_XX | pup | 0 | 0.0 |
| 2792 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSEP_1_000_A_1707_XX | pup | 0 | 0.0 |
| 2816 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSEP_1_000_A_1505_XX | pup | 0 | 0.0 |
| 2840 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSEP_1_000_A_17_XX | pup | 0 | 0.0 |
| 2864 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSEP_1_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 UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code); CREATE INDEX ix_media_variant_weekdays ON media_variant (weekdays); CREATE INDEX ix_media_variant_frequency ON media_variant (frequency); CREATE INDEX ix_media_variant_source ON media_variant (source); CREATE INDEX ix_media_variant_extern ON media_variant (extern); CREATE INDEX ix_media_variant_media ON media_variant (media); CREATE INDEX ix_media_variant_timerange ON media_variant (timerange);