media_variant
1,542 rows where timerange = 8
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 62 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCA_0_000_A_1707_FF | pup | 0 | 6.244357 |
| 86 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCA_0_000_A_1505_FF | pup | 0 | 3.421551 |
| 110 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCA_0_000_A_17_FF | pup | 0 | 0.894004 |
| 134 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCA_0_000_A_15_FF | pup | 0 | 0.685358 |
| 158 | Goldbach gesamt CA_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCA_0_000_A_06_FF | pup | 0 | 1.568368 |
| 182 | Goldbach gesamt CA_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCA_0_000_A_07_FF | pup | 0 | 1.259645 |
| 240 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCH_0_000_A_1707_FF | pup | 0 | 0.88349 |
| 264 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCH_0_000_A_1505_FF | pup | 0 | 0.532006 |
| 288 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCH_0_000_A_17_FF | pup | 0 | 0.12666 |
| 312 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCH_0_000_A_15_FF | pup | 0 | 0.10674 |
| 336 | Airboards Köln CH_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCH_0_000_A_06_FF | pup | 0 | 0.115898 |
| 360 | Airboards Köln CH_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCH_0_000_A_07_FF | pup | 0 | 0.236753 |
| 418 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCI_0_000_A_1707_FF | pup | 0 | 0.089606 |
| 442 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCI_0_000_A_1505_FF | pup | 0 | 0.019073 |
| 466 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCI_0_000_A_17_FF | pup | 0 | 0.012808 |
| 490 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCI_0_000_A_15_FF | pup | 0 | 0.003815 |
| 514 | Airboards Paderborn CI_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCI_0_000_A_06_FF | pup | 0 | 0.060894 |
| 538 | Airboards Paderborn CI_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCI_0_000_A_07_FF | pup | 0 | 0.009675 |
| 596 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCF_0_000_A_1707_FF | pup | 0 | 0.0 |
| 620 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCF_0_000_A_1505_FF | pup | 0 | 0.0 |
| 644 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCF_0_000_A_17_FF | pup | 0 | 0.0 |
| 668 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCF_0_000_A_15_FF | pup | 0 | 0.0 |
| 692 | CityNet Tube Bochum CF_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCF_0_000_A_06_FF | pup | 0 | 0.0 |
| 716 | CityNet Tube Bochum CF_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCF_0_000_A_07_FF | pup | 0 | 0.0 |
| 774 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCB_0_000_A_1707_FF | pup | 0 | 2.382785 |
| 798 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCB_0_000_A_1505_FF | pup | 0 | 1.366251 |
| 822 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCB_0_000_A_17_FF | pup | 0 | 0.340608 |
| 846 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCB_0_000_A_15_FF | pup | 0 | 0.273349 |
| 870 | King Channel CB_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCB_0_000_A_06_FF | pup | 0 | 0.656147 |
| 894 | King Channel CB_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCB_0_000_A_07_FF | pup | 0 | 0.36155 |
| 952 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCC_0_000_A_1707_FF | pup | 0 | 0.0 |
| 976 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCC_0_000_A_1505_FF | pup | 0 | 0.0 |
| 1000 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCC_0_000_A_17_FF | pup | 0 | 0.0 |
| 1024 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCC_0_000_A_15_FF | pup | 0 | 0.0 |
| 1048 | Mall Channel CC_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCC_0_000_A_06_FF | pup | 0 | 0.0 |
| 1072 | Mall Channel CC_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCC_0_000_A_07_FF | pup | 0 | 0.0 |
| 1130 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCD_0_000_A_1707_FF | pup | 0 | 0.0 |
| 1154 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCD_0_000_A_1505_FF | pup | 0 | 0.0 |
| 1178 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCD_0_000_A_17_FF | pup | 0 | 0.0 |
| 1202 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCD_0_000_A_15_FF | pup | 0 | 0.0 |
| 1226 | Instore Channel CD_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCD_0_000_A_06_FF | pup | 0 | 0.0 |
| 1250 | Instore Channel CD_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCD_0_000_A_07_FF | pup | 0 | 0.0 |
| 1308 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCE_1_000_A_1707_FF | pup | 0 | 2.889979 |
| 1332 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCE_1_000_A_1505_FF | pup | 0 | 1.504525 |
| 1356 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCE_1_000_A_17_FF | pup | 0 | 0.41396 |
| 1380 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCE_1_000_A_15_FF | pup | 0 | 0.301458 |
| 1404 | Doorshow Hotel CE_1_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCE_1_000_A_06_FF | pup | 0 | 0.73559 |
| 1428 | Doorshow Hotel CE_1_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCE_1_000_A_07_FF | pup | 0 | 0.651808 |
| 1486 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCG_0_000_A_1707_FF | pup | 0 | 0.0 |
| 1510 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCG_0_000_A_1505_FF | pup | 0 | 0.0 |
| 1534 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCG_0_000_A_17_FF | pup | 0 | 0.0 |
| 1558 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCG_0_000_A_15_FF | pup | 0 | 0.0 |
| 1582 | Mobility Channel gesamt CG_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCG_0_000_A_06_FF | pup | 0 | 0.0 |
| 1606 | Mobility Channel gesamt CG_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCG_0_000_A_07_FF | pup | 0 | 0.0 |
| 1664 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCG_2_000_A_1707_FF | pup | 0 | 0.0 |
| 1688 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCG_2_000_A_1505_FF | pup | 0 | 0.0 |
| 1712 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCG_2_000_A_17_FF | pup | 0 | 0.0 |
| 1736 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCG_2_000_A_15_FF | pup | 0 | 0.0 |
| 1760 | Mobility Channel Bistro CG_2_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCG_2_000_A_06_FF | pup | 0 | 0.0 |
| 1784 | Mobility Channel Bistro CG_2_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCG_2_000_A_07_FF | pup | 0 | 0.0 |
| 1842 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCG_3_000_A_1707_FF | pup | 0 | 0.0 |
| 1866 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCG_3_000_A_1505_FF | pup | 0 | 0.0 |
| 1890 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCG_3_000_A_17_FF | pup | 0 | 0.0 |
| 1914 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCG_3_000_A_15_FF | pup | 0 | 0.0 |
| 1938 | Mobility Channel Kasse CG_3_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCG_3_000_A_06_FF | pup | 0 | 0.0 |
| 1962 | Mobility Channel Kasse CG_3_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCG_3_000_A_07_FF | pup | 0 | 0.0 |
| 2020 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCG_5_000_A_1707_FF | pup | 0 | 0.0 |
| 2044 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCG_5_000_A_1505_FF | pup | 0 | 0.0 |
| 2068 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCG_5_000_A_17_FF | pup | 0 | 0.0 |
| 2092 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCG_5_000_A_15_FF | pup | 0 | 0.0 |
| 2116 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCG_5_000_A_06_FF | pup | 0 | 0.0 |
| 2140 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCG_5_000_A_07_FF | pup | 0 | 0.0 |
| 2198 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSCG_4_000_A_1707_FF | pup | 0 | 0.0 |
| 2222 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSCG_4_000_A_1505_FF | pup | 0 | 0.0 |
| 2246 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSCG_4_000_A_17_FF | pup | 0 | 0.0 |
| 2270 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCG_4_000_A_15_FF | pup | 0 | 0.0 |
| 2294 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSCG_4_000_A_06_FF | pup | 0 | 0.0 |
| 2318 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSCG_4_000_A_07_FF | pup | 0 | 0.0 |
| 2348 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSEQ_0_000_A_1707_FF | pup | 0 | 0.0 |
| 2372 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSEQ_0_000_A_1505_FF | pup | 0 | 0.0 |
| 2396 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSEQ_0_000_A_17_FF | pup | 0 | 0.0 |
| 2420 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSEQ_0_000_A_15_FF | pup | 0 | 0.0 |
| 2444 | UniScreens Deutschland EQ_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSEQ_0_000_A_06_FF | pup | 0 | 0.0 |
| 2468 | UniScreens Deutschland EQ_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSEQ_0_000_A_07_FF | pup | 0 | 0.0 |
| 2498 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSEO_0_000_A_1707_FF | pup | 0 | 0.0 |
| 2522 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSEO_0_000_A_1505_FF | pup | 0 | 0.0 |
| 2546 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSEO_0_000_A_17_FF | pup | 0 | 0.0 |
| 2570 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSEO_0_000_A_15_FF | pup | 0 | 0.0 |
| 2594 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSEO_0_000_A_06_FF | pup | 0 | 0.0 |
| 2618 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSEO_0_000_A_07_FF | pup | 0 | 0.0 |
| 2648 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSEP_0_000_A_1707_FF | pup | 0 | 0.0 |
| 2672 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSEP_0_000_A_1505_FF | pup | 0 | 0.0 |
| 2696 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSEP_0_000_A_17_FF | pup | 0 | 0.0 |
| 2720 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSEP_0_000_A_15_FF | pup | 0 | 0.0 |
| 2744 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 05-06 Uhr 8 | 1 1 | SPPSEP_0_000_A_06_FF | pup | 0 | 0.0 |
| 2768 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 05-06 Uhr 8 | 1 1 | SPPSEP_0_000_A_07_FF | pup | 0 | 0.0 |
| 2798 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSEP_1_000_A_1707_FF | pup | 0 | 0.0 |
| 2822 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSEP_1_000_A_1505_FF | pup | 0 | 0.0 |
| 2846 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSEP_1_000_A_17_FF | pup | 0 | 0.0 |
| 2870 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSEP_1_000_A_15_FF | 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);