All Questions
Tagged with support data-explorer
702
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 ...
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 ...
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 ...
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?
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 ...
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 ...
32
votes
2
answers
3k
views
Meaning of Values for PostTypeId in data explorer or in data-dump [duplicate]
I am looking for some explanation of the schema for the data dump of se sites.
Specifically I'd like to know the values for PostTypeId field (1=Questions?, 2=Answers?, 3=?, etc).
I have tried to ...
32
votes
1
answer
727
views
Easy way to make local copy of entire SE database?
Recently, I have been using the Data Explorer to try to find fishy users on SO. However, the Data Explorer is limited when it comes to cross-site and time-consuming queries, so I want to create a ...
30
votes
1
answer
398
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 ...
29
votes
1
answer
563
views
How many posts are downvoted without a comment?
A returning theme on our beautiful and productive Meta sites is the topic on downvoting without leaving a comment. Yes, that is a bit cheeky and admit it: you've done that as well.
In a recent post ...
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?
27
votes
1
answer
487
views
Stack Exchange Data Explorer Login is Changing
Update Aug 27, 2020
The migrations have been executed.
I've just tested that I can login into my old account via the new login method!
In line with our efforts to discontinue support for OpenID, we'...
27
votes
2
answers
930
views
Record for most consecutive days visited?
Is there a way to find out the actual number for the highest ever consecutive days visited?
I don't want to know who the user is that holds the record (I would hope that information would be kept ...
22
votes
1
answer
419
views
How can I delete my Stack Exchange Data Explorer account?
How can I delete an account on the Stack Exchange data explorer?
I can't find any way to request the deletion when logged in to the account.
(Note that SEDE is an independent system. SEDE accounts ...
21
votes
1
answer
872
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" ...