Skip to main content

All Questions

Tagged with
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 ...
Nate's user avatar
  • 1,163
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 ...
badp's user avatar
  • 33.5k
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?
cpx's user avatar
  • 1,257
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 ...
Philippe's user avatar
  • 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 ...
JonathanDavidArndt's user avatar
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 ...
Unreason's user avatar
  • 707
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 ...
dwitvliet's user avatar
  • 1,219
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 ...
Amal Murali's user avatar
  • 5,269
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 ...
rene's user avatar
  • 91.1k
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?
Daniel A. White's user avatar
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'...
m0sa's user avatar
  • 22.2k
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 ...
chown's user avatar
  • 3,823
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 ...
Gilles 'SO- stop being evil''s user avatar
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" ...
Justin's user avatar
  • 8,470

15 30 50 per page
1
2 3 4 5
47