Get total pills for each manufacturer in a county

Get total pills for each manufacturer in a county

total_manufacturers_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_county(), total_distributors_state(), total_manufacturers_state(), total_pharmacies_county(), total_pharmacies_state()

Examples

# \donttest{
library(arcos)

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

head(mingo_wv)
#>   buyer_state buyer_county      combined_labeler_name total_dosage_unit
#> 1          WV        MINGO                 AAI Pharma             11100
#> 2          WV        MINGO                AbbVie Inc.             95100
#> 3          WV        MINGO       Actavis Pharma, Inc.          31142920
#> 4          WV        MINGO             Allergan, Inc.               200
#> 5          WV        MINGO              Alvogen, Inc.             42100
#> 6          WV        MINGO Amneal Pharmaceuticals LLC            213600
#>   total_records
#> 1            31
#> 2           399
#> 3         23127
#> 4             2
#> 5           147
#> 6           794
# }