In the Stack Exchange Data Explorer (SEDE), votes are not recorded with the user that cast them, for privacy reasons, except in cases of bounties and favorite votes.
However, for answer accept votes (VoteTypeId = 1), you can still find out who accepted an answer, by doing a double join on posts, like so:
SELECT p2.OwnerUserID AS [Voter_ID] , v.Id AS [Vote_ID] FROM Votes AS v INNER JOIN Posts AS p1 ON v.PostId = p1.Id INNER JOIN Posts AS p2 ON p1.ParentId = p2.Id
this works, but drastically complicates and slows down queries analyzing stats about accepted answer votes and similar.
It's obvious and desirable that Voter information is scrubbed for normal and secret votes in SEDE, but since an intended workaround exists, and since answer accepts are public anyways, I'd like to request a modification to the script that scrubs the
UserId field from
Votes to allow Accepted Answer Voters
UserId to persist.