All Questions
Tagged with support data-explorer
225
questions
382
votes
2
answers
124k
views
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the ...
17
votes
2
answers
800
views
How can I get URLs and site names for a cross-site SEDE query?
When doing cross-site queries on the Stack Exchange Data Explorer, two of the main problems are 1) getting the URLs right and 2) getting the site names right. For URLs, we have constructions like the ...
GlorfindelMod
- 253k
17
votes
1
answer
292
views
Why are my SEDE results inaccurate/obsolete/incorrect/outdated?
When I use the Stack Exchange Data Explorer (SEDE), the results I get don't reflect recent activity. Sometimes the data I get back are two months out of date. What's wrong?
This is intended to be a ...
13
votes
1
answer
482
views
Data from the Stack Exchange Data Explorer is obsolete [duplicate]
I was querying data from https://data.stackexchange.com/stackoverflow/atom using a LINQ query in LINQPAD and found that the data I got back is quite obsolete. I searched for Shekhar-Pro (me) by using ...
- 351
28
votes
2
answers
418
views
Why am I jon.doe when logging into Data Explorer?
I just tried to login to the Data Explorer and it gave me a jon.doe user.
I used the same openid...
How can I link this to my other accounts?
- 3,502
19
votes
2
answers
679
views
Why is vote time missing in the SE data dump and SEDE?
Is there a particular reason why vote times are omitted in the data dump?
IMO this could be a very useful data-set. Is this one of the steps that was done to anonymize the data, or does it simply not ...
- 14.7k
7
votes
1
answer
228
views
Wrong user when logging into Data Explorer
I think I'm having the same issue as reported in this question:
Why am I jon.doe when logging into Data Explorer?
When I log into SEDE with the same OpenID account I use for SE, a different user ...
- 418
104
votes
2
answers
3k
views
How can I search my comments using some keyword(s)?
Here's my problem: I know I've posted something on Stack Overflow about a particular topic. I know how to search all my answers with a given keyword, and that feature works well. But, if I don't ...
- 1,163
69
votes
3
answers
1k
views
Where can I see how many posts have I edited?
I've found here many queries to check edit counts, and I get different results for each one. Which one is the most accurate and up-to-date query? Or is there any way to see the edit count in stats?
- 1,257
85
votes
1
answer
7k
views
"OpenID 2.0 for Google Accounts is going away"; will this affect Stack Exchange? [closed]
Apparently, for some reason, Google is retiring its OpenID 2.0 platform. I got this notice while logging in with Disqus, but not with Stack Exchange.
So... is Stack Exchange going to be affected by ...
- 33.5k
63
votes
11
answers
4k
views
The company's commitment to the data dumps, the API, and SEDE
Many words have been written around the company's commitment to the ongoing existence of the data dumps, the API, and the Stack Exchange Data Explorer (SEDE). Much of that text can be confusing or ...
- 21k
37
votes
2
answers
6k
views
Is there any place to see a leaderboard of top "Helpful Flaggers"?
There are a few members of Stack Overflow especially who have a ridiculous number of helpful flags.
At the moment, there does not appear to be any way to display the top users with the most helpful ...
- 1,254
13
votes
2
answers
409
views
How can I write a cross-site Data Explorer query that joins databases on linked accounts? [duplicate]
The answer to this question implies that you can write cross-site Data Explorer queries, but the sample query doesn't appear to do what I think it should.
SELECT TOP 1 *
FROM [StackOverflow....
- 14.8k
10
votes
2
answers
253
views
Automatic logging into Data Explorer
On most Stack Exchange sites, when I visit them I am already logged in if I have logged in before.
Why isn't it the case with Data Explorer?
- 8,497
8
votes
1
answer
280
views
Out-of-resources when trying to run a popular DataExplorer query
So, I tried to run this query
Users with highest Socratic progress (socratic hopefuls)
which has many views (so I assume it's popular), but I get a message saying:
The query processor ran out of ...
- 26.8k