Get annual total pills for each buyer (pharmacy, etc) in a county

Get annual total pills for each buyer (pharmacy, etc) in a county

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

head(mingo_wv)
#>   BUYER_DEA_NO   BUYER_BUS_ACT BUYER_COUNTY BUYER_STATE year DOSAGE_UNIT
#> 1    AA8151728 RETAIL PHARMACY        MINGO          WV 2006      279800
#> 2    AA8151728 RETAIL PHARMACY        MINGO          WV 2007      252400
#> 3    AA8151728 RETAIL PHARMACY        MINGO          WV 2008      219400
#> 4    AA8151728 RETAIL PHARMACY        MINGO          WV 2009      192000
#> 5    AA8151728 RETAIL PHARMACY        MINGO          WV 2010      181600
#> 6    AA8151728 RETAIL PHARMACY        MINGO          WV 2011      211800
# }