SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Don't eat yellow snow spaceman's Avatar
    Join Date
    Mar 2001
    Location
    Melbourne, Australia
    Posts
    1,039
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi all,

    I have a table in a MySQL database with all the names of all the countries in the world together with their country codes (A3).

    But now I want to take it to the next level. I'm looking to source some data that will, depending on the chosen country, give a definitive list of every single state (or province/country/region) in that country. In a perfect world, the list I'm looking for would have three fields:
    CountryCode - essential (preferably ISO standard A3 code)
    StateCode - not essential, but desirable
    StateName - essential

    Big ask!

    Does anyone know where/if a spreadsheet of this sort of data is freely available? Given that there are over 200 countries on my list, and that each country would probably have anywhere between 2 and 50+ 'sub-divisions', I reckon the list would be something in the region of 10,000 records long (give or take 5000).

    I'm crossing my fingers...

  2. #2
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Interesting resource to have.
    I don't know but an encyclopedia might be of help but the problem is that the data isn't at one place (you have to look in different countries...) never mind, it's tedious
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •