R/raw.R
drug_fips_biz.RdData from from non-contiguous states not yet processed and available.
drug_fips_biz(
drug = "Fentanyl",
fips = "01001",
buyer_bus_act = "CHAIN PHARMACY",
key = "WaPo"
)Filter the data to one of 14 available drugs in the database (e.g. 'OXYCODONE')
Filter the data to only this county (e.g. ‘01001’ for Autauga, Alabama)
If provided, filter the data to one of businesses in BUYER_BUS_ACT (e.g. 'CHAIN PHARMACY', 'HOSP/CLINIC')
Key needed to make query successful
# \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
# }