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,606 questions
18
votes
0
answers
319
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 ...
- 55.5k
5
votes
1
answer
136
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 ...
- 16.9k
8
votes
1
answer
119
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.
...
- 16.9k
9
votes
1
answer
141
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-...
- 355
12
votes
0
answers
205
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 ...
- 35.7k
24
votes
0
answers
220
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 ...
- 25.6k
13
votes
1
answer
176
views
SEDE is being weird and returning a bunch of errors
I'm trying to run an existing SEDE query as a logged-in SEDE user. When I click "Run", I get this error:
Line 65536: Cannot open database "StackOverflow" requested by the login. ...
- 35.7k
1
vote
1
answer
92
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 ...
- 55.5k
4
votes
1
answer
64
views
How can I view all posts that have been featured on Meta Stack Exchange?
Is there a way to view a list of every post that has been featured (ie: had the featured tag) on Meta Stack Exchange? I am open to using either the site's built in search bar or Stack Exchange Data ...
- 16.5k
10
votes
2
answers
151
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 ...
- 16.9k
6
votes
1
answer
105
views
In SEDE, how do Id and CreationDate relate for Comments?
This question is based on my experience-based assumption that comment IDs are auto-incrementing. That is, previously, the general pattern I saw in comment IDs is that a new comment gets the next ...
- 35.7k
2
votes
1
answer
73
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.5k
6
votes
0
answers
139
views
How do I get a list of DMCA Takedowns on Stack Overflow?
I wrote a query in Stack Exchange Data Explorer to find Post Notices for DMCA Takedown Requests, which the Schema says is PostNoticeTypeId 9001.
SELECT
PostId,
PostNoticeTypeId,
CreationDate AS [...
- 16.5k
2
votes
1
answer
58
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.5k
1
vote
1
answer
57
views
Why is my SEDE query for questions with bounties returning historical locks instead?
I wrote a query for Stack Exchange Data Explorer to find questions that have had bounties on Stack Overflow.
SELECT
p.Id,
p.Title,
pnt.ClassId,
pn.PostNoticeTypeId,
pnt.Name AS ...
- 16.5k