title: How to get US county name from Address, city and state in R?
body: <p>I have a dataset of around 10000 rows. I have the Address, City, State and Zipcode values. I do not have lat/long coordinates. I would like to retrieve the county name without taking a large amount of time. I have tried library(tinygeocoder) but it takes around 14 seconds for 100 values, and is giving a 'time-out' error when I put in the entire dataset. Plus, it's outputting a fip code, which I have to join to get the actual county name. Reproducible example:</p>
  <pre><code>library(tidygeocoder)
  library(dplyr)
  
  df &lt;-   tidygeocoder::louisville[,1:4]
  county_fips &lt;- data.frame (fips = c(&quot;111&quot;, &quot;112&quot;),
                             county = c(&quot;Jefferson&quot;, &quot;Montgomery&quot;))
  
  geocoded &lt;- df %&gt;% geocode(street = street, city = city, state = state,
                             method = 'census', full_results = TRUE,
                             api_options = list(census_return_type = 'geographies'))
  
  df$fips &lt;- geocoded$county_fips
  df_new &lt;- merge(x=df, y=county_fips, by=&quot;fips&quot;, all.x = T)
  
  </code></pre>