All Questions
Tagged with support data-explorer
702
questions
-19
votes
3
answers
264
views
Can GPT-4 be used to do SEDE queries?
I don't know how to do SEDE queries, but I would like to explore some of the Earth Science Stack Exchange data.
Once I needed a query it was done by user rene, but I have many queries to do on Earth ...
3
votes
1
answer
60
views
How can I find users with a specific number of earned/offered bounties?
How can I find users with a specific number of earned or/and offered bounties?
-2
votes
1
answer
173
views
How can you view the most upvoted comments on your posts (answers and questions)?
Is there a way to view the most upvoted comments from any of my answers or questions on Stack Overflow?
There are two similar questions/answers:
Search for my most upvoted comments and
Can I view a ...
1
vote
1
answer
292
views
Find posts deleted by authors, that deleted their own account later
How can we find posts deleted by their author that deleted their own account later?
3
votes
0
answers
90
views
How can I find my OpenID identifier for logging in to SEDE?
In my previous post, all the login options at SEDE seem to be linked to the same URL which doesn't work. The last one I haven't tried is OpenID. But how can I find it?
3
votes
0
answers
66
views
Why isn't there any captcha asked when running a new query in SEDE?
When I tried to create a new query on https://data.stackexchange.com/stackoverflow/query/new, I didn't see any hint for me to work on CAPTCHA, so I just clicked Run Query, and the next page was https:/...
1
vote
0
answers
67
views
Login options in SEDE do not work
Clicking the login options such as Yahoo in https://data.stackexchange.com/account/login?returnurl=/account/login?returnurl=/account/login?returnurl=/stackoverflow/queries doesn't work. Hovering ...
4
votes
1
answer
64
views
What is the difference between DisplayName and Id on the Stack Exchange Data Explorer Users table?
I am trying to pull a list of all users who have commented on an answer and tie it back to their User profile, if one exists. However, not all Comments table records have a UserId associated with them ...
6
votes
1
answer
100
views
SEDE does something weird with URL parameters
Can somebody explain what happens in this SEDE query? It's a very simple one, apart from the use of a parameter:
PRINT ('%href="##url##"%')
but somehow SEDE decides to append part of its ...
6
votes
0
answers
107
views
What's the Data Explorer query to get the latest data that Stack Overflow Trends shows?
Stack Overflow Trends shows the percentage of questions with a certain tag. Here's an example for Java IDEs. On Jan 7, 2023, this link produces this graph:
So VS Code is at 0.8%, and IntelliJ is ...
7
votes
1
answer
102
views
How can I find unaccepted answers using the SEDE?
While researching my question, "Are there any questions for which multiple answers have received enlightened badges?", I've created a query that searches for questions with multiple accepted ...
1
vote
1
answer
93
views
SEDE query to find progress on Four Ayes hat?
I've been working on a query to count the number of days a user's posts have had votes up, with no votes down on any day. But it seems like it's missing some posts. Users that have Four Ayes, do not ...
6
votes
1
answer
94
views
Finding closed questions from new contributors that others believe may be now reopenable
This query is fast, showing about 150 results right now:
WITH Closed_New_Contributors (PID, UID, Created)
AS
(
SELECT
p.id AS PID,
u.id AS UID,
u.CreationDate as Created
FROM Posts p
INNER ...
9
votes
1
answer
150
views
Is there a way (e.g. with SEDE) to find questions with an existing tag that's been synonymized (but not merged) into another tag?
Say Tag 1 has been added as a synonym of Tag 2, so that new questions attempting to use Tag 1 will be automatically pointed to Tag 2. However, the two tags haven't been merged (yet). Then, if you ...
2
votes
1
answer
90
views
Can someone make a query of number of questions, answers and average upvotes on answers on Earth Science Stack Exchange since its beginning?
Earth Science Stack Exchange is no longer a beta site, but this stats show it is not a healthy site.
My perception is there are a lot of inactive users that started to publish content in the ...