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
4
votes
2answers
90 views

Data Explorer displays incorrect hour for PM timestamps

While fact-checking this timestamp-related feature-request, I noticed that timestamps in the Data Explorer are displayed with hours in 12-hour format, even though no AM/PM is displayed. So 2009-01-01 ...
-3
votes
4answers
153 views

www.odata.stackexchange.com does not exist?

I've recently found out that www.odata.stackexchange.com does not work while odata.stackexchange.com does. Now I know the www prefix isn't liked, but it should exist, and simply redirect to odata....
4
votes
1answer
74 views

Some site logos and favicons aren't displayed in Data Explorer

Some site logos and favicons aren't displayed in StackExchange Data Explorer (see screenshots below). The URLs of missing images, e.g. http://sstatic.net/so/img/logo.png, give server errors "404 - ...
3
votes
1answer
105 views

Dead images in SEDE homepage

http://odata.stackexchange.com/ contains dead images pointing to http://sstatic.net/so/img/logo.png
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!
6
votes
1answer
428 views

Unsung Hero badge: how does it work exactly?

I was just checking How Unsung am I? and I discovered that I currently have 6 unscored answers and 22.2% percent unscored. How does the unscored answers count work? It counts all accepted answers I ...
3
votes
1answer
105 views

Can Data Explorer quantify over my votes?

Can it be done in Data Explorer, or would I need the API for that? I was thinking about how to write a query for the Sportsmanship badge, and I stumble on this. I can see that there might be privacy ...
2
votes
1answer
73 views

Data Explorer Paging Bug - Changing Per-Page

I need to qualify this as not being a dupe of this question, well actually it is...but for Data Explorer not SO like the original. When you change Questions per page, say 100 you land at a URL like ...
3
votes
1answer
92 views

Let me change my OpenID in the data explorer

Please allow me to change my OpenId and/or have a secondary OpenID in the Stack Exchange Data Explorer.
7
votes
1answer
101 views

Data Explorer Feature Request: Allow Results Pane to Grow

Apologies if this is a duplicate, I couldn't find it at all. I agree with the SO/SE layouts being fixed width, the code formatting, predictability, etc. make perfect sense. However, I'm not sure ...
1
vote
1answer
102 views

SEDE update is missing data from the past few months

I noticed a problem running queries on odata.stackexchange.com/stackoverflow/queries. The info in the right rail looks correct for the recent update. Date and number of questions is right. But the ...
4
votes
1answer
75 views

Spelling Error in Data Explorer FAQ

Data Explorer FAQ Why are my queries not showing up int the recent query list? Surely "int" should be "in"?
16
votes
1answer
667 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 ...
2
votes
3answers
160 views
0
votes
1answer
69 views

List of Queries for each Badge

For people "in the know", do we have queries on the Data Explorer which exactly match the criteria for specific badges? For example, we have an Unsung Hero tracker. But, like all similar queries, I ...
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 ...
11
votes
2answers
126 views

Add a link to the data explorer from the SOFU/StackExchange sites

Please add a link to the data explorer from the main sites. It should be somewhere that will show up consistently on every site, like the footer where all the sites are listed. Preferably the link ...
7
votes
1answer
324 views

OData is broken on odata.stackexchange.com

All the odata urls eg: http://odata.stackexchange.com/stackoverflow/atom are returning errors. When will this be fixed?
4
votes
1answer
128 views

non transparent favicon for Stack Exchange Data Explorer

I just noticed that the favicon for Stack Exchange Data Explorer is not transparent. I don't think it was intentional as all other favicons on the SO sister sites are actually transparent. Shot of ...
4
votes
2answers
616 views

Inflector.NET not correctly attributed to Andrew Peters in Stack Exchange Data Explorer

Inflector is not correctly attributed in Stack Exchange Data Explorer code base. The source inaccurately lists Subsonic as the source and include the BSD license. This license may or may not be ...
3
votes
1answer
121 views

Can't run certain queries against SO on OData

I can't run f.e. this query against SO. SU, SF and Meta are working fine, but SO just tells me to hold tight while my results are fetched...but no matter how tight I hold my PC and Modem, it doesn't ...
3
votes
1answer
125 views

A more interesting user specific unanswered feed

The unanswered question feed is kind of cool but it feels a tad general to me. Can anybody think of a different query on data explorer that takes into account the tags I am good at answering and ...
15
votes
1answer
258 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 ...
1
vote
2answers
65 views

DataExplorer Feature request: Associate OpenID with other accounts in the trilogy, then allow push-button insertion of the user's own UserID

