R/raw.R
pharmacy_raw.RdData from from non-contiguous states not yet processed and available. This raw data only includes data from pharmacies and practitioners and the drugs Hydrocodne and Oxycodone.
pharmacy_raw(buyer_dea_no = "AB0454176", key = "WaPo")Filter the data to only this pharmacy (e.g. ‘AB0454176’)
Key needed to make query successful
# \donttest{
library(arcos)
solo_pharm <- pharmacy_raw(buyer_dea_no="AB0454176", key="WaPo")
head(solo_pharm)
#> REPORTER_DEA_NO REPORTER_BUS_ACT REPORTER_NAME
#> 1 RD0320933 DISTRIBUTOR D& K HEALTHCARE RESOURCES,
#> 2 RD0320933 DISTRIBUTOR D& K HEALTHCARE RESOURCES,
#> 3 RA0223432 DISTRIBUTOR AMERISOURCEBERGEN DRUG CORP
#> 4 RA0223432 DISTRIBUTOR AMERISOURCEBERGEN DRUG CORP
#> 5 RA0223432 DISTRIBUTOR AMERISOURCEBERGEN DRUG CORP
#> 6 RA0223432 DISTRIBUTOR AMERISOURCEBERGEN DRUG CORP
#> REPORTER_ADDL_CO_INFO REPORTER_ADDRESS1 REPORTER_ADDRESS2
#> 1 null 6775 JEFFERSON METROPOLITAN PKWY null
#> 2 null 6775 JEFFERSON METROPOLITAN PKWY null
#> 3 null 172 CAHABA VALLEY PKWY null
#> 4 null 172 CAHABA VALLEY PKWY null
#> 5 null 172 CAHABA VALLEY PKWY null
#> 6 null 172 CAHABA VALLEY PKWY null
#> REPORTER_CITY REPORTER_STATE REPORTER_ZIP REPORTER_COUNTY BUYER_DEA_NO
#> 1 MCCALLA AL 35111 JEFFERSON AB0454176
#> 2 MCCALLA AL 35111 JEFFERSON AB0454176
#> 3 PELHAM AL 35124 SHELBY AB0454176
#> 4 PELHAM AL 35124 SHELBY AB0454176
#> 5 PELHAM AL 35124 SHELBY AB0454176
#> 6 PELHAM AL 35124 SHELBY AB0454176
#> BUYER_BUS_ACT BUYER_NAME BUYER_ADDL_CO_INFO
#> 1 RETAIL PHARMACY BLOUNTSVILLE PHARMACY YEAGER JAMES F OWNERCOR HW
#> 2 RETAIL PHARMACY BLOUNTSVILLE PHARMACY YEAGER JAMES F OWNERCOR HW
#> 3 RETAIL PHARMACY BLOUNTSVILLE PHARMACY YEAGER JAMES F OWNERCOR HW
#> 4 RETAIL PHARMACY BLOUNTSVILLE PHARMACY YEAGER JAMES F OWNERCOR HW
#> 5 RETAIL PHARMACY BLOUNTSVILLE PHARMACY YEAGER JAMES F OWNERCOR HW
#> 6 RETAIL PHARMACY BLOUNTSVILLE PHARMACY YEAGER JAMES F OWNERCOR HW
#> BUYER_ADDRESS1 BUYER_ADDRESS2 BUYER_CITY BUYER_STATE BUYER_ZIP BUYER_COUNTY
#> 1 P.O. BOX 250 69005 MAIN ST BLOUNTSVILLE AL 35031 BLOUNT
#> 2 P.O. BOX 250 69005 MAIN ST BLOUNTSVILLE AL 35031 BLOUNT
#> 3 P.O. BOX 250 69005 MAIN ST BLOUNTSVILLE AL 35031 BLOUNT
#> 4 P.O. BOX 250 69005 MAIN ST BLOUNTSVILLE AL 35031 BLOUNT
#> 5 P.O. BOX 250 69005 MAIN ST BLOUNTSVILLE AL 35031 BLOUNT
#> 6 P.O. BOX 250 69005 MAIN ST BLOUNTSVILLE AL 35031 BLOUNT
#> TRANSACTION_CODE DRUG_CODE NDC_NO DRUG_NAME QUANTITY UNIT
#> 1 S 9193 00603388832 HYDROCODONE 1 null
#> 2 S 9193 00603388921 HYDROCODONE 1 null
#> 3 S 9193 50474090701 HYDROCODONE 2 null
#> 4 S 9193 00591054005 HYDROCODONE 2 null
#> 5 S 9193 00591085305 HYDROCODONE 1 null
#> 6 S 9193 00591054005 HYDROCODONE 2 null
#> ACTION_INDICATOR ORDER_FORM_NO CORRECTION_NO STRENGTH TRANSACTION_DATE
#> 1 null null null 0000 01052006
#> 2 null null null 0000 02222006
#> 3 null null null null 08022006
#> 4 null null null null 08252006
#> 5 null null null null 08302007
#> 6 null null null null 08082007
#> CALC_BASE_WT_IN_GM DOSAGE_UNIT TRANSACTION_ID
#> 1 6.0540 1000 601002710
#> 2 0.4540 100 602015099
#> 3 0.9081 200 21678
#> 4 6.0540 1000 9007
#> 5 3.0270 500 10795
#> 6 6.0540 1000 9555
#> Product_Name Ingredient_Name
#> 1 HYDROCODONE.BIT & ACETA 10MG & 500M HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 2 HYDROCODONE.BIT 7.5MG/ACETAMINAOPHEN HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 3 LORTAB 7.5MG HYDROCODONE.BIT / 500MG HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 4 HYDROCODONE BIT. 10MG/ACETAMINOPHEN HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 5 HYDROCODONE BIT. 10MG/ACETAMINOPHEN HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 6 HYDROCODONE BIT. 10MG/ACETAMINOPHEN HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> Measure MME_Conversion_Factor Combined_Labeler_Name
#> 1 TAB 1 Par Pharmaceutical
#> 2 TAB 1 Par Pharmaceutical
#> 3 TAB 1 UCB, Inc.
#> 4 TAB 1 Actavis Pharma, Inc.
#> 5 TAB 1 Actavis Pharma, Inc.
#> 6 TAB 1 Actavis Pharma, Inc.
#> Revised_Company_Name Reporter_family dos_str
#> 1 Endo Pharmaceuticals, Inc. D & K Healthcare Resources 10.0
#> 2 Endo Pharmaceuticals, Inc. D & K Healthcare Resources 7.5
#> 3 UCB, Inc. AmerisourceBergen Drug 7.5
#> 4 Allergan, Inc. AmerisourceBergen Drug 10.0
#> 5 Allergan, Inc. AmerisourceBergen Drug 10.0
#> 6 Allergan, Inc. AmerisourceBergen Drug 10.0
# }