Jump to content

Wikipedia:Civility/Poll/Data

From Wikipedia, the free encyclopedia

A list of users with more than 500 edits who were blocked in the first part of 2009 with a log message indicating incivility.

Data

[edit]

The data has been courtesy blanked to prevent it appearing in searches. The original data is in revision 300595707 of this page.

Source

[edit]

The data was generated by running the following query against the enwiki database on 2009-7-6 around 13:00 UTC.

select blocked.user_name, blocked.user_editcount, log_timestamp, admin.user_name, log_comment
from logging
join user as blocked
  on log_namespace = 2 and log_title = blocked.user_name
join user as admin
  on log_user = admin.user_id
where log_namespace = 2
  and blocked.user_editcount > 500
  and log_type='block'
  and log_action = 'block'
  and log_timestamp like '2009%';