Does any of the following provides useful data?

• How often are blocks created in a wiki ? (avg time) Ex: 5 blocks per hour
• How often are blocks removed
• Common reasons for "unblocking"
• Frequency of autoblocks?

What is the distribution of the most common block length options? (e.g. 500 wikis have 'indefinite' 500 have '1 day' 300 have '1 week' etc.)

Will this be in the past year? 7 days?

In T190328#4070480, @dmaza wrote:

Does any of the following provides useful data?

• How often are blocks created in a wiki ? (avg time) Ex: 5 blocks per hour
• How often are blocks removed
• Common reasons for "unblocking"
• Frequency of autoblocks?

While we're in there — yes these would be good to have to paint a complete picture.

What is the distribution of the most common block length options? (e.g. 500 wikis have 'indefinite' 500 have '1 day' 300 have '1 week' etc.)

Will this be in the past year? 7 days?

This is specifically about what's defined in MediaWiki:Ipboptions, so it would be a one-time snapshot.

One suggestion:

• How often is a block modified? (e.g. duration, talk page access on/off, updated summary)

Don't know how easy this is, and whether each type of modification needs its own query.

How often is a block modified/lifted by an admin other than the original blocking admin?

Great points. I've updated the ticket.

@dmaza I'm happy to help come up with mockup data tables to illustrate what type of results we're anticipating. "Per wiki, per hour, on average" can be interpreted in a few different ways.

@TBolliger Sure, if you want we can wait 'til we pick it up in a sprint and talk it through. Looks straight forward to me tho

From WMCON, @Matanya thinks the average block will be 2hr with reason as 'vandal'. :)

We should also look into (probably in another ticket) determining the block rate for new users. What percentage of new editors are blocked? Does this value change over time?

What percentage of blocks naturally expire vs. are manually unblocked?

@TBolliger, This means that I'd need to get blocks created in the last 7 days that expired already or that were manually unblocked before NOW. It can be done but we'll exclude any block with a lifespan longer than 7 days. I'm not sure how useful this is.

Or we can do dumb math (unblocks ➗ blocks). Let's drop it for now, i'll update the ticket.

I have collated all the data (sent via email) onto this Google sheets file (which is permissioned to certain WMF staff members).

Dayllan — can you please provide the exact date range(s) for each of these datasets? Thank you!

In T190328#4192272, @TBolliger wrote:

Dayllan — can you please provide the exact date range(s) for each of these datasets? Thank you!

April 30 - May 7 inclusive.

Below is the raw data generated from the queries.

@dmaza — I'm looking at this again and I'm skeptical there are only ~2,000 indefinite blocks on English Wikipedia of all time. According to Special:BlockList I see there were 255 infinite blocks just on May 9, 2018. Using basic math to extrapolate this to just one year, this is ~93,000 infinite blocks.

So, my understanding is the number in this data is for blocks set during the date range of April 30 to May 6, correct?

@TBolliger All the data is from April 30 to May 6.
If you need a different date range this can be easily adjusted and I can run them again.

OK, thank you for confirming. I think I was confused by the word "active" because it could either mean set within the daterange or all-time.

No need to generate anything else now. Thank you!