title: database design for states info
body: <p>If I'm making a database to store all the states, counties and cities along with info for each such as state website url, governor, etc. Is the best way to set up the counties functionality like:</p>
  
  <pre><code>'Counties' Table (One)
  with two fields -&gt; 'state' and 'county'
  Texas      Anderson
  Texas      Bell
  Texas      Dalhart
  New York   Albany
  New York   Allegany
  </code></pre>
  
  <p>with each row having a unique ID?</p>
  
  <p>Or make a counties table for each state? Or make one counties table with each state being a different field?</p>
  
  <p>The more I explain the more I'm almost certain it's the first way, but I've never done this before so I wanted to check. </p>