All Questions
Tagged with query or data-explorer
1,615 questions
4 votes
1 answer
147 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 ...
14 votes
1 answer
182 views
Use 'correct' site name for English.SE (and others) on SEDE
The Stack Exchange Data Explorer uses inconsistent naming for English Language & Usage Stack Exchange. The main site is abbreviated to English, the meta site uses the canonical name, with 'and' ...
2 votes
1 answer
168 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.
2 votes
0 answers
109 views
How to do fast pagination in the Data Explorer?
I'm trying to find the questions of a deleted user for a tag. Without any kind of pagination, I get 429 errors and never any results. So now I've written this query using skip-to-creationdate ...
23 votes
0 answers
175 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 ...
29 votes
1 answer
323 views
Unable to run any SEDE queries as Cloudflare keeps blocking them from running with a verification screen
I'm unable to run any single Stack Exchange Data Explorer query. I keep getting an error that "something unexpected went wrong while running your query". Per this prior post, this happens ...
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 ...
4 votes
0 answers
119 views
Downloading a SEDE execution plan leads to an internal server error
Steps to reproduce: Create a simple query like SELECT TOP 1 * FROM Posts Check the 'Include execution plan' option and click 'Run Query' Click the navigation tab 'Execution Plan', it's shown as a ...
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 ...
26 votes
1 answer
547 views
"Something unexpected went wrong while running your query. Don't worry blame is already being assigned" while in fact it needs Cloudflare verification
Happened to me a few times this week: I try to run an SEDE query, get this error Something unexpected went wrong while running your query. Don't worry, blame is already being assigned. while in fact ...
5 votes
1 answer
161 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 ...
8 votes
1 answer
152 views
The date on the SEDE home page is not updated?
The page https://data.stackexchange.com/ shows at the moment: "Data updated May 31 at 23:59" I think today update has already finished - at least according to this query created by rene. ...
10 votes
1 answer
165 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-...
17 votes
1 answer
352 views
Has anything changed about how SEDE counts request rate? I've started getting HTTP 429 recently
SEDE has been giving me HTTP 429 (too many requests) recently. I didn't used to have this problem. The past few days, I've just brushed it off and put up with it, but it's bothering me. I'm also now ...
24 votes
0 answers
237 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 ...