Is the count of anonymous feedback available in the schema?

Question

I've been interested in what sort of questions are helpful to anonymous people rather than regulars. I would like to get a count of anonymous feedback "Helpful" and "Not Helpful" votes on a question.

I cannot see how that information is available through the schema.

I am not sure if I am simply missing something staring at me in the face, or whether the Stack Exchange team have decided it isn't worth sharing this information. (Or another alternative I haven't considered!)

How do you fetch a count of anonymous feedback helpful votes on a post through the Stack Exchange Data Explorer?

Answer 1

It's in the PostFeedback table, where an up vote (VoteTypeId = 2) corresponds to helpful, and a down vote (VoteTypeId = 3) is not helpful.

So for a given post ##PostId##, the query becomes something like

SELECT COUNT(CASE WHEN VoteTypeId = 2 THEN 1 END) AS HelpfulVotes,
       COUNT(CASE WHEN VoteTypeId = 3 THEN 1 END) AS NotHelpfulVotes
FROM PostFeedback
WHERE PostId = ##PostId##
GROUP BY PostId

You may want to add a where clause in there to filter on IsAnonymous too, depending on whether you care to exclude registered users who can't vote or not from the totals.