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 such database ?
Other questions are regarding the partial dumps of wikipedia. Are the dumps sorted by any field ? How can get all the users pages ? Are they stored in a specific dump ? Or the dumps are stored by page titles or categories ?
Regards.
On Tue, Oct 18, 2011 at 15:29, Rami Al-Rfou' rmyeid@gmail.com wrote:
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 pages in the database.
- I can not see the users table! Is the users table stored in a special
partial dump?
- Does the user table contain any properties related to the user
country, preferred wikipeidas, or their skill in different languages ?
- I am interested in the user modifications that contain addition to
the articles and not modification or deletion. I am planning now to diff between revisions to get such data. Are you aware of any tool or effort that can help?
- Are you aware of any tools that extract the text from wikipedia
markup language.
Regards.
-- Rami Al-Rfou' PhD student at Stony Brook University