Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Is it common or is it rare? I don't necessarily need a "best answer" - any answer should help (as I tend to be someone who distributes my activity across multiple networks as well)

share|improve this question

The "association id" or AccountId is now available, so I produced the requested query here.

Note that I explicitly skip all Metas except this one, so that the query results should be the same as the number of sites with more than 200 rep that you see in a user's accounts tab.

share|improve this answer
Thanks, nicely done. No area51? – EnergyNumbers Feb 16 '14 at 18:35
IIRC there's a way of doing this that does scale (instead of having to mention each site individually) – Manishearth Feb 16 '14 at 18:38
@Manishearth Because they're separate databases you need to do something that refers to them individually, but you may be able to automate the generation and then use a dynamic query. – Mark Hurd Feb 16 '14 at 23:04
@Manishearth Updated that:… – Mark Hurd Feb 16 '14 at 23:27
@EnergyNumbers I include all data included in the SEDE (except Metas for this query). See Any plans for a Data Explorer for Area 51?. – Mark Hurd Feb 16 '14 at 23:32

While it is possible to do cross-site queries using the Data Explorer, I don't believe it is currently possible to use the Data Explorer to get the association id that links users across sites, so for now this would have to be done locally using a data dump, rather than online.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .