Get monthly summarized pill totals by county

Get monthly summarized pill totals by county

buyer_details(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: 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(), total_pharmacies_state()

Examples

# \donttest{
library(arcos)

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

head(mingo_wv)
#>   BUYER_DEA_NO   BUYER_BUS_ACT                   BUYER_NAME
#> 1    BH6954401 RETAIL PHARMACY      HURLEY DRUG COMPANY INC
#> 2    BS7437064 RETAIL PHARMACY                   STROSNIDER
#> 3    FS1092787 RETAIL PHARMACY         SAV-RITE PHARMACY #2
#> 4    FT0251227 RETAIL PHARMACY     TUG VALLEY PHARMACY, LLC
#> 5    BM2933263 RETAIL PHARMACY MATEWAN FAMILY PHARMACY, INC
#> 6    FR0261684 RETAIL PHARMACY           RIVERSIDE PHARMACY
#>            BUYER_ADDRESS1 BUYER_CITY BUYER_STATE BUYER_ZIP BUYER_COUNTY
#> 1        210 LOGAN STREET WILLIAMSON          WV     25661        MINGO
#> 2              PO BOX 600     KERMIT          WV     25674        MINGO
#> 3 ROUTE 52 STONECOAL ROAD     KERMIT          WV     25674        MINGO
#> 4              PO BOX 538 WILLIAMSON          WV     25661        MINGO
#> 5        RT. 49, MAIN ST.    MATEWAN          WV     25678        MINGO
#> 6 22 LARRY JOE HARLESS DR    GILBERT          WV     25621        MINGO
#>       BUYER_ADDL_CO_INFO    BUYER_ADDRESS2
#> 1                   <NA>              <NA>
#> 2 DBA: SAV-RITE PHARMACY 50 LINCOLN STREET
#> 3        STROSNIDER DRUG      P.O. BOX 660
#> 4                   <NA>      54 W 2ND AVE
#> 5                   <NA>              <NA>
#> 6                   <NA>              <NA>
# }