I guess a lot of people search for this list and very less get successful finding the list. I also required world's all Country
The state or territory's USPS postal abbreviation. Statename: The name of the state or territory that contains the city/town. Countyfips: The 5-digit FIPS code for the primary county. The first two digits correspond to the state's FIPS code. Countyname: The name of the primary county (or equivalent) that contains the city/town.
and correspondingI looked through the list of files. There seems to be nothing there that simply lists countries and states. There are lists of cities, highly detailed lists of locations, lists of countries and country-specific lists which contain a grab-bag of location types including states and small localities (with nothing to indicate which items are states and which aren't; since some countries would call. Full list of US states and cities. Contribute to grammakov/USA-cities-and-states development by creating an account on GitHub.
City or states for binding the drop down from sql server one of my project. i searched a lot and finally found a very good list, with the approved codes etc. you can use Ajax or anything after importing it to your database in required format in you any of oracle, mysql, access, sql-server, postgresql.here's Updated link.
http://www.unece.org/cefact/codesfortrade/codes_index.html
Us State List Csv
above link is for download, below link is for details of various terminologies used.
Country Code List Csv
http://www.unece.org/cefact/locode/welcome.htmlon the page you will get list in various acceptable formats from
- txt
- CSV
- excel
- mdb.
Csv Email List
as there is no just download latest file which is on the top of the list and import it to your database.its very detailed and informative list even got longitude details, district, state, city. so you can drill down to very depth or very less according to your requirements
Country State City List Csv Download Optional
my best to share the information as far as possible.
Please like this article on Facebook and G+ to make people to find it easily.