Number of thanks on enwiki per day
ActivePublic
Actions

Authored by Catrope on Jan 10 2018, 8:18 PM.

Tags

None

Referenced Files

	F12391911: Number of thanks on enwiki per day
	Jan 10 2018, 8:18 PM

Subscribers

None

	mysql:research@s3-analytics-slave [enwiki]> select substring(log_timestamp, 1, 8) as day, count(*) from logging where log_type='thanks' and log_timestamp >= '20170801000000' group by day;
	+----------+----------+
	\| day \| count(*) \|
	+----------+----------+
	\| 20170801 \| 898 \|
	\| 20170802 \| 881 \|
	\| 20170803 \| 996 \|
	\| 20170804 \| 915 \|
	\| 20170805 \| 758 \|
	\| 20170806 \| 853 \|
	\| 20170807 \| 946 \|
	\| 20170808 \| 842 \|
	\| 20170809 \| 908 \|
	\| 20170810 \| 913 \|
	\| 20170811 \| 909 \|
	\| 20170812 \| 648 \|
	\| 20170813 \| 759 \|
	\| 20170814 \| 897 \|
	\| 20170815 \| 970 \|
	\| 20170816 \| 1061 \|
	\| 20170817 \| 972 \|
	\| 20170818 \| 894 \|
	\| 20170819 \| 825 \|
	\| 20170820 \| 867 \|
	\| 20170821 \| 900 \|
	\| 20170822 \| 843 \|
	\| 20170823 \| 939 \|
	\| 20170824 \| 937 \|
	\| 20170825 \| 951 \|
	\| 20170826 \| 831 \|
	\| 20170827 \| 851 \|
	\| 20170828 \| 914 \|
	\| 20170829 \| 930 \|
	\| 20170830 \| 1170 \|
	\| 20170831 \| 1187 \|
	\| 20170901 \| 1012 \|
	\| 20170902 \| 899 \|
	\| 20170903 \| 892 \|
	\| 20170904 \| 975 \|
	\| 20170905 \| 1029 \|
	\| 20170906 \| 949 \|
	\| 20170907 \| 884 \|
	\| 20170908 \| 822 \|
	\| 20170909 \| 677 \|
	\| 20170910 \| 836 \|
	\| 20170911 \| 894 \|
	\| 20170912 \| 966 \|
	\| 20170913 \| 1026 \|
	\| 20170914 \| 953 \|
	\| 20170915 \| 1030 \|
	\| 20170916 \| 865 \|
	\| 20170917 \| 769 \|
	\| 20170918 \| 958 \|
	\| 20170919 \| 943 \|
	\| 20170920 \| 924 \|
	\| 20170921 \| 849 \|
	\| 20170922 \| 1086 \|
	\| 20170923 \| 838 \|
	\| 20170924 \| 798 \|
	\| 20170925 \| 952 \|
	\| 20170926 \| 903 \|
	\| 20170927 \| 964 \|
	\| 20170928 \| 854 \|
	\| 20170929 \| 780 \|
	\| 20170930 \| 793 \|
	\| 20171001 \| 833 \|
	\| 20171002 \| 985 \|
	\| 20171003 \| 975 \|
	\| 20171004 \| 912 \|
	\| 20171005 \| 889 \|
	\| 20171006 \| 837 \|
	\| 20171007 \| 811 \|
	\| 20171008 \| 850 \|
	\| 20171009 \| 890 \|
	\| 20171010 \| 972 \|
	\| 20171011 \| 863 \|
	\| 20171012 \| 958 \|
	\| 20171013 \| 987 \|
	\| 20171014 \| 798 \|
	\| 20171015 \| 796 \|
	\| 20171016 \| 962 \|
	\| 20171017 \| 956 \|
	\| 20171018 \| 982 \|
	\| 20171019 \| 949 \|
	\| 20171020 \| 813 \|
	\| 20171021 \| 758 \|
	\| 20171022 \| 726 \|
	\| 20171023 \| 906 \|
	\| 20171024 \| 943 \|
	\| 20171025 \| 988 \|
	\| 20171026 \| 983 \|
	\| 20171027 \| 942 \|
	\| 20171028 \| 1129 \|
	\| 20171029 \| 726 \|
	\| 20171030 \| 942 \|
	\| 20171031 \| 847 \|
	\| 20171101 \| 891 \|
	\| 20171102 \| 935 \|
	\| 20171103 \| 797 \|
	\| 20171104 \| 828 \|
	\| 20171105 \| 953 \|
	\| 20171106 \| 974 \|
	\| 20171107 \| 977 \|
	\| 20171108 \| 957 \|
	\| 20171109 \| 959 \|
	\| 20171110 \| 870 \|
	\| 20171111 \| 766 \|
	\| 20171112 \| 849 \|
	\| 20171113 \| 897 \|
	\| 20171114 \| 926 \|
	\| 20171115 \| 907 \|
	\| 20171116 \| 938 \|
	\| 20171117 \| 955 \|
	\| 20171118 \| 895 \|
	\| 20171119 \| 904 \|
	\| 20171120 \| 965 \|
	\| 20171121 \| 954 \|
	\| 20171122 \| 852 \|
	\| 20171123 \| 826 \|
	\| 20171124 \| 723 \|
	\| 20171125 \| 908 \|
	\| 20171126 \| 1225 \|
	\| 20171127 \| 1220 \|
	\| 20171128 \| 951 \|
	\| 20171129 \| 967 \|
	\| 20171130 \| 1068 \|
	\| 20171201 \| 933 \|
	\| 20171202 \| 834 \|
	\| 20171203 \| 874 \|
	\| 20171204 \| 947 \|
	\| 20171205 \| 1064 \|
	\| 20171206 \| 988 \|
	\| 20171207 \| 884 \|
	\| 20171208 \| 1001 \|
	\| 20171209 \| 873 \|
	\| 20171210 \| 866 \|
	\| 20171211 \| 951 \|
	\| 20171212 \| 919 \|
	\| 20171213 \| 889 \|
	\| 20171214 \| 1036 \|
	\| 20171215 \| 870 \|
	\| 20171216 \| 869 \|
	\| 20171217 \| 964 \|
	\| 20171218 \| 915 \|
	\| 20171219 \| 1057 \|
	\| 20171220 \| 940 \|
	\| 20171221 \| 954 \|
	\| 20171222 \| 1004 \|
	\| 20171223 \| 980 \|
	\| 20171224 \| 958 \|
	\| 20171225 \| 719 \|
	\| 20171226 \| 857 \|
	\| 20171227 \| 1004 \|
	\| 20171228 \| 1001 \|
	\| 20171229 \| 1103 \|
	\| 20171230 \| 947 \|
	\| 20171231 \| 1008 \|
	\| 20180101 \| 963 \|
	\| 20180102 \| 1226 \|
	\| 20180103 \| 1209 \|
	\| 20180104 \| 1025 \|
	\| 20180105 \| 1081 \|
	\| 20180106 \| 966 \|
	\| 20180107 \| 912 \|
	\| 20180108 \| 965 \|
	\| 20180109 \| 1159 \|
	\| 20180110 \| 866 \|
	+----------+----------+

