media_variant

8 rows where media = "AA_0_000"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: weekdays, frequency

id ▼ media weekdays timerange frequency study_code source extern raw_sample
1 DOOH gesamt AA_0_000 Ø Woche gesamt Mo-So 7 ganztägig 44 1 1 KPPSAA_0_000_A_1707_AX pup 0 14904.815869
2 DOOH gesamt AA_0_000 Ø Woche gesamt Mo-Fr 4 ganztägig 44 1 1 KPPSAA_0_000_A_1505_AX pup 0 13833.594013
3 DOOH gesamt AA_0_000 Sa 1 ganztägig 44 1 1 SPPSAA_0_000_A_06_AX pup 0 12204.889976
4 DOOH gesamt AA_0_000 So 2 ganztägig 44 1 1 SPPSAA_0_000_A_07_AX pup 0 7485.220322
19281 DOOH gesamt AA_0_000 Ø Woche gesamt Mo-So 7 ganztägig 44 17 17 KPPSAA_0_000_C_1707_AX pup 0 13762.122374
19282 DOOH gesamt AA_0_000 Ø Woche gesamt Mo-Fr 4 ganztägig 44 17 17 KPPSAA_0_000_C_1505_AX pup 0 12258.349391
19283 DOOH gesamt AA_0_000 Sa 1 ganztägig 44 17 17 SPPSAA_0_000_C_06_AX pup 0 9665.730131
19284 DOOH gesamt AA_0_000 So 2 ganztägig 44 17 17 SPPSAA_0_000_C_07_AX pup 0 4307.047698

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