Number of edits per day on enwiki and frwiki
ActivePublic
Actions

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

Tags

None

Referenced Files

	F12392099: Number of edits per day on enwiki and frwiki
	Jan 10 2018, 8:32 PM

Subscribers

None

	mysql:research@s3-analytics-slave [enwiki]> select substring(rev_timestamp, 1, 8) as day, count(*) from revision where rev_timestamp >= '20170801000000' group by day;
	+----------+----------+
	\| day \| count(*) \|
	+----------+----------+
	\| 20170801 \| 156467 \|
	\| 20170802 \| 149718 \|
	\| 20170803 \| 157426 \|
	\| 20170804 \| 166838 \|
	\| 20170805 \| 152029 \|
	\| 20170806 \| 145875 \|
	\| 20170807 \| 152372 \|
	\| 20170808 \| 173080 \|
	\| 20170809 \| 162756 \|
	\| 20170810 \| 160603 \|
	\| 20170811 \| 151788 \|
	\| 20170812 \| 147110 \|
	\| 20170813 \| 145047 \|
	\| 20170814 \| 152555 \|
	\| 20170815 \| 148960 \|
	\| 20170816 \| 150976 \|
	\| 20170817 \| 148988 \|
	\| 20170818 \| 142917 \|
	\| 20170819 \| 139850 \|
	\| 20170820 \| 138835 \|
	\| 20170821 \| 142791 \|
	\| 20170822 \| 163585 \|
	\| 20170823 \| 162707 \|
	\| 20170824 \| 157369 \|
	\| 20170825 \| 164418 \|
	\| 20170826 \| 150395 \|
	\| 20170827 \| 148010 \|
	\| 20170828 \| 172953 \|
	\| 20170829 \| 167473 \|
	\| 20170830 \| 168323 \|
	\| 20170831 \| 174999 \|
	\| 20170901 \| 160129 \|
	\| 20170902 \| 177247 \|
	\| 20170903 \| 185384 \|
	\| 20170904 \| 166635 \|
	\| 20170905 \| 165066 \|
	\| 20170906 \| 160821 \|
	\| 20170907 \| 155440 \|
	\| 20170908 \| 160910 \|
	\| 20170909 \| 158446 \|
	\| 20170910 \| 171440 \|
	\| 20170911 \| 196405 \|
	\| 20170912 \| 156590 \|
	\| 20170913 \| 155029 \|
	\| 20170914 \| 160891 \|
	\| 20170915 \| 161945 \|
	\| 20170916 \| 147965 \|
	\| 20170917 \| 162358 \|
	\| 20170918 \| 162985 \|
	\| 20170919 \| 167949 \|
	\| 20170920 \| 156706 \|
	\| 20170921 \| 153184 \|
	\| 20170922 \| 140370 \|
	\| 20170923 \| 143667 \|
	\| 20170924 \| 154339 \|
	\| 20170925 \| 148424 \|
	\| 20170926 \| 152991 \|
	\| 20170927 \| 146784 \|
	\| 20170928 \| 154162 \|
	\| 20170929 \| 150964 \|
	\| 20170930 \| 153127 \|
	\| 20171001 \| 166501 \|
	\| 20171002 \| 158985 \|
	\| 20171003 \| 166412 \|
	\| 20171004 \| 156998 \|
	\| 20171005 \| 148542 \|
	\| 20171006 \| 138015 \|
	\| 20171007 \| 149800 \|
	\| 20171008 \| 143423 \|
	\| 20171009 \| 155439 \|
	\| 20171010 \| 166577 \|
	\| 20171011 \| 164332 \|
	\| 20171012 \| 156871 \|
	\| 20171013 \| 145100 \|
	\| 20171014 \| 138780 \|
	\| 20171015 \| 147191 \|
	\| 20171016 \| 154277 \|
	\| 20171017 \| 153109 \|
	\| 20171018 \| 150712 \|
	\| 20171019 \| 143162 \|
	\| 20171020 \| 141847 \|
	\| 20171021 \| 140366 \|
	\| 20171022 \| 157404 \|
	\| 20171023 \| 167697 \|
	\| 20171024 \| 161538 \|
	\| 20171025 \| 178638 \|
	\| 20171026 \| 159013 \|
	\| 20171027 \| 160915 \|
	\| 20171028 \| 154482 \|
	\| 20171029 \| 158023 \|
	\| 20171030 \| 184194 \|
	\| 20171031 \| 168831 \|
	\| 20171101 \| 170281 \|
	\| 20171102 \| 163911 \|
	\| 20171103 \| 153928 \|
	\| 20171104 \| 143136 \|
	\| 20171105 \| 148387 \|
	\| 20171106 \| 160689 \|
	\| 20171107 \| 172479 \|
	\| 20171108 \| 165028 \|
	\| 20171109 \| 149817 \|
	\| 20171110 \| 146843 \|
	\| 20171111 \| 142877 \|
	\| 20171112 \| 158706 \|
	\| 20171113 \| 182388 \|
	\| 20171114 \| 174929 \|
	\| 20171115 \| 158234 \|
	\| 20171116 \| 155939 \|
	\| 20171117 \| 154702 \|
	\| 20171118 \| 140356 \|
	\| 20171119 \| 157168 \|
	\| 20171120 \| 159671 \|
	\| 20171121 \| 152966 \|
	\| 20171122 \| 149928 \|
	\| 20171123 \| 140567 \|
	\| 20171124 \| 156481 \|
	\| 20171125 \| 144095 \|
	\| 20171126 \| 170033 \|
	\| 20171127 \| 194036 \|
	\| 20171128 \| 167293 \|
	\| 20171129 \| 170743 \|
	\| 20171130 \| 164448 \|
	\| 20171201 \| 157132 \|
	\| 20171202 \| 168133 \|
	\| 20171203 \| 234150 \|
	\| 20171204 \| 193003 \|
	\| 20171205 \| 187636 \|
	\| 20171206 \| 187586 \|
	\| 20171207 \| 178746 \|
	\| 20171208 \| 163291 \|
	\| 20171209 \| 162830 \|
	\| 20171210 \| 161333 \|
	\| 20171211 \| 175536 \|
	\| 20171212 \| 161930 \|
	\| 20171213 \| 152485 \|
	\| 20171214 \| 168818 \|
	\| 20171215 \| 155245 \|
	\| 20171216 \| 140021 \|
	\| 20171217 \| 141511 \|
	\| 20171218 \| 149297 \|
	\| 20171219 \| 151393 \|
	\| 20171220 \| 166370 \|
	\| 20171221 \| 153122 \|
	\| 20171222 \| 144563 \|
	\| 20171223 \| 141975 \|
	\| 20171224 \| 125953 \|
	\| 20171225 \| 119976 \|
	\| 20171226 \| 140193 \|
	\| 20171227 \| 152760 \|
	\| 20171228 \| 150806 \|
	\| 20171229 \| 159594 \|
	\| 20171230 \| 166409 \|
	\| 20171231 \| 150148 \|
	\| 20180101 \| 152756 \|
	\| 20180102 \| 171529 \|
	\| 20180103 \| 169305 \|
	\| 20180104 \| 172182 \|
	\| 20180105 \| 167745 \|
	\| 20180106 \| 171474 \|
	\| 20180107 \| 162994 \|
	\| 20180108 \| 173787 \|
	\| 20180109 \| 180967 \|
	\| 20180110 \| 149379 \|
	+----------+----------+


	mysql:research@s3-analytics-slave [frwiki]> select substring(rev_timestamp, 1, 8) as day, count(*) from revision where rev_timestamp >= '20170801000000' group by day;
	+----------+----------+
	\| day \| count(*) \|
	+----------+----------+
	\| 20170801 \| 29129 \|
	\| 20170802 \| 26276 \|
	\| 20170803 \| 29615 \|
	\| 20170804 \| 24567 \|
	\| 20170805 \| 21785 \|
	\| 20170806 \| 25207 \|
	\| 20170807 \| 24451 \|
	\| 20170808 \| 25286 \|
	\| 20170809 \| 24616 \|
	\| 20170810 \| 25651 \|
	\| 20170811 \| 26847 \|
	\| 20170812 \| 25771 \|
	\| 20170813 \| 23869 \|
	\| 20170814 \| 23713 \|
	\| 20170815 \| 25634 \|
	\| 20170816 \| 28247 \|
	\| 20170817 \| 30989 \|
	\| 20170818 \| 28736 \|
	\| 20170819 \| 25358 \|
	\| 20170820 \| 24976 \|
	\| 20170821 \| 28303 \|
	\| 20170822 \| 27705 \|
	\| 20170823 \| 28117 \|
	\| 20170824 \| 28047 \|
	\| 20170825 \| 27112 \|
	\| 20170826 \| 24093 \|
	\| 20170827 \| 26425 \|
	\| 20170828 \| 29313 \|
	\| 20170829 \| 30057 \|
	\| 20170830 \| 29314 \|
	\| 20170831 \| 32194 \|
	\| 20170901 \| 30215 \|
	\| 20170902 \| 31212 \|
	\| 20170903 \| 28322 \|
	\| 20170904 \| 28398 \|
	\| 20170905 \| 29456 \|
	\| 20170906 \| 25895 \|
	\| 20170907 \| 25071 \|
	\| 20170908 \| 35021 \|
	\| 20170909 \| 45057 \|
	\| 20170910 \| 40151 \|
	\| 20170911 \| 26192 \|
	\| 20170912 \| 25715 \|
	\| 20170913 \| 26611 \|
	\| 20170914 \| 25828 \|
	\| 20170915 \| 23679 \|
	\| 20170916 \| 23138 \|
	\| 20170917 \| 24579 \|
	\| 20170918 \| 25066 \|
	\| 20170919 \| 25257 \|
	\| 20170920 \| 27615 \|
	\| 20170921 \| 25256 \|
	\| 20170922 \| 26132 \|
	\| 20170923 \| 23610 \|
	\| 20170924 \| 28372 \|
	\| 20170925 \| 30988 \|
	\| 20170926 \| 29744 \|
	\| 20170927 \| 29163 \|
	\| 20170928 \| 26537 \|
	\| 20170929 \| 25292 \|
	\| 20170930 \| 27171 \|
	\| 20171001 \| 35109 \|
	\| 20171002 \| 30601 \|
	\| 20171003 \| 32125 \|
	\| 20171004 \| 29145 \|
	\| 20171005 \| 28817 \|
	\| 20171006 \| 25600 \|
	\| 20171007 \| 32055 \|
	\| 20171008 \| 35051 \|
	\| 20171009 \| 30317 \|
	\| 20171010 \| 32032 \|
	\| 20171011 \| 27727 \|
	\| 20171012 \| 25524 \|
	\| 20171013 \| 25522 \|
	\| 20171014 \| 26459 \|
	\| 20171015 \| 28492 \|
	\| 20171016 \| 29071 \|
	\| 20171017 \| 27124 \|
	\| 20171018 \| 35329 \|
	\| 20171019 \| 35805 \|
	\| 20171020 \| 30315 \|
	\| 20171021 \| 38021 \|
	\| 20171022 \| 40063 \|
	\| 20171023 \| 44242 \|
	\| 20171024 \| 43205 \|
	\| 20171025 \| 41144 \|
	\| 20171026 \| 35467 \|
	\| 20171027 \| 43566 \|
	\| 20171028 \| 29698 \|
	\| 20171029 \| 39811 \|
	\| 20171030 \| 44963 \|
	\| 20171031 \| 31238 \|
	\| 20171101 \| 35480 \|
	\| 20171102 \| 32271 \|
	\| 20171103 \| 34189 \|
	\| 20171104 \| 34778 \|
	\| 20171105 \| 33381 \|
	\| 20171106 \| 30162 \|
	\| 20171107 \| 29055 \|
	\| 20171108 \| 33620 \|
	\| 20171109 \| 27578 \|
	\| 20171110 \| 27537 \|
	\| 20171111 \| 27331 \|
	\| 20171112 \| 31270 \|
	\| 20171113 \| 30793 \|
	\| 20171114 \| 30152 \|
	\| 20171115 \| 30781 \|
	\| 20171116 \| 32092 \|
	\| 20171117 \| 33219 \|
	\| 20171118 \| 30663 \|
	\| 20171119 \| 34657 \|
	\| 20171120 \| 31290 \|
	\| 20171121 \| 26201 \|
	\| 20171122 \| 29761 \|
	\| 20171123 \| 25215 \|
	\| 20171124 \| 24763 \|
	\| 20171125 \| 27336 \|
	\| 20171126 \| 29915 \|
	\| 20171127 \| 33047 \|
	\| 20171128 \| 31436 \|
	\| 20171129 \| 28069 \|
	\| 20171130 \| 28913 \|
	\| 20171201 \| 27897 \|
	\| 20171202 \| 24432 \|
	\| 20171203 \| 36241 \|
	\| 20171204 \| 36433 \|
	\| 20171205 \| 29140 \|
	\| 20171206 \| 27688 \|
	\| 20171207 \| 25983 \|
	\| 20171208 \| 25631 \|
	\| 20171209 \| 27609 \|
	\| 20171210 \| 37772 \|
	\| 20171211 \| 42508 \|
	\| 20171212 \| 40692 \|
	\| 20171213 \| 29515 \|
	\| 20171214 \| 27419 \|
	\| 20171215 \| 26601 \|
	\| 20171216 \| 26468 \|
	\| 20171217 \| 32777 \|
	\| 20171218 \| 31342 \|
	\| 20171219 \| 29637 \|
	\| 20171220 \| 27020 \|
	\| 20171221 \| 26504 \|
	\| 20171222 \| 24617 \|
	\| 20171223 \| 27337 \|
	\| 20171224 \| 24435 \|
	\| 20171225 \| 20083 \|
	\| 20171226 \| 27425 \|
	\| 20171227 \| 37671 \|
	\| 20171228 \| 30161 \|
	\| 20171229 \| 39156 \|
	\| 20171230 \| 37219 \|
	\| 20171231 \| 30169 \|
	\| 20180101 \| 28608 \|
	\| 20180102 \| 32829 \|
	\| 20180103 \| 31180 \|
	\| 20180104 \| 33652 \|
	\| 20180105 \| 30876 \|
	\| 20180106 \| 31467 \|
	\| 20180107 \| 31661 \|
	\| 20180108 \| 32099 \|
	\| 20180109 \| 31138 \|
	\| 20180110 \| 29830 \|
	+----------+----------+

Event Timeline

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

Number of edits per day on enwiki and frwikiActivePublicActions

Event Timeline

Number of edits per day on enwiki and frwiki
ActivePublic
Actions