media_variant
30 rows where media = "FC_F_000"
This data as json, copyable, CSV (advanced)
Suggested facets: weekdays, frequency, extern
| id ▼ | media | weekdays | timerange | frequency | study_code | source | extern | raw_sample |
|---|---|---|---|---|---|---|---|---|
| 19169 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-So 7 | 06-24 Uhr 12 | 2 2 | KPPSFC_F_000_A_1707_GX | pv | 0 | 167.04113 |
| 19170 | Station Video Bremen FC_F_000 | Ø Werktag Mo-Fr 3 | 06-24 Uhr 12 | 2 2 | SPPSFC_F_000_A_15_GX | pv | 0 | 32.41401 |
| 19171 | Station Video Bremen FC_F_000 | Sa 1 | 06-24 Uhr 12 | 2 2 | SPPSFC_F_000_A_06_GX | pv | 0 | 17.38651 |
| 19172 | Station Video Bremen FC_F_000 | So 2 | 06-24 Uhr 12 | 2 2 | SPPSFC_F_000_A_07_GX | pv | 0 | 14.42783 |
| 19268 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-Fr 4 | 06-24 Uhr 12 | 2 2 | KPPSFC_F_000_A_1505_GX | pv | 0 | 140.631071 |
| 38449 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-So 7 | 06-24 Uhr 12 | 8 8 | KPPSFC_F_000_C_1707_GX | pv | 1 | 35.80145 |
| 38450 | Station Video Bremen FC_F_000 | Ø Werktag Mo-Fr 3 | 06-24 Uhr 12 | 8 8 | SPPSFC_F_000_C_15_GX | pv | 1 | 6.18204 |
| 38451 | Station Video Bremen FC_F_000 | Sa 1 | 06-24 Uhr 12 | 8 8 | SPPSFC_F_000_C_06_GX | pv | 1 | 3.29846 |
| 38452 | Station Video Bremen FC_F_000 | So 2 | 06-24 Uhr 12 | 8 8 | SPPSFC_F_000_C_07_GX | pv | 1 | 2.73249 |
| 38548 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-Fr 4 | 06-24 Uhr 12 | 8 8 | KPPSFC_F_000_C_1505_GX | pv | 1 | 29.971595 |
| 41465 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-So 7 | 06-24 Uhr 12 | 22 22 | KPPSFC_F_000_E_1707_GX | pv | 1 | 63.8007 |
| 41466 | Station Video Bremen FC_F_000 | Ø Werktag Mo-Fr 3 | 06-24 Uhr 12 | 22 22 | SPPSFC_F_000_E_15_GX | pv | 1 | 11.29643 |
| 41467 | Station Video Bremen FC_F_000 | Sa 1 | 06-24 Uhr 12 | 22 22 | SPPSFC_F_000_E_06_GX | pv | 1 | 6.03548 |
| 41468 | Station Video Bremen FC_F_000 | So 2 | 06-24 Uhr 12 | 22 22 | SPPSFC_F_000_E_07_GX | pv | 1 | 5.01775 |
| 41564 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-Fr 4 | 06-24 Uhr 12 | 22 22 | KPPSFC_F_000_E_1505_GX | pv | 1 | 53.473791 |
| 43703 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-So 7 | 06-24 Uhr 12 | 25 25 | KPPSFC_F_000_G_1707_GX | pv | 1 | 103.70225 |
| 43704 | Station Video Bremen FC_F_000 | Ø Werktag Mo-Fr 3 | 06-24 Uhr 12 | 25 25 | SPPSFC_F_000_G_15_GX | pv | 1 | 19.01971 |
| 43705 | Station Video Bremen FC_F_000 | Sa 1 | 06-24 Uhr 12 | 25 25 | SPPSFC_F_000_G_06_GX | pv | 1 | 10.18633 |
| 43706 | Station Video Bremen FC_F_000 | So 2 | 06-24 Uhr 12 | 25 25 | SPPSFC_F_000_G_07_GX | pv | 1 | 8.46796 |
| 43802 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-Fr 4 | 06-24 Uhr 12 | 25 25 | KPPSFC_F_000_G_1505_GX | pv | 1 | 87.049838 |
| 43983 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-So 7 | 06-24 Uhr 12 | 28 28 | KPPSFC_F_000_I_1707_GX | pv | 1 | 129.51511 |
| 43984 | Station Video Bremen FC_F_000 | Ø Werktag Mo-Fr 3 | 06-24 Uhr 12 | 28 28 | SPPSFC_F_000_I_15_GX | pv | 1 | 24.2964 |
| 43985 | Station Video Bremen FC_F_000 | Sa 1 | 06-24 Uhr 12 | 28 28 | SPPSFC_F_000_I_06_GX | pv | 1 | 13.0325 |
| 43986 | Station Video Bremen FC_F_000 | So 2 | 06-24 Uhr 12 | 28 28 | SPPSFC_F_000_I_07_GX | pv | 1 | 10.82542 |
| 44082 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-Fr 4 | 06-24 Uhr 12 | 28 28 | KPPSFC_F_000_I_1505_GX | pv | 1 | 108.823866 |
| 44263 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-So 7 | 06-24 Uhr 12 | 30 30 | KPPSFC_F_000_K_1707_GX | pv | 1 | 146.24476 |
| 44264 | Station Video Bremen FC_F_000 | Ø Werktag Mo-Fr 3 | 06-24 Uhr 12 | 30 30 | SPPSFC_F_000_K_15_GX | pv | 1 | 27.83942 |
| 44265 | Station Video Bremen FC_F_000 | Sa 1 | 06-24 Uhr 12 | 30 30 | SPPSFC_F_000_K_06_GX | pv | 1 | 14.92847 |
| 44266 | Station Video Bremen FC_F_000 | So 2 | 06-24 Uhr 12 | 30 30 | SPPSFC_F_000_K_07_GX | pv | 1 | 12.40164 |
| 44362 | Station Video Bremen FC_F_000 | Ø Woche gesamt Mo-Fr 4 | 06-24 Uhr 12 | 30 30 | KPPSFC_F_000_K_1505_GX | pv | 1 | 122.932582 |
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);