W3C home > Mailing lists > Public > public-hcls-coi@w3.org > July to September 2008

DiabeticPatientsDataSet/*.txt accessible with SQL

From: Eric Prud'hommeaux <eric@w3.org>
Date: Tue, 29 Jul 2008 08:50:37 -0400
To: public-hcls-coi@w3.org
Message-ID: <20080729125037.GA21732@w3.org>
I created a little shell script to tweak the txt files into a more
conventional CSV format and create a MySQL database.
  http://www.w3.org/2008/04/DiabeticPatientsDataSet/createDB
It then calls
  http://www.w3.org/2008/04/DiabeticPatientsDataSet/CreateDB.sql
to create the tables and load the CSV files. (This script is also
MySQL-specific, but could be tweaked to work with other DBs.)

I tried to capture all of the foreign keys that I could find
(c.f. "foreign key (PatientID) references Person(ID)"), which one
failure documented below.

Tables:
Here are some contiguous entries for a given visit and prescription:

Person ---+------------+-------+---------------------+---------------------+
| ID      | MiddleName | SexDE | DateOfBirth         | LastEditedDTTM      |
| 1505583 |            |     3 | 1950-02-25 00:00:00 | 2007-03-10 06:01:55 | 

Sex_DE ------------------+-----------------+-------+-----------+-----------+---------------+----------------+----------------+---------------+---------------------
| ID | EnterpriseEntryID | DefinitionSetID | Entry | EntryCode | EntryName | EntryMnemonic | IsInactiveFLAG | IsEnforcedFLAG | IsCurrentFLAG | EffectiveDT         
|  3 |               389 |               0 |     2 |         2 | Female    | F             |              0 |              1 |             1 | 1996-09-22 16:43:00 

Item_Medication ----------+------------------------------+----------------+-------------+----------+---------------------
| ID          | PatientID | EntryName                    | IsAbnormalFLAG | IsErrorFLAG | ItemType | PerformedDTTM       
| 10586800019 |   1505583 | Metformin HCl 500 MG Tablet  |              1 |           0 | ME       | 2008-01-14 00:00:00 

Medication ---+-------------+--------------------+-------------+------+--------+------------------------+--------------------+------------+----------------+-----------
| ID          | ItemID      | FormOfMedicationDE | FreqUnitsDE | Dose | Refill | RoutOfAdministrationDE | QuantityToDispense | DaysToTake | PrescribedByID | MedDictDE 
| 10586800025 | 10586800019 | 0                  |          23 |    2 |      1 |                     15 |                120 |         30 |            996 |    100259 

Medication_DE ---+-----------+------------------------------+-------------+-------+----------+------+------+---------------+----------------------+----------------+---------------+-------------+------------------------------
| ID     | Entry | EntryCode | EntryName                    | NDC         | DDI   | Strength | Form | Qty  | UnitOfMeasure | ControlSubstanceCode | RouteOfAdminDE | DrugName      | LabelerName | DisplayName                  
| 100259 | 28557 | 28557     | Metformin HCl 500 MG Tablet  | 68382002810 | 28557 | 500      | TABS |      | MG            |                      |             15 | Metformin HCl |             | Metformin HCl 500 MG Tablet  

Encounter -------------+-----------+---------+---------------------+-----------------+---------------------+-------------+------------
| ID      | ProviderID | PatientID | VisitID | DTTM                | EncounterTypeDE | ReferringProviderID | Provider2ID | LockedDTTM 
| 1149505 |    1524421 |   1505583 | 1111381 | 2008-01-14 09:37:00 |              13 |                   0 |     1524421 |            

Encounter_Diagnosis ------------
| EncounterID | ICD9DiagnosisDE 
|     1149505 |           29515 

ICD9_Diagnosis_DE ----------+-----------------+-------+-----------+----------------------------------------------------------------------------+---------------+----------------+----------------+---------------+---------------------+---------+--------+-------+----------------------------------------------------------------------------+-------------------+ 
| ID    | EnterpriseEntryID | DefinitionSetID | Entry | EntryCode | EntryName                                                                  | EntryMnemonic | IsInactiveFLAG | IsEnforcedFLAG | IsCurrentFLAG | EffectiveDT         | HighAge | LowAge | SexDE | DisplayName                                                                | InjuryTypeReqFLAG | 
| 29515 |            842839 |               0 | 16796 | 401.1     | BENIGN HYPERTENSION                                                        | 401.1         |              0 |              0 |             1 | 2006-06-27 16:46:37 |       0 |      0 |     0 | BENIGN HYPERTENSION                                                        |                 0 | 

Foreign keys used above:
  Person.SexDE=Sex_DE.ID 
  Person.ID=Item_Medication.PatientID 
  Item_Medication.ID=Medication.ItemID // not strict fk, see below
  Medication_DE.ID=Medication.MedDictDE 
  Encounter.PatientID=Person.id 
  Encounter_Diagnosis.EncounterID=Encounter.ID 
  Encounter_Diagnosis.ICD9DiagnosisDE=ICD9_Diagnosis_DE.ID 

Foreign keys NOT used above:
  ICD9_Diagnosis_DE.SexDE=Sex_DE.ID // hypertension not associated with a sex.
  VitalSigns.PatientID=Person.ID // didn't include vitals above
  ICD9_Procedure_DE.SexDE=Sex_DE.ID // didn't include procedures
  ResultsByEncounter.EncounterID=Encounter.ID // didn't include results
  ResultsByEncounter.PatientID=Person.ID // didn't include results
  TestResults.PatientID=Person.ID // didn't include results

Issues:

Unknown Medications:
Medication.ItemID failed 93 of 340 refs to Item_Medication.ID .
All of these were for drugs that were know to Medication_DE.
mysql> SELECT COUNT(*) FROM Medication LEFT JOIN Item_Medication ON Medication.ItemID=Item_Medication.ID JOIN Medication_DE ON Medication_DE.ID=Medication.MedDictDE WHERE Item_Medication.ID IS NULL;
+----------+
| count(*) |
+----------+
|       93 | 
+----------+


No Prescription/Encounter Association:

As Helen has noted, there is no foreign key associating a prescription
to an encounter. Falling back to date matchup, 
  SUBSTR(Encounter.DTTM, 1, 10)=SUBSTR(Item_Medication.PerformedDTTM, 1, 10) 
we can a few false positives when we look for folks taking Metformin:

SELECT Person.ID, Sex_DE.EntryMnemonic AS S, Item_Medication.EntryName AS drug, SUBSTR(Item_Medication.PerformedDTTM, 1, 10) AS startDate, Medication.DaysToTake AS days, Encounter.ID, ICD9_Diagnosis_DE.DisplayName
  FROM Person
  JOIN Sex_DE ON Person.SexDE=Sex_DE.ID 
  JOIN Item_Medication ON Person.ID=Item_Medication.PatientID 
  JOIN Medication ON Item_Medication.ID=Medication.ItemID 
  JOIN Medication_DE ON Medication_DE.ID=Medication.MedDictDE 

  JOIN Encounter ON Encounter.PatientID=Person.id 
                    AND SUBSTR(Encounter.DTTM, 1, 10)=SUBSTR(Item_Medication.PerformedDTTM, 1, 10) 
  JOIN Encounter_Diagnosis ON Encounter_Diagnosis.EncounterID=Encounter.ID 
  JOIN ICD9_Diagnosis_DE ON Encounter_Diagnosis.ICD9DiagnosisDE=ICD9_Diagnosis_DE.ID 
 WHERE Item_Medication.EntryName like "%etformin%" 
ORDER BY Person.ID, startDate;
+-------+-+------------------+----------+----+-------+---------------------------------------------------------------------------+
|ID     |S|drug              |startDate |days|ID     |DisplayName                                                                |
+-------+-+------------------+----------+----+-------+---------------------------------------------------------------------------+
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149505|BENIGN HYPERTENSION                                                        | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149505|SEBORRHEIC DERMATITIS, UNSPECIFIED                                         | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149505|ATYPICAL FACE PAIN                                                         | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149514|LUPUS ERYTHEMATOSUS                                                        | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149505|ESOPHAGEAL REFLUX                                                          | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149504|MIGRAINE, UNSPECIFIED, WITHOUT MENTION OF INTRACTABLE MIGRAINE             | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149513|ADJUSTMENT DISORDER W/ANXIETY                                              | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149505|NONRUPT CEREBRAL ANEURYM                                                   | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149504|HEALTH EXAM-GROUP SURVEY                                                   | 
|1505583|F|Metformin HCl 500 |2008-01-14|  30|1149505|COMBINED SYSTOLIC & DIASTOLIC HRT FAIL, ACUTE                              | 
|1516986|M|Metformin HCl 1000|2007-12-04|  20|1147536|HYPERTENSION NOS                                                           | 
|1517403|M|Metformin HCl 500 |2008-01-03|  30|1147828|DM W/O MENTION OF COMP,TYPE II OR UNSPECF TYPE, NOT STATED AS UNCONTROLLED | 
+-------+-+------------------+----------+----+-------+---------------------------------------------------------------------------+
12 rows in set (0.01 sec)


No Heparin: If I recall, we are looking for folks taking Heparin.
While we list 62 types of Heparin in Medication_DE, there are none in
Item_Medication. Here are the medications we *do* have to work with:

mysql> SELECT Person.ID, Sex_DE.EntryMnemonic AS S, Item_Medication.EntryName AS drug, Medication_DE.NDC, Medication.Dose AS dose, SUBSTR(Item_Medication.PerformedDTTM, 1, 10) AS startDate, Medication.DaysToTake AS days 
  FROM Person
  JOIN Sex_DE ON Person.SexDE=Sex_DE.ID 
  JOIN Item_Medication ON Person.ID=Item_Medication.PatientID 
  JOIN Medication ON Item_Medication.ID=Medication.ItemID 
  JOIN Medication_DE ON Medication_DE.ID=Medication.MedDictDE
ORDER BY Person.ID, startDate;
+---------+---+------------------------+-------------+----+------------+----+
| ID      | S | drug                   | NDC         |dose| startDate  |days|
+---------+---+------------------------+-------------+----+------------+----+
| 1505026 | M | Amoxicillin 125 MG Tabl| 68115002530 |  1 | 2006-09-28 |  0 | 
| 1505026 | M | Amoxicillin 125 MG Tabl| 68115002530 |  1 | 2006-09-28 |  0 | 
| 1505026 | M | Amoxicillin 125 MG Tabl| 68115002530 |  1 | 2006-09-28 |  0 | 
| 1505026 | M | Amoxicillin 125 MG Tabl| 68115002530 |  1 | 2006-09-28 |  0 | 
| 1505026 | M | Prozac 10 MG Capsule   | 55289030830 |  1 | 2007-03-05 |  0 | 
| 1505026 | M | Prozac 10 MG Capsule   | 55289030830 |  1 | 2007-03-05 |  0 | 
| 1505026 | M | Amoxicillin 200 MG Tabl| 66116067620 |  1 | 2007-07-03 |  0 | 
| 1505026 | M | Amoxicillin 200 MG Tabl| 66116067620 |  1 | 2007-07-03 |  0 | 
| 1505026 | M | Paxil TABS             | 68115091630 |  1 | 2007-07-16 |  0 | 
| 1505026 | M | Paxil TABS             | 68382009816 |  1 | 2007-07-16 | 70 | 
| 1505026 | M | Motrin 400 MG TABS     |     9738502 |  1 | 2007-07-16 |  0 | 
| 1505026 | M | Ultracet TABS          | 68115087900 |  0 | 2007-07-16 |  0 | 
| 1505026 | M | Motrin 400 MG TABS     |     9738502 |  1 | 2007-07-16 |  0 | 
| 1505026 | M | Aspirin 81 MG Tablet   | 64393503916 |  0 | 2007-07-23 |  0 | 
| 1505026 | M | Aspirin 81 MG Tablet   | 64393503916 |  0 | 2007-07-23 |  0 | 
| 1505026 | M | Amoxicillin 200 MG Tabl| 66116067620 |  0 | 2007-07-31 |  0 | 
| 1505026 | M | Capozide TABS          | 54868376900 |  0 | 2008-01-07 |  0 | 
| 1505026 | M | Capozide TABS          | 54868376900 |  0 | 2008-01-07 |  0 | 
| 1505026 | M | Albuterol Powder       | 51927285900 |  0 | 2008-01-07 | 10 | 
| 1505029 | F | Motrin TABS            | 58864002630 |  0 | 2007-07-27 |  0 | 
| 1505029 | F | Imitrex 25 MG Tablet   | 58016024609 |  1 | 2007-07-27 |  0 | 
| 1505029 | F | Imitrex 25 MG Tablet   | 58016024609 |  1 | 2007-07-27 |  0 | 
| 1505029 | F | Motrin TABS            | 58864002630 |  0 | 2007-07-27 |  0 | 
| 1505029 | F | Motrin TABS            | 58864002630 |  0 | 2007-07-27 |  0 | 
| 1505029 | F | Aspirin 81 MG Tablet   | 64393503916 |  1 | 2007-09-24 |  0 | 
| 1505029 | F | Motrin 600 MG Tablet   | 54868043904 |  1 | 2007-09-24 |  0 | 
| 1505029 | F | Prozac 20 MG Capsule   | 68115071930 |  1 | 2007-09-24 |  0 | 
| 1505029 | F | Motrin 600 MG Tablet   | 54868043904 |  1 | 2007-09-24 |  0 | 
| 1505583 | F | Mobic 15 MG Tablet     | 68115043760 |  1 | 2006-08-23 |  0 | 
| 1505583 | F | Mobic 15 MG Tablet     | 68115043760 |  1 | 2006-08-23 |  0 | 
| 1505583 | F | Mobic 15 MG Tablet     | 68115043760 |  1 | 2006-08-23 |  0 | 
| 1505583 | F | Mobic 15 MG Tablet     | 68115043760 |  1 | 2006-08-23 |  0 | 
| 1505583 | F | Mobic 15 MG Tablet     | 68115043760 |  1 | 2006-08-23 |  0 | 
| 1505583 | F | Zoloft 100 MG Tablet   | 68115036560 |  2 | 2007-02-20 |  0 | 
| 1505583 | F | Isosorbide Mononitrate | 62175012937 |  1 | 2007-02-20 | 30 | 
| 1505583 | F | Isosorbide Mononitrate | 62175012937 |  1 | 2007-02-20 | 30 | 
| 1505583 | F | Isosorbide Mononitrate | 62175012937 |  1 | 2007-02-20 | 30 | 
| 1505583 | F | Zoloft 100 MG Tablet   | 68115036560 |  2 | 2007-02-20 |  0 | 
| 1505583 | F | Isosorbide Mononitrate | 62175012937 |  1 | 2007-02-20 | 30 | 
| 1505583 | F | Phenobarbital TABS     | 68258914901 |  1 | 2007-03-09 |  0 | 
| 1505583 | F | Phenobarbital TABS     | 68258914901 |  1 | 2007-03-09 |  0 | 
| 1505583 | F | Prochieve 4 % GEL      | 55056040601 |  0 | 2007-06-19 |  1 | 
| 1505583 | F | Hydrocodone-Acetaminoph| 68387030090 |  0 | 2007-06-19 | 30 | 
| 1505583 | F | Hydrocodone-Acetaminoph| 68387030090 |  0 | 2007-06-19 | 30 | 
| 1505583 | F | Aspirin 81 MG Tablet   | 64393503916 |  1 | 2007-06-19 |  0 | 
| 1505583 | F | Prochieve 4 % GEL      | 55056040601 |  0 | 2007-06-19 |  1 | 
| 1505583 | F | Bactrim TABS           | 49999023220 |  0 | 2007-06-19 |  0 | 
| 1505583 | F | Aspirin 81 MG Tablet   | 64393503916 |  1 | 2007-06-19 |  0 | 
| 1505583 | F | Bactrim TABS           | 49999023220 |  0 | 2007-06-19 |  0 | 
| 1505583 | F | Amoxicillin 250 MG Caps| 68258100201 |  1 | 2007-06-26 |  0 | 
| 1505583 | F | Amoxicillin 250 MG Caps| 68258100201 |  1 | 2007-06-26 |  0 | 
| 1505583 | F | Paxil 20 MG Tablet     | 68115026730 |  1 | 2007-06-27 |  0 | 
| 1505583 | F | Paxil 20 MG Tablet     | 68115026730 |  1 | 2007-06-27 |  0 | 
| 1505583 | F | Paxil TABS             | 68115091630 |  0 | 2007-06-28 |  0 | 
| 1505583 | F | Paxil TABS             | 68115091630 |  0 | 2007-06-28 |  0 | 
| 1505583 | F | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-26 |  0 | 
| 1505583 | F | Hydrocodone-Acetaminoph| 68387030090 |  1 | 2007-07-26 |  0 | 
| 1505583 | F | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-26 |  0 | 
| 1505583 | F | Hydrocodone-Acetaminoph| 68387030090 |  1 | 2007-07-26 |  0 | 
| 1505583 | F | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-26 |  0 | 
| 1505583 | F | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-26 |  0 | 
| 1505583 | F | Nexium 20 MG Capsule De| 58016082490 |  1 | 2007-08-08 | 30 | 
| 1505583 | F | Nexium 20 MG Capsule De| 58016082490 |  1 | 2007-08-08 | 30 | 
| 1505583 | F | Paxil 20 MG Tablet     | 68115026730 |  1 | 2007-11-19 |  0 | 
| 1505583 | F | Paxil 20 MG Tablet     | 68115026730 |  1 | 2007-11-19 |  0 | 
| 1505583 | F | Paxil 20 MG Tablet     | 68115026730 |  1 | 2007-11-19 |  0 | 
| 1505583 | F | Prevacid 30 MG Capsule | 68258108101 |  1 | 2007-12-06 | 30 | 
| 1505583 | F | Cipro TABS             | 58016011850 |  1 | 2007-12-17 |  0 | 
| 1505583 | F | Cipro TABS             | 58016011850 |  1 | 2007-12-17 |  0 | 
| 1505583 | F | Phenex-1 POWD          | 70074051121 |  0 | 2007-12-18 |  0 | 
| 1505583 | F | Phenex-1 POWD          | 70074051121 |  0 | 2007-12-18 |  0 | 
| 1505583 | F | Methotrexate 2.5 MG Tab| 68115063200 |  0 | 2007-12-19 | 30 | 
| 1505583 | F | Methotrexate 2.5 MG Tab| 68115063200 |  0 | 2007-12-19 | 30 | 
| 1505583 | F | Cipro 500 MG Tablet    | 68115008220 |  0 | 2007-12-19 |  0 | 
| 1505583 | F | Cipro 500 MG Tablet    | 68115008220 |  0 | 2007-12-19 |  0 | 
| 1505583 | F | Methotrexate 2.5 MG Tab| 68115063200 |  0 | 2007-12-19 | 30 | 
| 1505583 | F | Amoxicillin 500 MG Caps| 68387043040 |  1 | 2007-12-28 |  0 | 
| 1505583 | F | Amoxicillin 500 MG Caps| 68387043040 |  1 | 2007-12-28 |  0 | 
| 1505583 | F | Ciprofloxacin HCl 750 M| 68387053401 |  0 | 2007-12-31 |  7 | 
| 1505583 | F | Topamax 100 MG Tablet  | 68387055630 |  1 | 2007-12-31 | 30 | 
| 1505583 | F | Abilify 10 MG Tablet   | 68115071330 |  1 | 2008-01-02 | 30 | 
| 1505583 | F | Abilify 10 MG Tablet   | 68115071330 |  1 | 2008-01-02 | 30 | 
| 1505583 | F | Ciprofloxacin HCl 750 M| 68387053401 |  1 | 2008-01-02 | 10 | 
| 1505583 | F | Ciprofloxacin HCl 750 M| 68387053401 |  1 | 2008-01-02 | 10 | 
| 1505583 | F | Loxapine Succinate 50 M| 62584090311 |  1 | 2008-01-14 | 30 | 
| 1505583 | F | Aricept 5 MG Tablet    | 62856024590 |  1 | 2008-01-14 | 30 | 
| 1505583 | F | Tagamet 200 MG TABS    |   108501220 |  1 | 2008-01-14 |  0 | 
| 1505583 | F | Thiothixene 2 MG Capsul| 54868234300 |  1 | 2008-01-14 | 30 | 
| 1505583 | F | Benazepril HCl 5 MG Tab| 68258906201 |  1 | 2008-01-14 | 30 | 
| 1505583 | F | Metformin HCl 500 MG Ta| 68382002810 |  2 | 2008-01-14 | 30 | 
| 1505583 | F | Tagamet 200 MG TABS    |   108501220 |  1 | 2008-01-14 |  0 | 
| 1505583 | F | Ciprofloxacin 200 MG So| 55390019701 |  0 | 2008-01-14 | 14 | 
| 1505583 | F | Gas Free Extra Strength|   904545846 |  1 | 2008-01-14 | 30 | 
| 1505583 | F | Xopenex HFA 45 MCG/ACT | 63402051001 |  0 | 2008-01-14 | 30 | 
| 1505583 | F | Abilify 10 MG Tablet   | 68115071330 |  1 | 2008-01-15 | 30 | 
| 1505583 | F | Furosemide 40 MG Tablet| 68258101101 |  1 | 2008-01-16 | 90 | 
| 1505583 | F | Furosemide 40 MG Tablet| 68258101101 |  1 | 2008-01-16 | 90 | 
| 1505583 | F | Vagisil 5-2 % Cream (VA| 11509000363 |  0 | 2008-01-17 |  0 | 
| 1505583 | F | Amoxicillin 400 MG Tabl| 68115002830 |  1 | 2008-01-28 | 10 | 
| 1505583 | F | Metoprolol-Hydrochlorot| 54868552401 |  1 | 2008-01-31 | 30 | 
| 1505583 | F | Ciprofloxacin Powder   | 62991251802 |  0 | 2008-01-31 |  7 | 
| 1505583 | F | Ciprofloxacin Powder   | 62991251802 |  0 | 2008-01-31 |  7 | 
| 1505592 | F | Retin-A 0.025 % Cream  | 54868176002 |  0 | 2006-08-28 |  0 | 
| 1505592 | F | Retin-A 0.025 % Cream  | 54868176002 |  0 | 2006-08-28 |  0 | 
| 1505592 | F | Amoxapine 25 MG Tablet |   591571301 |  0 | 2007-07-02 |  0 | 
| 1505592 | F | Paxil 30 MG Tablet     | 67544027060 |  0 | 2007-07-02 |  0 | 
| 1505592 | F | Amoxapine 25 MG Tablet |   591571301 |  0 | 2007-07-02 |  0 | 
| 1505592 | F | Paxil 30 MG Tablet     | 67544027060 |  0 | 2007-07-02 |  0 | 
| 1505592 | F | Hydrocodone-Acetaminoph| 68387023560 |  3 | 2007-09-05 |  7 | 
| 1505592 | F | Aricept 10 MG Tablet   | 67544009289 |  1 | 2007-09-20 | 30 | 
| 1505592 | F | Hydrocodone-Acetaminoph| 68115039799 |  1 | 2007-09-27 | 10 | 
| 1505592 | F | Amoxicillin Powder     | 38779019008 |  1 | 2007-09-27 | 10 | 
| 1515263 | F | Prozac 10 MG Capsule   | 55289030830 |  2 | 2007-09-18 |  0 | 
| 1515476 | F | Celebrex 200 MG Capsule| 68387055260 |  0 | 2007-09-20 |  0 | 
| 1515476 | F | Hydrocodone-Acetaminoph| 68387030090 |  0 | 2007-09-20 | 20 | 
| 1515512 | F | Amoxapine TABS         |   591571401 |  0 | 2006-12-06 |  0 | 
| 1515512 | F | Amoxicillin 250 MG Caps| 68258100201 |  0 | 2006-12-06 |  0 | 
| 1515512 | F | Nexium 20 MG Capsule De| 58016082490 |  1 | 2007-10-02 |  0 | 
| 1516786 | F | Accutane 10 MG Capsule |     4015549 |  1 | 2007-04-18 |  0 | 
| 1516963 | M | Avelox 400 MG Tablet   | 68115092505 |  1 | 2007-07-02 |  0 | 
| 1516963 | M | Aspirin 81 MG Tablet   | 64393503916 |  0 | 2007-07-02 |  0 | 
| 1516963 | M | Accutane 10 MG Capsule |     4015549 |  0 | 2007-07-02 |  0 | 
| 1516963 | M | Aspirin 81 MG Tablet   | 64393503916 |  0 | 2007-07-02 |  0 | 
| 1516963 | M | Hydrocodone-Acetaminoph| 68387030090 |  1 | 2007-07-02 |  0 | 
| 1516963 | M | Accutane 10 MG Capsule |     4015549 |  0 | 2007-07-02 |  0 | 
| 1516963 | M | Hydrocodone-Acetaminoph| 68387030090 |  1 | 2007-07-02 |  0 | 
| 1516963 | M | Avelox 400 MG Tablet   | 68115092505 |  1 | 2007-07-02 |  0 | 
| 1516963 | M | Accutane 10 MG Capsule |     4015549 |  0 | 2007-08-17 |  0 | 
| 1516963 | M | Accutane 10 MG Capsule |     4015549 |  0 | 2007-08-17 |  0 | 
| 1516963 | M | Motrin 800 MG Tablet   | 58864002630 |  1 | 2007-08-23 |  0 | 
| 1516963 | M | Prozac 20 MG Capsule   | 68115071930 |  1 | 2007-08-29 |  0 | 
| 1516963 | M | Meloxicam 7.5 MG Tablet| 68462014001 |  1 | 2007-09-19 | 30 | 
| 1516963 | M | Imitrex 25 MG Tablet   | 58016024609 |  1 | 2007-09-28 | 30 | 
| 1516969 | F | Flomax 0.4 MG Capsule E| 68258910601 |  1 | 2006-10-11 |  0 | 
| 1516969 | F | Flomax 0.4 MG Capsule E| 68258910601 |  1 | 2006-10-11 |  0 | 
| 1516969 | F | Vicodin ES 750-7.5 MG T|    74197354 |  1 | 2006-10-20 |  0 | 
| 1516969 | F | Hydrocodone-Acetaminoph| 68387023560 |  3 | 2007-04-23 | 10 | 
| 1516969 | F | Hydrocodone-Acetaminoph| 68387023560 |  3 | 2007-04-23 | 10 | 
| 1516969 | F | Hydrocodone-Acetaminoph| 68387030090 |  1 | 2007-05-10 | 10 | 
| 1516969 | F | Hydrocodone-Acetaminoph| 68387023560 |  3 | 2007-05-21 | 10 | 
| 1516969 | F | Flomax 0.4 MG Capsule E| 68258910601 |  1 | 2007-07-16 |  5 | 
| 1516969 | F | Hydrocodone-Acetaminoph| 68387030090 |  1 | 2007-07-24 | 10 | 
| 1516969 | F | Amoxicillin 200 MG Tabl| 66116067620 |  4 | 2007-07-24 |  4 | 
| 1516969 | F | Amoxicillin 200 MG Tabl| 66116067620 |  4 | 2007-07-24 |  4 | 
| 1516969 | F | Amoxicillin 200 MG Tabl| 66116067620 |  4 | 2007-07-24 |  4 | 
| 1516969 | F | Aricept 10 MG Tablet   | 67544009289 |  1 | 2008-02-01 | 30 | 
| 1516969 | F | Aricept 10 MG Tablet   | 67544009289 |  1 | 2008-02-01 | 30 | 
| 1516982 | F | No Current Medications |           0 |  0 | 2007-08-23 |  0 | 
| 1516986 | M | Captopril 25 MG Tablet | 68115005990 |  1 | 2007-07-16 |  0 | 
| 1516986 | M | Glucophage XR 750 MG Ta|    87606413 |  1 | 2007-07-16 |  0 | 
| 1516986 | M | Glucophage XR 750 MG Ta|    87606413 |  1 | 2007-07-16 |  0 | 
| 1516986 | M | Thyroid 30 MG Tablet   | 66336095160 |  1 | 2007-07-23 | 30 | 
| 1516986 | M | Aspirin 325 MG Tablet  | 90389001751 |  1 | 2007-10-30 | 30 | 
| 1516986 | M | Aspirin 325 MG Tablet  | 90389001751 |  1 | 2007-10-30 | 30 | 
| 1516986 | M | Insulin Syringe 1cc/29G| 38415001529 |  0 | 2007-10-30 |100 | 
| 1516986 | M | Lipitor 10 MG Tablet   | 68115083690 |  1 | 2007-10-30 | 30 | 
| 1516986 | M | Furosemide 40 MG Tablet| 68258101101 |  1 | 2007-12-04 | 30 | 
| 1516986 | M | Atenolol 50 MG Tablet  | 68387053830 |  1 | 2007-12-04 | 30 | 
| 1516986 | M | Metformin HCl 1000 MG T| 68382003010 |  1 | 2007-12-04 | 20 | 
| 1516986 | M | Cipro TABS             | 58016011850 |  0 | 2007-12-18 |  0 | 
| 1516998 | M | Flexeril 10 MG Tablet  | 58016007090 |  1 | 2007-08-23 |  0 | 
| 1516999 | F | Demerol 50 MG/5ML Syrup|    24033206 |  0 | 2007-05-15 |  0 | 
| 1516999 | F | Demerol 50 MG/5ML Syrup|    24033206 |  0 | 2007-05-15 |  0 | 
| 1516999 | F | Celebrex 200 MG Capsule| 68387055260 |  1 | 2007-08-27 | 30 | 
| 1516999 | F | Motrin TABS            | 58864002630 |  0 | 2007-08-27 |  0 | 
| 1517000 | M | Celebrex 200 MG Capsule| 68387055260 |  1 | 2007-01-10 |  0 | 
| 1517000 | M | Celebrex 200 MG Capsule| 68387055260 |  1 | 2007-01-10 |  0 | 
| 1517000 | M | Keflex 500 MG Capsule  | 58016063390 |  1 | 2007-01-11 |  0 | 
| 1517000 | M | Zoloft 50 MG Tablet    | 68115036660 |  2 | 2007-02-20 |  0 | 
| 1517000 | M | Topamax 100 MG Tablet  | 68387055630 |  1 | 2007-02-20 | 90 | 
| 1517000 | M | Cyanocobalamin 1000 MCG| 63323004401 |  0 | 2007-02-20 |  1 | 
| 1517000 | M | Zoloft 50 MG Tablet    | 68115036660 |  2 | 2007-02-20 |  0 | 
| 1517000 | M | Ambien 10 MG Tablet    | 68387048530 |  1 | 2007-02-20 | 30 | 
| 1517000 | M | Ambien 10 MG Tablet    | 68387048530 |  1 | 2007-02-20 | 30 | 
| 1517000 | M | Zoloft 50 MG Tablet    | 68115036660 |  2 | 2007-02-20 |  0 | 
| 1517000 | M | Zoloft 50 MG Tablet    | 68115036660 |  2 | 2007-02-20 |  0 | 
| 1517000 | M | Prozac 20 MG/5ML Soluti|   777512058 |  8 | 2007-04-03 |  0 | 
| 1517000 | M | Prozac 20 MG/5ML Soluti|   777512058 |  8 | 2007-04-03 |  0 | 
| 1517000 | M | Tylenol Allergy Sinus 2| 50580014860 |  1 | 2007-06-29 |  0 | 
| 1517000 | M | Metformin HCl 500 MG Ta| 68382002810 |  1 | 2007-06-29 |  0 | 
| 1517000 | M | Aspirin 81 MG Tablet   | 64393503916 |  0 | 2007-06-29 |  0 | 
| 1517000 | M | Metformin HCl 500 MG Ta| 68382002810 |  1 | 2007-06-29 |  0 | 
| 1517000 | M | Aspirin 81 MG Tablet   | 64393503916 |  0 | 2007-06-29 |  0 | 
| 1517000 | M | Tylenol Allergy Sinus 2| 50580014860 |  1 | 2007-06-29 |  0 | 
| 1517000 | M | Vicodin 5-500 MG Tablet| 58016006390 |  1 | 2007-07-24 |  7 | 
| 1517000 | M | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-24 |  2 | 
| 1517000 | M | Vicodin 5-500 MG Tablet| 58016006390 |  1 | 2007-07-24 |  7 | 
| 1517000 | M | Amoxicillin 200 MG/5ML | 63304096904 |  5 | 2007-07-27 |  0 | 
| 1517000 | M | Amoxicillin 200 MG/5ML | 63304096904 |  5 | 2007-07-27 |  0 | 
| 1517000 | M | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-08-06 |  0 | 
| 1517000 | M | Amoxil CHEW            | 54868447000 |  0 | 2007-08-06 |  0 | 
| 1517000 | M | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-08-06 |  0 | 
| 1517000 | M | Amoxil CHEW            | 54868447000 |  0 | 2007-08-06 |  0 | 
| 1517000 | M | Amoxicillin 125 MG/5ML | 68115090480 |  5 | 2008-01-17 | 30 | 
| 1517026 | F | Paxil 10 MG Tablet     | 68115091930 |  1 | 2007-06-22 |  0 | 
| 1517040 | M | GlipiZIDE 10 MG Tablet | 68258101301 |  1 | 2007-06-01 |  0 | 
| 1517040 | M | Hydrochlorothiazide 12.| 67544100960 |  1 | 2007-06-27 |  0 | 
| 1517166 | M | Amoxicillin 125 MG/5ML | 68115090480 |  0 | 2007-09-18 |  0 | 
| 1517192 | F | Accutane 10 MG Capsule |     4015549 |  1 | 2007-06-25 |  0 | 
| 1517192 | F | Accutane 10 MG Capsule |     4015549 |  1 | 2007-06-25 |  0 | 
| 1517192 | F | Imitrex TABS           | 68115090709 |  0 | 2007-07-27 |  0 | 
| 1517403 | M | Tegretol 100 MG Tablet | 54868123503 |  1 | 2007-10-02 | 30 | 
| 1517403 | M | Tegretol 100 MG Tablet | 54868123503 |  1 | 2007-10-02 | 30 | 
| 1517403 | M | Aspirin 325 MG Tablet  | 90389001751 |  1 | 2007-11-01 | 30 | 
| 1517403 | M | Plavix 75 MG Tablet    | 68115085590 |  1 | 2007-11-01 | 30 | 
| 1517403 | M | Metformin HCl 500 MG Ta| 68382002810 |  2 | 2008-01-03 | 30 | 
| 1517403 | M | Lisinopril 10 MG Tablet| 68387054330 |  1 | 2008-01-03 | 30 | 
| 1517403 | M | Fluoxetine HCl 20 MG Ca| 68387012090 |  2 | 2008-01-03 | 30 | 
| 1517417 | M | Prozac 20 MG/5ML Soluti|   777512058 |  8 | 2007-09-18 |  0 | 
| 1517419 | M | Prozac 20 MG Capsule   | 68115071930 |  1 | 2007-04-05 |  0 | 
| 1517419 | M | Prozac 20 MG Capsule   | 68115071930 |  1 | 2007-04-05 |  0 | 
| 1517419 | M | Clindamycin HCl CAPS   | 68115042109 |  1 | 2007-04-26 |  0 | 
| 1517419 | M | Clindamycin HCl CAPS   | 68115042109 |  1 | 2007-04-26 |  0 | 
| 1517419 | M | Amoxicillin CAPS       | 68387043040 |  0 | 2007-04-26 |  0 | 
| 1517419 | M | Amoxicillin CAPS       | 68387043040 |  0 | 2007-04-26 |  0 | 
| 1517419 | M | Paxil TABS             | 68115091630 |  0 | 2007-05-03 |  0 | 
| 1517419 | M | Paxil TABS             | 68115091630 |  0 | 2007-05-03 |  0 | 
| 1517419 | M | GlipiZIDE 10 MG Tablet | 68258101301 |  1 | 2007-06-25 |  0 | 
| 1517419 | M | Paxil TABS             | 68115091630 |  1 | 2007-06-26 |  0 | 
| 1517419 | M | Paxil TABS             | 68115091630 |  1 | 2007-06-26 |  0 | 
| 1517426 | M | No Current Medications |           0 |  0 | 2007-07-18 |  0 | 
| 1517434 | M | Paxil 10 MG/5ML Suspens|    29321548 |  0 | 2007-06-22 |  0 | 
| 1517435 | M | Motrin 800 MG Tablet   | 58864002630 |  1 | 2007-01-02 |  0 | 
| 1517435 | M | Motrin IB 200 MG Tablet| 50580077074 |  0 | 2007-01-02 |  0 | 
| 1517435 | M | Motrin IB 200 MG Tablet| 50580077074 |  0 | 2007-01-02 |  0 | 
| 1517435 | M | Motrin 800 MG Tablet   | 58864002630 |  1 | 2007-01-02 |  0 | 
| 1517435 | M | Motrin IB 200 MG Tablet| 50580077074 |  0 | 2007-01-02 |  0 | 
| 1517435 | M | Motrin IB 200 MG Tablet| 50580077074 |  0 | 2007-01-02 |  0 | 
| 1517435 | M | Accupril 40 MG Tablet  | 63874005890 |  1 | 2007-01-09 |  0 | 
| 1517435 | M | Accupril 40 MG Tablet  | 63874005890 |  1 | 2007-01-09 |  0 | 
| 1517435 | M | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-16 |  0 | 
| 1517435 | M | Paxil 30 MG Tablet     | 67544027060 |  1 | 2007-07-16 |  0 | 
| 1517441 | F | Glucophage TABS        | 58016055360 |  1 | 2007-07-23 |  0 | 
| 1517441 | F | Glucophage TABS        | 58016055360 |  1 | 2007-07-23 |  0 | 
| 1517441 | F | Ibuprofen 800 MG Tablet| 68387021090 |  1 | 2007-07-24 |  1 | 
| 1517441 | F | YAZ 3-0.02 MG Tablet   | 50419040503 |  1 | 2007-07-24 |  1 | 
| 1517441 | F | Amoxicillin 500 MG Caps| 68387043040 |  1 | 2007-12-28 |  0 | 
| 1517441 | F | Vicodin TABS           | 58016006390 |  1 | 2008-01-07 |  0 | 
| 1517441 | F | Flonase SUSP           | 58016653301 |  0 | 2008-01-07 |  0 | 
| 1517441 | F | Ambien TABS            | 68115083000 |  1 | 2008-01-07 |  0 | 
| 1517441 | F | Paxil 20 MG Tablet     | 68115026730 |  1 | 2008-01-07 | 30 | 
| 1517649 | M | Aspirin 81 MG Tablet   | 64393503916 |  1 | 2007-12-10 | 30 | 
| 1517649 | M | Truvada 200-300 MG Tabl| 61958070101 |  1 | 2007-12-10 | 30 | 
| 1524357 | M | Furosemide 20 MG Tablet| 68387036530 |  1 | 2007-07-02 | 30 | 
| 1524357 | M | Furosemide 20 MG Tablet| 68387036530 |  1 | 2007-07-02 | 30 | 
| 1524357 | M | Morphine Sulfate 10 MG | 63304070601 |  1 | 2007-11-05 |  0 | 
| 1524357 | M | Tylenol 500 MG CAPS    |    45046870 |  0 | 2007-11-05 |  0 | 
+---------+---+------------------------+-------------+----+------------+----+
247 rows in set (0.11 sec)

-- 
-eric

office: +1.617.258.5741 32-G528, MIT, Cambridge, MA 02144 USA
mobile: +1.617.599.3509

(eric@w3.org)
Feel free to forward this message to any list for any purpose other than
email address distribution.

Received on Tuesday, 29 July 2008 12:51:18 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 29 July 2008 12:51:19 GMT