media_variant
1,542 rows where timerange = 41
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 55 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCA_0_000_A_1707_WW | pup | 0 | 51.363833 |
| 79 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCA_0_000_A_1505_WW | pup | 0 | 25.304657 |
| 103 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCA_0_000_A_17_WW | pup | 0 | 7.515078 |
| 127 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCA_0_000_A_15_WW | pup | 0 | 5.141805 |
| 151 | Goldbach gesamt CA_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCA_0_000_A_06_WW | pup | 0 | 17.83212 |
| 175 | Goldbach gesamt CA_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCA_0_000_A_07_WW | pup | 0 | 8.811621 |
| 233 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCH_0_000_A_1707_WW | pup | 0 | 3.37239 |
| 257 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCH_0_000_A_1505_WW | pup | 0 | 2.428867 |
| 281 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCH_0_000_A_17_WW | pup | 0 | 0.487684 |
| 305 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCH_0_000_A_15_WW | pup | 0 | 0.491412 |
| 329 | Airboards Köln CH_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCH_0_000_A_06_WW | pup | 0 | 0.517884 |
| 353 | Airboards Köln CH_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCH_0_000_A_07_WW | pup | 0 | 0.436735 |
| 411 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCI_0_000_A_1707_WW | pup | 0 | 0.166649 |
| 435 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCI_0_000_A_1505_WW | pup | 0 | 0.06617 |
| 459 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCI_0_000_A_17_WW | pup | 0 | 0.023823 |
| 483 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCI_0_000_A_15_WW | pup | 0 | 0.013237 |
| 507 | Airboards Paderborn CI_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCI_0_000_A_06_WW | pup | 0 | 0.074679 |
| 531 | Airboards Paderborn CI_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCI_0_000_A_07_WW | pup | 0 | 0.025882 |
| 589 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCF_0_000_A_1707_WW | pup | 0 | 7.826505 |
| 613 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCF_0_000_A_1505_WW | pup | 0 | 3.434555 |
| 637 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCF_0_000_A_17_WW | pup | 0 | 1.182817 |
| 661 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCF_0_000_A_15_WW | pup | 0 | 0.702013 |
| 685 | CityNet Tube Bochum CF_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCF_0_000_A_06_WW | pup | 0 | 3.462971 |
| 709 | CityNet Tube Bochum CF_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCF_0_000_A_07_WW | pup | 0 | 1.229487 |
| 767 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCB_0_000_A_1707_WW | pup | 0 | 25.423868 |
| 791 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCB_0_000_A_1505_WW | pup | 0 | 12.654065 |
| 815 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCB_0_000_A_17_WW | pup | 0 | 3.673755 |
| 839 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCB_0_000_A_15_WW | pup | 0 | 2.561141 |
| 863 | King Channel CB_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCB_0_000_A_06_WW | pup | 0 | 10.44657 |
| 887 | King Channel CB_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCB_0_000_A_07_WW | pup | 0 | 2.403096 |
| 945 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCC_0_000_A_1707_WW | pup | 0 | 0.0 |
| 969 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCC_0_000_A_1505_WW | pup | 0 | 0.0 |
| 993 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCC_0_000_A_17_WW | pup | 0 | 0.0 |
| 1017 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCC_0_000_A_15_WW | pup | 0 | 0.0 |
| 1041 | Mall Channel CC_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCC_0_000_A_06_WW | pup | 0 | 0.0 |
| 1065 | Mall Channel CC_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCC_0_000_A_07_WW | pup | 0 | 0.0 |
| 1123 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCD_0_000_A_1707_WW | pup | 0 | 0.0 |
| 1147 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCD_0_000_A_1505_WW | pup | 0 | 0.0 |
| 1171 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCD_0_000_A_17_WW | pup | 0 | 0.0 |
| 1195 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCD_0_000_A_15_WW | pup | 0 | 0.0 |
| 1219 | Instore Channel CD_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCD_0_000_A_06_WW | pup | 0 | 0.0 |
| 1243 | Instore Channel CD_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCD_0_000_A_07_WW | pup | 0 | 0.0 |
| 1301 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCE_1_000_A_1707_WW | pup | 0 | 3.498891 |
| 1325 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCE_1_000_A_1505_WW | pup | 0 | 2.02781 |
| 1349 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCE_1_000_A_17_WW | pup | 0 | 0.50103 |
| 1373 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCE_1_000_A_15_WW | pup | 0 | 0.406292 |
| 1397 | Doorshow Hotel CE_1_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCE_1_000_A_06_WW | pup | 0 | 0.936364 |
| 1421 | Doorshow Hotel CE_1_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCE_1_000_A_07_WW | pup | 0 | 0.538563 |
| 1479 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCG_0_000_A_1707_WW | pup | 0 | 11.162784 |
| 1503 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCG_0_000_A_1505_WW | pup | 0 | 4.71995 |
| 1527 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCG_0_000_A_17_WW | pup | 0 | 1.647753 |
| 1551 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCG_0_000_A_15_WW | pup | 0 | 0.968748 |
| 1575 | Mobility Channel gesamt CG_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCG_0_000_A_06_WW | pup | 0 | 2.401111 |
| 1599 | Mobility Channel gesamt CG_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCG_0_000_A_07_WW | pup | 0 | 4.179402 |
| 1657 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCG_2_000_A_1707_WW | pup | 0 | 3.212091 |
| 1681 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCG_2_000_A_1505_WW | pup | 0 | 1.363673 |
| 1705 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCG_2_000_A_17_WW | pup | 0 | 0.463168 |
| 1729 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCG_2_000_A_15_WW | pup | 0 | 0.274798 |
| 1753 | Mobility Channel Bistro CG_2_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCG_2_000_A_06_WW | pup | 0 | 0.719847 |
| 1777 | Mobility Channel Bistro CG_2_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCG_2_000_A_07_WW | pup | 0 | 1.13979 |
| 1835 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCG_3_000_A_1707_WW | pup | 0 | 5.66542 |
| 1859 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCG_3_000_A_1505_WW | pup | 0 | 2.337722 |
| 1883 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCG_3_000_A_17_WW | pup | 0 | 0.822895 |
| 1907 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCG_3_000_A_15_WW | pup | 0 | 0.473422 |
| 1931 | Mobility Channel Kasse CG_3_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCG_3_000_A_06_WW | pup | 0 | 1.246515 |
| 1955 | Mobility Channel Kasse CG_3_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCG_3_000_A_07_WW | pup | 0 | 2.117998 |
| 2013 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCG_5_000_A_1707_WW | pup | 0 | 1.017371 |
| 2037 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCG_5_000_A_1505_WW | pup | 0 | 0.444539 |
| 2061 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCG_5_000_A_17_WW | pup | 0 | 0.145796 |
| 2085 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCG_5_000_A_15_WW | pup | 0 | 0.089126 |
| 2109 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCG_5_000_A_06_WW | pup | 0 | 0.178182 |
| 2133 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCG_5_000_A_07_WW | pup | 0 | 0.395856 |
| 2191 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSCG_4_000_A_1707_WW | pup | 0 | 1.546341 |
| 2215 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSCG_4_000_A_1505_WW | pup | 0 | 0.67558 |
| 2239 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSCG_4_000_A_17_WW | pup | 0 | 0.221965 |
| 2263 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCG_4_000_A_15_WW | pup | 0 | 0.135622 |
| 2287 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSCG_4_000_A_06_WW | pup | 0 | 0.271164 |
| 2311 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSCG_4_000_A_07_WW | pup | 0 | 0.602375 |
| 2341 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSEQ_0_000_A_1707_WW | pup | 0 | 0.0 |
| 2365 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSEQ_0_000_A_1505_WW | pup | 0 | 0.0 |
| 2389 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSEQ_0_000_A_17_WW | pup | 0 | 0.0 |
| 2413 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSEQ_0_000_A_15_WW | pup | 0 | 0.0 |
| 2437 | UniScreens Deutschland EQ_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSEQ_0_000_A_06_WW | pup | 0 | 0.0 |
| 2461 | UniScreens Deutschland EQ_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSEQ_0_000_A_07_WW | pup | 0 | 0.0 |
| 2491 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSEO_0_000_A_1707_WW | pup | 0 | 2.443448 |
| 2515 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSEO_0_000_A_1505_WW | pup | 0 | 1.756396 |
| 2539 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSEO_0_000_A_17_WW | pup | 0 | 0.351683 |
| 2563 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSEO_0_000_A_15_WW | pup | 0 | 0.353811 |
| 2587 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSEO_0_000_A_06_WW | pup | 0 | 0.27269 |
| 2611 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSEO_0_000_A_07_WW | pup | 0 | 0.419005 |
| 2641 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSEP_0_000_A_1707_WW | pup | 0 | 2.443448 |
| 2665 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSEP_0_000_A_1505_WW | pup | 0 | 1.756396 |
| 2689 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSEP_0_000_A_17_WW | pup | 0 | 0.351683 |
| 2713 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSEP_0_000_A_15_WW | pup | 0 | 0.353811 |
| 2737 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 22-23 Uhr 41 | 1 1 | SPPSEP_0_000_A_06_WW | pup | 0 | 0.27269 |
| 2761 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 22-23 Uhr 41 | 1 1 | SPPSEP_0_000_A_07_WW | pup | 0 | 0.419005 |
| 2791 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSEP_1_000_A_1707_WW | pup | 0 | 1.775865 |
| 2815 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSEP_1_000_A_1505_WW | pup | 0 | 1.283087 |
| 2839 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSEP_1_000_A_17_WW | pup | 0 | 0.255064 |
| 2863 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSEP_1_000_A_15_WW | pup | 0 | 0.25794 |
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);