Jump to content

User:Zocky/Article survey

From Wikipedia, the free encyclopedia

What I need

[edit]

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

Classification

[edit]

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
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