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.
157
questions with no upvoted or accepted answers
40
votes
0answers
392 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] / [...
36
votes
0answers
183 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 ...
31
votes
0answers
102 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 ...
30
votes
0answers
206 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
...
29
votes
0answers
289 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 ...
21
votes
0answers
129 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 ...
21
votes
0answers
155 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, ...
18
votes
0answers
396 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 ...
16
votes
0answers
214 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 ...
15
votes
0answers
94 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 ...
15
votes
0answers
79 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 ...
14
votes
0answers
149 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 ...
13
votes
0answers
73 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 ...
13
votes
0answers
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?
12
votes
0answers
172 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 ...
11
votes
0answers
174 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 ...
11
votes
0answers
161 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 ...
10
votes
0answers
33 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 ...
10
votes
0answers
64 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 ...
10
votes
0answers
57 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 ...
10
votes
0answers
101 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 ...
10
votes
0answers
52 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, ...
10
votes
0answers
267 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 to flawed queries, especially when the query has a comment in it explaining ...
9
votes
0answers
97 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 ...
9
votes
0answers
62 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 "...
9
votes
0answers
50 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.com/...
9
votes
0answers
138 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 ...
9
votes
0answers
101 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" ...
8
votes
0answers
47 views
Backslash before single quote breaks syntax highlighting (the quote is not escaped, but gets highlighted as if it is) in SEDE query
I was trying to write a query to find posts with <%break%> or <%%>, and realised that % works as a glob. Someone suggested using ESCAPE '\' to search for literal %, and that worked and the ...
8
votes
0answers
78 views
Data Explorer fails to properly format lists of tags with Cyrillic characters
There is a minor issue with how Data Explorer handles tag output. Ordinarily it replaces every one of them with a decorated and clickable link.
But it seems like whenever that list includes tags with ...
8
votes
0answers
67 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 ...
8
votes
0answers
72 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 ...
8
votes
0answers
84 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 ...
8
votes
0answers
49 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?
8
votes
0answers
105 views
Can't explore Stack Exchange Data Explorer (errors trying to build new query and execute existing query)
Both of the below errors are most likely related to the internal network issues that were reported in StackStatus twitter account, but still think it's better reporting here.
When trying to write a ...
asked Feb 17 '15 at 15:55
Shadow Wizard Wearing Mask
142k25 gold badges330 silver badges685 bronze badges
8
votes
0answers
58 views
Can't fork my own query in data explorer
When you like some query and you want to make a new fork of it and modify it, it's easy when the query is not yours! You just click the "fork query" and that's it.
But if you have your own query, ...
8
votes
0answers
82 views
SE data explorer shows bad Ask Ubuntu logo
In the SE data explorer, the Ask Ubuntu logo is shown as:
when indeed it should have the "speech-bubble" portion visible. Looking at the image carefully shows that it should(if I am correct) be ...
8
votes
0answers
162 views
You mean besides ninjas? Recent insightful comments
I made you a list of recent insightful comments. I'm really enjoying reading through it and it's almost Friday anyway.
7
votes
0answers
70 views
Why is the user who ended a bounty shown in SEDE differently from the timeline and the revision history?
Recently I looked at situations where the PostNotices table shows a different OwnerUserId and DeletionUserId. This was based on Glorfindel's advice, who suggested this as a way to find bounties which ...
7
votes
0answers
43 views
Show year in SEDE timestamps from previous year
Can we adjust the display behaviour of timestamps in SEDE so that it matches the general Stack Exchange behaviour (better)? On Stack Exchange, the year is shown if an action (post creation, latest ...
7
votes
0answers
103 views
Why is BountyAmount for votetypeid = 8 empty in the votes table of MathOverflow
While helping out on a SEDE query here I was looking at the votes table in the MathOveflow database, specially the records for votetypeid = 8.
I noticed that the bountyamount isn't present in these ...
7
votes
0answers
60 views
Please merge my two data.SE accounts
I'm told that a meta post is the way to go to get SEDE accounts merged, so here we are:
Newer account
Older account
are both mine; could I have them merged into the older account?
7
votes
0answers
92 views
Data explorer site created new jon.doe account, instead of logging me to the old one
I've logged in to data explorer site, but it didn't recognise my old account and created a new one.
Is it possible to merge those accounts, as I can't logging to my old account anymore.
Related:
...
7
votes
0answers
41 views
Make PostTypeId for WikiPlaceholder posts more granular, or something
Recently, I wanted to compare the lists of off-topic things on /tour across all sites on the Stack Exchange network. My first instinct was to look to see if those lists (which are proper markdown-...
7
votes
0answers
68 views
The PostLinks table is not sanitized in the Data Explorer
In the Data Explorer, there is the table PostLinks. This table contains the inter-relationships between posts that reference each other.
In the data dumps in Stack Exchange Data explorer, the data is ...
7
votes
0answers
48 views
Can we have the new Captcha on the Data Explorer
The new Captcha is active on the sites:
But on the Data Explorer we have the old one:
Could we have the new one on this as well please? Or is there a reason (less secure, doesn't work because of ...
7
votes
0answers
161 views
There are no foreign-keys constraints in the data-explorer database
While creating the answer for Database Diagram of Stack Exchange model? I was looking for the schema information stored in the SEDE database. The sys.tables and sys.columns are populated but when I ...
7
votes
0answers
38 views
Update login icons on Data.SE
When I click login on Stack Overflow, I see this:
But when I click login on Data SE, I see this:
This is the old login UI, similar to what Stack Overflow used to have. Now, it is a collection of ...
7
votes
0answers
57 views
UsersHistory Table on SEDE
Stack Exchange Data Explorer is awesome!
It's an invaluable tool to analyze a site's activity, monitor unanswered questions and answering time, or just to fetch a dataset for further analysis of ...
7
votes
0answers
119 views
Color of site icons on Stack Exchange Data Explorer is (not technically incorrect but) confusing
In the Stack Exchange Data Explorer, the icon color for the various sites *seems** incorrect: Whenever I select a main site, the icon is greyed out, and when ever I select the corresponding meta site, ...
