- 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 UTC