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
Filter by
Sorted by
Tagged with
3
votes
0answers
40 views

How to query the Data Explorer for reviewer stats

I've been trying to figure out if it's possible to query the Data Explorer to give me data similar to what you get when you hover over people's names: I thought it may be similar to the ...
3
votes
0answers
37 views

Can there be a margin added to the data explorer?

I've done a few queries on SEDE, and I've noticed that it really needs left and right margins. The lack thereof makes it look rather ugly. Can these be added to the SEDE stylesheet?
3
votes
0answers
24 views

Data Explorer revert my edit on someone elses query

I have edited / forked a few queries from other users. For example top 100 questions for a given tag without accepted answer number of questions per week given a tag I changed them quite a bit and ...
3
votes
0answers
30 views

Change OpenID on data.SE

I'm trying to change the OpenID of my data.SE account, but when I click the "Log in using Stack Exchange" button I get redirected to a page saying "Server Error in '/' Application. Runtime Error". I'...
3
votes
0answers
76 views

Is SODDI still working with Data Dump?

I'm following this guide: How to Query the StackExchange Databases, but when trying to connect with SQL Server 2014 it doesn't let me connect to the db. Does SODDI work for the data of January 2015? ...
3
votes
0answers
45 views

What is the point of TargetRepChange when it's all zero?

