Questions tagged [data-explorer]
For questions about the functionalities, queries, databases and datamodel of The Stack Exchange Data Explorer (SEDE). SEDE allows you to create and run queries against copies of the databases of popular Stack Exchange sites.
1,517
questions
10
votes
0
answers
91
views
Add tooltip with exact timestamp to 'Data updated ... ago' label on SEDE homepage
Can we add a tooltip with the exact UTC timestamp to the 'Data updated ... ago' label on the SEDE homepage? It would help indicating whether the refresh was slow (as it was today) or even incomplete. ...
GlorfindelMod
- 239k
1
vote
0
answers
28
views
Where is the GitHub link in the Data Exchange Explorer located? [duplicate]
I went closely over the SEDE's fields, but couldn't find where the GitHub link is saved for a user:
I ran this query on my own profile but couldn't find my GitHub account.
- 363
3
votes
1
answer
105
views
How do I get the highest posters for a certain tag in a specific country?
I would like to get the user IDs, user names, the number of posts, and the total score for a certain tag for each user in a specific country (sorted in descending order by score).
For example, in the ...
- 363
2
votes
2
answers
72
views
How can I get the total number of posts for a user that have a certain tag in them?
User abbood (myself) has eight posts (in total) that have the tag cocoapods; six questions and two answers.
I thought that this query should simply get all eight:
SELECT Count(*)
FROM posts p
...
- 363
0
votes
0
answers
55
views
Why isn't the summation of a user's score equal to their reputation? [duplicate]
I was going over the database schema documentation and was trying to understand how the Post scoring system works. I was expecting this query:
select sum(p.score)
from posts p
where p.OwnerUserId = ...
- 363
2
votes
1
answer
50
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?
- 55.3k
-2
votes
1
answer
94
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,215
2
votes
1
answer
115
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?
- 55.3k
11
votes
0
answers
96
views
Data Explorer throws server error when attempting to query Psychology & Neuroscience
The Stack Exchange Data Explorer lets you write SQL queries to find questions, answers, comments, users etc across the StackExchange network, but the query interface throws an error if I try to select ...
- 9,618
3
votes
0
answers
83
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?
- 1,700
4
votes
0
answers
62
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,700
2
votes
0
answers
65
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 ...
- 1,700
4
votes
1
answer
53
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 ...
34
votes
1
answer
239
views
The current SEDE refresh was delayed overnight
On Saturday, January 22nd, we had a failure on a backup share that won't be fully resolved until Monday.
We've immediately re-routed backups to multiple secondary locations, so that concern has been ...
Aaron BertrandStaff
- 34.8k
5
votes
0
answers
60
views
Scrolling issues on data.stackexchange.com
I am encountering a couple of scrollbar issues viewing the results table on data.stackexchange.com. I am using OS X 10.14.6 using both Firefox 108.0.2 and Chrome 108.0.5359.98:
This happens only in ...
- 227
5
votes
1
answer
83
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 ...
GlorfindelMod
- 239k
6
votes
0
answers
71
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 ...
- 161
6
votes
1
answer
84
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 ...
- 4,616
7
votes
0
answers
66
views
The magic column [tagname] should handle number columns results gracefully
The magic column [tagname] will decorate and auto link tag names when used in a query. This feature relies on the JavaScript processing in the browser. The client-side script assumes it will always ...
- 84.1k
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 ...
- 1,151
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 ...
- 1,151
7
votes
1
answer
80
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 ...
- 5,317
4
votes
1
answer
43
views
How do I extract posts from Data.SE that contain code in them?
I'd like to extract posts from Stack Overflow using Data.SE, that contain code in them. I am mainly interested in the posts that come from the tag [artificial-intelligence]. Here is the code that I ...
- 183
8
votes
0
answers
101
views
Drop Posts.FavoriteCount from SEDE
Related: What happened to FavoriteCount? - my educated guess is that a NULL value indicates a question has never been favorited or bookmarked, and 0 that it was. Since the values are so different from ...
GlorfindelMod
- 239k
2
votes
1
answer
73
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 ...
10
votes
1
answer
103
views
What does the error message "unknown job being polled!" mean on SEDE?
Error message seen on the first attempt to run this query anonymously:
unknown job being polled!
Screenshot:
The second attempt to run the query was successful.
- 28.6k
6
votes
1
answer
62
views
What basic logic decides what does or doesn't get included in SEDE?
What basic logic decides what information does or doesn't get included in SEDE?
And what are the nuances for when certain things might not follow that basic logic?
I'm looking to get a kind of ...
- 5,586
10
votes
1
answer
79
views
Is it possible to use cached results of an already-run query in another query?
The results of queries are cached until the next refresh: 1, 2.
Is it possible to refer to those cached results in other queries?
I imagine if there is, it might look something like this:
SELECT * ...
- 5,586
8
votes
0
answers
115
views
SEDE refresh triggered multiple times today
As we all know, SEDE is refreshed every Sunday morning, but immediately after it finished (Stack Overflow is the last site, always somewhere before noon UTC), it seems to have triggered a new refresh ...
GlorfindelMod
- 239k
5
votes
1
answer
90
views
Searching my own unanswered questions over all Stack Exchange sites
I wish to get a list of my own unanswered questions over all Stack Exchange sites.
It seems you can run SQL queries with data.stackexchange.com, something I learned only today. Is there a way I can ...
- 161
3
votes
1
answer
84
views
Why can I not filter the Posts table in data.stackexchange by tags?
While trying to write a query on https://data.stackexchange.com/datascience/, using the Posts table, I cannot filter by tags.
For instance, if I try to extract the tags from the Posts table:
select ...
- 183
5
votes
0
answers
99
views
What happened to FavoriteCount?
On 10/22 I ran a query on the Data Science SEDE. In the Posts table I selected some columns, FavoriteCounts included. Looking at the results from the .csv I see a lot of different unique values for ...
- 51
4
votes
0
answers
53
views
Captcha in SEDE sometimes doesn't appear
Captcha in SEDE sometimes doesn't appear:
The "I'm not a robot" challenge is not displayed. Instead, it should be:
Infrequent (<5%). Tested on Chrome+Win 10 as an anon user. I ...
- 28.6k
3
votes
0
answers
47
views
SEDE quick-view of CloseAsOffTopicReasonTypes table does not match query result [duplicate]
#5 quick-view is about super-user, but query is about SSCCE
#6 quick-view is about career / office politics, but query is about minimal understanding
#7 quick-view is about what tech to learn next, ...
- 5,586
5
votes
0
answers
49
views
In the SEDE sidebar, give the "i" icon (show table contents) a larger hitbox
Proposal: Give the i icon in the SEDE sidebar some horizontal padding for larger hitbox.
Currently, the i icon which shows the table contents for small enum-like tables has a small hitbox (...
- 5,586
12
votes
1
answer
142
views
What does replacing of bookmarks with saves mean for SEDE?
So, relatively recently bookmarks were replaced by saves: Bookmarks have evolved into Saves.
In SEDE, bookmarks were stored in the votes table. They were stored with VoteTypeId=5 and the user was ...
- 14.8k
9
votes
1
answer
98
views
Is there a way to filter posts created with the Ask Wizard in the Data Explorer?
Stack Overflow recently re-debuted the Ask Wizard for use by new users.
Using the Data Explorer, is there any (current or planned) way to query posts that were created using this tool?
- 278
16
votes
0
answers
110
views
Some users can still create bookmarks
The unfortunate decision has been made to evolve Bookmarks into Saves. One of the key changes was:
Will my saved posts and lists be public?
Nope!
and with that a whole bunch of Data Explorer queries ...
- 84.1k
6
votes
2
answers
134
views
Query for getting top users on a specific tag by country sorted by tag score (Stack Overflow)
I need a query for getting top users on a specific tag by country sorted by tag score on the Stack Overflow site.
For example.
Top users of JavaScript that live in the United States and sorted by ...
- 71
7
votes
0
answers
76
views
"Verification expired" when anonymously running an SEDE query
I ran a long SEDE query without logging in. Did the captcha, but after ~30 or ~60 sec got "Verification expired".
Unsure if bug or feature request. Saw it quite often over the past few ...
- 28.6k
2
votes
1
answer
95
views
How to run a Stack Exchange data query with the Stack Exchange API
I'm trying to find out if there is a way to run a query/complex search on the Stack Exchange API.
I need to find all users that have a reputation greater than 250 and are from a certain location. I ...
6
votes
1
answer
118
views
Why do I have numbers in my username when I logged in to SEDE?
Today I logged in at https://data.stackexchange.com/ using my Stack Overflow account. I got surprised when I found numbers in my username in the top bar.
My username is Cédric, but when I logged in, ...
- 241
18
votes
1
answer
203
views
Weekly SEDE refresh has been contemplating Buddhism for a significant amount of time
Buddhism is interesting, surely, but either the weekly SEDE refresh has gained some Artificial Intelligence and is contemplating rebirth, or something is stuck. I'm not sure which one to hope for!
I'm ...
- 1,781
8
votes
1
answer
145
views
Which sites have the most prominent top users?
I was looking at the top users of Chess Stack Exchange and noticed the top user @BrianTowers has more than twice the reputation (79k) of the next user @PhishMaster (32.1k). Are there more Stack ...
GlorfindelMod
- 239k
5
votes
2
answers
233
views
Highest reputation moderators?
Highest-rep users on the network are easy enough to find. What about highest-rep moderators? We all know that moderation ability doesn't necessarily correlate with reputation, and moderators on ...
- 28.1k
1
vote
0
answers
82
views
Is there a way to check the change of geographical distribution of user base on SE?
I found geographical distribution checkers on SEDE, but is there a way to see how the population changes with time?
I want to see, for instance, from what country most people are joining vs from what ...
11
votes
1
answer
136
views
An edit missing from PostHistory in SEDE
I was looking at the revision history of the question "Is all ordinary mathematics contained in high school mathematics?" on MathOverflow (revision history, edit suggestion). I was curious ...
- 14.8k
18
votes
1
answer
297
views
Weekly SEDE refresh stuck at Gaming.SE
The weekly SEDE refresh is stuck, this query shows the problem occurred while copying the Gaming Stack Exchange database:
Note: a similar thing happened before.
GlorfindelMod
- 239k
2
votes
1
answer
63
views
Search a SO post that I closed with a certain keyword
Is there a way to search for a Stack Overflow post that I closed and that has a certain keyword say "this" or certain code say this in it?
I mean, I want to search by typing in the search ...
- 359
36
votes
0
answers
317
views
Can't login to SEDE - "StackApps authentication failed"
When I try to login to the Stack Exchange Data Explorer using Stack Overflow, it fails with the following error message:
StackApps authentication failed
I've tried several browsers, and even in ...
GlorfindelMod
- 239k