So, is there a query to get how far are you from the proofreader badge?
Something like How many Copy Editor/Strunk & White-qualifying edits have I made?
Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.
Sign up to join this communitySo, is there a query to get how far are you from the proofreader badge?
Something like How many Copy Editor/Strunk & White-qualifying edits have I made?
Probably, there might be. But why would you want to use one when you don't really need it?
You can get the numbers from the site without having to use the data explorer. You can find this by looking at any suggested edit you have reviewed. On the page, you'll see counts for how many you have approved and rejected. Add them up and you'll get your number.
Apparently you have made 70 reviews so far.
You can find the list of suggested edits you have reviewed by going to the activity tab in your profile and select the reviews filter. Click on the suggested edit
link on a review to see the page.
The simplest solution is to click on your user profile, and then "Select your next badge". If not obtained yet, Proofreader will be in the collection and there is a bar that tracks your progress (e.g. below).
Okay, I couldn't resist. It's a pain to navigate to the Reviewer Stats. Here's the SEDE query:
declare @UserId int = ##UserId##
SELECT
SUM(CASE WHEN VoteTypeId = 2 THEN 1 else 0 end) Approvals,
SUM(CASE WHEN VoteTypeId = 3 THEN 1 else 0 end) Rejections,
(100 - SUM(1)) AS VotesStillNeeded
FROM SuggestedEditVotes
WHERE UserId = @UserId
AND VoteTypeId in (2, 3)
https://data.stackexchange.com/stackoverflow/query/64662/how-close-am-i-to-the-proofreader-badge