* This is a bit tricky for non registered users as they are anonymous, so 2 or more people may share the same IP. * Having said it, you can access the revision table[1], or get all the revision from dumps and query for it with select rev_user_text, YEAR(rev_timestamp), count(*) from revision where rev_user=0 group by rev_user_text, YEAR(rev_timestamp)
(replace year with the required granularity[3]) [1] https://www.mediawiki.org/wiki/Manual:Revision_table [2] https://dumps.wikimedia.org/ [3] https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html On Thu, Dec 8, 2016 at 8:50 AM, Ofer Arazy <ofer.ar...@gmail.com> wrote: > Hi all, > > I'm seeking assistance in retrieving data regarding the activity of > *unregistered > contributors* on a year-by-year basis. > Namely, I'm looking for stats regarding the count of these IP users at the > end of each calendar year, as well as their activity levels (e.g. avg. > monthly edits). > > I was able to get detailed stats for registered members, but not for those > contributors identified through their IP > > Help will be appreciated. > > Thanks in advance, > Ofer > > -- > =================================== > Dr. Ofer Arazy > http://www.OferArazy.com <http://oferarazy.com/> > =================================== > > _______________________________________________ > Wiki-research-l mailing list > Wiki-research-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wiki-research-l > >
_______________________________________________ Wiki-research-l mailing list Wiki-research-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wiki-research-l
