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
114
votes
4answers
738 views

Beta sites should be in the Data Explorer

The Stack Exchange Data Explorer is a very nice and useful tool, but it has one very large drawback: Beta sites are not included at all. Excluding beta sites probably made a lot of sense when the ...
66
votes
8answers
10k views

Implement OData API for Stack Overflow

The request is simple Implement the OData API for Stack Overflow sites Benefits: It's a standard API. OData allows the Stack Overflow database to be queried and navigated for questions, users, ...
13
votes
1answer
586 views

My project requires data from Stack Overflow. What can I do?

I want to make research on Stack Overflow (or any other Stack Exchange website). How can I parse the website's data using regular expressions?
13
votes
1answer
139 views

Auto-linkification of Tags.TagName fails when the tag name contains nonstandard characters

Run the following SEDE query: http://data.stackexchange.com/japanese/query/178382. All the tags except kyūjitai-and-shinjitai, renyōkei, あれ, and たい-form get auto-linkified. These happen to also be ...
9
votes
1answer
305 views

Reputation History from Data Explorer

Is there a way to get the reputation history for a user in Data Explorer. I know you can do this through the StackExchange API through Reputation Changes. But there's a limit of 10K queries a day (at ...
28
votes
1answer
368 views

List my downvoted posts that were edited

Consider the following situation: I downvote a question / answer with a comment The answerer / asker edits the question and improves it In that case, I think the downvote should be removed. I know ...
27
votes
0answers
312 views

Can we have a feature to allow commenting on Data Explorer queries? [duplicate]

I love http://data.stackexchange.com but sometimes, I want to collaborate with the query creator - perhaps suggesting why their query isn't working as expected or asking something about the query. I ...
16
votes
1answer
669 views

Running queries to StackExchange Data Explorer from anywhere

Now that we have an awesome tool StackExchange Data Explorer, won't its usefulness be multiplied manifolds if we could have a way of embedding queries onto a site that can fetch the results without ...
16
votes
1answer
215 views

Why doesn't Data Explorer log in with Stack Overflow login? [duplicate]

https://data.stackexchange.com/users/10766/jon-doe10767 I logged in with the same Gmail account that I use to log into all my other Stack Overflow accounts and it didn't auto-populate the name. Nor ...
15
votes
1answer
608 views

Is the Data Explorer now updated weekly? [duplicate]

There was an update around the 17th or 18th. Now, I see that all of the sites have been updated as of the 25th. I know that there was a time when a weekly or every-two-week update cycle was planned, ...
12
votes
2answers
133 views

Data Explorer needs the ability to comment on queries [duplicate]

Possible Duplicate: Notify/contact SEDE user of fix to query I just tried out odata.stackexchange.com for the first time - quite impressive! However, I really missed the abilty to comment on ...
25
votes
1answer
192 views

Add UserId information for bounty starters and closers

Currently the "UserId" info is stripped from the Votes table for "BountyStart" and "BountyClose" vote types (i.e. for VoteTypeId=8 and VoteTypeId=9 respectively, check an example). Since this ...
10
votes
1answer
171 views

Missing Stack Exchange OpenID option at data.stackexchange.com

I wanted to log in to the Stack Exchange data explorer, but I found out that the login page does not list the SE's own OpenID login as option (manually entering the SE's OpenID URL worked).
53
votes
15answers
2k views

Can we become our own “Northwind” for teaching SQL / databases?

In the Microsoft ecosystem there are some standard databases like Northwind ... The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, ...
19
votes
1answer
147 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 ...
20
votes
3answers
398 views

Why prevent people from seeing upvote/downvote count if they can find out using the data explorer or the API?

There are some sites that I don't yet have 1,000 rep on (including meta), which means I cannot see the upvote/downvote breakdown. There were some posts that I was curious about, so I pieced together ...
14
votes
5answers
605 views

Strunk-and-White problem?

Thanks to the new edit system(which I really like, BTW) I recently got Strunk-and-White. Awesome! I'm a curious guy, so I had been periodically seeing how many edits I had with some data explorer ...
10
votes
2answers
428 views

How far am I from getting into the “Top 20%” for a particular tag?

I've got a couple of "Top 20%" tags on my careers page. I'd really like to know how far I am from getting the same award for the "android" tag. Is there an easy way to get that information? I don't ...
7
votes
3answers
125 views

Is it possible to see a list of all my edits using a query?

Is it possible to see a list of all my edits using a query similar to this query for getting a list of comments? Can any one give any link to the query?
7
votes
2answers
175 views

Stats about close reasons used?

