R/raw.R
county_raw_fips.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.
county_raw_fips(fips = "01001", key = "WaPo")Filter the data to only this county (e.g. ‘01001’ for Autauga, Alabama)
Key needed to make query successful
# \donttest{
library(arcos)
autauga_al <- county_raw_fips(fips="01001", key="WaPo")
head(autauga_al)
#> REPORTER_DEA_NO REPORTER_BUS_ACT REPORTER_NAME
#> 1 PB0167127 DISTRIBUTOR BLOODWORTH WHOLESALE DRUGS
#> 2 PB0167127 DISTRIBUTOR BLOODWORTH WHOLESALE DRUGS
#> 3 PB0167127 DISTRIBUTOR BLOODWORTH WHOLESALE DRUGS
#> 4 PB0167127 DISTRIBUTOR BLOODWORTH WHOLESALE DRUGS
#> 5 PB0167127 DISTRIBUTOR BLOODWORTH WHOLESALE DRUGS
#> 6 PB0167127 DISTRIBUTOR BLOODWORTH WHOLESALE DRUGS
#> REPORTER_ADDL_CO_INFO REPORTER_ADDRESS1 REPORTER_ADDRESS2 REPORTER_CITY
#> 1 null 2128 YANK LAMB DRIVE P.O. BOX 1849 TIFTON
#> 2 null 2128 YANK LAMB DRIVE P.O. BOX 1849 TIFTON
#> 3 null 2128 YANK LAMB DRIVE P.O. BOX 1849 TIFTON
#> 4 null 2128 YANK LAMB DRIVE P.O. BOX 1849 TIFTON
#> 5 null 2128 YANK LAMB DRIVE P.O. BOX 1849 TIFTON
#> 6 null 2128 YANK LAMB DRIVE P.O. BOX 1849 TIFTON
#> REPORTER_STATE REPORTER_ZIP REPORTER_COUNTY BUYER_DEA_NO BUYER_BUS_ACT
#> 1 GA 31793 TIFT BT4725050 RETAIL PHARMACY
#> 2 GA 31793 TIFT BT4725050 RETAIL PHARMACY
#> 3 GA 31793 TIFT BT4725050 RETAIL PHARMACY
#> 4 GA 31793 TIFT BT4725050 RETAIL PHARMACY
#> 5 GA 31793 TIFT BT4725050 RETAIL PHARMACY
#> 6 GA 31793 TIFT BT4725050 RETAIL PHARMACY
#> BUYER_NAME BUYER_ADDL_CO_INFO BUYER_ADDRESS1 BUYER_ADDRESS2 BUYER_CITY
#> 1 JONES DRUGS 003 null 959 EAST MAIN ST SUITE A PRATTVILLE
#> 2 JONES DRUGS 003 null 959 EAST MAIN ST SUITE A PRATTVILLE
#> 3 JONES DRUGS 003 null 959 EAST MAIN ST SUITE A PRATTVILLE
#> 4 JONES DRUGS 003 null 959 EAST MAIN ST SUITE A PRATTVILLE
#> 5 JONES DRUGS 003 null 959 EAST MAIN ST SUITE A PRATTVILLE
#> 6 JONES DRUGS 003 null 959 EAST MAIN ST SUITE A PRATTVILLE
#> BUYER_STATE BUYER_ZIP BUYER_COUNTY TRANSACTION_CODE DRUG_CODE NDC_NO
#> 1 AL 36066 AUTAUGA S 9193 00406035905
#> 2 AL 36066 AUTAUGA S 9193 00603388728
#> 3 AL 36066 AUTAUGA S 9193 00603388832
#> 4 AL 36066 AUTAUGA S 9193 00603388728
#> 5 AL 36066 AUTAUGA S 9193 00591054005
#> 6 AL 36066 AUTAUGA S 9193 00591054005
#> DRUG_NAME QUANTITY UNIT ACTION_INDICATOR ORDER_FORM_NO CORRECTION_NO
#> 1 HYDROCODONE 1 null null null null
#> 2 HYDROCODONE 2 null null null null
#> 3 HYDROCODONE 2 null null null null
#> 4 HYDROCODONE 1 null null null null
#> 5 HYDROCODONE 1 null null null null
#> 6 HYDROCODONE 1 null null null null
#> STRENGTH TRANSACTION_DATE CALC_BASE_WT_IN_GM DOSAGE_UNIT TRANSACTION_ID
#> 1 null 06072010 2.2702 500 1788
#> 2 null 09102010 6.0540 1000 2054
#> 3 null 06102011 12.1080 2000 2287
#> 4 null 08152011 3.0270 500 1267
#> 5 null 09132011 3.0270 500 2184
#> 6 null 10032011 3.0270 500 34
#> Product_Name Ingredient_Name
#> 1 HYDROCODONE BITARTRATE 7.5MG & ACETA HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 2 HYDROCODONE.BIT./ACET.,10MG & 325MG/ HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 3 HYDROCODONE.BIT & ACETA 10MG & 500M HYDROCODONE BITARTRATE HEMIPENTAHYDRATE
#> 4 HYDROCODONE.BIT./ACET.,10MG & 325MG/ 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 SpecGx LLC
#> 2 TAB 1 Par Pharmaceutical
#> 3 TAB 1 Par Pharmaceutical
#> 4 TAB 1 Par Pharmaceutical
#> 5 TAB 1 Actavis Pharma, Inc.
#> 6 TAB 1 Actavis Pharma, Inc.
#> Revised_Company_Name Reporter_family dos_str
#> 1 Mallinckrodt Bloodworth Wholesale Drugs 7.5
#> 2 Endo Pharmaceuticals, Inc. Bloodworth Wholesale Drugs 10.0
#> 3 Endo Pharmaceuticals, Inc. Bloodworth Wholesale Drugs 10.0
#> 4 Endo Pharmaceuticals, Inc. Bloodworth Wholesale Drugs 10.0
#> 5 Allergan, Inc. Bloodworth Wholesale Drugs 10.0
#> 6 Allergan, Inc. Bloodworth Wholesale Drugs 10.0
# }