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
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 ...
- 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
...
- 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] / [...
- 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 ...
- 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 ...
GlorfindelMod
- 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 ...
- 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 ...
user259867
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 ...
- 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: ...
- 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, ...
- 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, ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 10.1k
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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?
- 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 "...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
user221081
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 ...
- 20.6k
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. ...
GlorfindelMod
- 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 ...
GlorfindelMod
- 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 ...
- 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 ...
- 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 ...
- 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?
- 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 "...
- 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....
- 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 ...
- 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, ...
- 33k
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 ...
- 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" ...
- 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 ...
GlorfindelMod
- 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 ...
GlorfindelMod
- 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 ...
- 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 ' + ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 25.9k