« first day (1573 days earlier)      last day (1085 days later) » 

1:30 PM
@JoeW I guess there are people who know more about this then me (@TimStone are you around?), but I'd guess that this is not possible.
In the description of Votes table in Database schema documentation for the public data dump and SEDE I read this:
> 6 = Close (effective 2013-06-25: Close votes are only stored in table: PostHistory)
 
@MartinSleziak That is what I was thinking but my knowledge of the data explorer is limited so I figured would check here
 
And there is also the table: PendingFlags "Despite the name, this table in fact contains close-related flags and votes."
So you can find which questions have pending close votes. You can find which questions have been closed.
But I do not think you can get the information who voted to close from database very easily.
There is also this:
> If PostHistoryTypeId in (10,11,12,13,14,15,19,20,35) this column will contain a JSON encoded string with all users who have voted for the PostHistoryTypeId
So it seems that you can extract list of close votes in some form. But this is probably not exactly what you are after.
 
queries I found for pending close votes all tended to involve questions that where in a review que
 
Still, I have to admit I am not that experienced with SEDE (and with SQL in general) either. Maybe somebody more experienced will be able to help
 
was mainly looking to see where I fell in the rankings of close voters on a site.someone got upset at a close vote I casted and accused me of being to quick to cast close votes so I just was wondering where i stood in the close vote rankings on the site.
 
1:49 PM
Apparently this query was an attempt to find close votes by an individual user: data.stackexchange.com/math/query/90447
I have modified it a bit so that I get a link which is clickable - to check whether it returns some reasonable results: data.stackexchange.com/math/query/869433/…
But when I try them on a small beta site, I get much smaller numbers than I expected.
 
thanks, I am looking at those now
 
And when I try it on a big site it runs out of time. :-(
If you have some time to spend, you can check what actually that query does. And maybe with changing startDate it could be possible to run it even on a bigger site.
 
The first of the top closer voters shows a count that is way to low for most people, including me. And the second one shows people with a null value for close votes but seems more accurate overall
I will play with them later but I think deleted posts are going to make it impossible to get an accurate answer
thanks again for the help
 

« first day (1573 days earlier)      last day (1085 days later) »