Explanation of Benefits (EOB) and Patient Statements

This dataset provides a comprehensive record of healthcare Explanation of Benefits (EOB) documents and patient billing statements, detailing services rendered, insurance payments, adjustments, patient responsibility, payment history, and outstanding balances. It enables robust analysis of healthcare billing, insurance claims, patient collections, and financial performance for providers and payers.

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

Revenue cycle management and collections optimization

Sample rows

preview · 8 of 100 rows · all 30 columns
eob_idstringstatement_statusstringbalance_duefloatpatient_statestringpatient_idstringpatient_first_namestringpatient_last_namestringpatient_date_of_birthdatepatient_street_addressstringpatient_citystringpatient_postal_codestringpatient_countrystringprovider_idstringprovider_namestringservice_datedateservice_codestringbilled_amountfloatinsurance_paid_amountfloatadjustment_amountfloatpatient_responsibility_amountfloatstatement_idstringstatement_datedatepayment_received_amountfloatpayment_received_datedateinsurance_plan_idstringinsurance_plan_namestringclaim_numberstringdenial_codestringdenial_reasonstringservice_descriptionstring
EOB1001paid0ILPAT2001EmilyStevens1986-05-14342 Oak AveSpringfield62704USAPROV3001Springfield Medical Group2024-03-11992131501102020STMT40012024-03-18202024-03-22INS5001Aetna POSCLM6001blankblankOffice/outpatient visit, established patient
EOB1002paid0OHPAT2002MichaelNguyen1972-11-30789 Chestnut RdColumbus43215USAPROV3002Ohio Family Clinic2024-02-19800537560105STMT40022024-02-2652024-03-05INS5002UnitedHealthcare SelectCLM6002blankblankComprehensive metabolic panel
EOB1003paid0TXPAT2003SophiaGarcia2001-06-21105 Spruce BlvdSan Antonio78205USAPROV3003Alamo Health2024-04-029300095701510STMT40032024-04-09102024-04-15INS5003BlueCross BlueShield TXCLM6003blankblankElectrocardiogram, routine ECG with interpretation
EOB1004unpaid25WIPAT2004DavidSmith1959-09-09222 Willow DrMadison53703USAPROV3004Madison Cardiology Assoc2024-01-15992142051503025STMT40042024-01-220blankINS5004Humana Gold PlusCLM6004blankblankOffice/outpatient visit, established patient, moderate complexity
EOB1005partial payment5WAPAT2005LindaPark1982-03-0388 Lakeview CtSeattle98101USAPROV3005Seattle Primary Care2024-04-20810023520510STMT40052024-04-2752024-05-02INS5005Kaiser Permanente NWCLM6005blankblankUrinalysis, non-automated, without microscopy
EOB1006paid0COPAT2006JamesLee1993-12-19444 Cypress StDenver80203USAPROV3006Denver Health Center2024-03-2636415201523STMT40062024-04-0232024-04-10INS5006Cigna Open AccessCLM6006blankblankRoutine venipuncture
EOB1007unpaid5CAPAT2007AvaWaters2011-07-2617 Pine StLos Angeles90012USAPROV3007LA Pediatric Group2024-05-0190471504055STMT40072024-05-080blankINS5007Anthem Blue Cross CACLM6007blankblankImmunization administration
EOB1008partial payment25AZPAT2008OliverBrown1967-10-05301 Maple LanePhoenix85004USAPROV3008Phoenix Wellness Center2024-02-097045065050010050STMT40082024-02-16252024-02-20INS5008Aetna Choice POS IICLM6008blankblankCT scan head/brain without contrast

What the 100 rows show

from the 100-row sample

Unpaid (statement status) stands out: mean balance_due is 17.1, against 2.4 for the rest.

  • 5median balance_due
  • 26service codes
  • 120median billed_amount
  • 90median insurance_paid_amount
  • 25median adjustment_amount
  • 12.5median patient_responsibility_amount
