810 rows where timerange = 12

View and edit SQL

Suggested facets: media, weekdays, frequency, extern

id ▼ media weekdays timerange frequency study_code source extern raw_sample
14713 Public Video Infoscreen Deutschland FA_A_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_A_000_A_1707_GX pv 0 3435.94502
14720 Public Video Infoscreen Deutschland FA_A_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_A_000_A_15_GX pv 0 1091.25898
14727 Public Video Infoscreen Deutschland FA_A_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_A_000_A_06_GX pv 0 607.775109
14734 Public Video Infoscreen Deutschland FA_A_000 So 2 06-24 Uhr 12 2 2 SPPSFA_A_000_A_07_GX pv 0 452.804412
14741 Public Video Infoscreen Hamburg FA_G_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_G_000_A_1707_GX pv 0 838.199889
14742 Public Video Infoscreen Hamburg FA_G_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_G_000_A_15_GX pv 0 248.622151
14743 Public Video Infoscreen Hamburg FA_G_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_G_000_A_06_GX pv 0 127.86541
14744 Public Video Infoscreen Hamburg FA_G_000 So 2 06-24 Uhr 12 2 2 SPPSFA_G_000_A_07_GX pv 0 99.054
14745 Public Video Infoscreen Niedersachsen FA_J_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_J_000_A_1707_GX pv 0 280.976609
14746 Public Video Infoscreen Niedersachsen FA_J_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_J_000_A_15_GX pv 0 66.09305
14747 Public Video Infoscreen Niedersachsen FA_J_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_J_000_A_06_GX pv 0 35.93508
14748 Public Video Infoscreen Niedersachsen FA_J_000 So 2 06-24 Uhr 12 2 2 SPPSFA_J_000_A_07_GX pv 0 25.77195
14749 Public Video Infoscreen Nordrhein-Westfalen FA_K_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_K_000_A_1707_GX pv 0 581.222979
14750 Public Video Infoscreen Nordrhein-Westfalen FA_K_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_K_000_A_15_GX pv 0 145.90815
14751 Public Video Infoscreen Nordrhein-Westfalen FA_K_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_K_000_A_06_GX pv 0 79.32052
14752 Public Video Infoscreen Nordrhein-Westfalen FA_K_000 So 2 06-24 Uhr 12 2 2 SPPSFA_K_000_A_07_GX pv 0 62.27613
14753 Public Video Infoscreen Hessen FA_H_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_H_000_A_1707_GX pv 0 879.648391
14754 Public Video Infoscreen Hessen FA_H_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_H_000_A_15_GX pv 0 192.52586
14755 Public Video Infoscreen Hessen FA_H_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_H_000_A_06_GX pv 0 98.76995
14756 Public Video Infoscreen Hessen FA_H_000 So 2 06-24 Uhr 12 2 2 SPPSFA_H_000_A_07_GX pv 0 73.15801
14757 Public Video Infoscreen Baden-Württemberg FA_B_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_B_000_A_1707_GX pv 0 411.343049
14758 Public Video Infoscreen Baden-Württemberg FA_B_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_B_000_A_15_GX pv 0 100.02364
14759 Public Video Infoscreen Baden-Württemberg FA_B_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_B_000_A_06_GX pv 0 51.8867
14760 Public Video Infoscreen Baden-Württemberg FA_B_000 So 2 06-24 Uhr 12 2 2 SPPSFA_B_000_A_07_GX pv 0 38.44173
14761 Public Video Infoscreen Bayern FA_C_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_C_000_A_1707_GX pv 0 920.575251
14762 Public Video Infoscreen Bayern FA_C_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_C_000_A_15_GX pv 0 279.585811
14763 Public Video Infoscreen Bayern FA_C_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_C_000_A_06_GX pv 0 156.83801
14764 Public Video Infoscreen Bayern FA_C_000 So 2 06-24 Uhr 12 2 2 SPPSFA_C_000_A_07_GX pv 0 118.26279
14765 Public Video Infoscreen Berlin FA_D_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_D_000_A_1707_GX pv 0 558.379129
14766 Public Video Infoscreen Berlin FA_D_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_D_000_A_15_GX pv 0 164.63282
14767 Public Video Infoscreen Berlin FA_D_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_D_000_A_06_GX pv 0 83.02686
14768 Public Video Infoscreen Berlin FA_D_000 So 2 06-24 Uhr 12 2 2 SPPSFA_D_000_A_07_GX pv 0 51.14982
14769 Public Video Infoscreen Sachsen FA_N_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFA_N_000_A_1707_GX pv 0 224.03814
14770 Public Video Infoscreen Sachsen FA_N_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFA_N_000_A_15_GX pv 0 45.60668
14771 Public Video Infoscreen Sachsen FA_N_000 Sa 1 06-24 Uhr 12 2 2 SPPSFA_N_000_A_06_GX pv 0 23.13488
14772 Public Video Infoscreen Sachsen FA_N_000 So 2 06-24 Uhr 12 2 2 SPPSFA_N_000_A_07_GX pv 0 18.39744
14833 Public Video Station Deutschland FC_A_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_A_000_A_1707_GX pv 0 4698.97858
14840 Public Video Station Deutschland FC_A_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_A_000_A_15_GX pv 0 1763.480422
14847 Public Video Station Deutschland FC_A_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_A_000_A_06_GX pv 0 1049.93862
14854 Public Video Station Deutschland FC_A_000 So 2 06-24 Uhr 12 2 2 SPPSFC_A_000_A_07_GX pv 0 803.874729
14861 Public Video Station Schleswig-Holstein FC_P_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_P_000_A_1707_GX pv 0 62.18864
14862 Public Video Station Schleswig-Holstein FC_P_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_P_000_A_15_GX pv 0 11.36838
14863 Public Video Station Schleswig-Holstein FC_P_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_P_000_A_06_GX pv 0 6.07837
14864 Public Video Station Schleswig-Holstein FC_P_000 So 2 06-24 Uhr 12 2 2 SPPSFC_P_000_A_07_GX pv 0 4.83106
14865 Public Video Station Hamburg FC_G_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_G_000_A_1707_GX pv 0 1353.1753
14866 Public Video Station Hamburg FC_G_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_G_000_A_15_GX pv 0 399.41981
14867 Public Video Station Hamburg FC_G_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_G_000_A_06_GX pv 0 213.549581
14868 Public Video Station Hamburg FC_G_000 So 2 06-24 Uhr 12 2 2 SPPSFC_G_000_A_07_GX pv 0 164.26203
14869 Public Video Station Niedersachsen FC_J_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_J_000_A_1707_GX pv 0 414.637619
14870 Public Video Station Niedersachsen FC_J_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_J_000_A_15_GX pv 0 82.6852
14871 Public Video Station Niedersachsen FC_J_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_J_000_A_06_GX pv 0 42.16465
14872 Public Video Station Niedersachsen FC_J_000 So 2 06-24 Uhr 12 2 2 SPPSFC_J_000_A_07_GX pv 0 32.79792
14873 Public Video Station Bremen FC_F_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_F_000_A_1707_GX pv 0 172.229649
14874 Public Video Station Bremen FC_F_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_F_000_A_15_GX pv 0 34.79075
14875 Public Video Station Bremen FC_F_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_F_000_A_06_GX pv 0 17.17695
14876 Public Video Station Bremen FC_F_000 So 2 06-24 Uhr 12 2 2 SPPSFC_F_000_A_07_GX pv 0 14.67924
14877 Public Video Station Nordrhein-Westfalen FC_K_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_K_000_A_1707_GX pv 0 1293.717267
14878 Public Video Station Nordrhein-Westfalen FC_K_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_K_000_A_15_GX pv 0 395.047869
14879 Public Video Station Nordrhein-Westfalen FC_K_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_K_000_A_06_GX pv 0 223.613489
14880 Public Video Station Nordrhein-Westfalen FC_K_000 So 2 06-24 Uhr 12 2 2 SPPSFC_K_000_A_07_GX pv 0 176.97667
14881 Public Video Station Hessen FC_H_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_H_000_A_1707_GX pv 0 850.722722
14882 Public Video Station Hessen FC_H_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_H_000_A_15_GX pv 0 185.79046
14883 Public Video Station Hessen FC_H_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_H_000_A_06_GX pv 0 94.36641
14884 Public Video Station Hessen FC_H_000 So 2 06-24 Uhr 12 2 2 SPPSFC_H_000_A_07_GX pv 0 72.10268
14885 Public Video Station Rheinland-Pfalz FC_L_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_L_000_A_1707_GX pv 0 109.78322
14886 Public Video Station Rheinland-Pfalz FC_L_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_L_000_A_15_GX pv 0 20.80934
14887 Public Video Station Rheinland-Pfalz FC_L_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_L_000_A_06_GX pv 0 11.33672
14888 Public Video Station Rheinland-Pfalz FC_L_000 So 2 06-24 Uhr 12 2 2 SPPSFC_L_000_A_07_GX pv 0 8.93775
14889 Public Video Station Baden-Württemberg FC_B_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_B_000_A_1707_GX pv 0 633.738741
14890 Public Video Station Baden-Württemberg FC_B_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_B_000_A_15_GX pv 0 166.13311
14891 Public Video Station Baden-Württemberg FC_B_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_B_000_A_06_GX pv 0 90.63522
14892 Public Video Station Baden-Württemberg FC_B_000 So 2 06-24 Uhr 12 2 2 SPPSFC_B_000_A_07_GX pv 0 68.76161
14893 Public Video Station Bayern FC_C_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_C_000_A_1707_GX pv 0 1057.734539
14894 Public Video Station Bayern FC_C_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_C_000_A_15_GX pv 0 327.33517
14895 Public Video Station Bayern FC_C_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_C_000_A_06_GX pv 0 189.54166
14896 Public Video Station Bayern FC_C_000 So 2 06-24 Uhr 12 2 2 SPPSFC_C_000_A_07_GX pv 0 143.9006
14897 Public Video Station Saarland FC_M_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_M_000_A_1707_GX pv 0 22.76802
14898 Public Video Station Saarland FC_M_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_M_000_A_15_GX pv 0 4.32015
14899 Public Video Station Saarland FC_M_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_M_000_A_06_GX pv 0 2.29711
14900 Public Video Station Saarland FC_M_000 So 2 06-24 Uhr 12 2 2 SPPSFC_M_000_A_07_GX pv 0 2.0854
14901 Public Video Station Berlin FC_D_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_D_000_A_1707_GX pv 0 914.86955
14902 Public Video Station Berlin FC_D_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_D_000_A_15_GX pv 0 380.808253
14903 Public Video Station Berlin FC_D_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_D_000_A_06_GX pv 0 216.94432
14904 Public Video Station Berlin FC_D_000 So 2 06-24 Uhr 12 2 2 SPPSFC_D_000_A_07_GX pv 0 143.444891
14905 Public Video Station Brandenburg FC_E_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_E_000_A_1707_GX pv 0 24.37611
14906 Public Video Station Brandenburg FC_E_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_E_000_A_15_GX pv 0 4.76603
14907 Public Video Station Brandenburg FC_E_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_E_000_A_06_GX pv 0 2.53129
14908 Public Video Station Brandenburg FC_E_000 So 2 06-24 Uhr 12 2 2 SPPSFC_E_000_A_07_GX pv 0 2.15111
14909 Public Video Station Mecklenburg-Vorpommern FC_I_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_I_000_A_1707_GX pv 0 14.27639
14910 Public Video Station Mecklenburg-Vorpommern FC_I_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_I_000_A_15_GX pv 0 2.57049
14911 Public Video Station Mecklenburg-Vorpommern FC_I_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_I_000_A_06_GX pv 0 1.14468
14912 Public Video Station Mecklenburg-Vorpommern FC_I_000 So 2 06-24 Uhr 12 2 2 SPPSFC_I_000_A_07_GX pv 0 0.93188
14913 Public Video Station Sachsen FC_N_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_N_000_A_1707_GX pv 0 360.89673
14914 Public Video Station Sachsen FC_N_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_N_000_A_15_GX pv 0 79.51456
14915 Public Video Station Sachsen FC_N_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_N_000_A_06_GX pv 0 41.05646
14916 Public Video Station Sachsen FC_N_000 So 2 06-24 Uhr 12 2 2 SPPSFC_N_000_A_07_GX pv 0 33.60059
14917 Public Video Station Sachsen-Anhalt FC_O_000 Ø Woche gesamt Mo-So 7 06-24 Uhr 12 2 2 KPPSFC_O_000_A_1707_GX pv 0 51.79669
14918 Public Video Station Sachsen-Anhalt FC_O_000 Ø Werktag Mo-Fr 3 06-24 Uhr 12 2 2 SPPSFC_O_000_A_15_GX pv 0 9.87031
14919 Public Video Station Sachsen-Anhalt FC_O_000 Sa 1 06-24 Uhr 12 2 2 SPPSFC_O_000_A_06_GX pv 0 4.8216
14920 Public Video Station Sachsen-Anhalt FC_O_000 So 2 06-24 Uhr 12 2 2 SPPSFC_O_000_A_07_GX pv 0 3.47005

Next page

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_weekdays ON media_variant (weekdays);
CREATE INDEX ix_media_variant_timerange ON media_variant (timerange);
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_media ON media_variant (media);
CREATE INDEX ix_media_variant_source ON media_variant (source);
CREATE INDEX ix_media_variant_frequency ON media_variant (frequency);
CREATE INDEX ix_media_variant_extern ON media_variant (extern);