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
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 ...
9
votes
1answer
101 views

Cannot log into SEDE with Google account - openid was dropped

Related: "OpenID 2.0 for Google Accounts is going away"; will this affect Stack Exchange? Google has now officially retired OpenID 2.0. Now, i can't log in to SEDE anymore. I just get ...
8
votes
1answer
143 views

Provide convenient way to get the current site URL in SEDE query

Since Data Explorer allows us to create links to any of the "unlinked pages" (like suggested-edits, timeline, revisions etc) it would be useful to have a convenient way to get the URL of the site ...
7
votes
3answers
113 views

Can I set default values for Data Explorer query parameters?

Is it possible to set a default value for a Data Explorer query parameter?
7
votes
2answers
274 views

SEDE caching issue

SEDE has been updated, but apparently the query results are being cached and thus showing old results. Example: http://odata.stackexchange.com/stackoverflow/s/582/find-most-recent-post http://odata....
7
votes
2answers
77 views

Why are there posts with votes cast before their creation date?

I was playing around with the Data Explorer and found to my surprise that several posts have received votes before they were created: 67 posts on Stack Overflow have received up-votes, down-votes, ...
7
votes
2answers
116 views

On what “day of the month” is Stack Exchange Data Explorer updated? [duplicate]

I know this question might seem like a duplicate, but none of the questions give an exact answer. The FAQ mentions that data is updated monthly. Which of the following is a correct interpretation of ...
6
votes
1answer
2k views

OData has left me really confused

One of the more popular meta topics is Implement OData API for StackOverflow Well ... done, here you go http://data.stackexchange.com its an odata endpoint for the current stack overflow db. But ...
6
votes
1answer
169 views

Is there a reason that CS50 and edx-cs169-1x are not present in SEDE?

I left a comment on this question suggesting to try a cross-database query to get a reliable statistic (I did mention that it might run for too long but that is not the point). After seeing nicael's ...
6
votes
1answer
116 views

Data explorer: votes without voters

Hi, It seems that the vast majority of the votes has no userid associated with it: SELECT COUNT(*) FROM votes WHERE userid IS NULL; -- Nobody voted? 9211783 SELECT COUNT(*) FROM votes WHERE ...
5
votes
3answers
179 views

How can I query SEDE for tags I've created?

How can I query the Stack Exchange Data Explorer for tags I've created?
3
votes
2answers
154 views

In the data explorer can you get the date/time of the last data update to use in the query?

