media_variant
1,542 rows where timerange = 37
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 53 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCA_0_000_A_1707_UU | pup | 0 | 140.763641 |
| 77 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCA_0_000_A_1505_UU | pup | 0 | 92.916707 |
| 101 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCA_0_000_A_17_UU | pup | 0 | 20.956756 |
| 125 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCA_0_000_A_15_UU | pup | 0 | 19.268917 |
| 149 | Goldbach gesamt CA_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCA_0_000_A_06_UU | pup | 0 | 38.57718 |
| 173 | Goldbach gesamt CA_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCA_0_000_A_07_UU | pup | 0 | 11.158231 |
| 231 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCH_0_000_A_1707_UU | pup | 0 | 4.482456 |
| 255 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCH_0_000_A_1505_UU | pup | 0 | 2.963947 |
| 279 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCH_0_000_A_17_UU | pup | 0 | 0.650053 |
| 303 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCH_0_000_A_15_UU | pup | 0 | 0.600005 |
| 327 | Airboards Köln CH_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCH_0_000_A_06_UU | pup | 0 | 0.815871 |
| 351 | Airboards Köln CH_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCH_0_000_A_07_UU | pup | 0 | 0.729875 |
| 409 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCI_0_000_A_1707_UU | pup | 0 | 0.15995 |
| 433 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCI_0_000_A_1505_UU | pup | 0 | 0.062901 |
| 457 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCI_0_000_A_17_UU | pup | 0 | 0.022866 |
| 481 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCI_0_000_A_15_UU | pup | 0 | 0.012583 |
| 505 | Airboards Paderborn CI_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCI_0_000_A_06_UU | pup | 0 | 0.070477 |
| 529 | Airboards Paderborn CI_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCI_0_000_A_07_UU | pup | 0 | 0.026658 |
| 587 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCF_0_000_A_1707_UU | pup | 0 | 10.552954 |
| 611 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCF_0_000_A_1505_UU | pup | 0 | 6.108154 |
| 635 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCF_0_000_A_17_UU | pup | 0 | 1.607008 |
| 659 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCF_0_000_A_15_UU | pup | 0 | 1.270659 |
| 683 | CityNet Tube Bochum CF_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCF_0_000_A_06_UU | pup | 0 | 3.282646 |
| 707 | CityNet Tube Bochum CF_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCF_0_000_A_07_UU | pup | 0 | 1.570971 |
| 765 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCB_0_000_A_1707_UU | pup | 0 | 31.929238 |
| 789 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCB_0_000_A_1505_UU | pup | 0 | 16.416576 |
| 813 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCB_0_000_A_17_UU | pup | 0 | 4.599726 |
| 837 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCB_0_000_A_15_UU | pup | 0 | 3.299779 |
| 861 | King Channel CB_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCB_0_000_A_06_UU | pup | 0 | 11.738027 |
| 885 | King Channel CB_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCB_0_000_A_07_UU | pup | 0 | 3.92382 |
| 943 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCC_0_000_A_1707_UU | pup | 0 | 63.425175 |
| 967 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCC_0_000_A_1505_UU | pup | 0 | 47.456119 |
| 991 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCC_0_000_A_17_UU | pup | 0 | 9.522335 |
| 1015 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCC_0_000_A_15_UU | pup | 0 | 9.943758 |
| 1039 | Mall Channel CC_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCC_0_000_A_06_UU | pup | 0 | 16.627122 |
| 1063 | Mall Channel CC_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCC_0_000_A_07_UU | pup | 0 | 0.0 |
| 1121 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCD_0_000_A_1707_UU | pup | 0 | 0.308251 |
| 1145 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCD_0_000_A_1505_UU | pup | 0 | 0.304921 |
| 1169 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCD_0_000_A_17_UU | pup | 0 | 0.044119 |
| 1193 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCD_0_000_A_15_UU | pup | 0 | 0.061093 |
| 1217 | Instore Channel CD_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCD_0_000_A_06_UU | pup | 0 | 0.003338 |
| 1241 | Instore Channel CD_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCD_0_000_A_07_UU | pup | 0 | 0.0 |
| 1299 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCE_1_000_A_1707_UU | pup | 0 | 6.989234 |
| 1323 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCE_1_000_A_1505_UU | pup | 0 | 4.050679 |
| 1347 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCE_1_000_A_17_UU | pup | 0 | 1.016242 |
| 1371 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCE_1_000_A_15_UU | pup | 0 | 0.825185 |
| 1395 | Doorshow Hotel CE_1_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCE_1_000_A_06_UU | pup | 0 | 2.185868 |
| 1419 | Doorshow Hotel CE_1_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCE_1_000_A_07_UU | pup | 0 | 0.757159 |
| 1477 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCG_0_000_A_1707_UU | pup | 0 | 23.519109 |
| 1501 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCG_0_000_A_1505_UU | pup | 0 | 15.7889 |
| 1525 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCG_0_000_A_17_UU | pup | 0 | 3.507396 |
| 1549 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCG_0_000_A_15_UU | pup | 0 | 3.265657 |
| 1573 | Mobility Channel gesamt CG_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCG_0_000_A_06_UU | pup | 0 | 3.905188 |
| 1597 | Mobility Channel gesamt CG_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCG_0_000_A_07_UU | pup | 0 | 4.15195 |
| 1655 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCG_2_000_A_1707_UU | pup | 0 | 7.264942 |
| 1679 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCG_2_000_A_1505_UU | pup | 0 | 4.502989 |
| 1703 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCG_2_000_A_17_UU | pup | 0 | 1.051766 |
| 1727 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCG_2_000_A_15_UU | pup | 0 | 0.909371 |
| 1751 | Mobility Channel Bistro CG_2_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCG_2_000_A_06_UU | pup | 0 | 1.058083 |
| 1775 | Mobility Channel Bistro CG_2_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCG_2_000_A_07_UU | pup | 0 | 1.731287 |
| 1833 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCG_3_000_A_1707_UU | pup | 0 | 12.39195 |
| 1857 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCG_3_000_A_1505_UU | pup | 0 | 8.504254 |
| 1881 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCG_3_000_A_17_UU | pup | 0 | 1.810919 |
| 1905 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCG_3_000_A_15_UU | pup | 0 | 1.732059 |
| 1929 | Mobility Channel Kasse CG_3_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCG_3_000_A_06_UU | pup | 0 | 1.973406 |
| 1953 | Mobility Channel Kasse CG_3_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCG_3_000_A_07_UU | pup | 0 | 2.00315 |
| 2011 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCG_5_000_A_1707_UU | pup | 0 | 1.827763 |
| 2035 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCG_5_000_A_1505_UU | pup | 0 | 1.268879 |
| 2059 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCG_5_000_A_17_UU | pup | 0 | 0.261972 |
| 2083 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCG_5_000_A_15_UU | pup | 0 | 0.254405 |
| 2107 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCG_5_000_A_06_UU | pup | 0 | 0.364317 |
| 2131 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCG_5_000_A_07_UU | pup | 0 | 0.196885 |
| 2189 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSCG_4_000_A_1707_UU | pup | 0 | 2.777342 |
| 2213 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSCG_4_000_A_1505_UU | pup | 0 | 1.92867 |
| 2237 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSCG_4_000_A_17_UU | pup | 0 | 0.398759 |
| 2261 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCG_4_000_A_15_UU | pup | 0 | 0.387189 |
| 2285 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSCG_4_000_A_06_UU | pup | 0 | 0.554367 |
| 2309 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSCG_4_000_A_07_UU | pup | 0 | 0.299615 |
| 2339 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSEQ_0_000_A_1707_UU | pup | 0 | 4.669469 |
| 2363 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSEQ_0_000_A_1505_UU | pup | 0 | 4.477802 |
| 2387 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSEQ_0_000_A_17_UU | pup | 0 | 0.669703 |
| 2411 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSEQ_0_000_A_15_UU | pup | 0 | 0.898857 |
| 2435 | UniScreens Deutschland EQ_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSEQ_0_000_A_06_UU | pup | 0 | 0.192533 |
| 2459 | UniScreens Deutschland EQ_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSEQ_0_000_A_07_UU | pup | 0 | 0.0 |
| 2489 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSEO_0_000_A_1707_UU | pup | 0 | 1.765086 |
| 2513 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSEO_0_000_A_1505_UU | pup | 0 | 1.240664 |
| 2537 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSEO_0_000_A_17_UU | pup | 0 | 0.253497 |
| 2561 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSEO_0_000_A_15_UU | pup | 0 | 0.249311 |
| 2585 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSEO_0_000_A_06_UU | pup | 0 | 0.211549 |
| 2609 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSEO_0_000_A_07_UU | pup | 0 | 0.315977 |
| 2639 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSEP_0_000_A_1707_UU | pup | 0 | 1.765086 |
| 2663 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSEP_0_000_A_1505_UU | pup | 0 | 1.240664 |
| 2687 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSEP_0_000_A_17_UU | pup | 0 | 0.253497 |
| 2711 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSEP_0_000_A_15_UU | pup | 0 | 0.249311 |
| 2735 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 20-21 Uhr 37 | 1 1 | SPPSEP_0_000_A_06_UU | pup | 0 | 0.211549 |
| 2759 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 20-21 Uhr 37 | 1 1 | SPPSEP_0_000_A_07_UU | pup | 0 | 0.315977 |
| 2789 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSEP_1_000_A_1707_UU | pup | 0 | 1.284698 |
| 2813 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSEP_1_000_A_1505_UU | pup | 0 | 0.903882 |
| 2837 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSEP_1_000_A_17_UU | pup | 0 | 0.184235 |
| 2861 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSEP_1_000_A_15_UU | pup | 0 | 0.18139 |
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);