Prescription Drug Price Tracking

This dataset provides a comprehensive record of prescription drug prices across multiple pharmacies, including detailed drug identifiers, pharmacy locations, pricing, insurance acceptance, and discount availability. It enables robust cost analysis, price comparison, and supports healthcare networks in optimizing pricing strategies and improving patient access to affordable medications.

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

Comparing prescription drug prices across pharmacies for cost transparency

Sample rows

preview · 8 of 200 rows · all 22 columns
price_idstringdata_sourcestringpricefloatdiscount_availablebooleanpackage_sizestringdrug_ndcstringdrug_namestringdosage_formstringstrengthstringpharmacy_idstringpharmacy_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_statestringpharmacy_postal_codestringpharmacy_countrystringcurrencystringinsurance_acceptedbooleanprice_effective_datedateprice_expiry_datedatelast_updateddatetimediscount_detailsstring
PRC-00001website12.99true30 tablets12345-6789-01Atorvastatintablet20mgPHM-001Walgreens123 Main StChicagoIL60601USAUSDtrue2023-12-01blank2023-12-01T08:34:37$4 Generic Program for select medications
PRC-00002flyer10true90 tablets54321-1234-10Metformintablet500mgPHM-002CVS Pharmacy456 Elm AveBostonMA02116USAUSDtrue2023-11-152024-05-152023-11-16T10:22:19$10 for 90 day supply with CVS Savings card
PRC-00003website4true30 tablets23456-7890-05Lisinopriltablet10mgPHM-003Walmart Pharmacy789 Oak DrDallasTX75201USAUSDtrue2023-10-10blank2023-10-10T11:10:05$4 generic prescription program
PRC-00004flyer0true30 tablets11111-2222-01Simvastatintablet40mgPHM-004Publix12 Sunrise BlvdMiamiFL33101USAUSDtrue2023-09-20blank2023-09-20T13:12:41Free Medication Program for select statins
PRC-00005website9.99false30 tablets33333-4444-02Sertralinetablet50mgPHM-005Rite Aid87 Center RdPittsburghPA15222USAUSDtrue2024-01-032024-07-032024-01-02T16:19:02blank
PRC-00006website15.5false42 capsules87654-3210-15Omeprazolecapsule20mgPHM-006Costco Pharmacy500 Costco WaySeattleWA98101USAUSDfalse2024-02-012024-08-012024-02-01T14:08:56blank
PRC-00007website10true90 tablets22222-3333-07Amlodipinetablet5mgPHM-007Kroger Pharmacy100 Market AveColumbusOH43215USAUSDtrue2023-12-172024-06-172023-12-18T09:09:43$10 for 90-day supply with Kroger Rx Savings
PRC-00008direct report8.99false30 tablets44444-5555-03Levothyroxinetablet75mcgPHM-008Albertsons200 State StBoiseID83702USAUSDtrue2023-10-222024-04-222023-10-23T16:15:00blank

What the 200 rows show

from the 200-row sample

Flyer (data source) stands out: 12 of its 17 rows have discount_available = true, against 41 of 183 for the rest.

  • 27%discount_available = true
  • 12.5median price
  • 7dosage forms
  • 13pharmacy countries
  • 13currencies
  • 44strengths
Discount available rate by data_sourcediscount_available = true
0%50%100%28%webs…38 of…7%dire…2 of …71%flyer12 of…0%hosp…0 of …0%syst…0 of 70%spec…0 of 2100%memb…1 of 1
price200 rows, in bands of 10k
0100200196000000004050k100kprice →

Median 12.5, from 0.0 to 100,000.

package_size200 rows · top 10 of 29 values
  1. 30 tablets69
  2. 60 tablets20
  3. 28 tablets19
  4. 90 tablets15
  5. 30 capsules10
  6. 1 inhaler9
  7. 28 capsules6
  8. 60 capsules5
  9. 10 mL5
  10. 100 tablets5
22 columns by typefrom the column list below
  • string 16
  • float 1
  • date 2
  • datetime 1
  • boolean 2

Columns

22 columns in four groups
blueprint · 22 columns
columntypedescriptionexample
Text 16 columns
price_idstringUnique identifier for each recorded drug price entryuniquePRC-00001
drug_ndcstringNational Drug Code (NDC) identifying the specific drug and formulation12345-6789-01
drug_namestringBrand or generic name of the prescription drugAtorvastatin
dosage_formstringForm of the drug (e.g., tablet, capsule, solution)7 formstablet
strengthstringStrength of the drug (e.g., 500mg, 10mg/5mL)20mg
package_sizestringSize or quantity of the drug package (e.g., 30 tablets, 100 mL)optional30 tablets
pharmacy_idstringUnique identifier for the pharmacy locationPHM-001
pharmacy_namestringName of the pharmacyWalgreens
pharmacy_street_addressstringStreet address of the pharmacy123 Main St
pharmacy_citystringCity where the pharmacy is locatedChicago
pharmacy_statestringState or province of the pharmacy locationIL
pharmacy_postal_codestringPostal or ZIP code of the pharmacy60601
pharmacy_countrystringCountry where the pharmacy is locatedUSA
currencystringCurrency code for the price (e.g., USD, EUR)USD
discount_detailsstringDetails about the discount or coupon (if applicable)optional$4 generic program
data_sourcestringSource from which the price data was obtained (e.g., website, direct report)7 sources · optionalwebsite
Numbers 1 column
pricefloatRetail price of the drug at the pharmacy for the specified package0 or more12.99
Dates and times 3 columns
price_effective_datedateDate when the price was recorded or became effective2023-12-01
price_expiry_datedateDate when the price is no longer valid (if known)optional2024-05-15
last_updateddatetimeTimestamp of the most recent update to this price record2023-12-01T08:34:37
True or false 2 columns
insurance_acceptedbooleanIndicates whether the price is available with insurance coveragetrue
discount_availablebooleanIndicates if any discount or coupon is available for this priceoptionaltrue

Use it for

  • discount avail…27%53 of 200 rowsmean price by data so…18.8webs…25.5dire…7.3flyer18.3khosp…

    A healthcare dashboard

    The discount_available rate, price by data_source and a breakdown of package_size. Excel, Power BI or Tableau.

  • Why do 53 of 200 rows have discount_available = 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 prices with drug_ndc, drug_name and dosage_form to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 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 rows22 columns
Yours1,000 rows22 columnspharmacy_street_address: UK only

blueprint · prescription-drug-price-tracking

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 22 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 record represents a unique pharmacy and drug combination.
  • Prices updated monthly per pharmacy.
  • Includes insurance and uninsured pricing columns.
  • Captures drug formulation and dosage details.
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
prescription-drug-price-tracking

More in Healthcare

Browse all
Also in HealthcarePrescription Adherence TrackingPharmacy Retail Purchase EventsHealthcare-Insurance Claims IntegrationAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.