Pharmacy Dispensing and Fill History

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.

  • opened 5 times
  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Medication adherence monitoring for patients

Sample rows

preview · 8 of 130 rows · all 21 columns
dispense_idstringclaim_statusstringquantity_dispensedintegeradherence_flagbooleanpharmacy_namestringpharmacy_idstringpatient_idstringprescription_idstringprescriber_idstringfill_datedatendcstringmedication_namestringdays_supplyintegerrefill_numberintegerclaim_idstringprescriber_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_statestringpharmacy_postal_codestringpharmacy_countrystring
D0000001paid30trueCentral PharmacyPHX01PT1001RX10001DR20012023-01-0300093051230Lisinopril 10mg Tablet300CLM0001James Carter, MD123 Main StColumbusOH43215USA
D0000002paid90trueEastside PharmacyPHX02PT1002RX10002DR20022023-02-0400185007201Metformin 500mg Tablet900CLM0002Patricia Allen, DO456 Broad AveHoustonTX77002USA
D0000003paid30trueWest End DrugstorePHX03PT1003RX10003DR20032023-03-1500078065605Atorvastatin 20mg Tablet300CLM0003Kenneth Smith, NP789 Oak StNewarkNJ07102USA
D0000004paid30trueCentral PharmacyPHX01PT1001RX10001DR20012023-02-0300093051230Lisinopril 10mg Tablet301CLM0004James Carter, MD123 Main StColumbusOH43215USA
D0000005paid30trueCentral PharmacyPHX01PT1001RX10001DR20012023-03-0500093051230Lisinopril 10mg Tablet302CLM0005James Carter, MD123 Main StColumbusOH43215USA
D0000006paid90trueNorthside PharmacyPHX04PT1004RX10004DR20042023-01-1200054045725Gabapentin 300mg Capsule900CLM0006Rebecca Lee, PA135 Elm StChicagoIL60601USA
D0000007paid90trueNorthside PharmacyPHX04PT1004RX10004DR20042023-04-1200054045725Gabapentin 300mg Capsule901CLM0007Rebecca Lee, PA135 Elm StChicagoIL60601USA
D0000008paid90falseRiver City RxPHX05PT1005RX10005DR20052023-02-1500781504101Levothyroxine 50mcg Tablet900CLM0008Nancy Wood, MD200 River RdClevelandOH44114USA

What the 130 rows show

from the 130-row sample

Paid (claim status) stands out: 51 of its 77 rows have adherence_flag = true, against 0 of 17 for the rest.

  • 54%adherence_flag = true
  • 30median quantity_dispensed
  • 10pharmacy states
  • 23pharmacy cities
  • 27pharmacy postal codes
  • 32pharmacy street addresses
Adherence flag rate by claim_statusadherence_flag = true
0%50%100%66%paid51 of 770%rejected0 of 17
quantity_dispensed130 rows, in bands of 100
06012011900004000705001,000quantity_dispensed →

Median 30, from 1 to 1,000.

pharmacy_name113 rows with a value · 17 left blank
  1. Central Pharmacy7
  2. Southtown Pharmacy7
  3. Eastside Pharmacy6
  4. UrgentCare Rx6
  5. Heritage Drugstore6
  6. Northside Rx6
  7. Central Urban Pharmacy6
  8. River City Rx5
  9. Greenview Pharmacy5
  10. Green Valley Pharmacy4
21 columns by typefrom the column list below
  • string 16
  • integer 3
  • date 1
  • boolean 1

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 16 columns
dispense_idstringUnique identifier for each medication dispensing eventuniqueD0000001
pharmacy_idstringUnique identifier for the pharmacy where the medication was dispensedPHX01
patient_idstringUnique identifier for the patient receiving the medicationPT1001
prescription_idstringUnique identifier for the prescription associated with the dispensing eventRX10001
prescriber_idstringUnique identifier for the prescriber who authorized the prescriptionDR2001
ndcstringNational Drug Code (NDC) for the medication dispensed00093051230
medication_namestringName of the medication dispensedLisinopril 10mg Tablet
claim_idstringUnique identifier for the prescription claim associated with this dispensing eventoptionalCLM0001
claim_statusstringStatus of the prescription claim (e.g., paid, rejected, pending)paid · rejected · pending · other · optionalpaid
prescriber_namestringFull name of the prescriberoptionalJames Carter, MD
pharmacy_namestringName of the pharmacy where the medication was dispensedoptionalCentral Pharmacy
pharmacy_street_addressstringStreet address of the pharmacyoptional123 Main St
pharmacy_citystringCity where the pharmacy is locatedoptionalColumbus
pharmacy_statestringState where the pharmacy is located10 states · optionalOH
pharmacy_postal_codestringPostal code of the pharmacyoptional43215
pharmacy_countrystringCountry where the pharmacy is locatedoptionalUSA
Numbers 3 columns
quantity_dispensedintegerNumber of units dispensed in this event1 or more30
days_supplyintegerNumber of days the dispensed quantity is intended to last1 or more30
refill_numberintegerThe sequential number of the refill for this prescription (0 for original fill)0 or more0
Dates and times 1 column
fill_datedateDate the medication was dispensed to the patient2023-01-03
True or false 1 column
adherence_flagbooleanIndicates if the dispensing event is considered adherent to prescribed therapyoptionaltrue

Use it for

  • adherence flag54%51 of 94 rowsmean quantity dispens…169.5paid40.6reje…9.7pend…4.9other

    A healthcare dashboard

    The adherence_flag rate, quantity_dispensed by claim_status and a breakdown of pharmacy_name. Excel, Power BI or Tableau.

  • Why do 51 of 94 rows have adherence_flag = true?

    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 dispenses with pharmacy_id, patient_id and prescription_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 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 dataset130 rows21 columns
Yours1,000 rows21 columnspharmacy_street_address: UK only

blueprint · pharmacy-dispensing-and-fill-history

Behind this dataset

Same schema. As many rows as you need.

These 130 rows came out of a blueprint — 21 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
  • Dispensing ID unique per fill
  • Prescription reference number
  • Fill date and refill number (0 for initial, 1+ for refills)
  • NDC code for drug dispensed (specific manufacturer)
  • Quantity dispensed and days supply
  • Prescriber verification and override if substitution
  • Generic substitution if applicable (DAW codes)
  • Patient pickup vs delivery
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
pharmacy-dispensing-and-fill-history

More in Healthcare

Browse all
Also in HealthcareDrug Prescription Adherence RecordsPharmacy Retail Purchase EventsEmergency Department Triage PatternsAll 1,966 datasets
In collectionsPharmacy and Prescription Datasets

What should your data show?

Preview 20 rows free
No signup. No card.