WASHINGTON STATE OPIOID NETWORK
Saunders
9/28/2019
knitr::opts_chunk$set(echo = TRUE)INTRO
One way to handle the very large Washington Post Opioid dataset is to parse the data by state. Here is an analysis of the Washington State data.
PROCESS DATA
PACKAGES
library(tidyverse, warn.conflicts = FALSE)## -- Attaching packages --------------------------------------------------------------------------------------------- tidyverse 1.3.0 --## v ggplot2 3.2.1 v purrr 0.3.3
## v tibble 2.1.3 v dplyr 0.8.4
## v tidyr 1.0.2 v stringr 1.4.0
## v readr 1.3.1 v forcats 0.4.0## -- Conflicts ------------------------------------------------------------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()library(lubridate, warn.conflicts = FALSE)
library(ggmap, warn.conflicts = FALSE)## Google's Terms of Service: https://cloud.google.com/maps-platform/terms/.## Please cite ggmap if you use it! See citation("ggmap") for details.library(kableExtra, warn.conflicts = FALSE)
#library(forcats)
#install_github("ww44ss/yo")
library(yo)
#yo <- function(x){x}Keys
Get the key from local file. filename is incuded in gitignore so it does not copy to repository.
directory <- "***********" # add your own pointerLOAD THE DATA
REGISTER GOOGLE KEY
Needed for mapping and geo-coding.
## key file is ignored by git
keys <- read_csv(str_c(directory, "keys.csv"))## Parsed with column specification:
## cols(
## key = col_character()
## )APIkey <- keys$key
#APIkey <- "THISisNOTaREALkey123456789" ## FAKE_KEY
#to create new key go to https://console.cloud.google.com/apis/credentials/key
register_google(key = APIkey)
has_google_key()## [1] TRUE#google_key()
#has_google_client()
#has_google_signature()Can check key by verifying has_google_key() = TRUE.
## Warning: 1 parsing failure.
## row col expected actual file
## 2374460 DOSAGE_UNIT no trailing characters .5 'C:/Users/wisaund/OneDrive - Microsoft/Documents/2019 Data Science/Washington_Post_Opiod_Data/Washington/REPORTER_BUYER_STATE_CITY2019_09_26_17_08_55.csv'That data has 2379204 rows.
Summarize the data by BUYER and REPORTER data and create CITY_STATE variable.
buy_report_data <- summary_data %>%
select(BUYER_CITY, BUYER_STATE, REPORTER_CITY, REPORTER_STATE, CALC_BASE_WT_IN_GM)%>%
group_by(BUYER_CITY, BUYER_STATE, REPORTER_CITY, REPORTER_STATE) %>%
summarize(TOTAL_WT_IN_GM = sum(CALC_BASE_WT_IN_GM)) %>%
ungroup() %>%
mutate(buyer = str_c(BUYER_CITY, ", ", BUYER_STATE), reporter = str_c(REPORTER_CITY, ", ", REPORTER_STATE)) %>%
yo
Here are the first few lines of the data
summary_data %>%
slice(1:100) %>%
kable() %>%
kable_styling(bootstrap_options = "striped", full_width = T, position = "center") %>%
row_spec(0, angle = 0, align = 'c', bold = F, color = "white", background = "#17367E") %>%
kable_styling(font_size = 8) %>%
scroll_box(width = "700px", height = "200px") %>%
yo| REPORTER_DEA_NO | REPORTER_BUS_ACT | REPORTER_NAME | REPORTER_ADDL_CO_INFO | REPORTER_ADDRESS1 | REPORTER_ADDRESS2 | REPORTER_CITY | REPORTER_STATE | REPORTER_ZIP | REPORTER_COUNTY | BUYER_DEA_NO | BUYER_BUS_ACT | BUYER_NAME | BUYER_ADDL_CO_INFO | BUYER_ADDRESS1 | BUYER_ADDRESS2 | BUYER_CITY | BUYER_STATE | BUYER_ZIP | BUYER_COUNTY | TRANSACTION_CODE | DRUG_CODE | NDC_NO | DRUG_NAME | QUANTITY | UNIT | ACTION_INDICATOR | ORDER_FORM_NO | CORRECTION_NO | STRENGTH | TRANSACTION_DATE | CALC_BASE_WT_IN_GM | DOSAGE_UNIT | TRANSACTION_ID | Product_Name | Ingredient_Name | Measure | MME_Conversion_Factor | Combined_Labeler_Name | Revised_Company_Name | Reporter_family | dos_str | YEAR | MONTH |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RK0236403 | DISTRIBUTOR | KEYSOURCE MEDICAL | NA | 7820 PALACE DRIVE | NA | CINCINNATI | OH | 45249 | HAMILTON | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 406853001 | OXYCODONE | 150 | NA | NA | 10X006907 | NA | NA | 7122010 | 403.4250 | 15000 | 2044 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | KeySource Medical | 30 | 2010 | 7 |
| RK0236403 | DISTRIBUTOR | KEYSOURCE MEDICAL | NA | 7820 PALACE DRIVE | NA | CINCINNATI | OH | 45249 | HAMILTON | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 406853001 | OXYCODONE | 150 | NA | NA | 10X006377 | NA | NA | 6302010 | 403.4250 | 15000 | 5079 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | KeySource Medical | 30 | 2010 | 6 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 144 | NA | NA | 083922715 | NA | 0.0 | 10082008 | 387.2880 | 14400 | 810013582 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 10 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 083543547 | NA | NA | 11032008 | 344.2560 | 4800 | 811034704 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 077416398 | NA | NA | 2112008 | 344.2560 | 4800 | 802035206 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 2 |
| RA0287020 | DISTRIBUTOR | ANDA PHARMACEUTICALS INC | NA | 6500 ADELAIDE COURT | NA | GROVEPORT | OH | 43125 | FRANKLIN | BN7826499 | RETAIL PHARMACY | NORTHWEST PRESCRIPTIONS & MEDICAL SUPPLY | NA | 1536 NORTH 115TH STREET | SUITE 100 | SEATTLE | WA | 98133 | KING | S | 9143 | 591350401 | OXYCODONE | 48 | NA | NA | 070466262 | NA | 0.0 | 2262007 | 344.2560 | 4800 | 702024878 | OXYCODONE HCL 80MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Anda, Inc | 80 | 2007 | 2 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 077416382 | NA | NA | 3262008 | 344.2560 | 4800 | 803034043 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 3 |
| PK0132821 | DISTRIBUTOR | KAISER FNDTN HEALTH PLAN NW | PHARMACY MATERIAL SERVICES | 5721 NE 138TH AVE | REC DOOR D | PORTLAND | OR | 97230 | MULTNOMAH | AL2863810 | RETAIL PHARMACY | KAISER FOUNDATION HEALTH PLAN OF THE NW | KAISER PERMANENTE LONGVIEW KELSO PHARMACY | 1230 7TH AVE. | NA | LONGVIEW | WA | 98632 | COWLITZ | S | 9143 | 93003301 | OXYCODONE | 48 | NA | NA | 080684687 | NA | NA | 7012008 | 344.2560 | 4800 | 12 | OXYCODONE HYDROCHLORIDE - ER - 80MG/ | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Teva Pharmaceuticals USA, Inc. | Teva | Kaiser Permanente | 80 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 083543540 | NA | NA | 11042008 | 344.2560 | 4800 | 811034715 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 084610013 | NA | NA | 12022008 | 344.2560 | 4800 | 812039282 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 12 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 077416414 | NA | NA | 3102008 | 344.2560 | 4800 | 803033931 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 3 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 10X000666 | NA | NA | 2092010 | 344.2560 | 4800 | 11167 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | AmerisourceBergen Drug | 80 | 2010 | 2 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 09X000558 | NA | NA | 8302009 | 344.2560 | 4800 | 12450 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | AmerisourceBergen Drug | 80 | 2009 | 8 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 48 | NA | NA | 077416392 | NA | NA | 4092008 | 344.2560 | 4800 | 804034971 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 4 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 216 | NA | NA | NA | NA | NA | 5252011 | 326.9160 | 108000 | 16134 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2011 | 5 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 120 | NA | NA | 083218663 | NA | 0.0 | 7242008 | 322.7400 | 12000 | 807036848 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 7 |
| RW0191813 | DISTRIBUTOR | CARDINAL HEALTH | NA | 801 C STREET NW, SUITE B | NA | AUBURN | WA | 98001 | KING | AJ2347385 | RETAIL PHARMACY | JIM’S PHARMACY | NA | CAMMACK’S PHARMACIES INC | 424 EAST SECOND STREET | PORT ANGELES | WA | 98362 | CLALLAM | S | 9143 | 54465029 | OXYCODONE | 144 | NA | NA | 061722480 | NA | 0.0 | 7072006 | 322.7400 | 72000 | 607005664 | ROXICET - OXYCODONE.HCL & ACETA 5MG/ | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | West-Ward Pharmaceuticals Corp. | West-Ward Pharmaceuticals Corp. | Cardinal Health | 5 | 2006 | 7 |
| RW0191813 | DISTRIBUTOR | CARDINAL HEALTH | NA | 801 C STREET NW, SUITE B | NA | AUBURN | WA | 98001 | KING | AJ2347385 | RETAIL PHARMACY | JIM’S PHARMACY | NA | CAMMACK’S PHARMACIES INC | 424 EAST SECOND STREET | PORT ANGELES | WA | 98362 | CLALLAM | S | 9143 | 52152021402 | OXYCODONE | 240 | NA | NA | 072591565 | NA | 0.0 | 8152007 | 322.7400 | 24000 | 708017891 | OXYCODONE HYDROCHLORIDE TABLETS USP | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Cardinal Health | 15 | 2007 | 8 |
| RH0331417 | DISTRIBUTOR | HYGEN PHARMACEUTICALS, INC. | NA | 1940 124TH AVENUE N.E. | SUITE # A-105 | BELLEVUE | WA | 98005 | KING | BK8211877 | RETAIL PHARMACY | KEN DRUGS INC | KEN DRUGS #003 | 8001 N DALE MABRY HWY | UNIT 701 | TAMPA | FL | 33614 | HILLSBOROUGH | S | 9143 | 52152021502 | OXYCODONE | 120 | NA | NA | 074023273 | NA | 0.0 | 11062007 | 322.7400 | 12000 | 187 | OXYCODONE HYDROCHLORIDE USP 30MG TAB | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Hygen Pharmaceuticals, Inc. | 30 | 2007 | 11 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 108 | NA | NA | 083922714 | NA | 0.0 | 10012008 | 290.4660 | 10800 | 810002532 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 10 |
| PM0150538 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO | 710 132ND STREET SW | EVERETT | WA | 98204 | SNOHOMISH | FS0014580 | RETAIL PHARMACY | SKAGIT VALLEY MED CTR PHARMACY- SEDRO WOOLLEY | NA | 1990 HOSPITAL DRIVE SUITE 120 | NA | SEDRO WOOLLEY | WA | 98284 | SKAGIT | S | 9143 | 59011086010 | OXYCODONE | 54 | NA | NA | 08X000087 | NA | NA | 6132008 | 290.4660 | 5400 | 806041157 | OXYCONTIN 60MG COTROLLED RELEASE OXY | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 60 | 2008 | 6 |
| RA0287020 | DISTRIBUTOR | ANDA PHARMACEUTICALS INC | NA | 6500 ADELAIDE COURT | NA | GROVEPORT | OH | 43125 | FRANKLIN | AC9747001 | RETAIL PHARMACY | COST LESS PRESCRIPTIONS, INC. | NA | 5431 PACIFIC AVE | NA | TACOMA | WA | 98408 | PIERCE | S | 9143 | 591350401 | OXYCODONE | 40 | NA | NA | 063866988 | NA | 0.0 | 11092006 | 286.8800 | 4000 | 611008395 | OXYCODONE HCL 80MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Anda, Inc | 80 | 2006 | 11 |
| RW0191813 | DISTRIBUTOR | CARDINAL HEALTH | NA | 801 C STREET NW, SUITE B | NA | AUBURN | WA | 98001 | KING | BP0414259 | RETAIL PHARMACY | PURDY COST LESS PRESCRIPTIONS | DON ZIMMERMAN RPH OR IAN WARREN RPH | 14218 92ND AVENUE NW | NA | GIG HARBOR | WA | 98329 | PIERCE | S | 9143 | 591350301 | OXYCODONE | 80 | NA | NA | 070889796 | NA | 0.0 | 2282007 | 286.8800 | 8000 | 702036360 | OXYCODONE HCL 40MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Cardinal Health | 40 | 2007 | 2 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 100 | NA | NA | 081412578 | NA | 0.0 | 5212008 | 268.9500 | 10000 | 805031270 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 5 |
| RH0331417 | DISTRIBUTOR | HYGEN PHARMACEUTICALS, INC. | NA | 1940 124TH AVENUE N.E. | SUITE # A-105 | BELLEVUE | WA | 98005 | KING | BR9085514 | RETAIL PHARMACY | -BAL, INC, DBA THE RX SHOP ""YOUR OWN PHARMACY"""" | NA | 5322 DUHME DR | NA | MADEIRA BEACH | FL | 33708 | PINELLAS | S | 9143 | 52152021502 | OXYCODONE | 100 | NA | NA | 075601344 | NA | 0.0 | 11062007 | 268.9500 | 10000 | 285 | OXYCODONE HYDROCHLORIDE USP 30MG TAB | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Hygen Pharmaceuticals, Inc. | 30 | 2007 | 11 |
| RW0191813 | DISTRIBUTOR | CARDINAL HEALTH | NA | 801 C STREET NW, SUITE B | NA | AUBURN | WA | 98001 | KING | BP0414259 | RETAIL PHARMACY | PURDY COST LESS PRESCRIPTIONS | DON ZIMMERMAN RPH OR IAN WARREN RPH | 14218 92ND AVENUE NW | NA | GIG HARBOR | WA | 98329 | PIERCE | S | 9143 | 591350201 | OXYCODONE | 150 | NA | NA | 070889796 | NA | 0.0 | 2282007 | 268.9500 | 15000 | 702036359 | OXYCODONE HYDROCHLORIDE CR 20MG TABL | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Purdue Pharma LP | Cardinal Health | 20 | 2007 | 2 |
| RH0331417 | DISTRIBUTOR | HYGEN PHARMACEUTICALS, INC. | NA | 1940 124TH AVENUE N.E. | SUITE # A-105 | BELLEVUE | WA | 98005 | KING | BK8211877 | RETAIL PHARMACY | KEN DRUGS INC | KEN DRUGS #003 | 8001 N DALE MABRY HWY | UNIT 701 | TAMPA | FL | 33614 | HILLSBOROUGH | S | 9143 | 52152021502 | OXYCODONE | 100 | NA | NA | 070310387 | NA | 0.0 | 7022007 | 268.9500 | 10000 | 169 | OXYCODONE HYDROCHLORIDE USP 30MG TAB | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Hygen Pharmaceuticals, Inc. | 30 | 2007 | 7 |
| RA0253877 | DISTRIBUTOR | ADVANTAGE LOGISTICS | NA | 533 NORTH MALLICK ROAD | NA | OGLESBY | IL | 61348 | LA SALLE | BA2130007 | CHAIN PHARMACY | NEW ALBERTSONS INC | NA | DBA SAV-ON PHARMACY #475 | 1434 OLNEY AVENUE S E | PORT ORCHARD | WA | 98366 | KITSAP | S | 9143 | 378710601 | OXYCODONE | 300 | NA | NA | 10X040810 | NA | 1000.0 | 12272010 | 268.9500 | 30000 | 4530613 | OXYCODONE HCL/ACETAMINOPHEN 10MG/325 | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Mylan Pharmaceuticals, Inc. | Mylan Pharmaceuticals, Inc. | Advantage Logistics | 10 | 2010 | 12 |
| RK0236403 | DISTRIBUTOR | KEYSOURCE MEDICAL | NA | 7820 PALACE DRIVE | NA | CINCINNATI | OH | 45249 | HAMILTON | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 406853001 | OXYCODONE | 100 | NA | NA | 10X005522 | NA | NA | 6082010 | 268.9500 | 10000 | 1604 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | KeySource Medical | 30 | 2010 | 6 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BG7982893 | RETAIL PHARMACY | KAISER FOUNDATION HEALTH PLAN OF WASHINGTON | KAISER PERMANENTE CAMPUS PHARMACY | 2921 NACHES AVE SW | NA | RENTON | WA | 98057 | KING | S | 9143 | 93003301 | OXYCODONE | 36 | NA | NA | 057550848 | NA | NA | 7142006 | 258.1920 | 3600 | 20442 | OXYCODONE HYDROCHLORIDE - ER - 80MG/ | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Teva Pharmaceuticals USA, Inc. | Teva | AmerisourceBergen Drug | 80 | 2006 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543513 | NA | NA | 9162008 | 258.1920 | 9600 | 809019694 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 9 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 084610013 | NA | NA | 12022008 | 258.1920 | 9600 | 812021081 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 12 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 082509873 | NA | NA | 7302008 | 258.1920 | 3600 | 807034235 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509903 | NA | NA | 7072008 | 258.1920 | 9600 | 807018770 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509885 | NA | NA | 9032008 | 258.1920 | 9600 | 809019586 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 9 |
| RH0331417 | DISTRIBUTOR | HYGEN PHARMACEUTICALS, INC. | NA | 1940 124TH AVENUE N.E. | SUITE # A-105 | BELLEVUE | WA | 98005 | KING | BK8211877 | RETAIL PHARMACY | KEN DRUGS INC | KEN DRUGS #003 | 8001 N DALE MABRY HWY | UNIT 701 | TAMPA | FL | 33614 | HILLSBOROUGH | S | 9143 | 52152021502 | OXYCODONE | 96 | NA | NA | 070310387 | NA | 0.0 | 6062007 | 258.1920 | 9600 | 209 | OXYCODONE HYDROCHLORIDE USP 30MG TAB | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Hygen Pharmaceuticals, Inc. | 30 | 2007 | 6 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083218654 | NA | 0.0 | 8132008 | 258.1920 | 9600 | 808020642 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 8 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | AK8220282 | RETAIL PHARMACY | KAISER PERMANENTE MT SCOTT PHARMACY | NA | 9800 SE SUNNYSIDE ROAD | NA | CLACKAMAS | OR | 97015 | CLACKAMAS | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 092560648 | NA | NA | 6202009 | 258.1920 | 3600 | 12896 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | AmerisourceBergen Drug | 80 | 2009 | 6 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 10X000740 | NA | NA | 6082010 | 258.1920 | 3600 | 12430 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | AmerisourceBergen Drug | 80 | 2010 | 6 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | FA0036598 | RETAIL PHARMACY | ASSURED PHARMACY GRESHAM | NA | 831 NW COUNSIL DRIVE | SUITE 115 | GRESHAM | OR | 97030 | MULTNOMAH | S | 9143 | 66479058210 | OXYCODONE | 96 | NA | NA | 09X000211 | NA | NA | 4092009 | 258.1920 | 9600 | 12875 | ROXICODONE (OXYCODONE HCL) 30MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Xanodyne Pharmaceuticals, Inc. | Xanodyne Pharmaceuticals, Inc. | AmerisourceBergen Drug | 30 | 2009 | 4 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543547 | NA | NA | 11032008 | 258.1920 | 9600 | 811019106 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 083543529 | NA | NA | 10102008 | 258.1920 | 3600 | 810040499 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 10 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | FA0036598 | RETAIL PHARMACY | ASSURED PHARMACY GRESHAM | NA | 831 NW COUNSIL DRIVE | SUITE 115 | GRESHAM | OR | 97030 | MULTNOMAH | S | 9143 | 66479058210 | OXYCODONE | 96 | NA | NA | 09X000212 | NA | NA | 4132009 | 258.1920 | 9600 | 12878 | ROXICODONE (OXYCODONE HCL) 30MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Xanodyne Pharmaceuticals, Inc. | Xanodyne Pharmaceuticals, Inc. | AmerisourceBergen Drug | 30 | 2009 | 4 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 077416386 | NA | NA | 4022008 | 258.1920 | 9600 | 804015052 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 4 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509902 | NA | NA | 7032008 | 258.1920 | 9600 | 807018761 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 7 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 085236100 | NA | 0.0 | 11032008 | 258.1920 | 9600 | 811002506 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509887 | NA | NA | 7162008 | 258.1920 | 9600 | 807018858 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 084610039 | NA | NA | 11182008 | 258.1920 | 9600 | 811019230 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509892 | NA | NA | 7252008 | 258.1920 | 9600 | 807018930 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543540 | NA | NA | 11042008 | 258.1920 | 9600 | 811019113 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 084610006 | NA | NA | 12102008 | 258.1920 | 9600 | 812021229 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 12 |
| RH0366460 | DISTRIBUTOR | H D SMITH WHOLESALE DRUG COMPANY | NA | 1370 VICTORIA STREET | NA | CARSON | CA | 90746 | LOS ANGELES | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 228287911 | OXYCODONE | 96 | NA | NA | 104326106 | NA | NA | 1252012 | 258.1920 | 9600 | 10623 | OXYCODONE HCL 30MG TABLETS, 100 CT | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | H. D. Smith | 30 | 2012 | 1 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083218642 | NA | 0.0 | 8292008 | 258.1920 | 9600 | 808045239 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 8 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 077416384 | NA | NA | 3282008 | 258.1920 | 9600 | 803014342 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 3 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083218645 | NA | 0.0 | 7162008 | 258.1920 | 9600 | 807024391 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 7 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083922702 | NA | 0.0 | 9182008 | 258.1920 | 9600 | 809029580 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 9 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 077416418 | NA | NA | 3172008 | 258.1920 | 9600 | 803014273 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 3 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509879 | NA | NA | 8202008 | 258.1920 | 9600 | 808017339 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 8 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543536 | NA | NA | 11042008 | 258.1920 | 9600 | 811019121 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 11 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083922708 | NA | 0.0 | 9292008 | 258.1920 | 9600 | 809044443 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 9 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509873 | NA | NA | 7302008 | 258.1920 | 9600 | 807018964 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 082509881 | NA | NA | 8252008 | 258.1920 | 3600 | 808031831 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 8 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543529 | NA | NA | 10102008 | 258.1920 | 9600 | 810022509 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 10 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 081412587 | NA | 0.0 | 6052008 | 258.1920 | 9600 | 806007363 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 6 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | AL2863810 | RETAIL PHARMACY | KAISER FOUNDATION HEALTH PLAN OF THE NW | KAISER PERMANENTE LONGVIEW KELSO PHARMACY | 1230 7TH AVE. | NA | LONGVIEW | WA | 98632 | COWLITZ | S | 9143 | 93003301 | OXYCODONE | 36 | NA | NA | 08X000042 | NA | NA | 8062008 | 258.1920 | 3600 | 21877 | OXYCODONE HYDROCHLORIDE - ER - 80MG/ | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Teva Pharmaceuticals USA, Inc. | Teva | AmerisourceBergen Drug | 80 | 2008 | 8 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 93003301 | OXYCODONE | 36 | NA | NA | 077416398 | NA | NA | 2112008 | 258.1920 | 3600 | 802002184 | OXYCODONE HYDROCHLORIDE - ER - 80MG/ | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Teva Pharmaceuticals USA, Inc. | Teva | McKesson Corporation | 80 | 2008 | 2 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543511 | NA | NA | 9102008 | 258.1920 | 9600 | 809019655 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 9 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 084610007 | NA | NA | 12122008 | 258.1920 | 9600 | 812021259 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 12 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543507 | NA | NA | 9032008 | 258.1920 | 9600 | 809019590 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 9 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 084610034 | NA | NA | 11122008 | 258.1920 | 9600 | 811019205 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 084610014 | NA | NA | 12022008 | 258.1920 | 9600 | 812021082 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 12 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 080827322 | NA | NA | 5062008 | 258.1920 | 9600 | 805018372 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 5 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509895 | NA | NA | 6252008 | 258.1920 | 9600 | 806018223 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 6 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 082509905 | NA | NA | 7082008 | 258.1920 | 3600 | 807033967 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 7 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 93003301 | OXYCODONE | 36 | NA | NA | 077416410 | NA | NA | 3032008 | 258.1920 | 3600 | 803001884 | OXYCODONE HYDROCHLORIDE - ER - 80MG/ | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Teva Pharmaceuticals USA, Inc. | Teva | McKesson Corporation | 80 | 2008 | 3 |
| RH0366460 | DISTRIBUTOR | H D SMITH WHOLESALE DRUG COMPANY | NA | 1370 VICTORIA STREET | NA | CARSON | CA | 90746 | LOS ANGELES | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 00406853001 | OXYCODONE | 96 | NA | NA | 104326107 | NA | NA | 2012012 | 258.1920 | 9600 | 140 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | H. D. Smith | 30 | 2012 | 2 |
| RW0236009 | DISTRIBUTOR | CARDINAL HEALTH | NA | 3238 DWIGHT RD | NA | ELK GROVE | CA | 95758 | SACRAMENTO | BK8665145 | CHAIN PHARMACY | KMART OF WA LLC 3275 | NA | 2711 NE ANDRESEN ROAD | NA | VANCOUVER | WA | 98661 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 081412590 | NA | 0.0 | 6112008 | 258.1920 | 9600 | 806016333 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | Cardinal Health | 30 | 2008 | 6 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | FA0036598 | RETAIL PHARMACY | ASSURED PHARMACY GRESHAM | NA | 831 NW COUNSIL DRIVE | SUITE 115 | GRESHAM | OR | 97030 | MULTNOMAH | S | 9143 | 603499221 | OXYCODONE | 96 | NA | NA | 11X000786 | NA | NA | 4212011 | 258.1920 | 9600 | 3319 | OXYCODONE HCL 30MG USP TABLETS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 30 | 2011 | 4 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 082509877 | NA | NA | 8152008 | 258.1920 | 9600 | 808017305 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 8 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 36 | NA | NA | 083543536 | NA | NA | 11042008 | 258.1920 | 3600 | 811034720 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 11 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 080827337 | NA | NA | 6042008 | 258.1920 | 9600 | 806018064 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 6 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 406853001 | OXYCODONE | 96 | NA | NA | 083543514 | NA | NA | 9172008 | 258.1920 | 9600 | 809019720 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | McKesson Corporation | 30 | 2008 | 9 |
| RW0191813 | DISTRIBUTOR | CARDINAL HEALTH | NA | 801 C STREET NW, SUITE B | NA | AUBURN | WA | 98001 | KING | BP0414259 | RETAIL PHARMACY | PURDY COST LESS PRESCRIPTIONS | DON ZIMMERMAN RPH OR IAN WARREN RPH | 14218 92ND AVENUE NW | NA | GIG HARBOR | WA | 98329 | PIERCE | S | 9143 | 591350401 | OXYCODONE | 35 | NA | NA | 070889796 | NA | 0.0 | 2282007 | 251.0200 | 3500 | 702036361 | OXYCODONE HCL 80MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Cardinal Health | 80 | 2007 | 2 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9143 | 66479058010 | OXYCODONE | 540 | NA | NA | 09X000363 | NA | NA | 1092009 | 242.0550 | 54000 | 17559 | ROXICODONE (OXYCODONE HCL) 5MG TABS. | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Xanodyne Pharmaceuticals, Inc. | Xanodyne Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2009 | 1 |
| RH0366460 | DISTRIBUTOR | H D SMITH WHOLESALE DRUG COMPANY | NA | 1370 VICTORIA STREET | NA | CARSON | CA | 90746 | LOS ANGELES | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 406853001 | OXYCODONE | 88 | NA | NA | 111269496 | NA | NA | 11152012 | 236.6760 | 8800 | 4726 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | H. D. Smith | 30 | 2012 | 11 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 156 | NA | NA | NA | NA | NA | 3012012 | 236.1060 | 78000 | 17129 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2012 | 3 |
| RH0366460 | DISTRIBUTOR | H D SMITH WHOLESALE DRUG COMPANY | NA | 1370 VICTORIA STREET | NA | CARSON | CA | 90746 | LOS ANGELES | BA8901755 | RETAIL PHARMACY | ASSURED PHARMACIES NORTHWEST, LLC | CORDANT PHARMACY #3 AND CORDANT PHARMACY SOLUTIONS | 1417 116TH AVE NE | STE 204 | BELLEVUE | WA | 98004 | KING | S | 9143 | 406853001 | OXYCODONE | 84 | NA | NA | 104326099 | NA | NA | 12022011 | 225.9180 | 8400 | 5162 | OXYCODONE HYDROCHLORIDE 30MG TABLET | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | SpecGx LLC | Mallinckrodt | H. D. Smith | 30 | 2011 | 12 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | FA0036598 | RETAIL PHARMACY | ASSURED PHARMACY GRESHAM | NA | 831 NW COUNSIL DRIVE | SUITE 115 | GRESHAM | OR | 97030 | MULTNOMAH | S | 9143 | 603499221 | OXYCODONE | 83 | NA | NA | 09X000152 | NA | NA | 2022009 | 223.2285 | 8300 | 2367 | OXYCODONE HCL 30MG USP TABLETS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 30 | 2009 | 2 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 8022012 | 217.9440 | 72000 | 18016 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2012 | 8 |
| RH0334463 | DISTRIBUTOR | OMNICARE DISTRIBUTION CENTER LLC | NA | 302 S. BYRNE RD. | BUILDING 200 | TOLEDO | OH | 43615 | LUCAS | BE4189874 | RETAIL PHARMACY | EVERGREEN PHARMACEUTICAL LLC | OMNICARE OF SEATTLE | 12674 GATEWAY DRIVE S | NA | TUKWILA | WA | 98168 | KING | S | 9193 | 406035705 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 11192006 | 217.9440 | 72000 | 1168 | HYDROCODONE BIT/ACETAMINOPHEN 5MG/50 | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | SpecGx LLC | Mallinckrodt | Omnicare Distribution Center LLC | 5 | 2006 | 11 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 11212011 | 217.9440 | 72000 | 17777 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2011 | 11 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 12162010 | 217.9440 | 72000 | 17017 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2010 | 12 |
| RH0334463 | DISTRIBUTOR | OMNICARE DISTRIBUTION CENTER LLC | NA | 302 S. BYRNE RD. | BUILDING 200 | TOLEDO | OH | 43615 | LUCAS | BE4189874 | RETAIL PHARMACY | EVERGREEN PHARMACEUTICAL LLC | OMNICARE OF SEATTLE | 12674 GATEWAY DRIVE S | NA | TUKWILA | WA | 98168 | KING | S | 9193 | 406035705 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 12212006 | 217.9440 | 72000 | 1169 | HYDROCODONE BIT/ACETAMINOPHEN 5MG/50 | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | SpecGx LLC | Mallinckrodt | Omnicare Distribution Center LLC | 5 | 2006 | 12 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 7252012 | 217.9440 | 72000 | 16592 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2012 | 7 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 1062011 | 217.9440 | 72000 | 14637 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2011 | 1 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 12302011 | 217.9440 | 72000 | 17905 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2011 | 12 |
| RA0290938 | DISTRIBUTOR | AMERISOURCEBERGEN DRUG CORP | NA | 19220 64TH AVENUE SOUTH | NA | KENT | WA | 98032 | KING | BK4860955 | RETAIL PHARMACY | KAISER PERMANENTE | MAIL ORDER PHARMACY | 5725 NE 138TH AVENUE | NA | PORTLAND | OR | 97230 | MULTNOMAH | S | 9193 | 603388128 | HYDROCODONE | 144 | NA | NA | NA | NA | NA | 3042011 | 217.9440 | 72000 | 16379 | HYDROCODONE.BIT. & ACETA 5MG & 500M | HYDROCODONE BITARTRATE HEMIPENTAHYDRATE | TAB | 1.0 | Par Pharmaceutical | Endo Pharmaceuticals, Inc. | AmerisourceBergen Drug | 5 | 2011 | 3 |
| RA0180733 | DISTRIBUTOR | ANDA, INC | NA | 2915 WESTON ROAD | NA | WESTON | FL | 33331 | BROWARD | AC9747001 | RETAIL PHARMACY | COST LESS PRESCRIPTIONS, INC. | NA | 5431 PACIFIC AVE | NA | TACOMA | WA | 98408 | PIERCE | S | 9143 | 591350301 | OXYCODONE | 60 | NA | NA | 067026270 | NA | 0.0 | 2262007 | 215.1600 | 6000 | 702008366 | OXYCODONE HCL 40MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Anda, Inc | 40 | 2007 | 2 |
| PM0022929 | DISTRIBUTOR | MCKESSON CORPORATION | NA | DBA MCKESSON DRUG CO. | 9700 SW COMMERCE CIRCLE | WILSONVILLE | OR | 97070 | CLACKAMAS | BT5728576 | CHAIN PHARMACY | THRIFTY PAYLESS INC. | RITE AID #5291 | 13511 SE THIRD WAY | NA | VANCOUVER | WA | 98684 | CLARK | S | 9143 | 59011010710 | OXYCODONE | 30 | NA | NA | 080827312 | NA | NA | 5142008 | 215.1600 | 3000 | 805034120 | OXYCONTIN - 80MG OXYCODONE.HCL CONTR | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Purdue Pharma LP | Purdue Pharma LP | McKesson Corporation | 80 | 2008 | 5 |
| RW0191813 | DISTRIBUTOR | CARDINAL HEALTH | NA | 801 C STREET NW, SUITE B | NA | AUBURN | WA | 98001 | KING | BN7826499 | RETAIL PHARMACY | NORTHWEST PRESCRIPTIONS & MEDICAL SUPPLY | NA | 1536 NORTH 115TH STREET | SUITE 100 | SEATTLE | WA | 98133 | KING | S | 9143 | 591350301 | OXYCODONE | 60 | NA | NA | 066805022 | NA | 0.0 | 3232007 | 215.1600 | 6000 | 703030997 | OXYCODONE HCL 40MG TABS | OXYCODONE HYDROCHLORIDE | TAB | 1.5 | Actavis Pharma, Inc. | Allergan, Inc. | Cardinal Health | 40 | 2007 | 3 |
Let’s clean things up and make the data tidy.
buy_report_tidy <- buy_report_data %>%
select(buyer, reporter, TOTAL_WT_IN_GM) %>%
pivot_longer(c('buyer', 'reporter'), names_to = 'ROLE') %>%
rename('CITY_STATE' = 'value') %>%
yoGEO-CODE CITY_STATE
TO amiek thigs efficient separate adn geocode each unique entity once.
##
## check for latlon.csv
## if there read, if not create
## latlon is geo-code dCITY_STATE pairs
files <- list.files(directory)
if ('latlon.csv' %in% files) {
latlon <- read_csv(str_c(directory, "latlon.csv"), col_types ="cdd")
}else{
CITY_STATE <- buy_report_tidy %>%
select(CITY_STATE) %>%
unique() %>%
yo
latlon <- geocode(CITY_STATE$CITY_STATE)
latlon <- CITY_STATE %>%
bind_cols(latlon) %>%
yo
latlon %>% write_csv(str_c(directory, "latlon.csv"))
}Then use join to associate data.
## pair latlon with data
buy_report_tidy <- buy_report_tidy %>%
left_join(latlon, by = "CITY_STATE") %>%
yoMAPPING
THis is a map of all transactions a touch point with the state of WA. (either shipped to or shipped from).
lon_range_max <- max(buy_report_tidy$lon )
lon_range_min <- min( buy_report_tidy$lon )
lat_range_max <- max( buy_report_tidy$lat )
lat_range_min <- min( buy_report_tidy$lat )
ggmap(get_googlemap(center = c(lon = -105., lat = 44.),
zoom = 3, scale = 2,
maptype ='terrain',
color = 'color')) +
geom_point(aes(x = lon, y = lat, size = TOTAL_WT_IN_GM, fill = ROLE),
data = buy_report_tidy , pch = 21, alpha = 0.4) +
theme(legend.position="right") +
labs(title = "Buyer Reporter Locations for WA Transactions", subtitle = "size = total weight in grams ME") +
scale_x_continuous(limits = c(1.02*lon_range_min, 0.98*lon_range_max), expand = c(0, 0)) +
scale_y_continuous(limits = c(0.98*lat_range_min, 1.02*lat_range_max), expand = c(0, 0)) + facet_grid(.~ROLE)
CONTINENTAL US
Zooming in.
lon_range_max <- -66
lon_range_min <- -128
lat_range_max <- 49
lat_range_min <- 18
ggmap(get_googlemap(center = c(lon = -105., lat = 44.),
zoom = 3, scale = 2,
maptype ='terrain',
color = 'color')) +
geom_point(aes(x = lon, y = lat, size = TOTAL_WT_IN_GM, fill = ROLE),
data = buy_report_tidy , pch = 21, alpha = 0.4) +
theme(legend.position="right") +
labs(title = "Buyer Reporter Locations for WA Transactions", subtitle = "size = total weight in grams ME") +
scale_x_continuous(limits = c(1.02*lon_range_min, 0.98*lon_range_max), expand = c(0, 0)) +
scale_y_continuous(limits = c(0.98*lat_range_min, 1.02*lat_range_max), expand = c(0, 0)) + facet_grid(.~ROLE)
SHIPMENTS TO WA
plot_data <- buy_report_tidy %>% filter(CITY_STATE %>% str_detect (", WA") & ROLE == "buyer")
lon_range_max <- max(plot_data$lon )
lon_range_min <- min( plot_data$lon )
lat_range_max <- max( plot_data$lat )
lat_range_min <- min( plot_data$lat )
ggmap(get_googlemap(center = c(lon = (lon_range_max + lon_range_min)/2, lat = (lat_range_max+lat_range_min)/2),
zoom = 6, scale = 2,
maptype ='terrain',
color = 'color')) +
geom_point(aes(x = lon, y = lat, size = TOTAL_WT_IN_GM, fill = ROLE),
data = plot_data , pch = 21, alpha = 0.4) +
theme(legend.position="right") +
labs(title = "Buyer Reporter Locations for WA Transactions", subtitle = "size = total weight in grams ME") +
scale_x_continuous(limits = c(1.01*lon_range_min, 0.99*lon_range_max), expand = c(0, 0)) +
scale_y_continuous(limits = c(0.99*lat_range_min, 1.01*lat_range_max), expand = c(0, 0)) +
theme()
SHIPMENTS TO & FROM WA
We can also look at more compicated breakdowns.
Let’s look at traffic to and from WA. Here is the data for opioids shipped to WA
`
plot_data <- buy_report_tidy %>% filter((CITY_STATE %>% str_detect (", WA") & ROLE == "buyer") | (!(CITY_STATE %>% str_detect (", WA")) & ROLE == "reporter"))
lon_range_max <- max(plot_data$lon )
lon_range_min <- min( plot_data$lon )
lat_range_max <- max( plot_data$lat )
lat_range_min <- min( plot_data$lat )
ggmap(get_googlemap(center = c(lon = (lon_range_max + lon_range_min)/2, lat = (lat_range_max+lat_range_min)/2),
zoom = 3, scale = 2,
maptype ='terrain',
color = 'color')) +
geom_point(aes(x = lon, y = lat, size = TOTAL_WT_IN_GM, fill = ROLE),
data = plot_data , pch = 21, alpha = 0.4) +
theme(legend.position="right") +
labs(title = "Reporter outside WA shipped to Buyer inside WA", subtitle = "size = total weight in grams ME") +
scale_x_continuous(limits = c(1.01*lon_range_min, 0.99*lon_range_max), expand = c(0, 0)) +
scale_y_continuous(limits = c(0.99*lat_range_min, 1.01*lat_range_max), expand = c(0, 0)) +
theme()
Here’s the converse data for Opioids shipped from WA to elsewhere.
plot_data <- buy_report_tidy %>% filter((!(CITY_STATE %>% str_detect (", WA")) & ROLE == "buyer") | ((CITY_STATE %>% str_detect (", WA")) & ROLE == "reporter"))
lon_range_max <- max(plot_data$lon )
lon_range_min <- min( plot_data$lon )
lat_range_max <- max( plot_data$lat )
lat_range_min <- min( plot_data$lat )
ggmap(get_googlemap(center = c(lon = (lon_range_max + lon_range_min)/2, lat = (lat_range_max+lat_range_min)/2),
zoom = 3, scale = 2,
maptype ='terrain',
color = 'color')) +
geom_point(aes(x = lon, y = lat, size = TOTAL_WT_IN_GM, fill = ROLE),
data = plot_data , pch = 21, alpha = 0.4) +
theme(legend.position="right") +
labs(title = "REPORTER in WA shipped Outside WA", subtitle = "size = total weight in grams ME") +
scale_x_continuous(limits = c(1.01*lon_range_min, 0.99*lon_range_max), expand = c(0, 0)) +
scale_y_continuous(limits = c(0.99*lat_range_min, 1.01*lat_range_max), expand = c(0, 0)) +
theme()
Notice the relatively large shipments to Alaska. Possibly something to investigate.
SUMMARY
Opioid data reduced by selecting for a given state seems to work prety well.
- brings the data to a mangeable size
- retains a nation-wide picture.
Based on some otehr analysis, states like Azizona, California, and FLorida would be worth looking at.
This document took 1.1 minutes to execute
fin