media_variant
1,542 rows where timerange = 16
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 42 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCA_0_000_A_1707_JJ | pup | 0 | 190.300862 |
| 66 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCA_0_000_A_1505_JJ | pup | 0 | 130.224435 |
| 90 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCA_0_000_A_17_JJ | pup | 0 | 28.914957 |
| 114 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCA_0_000_A_15_JJ | pup | 0 | 27.511594 |
| 138 | Goldbach gesamt CA_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCA_0_000_A_06_JJ | pup | 0 | 55.573711 |
| 162 | Goldbach gesamt CA_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCA_0_000_A_07_JJ | pup | 0 | 8.012732 |
| 220 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCH_0_000_A_1707_JJ | pup | 0 | 5.918182 |
| 244 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCH_0_000_A_1505_JJ | pup | 0 | 4.381318 |
| 268 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCH_0_000_A_17_JJ | pup | 0 | 0.874491 |
| 292 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCH_0_000_A_15_JJ | pup | 0 | 0.906406 |
| 316 | Airboards Köln CH_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCH_0_000_A_06_JJ | pup | 0 | 1.108904 |
| 340 | Airboards Köln CH_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCH_0_000_A_07_JJ | pup | 0 | 0.471984 |
| 398 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCI_0_000_A_1707_JJ | pup | 0 | 0.294929 |
| 422 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCI_0_000_A_1505_JJ | pup | 0 | 0.170518 |
| 446 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCI_0_000_A_17_JJ | pup | 0 | 0.042189 |
| 470 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCI_0_000_A_15_JJ | pup | 0 | 0.034133 |
| 494 | Airboards Paderborn CI_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCI_0_000_A_06_JJ | pup | 0 | 0.103676 |
| 518 | Airboards Paderborn CI_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCI_0_000_A_07_JJ | pup | 0 | 0.02094 |
| 576 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCF_0_000_A_1707_JJ | pup | 0 | 22.679449 |
| 600 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCF_0_000_A_1505_JJ | pup | 0 | 18.287965 |
| 624 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCF_0_000_A_17_JJ | pup | 0 | 3.764047 |
| 648 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCF_0_000_A_15_JJ | pup | 0 | 4.19995 |
| 672 | CityNet Tube Bochum CF_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCF_0_000_A_06_JJ | pup | 0 | 4.60062 |
| 696 | CityNet Tube Bochum CF_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCF_0_000_A_07_JJ | pup | 0 | 0.555472 |
| 754 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCB_0_000_A_1707_JJ | pup | 0 | 9.004936 |
| 778 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCB_0_000_A_1505_JJ | pup | 0 | 5.208702 |
| 802 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCB_0_000_A_17_JJ | pup | 0 | 1.290083 |
| 826 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCB_0_000_A_15_JJ | pup | 0 | 1.043527 |
| 850 | King Channel CB_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCB_0_000_A_06_JJ | pup | 0 | 2.580225 |
| 874 | King Channel CB_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCB_0_000_A_07_JJ | pup | 0 | 1.225526 |
| 932 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCC_0_000_A_1707_JJ | pup | 0 | 93.875172 |
| 956 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCC_0_000_A_1505_JJ | pup | 0 | 64.676001 |
| 980 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCC_0_000_A_17_JJ | pup | 0 | 13.931611 |
| 1004 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCC_0_000_A_15_JJ | pup | 0 | 13.366866 |
| 1028 | Mall Channel CC_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCC_0_000_A_06_JJ | pup | 0 | 30.261498 |
| 1052 | Mall Channel CC_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCC_0_000_A_07_JJ | pup | 0 | 0.0 |
| 1110 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCD_0_000_A_1707_JJ | pup | 0 | 3.838255 |
| 1134 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCD_0_000_A_1505_JJ | pup | 0 | 2.930743 |
| 1158 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCD_0_000_A_17_JJ | pup | 0 | 0.557248 |
| 1182 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCD_0_000_A_15_JJ | pup | 0 | 0.595422 |
| 1206 | Instore Channel CD_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCD_0_000_A_06_JJ | pup | 0 | 0.91564 |
| 1230 | Instore Channel CD_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCD_0_000_A_07_JJ | pup | 0 | 0.0 |
| 1288 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCE_1_000_A_1707_JJ | pup | 0 | 10.504696 |
| 1312 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCE_1_000_A_1505_JJ | pup | 0 | 2.301622 |
| 1336 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCE_1_000_A_17_JJ | pup | 0 | 1.552143 |
| 1360 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCE_1_000_A_15_JJ | pup | 0 | 0.460883 |
| 1384 | Doorshow Hotel CE_1_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCE_1_000_A_06_JJ | pup | 0 | 7.178283 |
| 1408 | Doorshow Hotel CE_1_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCE_1_000_A_07_JJ | pup | 0 | 1.032805 |
| 1466 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCG_0_000_A_1707_JJ | pup | 0 | 45.502125 |
| 1490 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCG_0_000_A_1505_JJ | pup | 0 | 32.827988 |
| 1514 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCG_0_000_A_17_JJ | pup | 0 | 6.933041 |
| 1538 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCG_0_000_A_15_JJ | pup | 0 | 6.928579 |
| 1562 | Mobility Channel gesamt CG_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCG_0_000_A_06_JJ | pup | 0 | 8.943558 |
| 1586 | Mobility Channel gesamt CG_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCG_0_000_A_07_JJ | pup | 0 | 4.707086 |
| 1644 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCG_2_000_A_1707_JJ | pup | 0 | 13.605888 |
| 1668 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCG_2_000_A_1505_JJ | pup | 0 | 9.682754 |
| 1692 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCG_2_000_A_17_JJ | pup | 0 | 1.977757 |
| 1716 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCG_2_000_A_15_JJ | pup | 0 | 1.963438 |
| 1740 | Mobility Channel Bistro CG_2_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCG_2_000_A_06_JJ | pup | 0 | 2.62867 |
| 1764 | Mobility Channel Bistro CG_2_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCG_2_000_A_07_JJ | pup | 0 | 1.379509 |
| 1822 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCG_3_000_A_1707_JJ | pup | 0 | 23.772473 |
| 1846 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCG_3_000_A_1505_JJ | pup | 0 | 17.281154 |
| 1870 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCG_3_000_A_17_JJ | pup | 0 | 3.51349 |
| 1894 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCG_3_000_A_15_JJ | pup | 0 | 3.558123 |
| 1918 | Mobility Channel Kasse CG_3_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCG_3_000_A_06_JJ | pup | 0 | 4.451873 |
| 1942 | Mobility Channel Kasse CG_3_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCG_3_000_A_07_JJ | pup | 0 | 2.291154 |
| 2000 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCG_5_000_A_1707_JJ | pup | 0 | 4.113973 |
| 2024 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCG_5_000_A_1505_JJ | pup | 0 | 2.896348 |
| 2048 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCG_5_000_A_17_JJ | pup | 0 | 0.591353 |
| 2072 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCG_5_000_A_15_JJ | pup | 0 | 0.582309 |
| 2096 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCG_5_000_A_06_JJ | pup | 0 | 0.782871 |
| 2120 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCG_5_000_A_07_JJ | pup | 0 | 0.443077 |
| 2178 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSCG_4_000_A_1707_JJ | pup | 0 | 6.242057 |
| 2202 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSCG_4_000_A_1505_JJ | pup | 0 | 4.395641 |
| 2226 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSCG_4_000_A_17_JJ | pup | 0 | 0.90014 |
| 2250 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCG_4_000_A_15_JJ | pup | 0 | 0.886152 |
| 2274 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSCG_4_000_A_06_JJ | pup | 0 | 1.191348 |
| 2298 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSCG_4_000_A_07_JJ | pup | 0 | 0.674259 |
| 2328 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSEQ_0_000_A_1707_JJ | pup | 0 | 72.392717 |
| 2352 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSEQ_0_000_A_1505_JJ | pup | 0 | 70.508284 |
| 2376 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSEQ_0_000_A_17_JJ | pup | 0 | 10.835472 |
| 2400 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSEQ_0_000_A_15_JJ | pup | 0 | 14.712717 |
| 2424 | UniScreens Deutschland EQ_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSEQ_0_000_A_06_JJ | pup | 0 | 2.076737 |
| 2448 | UniScreens Deutschland EQ_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSEQ_0_000_A_07_JJ | pup | 0 | 0.0 |
| 2478 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSEO_0_000_A_1707_JJ | pup | 0 | 2.141153 |
| 2502 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSEO_0_000_A_1505_JJ | pup | 0 | 1.608978 |
| 2526 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSEO_0_000_A_17_JJ | pup | 0 | 0.306756 |
| 2550 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSEO_0_000_A_15_JJ | pup | 0 | 0.322556 |
| 2574 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSEO_0_000_A_06_JJ | pup | 0 | 0.208598 |
| 2598 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSEO_0_000_A_07_JJ | pup | 0 | 0.325447 |
| 2628 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSEP_0_000_A_1707_JJ | pup | 0 | 2.141153 |
| 2652 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSEP_0_000_A_1505_JJ | pup | 0 | 1.608978 |
| 2676 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSEP_0_000_A_17_JJ | pup | 0 | 0.306756 |
| 2700 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSEP_0_000_A_15_JJ | pup | 0 | 0.322556 |
| 2724 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 09-10 Uhr 16 | 1 1 | SPPSEP_0_000_A_06_JJ | pup | 0 | 0.208598 |
| 2748 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 09-10 Uhr 16 | 1 1 | SPPSEP_0_000_A_07_JJ | pup | 0 | 0.325447 |
| 2778 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSEP_1_000_A_1707_JJ | pup | 0 | 1.567533 |
| 2802 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSEP_1_000_A_1505_JJ | pup | 0 | 1.179807 |
| 2826 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSEP_1_000_A_17_JJ | pup | 0 | 0.224414 |
| 2850 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSEP_1_000_A_15_JJ | pup | 0 | 0.236383 |
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);