1

Is there any query on Stack Exchange Data Explorer (SEDE) that retrieves the questions which are eligible for the asking days badges (curious, inquisitive and socratic)? I could not find one*.

There is already this nice query written by Bohemian, which returns how many questions are eligible, but it does not return which ones they are.

I read in this thread that if one question is deleted, closed or is negatively-scored the day it is asked, even though there were other well-received questions that day, they will not count towards the goal.

This is the motivation for my question, i.e., to visualize among the positively-scored questions, which ones are good to go. If such a query does not exist yet, it would be nice if someone could write it up. Tks.

*I don't know how to write one either.

Improve this question

1 Answer 1

Reset to default
4

Jon Ericson wrote the definitive query for this already; here's an improved version. This gives you a) the number of qualifying days, and what badges you'd have earned with those day counts.

However, take into account that deleted questions are not included in the data set so the query can only give you an approximation.

Improve this answer
5
  • Tks. Not sure if I followed your answer. For example: currently I have 4 questions eligible, but which ones? Can I retrieve that information in Jon's query? Commented Aug 1, 2014 at 15:19
  • @AndreSilva: But it is the days on which you asked that matter for the badge. You can play with the subqueries to get more info, but you'd need to extract the dates on which you are eligible, then map that back to the questions you asked on those days. Commented Aug 1, 2014 at 15:22
  • 1
    @AndreSilva: Really, this isn't about the individual questions, but all questions for that day. Commented Aug 1, 2014 at 15:23
  • No problem. This is nice information already. I was just curious to know if there was a way to see which threads lead towards that number of days. For example, if one user has 32 positively-scored questions asked in separate days and a record which passes the criteria, but let's suppose in three days out of these 32 he/she also asked questions which were deleted. Then, this user would need one more question to qualify for the Inquisitive. The query would provide the correct information (29), but maybe the user would be confused because the 32 questions. Thanks for replying, anyway. Commented Aug 1, 2014 at 15:32
  • @AndreSilva: the query would then count too many days as qualifying. Only the user and moderators can see what was deleted, for the user it is limited to questions deleted in the past 60 days. That makes it easier for the user to check on what days they had deleted questions and discount the corresponding number of days. Commented Aug 1, 2014 at 15:33

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.