Mean balance_due by statement_status100 rows
010200.0paid48 rows17.1unpaid34 rows8.9partial paym…18 rows
balance_due100 rows, in bands of 5
025504910195592102040balance_due →

Median 5, from 0 to 40.

patient_state100 rows · top 10 of 37 values
  1. TX11
  2. CA10
  3. FL7
  4. OH5
  5. WI4
  6. OR4
  7. NC4
  8. TN4
  9. MO4
  10. IL3
30 columns by typefrom the column list below
  • string 20
  • float 6
  • date 4

Columns

30 columns in three groups
blueprint · 30 columns
columntypedescriptionexample
Text 20 columns
eob_idstringUnique identifier for each Explanation of Benefits documentuniqueEOB1001
patient_idstringUnique identifier for the patient associated with the EOB and statementPAT2001
patient_first_namestringPatient's first nameEmily
patient_last_namestringPatient's last nameStevens
patient_street_addressstringPatient's street addressoptional342 Oak Ave
patient_citystringPatient's cityoptionalSpringfield
patient_statestringPatient's stateoptionalIL
patient_postal_codestringPatient's postal codeoptional62704
patient_countrystringPatient's countryoptionalUSA
provider_idstringUnique identifier for the healthcare providerPROV3001
provider_namestringName of the healthcare provider or facilityOhio Family Clinic
service_codestringStandard code for the medical service/procedure (e.g., CPT, HCPCS)99213
service_descriptionstringDescription of the medical service renderedRoutine venipuncture
statement_idstringUnique identifier for the patient billing statementuniqueSTMT4001
insurance_plan_idstringUnique identifier for the insurance planoptionalINS5001
insurance_plan_namestringName of the insurance planoptionalAetna POS
claim_numberstringInsurance claim reference numberoptionalCLM6001
denial_codestringCode indicating reason for claim denial, if applicableoptional
denial_reasonstringDescription of the reason for claim denial, if applicableoptional
statement_statusstringCurrent status of the patient statement (e.g., paid, unpaid, in collections)paid · unpaid · in collections · partial payment · pendingpaid
Numbers 6 columns
billed_amountfloatTotal amount billed for the service0 or more150
insurance_paid_amountfloatAmount paid by insurance for the service0 or more110
adjustment_amountfloatAmount adjusted (discounts, write-offs, contractual adjustments)0 or more · optional20
patient_responsibility_amountfloatAmount the patient is responsible for paying0 or more20
payment_received_amountfloatAmount of payment received from the patient0 or more · optional20
balance_duefloatOutstanding balance due from the patient after payments and adjustments0 or more0
Dates and times 4 columns
patient_date_of_birthdatePatient's date of birthoptional1986-05-14
service_datedateDate when the medical service was rendered2024-03-11
statement_datedateDate the patient billing statement was issued2024-03-18
payment_received_datedateDate payment was received from the patientoptional2024-03-22

Use it for

  • median balance…5100 rowsmean balance due by s…0.0paid17.1unpaid8.9partia…

    A healthcare dashboard

    Balance_due by statement_status and a breakdown of patient_state. Excel, Power BI or Tableau.

  • Why do the 34 unpaid rows have a mean balance_due of 17.1?

    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 eobs with patient_id, patient_first_name and patient_last_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset100 rows30 columns
Yours10,000 rows30 columnspatient_street_address: UK only

blueprint · explanation-of-benefits-eob-and-patient-statements

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 30 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
  • EOB ID unique per insurance payment
  • Service date and provider
  • Billed charges, allowed amount, insurance paid
  • Patient responsibility: deductible, coinsurance, copay, non-covered
  • Claim adjustment reason codes explanations
  • Patient statement consolidates all charges
  • Previous balance, new charges, payments, adjustments
  • Current balance due
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
explanation-of-benefits-eob-and-patient-statements

What should your data show?

Preview 20 rows free
No signup. No card.