I made a few DE queries for this question

Anyways, I was testing the queries, and I noticed that it doesn't catch me in these queries:

  1. https://data.stackexchange.com/physics/query/65968/top-users-mumbai

  2. https://data.stackexchange.com/physics/query/65970/top-users-india

Even though it is ORDER BY Reputation DESC, and (not to boast), I have more rep on Physics.SE than any of them-- I should be displayed in the results.

It may be an issue with my SQL, I've never really formally learned SQL and I'm used to testing out queries on a command line.

Or, it may be a caching issue--I entered my location a week back. (a week seems a bit long for a cache, though--or do you use dumps?)

  • 4
    DE uses dumps as far as I recall, and is normally quite behind the actual data. Query the users table for you and check if the field is populated. Apr 5, 2012 at 11:52

1 Answer 1


SEDE data are updated roughly every three months. On the front page the date of the last update is shown at the far right, for each site, they are usually updated on the same day or a day apart.

For Physics the most recent update was on March 15, so SEDE doesn't know your location (yet).

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