Healthcare Prescription Pattern Analysis
This dataset provides detailed synthetic records of prescription events, including patient demographics, prescriber characteristics, drug details, and prescription parameters. Designed for healthcare analytics, it enables the identification of unusual prescribing patterns, supports compliance monitoring, and facilitates research into medication usage trends and risk management.
Sample rows
preview · 8 of 200 rows · all 20 columns| prescription_idstring | payment_typestring | refill_countinteger | is_high_risk_drugboolean | prescriber_statestring | prescription_datedate | patient_idstring | patient_genderstring | patient_birth_datedate | patient_zip_codestring | prescriber_idstring | prescriber_specialtystring | drug_namestring | drug_classstring | dosage_strengthstring | dosage_formstring | quantity_dispensedinteger | days_supplyinteger | prescription_statusstring | diagnosis_codestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RX100001 | insurance | 2 | false | NY | 2023-01-12 | PT001 | female | 1986-05-22 | 10011 | DR001 | Internal Medicine | Sertraline | SSRI Antidepressant | 50mg | tablet | 30 | 30 | filled | F33.1 |
| RX100002 | insurance | 3 | false | FL | 2022-11-18 | PT002 | male | 1952-02-14 | 33162 | DR002 | Cardiology | Atorvastatin | HMG-CoA Reductase Inhibitor | 20mg | tablet | 90 | 90 | filled | E78.5 |
| RX100003 | insurance | 1 | true | IL | 2024-02-28 | PT003 | other | 2003-09-11 | 60611 | DR003 | Psychiatry | Quetiapine | Atypical Antipsychotic | 100mg | tablet | 60 | 30 | filled | F20.9 |
| RX100004 | insurance | 2 | false | WA | 2023-05-07 | PT004 | female | 1995-07-04 | 98109 | DR004 | Family Medicine | Metformin | Biguanide | 500mg | tablet | 60 | 30 | filled | E11.9 |
| RX100005 | insurance | 1 | false | MA | 2022-10-12 | PT005 | male | 2015-01-19 | 02139 | DR005 | Pediatrics | Amoxicillin | Penicillin Antibiotic | 250mg/5mL | suspension | 90 | 10 | filled | J02.9 |
| RX100006 | government | 2 | true | PA | 2021-12-12 | PT006 | unknown | 1962-08-30 | 15213 | DR006 | Rheumatology | Methotrexate | Antimetabolite | 7.5mg | tablet | 4 | 28 | filled | M05.79 |
| RX100007 | insurance | 2 | true | CA | 2023-10-30 | PT007 | female | 1978-03-12 | 90210 | DR007 | Endocrinology | Insulin Glargine | Long-acting Insulin | 100U/mL | injection | 10 | 30 | filled | E11.65 |
| RX100008 | insurance | 0 | false | TX | 2023-11-02 | PT008 | female | 2018-08-15 | 77005 | DR008 | Pediatrics | Albuterol | Beta-2 Agonist | 0.083% | inhaler | 1 | 15 | filled | J45.909 |
| RX100009 | government | 4 | true | OH | 2024-03-10 | PT009 | male | 1943-01-05 | 43215 | DR009 | Geriatrics | Donepezil | Cholinesterase Inhibitor | 10mg | tablet | 30 | 30 | filled | G30.9 |
| RX100010 | insurance | 2 | false | NY | 2022-05-26 | PT010 | female | 1983-11-26 | 10011 | DR001 | Internal Medicine | Lisinopril | ACE Inhibitor | 10mg | tablet | 90 | 90 | filled | I10 |
| RX100011 | insurance | 0 | false | MA | 2022-12-15 | PT011 | unknown | 2011-02-29 | blank | DR010 | Pediatrics | Acetaminophen | Analgesic | 160mg/5mL | suspension | 24 | 7 | filled | R50.9 |
| RX100012 | government | 5 | true | CO | 2020-07-07 | PT012 | male | 1955-10-17 | 80203 | DR011 | Cardiology | Warfarin | Anticoagulant | 5mg | tablet | 30 | 30 | filled | I48.91 |
| RX100013 | other | 0 | false | PA | 2021-05-05 | PT013 | female | 2008-10-08 | 19104 | DR012 | Family Medicine | Vitamin K | Vitamin | 10mg/mL | injection | 1 | 1 | filled | blank |
| RX100014 | cash | 2 | true | MA | 2022-03-03 | PT014 | other | 1973-12-31 | 02111 | DR013 | Psychiatry | Clonazepam | Benzodiazepine | 0.5mg | tablet | 30 | 30 | filled | F41.1 |
| RX100015 | insurance | 3 | false | CA | 2024-04-01 | PT015 | female | 1976-06-23 | 90024 | DR004 | Family Medicine | Levothyroxine | Thyroid Hormone | 100mcg | tablet | 90 | 90 | filled | E03.9 |
| RX100016 | insurance | 1 | false | NY | 2023-09-16 | PT016 | male | 2002-04-30 | 10021 | DR014 | Internal Medicine | Fluoxetine | SSRI Antidepressant | 20mg | capsule | 30 | 30 | pending | F32.0 |
| RX100017 | insurance | 0 | false | MA | 2021-07-26 | PT017 | female | 2016-02-20 | blank | DR010 | Pediatrics | Ibuprofen | NSAID | 100mg/5mL | suspension | 20 | 5 | filled | R51 |
| RX100018 | cash | 0 | true | IL | 2021-08-22 | PT018 | unknown | 1980-10-10 | 60616 | DR003 | Psychiatry | Lorazepam | Benzodiazepine | 1mg | tablet | 30 | 15 | cancelled | F41.9 |
| RX100019 | government | 1 | true | DC | 2024-05-11 | PT019 | male | 1970-09-09 | 20001 | DR015 | Oncology | Morphine | Opioid Analgesic | 15mg | tablet | 60 | 30 | pending | C34.90 |
| RX100020 | insurance | 1 | false | TX | 2020-11-30 | PT020 | female | 2005-07-11 | 75205 | DR016 | Family Medicine | Ampicillin | Penicillin Antibiotic | 125mg | capsule | 30 | 10 | filled | J20.9 |
What the 200 rows show
from the 200-row sampleGovernment (payment type) stands out: mean refill_
- 31%is_
high_ risk_ drug = true - 1median refill_
count - 4patient genders
- 4prescription statuses
- 7dosage forms
- 11prescriber specialties
Median 1, from 0 to 11.
- string 14
- integer 3
- date 2
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
prescription_id | string | Unique identifier for each prescription eventunique | RX100001 |
patient_id | string | Unique identifier for the patient receiving the prescription | PT001 |
patient_gender | string | Gender of the patientmale · female · other · unknown | female |
patient_zip_code | string | Postal code of the patient's residenceoptional | 10011 |
prescriber_id | string | Unique identifier for the prescriber (doctor or provider) | DR001 |
prescriber_specialty | string | Medical specialty of the prescriber11 specialties | Internal Medicine |
prescriber_state | string | State where the prescriber practicesoptional | NY |
drug_name | string | Name of the prescribed drug (generic or brand) | Sertraline |
drug_class | string | Therapeutic class or category of the drugoptional | SSRI Antidepressant |
dosage_strength | string | Strength of the medication (e.g., 500mg, 10mg/mL)optional | 50mg |
dosage_form | string | Form of the medication (e.g., tablet, capsule, injection)7 forms · optional | tablet |
prescription_status | string | Current status of the prescription (e.g., filled, cancelled, pending)filled · cancelled · pending · expired | filled |
diagnosis_code | string | Primary diagnosis code (e.g., ICD-10) associated with the prescriptionoptional | F33.1 |
payment_type | string | Type of payment used for the prescription (e.g., insurance, cash, government)insurance · cash · government · other · optional | insurance |
| Numbers 3 columns | |||
quantity_dispensed | integer | Number of units dispensed in this prescription1 or more | 30 |
days_supply | integer | Number of days the prescription is intended to last1 or more | 30 |
refill_count | integer | Number of refills authorized for this prescription0 or more · optional | 2 |
| Dates and times 2 columns | |||
prescription_date | date | Date when the prescription was issued | 2023-01-12 |
patient_birth_date | date | Birth date of the patient | 1986-05-22 |
| True or false 1 column | |||
is_high_risk_drug | boolean | Indicates if the prescribed drug is classified as high risk (e.g., opioid, controlled substance)optional | false |
Use it for
A healthcare dashboard
The is_
high_ risk_ drug rate, refill_ count by payment_ type and a breakdown of prescriber_ state. Excel, Power BI or Tableau. Why do the 37 government rows have a mean refill_
count of 4.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Prescriptions200RX1000012insuranceRX1000031insuranceRX1000062governme…
A software demo
Believable prescriptions with prescription_
date, patient_ id and patient_ gender to fill a screen in front of a buyer.
blueprint · healthcare-prescription-pattern-analysis
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 20 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.
- Each row: prescription for a drug to a patient
- Includes drug class, dosage, frequency
- Prescriber and patient demographics randomized
- Flag high-risk combinations
- Prescription channel (in-person, telehealth) included
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- healthcare-prescription-pattern-analysis