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.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Detecting unusual or potentially non-compliant prescribing patterns

Sample rows

preview · 8 of 200 rows · all 20 columns
prescription_idstringpayment_typestringrefill_countintegeris_high_risk_drugbooleanprescriber_statestringprescription_datedatepatient_idstringpatient_genderstringpatient_birth_datedatepatient_zip_codestringprescriber_idstringprescriber_specialtystringdrug_namestringdrug_classstringdosage_strengthstringdosage_formstringquantity_dispensedintegerdays_supplyintegerprescription_statusstringdiagnosis_codestring
RX100001insurance2falseNY2023-01-12PT001female1986-05-2210011DR001Internal MedicineSertralineSSRI Antidepressant50mgtablet3030filledF33.1
RX100002insurance3falseFL2022-11-18PT002male1952-02-1433162DR002CardiologyAtorvastatinHMG-CoA Reductase Inhibitor20mgtablet9090filledE78.5
RX100003insurance1trueIL2024-02-28PT003other2003-09-1160611DR003PsychiatryQuetiapineAtypical Antipsychotic100mgtablet6030filledF20.9
RX100004insurance2falseWA2023-05-07PT004female1995-07-0498109DR004Family MedicineMetforminBiguanide500mgtablet6030filledE11.9
RX100005insurance1falseMA2022-10-12PT005male2015-01-1902139DR005PediatricsAmoxicillinPenicillin Antibiotic250mg/5mLsuspension9010filledJ02.9
RX100006government2truePA2021-12-12PT006unknown1962-08-3015213DR006RheumatologyMethotrexateAntimetabolite7.5mgtablet428filledM05.79
RX100007insurance2trueCA2023-10-30PT007female1978-03-1290210DR007EndocrinologyInsulin GlargineLong-acting Insulin100U/mLinjection1030filledE11.65
RX100008insurance0falseTX2023-11-02PT008female2018-08-1577005DR008PediatricsAlbuterolBeta-2 Agonist0.083%inhaler115filledJ45.909

What the 200 rows show

from the 200-row sample

Government (payment type) stands out: mean refill_count is 4.8, against 1.2 for the rest.

  • 31%is_high_risk_drug = true
  • 1median refill_count
  • 4patient genders
  • 4prescription statuses
  • 7dosage forms
  • 11prescriber specialties
Mean refill_count by payment_type200 rows
0481.3insurance149 rows1.3cash8 rows4.8governme…37 rows0.33other6 rows
refill_count200 rows, in bands of 2
05511010570117340612refill_count →

Median 1, from 0 to 11.

prescriber_state200 rows · top 10 of 15 values
  1. MA25
  2. IL23
  3. NY22
  4. CA22
  5. PA20
  6. FL19
  7. TX18
  8. WA14
  9. OH11
  10. CO11
20 columns by typefrom the column list below
  • string 14
  • integer 3
  • date 2
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 14 columns
prescription_idstringUnique identifier for each prescription eventuniqueRX100001
patient_idstringUnique identifier for the patient receiving the prescriptionPT001
patient_genderstringGender of the patientmale · female · other · unknownfemale
patient_zip_codestringPostal code of the patient's residenceoptional10011
prescriber_idstringUnique identifier for the prescriber (doctor or provider)DR001
prescriber_specialtystringMedical specialty of the prescriber11 specialtiesInternal Medicine
prescriber_statestringState where the prescriber practicesoptionalNY
drug_namestringName of the prescribed drug (generic or brand)Sertraline
drug_classstringTherapeutic class or category of the drugoptionalSSRI Antidepressant
dosage_strengthstringStrength of the medication (e.g., 500mg, 10mg/mL)optional50mg
dosage_formstringForm of the medication (e.g., tablet, capsule, injection)7 forms · optionaltablet
prescription_statusstringCurrent status of the prescription (e.g., filled, cancelled, pending)filled · cancelled · pending · expiredfilled
diagnosis_codestringPrimary diagnosis code (e.g., ICD-10) associated with the prescriptionoptionalF33.1
payment_typestringType of payment used for the prescription (e.g., insurance, cash, government)insurance · cash · government · other · optionalinsurance
Numbers 3 columns
quantity_dispensedintegerNumber of units dispensed in this prescription1 or more30
days_supplyintegerNumber of days the prescription is intended to last1 or more30
refill_countintegerNumber of refills authorized for this prescription0 or more · optional2
Dates and times 2 columns
prescription_datedateDate when the prescription was issued2023-01-12
patient_birth_datedateBirth date of the patient1986-05-22
True or false 1 column
is_high_risk_drugbooleanIndicates if the prescribed drug is classified as high risk (e.g., opioid, controlled substance)optionalfalse

Use it for

  • is high risk d…31%62 of 200 rowsmean refill count by …1.3insu…1.3cash4.8gove…0.33other

    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.

  • A software demo

    Believable prescriptions with prescription_date, patient_id and patient_gender to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows20 columns
Yours1,000 rows20 columnspatient_zip_code: UK only

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.

Rules it was built with
  • 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
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.