Skip to main content

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.

190 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
39 votes
0 answers
2k views

Planned SEDE maintenance scheduled for Sept 22, 2021 at 01:00-04:00 UTC (Sept 21 9:00 pm-midnight EDT)

Note: The originally planned second window on Sept 24 is cancelled as the upgrade was a success within the first window. Note: 2021-09-21 0225Z - Maintenance has ended. Please leave a comment if there ...
Jade Sprague's user avatar
  • 1,524
39 votes
0 answers
466 views

Show suspended users with their normal reputation in the Data Explorer

I was playing with the Data Explorer... And I was trying to write a query to show users who got the most % of their reputation from accepts. So for each user: [% from Accepts] = [Rep from Accepts] / [...
Mysticial's user avatar
  • 19.2k
38 votes
0 answers
198 views

Let moderators mark tags as deprecated

On Super User, we have quite a few tags that shouldn't exist. Unfortunately, some of those have a lot of questions, and despite our clear directives in the tag wiki excerpt, the tags continue to be ...
Ben N's user avatar
  • 7,380
36 votes
0 answers
328 views

Can't login to SEDE - "StackApps authentication failed"

When I try to login to the Stack Exchange Data Explorer using Stack Overflow, it fails with the following error message: StackApps authentication failed I've tried several browsers, and even in ...
Glorfindel's user avatar
  • 252k
32 votes
0 answers
111 views

Add Post Id to Badges table when applicable

Many badges are awarded for specific posts (Great Answer, Notable Question, Publicist, Investor, etc). In such cases, the list of badges includes the post for which it was awarded. This is public ...
user avatar
32 votes
0 answers
329 views

Show successful close/reopen votes in SEDE regardless of if they've expired or not?

Currently Data.SE only show currently active close and reopen votes. Once these votes expire, they're removed from the Votes table. This makes them rather useless when trying to query anything related ...
Rachel's user avatar
  • 19.3k
30 votes
0 answers
199 views

Please add the individual close-as-off-topic reason in the Data Explorer

A couple of previous questions (How to find the actual close reason for a question? and How to determine why a question was closed from the data dump/data explorer) document the fact that it is ...
E.P.'s user avatar
  • 19.5k
25 votes
0 answers
1k views

Planned SEDE maintenance scheduled for Oct 15, 2021 and Oct 16, 2021 15:00-17:00 UTC (11am-1pm ET)

Update 4: 2021-10-16 16:33 UTC: Today's window is done. Actual user-visible downtime was negligible. Thanks for bearing with us! This round of maintenance is done. Update 3: 2021-10-16 15:00 UTC: ...
Tom Limoncelli's user avatar
  • 7,266
22 votes
0 answers
176 views

Allow access to anonymous feedback stats without 10k rep

Right now you need the Access To Moderator Tools privilege (awarded at 10k on a regular site, 2k on public beta, 1k on private beta) to access anonymous feedback on that site. I don't see why that is, ...
Frank's user avatar
  • 2,716
20 votes
0 answers
322 views

Users who can't write good posts ≠ users who want to write good posts

I recently came across this post, which states (emphasis mine): ... The problem that became evident was that people who want to learn how to write a good question and people who can't write a good ...
dwitvliet's user avatar
  • 1,219
19 votes
0 answers
225 views

Planned Maintenance scheduled for Tuesday, September 29, 2020 for Data Explorer

Update: The maintenance went as planned. tl;dr; Planned service interruption that will impact Stack Exchange Data Explorer (SEDE). The site will be inaccessible for up to 12 hours on September 29, ...
Taryn's user avatar
  • 51.5k
18 votes
0 answers
399 views

Add tags to categorize the queries on SEDE

The ability to search SEDE queries was added recently, which is good, but this only searches on the title and description. Many of the existing queries don't really describe what the results represent ...
Jon Seigel's user avatar
  • 40.7k
17 votes
0 answers
176 views

Inclusion of the tables available in SEDE in the data dump at the Internet Archive

Table of contents Prologue The feature request TL; DR Current content of the data dump Missing tables in the data dump Motivation for doing this Epilogue Prologue First of all, I would like to ...
Rodrigo Morales's user avatar
17 votes
0 answers
190 views

Stack Exchange Data Explorer and Stack Exchange Data Dumps should include public chat room messages

All data from public chat rooms should be available in the data dumps and queryable in the Stack Exchange Data Explorer. Of course, deleted messages should not be available (since the general public ...
Thomas Owens's user avatar
  • 51.5k
16 votes
0 answers
289 views

What's going on with SEDE right now? It's being fickle

When I open a new tab, I get "we are currently offline", and then I refresh a couple of times and it's fine. Then when I try to run a query, it will give unknown job being polled! or ...
starball's user avatar
  • 26.8k
16 votes
0 answers
130 views

Some users can still create bookmarks

The unfortunate decision has been made to evolve Bookmarks into Saves. One of the key changes was: Will my saved posts and lists be public? Nope! and with that a whole bunch of Data Explorer queries ...
rene's user avatar
  • 91k
15 votes
0 answers
205 views

Can the PerSite setting be switched to true so the shown metadata is consistent?

I was looking at some of the *-Types tables in the Stack Exchange Data Explorer. specially CloseAsOffTopicReasonTypes. As I'm lazy I clicked the (i) that is found in the right hand side of the SEDE ...
rene's user avatar
  • 91k
15 votes
0 answers
143 views

Is there a way to recover how people voted to close a question post-close?

When the question has close votes (<5), and you click on "Close" link, in the dialog for closing it shows you how many people voted for each of separate options (e.g. 1 voted as Duplicate, 3 voted ...
DVK's user avatar
  • 10.6k
14 votes
0 answers
83 views

Include ViewCount in the Posts table for tag wikis (in SEDE)

Currently, the ViewCount column of the Posts table in SEDE is always null for tag wikis (posts where PostTypeId = 4). But this data is certainly tracked somewhere internally - I can look at the python ...
senshin's user avatar
  • 14k
14 votes
1 answer
554 views

What caused the drop in questions in April 2023?

Rerunning this query by starball for new questions and answers posted across the network generated the following graph: It plots posts by their creation date, and includes deleted posts. The decline ...
Adriaan's user avatar
  • 1,396
13 votes
0 answers
81 views

Can the reviewtasks table include the reviews for deleted posts as well?

The table reviewtasks is sanitized for deleted posts. This means that it is hard, if not impossible, for the users that care and for those that want to evaluate the effectiveness of a community to ...
rene's user avatar
  • 91k
13 votes
0 answers
74 views

In the SEDE the data for Meta Stack Exchange is missing

In the Data Explorer this site, Meta Stack Exchange, is missing. Can this be added to the weekly data dump, please?
rene's user avatar
  • 91k
13 votes
0 answers
143 views

SE data explorer shows Ask Ubuntu logo which has white font

In the Stack Exchange Data Explorer, the Ask Ubuntu logo is shown as: This is the image being displayed: https://cdn.sstatic.net/Sites/askubuntu/img/logo.png when indeed it should have the "...
nanofarad's user avatar
  • 3,185
12 votes
0 answers
136 views

The SE Data Explorer captcha is unnecessarily annoying

Whenever I try to run a query with the Data Explorer, my process is: Type the parameters for the query. Click "Run query". Click the "I'm not a robot" checkbox that suddenly ...
jamesdlin's user avatar
  • 726
12 votes
0 answers
112 views

How much are tag warnings used?

Although I'm reasonably experienced on Stack Exchange (8+ years of activity, 40 sites with 500+ reputation, 247k total rep) and have been a diamond moderator on one site for some 5 years, today I saw ...
gerrit's user avatar
  • 9,370
12 votes
0 answers
105 views

Enable text search on more than first 34 SEDE query results

I was recently running a SEDE query to determine which Stack Overflow users could vote for tag synonyms suggestions based on the target tag of that suggestion (in my case, as linked above, I was ...
josliber's user avatar
  • 1,441
12 votes
0 answers
278 views

Notify/contact SEDE user of fix to query

I guess I'm asking for comments, with subsequent notifications, to be added to queries in SEDE, so we can point out [fixes] 1 to flawed queries, especially when [the query] 0 has a comment in it ...
Mark Hurd's user avatar
  • 5,612
11 votes
0 answers
68 views

Query the Data Explorer without saving the query

Is there any way to run a query against the Data Explorer without having that query be saved forever? I'd really like to be able to do some experimentation without polluting everyone's searches with ...
phenry's user avatar
  • 1,319
11 votes
0 answers
193 views

Create example, reference queries on Data Explorer

Could we have some example queries, generated by the Stack Exchange team themselves, to use as a reference for the Data Explorer? Edit: Based on the comments, I need to clarify that I am suggesting ...
elixenide's user avatar
  • 3,678
11 votes
0 answers
170 views

Can you help with getting some statistics on Stack Overflow voting patterns?

About 2 weeks ago we've said good-bye to some old close reasons (minimal understanding, describe specific problem, etc). Since then, I think I might have noticed a drop in the amount of votes to close ...
user avatar
11 votes
0 answers
160 views

Please merge SEDE accounts, normal options unavailable

Original SEDE account ID: 6306 Newly added account ID: 11949 Please allow my Stack Exchange OpenID on account 6306, and discard/merge account 11949. MyOpenID is not working anymore for the Stack ...
Awesome Poodles's user avatar
10 votes
0 answers
157 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
  • 91k
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
  • 252k
10 votes
0 answers
56 views

SEDE favorite button fails silently when not logged in

I was trying to bookmark/favorite this interesting Proof of Concept on the Stack Exchange Data Explorer, but clicking the favorite button did not do anything. Of course, I should have realized SEDE ...
Glorfindel's user avatar
  • 252k
10 votes
0 answers
250 views

Have there been analyses to see if views of well-received answers are reduced by closure as duplicate which try to control for other factors?

This is a narrowly-scoped question; I'm just curious if this has been investigated quantitatively. Background only: I spent some substantial time and effort and love and coffee writing this answer to ...
uhoh's user avatar
  • 6,396
10 votes
0 answers
126 views

Can the Description for the CloseReasonTypes be added for the newer Close Reasons?

The table CloseReasonTypes in The Stack Exchange Data Explorer holds the id, name and description for the various close reasons. When the close reasons got a major overhaul the new close reasons got ...
rene's user avatar
  • 91k
10 votes
0 answers
38 views

Organize queries on Stack Exchange Data Explorer

On Data.SE, I tend to write a bunch of different queries, usually when something piques my interest and I want to look at a particular subset of the data. I currently have four pages of queries that ...
DForck42's user avatar
  • 1,660
10 votes
0 answers
111 views

Enable SEDE graph image to be saved or copied

When graphing data on SEDE, eg this example, right-clicking on the image and selecting either "Save as file" or "Copy image" both result in a totally black rectangle (albeit of the ...
Bohemian's user avatar
  • 9,658
10 votes
0 answers
55 views

I want to zoom in on SEDE graphs

I can't see many details on some SEDE graphs. So I think it would be nice to be able to zoom in, maybe like how rep graphs work. Can we get zoom for SEDE graphs?
Laurel's user avatar
  • 53.7k
10 votes
0 answers
69 views

Permalink to custom query parameter result

Currently, if you edit a query (which has parameters), and then run it, the SEDE tool allows you to click a "permalink": In the example above, the permalink is: https://data.stackexchange....
rolfl's user avatar
  • 9,398
10 votes
0 answers
105 views

Can we query SEDE for the actual number of questions per tag in the close vote queue?

I used the following query Close votes per tag in the glory days of the close vote queue. During the fuzzying I used the query to keep a sense of the actual number of questions with a close vote in ...
rene's user avatar
  • 91k
10 votes
0 answers
58 views

Collapse Data Explorer queries to only show latest revision

If you've used Data Explorer's search, you've probably been greeted with results like this: Lots and lots of the same exact query as separate results! They're actually revisions of the same query, ...
Zelda's user avatar
  • 33k
9 votes
0 answers
113 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
9 votes
0 answers
78 views

Fix http://data.stackexchange.com to https://data.stackexchange.com with Community♦ for correct session handling

If I click on an HTTPS link to https://data.stackexchange.com, I will be identified: But if I click on an HTTP link to http://data.stackexchange.com, I will not be identified: This HTTP issue ...
Cœur's user avatar
  • 2,592
9 votes
0 answers
108 views

User profile on Data Explorer

Today I logged in to Data Explorer using my OpenID account, and it didn't fill out automatically my user profile details; or, to be more exact, it filled them in wrongly: it only populated the "login" ...
Massimo's user avatar
  • 2,638
8 votes
0 answers
108 views

Drop Posts.FavoriteCount from SEDE

Related: What happened to FavoriteCount? - my educated guess is that a NULL value indicates a question has never been favorited or bookmarked, and 0 that it was. Since the values are so different from ...
Glorfindel's user avatar
  • 252k
8 votes
0 answers
126 views

SEDE refresh triggered multiple times today

As we all know, SEDE is refreshed every Sunday morning, but immediately after it finished (Stack Overflow is the last site, always somewhere before noon UTC), it seems to have triggered a new refresh ...
Glorfindel's user avatar
  • 252k
8 votes
0 answers
152 views

Is there a complete list of private guidance for network-wide closure reasons?

There is a difference between what others users see and what the post owner sees when a question is closed. For example, when a question is closed as a duplicate users see1: Some community members ...
Henry Ecker's user avatar
  • 4,682
8 votes
0 answers
66 views

The Stack Exchange Data Explorer reports an error on Line 0

In the fix I wrote for Include a line number when there's a syntax error I tried to handle both regular errors and errors that come with an Line number: if (response.line) { msg = 'Line ' + ...
rene's user avatar
  • 91k
8 votes
0 answers
257 views

It's time to remove Yahoo login from https://data.stackexchange.com/

Follow up question to: Is it possible to merge an old and new data.SE login? I was able to log in few days after asking that question. Now I am unable to log in with Yahoo which is how I log into my ...
4b0's user avatar
  • 4,590