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.

Filter by
Sorted by
Tagged with
18
votes
1answer
256 views

What are these mysterious values for PostHistoryType?

While trying to get a handle on PendingEditRepBonus in the Data Explorer, I stumbled across an undocumented mystery in the DB. For example, thousands of posts with no "valid" PostHistoryType. ...
17
votes
1answer
164 views

What are these mysterious gaps in the progression of post id?

Initially, I assume that PostId is auto-incremented. Except for very rare cases, where the data is completely wiped from the database, leaving some holes in the PostId progression, I expect that the ...
16
votes
0answers
215 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 ...
12
votes
1answer
485 views

A site URL changed and now its icon in SEDE is broken

This has happened before, and it's happened again, all because Cognitive Sciences recently was renamed Psychology & Neuroscience, with a change to the URL. The first thing that needs to be fixed ...
12
votes
1answer
208 views

Alias “Post Link” in data.stackexchange.com generate invalid links for “Meta sites” of pt.stackoverflow and es.stackoverflow

I create a query using [Post Link] and [Comment Link] and I noticed that the generated links are inverted for some sites, for example: This http://data.stackexchange.com/ptme/query/775699/bug-in-...
6
votes
2answers
224 views

Downloading all my questions with the answerer names

I am writing several papers in which I use answers which I received in various StackExchange websites. Naturally I would like to acknowlege and thank the SE members that gave the useful answers. But ...
5
votes
2answers
131 views

What should happen to questions asked by non-existent users with answers that score higher than the accepted answer?

Here's the scenario: Bob asks a question on Stack Overflow. Bob gets a few answers and selects the one that helps him the most. Bob's account gets deleted. Another (considerably better) answer is ...
16
votes
0answers
121 views

Data Explorer forgotten me - new account? [closed]

NOTE: My account seems to be linking back to the original. I guess that makes this issue closed? I had many (hundreds?) of queries in Data Explorer, and with the new google log in, they are all gone? ...
15
votes
1answer
259 views

Provide more frequent data dumps to Data Explorer

In the SO blog post "Introducing Stack Exchange Data Explorer" (2010-06-13), Jeff states in a footnote: we are looking at eventually making special weekly or biweekly dumps for SEDE Is this still ...
13
votes
1answer
132 views

When will StackExchange sites be available in Data-explorer

When will StackExchange 2.0 beta sites be available to query to Data Explorer? It would be helpful to building the site to be able to query them. If they are available now, how can I access them? ...
13
votes
1answer
536 views

SHOWPLAN permission denied when including execution plan in Data Explorer

If I select the "Include execution plan" checkbox in the Data Explorer, the query fails: SHOWPLAN permission denied in database 'StackOverflow'. I see that this has happened before following ...
11
votes
1answer
553 views

Add better descriptions and E/R diagram to Data Explorer's schema

Schema should show descriptions and possible values for fields. Maybe it should even have some kind of entity-relationship diagram for the tables.
10
votes
1answer
132 views

Data Explorer created a new account; issuing an account merge request resulted in a server error

I tried to log onto the Data Explorer through my normal OpenID (Google), but I got a brand new account instead. My real account is 4216. Is there some way to ensure that my OpenID goes to that one, ...
9
votes
1answer
81 views

When switching sites after executing a query that uses a user ID, it should not be carried over

