The Medications section is the patient's medication list. Each row has the drug (a generic name), the dose with its unit (40 mg, 20 units), the route, the frequency and a status:
- active: the patient is taking it now.
- completed: a course that ran to its planned end, such as ten days of an antibiotic.
- discontinued: stopped before its planned end.
Only active rows are current medications on the day the data was pulled, and an as-needed drug that is active is current too. For an earlier date, use start_date and end_date: a drug was being taken on a date if it had started and had not yet ended, whatever its status says today.
Routes and frequencies are stored as words: PO (by mouth, from the Latin per os), inhaled, subcutaneous (injected under the skin); daily, twice daily, at bedtime, every 4 hours as needed. A filter has to match the stored text exactly, so read it before you query.
Drug, dose, route, frequency, status.