Data from from non-contiguous states not yet processed and available.

drug_fips_biz(
  drug = "Fentanyl",
  fips = "01001",
  buyer_bus_act = "CHAIN PHARMACY",
  key = "WaPo"
)

Arguments

drug

Filter the data to one of 14 available drugs in the database (e.g. 'OXYCODONE')

fips

Filter the data to only this county (e.g. ‘01001’ for Autauga, Alabama)

buyer_bus_act

If provided, filter the data to one of businesses in BUYER_BUS_ACT (e.g. 'CHAIN PHARMACY', 'HOSP/CLINIC')

key

Key needed to make query successful

Examples

# \donttest{
library(arcos)

autauga_al <- drug_fips_biz(drug="Fentanyl", fips="01001", buyer_bus_act="CHAIN PHARMACY", key="WaPo")

head(autauga_al)
#>   REPORTER_DEA_NO REPORTER_BUS_ACT               REPORTER_NAME
#> 1       PR0040357      DISTRIBUTOR        MCKESSON CORPORATION
#> 2       PR0040357      DISTRIBUTOR        MCKESSON CORPORATION
#> 3       PR0040357      DISTRIBUTOR        MCKESSON CORPORATION
#> 4       PR0040357      DISTRIBUTOR        MCKESSON CORPORATION
#> 5       PR0040357      DISTRIBUTOR        MCKESSON CORPORATION
#> 6       RA0223432      DISTRIBUTOR AMERISOURCEBERGEN DRUG CORP
#>        REPORTER_ADDRESS1 REPORTER_ADDRESS2 REPORTER_CITY REPORTER_STATE
#> 1   DBA MCKESSON DRUG CO 2975 EVERGREEN DR        DULUTH             GA
#> 2   DBA MCKESSON DRUG CO 2975 EVERGREEN DR        DULUTH             GA
#> 3   DBA MCKESSON DRUG CO 2975 EVERGREEN DR        DULUTH             GA
#> 4   DBA MCKESSON DRUG CO 2975 EVERGREEN DR        DULUTH             GA
#> 5   DBA MCKESSON DRUG CO 2975 EVERGREEN DR        DULUTH             GA
#> 6 172 CAHABA VALLEY PKWY              <NA>        PELHAM             AL
#>   REPORTER_ZIP REPORTER_COUNTY BUYER_DEA_NO   BUYER_BUS_ACT
#> 1        30096        GWINNETT    BK2452566  CHAIN PHARMACY
#> 2        30096        GWINNETT    BK2452566  CHAIN PHARMACY
#> 3        30096        GWINNETT    BU4203751 RETAIL PHARMACY
#> 4        30096        GWINNETT    BU4203751 RETAIL PHARMACY
#> 5        30096        GWINNETT    BU4203751 RETAIL PHARMACY
#> 6        35124          SHELBY    BA6459576 RETAIL PHARMACY
#>                  BUYER_NAME BUYER_ADDL_CO_INFO           BUYER_ADDRESS1
#> 1 K & B ALABAMA CORPORATION     RITE AID #7172 606 SOUTH MEMORIAL DRIVE
#> 2 K & B ALABAMA CORPORATION     RITE AID #7172 606 SOUTH MEMORIAL DRIVE
#> 3    OMNICARE OF PRATTVILLE               <NA>         842 PEACHTREE ST
#> 4    OMNICARE OF PRATTVILLE               <NA>         842 PEACHTREE ST
#> 5    OMNICARE OF PRATTVILLE               <NA>         842 PEACHTREE ST
#> 6    ADAMS DRUGS-PRATTVILLE               <NA> 103 SOUTH MEMORIAL DRIVE
#>   BUYER_CITY BUYER_STATE BUYER_ZIP BUYER_COUNTY TRANSACTION_CODE DRUG_CODE
#> 1 PRATTVILLE          AL     36067      AUTAUGA                S      9801
#> 2 PRATTVILLE          AL     36067      AUTAUGA                S      9801
#> 3 PRATTVILLE          AL     36066      AUTAUGA                S      9801
#> 4 PRATTVILLE          AL     36066      AUTAUGA                S      9801
#> 5 PRATTVILLE          AL     36066      AUTAUGA                S      9801
#> 6 PRATTVILLE          AL     36066      AUTAUGA                S      9801
#>        NDC_NO DRUG_NAME QUANTITY ORDER_FORM_NO TRANSACTION_DATE
#> 1 00378912298  FENTANYL        3     061743386         05222006
#> 2 00378912198  FENTANYL        5     061743389         06282006
#> 3 50458003305  FENTANYL        2     07X000038         03192007
#> 4 00781710955  FENTANYL       10     07X000048         04132007
#> 5 00591319872  FENTANYL       72     08X000019         03052008
#> 6 00781711255  FENTANYL        3     056729958         02162006
#>   CALC_BASE_WT_IN_GM DOSAGE_UNIT TRANSACTION_ID
#> 1             0.0765          15      605007466
#> 2             0.0638          25      606006979
#> 3             0.0250          10      703041217
#> 4             0.0625          50      704031016
#> 5             0.9000         360      803041754
#> 6             0.0750          15          15143
#>                           Product_Name Ingredient_Name Measure
#> 1 FENTANYL 72HR 50MCG/HR TDS (5.10MG T   FENTANYL BASE   PO/PA
#> 2 FENTANYL 72HR 25MCG/HR TDS (2.55MG T   FENTANYL BASE   PO/PA
#> 3         DURAGESIC 2.5MG FENTANYL TDS   FENTANYL BASE   PO/PA
#> 4 FENTANYL TRANSDERMAL SYSTEM 1.25MG F   FENTANYL BASE   PO/PA
#> 5 FENTANYL 25MCG/HR TRANSDERMAL SYSTEM   FENTANYL BASE   PO/PA
#> 6 FENTANYL TRANSDERMAL SYSTEM 5MG POUC   FENTANYL BASE   PO/PA
#>   MME_Conversion_Factor         Combined_Labeler_Name        Reporter_family
#> 1                   100   Mylan Pharmaceuticals, Inc.   McKesson Corporation
#> 2                   100   Mylan Pharmaceuticals, Inc.   McKesson Corporation
#> 3                   100 Janssen Pharmaceuticals, Inc.   McKesson Corporation
#> 4                   100                    Sandoz Inc   McKesson Corporation
#> 5                   100          Actavis Pharma, Inc.   McKesson Corporation
#> 6                   100                    Sandoz Inc AmerisourceBergen Drug
#>     MME year REPORTER_ADDL_CO_INFO BUYER_ADDRESS2 STRENGTH ACTION_INDICATOR
#> 1  7650 2006                  <NA>           <NA>     <NA>             <NA>
#> 2  6375 2006                  <NA>           <NA>     <NA>             <NA>
#> 3  2500 2007                  <NA>           <NA>     <NA>             <NA>
#> 4  6250 2007                  <NA>           <NA>     <NA>             <NA>
#> 5 90000 2008                  <NA>           <NA>     <NA>             <NA>
#> 6  7500 2006                  <NA>           <NA>     <NA>             <NA>
#>   CORRECTION_NO dos_str
#> 1          <NA>      NA
#> 2          <NA>      NA
#> 3          <NA>      NA
#> 4          <NA>      NA
#> 5          <NA>      NA
#> 6          <NA>      NA
# }