When you execute a query that uses your user ID, it is prefilled automatically if you are logged into the Data Explorer. If, after executing (because before that it isn't really possible for some ...
9
votes
0answers
97 views

##UserId## parameter is no longer automatically filled on Data Explorer [duplicate]

If I go to e.g. How many upvotes do I have for each tag? while logged in at Data.SE, the ##UserId## parameter isn't populated like it usually is. This was originally only happening for some sites, but ...
8
votes
1answer
261 views

odata access from data.stackexchange.com down

The OData endpoint provided at data.stackexchange.com has been down for the last few days. I have searched for information about the outage, but I can't find any reason or explanation. Can someone ...
7
votes
1answer
103 views

Site Logos Not Readable on OData

If you look at some of the logos on http://odata.stackexchange.com/, specifically Photography and AskUbuntu, you'll see the problem. These logos were meant for dark backgrounds (the site name is ...
7
votes
3answers
269 views

Data Explorer bombs if you use the GO keyword

Running: -- [Enter Query Title] SELECT 'gn' GO Results in: Error: System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized at System.Data.SqlClient....
5
votes
1answer
95 views

Post Link for Tag Info Wiki's display text should be better than “unknown”

The displayed text for a [Post Link] where the underlying Id corresponds to a Tag/Info Wiki (where the link redirects successfully) is just "unknown". For example, if you've ever edited a tag wiki: ...
5
votes
1answer
96 views

Missing ProfileImageUrl for many profiles in StackOverflow data dump

I noticed that in the StackOverflow data dump many profiles miss the ProfileImageUrl column. What is the reason for this, because I could still get this data by scraping all profiles that I am ...
4
votes
0answers
529 views

Search over queries needed

We've got enough in "everything", at least, to want to search for specific queries. E.g. I know I had some 'queries' that just PRINTed stuff, with no result sets, that would have been useful to test ...
4
votes
1answer
71 views

SE Data: rand() fixed?

When answering this question, I wrote up this SQL answer, which works fine from my machine. However, on SE data, it always picks the same winner. Is it possible that SE Data fixes rand() to a ...
4
votes
1answer
106 views

Error when trying to log into StackExchange Data Explorer

Yesterday and today I tried to log in to Data Explorer using OpenID. But every time I see this error: Am I missing something? Or isn't it my fault?
2
votes
1answer
136 views

Please use a more obviously synthesized username for new accounts on http://data.stackexchange.com/

Original problem I' ve opened http://data.stackexchange.com first time (from iPad 2 safary ), then clicked "log in", then clicked "log in with google" icon, Then I've confirmed that I am allow ...
1
vote
2answers
77 views

Is there a way to know which data set is available in the Data Explorer?

Is there a metadata table or something which would indicate the effective date of the set and perhaps the date and time it was refreshed? (Typically, we have this kind of thing in our ETL for data ...
-2
votes
1answer
183 views

Can we add vote history to the data.se dumps?

EDIT AGAIN For everyone downvoting this request - how is this different from the data already publicly available from the new /users/<id>/<name>?tab=reputation page? At least leave an ...
50
votes
5answers
1k views

When am I going to get the generalist badge?

Can anybody muster up a query on Data Explorer that will show me my progress towards the Generalist badge?
32
votes
1answer
11k views

Change “Login” to “Log in” and “Logout” to “Log out”

OK, so not a bug per se, but it does 'bug' me... On the Data Explorer page, the link to log in is labelled login rather than log in. The latter is on all the other SE sites I clicked through to, so ...
32
votes
18answers
958 views

Don't forget to mention… SQL injection!

I've thought for a long time that answers that mention SQL injection get upvoted a lot, even if SQL injection is entirely unrelated to the question. It looks like the new data browser supports that ...
18
votes
2answers
241 views

Can we have functions in SEDE?

I want to define a function for use in an SQL query. But: CREATE FUNCTION permission denied in database 'StackExchange.French'. Is there a workaround that would allow me to do what I'm trying to do, ...
12
votes
1answer
204 views

On which Stack Exchange do you get the quickest answers?

I was writing an answer on this now-deleted question which basically asked 'Why do I get an answer quicker when I post on Stack Overflow than on Server Fault?'. This triggered me; was this just an N=1 ...
2
votes
3answers
169 views

Actual badge queries used by StackExchange for use on SEDE

SEDE has been a great tool to poke into SE data. I have seen some saved queries on it. Is there a definitive [official] list of queries used for badges on there? [apparently not] Is there a way to ...
17
votes
3answers
337 views

Magic number in Data Explorer should be documented

There are several columns such as Posts.PostTypeId where the content are encoded as an integer. Although not hard to find out playing with a few queries, what these integers represent should be ...
16
votes
1answer
2k views

Is there a beginner's tutorial for using the Stack Exchange API v2.0?

Is there a "Stack Exchange API 2.0 for Dummies" page out there somewhere? Almost all of the support questions on Stack Apps are for 1.0. Everything explaining how to use javascript to parse through ...
13
votes
2answers
229 views

Please add a tutorial for SEDE

I recently discovered the Stack Exchange Data Explorer, and it seems pretty interesting... except... I have absolutely no clue how to use it. It would be nice to have a "beginner's tutorial" of sorts ...
11
votes
1answer
108 views

Ability to disable SEDE plot for a query link, before the query is run

The Problem This request is to address Data Explorer page keeps freezing Chrome and Firefox. There is an issue now where large queries that result in complex plots can bring the browser to a grinding ...
7
votes
1answer
71 views

Per-site metas are not linked properly from the Data Explorer

I was looking through my results from this cross-site query when I noticed that the results for the questions I asked on the Arqade meta pointed to http://meta.gaming.stackexchange.com/q/<####> ...
3
votes
1answer
92 views

How can I query SEDE for Favorites tagged with <foo>

Since we currently don't have a way to search our favorites, I built a SEDE Query to List of Favorites for a UserId that are Tagged with TagName. The query takes two inputs: UserId (int) TagName (...
30
votes
0answers
207 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
1answer
297 views

How is the data explorer secured?

I understand that the SQL user probably doesn't have any sort of permission to modify the database, and that very heavy caching is probably used in addition to the fact that this is on a data dump ...
29
votes
3answers
833 views

The true unsung heros

The unsung hero badge has gained a ton of popularity. So I decided to run some stats and try to find the real unsung heros on Stack Overflow. I basically created a query that counts how many zero ...
28
votes
1answer
396 views

Why do some comments on Russian-language sites have negative scores?

At least on two sites: SO on Russian and Русский язык SE Data Explorer returns a lot of comments with negative score [-6...-1]: Actual comments look like normal comment without upvotes. What is ...
21
votes
0answers
130 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
95 views

How can I remove queries from my data explorer profile? [duplicate]

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, ...
18
votes
1answer
478 views

Data Explorer syntax or language reference?

Where can I find a syntax or language reference for the query language used on http://data.stackexchange.com/?
17
votes
2answers
141 views

Should we include information on whether post activity was from one of the mobile apps in the public data?

Internally, we are discussing making it easier for us to tell if post activities came via the mobile version of the site. We already have a column in the PostHistory table called ApplicationId that ...
16
votes
1answer
122 views

Migration PostHistory records are omitted from Data Explorer DB Exports, Why?

Seems from a few posts as recent as August 2011 that Migration records used to be included in the DE DB's PostHistory table. They are currently (Nov 2011) omitted and I was just wondering why. The ...
13
votes
1answer
121 views

SEDE not fully-up-to-date after last “update”

According to this previous bug report, SEDE had error so it did not update at usual time. The bug report was marked status-completed. Even though SEDE says it "updated 14 hours ago", it isn'...
12
votes
0answers
173 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 ...
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 ...

1 2
3
4 5
10