Linked Questions

4
votes
1answer
110 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 ...
1
vote
1answer
81 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....
1
vote
0answers
66 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 ...
2
votes
0answers
34 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 ...
3
votes
0answers
29 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, ...
158
votes
31answers
9k 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 ...
143
votes
2answers
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 ...
11
votes
3answers
223 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 ...
10
votes
1answer
791 views

Where did EmailHash go?

There are at least four ways to get to StackExchange data: OData (http://data.stackexchange.com/stackoverflow/atom/), Data Explorer (http://data.stackexchange.com/), XML data dumps (https://archive....
80
votes
0answers
567 views

Can we have *.stackexchange.com aliases for sites that have their own domain names?

I have a Chrome search engine of the form http://%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). ...
11
votes
1answer
284 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....
11
votes
1answer
133 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 ...
14
votes
0answers
146 views

Directly support cross-site queries in the Data Explorer

Often you want to query some statistic for a user across all sites. For example, you might write a query to find your rejected suggested edits across all Stack Exchange sites. To implement this, you ...
1
vote
1answer
97 views

How can I find all the StackExchange websites that I'm part of? - Queries on Data Explorer

How can I find all the StackExchange websites that I'm part of as well as I'm not part of using the Data Explorer..? In addition, if it's possible, I would like to use this query to do additional data ...
-2
votes
2answers
125 views

Data Explorer queries most likely to find dormant users that if engaged are likely to become active users

Currently my thought is the profile of such a user would be that they: have not visited the site in a month and posted a answer/comment/question have an answer/comment/question on the site have been ...

15 30 50 per page