Sample prescriptions data
Medication prescriptions with drug details, dosing, and pharmacy information
Free to download, no account needed for the 1k-row files below.
Larger sizes — up to 1M rows — need a free account.
This is synthetic data: it looks realistic and refers to nobody, so it
carries none of the data-protection risk of copying production records into a test system.
Downloads
| Size | Format | Locale |
|---|---|---|
| 1k rows | csv | de_DE en_GB en_US es_ES fr_FR ja_JP |
| 1k rows | jsonl | de_DE en_GB en_US es_ES fr_FR ja_JP |
| 1k rows | parquet | de_DE en_GB en_US es_ES fr_FR ja_JP |
| 10k rows | csv | free account (6 locales) |
| 10k rows | jsonl | free account (6 locales) |
| 10k rows | parquet | free account (6 locales) |
| 100k rows | csv | free account (6 locales) |
| 100k rows | jsonl | free account (6 locales) |
| 100k rows | parquet | free account (6 locales) |
| 500k rows | csv | free account (2 locales) |
| 500k rows | jsonl | free account (2 locales) |
| 500k rows | parquet | free account (2 locales) |
| 1M rows | csv | free account (2 locales) |
| 1M rows | jsonl | free account (2 locales) |
Columns
| Column | Type | |
|---|---|---|
id | id | always set |
rx_number | sequence | always set |
patient_id | foreign_key | always set |
encounter_id | foreign_key | optional |
medication_name | zipfian_choice | always set |
drug_class | constant | always set |
ndc_code | regex | always set |
strength | weighted_choice | always set |
dosage_form | weighted_choice | always set |
route | weighted_choice | always set |
frequency | weighted_choice | always set |
quantity | weighted_choice | always set |
days_supply | weighted_choice | always set |
refills_authorized | weighted_choice | always set |
refills_remaining | integer | always set |
prescriber_name | name | always set |
prescriber_npi | regex | always set |
prescriber_dea | regex | optional |
pharmacy_name | weighted_choice | always set |
pharmacy_npi | regex | always set |
daw_code | weighted_choice | always set |
is_controlled | weighted_choice | always set |
schedule | weighted_choice | always set |
written_date | date | always set |
filled_date | date | optional |
expiration_date | date | always set |
instructions | weighted_choice | always set |
status | weighted_choice | always set |
notes | sentence | optional |
created_at | datetime | always set |
updated_at | datetime | always set |
Need a different shape?
Generate this dataset with your own columns, row counts and locales, or browse the full catalogue of 88 ready-made files for this template alone.