With the new site, there is (understandably, since it's barely even been announced) no tie-in with accounts on the other sites. If/when account association gets added, it would be nice to add the ...
4
votes
1answer
228 views

Stack Exchange Data Explorer offline?

I attempted to visit the Data Explorer today and received this message: ERROR The requested URL could not be retrieved While trying to retrieve the URL: http://odata.stackexchange.com/...
0
votes
1answer
80 views

Is ControlsOverload site a sister site of SO/SU/Meta etc?

Is the site Controlsoverload part of the StackOverflow / SuperUser / Meta / etc group? It looks the same, and has a link to stackexchange at the bottom. It also says it is in Beta, but I don't see it ...
2
votes
2answers
115 views

timed_penalty_date on Stack Exchange Data Explorer

I just did a query to list user with higest downvote ratio. Then I noticed that there is banned user like "Geoffrey Chetwood". Would it be possible to include this information on Stack Exchange Data ...
4
votes
2answers
121 views

How to get real objects in the Data Explorer, not just table variables - for average joes?

The benefits of this would be being able to demonstrate differences in indexing strategies and constraints. Also, creating views, stored procedures and UDFs for architectural questions. This would ...
4
votes
2answers
169 views

SQL Injection VS Stack Exchange Data Explorer

One topic that seems to pop up quite frequently is that the parameter implementation in SEDE allows for SQL injection. To address this I added typed parameters yesterday, which means you can let us ...
6
votes
0answers
94 views

How can I search StackExchange Data Explorer? [duplicate]

Possible Duplicate: Search on Stack Exchange Data Explorer I just noticed that there is no search box on Data Explorer. I guess there should be one in the pipeline. Am I correct? Also surprising ...
2
votes
1answer
88 views

Bad URLs on Stack Exchange Data Explorer cause yellow screen of death (YSOD)

Trying to access a nonexistent URL on Stack Exchange Data Explorer causes a yellow screen of death. Example: http://odata.stackexchange.com/users/d
9
votes
1answer
167 views

I'm being logged into Data Explorer as “jon.doe18”, why?

Forgive me if I'm just ignorant of some well-known fact that explains this behavior: When I log into Data Explorer with my usual OpenID provider (myOpenID), then I'm logged into the system as http://...
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
74 views

Link function in data explorer for posts

Wouldn't be nice if results in Data Explorer could link to the post they result in? Please provide a link function that takes a PostId and returns a link to that post. For example -- Great Answers -...
5
votes
1answer
81 views

Removal of duplicate users on data-explorer

(I hope this is the correct place to post this - I'm not sure who "owns" the data explorer) I originally registered on data explorer with my main open id provider and got an account (user 15). Since ...
3
votes
1answer
68 views

Data explorer doesn't highlight “TOP” as query keyword

The Data Explorer doesn't highlight "TOP" as a query keyword, even though it supports it (i.e. "SELECT TOP 10 ...").
4
votes
2answers
118 views

Data Explorer query editor ignores Shift+Space

The query editor in the Data Explorer does not insert a space if the user types Shift+Space. This is very annoying for those of us who prefer to type SQL keywords in upper-case. Sometimes I haven't ...
1
vote
1answer
45 views

Crash when editing profile on data explorer

I just tried to update my profile on SEDE, but got a crash (the ASP.Net yellow screen of death) when I clicked save. Does the "about me" section support markdown (like the other SOFU sites), as I was ...
8
votes
1answer
167 views

Allow parameters for parametrized queries in Data Explorer's URLs

It would be nice if you could specify parameters for parametrized queries directly in URLs. Something like this: http://odata.stackexchange.com/stackoverflow/s/75/my-comments?UserId=1431
1
vote
1answer
106 views

Data Explorer Recent Queries not Updating

The recent queries view in the data explorer seems to be broken. It shows, since quite a while, that Mark Hurd asked for Quick Answers, zero seconds ago. The view doesn't seem to be updated by new ...
6
votes
1answer
193 views

Data Explorer's stored queries should have a slug in URLs

Links to stored queries should have a slug like SO question links: e.g. http://odata.stackexchange.com/stackoverflow/q/734/how-long-until-i-get-the-generalist-badge
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.
5
votes
1answer
108 views

Can we change the SEDE workflow a little?

Currently when a user goes to SEDE they must first pick a site for which to run their query. Only then can they browse the available queries or compose one of their own. Seeing that the queries are ...
2
votes
0answers
64 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 ...
14
votes
1answer
167 views

This definitely shouldn't be here

BOOOOOOOOOOOOOOOO!! http://img175.imageshack.us/img175/3962/editlink.jpg I'm not ausaitis or a moderator, so I don't think I should be editing his profile... The link doesn't work, it just sends me ...
0
votes
1answer
136 views

Any plans to load the community data dumps to a data warehouse?

So you'd have point in time and all the other things you might get out of a data warehouse. I can see where this relates to using the dump(s) for an AdventureWorks replacement, with the additional ...
2
votes
2answers
119 views

OpenID login does not work on Data Explorer with Google Chrome

I can't login to Data Explorer with Google Chrome. Firefox works just fine. When I click "Log in" button or press enter after writing my OpenID, nothing happens. I am using Windows Vista, Google ...
5
votes
1answer
103 views

Data Explorer query results: align columns with numerical data to right

If column type in Data Explorer's query is numerical, it should be right aligned. Looks nicer that way. Like this: 123 0 321123 1231 99999 Not like this (current situation): 123 0 ...
2
votes
1answer
153 views

How are featured queries selected in Data Explorer?

Recent and popular queries are self explanatory, but how are featured queries selected in Data Explorer?
5
votes
3answers
144 views

Average Answerer's Age (among the tags answered by more than 1000 users with age filled) [closed]

Average Answerer's Age (among the tags answered by more than 1000 users with age filled) White-bearded aqsaqals of age 33, who have mastered the principles of agile development, use old-school ...