What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 130 Stack Exchange communities.

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

2 Answers 2

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 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 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 at 23:04
    
    
@Manishearth Updated that: data.stackexchange.com/stackoverflow/query/168161/… –  Mark Hurd Feb 16 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 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 .