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 [http://en.wikipedia.org/w/index.php?title=Wikipedia:Civility/Poll/Data&oldid=300595707 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%';