Meta Stack Exchange

Questions tagged [data-explorer]

Ask Question

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.

151 questions with no upvoted or accepted answers
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
40
votes
0answers
385 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
181 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 ...
30
votes
0answers
191 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
98 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 ...
29
votes
0answers
284 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
153 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, ...
20
votes
0answers
124 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 ...
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
208 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
91 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
323 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
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
146 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
72 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
167 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
159 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
145 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
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
100 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
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
135 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
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
81 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
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
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
81 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
42 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
101 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
64 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
59 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
90 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
40 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
67 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
151 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, ...
7
votes
0answers
104 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
62 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 ...
6
votes
0answers
75 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 ...

1 2 3 4