auth_rx_combined

11,827,050 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date of Service (date), Processing Date (date)

Link rowid ▼ Date of Service Rx Processing Date Status NDC Quantity Dispensed Days Supply IC Pharmacy REMS ID Pharmacy Name Prescriber REMS ID Prescriber Last Names New or Repeat # of Times on Subsys Week Territory SSP DM RD RSM proc_rel FLAG Flag Count if Patient ID FSD Class ASD RM
1 1 2012-03-26 3D6768D0BE8D1562 2012-03-26 13:12:22.000032 Paid 20482-0001-30 30.0 30 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
2 2 2012-03-26 AFA77098914B198A 2012-03-28 12:30:32.999328 Paid 20482-0001-30 10.0 10 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
3 3 2012-03-26 F92720B39062D5A4 2012-04-04 18:09:17.999712 Reversal 20482-0001-30 0.0 0 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
4 4 2012-03-26 F4F8E4F3685AA402 2012-04-04 18:09:27 Reversal 20482-0004-30 0.0 0 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
5 5 2012-03-26 F23207AFDFDF3F3C 2012-03-26 10:19:24.999744 Reversal 20482-0016-30 0.0 0   7493052 CVS PHARMACY 6830576 Rosenberg                                
6 6 2012-03-26 3D6768D0BE8D1562 2012-03-26 13:12:22.000032 Paid 20482-0001-30 30.0 30 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
7 7 2012-03-26 AFA77098914B198A 2012-03-28 12:30:32.999328 Paid 20482-0001-30 10.0 10 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
8 8 2012-03-26 F92720B39062D5A4 2012-04-04 18:09:17.999712 Reversal 20482-0001-30 0.0 0 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
9 9 2012-03-26 F4F8E4F3685AA402 2012-04-04 18:09:27 Reversal 20482-0004-30 0.0 0 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
10 10 2012-03-26 F23207AFDFDF3F3C 2012-03-26 10:19:24.999744 Reversal 20482-0016-30 0.0 0   7493052 CVS PHARMACY 6830576 Rosenberg                                
11 11 2012-03-26 F23207AFDFDF3F3C 2012-03-26 10:19:24.999744 Reversal 20482-0016-30 0.0 0   7493052 CVS PHARMACY 6830576 Rosenberg     0100180116 NYC-102 Abe Rosenberg     Jeff Pearlman                
12 12 2012-03-27 48F93394FD700C2E 2012-04-02 20:37:17.999904 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
13 13 2012-03-27 48F93394FD700C2E 2012-04-02 20:37:17.999904 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
14 14 2012-03-28 3EDF4951D74FFDD3 2012-03-28 12:32:14.999712 Paid 20482-0001-30 10.0 10 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
15 15 2012-03-28 5CCFD1933ED19C3F 2012-03-28 16:41:43.999296 Paid 20482-0002-30 30.0 30 I 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
16 16 2012-03-28 6100DD87D6805022 2012-03-28 20:53:48.999264 Paid 20482-0002-30 90.0 11 C 7158549 BASHAS 6833515 Fanto                                
17 17 2012-03-28 3EDF4951D74FFDD3 2012-03-28 12:32:14.999712 Paid 20482-0001-30 10.0 10 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
18 18 2012-03-28 5CCFD1933ED19C3F 2012-03-28 16:41:43.999296 Paid 20482-0002-30 30.0 30 I 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
19 19 2012-03-28 6100DD87D6805022 2012-03-28 20:53:48.999264 Paid 20482-0002-30 90.0 11 C 7158549 BASHAS 6833515 Fanto                                
20 20 2012-03-29 3320CE2CA4C925E2 2012-03-29 13:24:43.999776 Paid 20482-0001-30 10.0 3 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
21 21 2012-03-29 E4B970835EC647B1 2012-03-29 09:42:00.999936 Paid 20482-0004-30 90.0 30 I 8351864 Middleport Family Health Center 6836833 waghmarae                                
22 22 2012-03-29 C60C9ED040161106 2012-03-29 13:27:58.999392 Paid 20482-0004-30 42.0 21 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
23 23 2012-03-29 6F12B7A42F33FB51 2012-03-29 19:35:34.999584 Paid 20482-0004-30 30.0 30 I 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
24 24 2012-03-29 0C4D17ACDDE5BC4E 2012-03-30 17:38:59.999424 Reversal 20482-0004-30 0.0 0 I 9020396 blue water 6826506 Awerbuch                                
25 25 2012-03-29 A85DB5D479568025 2012-03-29 17:07:14.99952 Reversal 20482-0006-30 0.0 0   8083281 Sonterra RX 6825278 Hernandez                                
26 26 2012-03-29 3320CE2CA4C925E2 2012-03-29 13:24:43.999776 Paid 20482-0001-30 10.0 3 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
27 27 2012-03-29 E4B970835EC647B1 2012-03-29 09:42:00.999936 Paid 20482-0004-30 90.0 30 I 8351864 Middleport Family Health Center 6836833 waghmarae                                
28 28 2012-03-29 C60C9ED040161106 2012-03-29 13:27:58.999392 Paid 20482-0004-30 42.0 21 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
29 29 2012-03-29 6F12B7A42F33FB51 2012-03-29 19:35:34.999584 Paid 20482-0004-30 30.0 30 I 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
30 30 2012-03-29 0C4D17ACDDE5BC4E 2012-03-30 17:38:59.999424 Reversal 20482-0004-30 0.0 0 I 9020396 blue water 6826506 Awerbuch                                
31 31 2012-03-29 A85DB5D479568025 2012-03-29 17:07:14.99952 Reversal 20482-0006-30 0.0 0   8083281 Sonterra RX 6825278 Hernandez                                
32 32 2012-03-29 E4B970835EC647B1 2012-03-29 09:42:00.999936 Paid 20482-0004-30 90.0 30 I 8351864 Middleport Family Health Center 6836833 waghmarae     8360181009 NYC-101 Michael Volansky     Jeff Pearlman                
33 33 2012-03-29 A85DB5D479568025 2012-03-29 17:07:14.99952 Reversal 20482-0006-30 0.0 0   8083281 Sonterra RX 6825278 Hernandez     0050671026 SFO-106 Ty Rustin     Jessica Kroll                
34 34 2012-03-30 5F9B99F88A7AEF95 2012-03-30 13:55:18.999264 Paid 20482-0001-30 30.0 7 I 7932661 OLYMPIA PLAZA PHARMACY 6824330 Chatman                                
35 35 2012-03-30 ED1B6130DC70C491 2012-03-30 22:09:13.000032 Reversal 20482-0001-30 0.0 0   7368696 CVS PHARMACY 6782056 Mangar                                
36 36 2012-03-30 0E23E994E8C76093 2012-04-03 15:00:30.999456 Paid 20482-0001-30 30.0 8 C 6920186 Blue Ridge Pharmacy 6825732 Cook                                
37 37 2012-03-30 5C058C2CF57C183C 2012-03-30 12:17:57.99984 Paid 20482-0002-30 25.0 13 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
38 38 2012-03-30 C25D32307E795CF6 2012-03-30 13:58:40.999872 Paid 20482-0002-30 30.0 7 C 7932661 OLYMPIA PLAZA PHARMACY 6824330 Chatman                                
39 39 2012-03-30 01C6EB52E7652FC1 2012-03-30 20:18:28.999872 Reversal 20482-0002-30 0.0 0   6993816 RITE AID PHARMACY 00758 6836833 waghmarae                                
40 40 2012-03-30 A9FD0F74382C8C92 2012-03-30 14:12:49.999968 Paid 20482-0006-30 30.0 7 C 7932661 OLYMPIA PLAZA PHARMACY 6824330 Chatman                                
41 41 2012-03-30 5F9B99F88A7AEF95 2012-03-30 13:55:18.999264 Paid 20482-0001-30 30.0 7 I 7932661 OLYMPIA PLAZA PHARMACY 6824330 Chatman                                
42 42 2012-03-30 ED1B6130DC70C491 2012-03-30 22:09:13.000032 Reversal 20482-0001-30 0.0 0   7368696 CVS PHARMACY 6782056 Mangar                                
43 43 2012-03-30 0E23E994E8C76093 2012-04-03 15:00:30.999456 Paid 20482-0001-30 30.0 8 C 6920186 Blue Ridge Pharmacy 6825732 Cook                                
44 44 2012-03-30 5C058C2CF57C183C 2012-03-30 12:17:57.99984 Paid 20482-0002-30 25.0 13 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
45 45 2012-03-30 C25D32307E795CF6 2012-03-30 13:58:40.999872 Paid 20482-0002-30 30.0 7 C 7932661 OLYMPIA PLAZA PHARMACY 6824330 Chatman                                
46 46 2012-03-30 01C6EB52E7652FC1 2012-03-30 20:18:28.999872 Reversal 20482-0002-30 0.0 0   6993816 RITE AID PHARMACY 00758 6836833 waghmarae                                
47 47 2012-03-30 A9FD0F74382C8C92 2012-03-30 14:12:49.999968 Paid 20482-0006-30 30.0 7 C 7932661 OLYMPIA PLAZA PHARMACY 6824330 Chatman                                
48 48 2012-03-30 01C6EB52E7652FC1 2012-03-30 20:18:28.999872 Reversal 20482-0002-30 0.0 0   6993816 RITE AID PHARMACY 00758 6836833 waghmarae     8360181009 NYC-101 Michael Volansky     Jeff Pearlman                
49 49 2012-04-01 C6FDAC009ACF3158 2012-04-01 18:27:06.999264 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
50 50 2012-04-01 C6FDAC009ACF3158 2012-04-01 18:27:06.999264 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
51 51 2012-04-02 D793B0FD42852840 2012-04-02 10:42:31.000032 Paid 20482-0001-30 5.0 3 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
52 52 2012-04-02 A6D033C02A9F5942 2012-04-02 11:08:16.999296 Paid 20482-0001-30 60.0 15 C 6911949 LACEYS MARIETTA PHARMACY 6858426 Tark                                
53 53 2012-04-02 438B94DF6A9704A1 2012-04-02 11:32:33.999648 Paid 20482-0001-30 4.0 2 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
54 54 2012-04-02 F7452AB7C11BC6CB 2012-04-02 12:49:32.999808 Reversal 20482-0002-30 0.0 0 C 7454605 CVS PHARMACY 6810209 Gehret                                
55 55 2012-04-02 01C6EB52E7652FC1 2012-04-02 13:20:12.999264 Reversal 20482-0002-30 0.0 0   6993816 RITE AID PHARMACY 00758 6836833 waghmarae                                
56 56 2012-04-02 2A2499366B21EB67 2012-04-03 10:39:55.999296 Paid 20482-0002-30 60.0 15 I 8321865 apex pharmacy 6835846 Gatz                                
57 57 2012-04-02 87C55853904ECFC4 2012-04-03 15:38:11.999328 Paid 20482-0002-30 60.0 30 C 6913751 Sierra Pharmacy 6810591 Ritter                                
58 58 2012-04-02 2A2499366B21EB67 2012-04-24 15:23:29.999616 Reversal 20482-0002-30 0.0 0 I 8321865 apex pharmacy 6835846 Gatz                                
59 59 2012-04-02 38F1784B21A94304 2012-04-02 10:44:43.999872 Paid 20482-0004-30 55.0 27 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
60 60 2012-04-02 F57A52EA7BF1D920 2012-04-02 17:15:35.999424 Paid 20482-0004-30 30.0 5 I 8321198 Focus Rx 9085624 Forde                                
61 61 2012-04-02 552896E032F8E838 2012-04-02 18:23:09.999744 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837809 rho                                
62 62 2012-04-02 39C8125A7E254B1A 2012-04-02 21:47:27.999744 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
63 63 2012-04-02 FA0694CC5E94A342 2012-04-04 16:44:16.999872 Reversal 20482-0004-30 0.0 0 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
64 64 2012-04-02 6AA402660153BE4C 2012-04-02 15:20:17.999808 Paid 20482-0006-30 30.0 5 C 8083281 Sonterra RX 6825278 Hernandez                                
65 65 2012-04-02 3BAA6FB5DC8B4571 2012-04-02 17:25:44.999328 Paid 20482-0006-30 30.0 10 C 6910758 familycare discount pharmacy 6827129 chun                                
66 66 2012-04-02 CF74A4C517F6ED1F 2012-04-02 16:17:54.999456 Paid 20482-0008-30 30.0 30 C 8757470 APOTHECARY SHOP AT GRAYHAWK 6833515 Fanto                                
67 67 2012-04-02 90FB778BBE5C0A5F 2012-04-02 18:31:45.999552 Paid 20482-0008-30 60.0 30 C 7953548 ALBERTSONS LLC 6837896 Gruskin                                
68 68 2012-04-02 D793B0FD42852840 2012-04-02 10:42:31.000032 Paid 20482-0001-30 5.0 3 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
69 69 2012-04-02 A6D033C02A9F5942 2012-04-02 11:08:16.999296 Paid 20482-0001-30 60.0 15 C 6911949 LACEYS MARIETTA PHARMACY 6858426 Tark                                
70 70 2012-04-02 438B94DF6A9704A1 2012-04-02 11:32:33.999648 Paid 20482-0001-30 4.0 2 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
71 71 2012-04-02 F7452AB7C11BC6CB 2012-04-02 12:49:32.999808 Reversal 20482-0002-30 0.0 0 C 7454605 CVS PHARMACY 6810209 Gehret                                
72 72 2012-04-02 01C6EB52E7652FC1 2012-04-02 13:20:12.999264 Reversal 20482-0002-30 0.0 0   6993816 RITE AID PHARMACY 00758 6836833 waghmarae                                
73 73 2012-04-02 2A2499366B21EB67 2012-04-03 10:39:55.999296 Paid 20482-0002-30 60.0 15 I 8321865 apex pharmacy 6835846 Gatz                                
74 74 2012-04-02 87C55853904ECFC4 2012-04-03 15:38:11.999328 Paid 20482-0002-30 60.0 30 C 6913751 Sierra Pharmacy 6810591 Ritter                                
75 75 2012-04-02 2A2499366B21EB67 2012-04-24 15:23:29.999616 Reversal 20482-0002-30 0.0 0 I 8321865 apex pharmacy 6835846 Gatz                                
76 76 2012-04-02 38F1784B21A94304 2012-04-02 10:44:43.999872 Paid 20482-0004-30 55.0 27 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
77 77 2012-04-02 F57A52EA7BF1D920 2012-04-02 17:15:35.999424 Paid 20482-0004-30 30.0 5 I 8321198 Focus Rx 9085624 Forde                                
78 78 2012-04-02 552896E032F8E838 2012-04-02 18:23:09.999744 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837809 rho                                
79 79 2012-04-02 39C8125A7E254B1A 2012-04-02 21:47:27.999744 Paid 20482-0004-30 30.0 30 C 6936767 QUICK CARE PHARMACY INC 6837840 Song                                
80 80 2012-04-02 FA0694CC5E94A342 2012-04-04 16:44:16.999872 Reversal 20482-0004-30 0.0 0 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
81 81 2012-04-02 6AA402660153BE4C 2012-04-02 15:20:17.999808 Paid 20482-0006-30 30.0 5 C 8083281 Sonterra RX 6825278 Hernandez                                
82 82 2012-04-02 3BAA6FB5DC8B4571 2012-04-02 17:25:44.999328 Paid 20482-0006-30 30.0 10 C 6910758 familycare discount pharmacy 6827129 chun                                
83 83 2012-04-02 CF74A4C517F6ED1F 2012-04-02 16:17:54.999456 Paid 20482-0008-30 30.0 30 C 8757470 APOTHECARY SHOP AT GRAYHAWK 6833515 Fanto                                
84 84 2012-04-02 90FB778BBE5C0A5F 2012-04-02 18:31:45.999552 Paid 20482-0008-30 60.0 30 C 7953548 ALBERTSONS LLC 6837896 Gruskin                                
85 85 2012-04-02 01C6EB52E7652FC1 2012-04-02 13:20:12.999264 Reversal 20482-0002-30 0.0 0   6993816 RITE AID PHARMACY 00758 6836833 waghmarae     8360181009 NYC-101 Michael Volansky     Jeff Pearlman                
86 86 2012-04-02 3BAA6FB5DC8B4571 2012-04-02 17:25:44.999328 Paid 20482-0006-30 30.0 10 C 6910758 familycare discount pharmacy 6827129 chun     0540492030 MIA-108 Daniel Tondre     Joseph Rowan                
87 87 2012-04-02 6AA402660153BE4C 2012-04-02 15:20:17.999808 Paid 20482-0006-30 30.0 5 C 8083281 Sonterra RX 6825278 Hernandez     0050671026 SFO-106 Ty Rustin     Jessica Kroll                
88 88 2012-04-03 C32FB787C5873CF8 2012-04-03 10:06:24.999552 Paid 20482-0001-30 4.0 1 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
89 89 2012-04-03 0CDAE3A53F842801 2012-04-03 14:00:43.999776 Paid 20482-0001-30 2.0 1 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
90 90 2012-04-03 1ECE5F0A352643AF 2012-04-03 14:17:43.999296 Reversal 20482-0001-30 0.0 0   6976271 RITE AID PHARMACY 10469 6796135 Spagnoletti                                
91 91 2012-04-03 04E9BBE9CF5EB95E 2012-04-03 14:33:31.999968 Paid 20482-0001-30 6.0 6 I 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
92 92 2012-04-03 8DCAD21F63789CE1 2012-04-03 19:19:35.999328 Reversal 20482-0001-30 0.0 0   7178637 KING SOOPERS PHARMACY 6777845 Shemesh                                
93 93 2012-04-03 ED1B6130DC70C491 2012-04-04 17:30:30.999744 Reversal 20482-0001-30 0.0 0 I 7368696 CVS PHARMACY 6782056 Mangar                                
94 94 2012-04-03 09A3A57C9D9A0B3E 2012-04-14 15:08:06.999648 Reversal 20482-0001-30 0.0 0 I 7519430 PUBLIX PHARMACY 6835846 Gatz                                
95 95 2012-04-03 DE5A1C81E45502F6 2012-04-03 11:32:60 Reversal 20482-0002-30 0.0 0   8082816 EXPRESS PHARMACY 6826506 Awerbuch                                
96 96 2012-04-03 F48808244A2F23F4 2012-04-03 15:06:36.99936 Reversal 20482-0002-30 0.0 0   8082816 EXPRESS PHARMACY 6826506 Awerbuch                                
97 97 2012-04-03 D9ED3C9C70BD866D 2012-04-03 22:00:14.999328 Reversal 20482-0002-30 0.0 0 I 7185422 FRYS FOOD AND DRUG 6836583 jones                                
98 98 2012-04-03 BFD8ADC5FC79A6FF 2012-04-03 14:02:51 Paid 20482-0004-30 88.0 30 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                
99 99 2012-04-03 C90670FA2B4CE86A 2012-04-03 17:16:01.999776 Paid 20482-0004-30 120.0 30 I 6927066 HAMBURG PHARMACY, INC. 6836833 waghmarae                                
100 100 2012-04-03 740F04E3EF021DEB 2012-04-03 14:36:02.99952 Paid 20482-0006-30 22.0 22 C 6911763 Marlton Pharmacy 6796135 Spagnoletti                                

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "auth_rx_combined" (
"Date of Service" TEXT,
  "Rx" TEXT,
  "Processing Date" TEXT,
  "Status" TEXT,
  "NDC" TEXT,
  "Quantity Dispensed" REAL,
  "Days Supply" INTEGER,
  "IC" TEXT,
  "Pharmacy REMS ID" TEXT,
  "Pharmacy Name" TEXT,
  "Prescriber REMS ID" TEXT,
  "Prescriber Last Names" TEXT,
  "New or Repeat" TEXT,
  "# of Times on Subsys" INTEGER,
  "Week" TEXT,
  "Territory" TEXT,
  "SSP" TEXT,
  "DM" TEXT,
  "RD" TEXT,
  "RSM" TEXT,
  "proc_rel" TEXT,
  "FLAG" TEXT,
  "Flag Count if" INTEGER,
  "Patient ID" INTEGER,
  "FSD" TEXT,
  "Class" TEXT,
  "ASD" TEXT,
  "RM" TEXT
);