media_variant
1,542 rows where timerange = 28
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 48 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCA_0_000_A_1707_PP | pup | 0 | 262.247422 |
| 72 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCA_0_000_A_1505_PP | pup | 0 | 164.077362 |
| 96 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCA_0_000_A_17_PP | pup | 0 | 39.516097 |
| 120 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCA_0_000_A_15_PP | pup | 0 | 34.315742 |
| 144 | Goldbach gesamt CA_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCA_0_000_A_06_PP | pup | 0 | 85.400277 |
| 168 | Goldbach gesamt CA_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCA_0_000_A_07_PP | pup | 0 | 18.095109 |
| 226 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCH_0_000_A_1707_PP | pup | 0 | 4.605949 |
| 250 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCH_0_000_A_1505_PP | pup | 0 | 3.436714 |
| 274 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCH_0_000_A_17_PP | pup | 0 | 0.675036 |
| 298 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCH_0_000_A_15_PP | pup | 0 | 0.705114 |
| 322 | Airboards Köln CH_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCH_0_000_A_06_PP | pup | 0 | 0.674332 |
| 346 | Airboards Köln CH_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCH_0_000_A_07_PP | pup | 0 | 0.520156 |
| 404 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCI_0_000_A_1707_PP | pup | 0 | 0.308995 |
| 428 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCI_0_000_A_1505_PP | pup | 0 | 0.21999 |
| 452 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCI_0_000_A_17_PP | pup | 0 | 0.044252 |
| 476 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCI_0_000_A_15_PP | pup | 0 | 0.044112 |
| 500 | Airboards Paderborn CI_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCI_0_000_A_06_PP | pup | 0 | 0.076975 |
| 524 | Airboards Paderborn CI_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCI_0_000_A_07_PP | pup | 0 | 0.012191 |
| 582 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCF_0_000_A_1707_PP | pup | 0 | 20.614465 |
| 606 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCF_0_000_A_1505_PP | pup | 0 | 15.08025 |
| 630 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCF_0_000_A_17_PP | pup | 0 | 3.460729 |
| 654 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCF_0_000_A_15_PP | pup | 0 | 3.423329 |
| 678 | CityNet Tube Bochum CF_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCF_0_000_A_06_PP | pup | 0 | 5.441225 |
| 702 | CityNet Tube Bochum CF_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCF_0_000_A_07_PP | pup | 0 | 1.54974 |
| 760 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCB_0_000_A_1707_PP | pup | 0 | 38.98632 |
| 784 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCB_0_000_A_1505_PP | pup | 0 | 18.261868 |
| 808 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCB_0_000_A_17_PP | pup | 0 | 5.632344 |
| 832 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCB_0_000_A_15_PP | pup | 0 | 3.668325 |
| 856 | King Channel CB_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCB_0_000_A_06_PP | pup | 0 | 11.882292 |
| 880 | King Channel CB_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCB_0_000_A_07_PP | pup | 0 | 9.013379 |
| 938 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCC_0_000_A_1707_PP | pup | 0 | 145.848238 |
| 962 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCC_0_000_A_1505_PP | pup | 0 | 87.963335 |
| 986 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCC_0_000_A_17_PP | pup | 0 | 21.751694 |
| 1010 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCC_0_000_A_15_PP | pup | 0 | 18.238971 |
| 1034 | Mall Channel CC_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCC_0_000_A_06_PP | pup | 0 | 60.05889 |
| 1058 | Mall Channel CC_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCC_0_000_A_07_PP | pup | 0 | 0.0 |
| 1116 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCD_0_000_A_1707_PP | pup | 0 | 3.487895 |
| 1140 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCD_0_000_A_1505_PP | pup | 0 | 2.985794 |
| 1164 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCD_0_000_A_17_PP | pup | 0 | 0.51772 |
| 1188 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCD_0_000_A_15_PP | pup | 0 | 0.62159 |
| 1212 | Instore Channel CD_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCD_0_000_A_06_PP | pup | 0 | 0.502369 |
| 1236 | Instore Channel CD_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCD_0_000_A_07_PP | pup | 0 | 0.0 |
| 1294 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCE_1_000_A_1707_PP | pup | 0 | 3.087346 |
| 1318 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCE_1_000_A_1505_PP | pup | 0 | 1.693023 |
| 1342 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCE_1_000_A_17_PP | pup | 0 | 0.442165 |
| 1366 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCE_1_000_A_15_PP | pup | 0 | 0.339158 |
| 1390 | Doorshow Hotel CE_1_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCE_1_000_A_06_PP | pup | 0 | 0.788494 |
| 1414 | Doorshow Hotel CE_1_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCE_1_000_A_07_PP | pup | 0 | 0.607672 |
| 1472 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCG_0_000_A_1707_PP | pup | 0 | 47.242361 |
| 1496 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCG_0_000_A_1505_PP | pup | 0 | 35.214867 |
| 1520 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCG_0_000_A_17_PP | pup | 0 | 7.035229 |
| 1544 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCG_0_000_A_15_PP | pup | 0 | 7.3088 |
| 1568 | Mobility Channel gesamt CG_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCG_0_000_A_06_PP | pup | 0 | 6.147666 |
| 1592 | Mobility Channel gesamt CG_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCG_0_000_A_07_PP | pup | 0 | 6.39743 |
| 1650 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCG_2_000_A_1707_PP | pup | 0 | 14.326048 |
| 1674 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCG_2_000_A_1505_PP | pup | 0 | 10.876507 |
| 1698 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCG_2_000_A_17_PP | pup | 0 | 2.074307 |
| 1722 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCG_2_000_A_15_PP | pup | 0 | 2.203117 |
| 1746 | Mobility Channel Bistro CG_2_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCG_2_000_A_06_PP | pup | 0 | 1.760438 |
| 1770 | Mobility Channel Bistro CG_2_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCG_2_000_A_07_PP | pup | 0 | 1.729361 |
| 1828 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCG_3_000_A_1707_PP | pup | 0 | 24.522682 |
| 1852 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCG_3_000_A_1505_PP | pup | 0 | 18.142472 |
| 1876 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCG_3_000_A_17_PP | pup | 0 | 3.577754 |
| 1900 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCG_3_000_A_15_PP | pup | 0 | 3.696886 |
| 1924 | Mobility Channel Kasse CG_3_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCG_3_000_A_06_PP | pup | 0 | 3.218175 |
| 1948 | Mobility Channel Kasse CG_3_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCG_3_000_A_07_PP | pup | 0 | 3.3009 |
| 2006 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCG_5_000_A_1707_PP | pup | 0 | 3.913039 |
| 2030 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCG_5_000_A_1505_PP | pup | 0 | 2.871386 |
| 2054 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCG_5_000_A_17_PP | pup | 0 | 0.560953 |
| 2078 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCG_5_000_A_15_PP | pup | 0 | 0.575999 |
| 2102 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCG_5_000_A_06_PP | pup | 0 | 0.479821 |
| 2126 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCG_5_000_A_07_PP | pup | 0 | 0.565883 |
| 2184 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSCG_4_000_A_1707_PP | pup | 0 | 5.944843 |
| 2208 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSCG_4_000_A_1505_PP | pup | 0 | 4.362783 |
| 2232 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSCG_4_000_A_17_PP | pup | 0 | 0.853768 |
| 2256 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCG_4_000_A_15_PP | pup | 0 | 0.876539 |
| 2280 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSCG_4_000_A_06_PP | pup | 0 | 0.730171 |
| 2304 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSCG_4_000_A_07_PP | pup | 0 | 0.861124 |
| 2334 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSEQ_0_000_A_1707_PP | pup | 0 | 43.173394 |
| 2358 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSEQ_0_000_A_1505_PP | pup | 0 | 41.857441 |
| 2382 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSEQ_0_000_A_17_PP | pup | 0 | 6.325143 |
| 2406 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSEQ_0_000_A_15_PP | pup | 0 | 8.567613 |
| 2430 | UniScreens Deutschland EQ_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSEQ_0_000_A_06_PP | pup | 0 | 1.372787 |
| 2454 | UniScreens Deutschland EQ_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSEQ_0_000_A_07_PP | pup | 0 | 0.0 |
| 2484 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSEO_0_000_A_1707_PP | pup | 0 | 2.347179 |
| 2508 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSEO_0_000_A_1505_PP | pup | 0 | 1.435826 |
| 2532 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSEO_0_000_A_17_PP | pup | 0 | 0.33657 |
| 2556 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSEO_0_000_A_15_PP | pup | 0 | 0.287848 |
| 2580 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSEO_0_000_A_06_PP | pup | 0 | 0.309213 |
| 2604 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSEO_0_000_A_07_PP | pup | 0 | 0.606174 |
| 2634 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSEP_0_000_A_1707_PP | pup | 0 | 2.347179 |
| 2658 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSEP_0_000_A_1505_PP | pup | 0 | 1.435826 |
| 2682 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSEP_0_000_A_17_PP | pup | 0 | 0.33657 |
| 2706 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSEP_0_000_A_15_PP | pup | 0 | 0.287848 |
| 2730 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 15-16 Uhr 28 | 1 1 | SPPSEP_0_000_A_06_PP | pup | 0 | 0.309213 |
| 2754 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 15-16 Uhr 28 | 1 1 | SPPSEP_0_000_A_07_PP | pup | 0 | 0.606174 |
| 2784 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSEP_1_000_A_1707_PP | pup | 0 | 1.715672 |
| 2808 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSEP_1_000_A_1505_PP | pup | 0 | 1.050841 |
| 2832 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSEP_1_000_A_17_PP | pup | 0 | 0.245788 |
| 2856 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSEP_1_000_A_15_PP | pup | 0 | 0.210544 |
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);