media_variant
1,542 rows where timerange = 21
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 44 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCA_0_000_A_1707_LL | pup | 0 | 180.183051 |
| 68 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCA_0_000_A_1505_LL | pup | 0 | 117.334239 |
| 92 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCA_0_000_A_17_LL | pup | 0 | 26.784928 |
| 116 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCA_0_000_A_15_LL | pup | 0 | 24.336015 |
| 140 | Goldbach gesamt CA_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCA_0_000_A_06_LL | pup | 0 | 57.038738 |
| 164 | Goldbach gesamt CA_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCA_0_000_A_07_LL | pup | 0 | 7.958408 |
| 222 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCH_0_000_A_1707_LL | pup | 0 | 4.504612 |
| 246 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCH_0_000_A_1505_LL | pup | 0 | 3.3849 |
| 270 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCH_0_000_A_17_LL | pup | 0 | 0.66105 |
| 294 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCH_0_000_A_15_LL | pup | 0 | 0.696288 |
| 318 | Airboards Köln CH_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCH_0_000_A_06_LL | pup | 0 | 0.741673 |
| 342 | Airboards Köln CH_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCH_0_000_A_07_LL | pup | 0 | 0.397662 |
| 400 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCI_0_000_A_1707_LL | pup | 0 | 0.209618 |
| 424 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCI_0_000_A_1505_LL | pup | 0 | 0.089696 |
| 448 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCI_0_000_A_17_LL | pup | 0 | 0.029968 |
| 472 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCI_0_000_A_15_LL | pup | 0 | 0.017947 |
| 496 | Airboards Paderborn CI_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCI_0_000_A_06_LL | pup | 0 | 0.110618 |
| 520 | Airboards Paderborn CI_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCI_0_000_A_07_LL | pup | 0 | 0.009395 |
| 578 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCF_0_000_A_1707_LL | pup | 0 | 16.173503 |
| 602 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCF_0_000_A_1505_LL | pup | 0 | 11.574208 |
| 626 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCF_0_000_A_17_LL | pup | 0 | 2.600624 |
| 650 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCF_0_000_A_15_LL | pup | 0 | 2.592225 |
| 674 | CityNet Tube Bochum CF_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCF_0_000_A_06_LL | pup | 0 | 4.331772 |
| 698 | CityNet Tube Bochum CF_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCF_0_000_A_07_LL | pup | 0 | 0.763866 |
| 756 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCB_0_000_A_1707_LL | pup | 0 | 20.797476 |
| 780 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCB_0_000_A_1505_LL | pup | 0 | 15.167873 |
| 804 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCB_0_000_A_17_LL | pup | 0 | 3.002718 |
| 828 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCB_0_000_A_15_LL | pup | 0 | 3.067528 |
| 852 | King Channel CB_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCB_0_000_A_06_LL | pup | 0 | 3.815787 |
| 876 | King Channel CB_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCB_0_000_A_07_LL | pup | 0 | 1.853122 |
| 934 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCC_0_000_A_1707_LL | pup | 0 | 106.077815 |
| 958 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCC_0_000_A_1505_LL | pup | 0 | 66.881112 |
| 982 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCC_0_000_A_17_LL | pup | 0 | 15.64463 |
| 1006 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCC_0_000_A_15_LL | pup | 0 | 13.764839 |
| 1030 | Mall Channel CC_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCC_0_000_A_06_LL | pup | 0 | 40.16071 |
| 1054 | Mall Channel CC_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCC_0_000_A_07_LL | pup | 0 | 0.0 |
| 1112 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCD_0_000_A_1707_LL | pup | 0 | 1.928925 |
| 1136 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCD_0_000_A_1505_LL | pup | 0 | 0.551254 |
| 1160 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCD_0_000_A_17_LL | pup | 0 | 0.27738 |
| 1184 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCD_0_000_A_15_LL | pup | 0 | 0.110533 |
| 1208 | Instore Channel CD_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCD_0_000_A_06_LL | pup | 0 | 1.379966 |
| 1232 | Instore Channel CD_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCD_0_000_A_07_LL | pup | 0 | 0.0 |
| 1290 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCE_1_000_A_1707_LL | pup | 0 | 4.195884 |
| 1314 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCE_1_000_A_1505_LL | pup | 0 | 1.888519 |
| 1338 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCE_1_000_A_17_LL | pup | 0 | 0.601068 |
| 1362 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCE_1_000_A_15_LL | pup | 0 | 0.378197 |
| 1386 | Doorshow Hotel CE_1_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCE_1_000_A_06_LL | pup | 0 | 1.143213 |
| 1410 | Doorshow Hotel CE_1_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCE_1_000_A_07_LL | pup | 0 | 1.166667 |
| 1468 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCG_0_000_A_1707_LL | pup | 0 | 27.106917 |
| 1492 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCG_0_000_A_1505_LL | pup | 0 | 18.116032 |
| 1516 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCG_0_000_A_17_LL | pup | 0 | 3.984638 |
| 1540 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCG_0_000_A_15_LL | pup | 0 | 3.721406 |
| 1564 | Mobility Channel gesamt CG_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCG_0_000_A_06_LL | pup | 0 | 5.424906 |
| 1588 | Mobility Channel gesamt CG_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCG_0_000_A_07_LL | pup | 0 | 3.769471 |
| 1646 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCG_2_000_A_1707_LL | pup | 0 | 7.636652 |
| 1670 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCG_2_000_A_1505_LL | pup | 0 | 5.183625 |
| 1694 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCG_2_000_A_17_LL | pup | 0 | 1.099316 |
| 1718 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCG_2_000_A_15_LL | pup | 0 | 1.044222 |
| 1742 | Mobility Channel Bistro CG_2_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCG_2_000_A_06_LL | pup | 0 | 1.482294 |
| 1766 | Mobility Channel Bistro CG_2_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCG_2_000_A_07_LL | pup | 0 | 0.985587 |
| 1824 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCG_3_000_A_1707_LL | pup | 0 | 14.315682 |
| 1848 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCG_3_000_A_1505_LL | pup | 0 | 9.464609 |
| 1872 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCG_3_000_A_17_LL | pup | 0 | 2.076585 |
| 1896 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCG_3_000_A_15_LL | pup | 0 | 1.919953 |
| 1920 | Mobility Channel Kasse CG_3_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCG_3_000_A_06_LL | pup | 0 | 2.892936 |
| 1944 | Mobility Channel Kasse CG_3_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCG_3_000_A_07_LL | pup | 0 | 2.016702 |
| 2002 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCG_5_000_A_1707_LL | pup | 0 | 2.272861 |
| 2026 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCG_5_000_A_1505_LL | pup | 0 | 1.52963 |
| 2050 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCG_5_000_A_17_LL | pup | 0 | 0.325493 |
| 2074 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCG_5_000_A_15_LL | pup | 0 | 0.306645 |
| 2098 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCG_5_000_A_06_LL | pup | 0 | 0.429843 |
| 2122 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCG_5_000_A_07_LL | pup | 0 | 0.314797 |
| 2180 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSCG_4_000_A_1707_LL | pup | 0 | 3.455067 |
| 2204 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSCG_4_000_A_1505_LL | pup | 0 | 2.325094 |
| 2228 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSCG_4_000_A_17_LL | pup | 0 | 0.495429 |
| 2252 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCG_4_000_A_15_LL | pup | 0 | 0.466683 |
| 2276 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSCG_4_000_A_06_LL | pup | 0 | 0.654094 |
| 2300 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSCG_4_000_A_07_LL | pup | 0 | 0.479032 |
| 2330 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSEQ_0_000_A_1707_LL | pup | 0 | 57.98361 |
| 2354 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSEQ_0_000_A_1505_LL | pup | 0 | 55.669123 |
| 2378 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSEQ_0_000_A_17_LL | pup | 0 | 8.567343 |
| 2402 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSEQ_0_000_A_15_LL | pup | 0 | 11.473252 |
| 2426 | UniScreens Deutschland EQ_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSEQ_0_000_A_06_LL | pup | 0 | 2.497873 |
| 2450 | UniScreens Deutschland EQ_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSEQ_0_000_A_07_LL | pup | 0 | 0.0 |
| 2480 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSEO_0_000_A_1707_LL | pup | 0 | 2.266656 |
| 2504 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSEO_0_000_A_1505_LL | pup | 0 | 1.717134 |
| 2528 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSEO_0_000_A_17_LL | pup | 0 | 0.325101 |
| 2552 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSEO_0_000_A_15_LL | pup | 0 | 0.344564 |
| 2576 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSEO_0_000_A_06_LL | pup | 0 | 0.269319 |
| 2600 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSEO_0_000_A_07_LL | pup | 0 | 0.282925 |
| 2630 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSEP_0_000_A_1707_LL | pup | 0 | 2.266656 |
| 2654 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSEP_0_000_A_1505_LL | pup | 0 | 1.717134 |
| 2678 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSEP_0_000_A_17_LL | pup | 0 | 0.325101 |
| 2702 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSEP_0_000_A_15_LL | pup | 0 | 0.344564 |
| 2726 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 11-12 Uhr 21 | 1 1 | SPPSEP_0_000_A_06_LL | pup | 0 | 0.269319 |
| 2750 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 11-12 Uhr 21 | 1 1 | SPPSEP_0_000_A_07_LL | pup | 0 | 0.282925 |
| 2780 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSEP_1_000_A_1707_LL | pup | 0 | 1.643372 |
| 2804 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSEP_1_000_A_1505_LL | pup | 0 | 1.252324 |
| 2828 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSEP_1_000_A_17_LL | pup | 0 | 0.235464 |
| 2852 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSEP_1_000_A_15_LL | pup | 0 | 0.251088 |
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);