24 rows where media = "FB_F_000"

View and edit SQL

Suggested facets: weekdays, frequency, extern

id ▼ media weekdays timerange frequency study_code source extern raw_sample
14797 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Sa 5 09-21 Uhr 18 2 2 KPPSFB_F_000_A_1606_JU pv 0 63.875623
14798 Public Video Mall Bremen FB_F_000 Ø Werktag Mo-Fr 3 09-21 Uhr 18 2 2 SPPSFB_F_000_A_15_JU pv 0 9.28036
14799 Public Video Mall Bremen FB_F_000 Sa 1 09-21 Uhr 18 2 2 SPPSFB_F_000_A_06_JU pv 0 22.90505
14948 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Fr 4 09-21 Uhr 18 2 2 KPPSFB_F_000_A_1505_JU pv 0 43.558247
29934 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Sa 5 09-21 Uhr 18 7 7 KPPSFB_F_000_C_1606_JU pv 1 29.211122
29935 Public Video Mall Bremen FB_F_000 Ø Werktag Mo-Fr 3 09-21 Uhr 18 7 7 SPPSFB_F_000_C_15_JU pv 1 4.01947
29936 Public Video Mall Bremen FB_F_000 Sa 1 09-21 Uhr 18 7 7 SPPSFB_F_000_C_06_JU pv 1 9.9502
30085 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Fr 4 09-21 Uhr 18 7 7 KPPSFB_F_000_C_1505_JU pv 1 19.66909
32767 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Sa 5 09-21 Uhr 18 20 20 KPPSFB_F_000_E_1606_JU pv 1 42.394151
32768 Public Video Mall Bremen FB_F_000 Ø Werktag Mo-Fr 3 09-21 Uhr 18 20 20 SPPSFB_F_000_E_15_JU pv 1 5.91729
32769 Public Video Mall Bremen FB_F_000 Sa 1 09-21 Uhr 18 20 20 SPPSFB_F_000_E_06_JU pv 1 14.67661
32918 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Fr 4 09-21 Uhr 18 20 20 KPPSFB_F_000_E_1505_JU pv 1 28.624587
34822 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Sa 5 09-21 Uhr 18 23 23 KPPSFB_F_000_G_1606_JU pv 1 53.260179
34823 Public Video Mall Bremen FB_F_000 Ø Werktag Mo-Fr 3 09-21 Uhr 18 23 23 SPPSFB_F_000_G_15_JU pv 1 7.55529
34824 Public Video Mall Bremen FB_F_000 Sa 1 09-21 Uhr 18 23 23 SPPSFB_F_000_G_06_JU pv 1 18.72817
34973 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Fr 4 09-21 Uhr 18 23 23 KPPSFB_F_000_G_1505_JU pv 1 36.09031
35097 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Sa 5 09-21 Uhr 18 26 26 KPPSFB_F_000_I_1606_JU pv 1 57.722486
35098 Public Video Mall Bremen FB_F_000 Ø Werktag Mo-Fr 3 09-21 Uhr 18 26 26 SPPSFB_F_000_I_15_JU pv 1 8.25792
35099 Public Video Mall Bremen FB_F_000 Sa 1 09-21 Uhr 18 26 26 SPPSFB_F_000_I_06_JU pv 1 20.48172
35248 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Fr 4 09-21 Uhr 18 26 26 KPPSFB_F_000_I_1505_JU pv 1 39.178101
35372 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Sa 5 09-21 Uhr 18 28 28 KPPSFB_F_000_K_1606_JU pv 1 60.242093
35373 Public Video Mall Bremen FB_F_000 Ø Werktag Mo-Fr 3 09-21 Uhr 18 28 28 SPPSFB_F_000_K_15_JU pv 1 8.66607
35374 Public Video Mall Bremen FB_F_000 Sa 1 09-21 Uhr 18 28 28 SPPSFB_F_000_K_06_JU pv 1 21.49512
35523 Public Video Mall Bremen FB_F_000 Ø Woche gesamt Mo-Fr 4 09-21 Uhr 18 28 28 KPPSFB_F_000_K_1505_JU pv 1 40.934761

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);