« first day (997 days earlier)      last day (17 days later) » 

7:08 AM
@rene I know nothing about how to write SEDE queries (though, I have read its guideline some times). Can you help me? As far as I know, all information visible in profiles can be viewed by SEDE, right? For example, can we know which users have top flag statistics on a SE community?
 
 
6 hours later…
1:31 PM
@Later no, not all data. Flags are not in SEDE, here is all we have for your profile on MSE: data.stackexchange.com/meta.stackexchange/query/1399272 the best you can find are your total upvotes and downvotes.
 
1:50 PM
@rene Thanks. However, the number of flags is visible in profiles, so why can such statistics not be viewed in SEDE?
 
2:01 PM
I meant whether we can find the list of users in the order of the number of (helpful) flags.
I meant the list of users ranked by helpful flags, for example.
 
@Later not everything is added by Stack Exchange. For example the users table also lacks the twitter url and github name. On the reviews table it is missing the userid while on the site you can see which users performed a review. Historically the data is limited, there are a lot of requests to add a bit more but those are hardly ever honoured. Help flags is one of those datapoints that is missing.
No SEDE but scraping :(
Here is the full schema for SEDE: meta.stackexchange.com/questions/2677/…
 
Ok thanks. How about the list of users ranked by number of downvotes?
 
Is it possible to restrict such data for the last month? I mean users ranked by number of downvotes in the last month.
 
No, that is not possible. That would make it way to easy for users to retaliate against users that downvote them.
Voting remains anonymous, also/even in SEDE
You could run this query every month and then compare results between months yourself.
But that only works for starting now, going forward.
 
2:18 PM
However, one can know active users on each website. So with help of the query you linked, one can guess who have cast most downvotes, right?
 
Yes, not even guess, you'll know
SEDE is updated only once per week
so you get fresh data on sunday
 
Can you estimate how many distinct users cast votes on new posts on Meta.SE per a month?
 
No, you can't. You only know votes per post. Not who voted.
 
You are here for a long time. You cannot guess anything?
 
@Later top 1000 of users that have a lastaccess date > Apr, 1st ordered by overall downvotes data.stackexchange.com/meta.stackexchange/query/1399300
@Later No, not really.
 
2:25 PM
The community team must have such information, right?
If I ask such a thing on Meta, will the community team respond to me?
 
@Later at most 574 users casted a downvote since april 1st (because you can only vote once on a post).
 
Any posts (question & answer)?
 
@Later I doubt it. There are a lot of these requests and many go without an answer. Only if the data is needed to improve content quality/ moderation. So you need a bloody good reason before they even start considering putting effort in writing the query and hand you the stats. And just curious is not a good reason ;)
@Later yep, i can split that, if needed
 
Yes. I only interested in questions
 
@Later same query updated, 412 now
 
2:37 PM
Why did you say "at most"? I mean it should not be "exactly"?
I got it. Never mind.
Ok. Thank you very much.
 
You're welcome. Careful with the data. Use it responsibly.
 
For sure.
 
thanks
 

« first day (997 days earlier)      last day (17 days later) »