Wikipedia:Civility/Poll/Data

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

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

Source

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%';