All Questions
Tagged with data-explorer status-bydesign
30
questions
4
votes
1
answer
89
views
Why does this simple Data Explorer query only return 124 rows instead of 4,912?
Why does this query only return 124 rows when https://stackoverflow.com/users/470749/ryan?tab=votes&sort=all says "4,912 Votes Cast"?
SELECT v.id, v.VoteTypeId, v.CreationDate
FROM Votes ...
5
votes
1
answer
107
views
SEDE did not update
SEDE currently states it was updated 11 minutes ago:
However this does not appear to be the case, as this query:
select
max(creationdate) [last action],
datediff(day, max(creationdate), getdate(...
1
vote
2
answers
55
views
PostTags does not include deleted questions
The PostTags table in SEDE does not contain deleted posts. For example, on Worldbuilding:
Nondeleted posts: Total: 10845, In PostTags: 10845 (100.00%)
Deleted posts: Total: 1410, In PostTags: 2 (0.14%...
41
votes
1
answer
344
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
...
1
vote
1
answer
35
views
Can't reach stats for Portuguese language SE in Data Explorer
I type Portuguese into the Switch Sites box and all I get is Politics, Poker, SO in Portuguese, and relevant metas.
4
votes
1
answer
37
views
Post link is broken for tag wikis
I was making a query to tell me which are the shortest (by character length) posts on stack exchange. But I was unaware that my search includes tag wikis and other posts.
Funny thing is that the link ...
-3
votes
2
answers
868
views
Please STOP requiring Google profile info, and switch to the other endpoint!
I know this change already took place some months ago, but I wanted to write about this now. Here's the situation:
When I click on
I login on my Gmail account and get :And I don’t have a public ...
4
votes
1
answer
473
views
Data Explorer CAPTCHA doesn't work with Google blocked
I tried to do this again:
Keep track of your rejected edits
but when I follow the link in the accepted answer, I get no CAPTCHA when I click on "I am a Human Being".
I use Firefox 32 with ...
3
votes
1
answer
71
views
Some accepted answers appear to have been unaccepted but still have the checkmark [duplicate]
Some accepted answers do not have a valid accept-vote in Votes table, even though the question owner still exists. Stack Overflow alone has over 2000 such answers. A recent example is Sub query for ...
3
votes
1
answer
122
views
Data Explorer page keeps freezing Chrome and Firefox [duplicate]
On Firefox 29.0 when I visit https://data.stackexchange.com/stackoverflow/query/209394, the browser comes to a grinding halt and does not recover.
On Chrome 35.0.1916.153 when I visit the same page ...
2
votes
1
answer
42
views
Data.SE does not display correct query title for old revisions
Minor issue: When an existing query on Data.SE is edited and the title is changed, clicking on previous revisions in the editor displays the new edited title and not the title from that revision.
The ...
10
votes
1
answer
1k
views
Where did EmailHash go?
There are at least four ways to get to StackExchange data: OData (https://data.stackexchange.com/stackoverflow/atom/), Data Explorer (https://data.stackexchange.com/), XML data dumps (https://archive....
0
votes
1
answer
71
views
Removed comments not being removed from SEDE database
I tried generating obsoletes with this SEDE Query, but if you look under the 'Comment Link' row, something is really weird. Some of the links don't contain the comment in the post anymore (for ...
7
votes
3
answers
2k
views
Why can't I pull in all the SO users from Data Explorer?
It only returns 50,000 rows when I do the query below. I thought there are more than that.
select id,DisplayName from Users
33
votes
2
answers
636
views
Why is the ##UserID## parameter not populated in Data Explorer anymore?
Environment
I'm logging in using the OpenID from http://openid.stackexchange.com and using Chrome 31.0.1650.57 m if that matters.
Steps to reproduce:
Log in to Data Explorer and compose a query, for ...