Get annual summarized pill totals by county

Get annual summarized pill totals by county

summarized_county_annual(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_monthly(), 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_annual(county = "Mingo", state="WV", key="WaPo")

head(mingo_wv)
#>   BUYER_COUNTY BUYER_STATE year count DOSAGE_UNIT countyfips
#> 1        MINGO          WV 2006  4192     4691980      54059
#> 2        MINGO          WV 2007  5389     7511830      54059
#> 3        MINGO          WV 2008  7496     9795100      54059
#> 4        MINGO          WV 2009  7227     7464630      54059
#> 5        MINGO          WV 2010  4466     3162950      54059
#> 6        MINGO          WV 2011  4243     2863950      54059
# }