If you are looking for the country state list (list of Countries and it's corresponding States) , here it is.  You can download the XML file here which contains the Countries and it's States. I used this to fill  my Country and State tables for the OSS project i am working on. It has got 252 countries and 4306 states. Unfortunately there is no state code !

If you are working with c#, You can use the below code  to read the contry name and state name from the XML  for inserting to your database. I am using LINQtoXML to query the XML.  XElement class belongs to System.Xml.Linq namspace. So you need to include thae using statement to refer that in  your class.

 

Big Thanks to Michael John for sharing the XML file  in  http://www.darwinshome.za.net/blog/2008/02/country-selection-list-with-sate-and-province/