title: Where can I get a list of Countries, States and Cities?
body: <p>This probably seems like a duplicate, since there are identical questions out there.</p>
  
  <p>Unfortunately all of the answers to all of these questions are missing one detail: <strong>the states</strong>.</p>
  
  <p>Where can I get a list of countries, <strong>states</strong> and cities?</p>
  
  <p>For example, I want this:</p>
  
  <pre><code>| Sydney  |  New South Wales  |  Australia  |
  </code></pre>
  
  <p>or</p>
  
  <pre><code>|  Miami  |  Florida          |  United States  |
  </code></pre>
  
  <p>I <strong>don't</strong> want something like this, which excludes the state:</p>
  
  <pre><code>|  Miami  |  United States  |
  </code></pre>
  
  <p>Is there any place where I can get this kind of data?</p>
  
  <p>I've already tried the following data sources:</p>
  
  <ul>
  <li><a href="http://www.maxmind.com/app/csv" rel="noreferrer">http://www.maxmind.com/app/csv</a></li>
  <li><a href="http://www.geodatasource.com/world-cities-database/free" rel="noreferrer">http://www.geodatasource.com/world-cities-database/free</a></li>
  <li><a href="http://developer.yahoo.com/geo/geoplanet/data/" rel="noreferrer">http://developer.yahoo.com/geo/geoplanet/data/</a></li>
  </ul>
  
  <p>But all of them exclude the <strong>states</strong>.</p>