Healthcare20 cols · 200 rows
This dataset provides detailed historical sales and inventory records for top pharmacy products, including batch-level expiration and restock information, store locations, and transaction details. It enables precise inventory optimization, demand forecasting, and proactive management of product expirations across multiple pharmacy locations.
| product_name | category | store_name |
|---|
| Ibuprofen 200mg | analgesic | HealthFirst Pharmacy |
| Amoxicillin 500mg | antibiotic | Care Max |
| Vitamin D3 1000IU | supplement | PharmaTrust |
sale_idproduct_idmanufacturer+14 more
Healthcare25 cols · 200 rows
This dataset provides detailed, line-level records of pharmacy retail purchase events, including both over-the-counter and prescription medications. Each record captures transaction details, customer demographics (where available), product specifics, payment method, and prescription information, enabling comprehensive analysis of purchasing patterns, health trends, and market basket behaviors.
| store_name | product_name | product_category |
|---|
| RxMart Downtown | Vitamin D3 Gummies | supplement |
| CareFirst Pharmacy | Ibuprofen Tablets | analgesic |
| MediQuick Central | Metformin HCl | antidiabetic |
transaction_idtransaction_datetimestore_id+19 more
Healthcare23 cols · 200 rows
This dataset provides detailed, location-specific pharmacy inventory records, including product stock levels, demand forecasts, reorder patterns, and risk flags for stockouts and excess inventory. It enables supply chain optimization, predictive analytics, and operational efficiency for pharmacies by integrating product, demand, and location data. Ideal for inventory management, demand planning, and reducing waste in pharmaceutical retail.
| pharmacy_name | product_name | product_category |
|---|
| CityCare Pharmacy | Ibuprofen 200mg Tablets | painkiller |
| EcoPharm Berlin | Metformin XR 500mg | antidiabetic |
| Central Pharmacy | Amoxicillin 500mg Capsules | antibiotic |
pharmacy_idaddress_streetaddress_city+17 more
Healthcare29 cols · 200 rows
This dataset provides detailed records of pharmacy inventory movements, including receipts, dispenses, adjustments, returns, and transfers. Each transaction is linked to pharmacy, product, supplier, and patient entities, with granular tracking of stock levels, costs, and transaction types. Ideal for inventory optimization, demand forecasting, and stockout prevention in healthcare supply chains.
| pharmacy_name | product_name | product_category |
|---|
| Main Street Pharmacy | Metformin Hydrochloride | diabetic |
| Westlake Drugs | Amoxicillin | antibiotic |
| Toronto General Pharmacy | Ibuprofen | analgesic |
transaction_idpharmacy_idpharmacy_street_address+23 more
Healthcare22 cols · 200 rows
This dataset provides comprehensive prescription records, detailing medication names, dosages, refill counts, prescribing doctors, and pharmacy information. It enables robust tracking of medication dispensing, supports compliance auditing, and facilitates analysis of prescribing patterns and pharmacy utilization. Ideal for healthcare providers, researchers, and pharmacy management systems.
| drug_name | doctor_name | pharmacy_name |
|---|
| Metformin Hydrochloride | Dr. Judith Thompson | CVS Pharmacy |
| Azithromycin | Dr. Marcus Ellison | Walgreens |
| Levothyroxine Sodium | Dr. Emily Wu | Rite Aid |
prescription_idpatient_iddosage_amount+16 more
Healthcare21 cols · 130 rows
This dataset provides detailed records of pharmacy medication dispensing events, including fill dates, drug codes, quantities, days supply, prescriber and pharmacy information, and prescription claim statuses. It enables comprehensive tracking of patient medication adherence, refill patterns, and pharmacy operations, making it ideal for clinical research, healthcare analytics, and operational monitoring.
| medication_name | claim_status | prescriber_name |
|---|
| Lisinopril 10mg Tablet | paid | James Carter, MD |
| Metformin 500mg Tablet | paid | Patricia Allen, DO |
| Atorvastatin 20mg Tablet | paid | Kenneth Smith, NP |
dispense_idpharmacy_idpatient_id+15 more
Healthcare22 cols · 200 rows
This dataset provides detailed, transaction-level records of prescription drug purchases across multiple pharmacies, including information on drugs, pharmacies, prescribers, and patient demographics. It is ideal for analyzing purchase trends, forecasting demand, optimizing inventory, and supporting public health research or regulatory oversight. The dataset's granularity enables deep insights into drug utilization patterns and supply chain efficiency.
| pharmacy_name | pharmacy_state | drug_name |
|---|
| Metro City Pharmacy | MA | Atorvastatin |
| Healthwise Drugs | AZ | Amoxicillin |
| Sun Valley Meds | CA | Metformin |
purchase_idpharmacy_idpharmacy_street_address+16 more
Healthcare21 cols · 200 rows
This dataset provides detailed, timestamped logs of patient adherence to prescribed medication regimens, capturing scheduled and actual intake times, adherence status, and reasons for nonadherence. It enables healthcare providers to monitor compliance, identify patterns of missed doses, and design targeted interventions to improve patient outcomes and reduce hospital readmissions.
| patient_first_name | patient_last_name | medication_name |
|---|
| Maria | Lopez | Lisinopril |
| John | Smith | Amlodipine |
| – | – | Insulin Glargine |
adherence_log_idpatient_iddate_of_birth+15 more
Logistics31 cols · 200 rows
This dataset provides comprehensive, transaction-level records of pharmaceutical inventory supply chains, including order placement, shipment tracking, and storage history at destination facilities. It enables detailed analysis of logistics performance, inventory management, and stockout events, supporting optimization and risk mitigation in pharmaceutical distribution networks.
| supplier_name | product_name | order_status |
|---|
| Global Pharma Inc. | Atorvastatin Calcium Tablets | delivered |
| Northway Biologics Ltd. | Influenza Vaccine Quadrivalent | shipped |
| Cardio Health Solutions | Metoprolol Tartrate Tablets | delivered |
order_idorder_datesupplier_id+25 more
Healthcare28 cols · 200 rows
This dataset provides a comprehensive view of pharmacy inventory, combining historical sales and replenishment data with predictive stock needs for each product and location. It enables pharmacies to optimize inventory levels, reduce stockouts, and improve operational efficiency by leveraging data-driven forecasting. The dataset includes detailed product, supplier, and location information for robust analytics and compliance.
| pharmacy_name | product_name | product_category |
|---|
| Central City Pharmacy | Acetaminophen Extra Strength | Analgesic |
| Riverside Wellness Rx | Vitamin D3 2000 IU | Supplement |
| MountainView Rx | Metformin Hydrochloride | Antidiabetic |
inventory_idpharmacy_idpharmacy_street_address+22 more
Logistics22 cols · 100 rows
This dataset provides granular, real-time logs of temperature and humidity conditions for pharmaceutical shipments in the cold chain, including compliance status, alerting, and geolocation data. It enables supply chain stakeholders to monitor medication integrity, ensure regulatory compliance, and optimize logistics for temperature-sensitive products. The rich contextual fields support spoilage prevention, route analysis, and auditability for high-value pharmaceutical deliveries.
| medication_name | compliance_status | alert_flag |
|---|
| Insulin Glargine | compliant | false |
| Insulin Glargine | non-compliant | true |
| Adalimumab | compliant | false |
log_idshipment_idcontainer_id+16 more