All values of the field TargetRepChange in the table SuggestedEditVotes are zero (0). See the SEDE query Select Sum(TargetRepChange) As [Total TargetRepChange] From SuggestedEditVotes; (or even ...
3
votes
0answers
82 views

Count users who down-voted questions but not answers, despite anonymisation of Votes table in SEDE?

To gather some evidence prior to posting a feature request, I wanted to count the number of users who have down-voted at least one question but have never down-voted an answer. The intention is to ...
3
votes
0answers
70 views

Are SO total Post ViewCounts really declining?

I'm querying the SO posting data to see popularity of different words in post titles over time. As part of this I'm trying to take account of overall traffic rather than looking at raw view/comment/...
3
votes
0answers
34 views

Duplicate popups in Data Explorer

Every time you click the "n sql" links in the data explorer, it pops up a new dialog, even if one is already showing. This isn't immediately obvious, but you can see it by looking at the backdrop ...
3
votes
0answers
52 views

Add post quality to data dump & SEDE

I think it would be quite interesting to add post quality to the data dump, to check for correlations with other things (like tag, for example). However, I'm not sure where it should go (in Post, or ...
2
votes
0answers
59 views

Top voted questions not voted by me

How can I get top voted questions by tag, that are not voted by me (down/up). Can you help me with a SEDE query, or easier solution? Edit If above query is not possible, Can it be possible To ...
2
votes
0answers
150 views

Is Stack Exchange working on providing a GraphQL based API endpoint?

GitHub currently offers both REST API and a GraphQL endpoint to query its entire database. I was wondering if Stack Exchange (SE) is working on offering a GraphQL endpoint sometime soon. As a ...
2
votes
0answers
66 views

Magic Column [User Link] produces “Out of Resources” error on simple SEDE queries

Question shrunk since the issue is known and will be addressed in due time. (View complete question.) Error in SEDE when using magic column: Example #1: Control query (no magic column). ...
2
votes
0answers
62 views

Please make the “favorites” tab sortable in the SEDE

Ext: of course the best would be if it would be so nicely sortable/searchable like the questions on the ordinary sites. Currently the only way to remark "my" queries is to favorize them. However, as ...
2
votes
0answers
40 views

Cannot get parameterized permalinks to SEDE queries I own

When I create an SEDE query while logged in, and that query has parameters, there is no direct permalink to that query with certain parameter values, because the "permalink" button is "edit" in that ...
2
votes
0answers
24 views

Treat NULL the same as T-SQL in SEDE interactive sort on numeric columns

In SEDE, SQL Server always places null values first in ascending order, and last in descending order. However, the interactive column sort in SEDE (click column headers) always treats null values as ...
2
votes
0answers
71 views

SEDE seems overloaded, is it true?

Most of my queries I've developed worked pretty well while I've developed them, now most of them time out. Has something uncommon happened, or are we simply overloaded? Can I get information about ...
2
votes
0answers
21 views

Column name overlaps with type column in Data Explorer in PendingFlags table

In the SE Data Explorer, if you attempt to compose a query and scroll to the PendingFlags table, two columns (CloseAsOffTopicReasonTypeId and BelongsOnBaseHostAddress) overlap into the column type ...
2
votes
0answers
32 views

Few site and meta site names are ending with Stack Exchange and not all the sites in the data explorer main page

In the Stack Exchange Data Explorer main page the Stack Exchange site and it's meta site names are displaying. For the following site and it's meta site's names are ending with Stack Exchange but not ...
2
votes
0answers
45 views

Data Explorer: How to query for “Reviewer Stats” data?

Along any suggested edit, there’s “Reviewer Stats” on all involved reviewers, like this one: Community has approved 297542 edit suggestions and rejected 155813 edit suggestions and improved 1209 ...
2
votes
0answers
27 views

Anchor link to execution plan in SEDE queries does not work

When you include the execution plan in a query, then click the Execution Plan tab, the URL is updated to include an anchor to #executionPlan. However, when you follow this link, the query does not ...
2
votes
0answers
34 views

Add a ReviewTaskResultTypeId column to the SuggestedEditVotes table in SEDE

The Data Explorer's SuggestedEditVotes table has a VoteTypeId column that can be either 2 or 3 to indicate Approve or Reject, respectively. "Improve Edit" and "Reject and Edit" votes, though, don't ...
2
votes
0answers
48 views

How to retrieve “badge type” in Data Explorer?

I'm trying to write a query (Badge Order Received) on the Stack Exchange Data Explorer, within whose results I want to link to a user's awards of a given badge. On Stack Overflow, such a link may be ...
2
votes
0answers
27 views

When not logged in, clicking Run Query navigates to the raw text result rather than showing the result on the same page

Lately, clicking Run Query on any Data Explorer query (where the result wasn't generated beforehand) navigates to URLs like data.stackexchange.com/query/run/1/*/*, usually with the JSON query result, ...
2
votes
0answers
61 views

What happened to the Data Explorer Input Fields?

I just tried one of my queries in Data Explorer, and noticed the input fields were missing. Here's a screencap: The following error message was returned in the JSON response: {"error":"Missing value ...
2
votes
0answers
288 views

“Operation cancelled by user” (but I didn't!)

I was playing around with the Data Explorer, and formulated the following query (this is not an SQL question; it is about the Data Explorer): SELECT TOP 2000 P.Id as [Post Link], P.Score as [Post ...
2
votes
0answers
124 views

Classifying and evaluating Stack Overflow posts

I was trying to evaluate and classify Stack Overflow posts using some objective metrics extracted from a Stack Overflow data dump as a research project. I need some expert advice about the ...
2
votes
0answers
75 views

URL table in the SEDE dump

I have noticed a few SEDE queries that attempt to extract the referenced URLs from post bodies. Is there any chance we can get a table to list the URLs referenced by posts? This should simplify ...
2
votes
0answers
95 views

Add sub-metas to the data explorer

Now the sub-metas are included in the data dumps and the data explorer has been updated, shouldn't they be listed on the data explorer as well?
2
votes
0answers
63 views

Page Titles on Data Explorer

The login page doesn't have the "Stack Exchange Data Explorer" suffix. The page titles in the Browse section don't change when you change the selected tab(featured, recent, favorite and popular) Some ...
1
vote
0answers
44 views

Logging in to Data Explorer (SEDE) in another window changes name in the first

When writing a question a few minutes ago, I logged into Data Explorer in a private window. When I logged back into it in a normal window, my username had changed to "Stormblessed31729" due to not ...
1
vote
0answers
51 views

Link registered account in Data Explorer to user profile page

Lately, I have been consulting and pulling data from Data Explorer Stack Exchange for performing review activities, adding data to meta posts, learn more about some pattern, etc.. I'd like being ...
1
vote
0answers
29 views

Data Explorer: Shrink query window a little more

The "Query Window" textbox on data.stackexchange.com is already stretchable, but it would be helpful if the minimum height were set "even smaller". When testing quick edits to a query, it would be ...
1
vote
0answers
47 views

SEDE Query to find posts I have cast delete vote on but aren't yet deleted?

Related to 10k "Most Delete Votes" List - Don't Show Questions I Can't Vote For, I'd like to be able to identify posts I've cast delete votes on, but which aren't yet deleted. My ...
1
vote
0answers
27 views

SEDE does not draw lines on execution plan when plan is very complex

In the execution plan for this query, the lines between the boxes are not drawn: I am not sure if it is related to the number of boxes, or if it is because of the dimensions of the plan. Chrome 58, ...
1
vote
0answers
66 views

SEDE Extend graph support

I created this query which counts the number of post in a certain timeperiod for given tags. The result is pivoted. I would like the graphing support to be extended to support pivoted-results of the ...
1
vote
0answers
31 views

How to remotely query for my questions, answers, upvotes and stars?

I keep searching for my upvotes and questions across several SE sites and was wondering if there is a way to remotely query for these actions to build an offline repository (a single web page, ...
1
vote
0answers
29 views

In data explorer why the first character of the month name is in lowercase for created and edited fields

Why the month name's first character is showing as lower case for the created, edited in the Stack Exchange Data Explorer site. In other SE sites the first character for the month name is in Caps, is ...
1
vote
0answers
16 views

The graph label goes off the page

I was experimenting with some complex queries, and I'm having an issue with the graph. Not only is the label falling off the page (it continues for several page lengths past the graph), I cannot see ...
1
vote
0answers
29 views

SEDE signup should be clearer

The FAQ says the SEDE login isn't like other SE sites. When you try to signup/login, you will see you have a different profile. Many users are jon.doe####, but my account was Laurel.Last.Name, where "...
1
vote
0answers
53 views

Strange behavior in unsung hero query

I recently notice that I'm close to get the Unsung Hero Badge so I run this query How Close Am I to Unsung Hero Badge (Including 10 days requirement)? with my userId 4848308 and I get as result | ...
1
vote
0answers
42 views

Query inboxes with Data.SE

I'm researching a notification proposition and would like to learn current notification rates for users to see exactly how much burden it is going to be. But, I don't see anything like "Inbox" in the ...
1
vote
0answers
33 views

Prevent profiler pane from obstructing the view

As the profiler pane grows, it starts obstructing the edit area: There doesn't seem to be any way to prevent this save for deleting it from DOM by hand. The ideas are: make it collapsible, cleanable ...
1
vote
0answers
225 views

Data Explorer OpenID issues

When you login to data.stackexchange.com through something like Google, you get a nice jon.doe account. However, I have changed my username to UniKitty. (Here's the account). However, I logout and ...
1
vote
0answers
83 views

Is a smart query service for stackexchange sites welcome here?

StackExchange sites has been a great source for me to find answers to many technical questions, but sometimes I needs a little more than what a generic search engine can provided. Having the ...
1
vote
0answers
40 views

upvotes I have for each tag is not consistent with what my page says

I came across several queries that calculate the upvotes I have for each tag, and found the statistics are not the same as what my own page displays. For some tags, the calculation is less, while some ...
1
vote
0answers
77 views

How can we identify the creator of Data Explorer query?

So far we do not have a possibility to comment on a SEDE queries. (Although there exists a feature request for this.) Another related post is this one. Until there is such a possibility, the only ...
1
vote
0answers
137 views

Encouragement to write more answers

I wrote this Data Explorer query to show the average answer-accept rate vs the number of answers a user has written, minus the top power-users (who don't accurately represent the average user). ...
1
vote
0answers
84 views

SE Data Explorer Copy/Paste keyboard shortcuts missing

Windows has 2 sets of Copy/Cut/Paste shortcuts by default. The most common of course are Ctrl-C/X/V but Ctrl-Insert, Shift-Insert and Shift-Delete are also Copy/Paste/Cut respectively. I've been ...
1
vote
0answers
34 views

The users page on Data.SE isn't reporting the correct number of saved queries

According to this page on the Data.SE I've got more than a 1200 saved queries on Data.SE. I'm pretty sure this is counting the revisions.