media_variant
1,542 rows where timerange = 32
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 50 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCA_0_000_A_1707_RR | pup | 0 | 269.335439 |
| 74 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCA_0_000_A_1505_RR | pup | 0 | 186.387962 |
| 98 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCA_0_000_A_17_RR | pup | 0 | 40.720467 |
| 122 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCA_0_000_A_15_RR | pup | 0 | 39.077203 |
| 146 | Goldbach gesamt CA_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCA_0_000_A_06_RR | pup | 0 | 75.868587 |
| 170 | Goldbach gesamt CA_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCA_0_000_A_07_RR | pup | 0 | 12.487962 |
| 228 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCH_0_000_A_1707_RR | pup | 0 | 4.286007 |
| 252 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCH_0_000_A_1505_RR | pup | 0 | 2.537941 |
| 276 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCH_0_000_A_17_RR | pup | 0 | 0.621905 |
| 300 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCH_0_000_A_15_RR | pup | 0 | 0.514214 |
| 324 | Airboards Köln CH_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCH_0_000_A_06_RR | pup | 0 | 0.522115 |
| 348 | Airboards Köln CH_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCH_0_000_A_07_RR | pup | 0 | 1.243916 |
| 406 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCI_0_000_A_1707_RR | pup | 0 | 0.17513 |
| 430 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCI_0_000_A_1505_RR | pup | 0 | 0.059993 |
| 454 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCI_0_000_A_17_RR | pup | 0 | 0.025041 |
| 478 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCI_0_000_A_15_RR | pup | 0 | 0.012002 |
| 502 | Airboards Paderborn CI_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCI_0_000_A_06_RR | pup | 0 | 0.087618 |
| 526 | Airboards Paderborn CI_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCI_0_000_A_07_RR | pup | 0 | 0.027635 |
| 584 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCF_0_000_A_1707_RR | pup | 0 | 22.680672 |
| 608 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCF_0_000_A_1505_RR | pup | 0 | 18.731994 |
| 632 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCF_0_000_A_17_RR | pup | 0 | 3.872286 |
| 656 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCF_0_000_A_15_RR | pup | 0 | 4.378982 |
| 680 | CityNet Tube Bochum CF_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCF_0_000_A_06_RR | pup | 0 | 4.052418 |
| 704 | CityNet Tube Bochum CF_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCF_0_000_A_07_RR | pup | 0 | 0.965379 |
| 762 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCB_0_000_A_1707_RR | pup | 0 | 66.240001 |
| 786 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCB_0_000_A_1505_RR | pup | 0 | 39.808128 |
| 810 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCB_0_000_A_17_RR | pup | 0 | 9.61079 |
| 834 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCB_0_000_A_15_RR | pup | 0 | 8.028754 |
| 858 | King Channel CB_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCB_0_000_A_06_RR | pup | 0 | 22.647781 |
| 882 | King Channel CB_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCB_0_000_A_07_RR | pup | 0 | 4.204063 |
| 940 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCC_0_000_A_1707_RR | pup | 0 | 115.893283 |
| 964 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCC_0_000_A_1505_RR | pup | 0 | 81.188636 |
| 988 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCC_0_000_A_17_RR | pup | 0 | 17.288346 |
| 1012 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCC_0_000_A_15_RR | pup | 0 | 16.820795 |
| 1036 | Mall Channel CC_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCC_0_000_A_06_RR | pup | 0 | 36.401981 |
| 1060 | Mall Channel CC_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCC_0_000_A_07_RR | pup | 0 | 0.0 |
| 1118 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCD_0_000_A_1707_RR | pup | 0 | 3.72406 |
| 1142 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCD_0_000_A_1505_RR | pup | 0 | 3.63044 |
| 1166 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCD_0_000_A_17_RR | pup | 0 | 0.540473 |
| 1190 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCD_0_000_A_15_RR | pup | 0 | 0.736884 |
| 1214 | Instore Channel CD_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCD_0_000_A_06_RR | pup | 0 | 0.095193 |
| 1238 | Instore Channel CD_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCD_0_000_A_07_RR | pup | 0 | 0.0 |
| 1296 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCE_1_000_A_1707_RR | pup | 0 | 4.828475 |
| 1320 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCE_1_000_A_1505_RR | pup | 0 | 2.577556 |
| 1344 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCE_1_000_A_17_RR | pup | 0 | 0.691097 |
| 1368 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCE_1_000_A_15_RR | pup | 0 | 0.516084 |
| 1392 | Doorshow Hotel CE_1_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCE_1_000_A_06_RR | pup | 0 | 1.586116 |
| 1416 | Doorshow Hotel CE_1_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCE_1_000_A_07_RR | pup | 0 | 0.667539 |
| 1474 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCG_0_000_A_1707_RR | pup | 0 | 53.850709 |
| 1498 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCG_0_000_A_1505_RR | pup | 0 | 38.98418 |
| 1522 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCG_0_000_A_17_RR | pup | 0 | 8.123498 |
| 1546 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCG_0_000_A_15_RR | pup | 0 | 8.118449 |
| 1570 | Mobility Channel gesamt CG_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCG_0_000_A_06_RR | pup | 0 | 10.655254 |
| 1594 | Mobility Channel gesamt CG_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCG_0_000_A_07_RR | pup | 0 | 5.384517 |
| 1652 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCG_2_000_A_1707_RR | pup | 0 | 16.355498 |
| 1676 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCG_2_000_A_1505_RR | pup | 0 | 11.724227 |
| 1700 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCG_2_000_A_17_RR | pup | 0 | 2.372695 |
| 1724 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCG_2_000_A_15_RR | pup | 0 | 2.371601 |
| 1748 | Mobility Channel Bistro CG_2_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCG_2_000_A_06_RR | pup | 0 | 3.293396 |
| 1772 | Mobility Channel Bistro CG_2_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCG_2_000_A_07_RR | pup | 0 | 1.434578 |
| 1830 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCG_3_000_A_1707_RR | pup | 0 | 28.475517 |
| 1854 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCG_3_000_A_1505_RR | pup | 0 | 20.489773 |
| 1878 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCG_3_000_A_17_RR | pup | 0 | 4.193416 |
| 1902 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCG_3_000_A_15_RR | pup | 0 | 4.190165 |
| 1926 | Mobility Channel Kasse CG_3_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCG_3_000_A_06_RR | pup | 0 | 5.439163 |
| 1950 | Mobility Channel Kasse CG_3_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCG_3_000_A_07_RR | pup | 0 | 2.902076 |
| 2008 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCG_5_000_A_1707_RR | pup | 0 | 4.435767 |
| 2032 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCG_5_000_A_1505_RR | pup | 0 | 3.180645 |
| 2056 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCG_5_000_A_17_RR | pup | 0 | 0.636362 |
| 2080 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCG_5_000_A_15_RR | pup | 0 | 0.638114 |
| 2104 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCG_5_000_A_06_RR | pup | 0 | 0.822281 |
| 2128 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCG_5_000_A_07_RR | pup | 0 | 0.440268 |
| 2186 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSCG_4_000_A_1707_RR | pup | 0 | 6.735964 |
| 2210 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSCG_4_000_A_1505_RR | pup | 0 | 4.831925 |
| 2234 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSCG_4_000_A_17_RR | pup | 0 | 0.968479 |
| 2258 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCG_4_000_A_15_RR | pup | 0 | 0.970975 |
| 2282 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSCG_4_000_A_06_RR | pup | 0 | 1.251231 |
| 2306 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSCG_4_000_A_07_RR | pup | 0 | 0.669955 |
| 2336 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSEQ_0_000_A_1707_RR | pup | 0 | 22.65432 |
| 2360 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSEQ_0_000_A_1505_RR | pup | 0 | 21.868103 |
| 2384 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSEQ_0_000_A_17_RR | pup | 0 | 3.280442 |
| 2408 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSEQ_0_000_A_15_RR | pup | 0 | 4.427879 |
| 2432 | UniScreens Deutschland EQ_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSEQ_0_000_A_06_RR | pup | 0 | 0.806056 |
| 2456 | UniScreens Deutschland EQ_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSEQ_0_000_A_07_RR | pup | 0 | 0.0 |
| 2486 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSEO_0_000_A_1707_RR | pup | 0 | 2.208819 |
| 2510 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSEO_0_000_A_1505_RR | pup | 0 | 1.570431 |
| 2534 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSEO_0_000_A_17_RR | pup | 0 | 0.31662 |
| 2558 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSEO_0_000_A_15_RR | pup | 0 | 0.314892 |
| 2582 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSEO_0_000_A_06_RR | pup | 0 | 0.281239 |
| 2606 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSEO_0_000_A_07_RR | pup | 0 | 0.360187 |
| 2636 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSEP_0_000_A_1707_RR | pup | 0 | 2.208819 |
| 2660 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSEP_0_000_A_1505_RR | pup | 0 | 1.570431 |
| 2684 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSEP_0_000_A_17_RR | pup | 0 | 0.31662 |
| 2708 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSEP_0_000_A_15_RR | pup | 0 | 0.314892 |
| 2732 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 17-18 Uhr 32 | 1 1 | SPPSEP_0_000_A_06_RR | pup | 0 | 0.281239 |
| 2756 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 17-18 Uhr 32 | 1 1 | SPPSEP_0_000_A_07_RR | pup | 0 | 0.360187 |
| 2786 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSEP_1_000_A_1707_RR | pup | 0 | 1.62098 |
| 2810 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSEP_1_000_A_1505_RR | pup | 0 | 1.154216 |
| 2834 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSEP_1_000_A_17_RR | pup | 0 | 0.232163 |
| 2858 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSEP_1_000_A_15_RR | pup | 0 | 0.231293 |
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);