Spreadsheet: 696914d1601038879-count-overlap-between-days-multiple-dates-overlap-calc-20200925
Sheet: June Claims

 |  |  | Start measurement period | 2020-06-01 00:00:00
 |  |  | End measurement period | 2020-06-30 00:00:00
member_id | date_filled 2 | end_date_filled | start measurement period 1 | end measurement period 1 | drug_label_name | DS Covered period 1 | Days in Period period 1 | MME/Day | Count of DS Covered period 1 | Distinct Count of claim_number | calculate overlap if there is one | overlap daily [NAME] | Note | adjusted start date | adjusted end date | adjusted calculated overlap 1
2000c001300 | 2020-05-27 00:00:00 | 2020-06-16 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] 10-325 MG | 16 | 30 | 4 | 1 | 1 |  |  | less than 15 days overlap, no action
2000c001300 | 2020-06-24 00:00:00 | 2020-07-14 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] 10-325 MG | 7 | 30 | 4 | 1 | 1 |  |  | less than 15 days overlap, no action
2000c001300 Total |  |  |  |  |  |  |  |  | 2 | 2 |  |  | less than 15 days overlap, no action
2000c00x000 | 2020-05-26 00:00:00 | 2020-06-23 00:00:00 | 6/1/2020 | 6/30/2020 | HYDROMORPHONE 2 MG TABLET | 23 | 30 | 25.71428571428572 | 1 | 1 |  |  | <90 mme/day
2000c00x000 | 2020-05-26 00:00:00 | 2020-06-25 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCONTIN ER 20 MG TABLET | 25 | 30 | 4.5 | 1 | 1 |  |  | <90 mme/day
2000c00x000 | 2020-06-26 00:00:00 | 2020-07-26 00:00:00 | 6/1/2020 | 6/30/2020 | HYDROMORPHONE 2 MG TABLET | 5 | 30 | 24 | 1 | 1 |  |  | <90 mme/day
2000c00x000 | 2020-06-26 00:00:00 | 2020-07-26 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCONTIN ER 20 MG TABLET | 5 | 30 | 4.5 | 1 | 1 |  |  | <90 mme/day
2000c00x000 Total |  |  |  |  |  |  |  |  | 4 | 4 |  |  | <90 mme/day
x01kcx90900 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 1 | 30 | 1.5 | 1 | 1 |  |  | 1 claim no action
x01kcx90900 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01kc901300 | 2020-06-24 00:00:00 | 2020-07-01 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE-ACETAMINOPHEN 5-325 | 7 | 30 | 8.571428571428571 | 1 | 1 |  |  | 1 claim no action
x01kc901300 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01kc90xk01 | 2020-05-05 00:00:00 | 2020-06-04 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 4 | 30 | 0.1 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc90xk01 | 2020-05-27 00:00:00 | 2020-06-26 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 26 | 30 | 0.1 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc90xk01 Total |  |  |  |  |  |  |  |  | 2 | 2 |  |  | less than 15 days overlap, no action
x01kc9k7c00 | 2020-05-07 00:00:00 | 2020-06-06 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE-ACETAMINOPHEN 5-325 | 6 | 30 | 3 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc9k7c00 | 2020-06-15 00:00:00 | 2020-07-15 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE-ACETAMINOPHEN 5-325 | 16 | 30 | 3 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc9k7c00 Total |  |  |  |  |  |  |  |  | 2 | 2 |  |  | less than 15 days overlap, no action
x01kc973400 | 2020-06-24 00:00:00 | 2020-06-28 00:00:00 | 6/1/2020 | 6/30/2020 | HYDROMORPHONE 2 MG TABLET | 5 | 30 | 24 | 1 | 1 |  |  | 1 claim no action
x01kc973400 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01kc973904 | 2020-06-24 00:00:00 | 2020-06-26 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 3 | 30 | 0.5 | 1 | 1 |  |  | 1 claim no action
x01kc973904 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01kc977100 | 2020-05-14 00:00:00 | 2020-06-13 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 13 | 30 | 0.1 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc977100 | 2020-06-10 00:00:00 | 2020-07-10 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 21 | 30 | 0.1 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc977100 Total |  |  |  |  |  |  |  |  | 2 | 2 |  |  | less than 15 days overlap, no action
x01kc9x0c01 | 2020-06-12 00:00:00 | 2020-06-22 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] MG | 11 | 30 | 12 | 1 | 1 |  |  | 1 claim no action
x01kc9x0c01 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01kc9x4700 | 2020-06-30 00:00:00 | 2020-07-07 00:00:00 | 6/1/2020 | 6/30/2020 | ACETAMINOPHEN-COD #3 TABLET | 1 | 30 | 0.15 | 1 | 1 |  |  | 1 claim no action
x01kc9x4700 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01kc991100 | 2020-05-19 00:00:00 | 2020-06-18 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] MG | 18 | 30 | 1 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc991100 | 2020-06-21 00:00:00 | 2020-06-23 00:00:00 | 6/1/2020 | 6/30/2020 | BUTALB-CAFF-ACETAMINOPH-CODEIN | 3 | 30 | 1.125 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc991100 | 2020-06-23 00:00:00 | 2020-07-23 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] MG | 8 | 30 | 1 | 1 | 1 |  |  | less than 15 days overlap, no action
x01kc991100 Total |  |  |  |  |  |  |  |  | 3 | 3 |  |  | less than 15 days overlap, no action
[NAME] | 2020-05-04 00:00:00 | 2020-06-03 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE-ACETAMINOPHEN 5-325 | 3 | 30 | 3 | 1 | 1 |  |  | 1 claim no action
x01kc99x901 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01k700x701 | 2020-06-22 00:00:00 | 2020-06-27 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE-ACETAMINOPHEN 5-325 | 6 | 30 | 9 | 1 | 1 |  |  | 1 claim no action
x01k700x701 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01k701x200 | 2020-05-04 00:00:00 | 2020-06-03 00:00:00 | 6/1/2020 | 6/30/2020 | MORPHINE SULF ER 15 MG TABLET | 3 | 30 | 2 | 1 | 1 |  |  | less than 15 days overlap, no action
x01k701x200 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 6/1/2020 | 6/30/2020 | MORPHINE SULF ER 15 MG TABLET | 30 | 30 | 2 | 1 | 1 |  |  | less than 15 days overlap, no action
x01k701x200 | 2020-06-30 00:00:00 | 2020-07-30 00:00:00 | 6/1/2020 | 6/30/2020 | MORPHINE SULF ER 15 MG TABLET | 1 | 30 | 2 | 1 | 1 |  |  | less than 15 days overlap, no action
x01k701x200 Total |  |  |  |  |  |  |  |  | 3 | 3 |  |  | less than 15 days overlap, no action
x01k702k700 | 2020-06-11 00:00:00 | 2020-06-17 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 7 | 30 | 0.3 | 1 | 1 |  |  | less than 15 days overlap, no action
x01k702k700 | 2020-06-16 00:00:00 | 2020-07-06 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 15 | 30 | 0.3 | 1 | 1 |  |  | less than 15 days overlap, no action
x01k702k700 Total |  |  |  |  |  |  |  |  | 2 | 2 |  |  | less than 15 days overlap, no action
[NAME] | 2020-06-30 00:00:00 | 2020-07-05 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 1 | 30 | 9 | 1 | 1 |  |  | 1 claim no action
x01k703ck01 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01k70k7301 | 2020-06-27 00:00:00 | 2020-07-01 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 4 | 30 | 7.5 | 1 | 1 |  |  | 1 claim no action
x01k70k7301 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01k70c0k00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE-ACETAMINOPHEN 5-325 | 2 | 30 | 9 | 1 | 1 |  |  | 1 claim no action
x01k70c0k00 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01k7112x00 | 2020-06-18 00:00:00 | 2020-06-23 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 6 | 30 | 0.4 | 1 | 1 |  |  | 1 claim no action
x01k7112x00 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action
x01k71k2k00 | 2020-05-20 00:00:00 | 2020-06-19 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] MG TABLET | 19 | 30 | 36 | 1 | 1 |  |  | <90 mme/day
x01k71k2k00 | 2020-05-29 00:00:00 | 2020-06-06 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 20 MG TABLET | 6 | 30 | 22.5 | 1 | 1 |  |  | <90 mme/day
x01k71k2k00 | 2020-06-10 00:00:00 | 2020-07-10 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] 10 MG TABLET | 21 | 30 | 24 | 1 | 1 |  |  | <90 mme/day
x01k71k2k00 | 2020-06-16 00:00:00 | 2020-06-24 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 20 MG TABLET | 9 | 30 | 22.5 | 1 | 1 |  |  | <90 mme/day
x01k71k2k00 | 2020-06-24 00:00:00 | 2020-07-09 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] MG TABLET | 7 | 30 | 6.133333333333334 | 1 | 1 |  |  | <90 mme/day
x01k71k2k00 Total |  |  |  |  |  |  |  |  | 5 | 5 |  |  | <90 mme/day
x0239cxx200 | 2020-05-05 00:00:00 | 2020-06-04 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 4 | 30 | 6 | 1 | 1 |  |  | <90 mme/day
x0239cxx200 | 2020-05-05 00:00:00 | 2020-06-04 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 4 | 30 | 0.4 | 1 | 1 |  |  | <90 mme/day
x0239cxx200 | 2020-06-02 00:00:00 | 2020-07-02 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 29 | 30 | 0.4 | 1 | 1 |  |  | <90 mme/day
x0239cxx200 | 2020-06-04 00:00:00 | 2020-07-04 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 27 | 30 | 6 | 1 | 1 |  |  | <90 mme/day
x0239cxx200 | 2020-06-30 00:00:00 | 2020-07-30 00:00:00 | 6/1/2020 | 6/30/2020 | TRAMADOL HCL 50 MG TABLET | 1 | 30 | 0.4 | 1 | 1 |  |  | <90 mme/day
x0239cxx200 Total |  |  |  |  |  |  |  |  | 5 | 5 |  |  | <90 mme/day
x0239x39c00 | 2020-06-17 00:00:00 | 2020-06-22 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 6 | 30 | 9 | 1 | 1 |  |  | less than 15 days overlap, no action
x0239x39c00 | 2020-06-29 00:00:00 | 2020-07-04 00:00:00 | 6/1/2020 | 6/30/2020 | OXYCODONE HCL 5 MG TABLET | 2 | 30 | 9 | 1 | 1 |  |  | less than 15 days overlap, no action
x0239x39c00 Total |  |  |  |  |  |  |  |  | 2 | 2 |  |  | less than 15 days overlap, no action
x0239x71100 | 2020-06-07 00:00:00 | 2020-06-10 00:00:00 | 6/1/2020 | 6/30/2020 | [NAME] MG | 4 | 30 | 3.333333333333333 | 1 | 1 |  |  | 1 claim no action
x0239x71100 Total |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 claim no action