All Questions
Tagged with support data-explorer
702
questions
9
votes
1
answer
132
views
What does the error message "unknown job being polled!" mean on SEDE?
Error message seen on the first attempt to run this query anonymously:
unknown job being polled!
Screenshot:
The second attempt to run the query was successful.
- 41.3k
6
votes
1
answer
73
views
What basic logic decides what does or doesn't get included in SEDE?
What basic logic decides what information does or doesn't get included in SEDE?
And what are the nuances for when certain things might not follow that basic logic?
I'm looking to get a kind of ...
- 26.8k
10
votes
1
answer
109
views
Is it possible to use cached results of an already-run query in another query?
The results of queries are cached until the next refresh: 1, 2.
Is it possible to refer to those cached results in other queries?
I imagine if there is, it might look something like this:
SELECT * ...
- 26.8k
5
votes
1
answer
97
views
Searching my own unanswered questions over all Stack Exchange sites
I wish to get a list of my own unanswered questions over all Stack Exchange sites.
It seems you can run SQL queries with data.stackexchange.com, something I learned only today. Is there a way I can ...
- 161
5
votes
0
answers
157
views
What happened to FavoriteCount?
On 10/22 I ran a query on the Data Science SEDE. In the Posts table I selected some columns, FavoriteCounts included. Looking at the results from the .csv I see a lot of different unique values for ...
- 51
3
votes
0
answers
47
views
SEDE quick-view of CloseAsOffTopicReasonTypes table does not match query result [duplicate]
#5 quick-view is about super-user, but query is about SSCCE
#6 quick-view is about career / office politics, but query is about minimal understanding
#7 quick-view is about what tech to learn next, ...
- 26.8k
13
votes
1
answer
197
views
What does replacing bookmarks with Saves mean for SEDE?
So, relatively recently bookmarks were replaced by Saves: Bookmarks have evolved into Saves.
In SEDE, bookmarks were stored in the votes table. They were stored with VoteTypeId=5 and the user was ...
- 15.2k
2
votes
2
answers
197
views
How to run a Stack Exchange data query with the Stack Exchange API
I'm trying to find out if there is a way to run a query/complex search on the Stack Exchange API.
I need to find all users that have a reputation greater than 250 and are from a certain location. I ...
8
votes
1
answer
147
views
Which sites have the most prominent top users?
I was looking at the top users of Chess Stack Exchange and noticed the top user @BrianTowers has more than twice the reputation (79k) of the next user @PhishMaster (32.1k). Are there more Stack ...
GlorfindelMod
- 253k
5
votes
2
answers
250
views
Highest reputation moderators?
Highest-rep users on the network are easy enough to find. What about highest-rep moderators? We all know that moderation ability doesn't necessarily correlate with reputation, and moderators on ...
- 33.4k
2
votes
1
answer
66
views
Search a SO post that I closed with a certain keyword
Is there a way to search for a Stack Overflow post that I closed and that has a certain keyword say "this" or certain code say this in it?
I mean, I want to search by typing in the search ...
- 617
4
votes
1
answer
106
views
How do I access this built-in SEDE functionality to run multi-site queries?
Queries in the Stack Exchange Data Explorer are usually run over one database, i.e. a single Stack Exchange site. It is possible to do a multi-site query by fully qualifying tables (including the ...
GlorfindelMod
- 253k
5
votes
2
answers
146
views
How can I see the list of questions that were removed by a mod from the list of hot network questions on a given SE website?
How can I see the list of questions that were manually removed (= removed by a mod) from the list of hot network questions on a given SE website?
- 41.3k
6
votes
1
answer
113
views
Find questions with the longest titles
I want to find the list of questions on a site that have the longest titles.
The purpose is testing design elements that might break or have layout problems if the title is too long. It's also an ...
- 27.3k
8
votes
1
answer
96
views
Which tags attract drive-by questions? Or: How do I compute, for each tag, the number of users of that tag who have ≤N total questions?
I'm currently thinking about questions with the character-identification tag at Chinese Language. I feel like a lot of the questions with this tag are "drive-by" questions, i.e., the user ...
- 22.1k