Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

For each user on Wikipedia, I'd like to find which pages were created by those users. How can I find all of the pages that were created by a specific Wikipedia or Mediawiki user?

share|improve this question
    
Of course, it's possible to find the creator of a page by going back to the first edit in the page's revision history. What I want to do is find a list of all pages that were created by a particular user. –  Anderson Green Aug 11 '12 at 0:04
    
I'm assuming you don't have account on the toolserver, right? –  svick Aug 11 '12 at 0:31
    
No, I don't yet have an account on the toolserver. How is this relevant to my question? –  Anderson Green Aug 11 '12 at 2:15

2 Answers 2

up vote 3 down vote accepted

As far as I know, there is no simple way to do this. But I can see some possibilities (starting with those that practically won't work):

  1. Use the API. The API doesn't have any direct way to do this, but you could try to work around that:

    1. Go though all pages and for each of them, find out the creator. Because of the limitations of the API when working with revisions, this would mean 1 request per page, which makes this completely unfeasible for a wiki as big as Wikipedia.

      The first query would look something like: http://en.wikipedia.org/w/api.php?action=query&generator=allpages&gaplimit=1&prop=revisions&rvdir=newer&rvprop=user&rvlimit=1

    2. For each user, go through his contributions and find out which of his edits created a new page. Because the API won't let you filter the contributions to show only page creations, you would have to filter that by yourself. This would be probably much faster than the option above, but still way too slow for Wikipedia:

      The query for User:Svick would look like: http://en.wikipedia.org/w/api.php?action=query&list=usercontribs&ucuser=Svick&ucprop=title|flags&uclimit=max

  2. Download the stub-meta-history dump (32 GB compressed for the English Wikipedia), which contains information about revisions of all pages in XML. You could go through that to find out the creator of each page (assuming no revisions were deleted).

  3. On the Wikimedia Toolserver, I run a script (originally not written by me) that periodically updates the table u_svick_enwiki_page_creators_p, which contains information about users that created each page. This table is accessible to other users of the Toolserver, but not to the public.

To sum up: there is no good solution and you have pretty much two choices: download and parse 32 GB of data, or get a Toolserver account and then use the table I mentioned.

share|improve this answer

As of Wikimedia 1.23, this can be done with the Usercontribs module in the API using the new option of the ucshow parameter.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.