Get total pills for each distributor in a county

Get total pills for each distributor in a county

total_distributors_county(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(), summarized_county_monthly(), total_distributors_state(), total_manufacturers_county(), total_manufacturers_state(), total_pharmacies_county(), total_pharmacies_state()

Examples

# \donttest{
library(arcos)

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

head(mingo_wv)
#>   BUYER_STATE buyer_county             Reporter_family total_dosage_unit
#> 1          WV        MINGO      AmerisourceBergen Drug           3701200
#> 2          WV        MINGO                   Anda, Inc             82400
#> 3          WV        MINGO   Associated Pharmacies Inc              1500
#> 4          WV        MINGO       Auburn Pharmaceutical             17700
#> 5          WV        MINGO Butler Animal Health Supply               700
#> 6          WV        MINGO             Cardinal Health           3979150
#>   total_records
#> 1          4292
#> 2            89
#> 3             1
#> 4            10
#> 5             4
#> 6          5915
# }