« first day (1024 days earlier)      last day (1073 days later) » 

12:01 AM
Is there a way to access the users who closed a question via the SEDE? It doesn't show up here in the listed data
 
 
6 hours later…
5:39 AM
@cairdcoinheringaahing yes, you can look for PostHistory, rows where posthistorytypeid = 10, the text column will have an JSON with the close voters. Here is an example query how you can leverage that: data.stackexchange.com/codegolf/query/1409173
 
 
14 hours later…
7:53 PM
@rene Thanks! I'm looking to count the number of times a specific trio of users closed a question together. I tried playing around with the example, but I can't seem to get the list of voters for each question together to work with
 
 
1 hour later…
9:21 PM
@cairdcoinheringaahing here you go: data.stackexchange.com/codegolf/query/1409173 I assume you can add/replace the userids you need.
 
9:43 PM
@rene Oh wow, thanks! Still learning SQL/SEDE :P Yeah, I can handle the ids no problem, thanks!
 
10:02 PM
@cairdcoinheringaahing I can probably do a better job with a pivot table but if it is only three then this will work ... me lazy.
 

« first day (1024 days earlier)      last day (1073 days later) »