media_variant
1,542 rows where timerange = 30
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 49 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCA_0_000_A_1707_QQ | pup | 0 | 247.15949 |
| 73 | Goldbach gesamt CA_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCA_0_000_A_1505_QQ | pup | 0 | 166.615909 |
| 97 | Goldbach gesamt CA_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCA_0_000_A_17_QQ | pup | 0 | 37.342573 |
| 121 | Goldbach gesamt CA_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCA_0_000_A_15_QQ | pup | 0 | 34.867116 |
| 145 | Goldbach gesamt CA_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCA_0_000_A_06_QQ | pup | 0 | 75.122664 |
| 169 | Goldbach gesamt CA_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCA_0_000_A_07_QQ | pup | 0 | 10.366311 |
| 227 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCH_0_000_A_1707_QQ | pup | 0 | 3.599166 |
| 251 | Airboards Köln CH_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCH_0_000_A_1505_QQ | pup | 0 | 2.872543 |
| 275 | Airboards Köln CH_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCH_0_000_A_17_QQ | pup | 0 | 0.528718 |
| 299 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCH_0_000_A_15_QQ | pup | 0 | 0.591018 |
| 323 | Airboards Köln CH_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCH_0_000_A_06_QQ | pup | 0 | 0.39196 |
| 347 | Airboards Köln CH_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCH_0_000_A_07_QQ | pup | 0 | 0.348812 |
| 405 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCI_0_000_A_1707_QQ | pup | 0 | 0.151976 |
| 429 | Airboards Paderborn CI_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCI_0_000_A_1505_QQ | pup | 0 | 0.051712 |
| 453 | Airboards Paderborn CI_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCI_0_000_A_17_QQ | pup | 0 | 0.021725 |
| 477 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCI_0_000_A_15_QQ | pup | 0 | 0.010344 |
| 501 | Airboards Paderborn CI_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCI_0_000_A_06_QQ | pup | 0 | 0.080028 |
| 525 | Airboards Paderborn CI_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCI_0_000_A_07_QQ | pup | 0 | 0.020301 |
| 583 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCF_0_000_A_1707_QQ | pup | 0 | 20.912109 |
| 607 | CityNet Tube Bochum CF_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCF_0_000_A_1505_QQ | pup | 0 | 16.685532 |
| 631 | CityNet Tube Bochum CF_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCF_0_000_A_17_QQ | pup | 0 | 3.498127 |
| 655 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCF_0_000_A_15_QQ | pup | 0 | 3.812448 |
| 679 | CityNet Tube Bochum CF_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCF_0_000_A_06_QQ | pup | 0 | 4.123773 |
| 703 | CityNet Tube Bochum CF_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCF_0_000_A_07_QQ | pup | 0 | 1.182579 |
| 761 | King Channel CB_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCB_0_000_A_1707_QQ | pup | 0 | 33.178503 |
| 785 | King Channel CB_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCB_0_000_A_1505_QQ | pup | 0 | 20.512915 |
| 809 | King Channel CB_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCB_0_000_A_17_QQ | pup | 0 | 4.776201 |
| 833 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCB_0_000_A_15_QQ | pup | 0 | 4.125983 |
| 857 | King Channel CB_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCB_0_000_A_06_QQ | pup | 0 | 8.063426 |
| 881 | King Channel CB_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCB_0_000_A_07_QQ | pup | 0 | 4.703882 |
| 939 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCC_0_000_A_1707_QQ | pup | 0 | 135.115777 |
| 963 | Mall Channel CC_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCC_0_000_A_1505_QQ | pup | 0 | 88.858458 |
| 987 | Mall Channel CC_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCC_0_000_A_17_QQ | pup | 0 | 20.150508 |
| 1011 | Mall Channel CC_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCC_0_000_A_15_QQ | pup | 0 | 18.422929 |
| 1035 | Mall Channel CC_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCC_0_000_A_06_QQ | pup | 0 | 48.139258 |
| 1059 | Mall Channel CC_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCC_0_000_A_07_QQ | pup | 0 | 0.0 |
| 1117 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCD_0_000_A_1707_QQ | pup | 0 | 3.911526 |
| 1141 | Instore Channel CD_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCD_0_000_A_1505_QQ | pup | 0 | 3.897552 |
| 1165 | Instore Channel CD_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCD_0_000_A_17_QQ | pup | 0 | 0.574608 |
| 1189 | Instore Channel CD_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCD_0_000_A_15_QQ | pup | 0 | 0.800135 |
| 1213 | Instore Channel CD_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCD_0_000_A_06_QQ | pup | 0 | 0.014045 |
| 1237 | Instore Channel CD_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCD_0_000_A_07_QQ | pup | 0 | 0.0 |
| 1295 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCE_1_000_A_1707_QQ | pup | 0 | 3.338938 |
| 1319 | Doorshow Hotel CE_1_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCE_1_000_A_1505_QQ | pup | 0 | 1.885774 |
| 1343 | Doorshow Hotel CE_1_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCE_1_000_A_17_QQ | pup | 0 | 0.478014 |
| 1367 | Doorshow Hotel CE_1_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCE_1_000_A_15_QQ | pup | 0 | 0.377606 |
| 1391 | Doorshow Hotel CE_1_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCE_1_000_A_06_QQ | pup | 0 | 0.800954 |
| 1415 | Doorshow Hotel CE_1_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCE_1_000_A_07_QQ | pup | 0 | 0.653894 |
| 1473 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCG_0_000_A_1707_QQ | pup | 0 | 48.625034 |
| 1497 | Mobility Channel gesamt CG_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCG_0_000_A_1505_QQ | pup | 0 | 32.634998 |
| 1521 | Mobility Channel gesamt CG_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCG_0_000_A_17_QQ | pup | 0 | 7.351917 |
| 1545 | Mobility Channel gesamt CG_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCG_0_000_A_15_QQ | pup | 0 | 6.760049 |
| 1569 | Mobility Channel gesamt CG_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCG_0_000_A_06_QQ | pup | 0 | 13.6333 |
| 1593 | Mobility Channel gesamt CG_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCG_0_000_A_07_QQ | pup | 0 | 3.459714 |
| 1651 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCG_2_000_A_1707_QQ | pup | 0 | 14.892691 |
| 1675 | Mobility Channel Bistro CG_2_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCG_2_000_A_1505_QQ | pup | 0 | 10.230398 |
| 1699 | Mobility Channel Bistro CG_2_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCG_2_000_A_17_QQ | pup | 0 | 2.165475 |
| 1723 | Mobility Channel Bistro CG_2_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCG_2_000_A_15_QQ | pup | 0 | 2.069602 |
| 1747 | Mobility Channel Bistro CG_2_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCG_2_000_A_06_QQ | pup | 0 | 3.791993 |
| 1771 | Mobility Channel Bistro CG_2_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCG_2_000_A_07_QQ | pup | 0 | 0.966735 |
| 1829 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCG_3_000_A_1707_QQ | pup | 0 | 25.615145 |
| 1853 | Mobility Channel Kasse CG_3_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCG_3_000_A_1505_QQ | pup | 0 | 16.988363 |
| 1877 | Mobility Channel Kasse CG_3_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCG_3_000_A_17_QQ | pup | 0 | 3.769146 |
| 1901 | Mobility Channel Kasse CG_3_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCG_3_000_A_15_QQ | pup | 0 | 3.461643 |
| 1925 | Mobility Channel Kasse CG_3_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCG_3_000_A_06_QQ | pup | 0 | 7.158085 |
| 1949 | Mobility Channel Kasse CG_3_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCG_3_000_A_07_QQ | pup | 0 | 1.766041 |
| 2007 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCG_5_000_A_1707_QQ | pup | 0 | 4.042187 |
| 2031 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCG_5_000_A_1505_QQ | pup | 0 | 2.504985 |
| 2055 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCG_5_000_A_17_QQ | pup | 0 | 0.580323 |
| 2079 | Mobility Channel Eingang - Indoor CG_5_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCG_5_000_A_15_QQ | pup | 0 | 0.502244 |
| 2103 | Mobility Channel Eingang - Indoor CG_5_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCG_5_000_A_06_QQ | pup | 0 | 1.247939 |
| 2127 | Mobility Channel Eingang - Indoor CG_5_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCG_5_000_A_07_QQ | pup | 0 | 0.298331 |
| 2185 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSCG_4_000_A_1707_QQ | pup | 0 | 6.139178 |
| 2209 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSCG_4_000_A_1505_QQ | pup | 0 | 3.807128 |
| 2233 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSCG_4_000_A_17_QQ | pup | 0 | 0.883675 |
| 2257 | Mobility Channel Eingang - Outdoor CG_4_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCG_4_000_A_15_QQ | pup | 0 | 0.764311 |
| 2281 | Mobility Channel Eingang - Outdoor CG_4_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSCG_4_000_A_06_QQ | pup | 0 | 1.899015 |
| 2305 | Mobility Channel Eingang - Outdoor CG_4_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSCG_4_000_A_07_QQ | pup | 0 | 0.453966 |
| 2335 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSEQ_0_000_A_1707_QQ | pup | 0 | 32.724997 |
| 2359 | UniScreens Deutschland EQ_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSEQ_0_000_A_1505_QQ | pup | 0 | 31.67256 |
| 2383 | UniScreens Deutschland EQ_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSEQ_0_000_A_17_QQ | pup | 0 | 4.782241 |
| 2407 | UniScreens Deutschland EQ_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSEQ_0_000_A_15_QQ | pup | 0 | 6.469477 |
| 2431 | UniScreens Deutschland EQ_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSEQ_0_000_A_06_QQ | pup | 0 | 1.081617 |
| 2455 | UniScreens Deutschland EQ_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSEQ_0_000_A_07_QQ | pup | 0 | 0.0 |
| 2485 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSEO_0_000_A_1707_QQ | pup | 0 | 1.475846 |
| 2509 | Flughafen Stuttgart gesamt EO_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSEO_0_000_A_1505_QQ | pup | 0 | 0.956299 |
| 2533 | Flughafen Stuttgart gesamt EO_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSEO_0_000_A_17_QQ | pup | 0 | 0.21132 |
| 2557 | Flughafen Stuttgart gesamt EO_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSEO_0_000_A_15_QQ | pup | 0 | 0.191576 |
| 2581 | Flughafen Stuttgart gesamt EO_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSEO_0_000_A_06_QQ | pup | 0 | 0.27078 |
| 2605 | Flughafen Stuttgart gesamt EO_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSEO_0_000_A_07_QQ | pup | 0 | 0.250406 |
| 2635 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSEP_0_000_A_1707_QQ | pup | 0 | 1.475846 |
| 2659 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSEP_0_000_A_1505_QQ | pup | 0 | 0.956299 |
| 2683 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSEP_0_000_A_17_QQ | pup | 0 | 0.21132 |
| 2707 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSEP_0_000_A_15_QQ | pup | 0 | 0.191576 |
| 2731 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | Sa 1 | 16-17 Uhr 30 | 1 1 | SPPSEP_0_000_A_06_QQ | pup | 0 | 0.27078 |
| 2755 | Flughafen Stuttgart Eigenvermarktung gesamt EP_0_000 | So 2 | 16-17 Uhr 30 | 1 1 | SPPSEP_0_000_A_07_QQ | pup | 0 | 0.250406 |
| 2785 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSEP_1_000_A_1707_QQ | pup | 0 | 1.07171 |
| 2809 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSEP_1_000_A_1505_QQ | pup | 0 | 0.695376 |
| 2833 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSEP_1_000_A_17_QQ | pup | 0 | 0.153357 |
| 2857 | Flughafen Stuttgart Eigenvermarktung Abflugnetz EP_1_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSEP_1_000_A_15_QQ | pup | 0 | 0.13924 |
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);