Linked Questions
22 questions linked to/from Allow cross-site queries in data explorer
6
votes
1
answer
179
views
With SEDE, is there a way to run a query across all sites in the network? [duplicate]
My apologies if this question is off-topic here, but it is a discussion about how to use a network-wide tool specific to SE.
The question in its entirety is in the title, really. How can I use the ...
- 467
1
vote
1
answer
89
views
Data stack exchange: query from all sites [duplicate]
While creating a query on Stack Exchange Explorer, how do you write a query to include all Stack Exchange sites?
select P.ID as [Post Link],
p.Score,
P.Title,
P....
- 297
2
votes
0
answers
102
views
Is it possible to query multiple sites in one data SE query? [duplicate]
I was curious about finding users that have higher reputation on SE sites other than stackoverflow.
I'm kind of fuzzy on what I want to do, but my hypothesis is that ... people who are involved in SE ...
- 121
2
votes
0
answers
37
views
Cross-site SEDE Queries [duplicate]
In the view of the recent Worldbuilding election, I wanted to check the profile of the voters (based on Constituent badges awarded). And one idea was to look at the reputation of the users.
However ...
- 252
3
votes
0
answers
37
views
Writing a query for multiple communities at once [duplicate]
Is is possible in SEDE to write a query targeting many communities simultaneously?
I've seen this related question but it doesn't help me. e.g. I would like to see how many questions were asked in X, ...
- 3,805
165
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 ...
81
votes
5
answers
2k
views
Dump of my own Stack Exchange content
Is there a way to quickly save all my Stack Exchange content across all Stack Exchange sites, as hundreds of HTML pages? (for me probably 15 or 20 sites: SO, dsp.SE, unix.SE, etc.)?
The ideal way ...
- 1,690
146
votes
2
answers
3k
views
Map of all Stack Exchange sites (except the three biggest)
I've just made a map of all Stack Exchange sites, except for the three biggest ones:
(A high(er) res png file) (EDIT: there was a PDF file, but for some reason it was eating more than 1 GB of memory, ...
- 2,770
36
votes
2
answers
3k
views
Did Stack Exchange's traffic go down since ChatGPT?
I was wondering whether the traffic of Stack Exchange sites went down since the open access to ChatGPT. There is so much gossip in terms of "Will programmers be unnecessary with ChatGPT? Will ...
- 639
11
votes
3
answers
231
views
Which users have the most accounts with over 200 reputation across the SE networks?
Which users have the most accounts with over 200 reputation across the Stack Exchange networks?
Is it common or is it rare? I don't necessarily need a "best answer" - any answer should help (as I tend ...
- 1,691
10
votes
1
answer
996
views
Where did EmailHash go?
There are at least four ways to get to StackExchange data: OData (https://data.stackexchange.com/stackoverflow/atom/), Data Explorer (https://data.stackexchange.com/), XML data dumps (https://archive....
- 193
11
votes
2
answers
362
views
How can I write a cross-site Data Explorer query that joins databases on linked accounts?
The answer to this question implies that you can write cross-site Data Explorer queries, but the sample query doesn't appear to do what I think it should.
SELECT TOP 1 *
FROM [StackOverflow....
- 14.8k
11
votes
1
answer
210
views
Cross-site queries on SEDE fail with "The EXECUTE permission was denied"
I just noticed that any cross-site queries using dynamically generated SQL on the Stack Exchange Data Explorer (SEDE) now fail with the error message:
The EXECUTE permission was denied on the ...
- 31.6k
6
votes
2
answers
150
views
Search only my posts across all sites
I wrote a post some years ago about a relatively complex bash script (with parameters) but I can't find it anymore, and I don't remember on which site of the SE hierarchy I wrote it. Is there a way to ...
- 241
107
votes
0
answers
1k
views
Can we have *.stackexchange.com aliases for sites that have their own domain names?
I have a Chrome search engine of the form https://%s.stackexchange.com/ that I use to quickly move between various SE sites (I find this more efficient than bumbling my way through the multicollider).
...
- 14k