media_variant
1,542 rows where timerange = 19
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 43 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCA_0_000_A_1707_KK | pup | 0 | 201.04446 |
| 67 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCA_0_000_A_1505_KK | pup | 0 | 130.677802 |
| 91 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCA_0_000_A_17_KK | pup | 0 | 30.852305 |
| 115 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCA_0_000_A_15_KK | pup | 0 | 27.845353 |
| 139 | Goldbach gesamt CA_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCA_0_000_A_06_KK | pup | 0 | 60.241945 |
| 163 | Goldbach gesamt CA_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCA_0_000_A_07_KK | pup | 0 | 14.684682 |
| 221 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCH_0_000_A_1707_KK | pup | 0 | 5.114623 |
| 245 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCH_0_000_A_1505_KK | pup | 0 | 4.159298 |
| 269 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCH_0_000_A_17_KK | pup | 0 | 0.752116 |
| 293 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCH_0_000_A_15_KK | pup | 0 | 0.85566 |
| 317 | Airboards Köln CH_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCH_0_000_A_06_KK | pup | 0 | 0.595331 |
| 341 | Airboards Köln CH_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCH_0_000_A_07_KK | pup | 0 | 0.383985 |
| 399 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCI_0_000_A_1707_KK | pup | 0 | 0.232982 |
| 423 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCI_0_000_A_1505_KK | pup | 0 | 0.111208 |
| 447 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCI_0_000_A_17_KK | pup | 0 | 0.033311 |
| 471 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCI_0_000_A_15_KK | pup | 0 | 0.022251 |
| 495 | Airboards Paderborn CI_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCI_0_000_A_06_KK | pup | 0 | 0.105477 |
| 519 | Airboards Paderborn CI_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCI_0_000_A_07_KK | pup | 0 | 0.016415 |
| 577 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCF_0_000_A_1707_KK | pup | 0 | 19.076526 |
| 601 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCF_0_000_A_1505_KK | pup | 0 | 14.673731 |
| 625 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCF_0_000_A_17_KK | pup | 0 | 3.328386 |
| 649 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCF_0_000_A_15_KK | pup | 0 | 3.602762 |
| 673 | CityNet Tube Bochum CF_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCF_0_000_A_06_KK | pup | 0 | 4.206899 |
| 697 | CityNet Tube Bochum CF_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCF_0_000_A_07_KK | pup | 0 | 0.751976 |
| 755 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCB_0_000_A_1707_KK | pup | 0 | 11.972218 |
| 779 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCB_0_000_A_1505_KK | pup | 0 | 7.814329 |
| 803 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCB_0_000_A_17_KK | pup | 0 | 1.716151 |
| 827 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCB_0_000_A_15_KK | pup | 0 | 1.566844 |
| 851 | King Channel CB_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCB_0_000_A_06_KK | pup | 0 | 3.684751 |
| 875 | King Channel CB_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCB_0_000_A_07_KK | pup | 0 | 0.48725 |
| 933 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCC_0_000_A_1707_KK | pup | 0 | 102.918851 |
| 957 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCC_0_000_A_1505_KK | pup | 0 | 66.01833 |
| 981 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCC_0_000_A_17_KK | pup | 0 | 15.256522 |
| 1005 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCC_0_000_A_15_KK | pup | 0 | 13.660535 |
| 1029 | Mall Channel CC_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCC_0_000_A_06_KK | pup | 0 | 37.920634 |
| 1053 | Mall Channel CC_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCC_0_000_A_07_KK | pup | 0 | 0.0 |
| 1111 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCD_0_000_A_1707_KK | pup | 0 | 2.631537 |
| 1135 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCD_0_000_A_1505_KK | pup | 0 | 1.065317 |
| 1159 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCD_0_000_A_17_KK | pup | 0 | 0.379606 |
| 1183 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCD_0_000_A_15_KK | pup | 0 | 0.215277 |
| 1207 | Instore Channel CD_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCD_0_000_A_06_KK | pup | 0 | 1.569026 |
| 1231 | Instore Channel CD_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCD_0_000_A_07_KK | pup | 0 | 0.0 |
| 1289 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCE_1_000_A_1707_KK | pup | 0 | 5.591645 |
| 1313 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCE_1_000_A_1505_KK | pup | 0 | 2.17239 |
| 1337 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCE_1_000_A_17_KK | pup | 0 | 0.801945 |
| 1361 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCE_1_000_A_15_KK | pup | 0 | 0.435161 |
| 1385 | Doorshow Hotel CE_1_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCE_1_000_A_06_KK | pup | 0 | 1.832114 |
| 1409 | Doorshow Hotel CE_1_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCE_1_000_A_07_KK | pup | 0 | 1.593515 |
| 1467 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCG_0_000_A_1707_KK | pup | 0 | 54.890899 |
| 1491 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCG_0_000_A_1505_KK | pup | 0 | 35.374325 |
| 1515 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCG_0_000_A_17_KK | pup | 0 | 8.620352 |
| 1539 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCG_0_000_A_15_KK | pup | 0 | 7.525465 |
| 1563 | Mobility Channel gesamt CG_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCG_0_000_A_06_KK | pup | 0 | 10.424475 |
| 1587 | Mobility Channel gesamt CG_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCG_0_000_A_07_KK | pup | 0 | 11.453342 |
| 1645 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCG_2_000_A_1707_KK | pup | 0 | 16.352554 |
| 1669 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCG_2_000_A_1505_KK | pup | 0 | 10.935363 |
| 1693 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCG_2_000_A_17_KK | pup | 0 | 2.392431 |
| 1717 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCG_2_000_A_15_KK | pup | 0 | 2.228207 |
| 1741 | Mobility Channel Bistro CG_2_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCG_2_000_A_06_KK | pup | 0 | 2.653312 |
| 1765 | Mobility Channel Bistro CG_2_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCG_2_000_A_07_KK | pup | 0 | 2.896951 |
| 1823 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCG_3_000_A_1707_KK | pup | 0 | 29.953343 |
| 1847 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCG_3_000_A_1505_KK | pup | 0 | 18.489355 |
| 1871 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCG_3_000_A_17_KK | pup | 0 | 4.517616 |
| 1895 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCG_3_000_A_15_KK | pup | 0 | 3.818881 |
| 1919 | Mobility Channel Kasse CG_3_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCG_3_000_A_06_KK | pup | 0 | 5.607838 |
| 1943 | Mobility Channel Kasse CG_3_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCG_3_000_A_07_KK | pup | 0 | 6.655555 |
| 2001 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCG_5_000_A_1707_KK | pup | 0 | 4.952827 |
| 2025 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCG_5_000_A_1505_KK | pup | 0 | 3.067941 |
| 2049 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCG_5_000_A_17_KK | pup | 0 | 0.714189 |
| 2073 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCG_5_000_A_15_KK | pup | 0 | 0.617156 |
| 2097 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCG_5_000_A_06_KK | pup | 0 | 0.925008 |
| 2121 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCG_5_000_A_07_KK | pup | 0 | 0.982639 |
| 2179 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSCG_4_000_A_1707_KK | pup | 0 | 7.505137 |
| 2203 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSCG_4_000_A_1505_KK | pup | 0 | 4.654675 |
| 2227 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSCG_4_000_A_17_KK | pup | 0 | 1.087503 |
| 2251 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCG_4_000_A_15_KK | pup | 0 | 0.939175 |
| 2275 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSCG_4_000_A_06_KK | pup | 0 | 1.407586 |
| 2299 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSCG_4_000_A_07_KK | pup | 0 | 1.495298 |
| 2329 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSEQ_0_000_A_1707_KK | pup | 0 | 62.91157 |
| 2353 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSEQ_0_000_A_1505_KK | pup | 0 | 60.70513 |
| 2377 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSEQ_0_000_A_17_KK | pup | 0 | 9.333708 |
| 2401 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSEQ_0_000_A_15_KK | pup | 0 | 12.562458 |
| 2425 | UniScreens Deutschland EQ_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSEQ_0_000_A_06_KK | pup | 0 | 2.385699 |
| 2449 | UniScreens Deutschland EQ_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSEQ_0_000_A_07_KK | pup | 0 | 0.0 |
| 2479 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSEO_0_000_A_1707_KK | pup | 0 | 2.776745 |
| 2503 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSEO_0_000_A_1505_KK | pup | 0 | 2.106742 |
| 2527 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSEO_0_000_A_17_KK | pup | 0 | 0.398296 |
| 2551 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSEO_0_000_A_15_KK | pup | 0 | 0.422636 |
| 2575 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSEO_0_000_A_06_KK | pup | 0 | 0.442729 |
| 2599 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSEO_0_000_A_07_KK | pup | 0 | 0.231685 |
| 2629 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSEP_0_000_A_1707_KK | pup | 0 | 2.776745 |
| 2653 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSEP_0_000_A_1505_KK | pup | 0 | 2.106742 |
| 2677 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSEP_0_000_A_17_KK | pup | 0 | 0.398296 |
| 2701 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSEP_0_000_A_15_KK | pup | 0 | 0.422636 |
| 2725 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 10-11 Uhr 19 | 1 1 | SPPSEP_0_000_A_06_KK | pup | 0 | 0.442729 |
| 2749 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 10-11 Uhr 19 | 1 1 | SPPSEP_0_000_A_07_KK | pup | 0 | 0.231685 |
| 2779 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSEP_1_000_A_1707_KK | pup | 0 | 2.012441 |
| 2803 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSEP_1_000_A_1505_KK | pup | 0 | 1.526242 |
| 2827 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSEP_1_000_A_17_KK | pup | 0 | 0.288349 |
| 2851 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSEP_1_000_A_15_KK | pup | 0 | 0.305931 |
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);