All Questions
Tagged with support data-explorer
705 questions
7
votes
0
answers
52
views
"permission denied" error when running cross-site query
When attempting to run a cross-site SEDE query, I get this:
Line 1: CREATE TABLE permission denied in database 'tempdb'.
I can reproduce this with the provided examples.
While I realize it's around ...
- 16.3k
12
votes
0
answers
216
views
The SEDE refresh is stuck on Math [closed]
I just happened to check in the SEDE refresh with this query:
select database_id
, database_name
, site_name
, initialized
, made_available
, processing_time
, ...
reneMod
- 92.1k
10
votes
1
answer
245
views
A SEDE query that worked for years is now timing out for the last ten attempts [duplicate]
The SEDE query All my posts on the SE network (with Markdown and HTML content plus editors and status) has been working for years, however over the last week, and the last ten attempts, this error ...
- 569
4
votes
1
answer
62
views
How do I associate a saved Data Explorer query with a single site?
I have some saved-queries in data.stackexchange that shows me my top-voted comments using WHERE c.UserId = @myUserId ...so far, so egotistical.
...but because my UserId is different on each site (e.g. ...
- 261
6
votes
1
answer
138
views
Fetching posts in a given month with the StackExchange Data Explorer produces Execution Timeout Expired error
Some years ago, I wrote a generic query to fetch posts in a given month.
WITH allData AS (
SELECT
ROW_NUMBER() OVER (ORDER BY P.Id) AS row
, P.Id
, ...
- 197
4
votes
1
answer
217
views
Profile User ID 195420 does not appear in query result for Blender Stack Exchange users
I'm trying to query out potential profile spam on Blender Stack Exchange using the following query on https://data.stackexchange.com/blender/query/new. It's not perfect since I'm still just testing ...
- 376
5
votes
1
answer
91
views
How can I search for tags with that include a specified string in their Usage Guidance?
I would like to search for all tags (on Stack Overflow) that include some specific string in the Usage Guidance portion of their Tag Wiki. How can I do that?
Specifically I would like to search for ...
- 4,167
7
votes
2
answers
131
views
How should I go about retrieving the date of when a question became/was no longer hot with SEDE?
I am currently making a SEDE query to determine which questions from a specific user have made it onto the Hot Network Questions list and when. While I can get the specific questions, I am unable to ...
- 411
-1
votes
1
answer
135
views
Data explorer query takes a lot of time and needs to be optimized
This is a Stack Exchange Data Explorer query which gets the top users on specific skill scores (example: JavaScript) based on a specific country (example: Egypt), and it took a lot of time until it ...
- 23
7
votes
2
answers
290
views
Data Explorer Query crashes with collation conflict error
I have a website built off my Q & A posted in Stack Exchange sites such as; Ask Ubuntu, Stack Overflow, SE Security, etc.
Data Explorer is used to scrape ALL Stack Exchange Q & A I've posted ...
- 569
5
votes
1
answer
108
views
Are SEDE results ever cached on client side, or solely on server side?
I know that SEDE query results are cached on the server side. I wonder if in some cases they are also cached on the client side.
- 48.2k
5
votes
1
answer
165
views
How can one see when a query was cached in SEDE?
Query results in SEDE are cached:
How can one see when a query result was last cached in SEDE?
- 48.2k
10
votes
2
answers
176
views
How can I write and run a SEDE query without the query itself being visible to other regular SEDE users?
How can I write and run a query in SEDE without the query itself being visible to other regular SEDE users, such as in the "everything" tab of the "queries" page?
- 29.2k
7
votes
1
answer
121
views
What exactly is the "sql" parameter in SEDE and what purpose does it serve?
SEDE supports query parameters. I found that if I try to define a query parameter of string type named "sql", whatever I pass as the argument for that parameter will be prepended by a string ...
- 29.2k
4
votes
1
answer
100
views
How can I see the number of questions that a given user voted to close but got later reopened by someone else?
I wonder the following: for a given user, how can I see the number of questions that they voted to close, but the question was later reopened by someone else (possibly a group of users)?
- 48.2k
16
votes
0
answers
293
views
What's going on with SEDE right now? It's being fickle
When I open a new tab, I get "we are currently offline", and then I refresh a couple of times and it's fine.
Then when I try to run a query, it will give
unknown job being polled!
or
...
- 29.2k
0
votes
0
answers
150
views
Get statistics about self-deleted accounts
It's interesting to know is there a possibility to get the number of deleted users on site per specified period?
Additional information like reputation, number of posts etc on the moment of deletion ...
- 69.7k
3
votes
1
answer
144
views
How can one see how many regular users cast at least one reopen vote during the current year?
I am looking at some question reopening statistics. How can one see how many regular users cast at least one reopen vote during the current year? Preferably with the count of how many reopen votes ...
- 48.2k
2
votes
1
answer
150
views
SEDE query to pull votes on a post within 90 days of its creation date
I am trying to query SEDE so I can count the upvotes (and I would also like to count the downvotes in its own column) that happen within 90 days after the question or answer was created.
I have tried ...
- 51
10
votes
0
answers
162
views
Some Users have an AccountId being Zero
We know account creation is finicky from answers to questions like Why is my profile messed up on a single site and how can I revert it? among others.
In some of these cases you end-up with a user-...
reneMod
- 92.1k
1
vote
1
answer
81
views
How to query SEDE for user sign-up dates for a specific community
We are looking to query a list of users to receive the sign-up dates to the Stack Overflow sub-community. Does anyone have a suggestion how to do this via SEDE?
- 51
9
votes
0
answers
114
views
How can we check how often questions sent to the close queue age out?
My site is dealing with a rather long close vote review queue and we believe reviews are regularly ageing out. We want to address the problem in Meta and motivate it with stats over time about how ...
- 547
2
votes
0
answers
113
views
Should Windows Phone site be removed from SEDE?
I have noticed that it is possible to see Windows Phone as one of the sites where one can run SEDE queries. As an example, here is a query listing the recent posts.
This query shows the date as the ...
- 15.6k
4
votes
1
answer
1k
views
How can I view unread messages?
At one point I had up to a hundred of unread messages. I read many of them, but the notification icon says there are four I have not. Because of the sheer number of the messages, I am having ...
- 1,063
8
votes
1
answer
97
views
Can you save an edit to a SEDE query's title or description without editing the query?
I don't create queries in SEDE much but when I do, I forget to give them a useful title and description until after I'm finished creating them and click the permalink button.
In an effort to avoid ...
- 111k
5
votes
2
answers
268
views
Search for comments on posts with a certain tag based on a keyword
I am trying to get the comments on posts with a specific tag which include a phrase or a keyword of interest using SEDE. Here's my first attempt: https://data.stackexchange.com/stackoverflow/query/...
- 3,100
-8
votes
1
answer
132
views
Finding my upvotes on Data Explorer
This T-SQL finds all the questions I have answered on SO.
https://data.stackexchange.com/stackoverflow/query/1779459/questions-i-have-answered
I want to determine if I upvoted the question or not (as ...
- 131
4
votes
1
answer
61
views
Can I see other user's badge progress and/or tag progress short of doing SEDE query?
I can see my own badge/tag progress in the "Select your next badge" dialog box from the User Activity screen. For example, I can see that I'm 455/500 for a gold Copy Editor badge in ...
- 1,061
1
vote
0
answers
99
views
What am I supposed to do when I get what is probably the "requires external JavaScript" error for the chat domains and SEDE?
I'm suddenly getting this error in my main sites (like SO and MSE)
Meta Stack Exchange requires external JavaScript from another domain, which is blocked or failed to load. Retry using another source....
- 29.2k
64
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 ...
- 21.2k
9
votes
2
answers
284
views
What exactly do VoteTypeId=4 (offensive) and VoteTypeId=12 (spam) mean?
According to the Database schema documentation for SEDE, the table Votes contains as VoteTypeId 4 = Offensive and 12 = Spam. The latter was mentioned, for example, here: How to find posts closed as ...
- 15.6k
3
votes
1
answer
660
views
How can I download a small data set (1 year 2023-2022) from Stack Exchange?
I want to download a small dataset for one year. I didn't find a link that allows me to download 1 year of data or the last five years' data.
I tried "https://data.stackexchange.com/stackoverflow/...
5
votes
1
answer
191
views
Ranking users with most edits and close votes on a specific tag
A while back I asked this question about writing a query which would rank users based on their number of close votes on posts related to a specific tag: Table of users ranked based on their number of ...
- 3,100
5
votes
2
answers
174
views
Table of users ranked based on their number of close votes in a specific tag
I am trying to get the list of users that have the most number of close votes (tallying each type of close votes; i.e. Duplicates, Too Broad, Need MRE, Not About Programming, etc.) in a specific tag. ...
- 3,100
9
votes
1
answer
217
views
When were comments first available on Stack Exchange?
I am curious about when comments first became available on Stack Exchange (or whatever the site was when the development occurred). I ask this because, in the Database schema documentation for the ...
-19
votes
3
answers
267
views
Can GPT-4 be used to do SEDE queries?
I don't know how to do SEDE queries, but I would like to explore some of the Earth Science Stack Exchange data.
Once I needed a query it was done by user rene, but I have many queries to do on Earth ...
user1242306
3
votes
1
answer
64
views
How can I find users with a specific number of earned/offered bounties?
How can I find users with a specific number of earned or/and offered bounties?
- 69.7k
-2
votes
1
answer
197
views
How can you view the most upvoted comments on your posts (answers and questions)?
Is there a way to view the most upvoted comments from any of my answers or questions on Stack Overflow?
There are two similar questions/answers:
Search for my most upvoted comments and
Can I view a ...
- 1,281
1
vote
1
answer
394
views
Find posts deleted by authors, that deleted their own account later
How can we find posts deleted by their author that deleted their own account later?
- 69.7k
3
votes
0
answers
92
views
How can I find my OpenID identifier for logging in to SEDE?
In my previous post, all the login options at SEDE seem to be linked to the same URL which doesn't work. The last one I haven't tried is OpenID. But how can I find it?
- 1,756
3
votes
0
answers
66
views
Why isn't there any captcha asked when running a new query in SEDE?
When I tried to create a new query on https://data.stackexchange.com/stackoverflow/query/new, I didn't see any hint for me to work on CAPTCHA, so I just clicked Run Query, and the next page was https:/...
- 1,756
1
vote
0
answers
67
views
Login options in SEDE do not work
Clicking the login options such as Yahoo in https://data.stackexchange.com/account/login?returnurl=/account/login?returnurl=/account/login?returnurl=/stackoverflow/queries doesn't work. Hovering ...
- 1,756
4
votes
1
answer
65
views
What is the difference between DisplayName and Id on the Stack Exchange Data Explorer Users table?
I am trying to pull a list of all users who have commented on an answer and tie it back to their User profile, if one exists. However, not all Comments table records have a UserId associated with them ...
6
votes
1
answer
101
views
SEDE does something weird with URL parameters
Can somebody explain what happens in this SEDE query? It's a very simple one, apart from the use of a parameter:
PRINT ('%href="##url##"%')
but somehow SEDE decides to append part of its ...
GlorfindelMod
- 256k
6
votes
0
answers
109
views
What's the Data Explorer query to get the latest data that Stack Overflow Trends shows?
Stack Overflow Trends shows the percentage of questions with a certain tag. Here's an example for Java IDEs. On Jan 7, 2023, this link produces this graph:
So VS Code is at 0.8%, and IntelliJ is ...
- 161
7
votes
1
answer
104
views
How can I find unaccepted answers using the SEDE?
While researching my question, "Are there any questions for which multiple answers have received enlightened badges?", I've created a query that searches for questions with multiple accepted ...
- 4,798
1
vote
1
answer
93
views
SEDE query to find progress on Four Ayes hat?
I've been working on a query to count the number of days a user's posts have had votes up, with no votes down on any day. But it seems like it's missing some posts. Users that have Four Ayes, do not ...
- 1,276
6
votes
1
answer
94
views
Finding closed questions from new contributors that others believe may be now reopenable
This query is fast, showing about 150 results right now:
WITH Closed_New_Contributors (PID, UID, Created)
AS
(
SELECT
p.id AS PID,
u.id AS UID,
u.CreationDate as Created
FROM Posts p
INNER ...
- 1,276
9
votes
1
answer
167
views
Is there a way (e.g. with SEDE) to find questions with an existing tag that's been synonymized (but not merged) into another tag?
Say Tag 1 has been added as a synonym of Tag 2, so that new questions attempting to use Tag 1 will be automatically pointed to Tag 2. However, the two tags haven't been merged (yet). Then, if you ...
- 7,785
2
votes
1
answer
91
views
Can someone make a query of number of questions, answers and average upvotes on answers on Earth Science Stack Exchange since its beginning?
Earth Science Stack Exchange is no longer a beta site, but this stats show it is not a healthy site.
My perception is there are a lot of inactive users that started to publish content in the ...
user1242306