Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

This question already has an answer here:

This is mainly for SEDE use.

I know the basic VoteTypeIds, like 1 for accept, 2 for upvote, and 3 for downvote. There are also some other less well-known ones like 11 for undelete.

Is there a complete list somewhere I can refer to?

share|improve this question

marked as duplicate by Mat, hims056, Shadow Wizard, Grant Thomas, Rory Mar 10 '13 at 13:14

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

It contains the answer to your question, plus extra information. – Mat Mar 10 '13 at 12:32
There's an icon on these kinds of tables in the schema that you can click to get a list of values with their labels, for future reference. – Tim Stone Mar 10 '13 at 15:59
up vote 5 down vote accepted

You can run the SELECT id, name FROM VoteTypes on the Data Explorer:

The results:

Id | Name
-- | ----------------------
1  | AcceptedByOriginator
2  | UpMod
3  | DownMod
4  | Offensive
5  | Favorite
6  | Close
7  | Reopen
8  | BountyStart
9  | BountyClose
10 | Deletion
11 | Undeletion
12 | Spam
15 | ModeratorReview
16 | ApproveEditSuggestion
share|improve this answer
I wonder what happened to 13 and 14. – nneonneo Mar 10 '13 at 12:32

Not the answer you're looking for? Browse other questions tagged .