@Martin - Thanks for working on your query. I don't see anything in the Reputation column. But the first column is labeled "score" so maybe that is indicative. // Can you run it retroactively? Get previously suspended users, to compare against last year?

@aparente001 Maybe just scroll a bit to the right.

For each user, I see reputation 1.

Score is sum of scores over all posts, so it can be taken as a very rough approximation of reputation. (It does not take into account daily reputation cap, downvotes, bounties, suggested edits, etc.)

@Martin - Oh, right. We are using the fact that the reputation has been forced down to 1 in order to collect the correct individuals. So that would not allow me to see what their reputation used to be. But I guess the score would help.

Getting better approximation of reputation from SEDE is more complicated.

Just to get a general idea of the person's general level of being an asset to the site.

What about last year?

Similarly, LastActivityDate might serve as an approximation of the suspension date.

@aparente001 In this way you'll get only users who are suspended at the time.

Yes, that looks helpful.

I do not know about some way how to get users who were suspended at some date.

That would allow for a comparison over time.

To be more precise, is should have said at the time of last update of data in SEDE.

There are some data dumps archived quarterly - but that's probably not sufficient for what you're asking about.

The SEDE query I posted was intended just as a rough estimate of the current state. (Many of the suspensions there are completely unrelated to current events.)

I'd guess that SE staff has some access to stats about suspensions (or would be able to create such stats). It's up to them whether they want to reveal such stats or not.

@Martin - Hello again. I wonder if you have any way of improving a query that was created at meta.stackexchange.com/q/340693/287826. I would like to have links to all these people's posts and comments published since late September if possible.

@aparente001 Isn't that basically what Glorfindel query does. Possibly the only thing is that you might need to updated the list of ids if some staff members are missing there.

It is not difficult to modify the query to get the list of comments (rather than posts): data.stackexchange.com/meta.stackexchange/query/1173296/…