Are there any stats about the percentage of close reasons used to close questions Successfully (preferably, based on the number of closed questions) Unsuccessfully (alternatively, the total ...
15
votes
1answer
302 views

Why are there so few posts with zero comments?

While researching my theory that showing comments costs votes, I noticed that there are surprisingly few posts with zero comments. Here's what the distribution looks like: That graph was generated ...
13
votes
2answers
201 views

Is there a way to auto-identify tag synonyms which differ by *only* a hyphen?

Note: There is a nice background discussion on this here: Should tags take the form foobar or foo-bar?. This discussion is not part of this question however: I'd like to go through and propose a ...
12
votes
1answer
109 views

Are user accounts on data.stackexchange.com and Stack Exchange two different entities?

I tried to search for similar questions, as I always do, but was not able to find one. I just created a new account on Data.Stack Exchange with my existing Google OpenID and it seems to be not ...
10
votes
2answers
635 views

Captcha is missing in Data Explorer when connected over HTTPS

When I tried to run How many upvotes do I have for each tag?, I got the below screen: The captcha is missing! I tried in other browsers too. Update: From @Oded's comments, I changed to HTTP and it ...
9
votes
1answer
969 views

What do these votetypeids in the votetypes table mean?

I have been using the data explorer to examine the stackoverflow data and I don't know what some of the votetypeids mean. I am specifically interested in the following Votetypeid 2: UpMod; is this ...
9
votes
2answers
246 views

What's the Codegolf_Temp database (and why does it mess up my query)?

Today, I was running some queries on SEDE and found out that this one fails to run because of the following error: Invalid object name 'StackExchange.Codegolf_Temp.dbo.badges'. Apparently, there's ...
8
votes
0answers
105 views

Age field in database off by one [duplicate]

Take this query for example. And checking the "real" user profiles, the ages are all either off by one, or nonexistent. This might make sense since the data doesn't arrive constantly, except everybody ...
-8
votes
6answers
322 views

Include user's “Interesting” and “Ignored” tags in the data dump

I added a feature-request earlier that revolves around my use of tagging to draw .NET developers to questions that are language-agnostic (as far as C# and VB.NET are concerned). The request is based ...
17
votes
1answer
249 views

How to determine why a question was closed from the data dump/data explorer

Database schema documentation for the public data dump and SEDE for PostHistory says: Comment: This field will contain the comment made by the user who edited a post. If PostHistoryTypeId = 10, ...
15
votes
1answer
275 views

SEDE appears to be partially-refreshed

I went to check some of my queries against UNIX & Linux this morning and noticed that the results all had dates older than a week. Going to rene's "did the SEDE refresh work?" query, I see that U&...
15
votes
3answers
321 views

“member for” is a negative number on Data.SE

I've recently joined Data.SE, and seen this: -55, -54, and counting… it reached 0, but then it started over from -59! It seems I'm not alone with this problem
14
votes
8answers
792 views

Is it harder to write a good question or a good answer?

I was wondering whether there's any evidence to be had as to whether it's harder to write good questions or good answers. For example, from the data available in SEDE or previous surveys. I suppose "...
11
votes
1answer
202 views

Why is the data explorer telling me there are closed questions with no close votes?

I am curious why SE Data Explorer is telling me there are closed questions with no close votes I don't think my query is wrong, but I suppose it could be: select Closevotes, count(*) from ( ...
11
votes
1answer
252 views

A couple of (popular) queries on the Data Explorer aren't working

So far, it seems to be: How long until I get the generalist badge? How many upvotes do I have for each tag? The first query gives me no results, the second gives me two rows: TagName ...
9
votes
1answer
108 views

Two SEDE accounts; please fix and how do I avoid this?

I just found a use for Stack Exchange Data Explorer, so I created an account yesterday in order to favorite a query. Then I logged in (from a different computer) today, and now I have two accounts. ...
6
votes
1answer
139 views

How do I make a bar chart in the Data Explorer?

I've been wondering if there was a way to graph something in SEDE other than a line graph, because line graphs are boring. I figured out how to do a scatter plot, but it's still not as cool as a bar ...
5
votes
2answers
300 views

Add Support for Multiple Results sets in data Explorer

If you run this query in data explorer it would appear that both queries run since the message window reads... (1 row(s) affected) (555 row(s) affected) ...but only the first result is displayed or ...
4
votes
1answer
126 views

Any plans for a Data Explorer for Area 51?

As the title says...
23
votes
1answer
292 views

What SEDE examples would be most useful to new users?

This question asks about an SEDE tutorial, which doesn't really exist. The answer there suggests that you can look at existing queries, which I think is how most SEDE users have learned, but that has ...
20
votes
1answer
410 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 ...
33
votes
2answers
308 views

Maybe it's time to update the code base of Data Explorer?

Not talking about the data, this one appears to be updating regularly which is awesome. Talking about this: There is outdated footer (e.g. "contact us" is still a mailto: link!) and more than a ...
28
votes
2answers
501 views

StackExchange Data Explorer is going open source

We are almost ready to announce on the blog that we are open sourcing SEDE. Before we do that I wanted to get a bit of feedback to make sure that what we are doing makes sense and is easy to follow. ...
14
votes
0answers
150 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 ...
11
votes
1answer
253 views

What are the indices used in SEDE?

I'm writing an application that uses the Stack Exchange Data Dump. I've imported the most recent dump into SQL Server 2014 on my local development machine. I wrote a query that runs very slowly on my ...
6
votes
3answers
661 views

How to access all of oData in stackoverflow data explorer?

I want to get all the Tags from the data explorer (http://odata.stackexchange.com/meta/query/new) but my query results get truncated to 2000 records. How can I get the whole thing? Thanks!
32
votes
1answer
515 views

SEDE is offline

Cannot access SEDE at all. Have checked with https://downforeveryoneorjustme.com/data.stackexchange.com which also says it's down.
21
votes
1answer
837 views

Data explorer merge request - Execution plans

This is a request to merge some changes I've made to the Stack Exchange Data Explorer. I've add the ability to view / download query execution plans - a tick of the "Include execution plan" check box ...
19
votes
0answers
171 views

Data Explorer execution plans are no longer available because SHOWPLAN permission is denied [closed]

I noticed after a recent maintenance downtime that now I get the following message when trying to include an execution plan with a query: SHOWPLAN permission denied in database 'StackOverflow'. ...
12
votes
3answers
254 views

Charts in the data explorer

I don't know whether the data explorer was created for SOFU, obviously if it wasn't this is impractical. Would it be possible to add an option to display the results as a chart?
0
votes
1answer
233 views

Query for top users (rep) over the past n days

Can someone more familiar with SQL construct a query that shows the top users (rep) over the past n days, similar to how this page does it.

1
2
3 4 5
10