media_variant
300 rows where media = "DB_0_000"
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, timerange, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 4059 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | ganztägig 44 | 1 1 | KPPSDB_0_000_A_1707_AX | pup | 0 | 211.114121 |
| 4060 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | ganztägig 44 | 1 1 | KPPSDB_0_000_A_1505_AX | pup | 0 | 197.492942 |
| 4061 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | ganztägig 44 | 1 1 | SPPSDB_0_000_A_17_AX | pup | 0 | 35.343452 |
| 4062 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | ganztägig 44 | 1 1 | SPPSDB_0_000_A_15_AX | pup | 0 | 45.647421 |
| 4063 | Public Video Campus DB_0_000 | Sa 1 | ganztägig 44 | 1 1 | SPPSDB_0_000_A_06_AX | pup | 0 | 16.645343 |
| 4064 | Public Video Campus DB_0_000 | So 2 | ganztägig 44 | 1 1 | SPPSDB_0_000_A_07_AX | pup | 0 | 0.0 |
| 4065 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 06-07 Uhr 9 | 1 1 | KPPSDB_0_000_A_1707_GG | pup | 0 | 3.863698 |
| 4066 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 07-08 Uhr 13 | 1 1 | KPPSDB_0_000_A_1707_HH | pup | 0 | 18.173758 |
| 4067 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 08-09 Uhr 14 | 1 1 | KPPSDB_0_000_A_1707_II | pup | 0 | 33.344782 |
| 4068 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 09-10 Uhr 16 | 1 1 | KPPSDB_0_000_A_1707_JJ | pup | 0 | 28.232682 |
| 4069 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 10-11 Uhr 19 | 1 1 | KPPSDB_0_000_A_1707_KK | pup | 0 | 25.156496 |
| 4070 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 11-12 Uhr 21 | 1 1 | KPPSDB_0_000_A_1707_LL | pup | 0 | 23.504634 |
| 4071 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 12-13 Uhr 22 | 1 1 | KPPSDB_0_000_A_1707_MM | pup | 0 | 23.117379 |
| 4072 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 13-14 Uhr 25 | 1 1 | KPPSDB_0_000_A_1707_NN | pup | 0 | 23.322824 |
| 4073 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 14-15 Uhr 26 | 1 1 | KPPSDB_0_000_A_1707_OO | pup | 0 | 19.988733 |
| 4074 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 15-16 Uhr 28 | 1 1 | KPPSDB_0_000_A_1707_PP | pup | 0 | 17.590868 |
| 4075 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 16-17 Uhr 30 | 1 1 | KPPSDB_0_000_A_1707_QQ | pup | 0 | 13.743797 |
| 4076 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 17-18 Uhr 32 | 1 1 | KPPSDB_0_000_A_1707_RR | pup | 0 | 9.430038 |
| 4077 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 18-19 Uhr 33 | 1 1 | KPPSDB_0_000_A_1707_SS | pup | 0 | 5.23392 |
| 4078 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 19-20 Uhr 36 | 1 1 | KPPSDB_0_000_A_1707_TT | pup | 0 | 2.966293 |
| 4079 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 20-21 Uhr 37 | 1 1 | KPPSDB_0_000_A_1707_UU | pup | 0 | 1.977785 |
| 4080 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 21-22 Uhr 39 | 1 1 | KPPSDB_0_000_A_1707_VV | pup | 0 | 0.0 |
| 4081 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 22-23 Uhr 41 | 1 1 | KPPSDB_0_000_A_1707_WW | pup | 0 | 0.0 |
| 4082 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 23-24 Uhr 43 | 1 1 | KPPSDB_0_000_A_1707_XX | pup | 0 | 0.0 |
| 4083 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 00-01 Uhr 1 | 1 1 | KPPSDB_0_000_A_1707_AA | pup | 0 | 0.0 |
| 4084 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 01-02 Uhr 3 | 1 1 | KPPSDB_0_000_A_1707_BB | pup | 0 | 0.0 |
| 4085 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 02-03 Uhr 4 | 1 1 | KPPSDB_0_000_A_1707_CC | pup | 0 | 0.0 |
| 4086 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 03-04 Uhr 5 | 1 1 | KPPSDB_0_000_A_1707_DD | pup | 0 | 0.0 |
| 4087 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 04-05 Uhr 6 | 1 1 | KPPSDB_0_000_A_1707_EE | pup | 0 | 0.0 |
| 4088 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-So 7 | 05-06 Uhr 8 | 1 1 | KPPSDB_0_000_A_1707_FF | pup | 0 | 0.0 |
| 4089 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 06-07 Uhr 9 | 1 1 | KPPSDB_0_000_A_1505_GG | pup | 0 | 3.288566 |
| 4090 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 07-08 Uhr 13 | 1 1 | KPPSDB_0_000_A_1505_HH | pup | 0 | 17.287814 |
| 4091 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 08-09 Uhr 14 | 1 1 | KPPSDB_0_000_A_1505_II | pup | 0 | 31.586298 |
| 4092 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 09-10 Uhr 16 | 1 1 | KPPSDB_0_000_A_1505_JJ | pup | 0 | 26.733335 |
| 4093 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 10-11 Uhr 19 | 1 1 | KPPSDB_0_000_A_1505_KK | pup | 0 | 23.30764 |
| 4094 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 11-12 Uhr 21 | 1 1 | KPPSDB_0_000_A_1505_LL | pup | 0 | 21.577023 |
| 4095 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 12-13 Uhr 22 | 1 1 | KPPSDB_0_000_A_1505_MM | pup | 0 | 21.428614 |
| 4096 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 13-14 Uhr 25 | 1 1 | KPPSDB_0_000_A_1505_NN | pup | 0 | 21.611785 |
| 4097 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 14-15 Uhr 26 | 1 1 | KPPSDB_0_000_A_1505_OO | pup | 0 | 18.695851 |
| 4098 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 15-16 Uhr 28 | 1 1 | KPPSDB_0_000_A_1505_PP | pup | 0 | 16.409088 |
| 4099 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 16-17 Uhr 30 | 1 1 | KPPSDB_0_000_A_1505_QQ | pup | 0 | 12.668375 |
| 4100 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 17-18 Uhr 32 | 1 1 | KPPSDB_0_000_A_1505_RR | pup | 0 | 8.729631 |
| 4101 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 18-19 Uhr 33 | 1 1 | KPPSDB_0_000_A_1505_SS | pup | 0 | 4.997777 |
| 4102 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 19-20 Uhr 36 | 1 1 | KPPSDB_0_000_A_1505_TT | pup | 0 | 2.707054 |
| 4103 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 20-21 Uhr 37 | 1 1 | KPPSDB_0_000_A_1505_UU | pup | 0 | 1.807194 |
| 4104 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 21-22 Uhr 39 | 1 1 | KPPSDB_0_000_A_1505_VV | pup | 0 | 0.0 |
| 4105 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 22-23 Uhr 41 | 1 1 | KPPSDB_0_000_A_1505_WW | pup | 0 | 0.0 |
| 4106 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 23-24 Uhr 43 | 1 1 | KPPSDB_0_000_A_1505_XX | pup | 0 | 0.0 |
| 4107 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 00-01 Uhr 1 | 1 1 | KPPSDB_0_000_A_1505_AA | pup | 0 | 0.0 |
| 4108 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 01-02 Uhr 3 | 1 1 | KPPSDB_0_000_A_1505_BB | pup | 0 | 0.0 |
| 4109 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 02-03 Uhr 4 | 1 1 | KPPSDB_0_000_A_1505_CC | pup | 0 | 0.0 |
| 4110 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 03-04 Uhr 5 | 1 1 | KPPSDB_0_000_A_1505_DD | pup | 0 | 0.0 |
| 4111 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 04-05 Uhr 6 | 1 1 | KPPSDB_0_000_A_1505_EE | pup | 0 | 0.0 |
| 4112 | Public Video Campus DB_0_000 | Ø Woche gesamt Mo-Fr 4 | 05-06 Uhr 8 | 1 1 | KPPSDB_0_000_A_1505_FF | pup | 0 | 0.0 |
| 4113 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 06-07 Uhr 9 | 1 1 | SPPSDB_0_000_A_17_GG | pup | 0 | 0.554408 |
| 4114 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 07-08 Uhr 13 | 1 1 | SPPSDB_0_000_A_17_HH | pup | 0 | 2.638416 |
| 4115 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 08-09 Uhr 14 | 1 1 | SPPSDB_0_000_A_17_II | pup | 0 | 4.875802 |
| 4116 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 09-10 Uhr 16 | 1 1 | SPPSDB_0_000_A_17_JJ | pup | 0 | 4.125247 |
| 4117 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 10-11 Uhr 19 | 1 1 | SPPSDB_0_000_A_17_KK | pup | 0 | 3.659962 |
| 4118 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 11-12 Uhr 21 | 1 1 | SPPSDB_0_000_A_17_LL | pup | 0 | 3.416015 |
| 4119 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 12-13 Uhr 22 | 1 1 | SPPSDB_0_000_A_17_MM | pup | 0 | 3.35887 |
| 4120 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 13-14 Uhr 25 | 1 1 | SPPSDB_0_000_A_17_NN | pup | 0 | 3.390644 |
| 4121 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 14-15 Uhr 26 | 1 1 | SPPSDB_0_000_A_17_OO | pup | 0 | 2.899504 |
| 4122 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 15-16 Uhr 28 | 1 1 | SPPSDB_0_000_A_17_PP | pup | 0 | 2.545902 |
| 4123 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 16-17 Uhr 30 | 1 1 | SPPSDB_0_000_A_17_QQ | pup | 0 | 1.989028 |
| 4124 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 17-18 Uhr 32 | 1 1 | SPPSDB_0_000_A_17_RR | pup | 0 | 1.35766 |
| 4125 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 18-19 Uhr 33 | 1 1 | SPPSDB_0_000_A_17_SS | pup | 0 | 0.751553 |
| 4126 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 19-20 Uhr 36 | 1 1 | SPPSDB_0_000_A_17_TT | pup | 0 | 0.424907 |
| 4127 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 20-21 Uhr 37 | 1 1 | SPPSDB_0_000_A_17_UU | pup | 0 | 0.283181 |
| 4128 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 21-22 Uhr 39 | 1 1 | SPPSDB_0_000_A_17_VV | pup | 0 | 0.0 |
| 4129 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 22-23 Uhr 41 | 1 1 | SPPSDB_0_000_A_17_WW | pup | 0 | 0.0 |
| 4130 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 23-24 Uhr 43 | 1 1 | SPPSDB_0_000_A_17_XX | pup | 0 | 0.0 |
| 4131 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 00-01 Uhr 1 | 1 1 | SPPSDB_0_000_A_17_AA | pup | 0 | 0.0 |
| 4132 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 01-02 Uhr 3 | 1 1 | SPPSDB_0_000_A_17_BB | pup | 0 | 0.0 |
| 4133 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 02-03 Uhr 4 | 1 1 | SPPSDB_0_000_A_17_CC | pup | 0 | 0.0 |
| 4134 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 03-04 Uhr 5 | 1 1 | SPPSDB_0_000_A_17_DD | pup | 0 | 0.0 |
| 4135 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 04-05 Uhr 6 | 1 1 | SPPSDB_0_000_A_17_EE | pup | 0 | 0.0 |
| 4136 | Public Video Campus DB_0_000 | Ø Wochentag Mo-So 6 | 05-06 Uhr 8 | 1 1 | SPPSDB_0_000_A_17_FF | pup | 0 | 0.0 |
| 4137 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 06-07 Uhr 9 | 1 1 | SPPSDB_0_000_A_15_GG | pup | 0 | 0.660378 |
| 4138 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 07-08 Uhr 13 | 1 1 | SPPSDB_0_000_A_15_HH | pup | 0 | 3.509759 |
| 4139 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 08-09 Uhr 14 | 1 1 | SPPSDB_0_000_A_15_II | pup | 0 | 6.4543 |
| 4140 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 09-10 Uhr 16 | 1 1 | SPPSDB_0_000_A_15_JJ | pup | 0 | 5.458832 |
| 4141 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 10-11 Uhr 19 | 1 1 | SPPSDB_0_000_A_15_KK | pup | 0 | 4.739985 |
| 4142 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 11-12 Uhr 21 | 1 1 | SPPSDB_0_000_A_15_LL | pup | 0 | 4.382868 |
| 4143 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 12-13 Uhr 22 | 1 1 | SPPSDB_0_000_A_15_MM | pup | 0 | 4.351626 |
| 4144 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 13-14 Uhr 25 | 1 1 | SPPSDB_0_000_A_15_NN | pup | 0 | 4.392551 |
| 4145 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 14-15 Uhr 26 | 1 1 | SPPSDB_0_000_A_15_OO | pup | 0 | 3.792475 |
| 4146 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 15-16 Uhr 28 | 1 1 | SPPSDB_0_000_A_15_PP | pup | 0 | 3.321696 |
| 4147 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 16-17 Uhr 30 | 1 1 | SPPSDB_0_000_A_15_QQ | pup | 0 | 2.565013 |
| 4148 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 17-18 Uhr 32 | 1 1 | SPPSDB_0_000_A_15_RR | pup | 0 | 1.758425 |
| 4149 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 18-19 Uhr 33 | 1 1 | SPPSDB_0_000_A_15_SS | pup | 0 | 1.004386 |
| 4150 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 19-20 Uhr 36 | 1 1 | SPPSDB_0_000_A_15_TT | pup | 0 | 0.542748 |
| 4151 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 20-21 Uhr 37 | 1 1 | SPPSDB_0_000_A_15_UU | pup | 0 | 0.362216 |
| 4152 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 21-22 Uhr 39 | 1 1 | SPPSDB_0_000_A_15_VV | pup | 0 | 0.0 |
| 4153 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 22-23 Uhr 41 | 1 1 | SPPSDB_0_000_A_15_WW | pup | 0 | 0.0 |
| 4154 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 23-24 Uhr 43 | 1 1 | SPPSDB_0_000_A_15_XX | pup | 0 | 0.0 |
| 4155 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 00-01 Uhr 1 | 1 1 | SPPSDB_0_000_A_15_AA | pup | 0 | 0.0 |
| 4156 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 01-02 Uhr 3 | 1 1 | SPPSDB_0_000_A_15_BB | pup | 0 | 0.0 |
| 4157 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 02-03 Uhr 4 | 1 1 | SPPSDB_0_000_A_15_CC | pup | 0 | 0.0 |
| 4158 | Public Video Campus DB_0_000 | Ø Werktag Mo-Fr 3 | 03-04 Uhr 5 | 1 1 | SPPSDB_0_000_A_15_DD | 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 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);