User:Zocky/Article survey
From Wikipedia, the free encyclopedia
[edit] What I need
A query to produce a list of 1000 random articles, with the following data both for the article page and for the talk page (all at the chosen cut-off date):
- Revision number
- Date of creation
- Creator logged in or not
- If yes, date of account creation
- Number of edits
- Number of edits by logged in editors
- Number of editors
- Number of logged in editors
- Date of last edit
- Last editor logged in or not
- Number of sections
- Number of characters
The following make sense just for the article page:
- Number of direct links to the article
- Number of redirects to the article
- Number of redirected links to the article
- Number of people watching the article
- Number of admin rollbacks in the history
- Number of images
- Number of categories
Additional data that would be nice but could possibly be tricky to get with SQL; could possibly be found out manually.
- Creator's edit count at time of creation
- Average edit count of editors at time of contribution
[edit] Classification
Articles will be classified by (at least) two criteria. This is the current draught:
- Encyclopedicity
- Articles rated by where one would expect to find them.
- Encyclopedia
- Things you would find in any large general-purpose encyclopedia
- Almanac
- Topics that are included because they are members of a well defined notable category.
- Cruft
- Topics that are included because they are members of a badly defined or instantly expandable category.
- Non-notable
- Articles that would likely not survive AfD for lack of notability
- Speedy
- Valid candidates for speedy deletion
- Encyclopedia
- Condition
- What superficial state the article is in. Proper review of presented information is way outside the scope of this little survey.
- CSD
- Valid candidates for speedy deletion
- Neglected
- Articles that need attention from experienced users, i.e. unformatted, unwikified, etc. pages.
- Stub
- Articles that provide only the definition and rudimentary links.
- Short article
- Short proper articles, up to several paragraphs.
- Medium article
- Medium proper articles, up to several screen-fuls
- Long article
- Elaborate coverage of a topic, proper section structure
- FA candidate
- Pages that are FA candidates or look like they could be reasonably proposed as a Featured Article candidates
- Featured article
- If any popup in the smallish sample.
- Short list
- Medium list
- Long list
- Dissambiguation
- CSD
