media_variant
1,542 rows where timerange = 22
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 45 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCA_0_000_A_1707_MM | pup | 0 | 232.201898 |
| 69 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCA_0_000_A_1505_MM | pup | 0 | 147.911884 |
| 93 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCA_0_000_A_17_MM | pup | 0 | 34.554604 |
| 117 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCA_0_000_A_15_MM | pup | 0 | 30.519104 |
| 141 | Goldbach gesamt CA_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCA_0_000_A_06_MM | pup | 0 | 76.895615 |
| 165 | Goldbach gesamt CA_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCA_0_000_A_07_MM | pup | 0 | 11.126489 |
| 223 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCH_0_000_A_1707_MM | pup | 0 | 4.498678 |
| 247 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCH_0_000_A_1505_MM | pup | 0 | 2.843988 |
| 271 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCH_0_000_A_17_MM | pup | 0 | 0.660419 |
| 295 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCH_0_000_A_15_MM | pup | 0 | 0.585529 |
| 319 | Airboards Köln CH_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCH_0_000_A_06_MM | pup | 0 | 1.354603 |
| 343 | Airboards Köln CH_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCH_0_000_A_07_MM | pup | 0 | 0.332922 |
| 401 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCI_0_000_A_1707_MM | pup | 0 | 0.225243 |
| 425 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCI_0_000_A_1505_MM | pup | 0 | 0.111195 |
| 449 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCI_0_000_A_17_MM | pup | 0 | 0.032205 |
| 473 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCI_0_000_A_15_MM | pup | 0 | 0.02225 |
| 497 | Airboards Paderborn CI_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCI_0_000_A_06_MM | pup | 0 | 0.105452 |
| 521 | Airboards Paderborn CI_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCI_0_000_A_07_MM | pup | 0 | 0.008676 |
| 579 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCF_0_000_A_1707_MM | pup | 0 | 15.236977 |
| 603 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCF_0_000_A_1505_MM | pup | 0 | 10.662997 |
| 627 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCF_0_000_A_17_MM | pup | 0 | 2.393518 |
| 651 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCF_0_000_A_15_MM | pup | 0 | 2.290043 |
| 675 | CityNet Tube Bochum CF_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCF_0_000_A_06_MM | pup | 0 | 4.347753 |
| 699 | CityNet Tube Bochum CF_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCF_0_000_A_07_MM | pup | 0 | 0.899097 |
| 757 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCB_0_000_A_1707_MM | pup | 0 | 51.922169 |
| 781 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCB_0_000_A_1505_MM | pup | 0 | 37.759151 |
| 805 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCB_0_000_A_17_MM | pup | 0 | 7.505447 |
| 829 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCB_0_000_A_15_MM | pup | 0 | 7.618523 |
| 853 | King Channel CB_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCB_0_000_A_06_MM | pup | 0 | 9.572594 |
| 877 | King Channel CB_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCB_0_000_A_07_MM | pup | 0 | 4.844398 |
| 935 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCC_0_000_A_1707_MM | pup | 0 | 112.965121 |
| 959 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCC_0_000_A_1505_MM | pup | 0 | 69.835158 |
| 983 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCC_0_000_A_17_MM | pup | 0 | 16.701092 |
| 1007 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCC_0_000_A_15_MM | pup | 0 | 14.391947 |
| 1031 | Mall Channel CC_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCC_0_000_A_06_MM | pup | 0 | 44.366604 |
| 1055 | Mall Channel CC_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCC_0_000_A_07_MM | pup | 0 | 0.0 |
| 1113 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCD_0_000_A_1707_MM | pup | 0 | 2.797618 |
| 1137 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCD_0_000_A_1505_MM | pup | 0 | 1.093351 |
| 1161 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCD_0_000_A_17_MM | pup | 0 | 0.403931 |
| 1185 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCD_0_000_A_15_MM | pup | 0 | 0.220128 |
| 1209 | Instore Channel CD_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCD_0_000_A_06_MM | pup | 0 | 1.715149 |
| 1233 | Instore Channel CD_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCD_0_000_A_07_MM | pup | 0 | 0.0 |
| 1291 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCE_1_000_A_1707_MM | pup | 0 | 6.753833 |
| 1315 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCE_1_000_A_1505_MM | pup | 0 | 4.549475 |
| 1339 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCE_1_000_A_17_MM | pup | 0 | 0.975796 |
| 1363 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCE_1_000_A_15_MM | pup | 0 | 0.922464 |
| 1387 | Doorshow Hotel CE_1_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCE_1_000_A_06_MM | pup | 0 | 1.292147 |
| 1411 | Doorshow Hotel CE_1_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCE_1_000_A_07_MM | pup | 0 | 0.91781 |
| 1469 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCG_0_000_A_1707_MM | pup | 0 | 39.29812 |
| 1493 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCG_0_000_A_1505_MM | pup | 0 | 21.66685 |
| 1517 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCG_0_000_A_17_MM | pup | 0 | 5.914536 |
| 1541 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCG_0_000_A_15_MM | pup | 0 | 4.49348 |
| 1565 | Mobility Channel gesamt CG_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCG_0_000_A_06_MM | pup | 0 | 14.282795 |
| 1589 | Mobility Channel gesamt CG_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCG_0_000_A_07_MM | pup | 0 | 4.125829 |
| 1647 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCG_2_000_A_1707_MM | pup | 0 | 10.365244 |
| 1671 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCG_2_000_A_1505_MM | pup | 0 | 5.730462 |
| 1695 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCG_2_000_A_17_MM | pup | 0 | 1.49787 |
| 1719 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCG_2_000_A_15_MM | pup | 0 | 1.155563 |
| 1743 | Mobility Channel Bistro CG_2_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCG_2_000_A_06_MM | pup | 0 | 3.613925 |
| 1767 | Mobility Channel Bistro CG_2_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCG_2_000_A_07_MM | pup | 0 | 1.061145 |
| 1825 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCG_3_000_A_1707_MM | pup | 0 | 21.256015 |
| 1849 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCG_3_000_A_1505_MM | pup | 0 | 11.682291 |
| 1873 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCG_3_000_A_17_MM | pup | 0 | 3.129418 |
| 1897 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCG_3_000_A_15_MM | pup | 0 | 2.38472 |
| 1921 | Mobility Channel Kasse CG_3_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCG_3_000_A_06_MM | pup | 0 | 7.643148 |
| 1945 | Mobility Channel Kasse CG_3_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCG_3_000_A_07_MM | pup | 0 | 2.182715 |
| 2003 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCG_5_000_A_1707_MM | pup | 0 | 3.645894 |
| 2027 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCG_5_000_A_1505_MM | pup | 0 | 1.935038 |
| 2051 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCG_5_000_A_17_MM | pup | 0 | 0.523489 |
| 2075 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCG_5_000_A_15_MM | pup | 0 | 0.388359 |
| 2099 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCG_5_000_A_06_MM | pup | 0 | 1.356963 |
| 2123 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCG_5_000_A_07_MM | pup | 0 | 0.361064 |
| 2181 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSCG_4_000_A_1707_MM | pup | 0 | 5.53732 |
| 2205 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSCG_4_000_A_1505_MM | pup | 0 | 2.93946 |
| 2229 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSCG_4_000_A_17_MM | pup | 0 | 0.797174 |
| 2253 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCG_4_000_A_15_MM | pup | 0 | 0.591015 |
| 2277 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSCG_4_000_A_06_MM | pup | 0 | 2.064935 |
| 2301 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSCG_4_000_A_07_MM | pup | 0 | 0.549446 |
| 2331 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSEQ_0_000_A_1707_MM | pup | 0 | 57.355345 |
| 2355 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSEQ_0_000_A_1505_MM | pup | 0 | 55.277769 |
| 2379 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSEQ_0_000_A_17_MM | pup | 0 | 8.468784 |
| 2403 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSEQ_0_000_A_15_MM | pup | 0 | 11.385887 |
| 2427 | UniScreens Deutschland EQ_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSEQ_0_000_A_06_MM | pup | 0 | 2.24668 |
| 2451 | UniScreens Deutschland EQ_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSEQ_0_000_A_07_MM | pup | 0 | 0.0 |
| 2481 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSEO_0_000_A_1707_MM | pup | 0 | 1.687058 |
| 2505 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSEO_0_000_A_1505_MM | pup | 0 | 1.008903 |
| 2529 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSEO_0_000_A_17_MM | pup | 0 | 0.241648 |
| 2553 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSEO_0_000_A_15_MM | pup | 0 | 0.202157 |
| 2577 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSEO_0_000_A_06_MM | pup | 0 | 0.283178 |
| 2601 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSEO_0_000_A_07_MM | pup | 0 | 0.397185 |
| 2631 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSEP_0_000_A_1707_MM | pup | 0 | 1.687058 |
| 2655 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSEP_0_000_A_1505_MM | pup | 0 | 1.008903 |
| 2679 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSEP_0_000_A_17_MM | pup | 0 | 0.241648 |
| 2703 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSEP_0_000_A_15_MM | pup | 0 | 0.202157 |
| 2727 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 12-13 Uhr 22 | 1 1 | SPPSEP_0_000_A_06_MM | pup | 0 | 0.283178 |
| 2751 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 12-13 Uhr 22 | 1 1 | SPPSEP_0_000_A_07_MM | pup | 0 | 0.397185 |
| 2781 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSEP_1_000_A_1707_MM | pup | 0 | 1.217743 |
| 2805 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSEP_1_000_A_1505_MM | pup | 0 | 0.72978 |
| 2829 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSEP_1_000_A_17_MM | pup | 0 | 0.174297 |
| 2853 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSEP_1_000_A_15_MM | pup | 0 | 0.146147 |
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);