Get total pills for each pharmacy in a state

Get total pills for each pharmacy in a state

total_pharmacies_state(state = "WV", key = "WaPo")

Arguments

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

Examples

# \donttest{
library(arcos)

wv <- total_pharmacies_state(state="WV", key="WaPo")

head(wv)
#>   buyer_state buyer_county buyer_dea_no                    buyer_name
#> 1          WV        MINGO    BS7437064                    STROSNIDER
#> 2          WV        LOGAN    BF0660565  FAMILY DISCOUNT PHARMACY INC
#> 3          WV        MINGO    BH6954401       HURLEY DRUG COMPANY INC
#> 4          WV        MINGO    FT0251227      TUG VALLEY PHARMACY, LLC
#> 5          WV   GREENBRIER    BM8273524 FRITZ'S PHARMACY AND WELLNESS
#> 6          WV        MASON    AF6754748            FRUTH PHARMACY INC
#>       buyer_city total_dosage_unit total_records
#> 1         KERMIT          13168350          7691
#> 2      MOUNT GAY          12849040          5680
#> 3     WILLIAMSON           8890370         11138
#> 4     WILLIAMSON           8827860          5390
#> 5     RONCEVERTE           7528100         13997
#> 6 POINT PLEASANT           7317220          9193
# }