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.

185 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,514
39 votes
0 answers
304 views

Why does the SEDE ReviewTaskResults table not include user data, which is all public anyway?

I wanted to do some data mining on the SEDE, and I ran across a limitation which I cannot understand. The Data Explorer table ReviewTaskResults currently contains the following information: Id ...
E.P.'s user avatar
  • 19.4k
39 votes
0 answers
461 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
197 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,370
36 votes
0 answers
322 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
  • 247k
32 votes
0 answers
326 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
31 votes
0 answers
110 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
29 votes
0 answers
193 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.4k
24 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,216
22 votes
0 answers
175 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
19 votes
0 answers
223 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.4k
18 votes
0 answers
186 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
  • 41.4k
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.6k
17 votes
0 answers
169 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 ...
rdrg109's user avatar
  • 531
16 votes
0 answers
111 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
  • 85.7k
16 votes
0 answers
253 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,169
16 votes
0 answers
187 views

Directly support cross-site queries in the Data Explorer

Often you want to query some statistic for a user across all sites. For example, you might write a query to find your rejected suggested edits across all Stack Exchange sites. To implement this, you ...
Mechanical snail's user avatar
15 votes
0 answers
201 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
  • 85.7k
15 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
15 votes
0 answers
142 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
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
  • 85.7k
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
  • 85.7k
13 votes
0 answers
142 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,149
12 votes
0 answers
111 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,240
12 votes
0 answers
97 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
189 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,698
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,656
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
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
159 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
97 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
  • 247k
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
  • 247k
10 votes
0 answers
136 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,354
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
  • 85.7k
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,680
10 votes
0 answers
54 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
  • 48k
10 votes
0 answers
76 views

Let the default collation of the SEDE databases match the dominant collation used for the nvarchar columns

Today I was working on a SEDE query when I was met with a somewhat unexpected error message: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "...
rene's user avatar
  • 85.7k
10 votes
0 answers
65 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,416
10 votes
0 answers
104 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
  • 85.7k
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, ...
Ben Brocka's user avatar
9 votes
0 answers
107 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
9 votes
0 answers
107 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,654
8 votes
0 answers
102 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
  • 247k
8 votes
0 answers
122 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
  • 247k
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,422
8 votes
0 answers
62 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
  • 85.7k
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
8 votes
0 answers
73 views

Better handling of large legends in Stack Exchange Data Explorer?

The problem The legend on Stack Exchange Data Explorer (SEDE), keeps going on, below the bottom of the page, on a white background, breaking the page (I've cropped this out to keep the page from ...
jrtapsell's user avatar
  • 345
8 votes
0 answers
74 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,572
8 votes
0 answers
99 views

Site meta info in SEDE

This is a feature request for an additional table in SEDE consisting of at least the following site meta data: The site's primary URL. The site's SEDE URL (or its TinyName). The date of the last SEDE ...
Jason C's user avatar
  • 25.9k