Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

38
votes
0answers
367 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] / [...
35
votes
0answers
179 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 ...
29
votes
0answers
282 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 ...
28
votes
0answers
95 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 ...
20
votes
0answers
121 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 ...
20
votes
0answers
90 views

How can I remove queries from my data explorer profile?

My data explorer profile contains some throwaway or duplicate queries. They make it harder to find the queries that I want to find later. Can I remove queries from my profile? (If the answer is no, ...
19
votes
0answers
98 views

Request: Keep statistics on a question's HNQ appearance

Duplicate, maybe. (How to see if a question was a "hot network question"?) While the HNQ list creates a lot of cross-site traffic (which is wanted), it also causes issues on those sites ...
19
votes
0answers
143 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, ...
19
votes
0answers
104 views

Long sites break the layout on the front page

The long name pushes the stats to a weird place. And what's with the "Stack Exchange" at the end anyway?
18
votes
0answers
391 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
206 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
125 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 ...
15
votes
0answers
126 views

Add Full-Text Search and Semantic Search to Data Explorer

Can SQL Server Full-Text Search and Semantic Search be added to Stack Exchange Data Explorer? Much of the textual data is difficult to query using T-SQL alone (impossible, if one hits a time out). ...
15
votes
0answers
297 views

Please provide a way to download SEDE data via an API

I recently suggested on the Stack Apps site that a formal API be added to SEDE, and it was suggested I reference the feature request here, for visibility. My use case is a query that the API does not ...
15
votes
0answers
116 views

SEDE login redirects to front page rather than returning

Recently, the redirect behaviour of login on SEDE has changed (for the worse). Steps to reproduce: When logged off, go to a query page Click the "login" link Login Previously, you would be returned ...
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
86 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 ...
14
votes
0answers
145 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
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
164 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
154 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
106 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 ...
10
votes
0answers
32 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
30 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 ...
10
votes
0answers
63 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
56 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
99 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
61 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
48 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
128 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
48 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
103 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 ...
8
votes
0answers
57 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
78 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
160 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
40 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
97 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
62 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 ...
7
votes
0answers
68 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 ...
7
votes
0answers
38 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
66 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
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
118 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, ...
7
votes
0answers
102 views

Viewing total re-open votes in SE Data Explorer?

Can you allow us to view total re-open vote count in data explorer? I am asking because I find it extremely hard to get questions re-opened by the community on lower traffic SE sites. Closed ...
7
votes
0answers
61 views

Add reputation at post time to PostHistory records in the data dump

One of the weaknesses of the data dump is that it is not possible to determine a user's reputation at a particular point in time. This is "by-design" and perfectly okay. However, there are a number ...