stackexchangeuser-activity

How many accounts does a user have?-StackExchange


I am trying to make a query on stackexchange that would tell me for every user, on which stack community he is present and possibly its reputation on that specific community. It seems there is no indicator in the Sql for this purpose.

Anyone has a solution? Much appreciated! Best from Italy


Solution

  • I do not have a query for every user specifically, by there are a couple existing queries in the Data Explorer than can be used to count the number of accounts that exist across the network:

    The results of the second query show the number of accounts that exist on multiple sites.

    While it doesn't show the number of accounts for each individual user, it does provide the scope of shared accounts across the network. Querying for each user is probably prohibitively expensive in terms of resources.