Event Timeline

Catrope created this paste.Jan 10 2018, 8:18 PM

	mysql:research@s3-analytics-slave [enwiki]> select substring(log_timestamp, 1, 8) as day, count(*) from logging where log_type='thanks' and log_timestamp >= '20170801000000' group by day;
	+----------+----------+
	\| day \| count(*) \|
	+----------+----------+
	\| 20170801 \| 898 \|
	\| 20170802 \| 881 \|
	\| 20170803 \| 996 \|
	\| 20170804 \| 915 \|
	\| 20170805 \| 758 \|
	\| 20170806 \| 853 \|
	\| 20170807 \| 946 \|
	\| 20170808 \| 842 \|
	\| 20170809 \| 908 \|
	\| 20170810 \| 913 \|
	\| 20170811 \| 909 \|
	\| 20170812 \| 648 \|
	\| 20170813 \| 759 \|
	\| 20170814 \| 897 \|
	\| 20170815 \| 970 \|
	\| 20170816 \| 1061 \|
	\| 20170817 \| 972 \|
	\| 20170818 \| 894 \|
	\| 20170819 \| 825 \|
	\| 20170820 \| 867 \|
	\| 20170821 \| 900 \|
	\| 20170822 \| 843 \|
	\| 20170823 \| 939 \|
	\| 20170824 \| 937 \|
	\| 20170825 \| 951 \|
	\| 20170826 \| 831 \|
	\| 20170827 \| 851 \|
	\| 20170828 \| 914 \|
	\| 20170829 \| 930 \|
	\| 20170830 \| 1170 \|
	\| 20170831 \| 1187 \|
	\| 20170901 \| 1012 \|
	\| 20170902 \| 899 \|
	\| 20170903 \| 892 \|
	\| 20170904 \| 975 \|
	\| 20170905 \| 1029 \|
	\| 20170906 \| 949 \|
	\| 20170907 \| 884 \|
	\| 20170908 \| 822 \|
	\| 20170909 \| 677 \|
	\| 20170910 \| 836 \|
	\| 20170911 \| 894 \|
	\| 20170912 \| 966 \|
	\| 20170913 \| 1026 \|
	\| 20170914 \| 953 \|
	\| 20170915 \| 1030 \|
	\| 20170916 \| 865 \|
	\| 20170917 \| 769 \|
	\| 20170918 \| 958 \|
	\| 20170919 \| 943 \|
	\| 20170920 \| 924 \|
	\| 20170921 \| 849 \|
	\| 20170922 \| 1086 \|
	\| 20170923 \| 838 \|
	\| 20170924 \| 798 \|
	\| 20170925 \| 952 \|
	\| 20170926 \| 903 \|
	\| 20170927 \| 964 \|
	\| 20170928 \| 854 \|
	\| 20170929 \| 780 \|
	\| 20170930 \| 793 \|
	\| 20171001 \| 833 \|
	\| 20171002 \| 985 \|
	\| 20171003 \| 975 \|
	\| 20171004 \| 912 \|
	\| 20171005 \| 889 \|
	\| 20171006 \| 837 \|
	\| 20171007 \| 811 \|
	\| 20171008 \| 850 \|
	\| 20171009 \| 890 \|
	\| 20171010 \| 972 \|
	\| 20171011 \| 863 \|
	\| 20171012 \| 958 \|
	\| 20171013 \| 987 \|
	\| 20171014 \| 798 \|
	\| 20171015 \| 796 \|
	\| 20171016 \| 962 \|
	\| 20171017 \| 956 \|
	\| 20171018 \| 982 \|
	\| 20171019 \| 949 \|
	\| 20171020 \| 813 \|
	\| 20171021 \| 758 \|
	\| 20171022 \| 726 \|
	\| 20171023 \| 906 \|
	\| 20171024 \| 943 \|
	\| 20171025 \| 988 \|
	\| 20171026 \| 983 \|
	\| 20171027 \| 942 \|
	\| 20171028 \| 1129 \|
	\| 20171029 \| 726 \|
	\| 20171030 \| 942 \|
	\| 20171031 \| 847 \|
	\| 20171101 \| 891 \|
	\| 20171102 \| 935 \|
	\| 20171103 \| 797 \|
	\| 20171104 \| 828 \|
	\| 20171105 \| 953 \|
	\| 20171106 \| 974 \|
	\| 20171107 \| 977 \|
	\| 20171108 \| 957 \|
	\| 20171109 \| 959 \|
	\| 20171110 \| 870 \|
	\| 20171111 \| 766 \|
	\| 20171112 \| 849 \|
	\| 20171113 \| 897 \|
	\| 20171114 \| 926 \|
	\| 20171115 \| 907 \|
	\| 20171116 \| 938 \|
	\| 20171117 \| 955 \|
	\| 20171118 \| 895 \|
	\| 20171119 \| 904 \|
	\| 20171120 \| 965 \|
	\| 20171121 \| 954 \|
	\| 20171122 \| 852 \|
	\| 20171123 \| 826 \|
	\| 20171124 \| 723 \|
	\| 20171125 \| 908 \|
	\| 20171126 \| 1225 \|
	\| 20171127 \| 1220 \|
	\| 20171128 \| 951 \|
	\| 20171129 \| 967 \|
	\| 20171130 \| 1068 \|
	\| 20171201 \| 933 \|
	\| 20171202 \| 834 \|
	\| 20171203 \| 874 \|
	\| 20171204 \| 947 \|
	\| 20171205 \| 1064 \|
	\| 20171206 \| 988 \|
	\| 20171207 \| 884 \|
	\| 20171208 \| 1001 \|
	\| 20171209 \| 873 \|
	\| 20171210 \| 866 \|
	\| 20171211 \| 951 \|
	\| 20171212 \| 919 \|
	\| 20171213 \| 889 \|
	\| 20171214 \| 1036 \|
	\| 20171215 \| 870 \|
	\| 20171216 \| 869 \|
	\| 20171217 \| 964 \|
	\| 20171218 \| 915 \|
	\| 20171219 \| 1057 \|
	\| 20171220 \| 940 \|
	\| 20171221 \| 954 \|
	\| 20171222 \| 1004 \|
	\| 20171223 \| 980 \|
	\| 20171224 \| 958 \|
	\| 20171225 \| 719 \|
	\| 20171226 \| 857 \|
	\| 20171227 \| 1004 \|
	\| 20171228 \| 1001 \|
	\| 20171229 \| 1103 \|
	\| 20171230 \| 947 \|
	\| 20171231 \| 1008 \|
	\| 20180101 \| 963 \|
	\| 20180102 \| 1226 \|
	\| 20180103 \| 1209 \|
	\| 20180104 \| 1025 \|
	\| 20180105 \| 1081 \|
	\| 20180106 \| 966 \|
	\| 20180107 \| 912 \|
	\| 20180108 \| 965 \|
	\| 20180109 \| 1159 \|
	\| 20180110 \| 866 \|
	+----------+----------+

Number of thanks on enwiki per dayActivePublicActions

Event Timeline

Number of thanks on enwiki per day
ActivePublic
Actions