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,574
questions
2
votes
0
answers
112
views
Should Windows Phone site be removed from SEDE?
I have noticed that it is possible to see Windows Phone as one of the sites where one can run SEDE queries. As an example, here is a query listing the recent posts.
This query shows the date as the ...
2
votes
0
answers
127
views
The visual human test sometimes appears very far away from the captcha checkbox in SEDE
The visual human test sometimes appears very far away from the captcha checkbox:
(click for full size)
Tested on an iPhone with Chrome. This is inconvenient because one has to unzoom to find it. It’...
4
votes
1
answer
765
views
How can I view unread messages?
At one point I had up to a hundred of unread messages. I read many of them, but the notification icon says there are four I have not. Because of the sheer number of the messages, I am having ...
8
votes
1
answer
96
views
Can you save an edit to a SEDE query's title or description without editing the query?
I don't create queries in SEDE much but when I do, I forget to give them a useful title and description until after I'm finished creating them and click the permalink button.
In an effort to avoid ...
5
votes
2
answers
249
views
Search for comments on posts with a certain tag based on a keyword
I am trying to get the comments on posts with a specific tag which include a phrase or a keyword of interest using SEDE. Here's my first attempt: https://data.stackexchange.com/stackoverflow/query/...
-8
votes
1
answer
119
views
Finding my upvotes on Data Explorer
This T-SQL finds all the questions I have answered on SO.
https://data.stackexchange.com/stackoverflow/query/1779459/questions-i-have-answered
I want to determine if I upvoted the question or not (as ...
9
votes
1
answer
215
views
SQL query used to calculate staff escalation statistics doesn't take into account different tag names for international sites
This is a bug report of a SQL query used at What posts should be escalated to staff using [status-review], and how do I escalate them?.
In the above post, status-review posts are counted using this ...
-9
votes
1
answer
118
views
Add option to download a message in SEDE
In SEDE, one can download the results as a CSV file, but there are no options to download a message.
Feature request: Add an option to download a message in SEDE. That'd be useful for queries ...
4
votes
1
answer
60
views
Can I see other user's badge progress and/or tag progress short of doing SEDE query?
I can see my own badge/tag progress in the "Select your next badge" dialog box from the User Activity screen. For example, I can see that I'm 455/500 for a gold Copy Editor badge in ...
3
votes
1
answer
121
views
Discrepancy in Post Counts between Local MySQL Stack Overflow Database and Data Stack Exchange Query
I recently downloaded the Stack Overflow data from Stack Overflow datadump and imported it into my local MySQL database. While attempting to retrieve the total number of posts for the year 2021 using ...
1
vote
0
answers
95
views
What am I supposed to do when I get what is probably the "requires external JavaScript" error for the chat domains and SEDE?
I'm suddenly getting this error in my main sites (like SO and MSE)
Meta Stack Exchange requires external JavaScript from another domain, which is blocked or failed to load. Retry using another source....
63
votes
11
answers
4k
views
The company's commitment to the data dumps, the API, and SEDE
Many words have been written around the company's commitment to the ongoing existence of the data dumps, the API, and the Stack Exchange Data Explorer (SEDE). Much of that text can be confusing or ...
9
votes
2
answers
278
views
What exactly do VoteTypeId=4 (offensive) and VoteTypeId=12 (spam) mean?
According to the Database schema documentation for SEDE, the table Votes contains as VoteTypeId 4 = Offensive and 12 = Spam. The latter was mentioned, for example, here: How to find posts closed as ...
3
votes
1
answer
523
views
How can I download a small data set (1 year 2023-2022) from Stack Exchange?
I want to download a small dataset for one year. I didn't find a link that allows me to download 1 year of data or the last five years' data.
I tried "https://data.stackexchange.com/stackoverflow/...
2
votes
2
answers
196
views
Does Stack Exchange offer any incentives related to use of their data explorer in research?
I'm interested in whether or not there have historically been this sort of partnership with research in the academic space or if it is planned for the future. This could be something like a grant, ...