I was building a query that ranked users by the number of votes they cast per day, and it dawned on my that doing the following has a serious flaw (which may well be my fault?): /* with added line ...
3
votes
1answer
133 views

SEDE translation of Legendary badge query

Jeff's query for Legendary badge is given here: https://meta.stackexchange.com/questions/57232/is-150-rep-cap-exceeded-alone-enough-for-legendary-badge/58192#58192 Given that the tables in data.se !=...
3
votes
1answer
119 views

Links to all my questions?

Is there a way to get hold of a parsable list of links (or if that's not possible, IDs) to all my questions to all my answers preferably without using the data dump?
2
votes
1answer
76 views

How can I query for StackExchange.* databases on the Data SE?

By default my table names are using the current site to which I am connected on. Thus a query SELECT TOP 100 * FROM Users will list 100 users. If I wish to select from a different database, in some ...
1
vote
1answer
81 views

Count city wise users from Stackoverflow Database

How do I get City wise users count from Stackoverflow Database? I found one Location field in Users table which may contains City, State, Country I wanted to get count all the City wise Users from ...
19
votes
1answer
160 views

Broken URL for data.stackexchange.com help page

When using data.stackexchange.com I fail to remember if as [post link] is the correct alias to get the url for the post. Luckily the site has an help link. Unfortunately it is now broken. Can this ...
18
votes
1answer
131 views

How can I get the text from a large number of deleted posts?

I'm looking into running a machine-learning project on EL&U to detect low-quality posts. To do that, I need a large dataset - and to get that, I need to get the text from a large number of deleted ...
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 ...
17
votes
1answer
178 views

Why do some questions have a favorite count of 0 while others have none?

I was playing around on SEDE when I noticed some questions have a favourite count of 0, while the majority have a favourite count of NULL. What's the reason behind this? For the questions with a count ...
14
votes
1answer
157 views

SEDE migration failed?

It's currently 11AM UTC and SEDE still has previous week's data (usually migration occurs around 4AM Sunday UTC). I know there's no SLA; this is just a heads-up and bug-placeholder in case there's a ...
13
votes
3answers
398 views

Why is there a TextBox instead of a Button in Data Explorer's Captcha?

I was trying to run a query in Data Explorer without logging in (I didn't notice that I am not logged in). When I click on Run Query button, I got a Captcha to avoid spam queries. But what I found ...
12
votes
1answer
224 views

How does StackExchange DataExplorer prevent DOS attacks?

I have seen the page for composing Data Explorer queries. If I enter some stupid queries like: select * from Posts a, Posts b, Posts c ..... where 1=1 etc., how does StackExchange prevent it from ...
12
votes
1answer
168 views

Why are there no close or reopen votes in the data explorer following June 25th, 2013?

I ran this query select distinct CreationDate from votes where (VoteTypeId = 6 OR VoteTypeId = 7) order by CreationDate desc and got (That's showing the top of the list.) What's going on? I know ...
11
votes
1answer
233 views

SEDE footer still links to version 3.0 of Creative Commons license

According to Stack Exchange and Stack Overflow have moved to CC BY-SA 4.0, subscriber content is now licensed under version 4.0 of the Creative Commons license. The change is reflected in the footer ...
11
votes
0answers
174 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
1answer
109 views

StackExchange Data Explorer bug (PRIMARY filegroup full)

While trying to execute a query in the StackExchange Data Explorer I got the following:
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
1answer
144 views

Oops, it did it again - SEDE didn't update for Stack Overflow

Last week's SEDE update left out poor Stack Overflow. And it did it again this week. This SO query only returns results up to 8/25/2015, while it seems for every other site it correctly returns ...
9
votes
1answer
84 views

Allow switching the site before executing a query

Currently, if you open a Data Explorer query, you can't switch the site until you actually execute the query, because the site list is hidden. Please change this. As it is, you either have to execute ...
8
votes
0answers
82 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
1answer
159 views

SEDE reports Could not allocate a new page for database 'TEMPDB'

I have been running queries for pretty much most of the day with success. However when trying to find out if the posthistory table might hold records for deleted posts I naively ran this query: ...
7
votes
1answer
282 views

“Server Error in '/' Application” on SEDE with new auth

I just logged in to SEDE with the new login thing (which was updated because Google was phasing out the old OAuth system). It seems to have not associated me with my old profile - I'm now jon.doe18288....
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
1answer
89 views

“permalink to this query” on data.stackexchange.com seems to be broken

The "permalink to this query" on data.stackexchange.com seems to be broken. For example if you visit the Top 50 Most Prolific Editors from the query list page and then click on the permalink you see ...
7
votes
3answers
170 views

data.stackexchange.com site URLs contain spaces

Below are a list of the links from http://data.stackexchange.com that currently have spaces in them: http://data.stackexchange.com/drupal%20answers/queries http://data.stackexchange.com/unix%20and%...
7
votes
0answers
92 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
1answer
80 views

Is the count of anonymous feedback available in the schema?

I've been interested in what sort of questions are helpful to anonymous people rather than regulars. I would like to get a count of anonymous feedback "Helpful" and "Not Helpful" votes on a question. ...
7
votes
2answers
122 views

Stack Exchange Data Explorer was not really updated

The Stack Exchange Data Explorer page claims that the “English Language & Usage” data was last updated on March 21, but the data is much older than that. One example of query where this is ...
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
59 views

Moving comments to chat seems to be missing in timeline and SEDE?

There are two possibilities how comments can be moved to chatroom. Either a moderator moves them or the users who discuss in comments are offered to continue in chat - and if they choose this option, ...
6
votes
1answer
88 views

Why can't I permalink to this Data Explorer query?

Why does this Data Explorer query explode (on Firefox 7.0.1, Mac OS X 10.6.8)? I can run the query once, when I compose it for the first time, but all further attempts to access it from my profile or ...
6
votes
3answers
149 views

Removing a data.stackexchange.com query from cache

I noticed that a query on the stackoverflow data is cached after first execution. This is quite good, but how to force a re-execution? Since the underlaying data changed the query results are no more ...
6
votes
0answers
75 views

Add the “Days Visited” metric to SEDE

I was writing a query on SEDE, when I noticed there was no "Days Visited" value. I have circled the available user metrics, alas there is no Days Visited While there is a CreationDate, this can't be ...
6
votes
2answers
115 views

The Download CSV link seems broken in SEDE query result window

I've created this query with a UserId parameter which works nice. I would really like to download those results as an CSV file. Therefor I click on the provided link on the right hand side of the ...
5
votes
1answer
157 views

Hide the broken OData link in Data Explorer

The OData protocol was used in the past as a feature to get data from SE data dumps, but is currently lightly maintained since the Stack Exchange API is usually better. The problem is that it seems ...
5
votes
1answer
84 views

Why is len(Posts.body) incorrect on answers in data.SE?

I was trying to find a longest answer on a site, and ran into a weird discrepancy: This query shows that this answer has a length of 36388 (length in the query is defined as LEN(Posts.Body)) Yet, ...
5
votes
1answer
103 views

Every second failed Data Explorer query just removes the last error

Start a new query. Put in something that is correct syntax. E.g. SELECT NULL Click Run Query and the correct results are displayed. Make it a syntax error. E.g. SELECT NULLx Click Run Query and ...
5
votes
1answer
158 views

Finding Number of Followers of a Tag in the Data Dump

I'm doing a research on the developers' QAs in Stack Overflow, I have checked Stack Exchange Data Explorer and data dumps but I didn't find number of followers of a tag: There isn't any related ...
5
votes
0answers
49 views

SEDE not parsing localized tags

I ran the query Most common tags with missing wiki/excerpt and Stack Overflow em Português localized tags are rendering as: I think it's not a duplicate, the other bug report renders the following in ...

1 2 3
4
5
10