title: Finding the Metropolitan Area or County for City, State
body: <p>I have following data in a dataframe:</p>
  
  <pre><code>... location           amount
  ... Jacksonville, FL   40
  ... Provo, UT          20
  ... Montgomery, AL     22
  ... Los Angeles, CA    34
  </code></pre>
  
  <p>My dataset only contains U.S. cities in the form of [city name, state code] and I have no ZIP codes.</p>
  
  <p>I want to determine either county of a city, in order to visualize my data with ggcounty (<a href="https://github.com/hrbrmstr/ggcounty" rel="nofollow noreferrer">like here</a>).</p>
  
  <p>I looked on the website of the <a href="https://www.census.gov/geo/reference/codes/place.html" rel="nofollow noreferrer">U.S. Census Bureau</a> but couldn't really find a table of city,state,county, or similar.</p>
  
  <p>Assuming that I would prefer solving the problem in R only, who has an idea how to solve this?</p>