media_variant
1,542 rows where timerange = 5
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 60 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCA_0_000_A_1707_DD | pup | 0 | 6.744995 |
| 84 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCA_0_000_A_1505_DD | pup | 0 | 4.263794 |
| 108 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCA_0_000_A_17_DD | pup | 0 | 0.966429 |
| 132 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCA_0_000_A_15_DD | pup | 0 | 0.85501 |
| 156 | Goldbach gesamt CA_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCA_0_000_A_06_DD | pup | 0 | 1.585373 |
| 180 | Goldbach gesamt CA_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCA_0_000_A_07_DD | pup | 0 | 0.900796 |
| 238 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCH_0_000_A_1707_DD | pup | 0 | 1.203606 |
| 262 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCH_0_000_A_1505_DD | pup | 0 | 0.980733 |
| 286 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCH_0_000_A_17_DD | pup | 0 | 0.172851 |
| 310 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCH_0_000_A_15_DD | pup | 0 | 0.197117 |
| 334 | Airboards Köln CH_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCH_0_000_A_06_DD | pup | 0 | 0.129007 |
| 358 | Airboards Köln CH_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCH_0_000_A_07_DD | pup | 0 | 0.095118 |
| 416 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCI_0_000_A_1707_DD | pup | 0 | 0.152051 |
| 440 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCI_0_000_A_1505_DD | pup | 0 | 0.119346 |
| 464 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCI_0_000_A_17_DD | pup | 0 | 0.021759 |
| 488 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCI_0_000_A_15_DD | pup | 0 | 0.023909 |
| 512 | Airboards Paderborn CI_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCI_0_000_A_06_DD | pup | 0 | 0.030102 |
| 536 | Airboards Paderborn CI_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCI_0_000_A_07_DD | pup | 0 | 0.002659 |
| 594 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCF_0_000_A_1707_DD | pup | 0 | 0.0 |
| 618 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCF_0_000_A_1505_DD | pup | 0 | 0.0 |
| 642 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCF_0_000_A_17_DD | pup | 0 | 0.0 |
| 666 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCF_0_000_A_15_DD | pup | 0 | 0.0 |
| 690 | CityNet Tube Bochum CF_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCF_0_000_A_06_DD | pup | 0 | 0.0 |
| 714 | CityNet Tube Bochum CF_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCF_0_000_A_07_DD | pup | 0 | 0.0 |
| 772 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCB_0_000_A_1707_DD | pup | 0 | 2.701543 |
| 796 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCB_0_000_A_1505_DD | pup | 0 | 1.756959 |
| 820 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCB_0_000_A_17_DD | pup | 0 | 0.386558 |
| 844 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCB_0_000_A_15_DD | pup | 0 | 0.352023 |
| 868 | King Channel CB_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCB_0_000_A_06_DD | pup | 0 | 0.789041 |
| 892 | King Channel CB_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCB_0_000_A_07_DD | pup | 0 | 0.156608 |
| 950 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCC_0_000_A_1707_DD | pup | 0 | 0.0 |
| 974 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCC_0_000_A_1505_DD | pup | 0 | 0.0 |
| 998 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCC_0_000_A_17_DD | pup | 0 | 0.0 |
| 1022 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCC_0_000_A_15_DD | pup | 0 | 0.0 |
| 1046 | Mall Channel CC_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCC_0_000_A_06_DD | pup | 0 | 0.0 |
| 1070 | Mall Channel CC_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCC_0_000_A_07_DD | pup | 0 | 0.0 |
| 1128 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCD_0_000_A_1707_DD | pup | 0 | 0.0 |
| 1152 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCD_0_000_A_1505_DD | pup | 0 | 0.0 |
| 1176 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCD_0_000_A_17_DD | pup | 0 | 0.0 |
| 1200 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCD_0_000_A_15_DD | pup | 0 | 0.0 |
| 1224 | Instore Channel CD_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCD_0_000_A_06_DD | pup | 0 | 0.0 |
| 1248 | Instore Channel CD_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCD_0_000_A_07_DD | pup | 0 | 0.0 |
| 1306 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCE_1_000_A_1707_DD | pup | 0 | 2.68915 |
| 1330 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCE_1_000_A_1505_DD | pup | 0 | 1.407282 |
| 1354 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCE_1_000_A_17_DD | pup | 0 | 0.385296 |
| 1378 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCE_1_000_A_15_DD | pup | 0 | 0.282002 |
| 1402 | Doorshow Hotel CE_1_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCE_1_000_A_06_DD | pup | 0 | 0.637248 |
| 1426 | Doorshow Hotel CE_1_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCE_1_000_A_07_DD | pup | 0 | 0.646435 |
| 1484 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCG_0_000_A_1707_DD | pup | 0 | 0.0 |
| 1508 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCG_0_000_A_1505_DD | pup | 0 | 0.0 |
| 1532 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCG_0_000_A_17_DD | pup | 0 | 0.0 |
| 1556 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCG_0_000_A_15_DD | pup | 0 | 0.0 |
| 1580 | Mobility Channel gesamt CG_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCG_0_000_A_06_DD | pup | 0 | 0.0 |
| 1604 | Mobility Channel gesamt CG_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCG_0_000_A_07_DD | pup | 0 | 0.0 |
| 1662 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCG_2_000_A_1707_DD | pup | 0 | 0.0 |
| 1686 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCG_2_000_A_1505_DD | pup | 0 | 0.0 |
| 1710 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCG_2_000_A_17_DD | pup | 0 | 0.0 |
| 1734 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCG_2_000_A_15_DD | pup | 0 | 0.0 |
| 1758 | Mobility Channel Bistro CG_2_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCG_2_000_A_06_DD | pup | 0 | 0.0 |
| 1782 | Mobility Channel Bistro CG_2_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCG_2_000_A_07_DD | pup | 0 | 0.0 |
| 1840 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCG_3_000_A_1707_DD | pup | 0 | 0.0 |
| 1864 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCG_3_000_A_1505_DD | pup | 0 | 0.0 |
| 1888 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCG_3_000_A_17_DD | pup | 0 | 0.0 |
| 1912 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCG_3_000_A_15_DD | pup | 0 | 0.0 |
| 1936 | Mobility Channel Kasse CG_3_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCG_3_000_A_06_DD | pup | 0 | 0.0 |
| 1960 | Mobility Channel Kasse CG_3_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCG_3_000_A_07_DD | pup | 0 | 0.0 |
| 2018 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCG_5_000_A_1707_DD | pup | 0 | 0.0 |
| 2042 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCG_5_000_A_1505_DD | pup | 0 | 0.0 |
| 2066 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCG_5_000_A_17_DD | pup | 0 | 0.0 |
| 2090 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCG_5_000_A_15_DD | pup | 0 | 0.0 |
| 2114 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCG_5_000_A_06_DD | pup | 0 | 0.0 |
| 2138 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCG_5_000_A_07_DD | pup | 0 | 0.0 |
| 2196 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSCG_4_000_A_1707_DD | pup | 0 | 0.0 |
| 2220 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSCG_4_000_A_1505_DD | pup | 0 | 0.0 |
| 2244 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSCG_4_000_A_17_DD | pup | 0 | 0.0 |
| 2268 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCG_4_000_A_15_DD | pup | 0 | 0.0 |
| 2292 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSCG_4_000_A_06_DD | pup | 0 | 0.0 |
| 2316 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSCG_4_000_A_07_DD | pup | 0 | 0.0 |
| 2346 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSEQ_0_000_A_1707_DD | pup | 0 | 0.0 |
| 2370 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSEQ_0_000_A_1505_DD | pup | 0 | 0.0 |
| 2394 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSEQ_0_000_A_17_DD | pup | 0 | 0.0 |
| 2418 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSEQ_0_000_A_15_DD | pup | 0 | 0.0 |
| 2442 | UniScreens Deutschland EQ_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSEQ_0_000_A_06_DD | pup | 0 | 0.0 |
| 2466 | UniScreens Deutschland EQ_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSEQ_0_000_A_07_DD | pup | 0 | 0.0 |
| 2496 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSEO_0_000_A_1707_DD | pup | 0 | 0.0 |
| 2520 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSEO_0_000_A_1505_DD | pup | 0 | 0.0 |
| 2544 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSEO_0_000_A_17_DD | pup | 0 | 0.0 |
| 2568 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSEO_0_000_A_15_DD | pup | 0 | 0.0 |
| 2592 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSEO_0_000_A_06_DD | pup | 0 | 0.0 |
| 2616 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSEO_0_000_A_07_DD | pup | 0 | 0.0 |
| 2646 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSEP_0_000_A_1707_DD | pup | 0 | 0.0 |
| 2670 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSEP_0_000_A_1505_DD | pup | 0 | 0.0 |
| 2694 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSEP_0_000_A_17_DD | pup | 0 | 0.0 |
| 2718 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSEP_0_000_A_15_DD | pup | 0 | 0.0 |
| 2742 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 03-04 Uhr 5 | 1 1 | SPPSEP_0_000_A_06_DD | pup | 0 | 0.0 |
| 2766 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 03-04 Uhr 5 | 1 1 | SPPSEP_0_000_A_07_DD | pup | 0 | 0.0 |
| 2796 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSEP_1_000_A_1707_DD | pup | 0 | 0.0 |
| 2820 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSEP_1_000_A_1505_DD | pup | 0 | 0.0 |
| 2844 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSEP_1_000_A_17_DD | pup | 0 | 0.0 |
| 2868 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSEP_1_000_A_15_DD | 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);