Healthcare24 columns
E-Prescribing and Medication Orders
This dataset provides comprehensive electronic prescription records, including detailed medication information, standardized RxNorm codes, prescriber and pharmacy identifiers, and SCRIPT message tracking for order and dispensing events. It enables robust analysis of prescribing patterns, medication safety, and pharmacy workflow optimization, supporting interoperability across healthcare systems.
opened 1 timeslast updated 4 Dec 2025by GoMask
The brief that made it
Medication safety and adherence analysis
Blueprint
blueprint · 24 columns
| column | type | description |
|---|---|---|
| prescription_id | string | Unique identifier for each electronic prescription record |
| patient_id | string | Unique identifier for the patient receiving the medication |
| drug_name | string | Name of the prescribed drug or medication |
| rxnorm_code | string | Standardized RxNorm code for the prescribed medication |
| dose_amount | float | Amount of drug per dose |
| dose_unit | string | Unit of measurement for the dose (e.g., mg, mL, tablet) |
| frequency | string | How often the medication should be taken (e.g., 'once daily', 'q8h') |
| quantity | integer | Total quantity of medication to be dispensed |
| refills | integer | Number of authorized refills for the prescription |
| prescriber_id | string | Unique identifier for the healthcare provider who prescribed the medication |
| prescriber_name | string | Full name of the prescriber |
| prescriber_npi | string | National Provider Identifier (NPI) for the prescriber |
| pharmacy_id | string | Unique identifier for the pharmacy where the prescription is sent |
| pharmacy_name | string | Name of the pharmacy |
| pharmacy_street_address | string | Street address of the pharmacy |
| pharmacy_city | string | City where the pharmacy is located |
| pharmacy_state | string | State where the pharmacy is located |
| pharmacy_postal_code | string | Postal code of the pharmacy |
| pharmacy_country | string | Country where the pharmacy is located |
| script_message_type | string | Type of SCRIPT message (e.g., 'NewRx', 'RefillRequest', 'CancelRx', 'RxChangeRequest') |
| script_message_id | string | Unique identifier for the SCRIPT message |
| script_message_datetime | datetime | Date and time when the SCRIPT message was sent |
| dispense_date | date | Date when the medication was dispensed by the pharmacy |
| notes | string | Additional notes or instructions related to the prescription |
Sample rows
preview · 4 of 120 rows
| prescription_id | patient_id | drug_name | rxnorm_code | dose_amount |
|---|---|---|---|---|
| RX1001 | P00001 | Simvastatin | 866350 | 40 |
| RX1002 | P00002 | Lisinopril | 290462 | 20 |
| RX1003 | P00003 | Metformin | 860975 | 500 |
| RX1004 | P00004 | Levothyroxine | 197361 | 75 |
Behind this dataset
blueprint · e-prescribing-and-medication-orders
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 24 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
1,000 rows10,000 rows100,000 rows1,000,000 rows
Open the blueprint in Data FactoryFree tier covers your first 1,000 rows.
More in Healthcare
Browse all →Pharmacy Inventory Sales ForecastThis 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.Pharmacy Inventory OptimizationThis 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 Inventory Movement DatasetThis 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.