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.

Filter by
Sorted by
Tagged with
3 votes
1 answer
134 views

How can one see how many regular users cast at least one reopen vote during the current year?

I am looking at some question reopening statistics. How can one see how many regular users cast at least one reopen vote during the current year? Preferably with the count of how many reopen votes ...
Franck Dernoncourt's user avatar
1 vote
1 answer
123 views

SEDE query to pull votes on a post within 90 days of its creation date

I am trying to query SEDE so I can count the upvotes (and I would also like to count the downvotes in its own column) that happen within 90 days after the question or answer was created. I have tried ...
Dennisdd's user avatar
10 votes
0 answers
134 views

Some Users have an AccountId being Zero

We know account creation is finicky from answers to questions like Why is my profile messed up on a single site and how can I revert it? among others. In some of these cases you end-up with a user-...
rene's user avatar
  • 86.2k
1 vote
1 answer
75 views

How to query SEDE for user sign-up dates for a specific community

We are looking to query a list of users to receive the sign-up dates to the Stack Overflow sub-community. Does anyone have a suggestion how to do this via SEDE?
Dennisdd's user avatar
9 votes
0 answers
110 views

How can we check how often questions sent to the close queue age out?

My site is dealing with a rather long close vote review queue and we believe reviews are regularly ageing out. We want to address the problem in Meta and motivate it with stats over time about how ...
gotube's user avatar
  • 537
2 votes
0 answers
109 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 ...
Martin's user avatar
  • 15.1k
2 votes
0 answers
122 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’...
Franck Dernoncourt's user avatar
4 votes
1 answer
345 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 ...
Alex's user avatar
  • 879
8 votes
1 answer
94 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 ...
Catija's user avatar
  • 103k
4 votes
2 answers
226 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/...
M--'s user avatar
  • 2,045
-9 votes
1 answer
111 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 ...
JMP's user avatar
  • 121
9 votes
1 answer
207 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 ...
nekketsuuu's user avatar
  • 1,625
-9 votes
1 answer
117 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 ...
Franck Dernoncourt's user avatar
4 votes
1 answer
57 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 ...
GratefulDisciple's user avatar
3 votes
1 answer
116 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 ...
I192058 Misbah Minhas's user avatar
1 vote
0 answers
89 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....
starball's user avatar
  • 21k
66 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 ...
Philippe's user avatar
  • 20.2k
9 votes
2 answers
270 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 ...
Martin's user avatar
  • 15.1k
3 votes
1 answer
393 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/...
I192058 Misbah Minhas's user avatar
2 votes
2 answers
168 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, ...
William Ledbetter's user avatar
5 votes
1 answer
181 views

Ranking users with most edits and close votes on a specific tag

A while back I asked this question about writing a query which would rank users based on their number of close votes on posts related to a specific tag: Table of users ranked based on their number of ...
M--'s user avatar
  • 2,045
1 vote
0 answers
36 views

View "people reached" data/trend through time for user

Is there a way to view a trend (graphically or tabulated) in the number of "people reached" per user per site? E.g., to see how many people a user's posts impacted monthly or annually, etc. ...
theforestecologist's user avatar
5 votes
2 answers
165 views

Table of users ranked based on their number of close votes in a specific tag

I am trying to get the list of users that have the most number of close votes (tallying each type of close votes; i.e. Duplicates, Too Broad, Need MRE, Not About Programming, etc.) in a specific tag. ...
M--'s user avatar
  • 2,045
5 votes
0 answers
37 views

Add a bit column for whether a badge is retired in SEDE or a RetiredDate column

It would be nice (for example) to be able to easily filter out badges that are retired when querying SEDE for analysis purposes. A bit for it would work, or alternatively, a nullable RetiredDate. Or ...
starball's user avatar
  • 21k
3 votes
1 answer
71 views

Why does this SEDE query think that the MathOverflow Meta is mathoverflow.meta.stackexchange.com?

I ran a query created by @peterh to find all my network posts. It works perfectly for the task, but it believes that all my posts made to MathOverflow Meta were actually made to https://mathoverflow....
LSpice's user avatar
  • 159
4 votes
0 answers
116 views

Some sites names shown in Data Explorer Stack Exchange doesn't match the current site name. Is this a bug or a feature?

Volume 1 : TL;DR Please fix the names of the sites in Data Explorer of Community Building, Music: Practice & Theory, Medical Sciences, Mythology and Folklore, Bricks, Cross Validated and "...
user avatar
13 votes
1 answer
293 views

Weekly SEDE refresh may be stuck restoring Literature.SE

I'm again looking at rene's SEDE query Status of the SEDE Refresh on Sunday 03:00 UTC to check the status, which is currently (in part): . category database_id Description create_date days ago 3 ...
Jeff Schaller's user avatar
-13 votes
1 answer
147 views

Why have you hidden the "Data Explorer" tool?

Why is Data Explorer tool accessed only by clicking the word "Data" at the bottom of the page? Correct it. Change the word "Data" to "Data Explorer". Bring the word &...
user avatar
8 votes
1 answer
203 views

When were comments first available on Stack Exchange?

I am curious about when comments first became available on Stack Exchange (or whatever the site was when the development occurred). I ask this because, in the Database schema documentation for the ...
William Ledbetter's user avatar
-19 votes
3 answers
259 views

Can GPT-4 be used to do SEDE queries?

I don't know how to do SEDE queries, but I would like to explore some of the Earth Science Stack Exchange data. Once I needed a query it was done by user rene, but I have many queries to do on Earth ...
user avatar
10 votes
0 answers
98 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. ...
Glorfindel's user avatar
  • 248k
1 vote
0 answers
31 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.
abbood's user avatar
  • 373
3 votes
1 answer
114 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 ...
abbood's user avatar
  • 373
2 votes
2 answers
79 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 ...
abbood's user avatar
  • 373
0 votes
0 answers
60 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 = ...
abbood's user avatar
  • 373
3 votes
1 answer
59 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?
αλεχολυτ's user avatar
-2 votes
1 answer
141 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 ...
stevec's user avatar
  • 1,235
1 vote
1 answer
183 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?
αλεχολυτ's user avatar
10 votes
1 answer
148 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 ...
tripleee's user avatar
  • 13.4k
3 votes
0 answers
86 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?
Tim's user avatar
  • 1
3 votes
0 answers
66 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:/...
Tim's user avatar
  • 1
1 vote
0 answers
66 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 ...
Tim's user avatar
  • 1
4 votes
1 answer
60 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 ...
William Ledbetter's user avatar
34 votes
1 answer
261 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 Bertrand's user avatar
  • 37.1k
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 ...
But those new buttons though..'s user avatar
6 votes
1 answer
95 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 ...
Glorfindel's user avatar
  • 248k
6 votes
0 answers
95 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 ...
Karsten Silz's user avatar
6 votes
1 answer
90 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 ...
SQB's user avatar
  • 4,686
7 votes
0 answers
73 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 ...
rene's user avatar
  • 86.2k
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 ...
James Risner's user avatar
  • 1,221

1
2 3 4 5
31