Re: [Wiki-research-l] Wikipedia Users database

2011-10-24 Thread R.Stuart Geiger
FYI, a lot of the database tables are archived on http://dumps.wikimedia.org -- see http://dumps.wikimedia.org/enwiki/20111007/ for the latest dump.  The user table is private, but it doesn't seem like you need that. You're looking for what people have publicly posted on their own user pages, whic

Re: [Wiki-research-l] Wikipedia Users database

2011-10-24 Thread Jon Davis
- That example you posted isn't a list of all users, just ones who have added "Babel" template to their userpages [1]. - That data is stored in the database, in the category and categorylinks tables (possibly elsewhere, I can't remember offhand). - I don't think the are sorted in an

Re: [Wiki-research-l] Wikipedia Users database

2011-10-24 Thread Kim Bruning
On Mon, Oct 24, 2011 at 04:11:22PM -0400, Rami Al-Rfou' wrote: > Hi All, > > So with more investigation I discovered that I can get a list of the users > depending on their skill at a specific language. For example: > http://en.wikipedia.org/w/index.php?title=Category:User_zh-N > > It seems that

Re: [Wiki-research-l] Wikipedia Users database

2011-10-24 Thread Laura Hale
On Tue, Oct 25, 2011 at 7:11 AM, Rami Al-Rfou' wrote: > Hi All, > > So with more investigation I discovered that I can get a list of the users > depending on their skill at a specific language. For example: > http://en.wikipedia.org/w/index.php?title=Category:User_zh-N > > It seems that such list

Re: [Wiki-research-l] Wikipedia Users database

2011-10-24 Thread Rami Al-Rfou'
Hi All, So with more investigation I discovered that I can get a list of the users depending on their skill at a specific language. For example: http://en.wikipedia.org/w/index.php?title=Category:User_zh-N It seems that such list is populated from a database. Does anyone know where can I find su

Re: [Wiki-research-l] Wikipedia Users database

2011-10-19 Thread Torsten Zesch
' Sent: Tuesday, October 18, 2011 9:29 PM To: Research into Wikimedia content and communities Cc: Yanqing Chen Subject: [Wiki-research-l] Wikipedia Users database Hi, I am planning to study the difference in users edits style and their spelling errors in English Wikipedia as part of a res

[Wiki-research-l] Wikipedia Users database

2011-10-18 Thread Rami Al-Rfou'
Hi, I am planning to study the difference in users edits style and their spelling errors in English Wikipedia as part of a research project I am involved in. So I downloaded some of the wikipedia XML partial dump and convert them to SQL. My understanding that wikipedia stores every copy of the pa