Get county GEOID for each pharmacy based on BUYER_DEA_NO (Only includes retail and chain pharmacy designations)

Get county GEOID for each pharmacy based on BUYER_DEA_NO (Only includes retail and chain pharmacy designations)

pharm_counties(county = "Mingo", state = "WV", key = "WaPo")

Arguments

county

Filter the data to only this county (e.g. 'Mingo')

state

Filter the data to county within this state (e.g. 'WV')

key

Key needed to make query successful

See also

https://www.washingtonpost.com/graphics/2019/investigations/dea-pain-pill-database/#download-resources

Other geocoded data: buyer_addresses(), county_population(), not_pharmacies(), pharm_cbsa(), pharm_latlon(), pharm_tracts(), reporter_addresses(), state_population()

Examples

# \donttest{
library(arcos)

mingo_wv <- pharm_counties(county = "Mingo", state="WV", key="WaPo")

head(mingo_wv)
#>   BUYER_DEA_NO BUYER_COUNTY BUYER_STATE STATEFP COUNTYFP county_fips
#> 1    BM2933263        MINGO          WV      54      059       54059
#> 2    AM2373051        MINGO          WV      54      059       54059
#> 3    BM2373051        MINGO          WV      54      059       54059
#> 4    FM2252372        MINGO          WV      54      099       54099
#> 5    FS1092787        MINGO          WV      54      099       54099
#> 6    BH6954401        MINGO          WV      54      059       54059
# }