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,615 questions
4
votes
1
answer
138
views
Opinion-based questions are missing from SEDE
I can't find posts from the new opinion-based questions experiment in SEDE. I've tried it with a slightly older one where I know the Id (79805930) and it is not in the Posts nor the PostsWithDeleted ...
- 199k
2
votes
1
answer
164
views
How to sort all Stack Exchange sites by their average time to approve suggested edits?
How can I list all Stack Exchange sites in order of their average duration to approve suggested edits? I'd like to know which sites approve suggested edits the fastest, the slowest.
- 129
23
votes
0
answers
174
views
SEDE is hitting the 429 error way too often due to how SEDE works
There have been a couple of previous reports on 429 errors when using SEDE. There is one marked status-norepro and I'm here to re-raise that issue, not as a support ticket but as a bug.
Here is ...
reneMod
- 94.5k
2
votes
0
answers
110
views
Contradictory SEDE error message “A severe error occurred on the current command… Operation cancelled by user” even though I never canceled operation?
I encountered this error message when trying to run a SEDE query (screenshot):
Line 0: A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by ...
- 58.9k
2
votes
0
answers
87
views
Wrong update date in Stack Exchange Data Explorer [duplicate]
The current SEDE homepage shows:
Data updated Aug 16 at 23:58
If I perform queries though I get results that are much newer, the cutoff seems to actually be around August 30. I only checked the SO ...
- 199k
5
votes
1
answer
156
views
Is it intentional that ParentId is present only if the question is not deleted?
The Database schema documentation for the public data dump and SEDE lists ParentId among the things which are present in the PostsWithDeleted table.
However, if you check the deleted answers, the ...
- 17.2k
10
votes
1
answer
164
views
SEDE is currently broken
When I click Run Query in SEDE, I get transported to https://data.stackexchange.com/query/save/1 and it returns the raw JSON:
{"running":true,"job_id":"6c3e4379-aabf-46aa-91d3-...
- 439
24
votes
0
answers
234
views
Stack Exchange Data Explorer migration to .NET 8
In case you folks missed it, we’re moving Stack Exchange to the cloud! And during that project, we saw an opportunity to leverage SEDE to try some cool containerization work in Linux there and avoid ...
- 26.3k
1
vote
1
answer
102
views
How can I return a table with links to comments in SEDE?
E.g. consider this SEDE query that lists 5 comments:
select top 5 c1.id, c1.Text
from Comments c1
ORDER BY id ASC
Output:
How can I add a column containing links to the comments (not links to the ...
- 58.9k
10
votes
2
answers
161
views
What causes the difference between score and (upvotes-downvotes) in SEDE?
As far as I can tell, there are some posts in SEDE where you get different number from Posts.Score and different number if you count upvotes and downvotes from the Votes table.
However, as you can see ...
- 17.2k
2
votes
1
answer
79
views
How do I find locked questions with Data Explorer?
I am trying to get a list of locked questions on Stack Overflow. Initially I tried searching for PostNotices that have PostNoticeTypes.ClassId=4 (Moderator Notice). However, this leaves out questions ...
- 16.9k
2
votes
1
answer
63
views
What is the PostNotices.ExpiryDate field used for in Stack Exchange Data Explorer?
The Schema for Stack Exchange Data Explorer says the PostNotices table has fields for DeletionDate and ExpiryDate. I assume the DeletionDate is when a Notice is removed from a post, but I can't figure ...
- 16.9k
5
votes
1
answer
93
views
How can I search my deleted posts on Stack Exchange Data Explorer?
I want to use Stack Exchange Data Explorer to find questions I wrote that have been deleted by the community user. However, I get no records when I search PostWithDeleted for posts with my OwnerUserId ...
- 16.9k
0
votes
0
answers
54
views
Has anyone calculated the votes per view ratio for questions on each Stack Exchange site? [duplicate]
I've noticed the votes per view ratio for each question appears to be extremely low on most Stack Exchange sites.
Has anyone calculated the votes per view ratio for each Stack Exchange site?
If so, is ...
- 2,076
6
votes
1
answer
179
views
How do I figure out why a SEDE query failed with "Bad SQL command."?
I've been trying out the (relatively) new site-querying views and periodically stumble upon this error:
Line 240: Bad SQL command; no donut. Try again in 6 to 8 weeks.
What's the easiest way to ...
- 3,213
23
votes
0
answers
243
views
Stack Exchange Data Explorer (SEDE) refresh will skip one week
Stack Exchange is currently in the process of migrating critical infrastructure to the cloud, as outlined in this post, and we are on approach to major database migration milestones. We're currently ...
- 13.4k
3
votes
0
answers
54
views
Running SEDE queries fails silently if a user was logged in when loading the query page, then logged out before clicking on "Run Query" [duplicate]
Bug (or lack of error message): Running SEDE queries fails silently if a user was logged in when loading the query page, then logged out (e.g. due to SEDE quick logout time) before clicking on "...
- 58.9k
28
votes
3
answers
1k
views
Posts from deleted users are missing from Data Explorer and Data Dump
I wanted to query for answers where the user account has been deleted, but the answer is still up. According to this link (https://stackoverflow.com/help/deleting-account), deleting your account will ...
- 643
9
votes
0
answers
80
views
Make SEDE queries automatically run after the captcha is completed [duplicate]
On the SE Data Explorer, anonymous visitors must complete a captcha. This isn’t unreasonable at all.
The captcha presents after “Run Query” is clicked/pressed. After the captcha is completed, visitors ...
- 3,870
15
votes
1
answer
525
views
Adding new indexes to Data Explorer Stack Exchange tables?
This is in regards to the Stack Exchange Data Explorer, specifically, its query creator.
I am trying to run some queries about Stack Overflow involving CreationDate on the table PostsWithDeleted, but ...
- 643
-3
votes
1
answer
257
views
Is there a table that holds the badge name, its description, and retired status?
SO has badges that are awarded to users for completing some tasks. I was playing around with SO Data Explorer and noticed there is no table for badge definition itself.
So for example if I want to ...
- 577
10
votes
1
answer
337
views
A SEDE query that worked for years is now timing out for the last ten attempts [duplicate]
The SEDE query All my posts on the SE network (with Markdown and HTML content plus editors and status) has been working for years, however over the last week, and the last ten attempts, this error ...
- 569
16
votes
1
answer
363
views
Weekly SEDE refresh is stuck
It looks like Stack Overflow has been refreshed properly, but the next couple of sites are not making any progress.
GlorfindelMod
- 270k
11
votes
2
answers
349
views
How to get SE sstatic images for my website
I've written about 2,500 questions and answers in Stack Exchange sites. About half of them I scrape into my website on GitHub Pages for customized presentation and searching.
A short time ago all the ...
- 569
28
votes
2
answers
535
views
Why was anonymous/low-rep post feedback not collected for a period in 2024?
When viewing the monthly post feedback stats in the 10k tools on Stack Overflow, I noticed there is no data:
This happens for it being set to "day", "week" and "month".
...
- 4,931