media_variant
5,354 rows where weekdays = 3
This data as json, copyable, CSV (advanced)
Suggested facets: frequency, source, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 4 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | ganztägig 44 | 1 1 | SPPSCH_0_000_A_15_AX | pup | 0 | 18.613135 |
| 107 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 06-07 Uhr 9 | 1 1 | SPPSCH_0_000_A_15_GG | pup | 0 | 1.097389 |
| 108 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 07-08 Uhr 13 | 1 1 | SPPSCH_0_000_A_15_HH | pup | 0 | 1.941181 |
| 109 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 08-09 Uhr 14 | 1 1 | SPPSCH_0_000_A_15_II | pup | 0 | 2.470758 |
| 110 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCH_0_000_A_15_JJ | pup | 0 | 1.215281 |
| 111 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCH_0_000_A_15_KK | pup | 0 | 1.195913 |
| 112 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCH_0_000_A_15_LL | pup | 0 | 0.980013 |
| 113 | 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.763845 |
| 114 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 13-14 Uhr 25 | 1 1 | SPPSCH_0_000_A_15_NN | pup | 0 | 1.134422 |
| 115 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 14-15 Uhr 26 | 1 1 | SPPSCH_0_000_A_15_OO | pup | 0 | 1.004672 |
| 116 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCH_0_000_A_15_PP | pup | 0 | 0.993458 |
| 117 | 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.852883 |
| 118 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCH_0_000_A_15_RR | pup | 0 | 0.802643 |
| 119 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 18-19 Uhr 33 | 1 1 | SPPSCH_0_000_A_15_SS | pup | 0 | 0.855734 |
| 120 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 19-20 Uhr 36 | 1 1 | SPPSCH_0_000_A_15_TT | pup | 0 | 0.672026 |
| 121 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCH_0_000_A_15_UU | pup | 0 | 0.975987 |
| 122 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 21-22 Uhr 39 | 1 1 | SPPSCH_0_000_A_15_VV | pup | 0 | 0.87184 |
| 123 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCH_0_000_A_15_WW | pup | 0 | 0.762217 |
| 124 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCH_0_000_A_15_XX | pup | 0 | 0.500786 |
| 125 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 00-01 Uhr 1 | 1 1 | SPPSCH_0_000_A_15_AA | pup | 0 | 0.194684 |
| 126 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 01-02 Uhr 3 | 1 1 | SPPSCH_0_000_A_15_BB | pup | 0 | 0.296626 |
| 127 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 02-03 Uhr 4 | 1 1 | SPPSCH_0_000_A_15_CC | pup | 0 | 0.256667 |
| 128 | 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.257427 |
| 129 | Airboards Köln CH_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCH_0_000_A_15_EE | pup | 0 | 0.318309 |
| 130 | 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.16068 |
| 182 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | ganztägig 44 | 1 1 | SPPSCI_0_000_A_15_AX | pup | 0 | 0.882211 |
| 285 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 06-07 Uhr 9 | 1 1 | SPPSCI_0_000_A_15_GG | pup | 0 | 0.043119 |
| 286 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 07-08 Uhr 13 | 1 1 | SPPSCI_0_000_A_15_HH | pup | 0 | 0.106421 |
| 287 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 08-09 Uhr 14 | 1 1 | SPPSCI_0_000_A_15_II | pup | 0 | 0.109096 |
| 288 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCI_0_000_A_15_JJ | pup | 0 | 0.067214 |
| 289 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCI_0_000_A_15_KK | pup | 0 | 0.054267 |
| 290 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCI_0_000_A_15_LL | pup | 0 | 0.035308 |
| 291 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCI_0_000_A_15_MM | pup | 0 | 0.035896 |
| 292 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 13-14 Uhr 25 | 1 1 | SPPSCI_0_000_A_15_NN | pup | 0 | 0.043957 |
| 293 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 14-15 Uhr 26 | 1 1 | SPPSCI_0_000_A_15_OO | pup | 0 | 0.036167 |
| 294 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCI_0_000_A_15_PP | pup | 0 | 0.033294 |
| 295 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCI_0_000_A_15_QQ | pup | 0 | 0.021394 |
| 296 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCI_0_000_A_15_RR | pup | 0 | 0.02579 |
| 297 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 18-19 Uhr 33 | 1 1 | SPPSCI_0_000_A_15_SS | pup | 0 | 0.031399 |
| 298 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 19-20 Uhr 36 | 1 1 | SPPSCI_0_000_A_15_TT | pup | 0 | 0.053706 |
| 299 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCI_0_000_A_15_UU | pup | 0 | 0.025487 |
| 300 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 21-22 Uhr 39 | 1 1 | SPPSCI_0_000_A_15_VV | pup | 0 | 0.042229 |
| 301 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCI_0_000_A_15_WW | pup | 0 | 0.024685 |
| 302 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCI_0_000_A_15_XX | pup | 0 | 0.026245 |
| 303 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 00-01 Uhr 1 | 1 1 | SPPSCI_0_000_A_15_AA | pup | 0 | 0.015686 |
| 304 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 01-02 Uhr 3 | 1 1 | SPPSCI_0_000_A_15_BB | pup | 0 | 0.00804 |
| 305 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 02-03 Uhr 4 | 1 1 | SPPSCI_0_000_A_15_CC | pup | 0 | 0.016642 |
| 306 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCI_0_000_A_15_DD | pup | 0 | 0.013926 |
| 307 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCI_0_000_A_15_EE | pup | 0 | 0.011003 |
| 308 | Airboards Paderborn CI_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCI_0_000_A_15_FF | pup | 0 | 0.008254 |
| 360 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | ganztägig 44 | 1 1 | SPPSCF_0_000_A_15_AX | pup | 0 | 38.535615 |
| 463 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 06-07 Uhr 9 | 1 1 | SPPSCF_0_000_A_15_GG | pup | 0 | 2.93188 |
| 464 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 07-08 Uhr 13 | 1 1 | SPPSCF_0_000_A_15_HH | pup | 0 | 5.478928 |
| 465 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 08-09 Uhr 14 | 1 1 | SPPSCF_0_000_A_15_II | pup | 0 | 5.474532 |
| 466 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCF_0_000_A_15_JJ | pup | 0 | 3.666269 |
| 467 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCF_0_000_A_15_KK | pup | 0 | 2.919589 |
| 468 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCF_0_000_A_15_LL | pup | 0 | 2.293449 |
| 469 | 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.325302 |
| 470 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 13-14 Uhr 25 | 1 1 | SPPSCF_0_000_A_15_NN | pup | 0 | 3.773824 |
| 471 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 14-15 Uhr 26 | 1 1 | SPPSCF_0_000_A_15_OO | pup | 0 | 4.144444 |
| 472 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCF_0_000_A_15_PP | pup | 0 | 3.302244 |
| 473 | 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.770415 |
| 474 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCF_0_000_A_15_RR | pup | 0 | 4.400916 |
| 475 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 18-19 Uhr 33 | 1 1 | SPPSCF_0_000_A_15_SS | pup | 0 | 3.106127 |
| 476 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 19-20 Uhr 36 | 1 1 | SPPSCF_0_000_A_15_TT | pup | 0 | 1.752249 |
| 477 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCF_0_000_A_15_UU | pup | 0 | 1.208901 |
| 478 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 21-22 Uhr 39 | 1 1 | SPPSCF_0_000_A_15_VV | pup | 0 | 0.805053 |
| 479 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCF_0_000_A_15_WW | pup | 0 | 0.651013 |
| 480 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCF_0_000_A_15_XX | pup | 0 | 1.059308 |
| 481 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 00-01 Uhr 1 | 1 1 | SPPSCF_0_000_A_15_AA | pup | 0 | 0.0 |
| 482 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 01-02 Uhr 3 | 1 1 | SPPSCF_0_000_A_15_BB | pup | 0 | 0.0 |
| 483 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 02-03 Uhr 4 | 1 1 | SPPSCF_0_000_A_15_CC | pup | 0 | 0.0 |
| 484 | 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 |
| 485 | CityNet Tube Bochum CF_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCF_0_000_A_15_EE | pup | 0 | 0.0 |
| 486 | 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 |
| 538 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | ganztägig 44 | 1 1 | SPPSCB_0_000_A_15_AX | pup | 0 | 75.374777 |
| 641 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 06-07 Uhr 9 | 1 1 | SPPSCB_0_000_A_15_GG | pup | 0 | 0.933625 |
| 642 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 07-08 Uhr 13 | 1 1 | SPPSCB_0_000_A_15_HH | pup | 0 | 1.476297 |
| 643 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 08-09 Uhr 14 | 1 1 | SPPSCB_0_000_A_15_II | pup | 0 | 1.907452 |
| 644 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSCB_0_000_A_15_JJ | pup | 0 | 1.141952 |
| 645 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSCB_0_000_A_15_KK | pup | 0 | 1.755054 |
| 646 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSCB_0_000_A_15_LL | pup | 0 | 3.183894 |
| 647 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSCB_0_000_A_15_MM | pup | 0 | 8.494724 |
| 648 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 13-14 Uhr 25 | 1 1 | SPPSCB_0_000_A_15_NN | pup | 0 | 7.173699 |
| 649 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 14-15 Uhr 26 | 1 1 | SPPSCB_0_000_A_15_OO | pup | 0 | 4.005239 |
| 650 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSCB_0_000_A_15_PP | pup | 0 | 4.164426 |
| 651 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSCB_0_000_A_15_QQ | pup | 0 | 4.66154 |
| 652 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSCB_0_000_A_15_RR | pup | 0 | 8.877745 |
| 653 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 18-19 Uhr 33 | 1 1 | SPPSCB_0_000_A_15_SS | pup | 0 | 9.120318 |
| 654 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 19-20 Uhr 36 | 1 1 | SPPSCB_0_000_A_15_TT | pup | 0 | 5.669145 |
| 655 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSCB_0_000_A_15_UU | pup | 0 | 3.74063 |
| 656 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 21-22 Uhr 39 | 1 1 | SPPSCB_0_000_A_15_VV | pup | 0 | 2.414535 |
| 657 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSCB_0_000_A_15_WW | pup | 0 | 2.863239 |
| 658 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSCB_0_000_A_15_XX | pup | 0 | 1.470852 |
| 659 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 00-01 Uhr 1 | 1 1 | SPPSCB_0_000_A_15_AA | pup | 0 | 0.266741 |
| 660 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 01-02 Uhr 3 | 1 1 | SPPSCB_0_000_A_15_BB | pup | 0 | 2.728511 |
| 661 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 02-03 Uhr 4 | 1 1 | SPPSCB_0_000_A_15_CC | pup | 0 | 0.350411 |
| 662 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSCB_0_000_A_15_DD | pup | 0 | 0.369901 |
| 663 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 04-05 Uhr 6 | 1 1 | SPPSCB_0_000_A_15_EE | pup | 0 | 0.15961 |
| 664 | King Channel CB_0_000 | Ø Werktag Mo-Fr 3 | 05-06 Uhr 8 | 1 1 | SPPSCB_0_000_A_15_FF | pup | 0 | 0.297668 |
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 INDEX ix_media_variant_weekdays ON media_variant (weekdays); CREATE INDEX ix_media_variant_extern ON media_variant (extern); CREATE INDEX ix_media_variant_timerange ON media_variant (timerange); CREATE INDEX ix_media_variant_media ON media_variant (media); CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code); CREATE INDEX ix_media_variant_source ON media_variant (source); CREATE INDEX ix_media_variant_frequency ON media_variant (frequency);