All Questions
Tagged with data-explorer badges
43
questions
5
votes
0
answers
40
views
Add a bit column for whether a badge is retired in SEDE or a RetiredDate column
It would be nice (for example) to be able to easily filter out badges that are retired when querying SEDE for analysis purposes.
A bit for it would work, or alternatively, a nullable RetiredDate.
Or ...
4
votes
1
answer
51
views
Query to get users with highest number of sites with at least one famous question
I want to know who are the top users across all sites in terms of number of sites in which they've got at least one famous question (so, count is across sites, not across famous questions).
I know ...
4
votes
2
answers
142
views
A query ranking users by number of badges per class - like the user card
I wanted a query that would rank users by total count of badges per class. That is, a ranking like the user card; with 3 columns: gold, silver, bronze - having the total counts (and possibly with the ...
10
votes
1
answer
235
views
Users should have the "Unsung Hero" badge, but they have not
I wrote a SEDE query to find the users who should have the Unsung Hero badge, but they have not.
The query simply counts the non-CW, not self-accepted, but accepted answers of the users, and compares ...
4
votes
1
answer
100
views
Write a query to get top rep. users who have silver badges, but no gold ones
I am trying to compose a query that will list all high rep users who have a silver badge, but no gold ones.
I am new to the SEDE. I have gone through the tutorial and properties documentation, but I ...
11
votes
1
answer
121
views
What proportion of Peer-Pressure and Disciplined-badge-earning posts stay deleted?
As far as I know, one can earn the Peer Pressure and Disciplined badges by deleting and subsequently undeleting posts with the appropriate scores (-3 and +3, respectively). See: I cheated on the ...
6
votes
1
answer
73
views
Edit counts toward Strunk & White badge do not always add up to 80
There are a number of similar questions but they don't seem to capture the following: There is a list of criteria for edits that do / do not count towards the Strunk & White badge; however, when I ...
4
votes
1
answer
58
views
Why is there some data unaccessible from the Data Explorer? [duplicate]
I was wondering why I didn't get the Unsung Hero badge when I theoretically should have it on Stack Overflow.
The How Unsung am I? requests shows only 10 unscored answers, the real count is 11 but ...
-4
votes
1
answer
94
views
What is the fastest and average time to attain each badge?
These seem to be interesting questions to understand in general how much effort is expended to attain a badge.
Effort is the wrong word, some badges are gained through fortune or uncontrollable chaos....
4
votes
2
answers
91
views
I want to find the number of unique badges a selected user has
I want to find the number of unique badges a selected user has, i.e. 737 (https://stackoverflow.com/users/22656/jon-skeet).
SELECT
Users.Id AS [Id], Users.DisplayName AS [Display Name],
COUNT
...
5
votes
1
answer
100
views
How can I see who has the most of a certain badge?
On a site, I've gotten 4 of a certain gold badge now and that made me curious to see who has the most, or maybe a list of users ordered by the number of times they've earned that badge.
I'm not ...
4
votes
3
answers
142
views
How to retrieve exact reputation on "legendary day"?
Some weeks ago I asked about the most legendary users on the network. Now that my name shows up in that list as well (or will show up when the SEDE data is updated) - a comment of another user ...
4
votes
1
answer
131
views
How to select users with a gold Angular badge
I'm using the following query on SEDE to select top 100 users with angular gold badge:
SELECT TOP 100 UserId AS [User Link], COUNT(*)
FROM Badges
WHERE Name IN ('angular')
GROUP BY UserId
ORDER BY ...
2
votes
1
answer
65
views
How is it possible to be the 4979th user to get a bronze tag in Java, but rank 8260?
When I was awarded Bronze tag in Java my number was 4979. But the rank as shown here is 8260?
How is it possible?
1
vote
0
answers
56
views
Strange behavior in unsung hero query
I recently notice that I'm close to get the Unsung Hero Badge so I run this query
How Close Am I to Unsung Hero Badge (Including 10 days requirement)? with my userId 4848308 and I get as result
| ...