Get monthly summarized pill totals by county

Get monthly summarized pill totals by county

summarized_county_monthly(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 summarized: buyer_details(), combined_buyer_annual(), combined_buyer_monthly(), summarized_county_annual(), total_distributors_county(), total_distributors_state(), total_manufacturers_county(), total_manufacturers_state(), total_pharmacies_county(), total_pharmacies_state()

Examples

# \donttest{
library(arcos)

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

head(mingo_wv)
#>   BUYER_COUNTY BUYER_STATE year month count DOSAGE_UNIT countyfips
#> 1        MINGO          WV 2006    01   353      333520      54059
#> 2        MINGO          WV 2006    02   335      321270      54059
#> 3        MINGO          WV 2006    03   412      418880      54059
#> 4        MINGO          WV 2006    04   358      376900      54059
#> 5        MINGO          WV 2006    05   338      399040      54059
#> 6        MINGO          WV 2006    06   366      389460      54059
# }