Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with data-explorer
Search options not deleted
in saves
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.
386
votes
2
answers
129k
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 Stack Exchange …
354
votes
Database schema documentation for the public data dump and SEDE
About this list:
foreign key fields are formatted as links to their parent table
italic table names are found in both the Data Dump on Archive.org as well as in the SEDE
if a column is optional or nu …
166
votes
31
answers
11k
views
Interesting queries on Data Explorer [closed]
Let's collect some interesting queries for the Stack Exchange Data Explorer here.
How many upvotes do I have for each tag? (how long before tag badges?)
SELECT TOP 20
TagName,
COUNT(*) AS UpV …
154
votes
The company's commitment to the data dumps, the API, and SEDE
(Note: the quoted sentence was edited after I posted my answer. I am leaving this answer unedited and undeleted, so that it is available for folks reading the revision history.)
From the original pos …
- 14.6k
71
votes
2
answers
560
views
Delete own query on data explorer
Is it possible to delete or at least hide your own data explorer query when you know you've only been testing something and don't want it to show?
- 2,109
116
votes
4
answers
783
views
Beta sites should be in the Data Explorer
The Stack Exchange Data Explorer is a very nice and useful tool, but it has one very large drawback: Beta sites are not included at all.
Excluding beta sites probably made a lot of sense when the bet …
- 189k
86
votes
4
answers
8k
views
Planned Maintenance scheduled for Wednesday, February 5, 2020 for Data Explorer
Update: The maintenance went as planned.
tl;dr; Planned service interruption that will impact Stack Exchange Data Explorer (SEDE). The site will be inaccessible for up to 12 hours on February 5, 20 …
- 51.6k
106
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 fin …
- 1,183
92
votes
Implement OData API for Stack Overflow
I emailed Jeff Atwood last night a one line email. "You should make a Stack Overflow API using OData." Then I realized that, as Linus says, Talk is Cheap, Show me the Code. So I created an initial pro …
- 1,037
71
votes
Accepted
Where can I see how many posts have I edited?
Yes, there certainly is a place where you can check this:
Click on the "Users" tab in the main navigation bar.
Click on the "editors" tab.
Select the "all" filter.
Search for your user name.
When …
- 64.4k
70
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,267
101
votes
1
answer
2k
views
Can some metadata about deleted posts be included in Data.SE?
I like to use Data.SE to view usage stats for some of the sites, however deleted posts are not included on Data.SE and I think this skews the numbers quite a bit, particularly on sites with a lot of d …
- 19.3k
100
votes
3
answers
3k
views
Why is my profile image different?
When I first signed up on a Stack Exchange site and got a profile image, it was this one (see my current user card I'm actually not sure what I look like any more):
Later, I got Area 51 and SEDE p …
- 56.4k
82
votes
4
answers
860
views
Let SEDE users get hold of data on unsuccessful close votes for stats
I have the feeling that with the growing influx of questions, an increasing number of questions that are clear closing candidates (i.e. it is totally obvious and undisputed that they belong closed und …
- 115k
57
votes
Accepted
When will data.SE get updated data?
The data is updated early every Sunday morning around 3:00 UTC
Update 9 Nov 2012 - Done!
Since our datacenter move has been delayed, I was able to use the new server as soon as it arrived. Data.SE n …
- 126k