media_variant
1,542 rows where timerange = 6
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 61 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCA_0_000_A_1707_EE | pup | 0 | 5.574112 |
| 85 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCA_0_000_A_1505_EE | pup | 0 | 3.104995 |
| 109 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCA_0_000_A_17_EE | pup | 0 | 0.798186 |
| 133 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCA_0_000_A_15_EE | pup | 0 | 0.622233 |
| 157 | Goldbach gesamt CA_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCA_0_000_A_06_EE | pup | 0 | 1.610697 |
| 181 | Goldbach gesamt CA_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCA_0_000_A_07_EE | pup | 0 | 0.862449 |
| 239 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCH_0_000_A_1707_EE | pup | 0 | 1.118785 |
| 263 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCH_0_000_A_1505_EE | pup | 0 | 0.890274 |
| 287 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCH_0_000_A_17_EE | pup | 0 | 0.16041 |
| 311 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCH_0_000_A_15_EE | pup | 0 | 0.178617 |
| 335 | Airboards Köln CH_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCH_0_000_A_06_EE | pup | 0 | 0.107217 |
| 359 | Airboards Köln CH_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCH_0_000_A_07_EE | pup | 0 | 0.122526 |
| 417 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCI_0_000_A_1707_EE | pup | 0 | 0.055165 |
| 441 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCI_0_000_A_1505_EE | pup | 0 | 0.026131 |
| 465 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCI_0_000_A_17_EE | pup | 0 | 0.007883 |
| 489 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCI_0_000_A_15_EE | pup | 0 | 0.005227 |
| 513 | Airboards Paderborn CI_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCI_0_000_A_06_EE | pup | 0 | 0.019343 |
| 537 | Airboards Paderborn CI_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCI_0_000_A_07_EE | pup | 0 | 0.009706 |
| 595 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCF_0_000_A_1707_EE | pup | 0 | 0.0 |
| 619 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCF_0_000_A_1505_EE | pup | 0 | 0.0 |
| 643 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCF_0_000_A_17_EE | pup | 0 | 0.0 |
| 667 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCF_0_000_A_15_EE | pup | 0 | 0.0 |
| 691 | CityNet Tube Bochum CF_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCF_0_000_A_06_EE | pup | 0 | 0.0 |
| 715 | CityNet Tube Bochum CF_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCF_0_000_A_07_EE | pup | 0 | 0.0 |
| 773 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCB_0_000_A_1707_EE | pup | 0 | 1.773163 |
| 797 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCB_0_000_A_1505_EE | pup | 0 | 0.693635 |
| 821 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCB_0_000_A_17_EE | pup | 0 | 0.253427 |
| 845 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCB_0_000_A_15_EE | pup | 0 | 0.138771 |
| 869 | King Channel CB_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCB_0_000_A_06_EE | pup | 0 | 0.94187 |
| 893 | King Channel CB_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCB_0_000_A_07_EE | pup | 0 | 0.138234 |
| 951 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCC_0_000_A_1707_EE | pup | 0 | 0.0 |
| 975 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCC_0_000_A_1505_EE | pup | 0 | 0.0 |
| 999 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCC_0_000_A_17_EE | pup | 0 | 0.0 |
| 1023 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCC_0_000_A_15_EE | pup | 0 | 0.0 |
| 1047 | Mall Channel CC_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCC_0_000_A_06_EE | pup | 0 | 0.0 |
| 1071 | Mall Channel CC_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCC_0_000_A_07_EE | pup | 0 | 0.0 |
| 1129 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCD_0_000_A_1707_EE | pup | 0 | 0.0 |
| 1153 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCD_0_000_A_1505_EE | pup | 0 | 0.0 |
| 1177 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCD_0_000_A_17_EE | pup | 0 | 0.0 |
| 1201 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCD_0_000_A_15_EE | pup | 0 | 0.0 |
| 1225 | Instore Channel CD_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCD_0_000_A_06_EE | pup | 0 | 0.0 |
| 1249 | Instore Channel CD_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCD_0_000_A_07_EE | pup | 0 | 0.0 |
| 1307 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCE_1_000_A_1707_EE | pup | 0 | 2.62815 |
| 1331 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCE_1_000_A_1505_EE | pup | 0 | 1.495518 |
| 1355 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCE_1_000_A_17_EE | pup | 0 | 0.376517 |
| 1379 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCE_1_000_A_15_EE | pup | 0 | 0.299687 |
| 1403 | Doorshow Hotel CE_1_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCE_1_000_A_06_EE | pup | 0 | 0.542362 |
| 1427 | Doorshow Hotel CE_1_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCE_1_000_A_07_EE | pup | 0 | 0.592023 |
| 1485 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCG_0_000_A_1707_EE | pup | 0 | 0.0 |
| 1509 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCG_0_000_A_1505_EE | pup | 0 | 0.0 |
| 1533 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCG_0_000_A_17_EE | pup | 0 | 0.0 |
| 1557 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCG_0_000_A_15_EE | pup | 0 | 0.0 |
| 1581 | Mobility Channel gesamt CG_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCG_0_000_A_06_EE | pup | 0 | 0.0 |
| 1605 | Mobility Channel gesamt CG_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCG_0_000_A_07_EE | pup | 0 | 0.0 |
| 1663 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCG_2_000_A_1707_EE | pup | 0 | 0.0 |
| 1687 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCG_2_000_A_1505_EE | pup | 0 | 0.0 |
| 1711 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCG_2_000_A_17_EE | pup | 0 | 0.0 |
| 1735 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCG_2_000_A_15_EE | pup | 0 | 0.0 |
| 1759 | Mobility Channel Bistro CG_2_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCG_2_000_A_06_EE | pup | 0 | 0.0 |
| 1783 | Mobility Channel Bistro CG_2_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCG_2_000_A_07_EE | pup | 0 | 0.0 |
| 1841 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCG_3_000_A_1707_EE | pup | 0 | 0.0 |
| 1865 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCG_3_000_A_1505_EE | pup | 0 | 0.0 |
| 1889 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCG_3_000_A_17_EE | pup | 0 | 0.0 |
| 1913 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCG_3_000_A_15_EE | pup | 0 | 0.0 |
| 1937 | Mobility Channel Kasse CG_3_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCG_3_000_A_06_EE | pup | 0 | 0.0 |
| 1961 | Mobility Channel Kasse CG_3_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCG_3_000_A_07_EE | pup | 0 | 0.0 |
| 2019 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCG_5_000_A_1707_EE | pup | 0 | 0.0 |
| 2043 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCG_5_000_A_1505_EE | pup | 0 | 0.0 |
| 2067 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCG_5_000_A_17_EE | pup | 0 | 0.0 |
| 2091 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCG_5_000_A_15_EE | pup | 0 | 0.0 |
| 2115 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCG_5_000_A_06_EE | pup | 0 | 0.0 |
| 2139 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCG_5_000_A_07_EE | pup | 0 | 0.0 |
| 2197 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSCG_4_000_A_1707_EE | pup | 0 | 0.0 |
| 2221 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSCG_4_000_A_1505_EE | pup | 0 | 0.0 |
| 2245 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSCG_4_000_A_17_EE | pup | 0 | 0.0 |
| 2269 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCG_4_000_A_15_EE | pup | 0 | 0.0 |
| 2293 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSCG_4_000_A_06_EE | pup | 0 | 0.0 |
| 2317 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSCG_4_000_A_07_EE | pup | 0 | 0.0 |
| 2347 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSEQ_0_000_A_1707_EE | pup | 0 | 0.0 |
| 2371 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSEQ_0_000_A_1505_EE | pup | 0 | 0.0 |
| 2395 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSEQ_0_000_A_17_EE | pup | 0 | 0.0 |
| 2419 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSEQ_0_000_A_15_EE | pup | 0 | 0.0 |
| 2443 | UniScreens Deutschland EQ_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSEQ_0_000_A_06_EE | pup | 0 | 0.0 |
| 2467 | UniScreens Deutschland EQ_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSEQ_0_000_A_07_EE | pup | 0 | 0.0 |
| 2497 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSEO_0_000_A_1707_EE | pup | 0 | 0.0 |
| 2521 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSEO_0_000_A_1505_EE | pup | 0 | 0.0 |
| 2545 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSEO_0_000_A_17_EE | pup | 0 | 0.0 |
| 2569 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSEO_0_000_A_15_EE | pup | 0 | 0.0 |
| 2593 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSEO_0_000_A_06_EE | pup | 0 | 0.0 |
| 2617 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSEO_0_000_A_07_EE | pup | 0 | 0.0 |
| 2647 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSEP_0_000_A_1707_EE | pup | 0 | 0.0 |
| 2671 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSEP_0_000_A_1505_EE | pup | 0 | 0.0 |
| 2695 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSEP_0_000_A_17_EE | pup | 0 | 0.0 |
| 2719 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSEP_0_000_A_15_EE | pup | 0 | 0.0 |
| 2743 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 04-05 Uhr 6 | 1 1 | SPPSEP_0_000_A_06_EE | pup | 0 | 0.0 |
| 2767 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 04-05 Uhr 6 | 1 1 | SPPSEP_0_000_A_07_EE | pup | 0 | 0.0 |
| 2797 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSEP_1_000_A_1707_EE | pup | 0 | 0.0 |
| 2821 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSEP_1_000_A_1505_EE | pup | 0 | 0.0 |
| 2845 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSEP_1_000_A_17_EE | pup | 0 | 0.0 |
| 2869 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSEP_1_000_A_15_EE | pup | 0 | 0.0 |
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);