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

How can I use Google to identify Stack Overflow users in a city with a reputation higher than X?

I can get a list of Stack Overflow users in a city by doing a simple Google query such as the following:

site:stackoverflow.com/users Singapore

Any ideas on how to enhance this query to rank by reputation or filter out all ratings below a certain amount?

share|improve this question

migrated from stackoverflow.com Sep 12 '09 at 6:20

This question came from our site for professional and enthusiast programmers.

    
Belongs On Meta –  user132149 Sep 12 '09 at 6:05
    
This should be in Meta Stackoverflow. –  Mk12 Sep 12 '09 at 6:06

1 Answer 1

Try querying the data dump:

SELECT Id, DisplayName, WebsiteURL, Reputation
FROM users 
WHERE Location LIKE '%Singapore%' 
      AND Reputation > '500'
ORDER BY Reputation DESC
LIMIT 200

In this example, you're looking for those over 500 rep.

share|improve this answer
    
What happened to this? I would like to find a great home improvement person in my area by querying diy.stackexchange.com but I can't. –  Carson Aug 28 '12 at 21:46

You must log in to answer this question.