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.
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.
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