Questions tagged [data-explorer]
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.
1,574
questions
7
votes
1
answer
117
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 ...
- 26.8k
4
votes
1
answer
99
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)?
- 41.3k
7
votes
1
answer
144
views
What site should I post a question about an error given from a SEDE (Stack Exchange Data Explorer) query?
I am working on composing a SEDE (Stack Exchange Data Explorer) query to find questions from 3-4 months ago that do not have any accepted answers that I feel like I could answer (as in limiting it to ...
- 399
26
votes
3
answers
555
views
Strange new database 'Data.StackExchangePOC' is messing up cross-site SEDE queries
I just read a comment by user @questionto42 that one of my cross-site queries isn't working. My educated guess is this is because a special database Data.StackExchangePOC was created two days ago:
(...
GlorfindelMod
- 253k
12
votes
0
answers
138
views
The SE Data Explorer captcha is unnecessarily annoying
Whenever I try to run a query with the Data Explorer, my process is:
Type the parameters for the query.
Click "Run query".
Click the "I'm not a robot" checkbox that suddenly ...
- 726
16
votes
0
answers
289
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
...
- 26.8k
6
votes
1
answer
145
views
Periodically publish a data dump of all IDs in the image ID space (and make it available in SEDE)
I see that Imgur has an API to query for image IDs in its ID space, but api.stack.imgur.com is not an API endpoint (and SE is moving off Imgur anyway). Say I want to get all the IDs of images in Stack ...
- 26.8k
20
votes
2
answers
416
views
The Data Explorer (SEDE) Refresh choked on a Raspberry
As we all know the community eagerly awaits the weekly SEDE refresh with all our posted content so we can analyze, share-alike or train our large language models (LLMs).
The script that runs the ...
- 91.1k
0
votes
0
answers
144
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.6k
16
votes
1
answer
270
views
Magic columns and site:// do not work for alcohol.meta.stackexchange
The site Beer, Wine & Spirits has the URL https://alcohol.stackexchange.com but in SEDE it uses beer for the main site and beerme for meta.
As far as I can tell, the shortcut site:// and the magic ...
- 15.2k
3
votes
1
answer
143
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 ...
- 41.3k
1
vote
1
answer
143
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 ...
- 41
10
votes
0
answers
158
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-...
- 91.1k
1
vote
1
answer
77
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?
- 41
9
votes
0
answers
113
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 ...
- 537