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.
Sample rows
preview · 8 of 100 rows · all 30 columns| eob_idstring | statement_statusstring | balance_duefloat | patient_statestring | patient_idstring | patient_first_namestring | patient_last_namestring | patient_date_of_birthdate | patient_street_addressstring | patient_citystring | patient_postal_codestring | patient_countrystring | provider_idstring | provider_namestring | service_datedate | service_codestring | billed_amountfloat | insurance_paid_amountfloat | adjustment_amountfloat | patient_responsibility_amountfloat | statement_idstring | statement_datedate | payment_received_amountfloat | payment_received_datedate | insurance_plan_idstring | insurance_plan_namestring | claim_numberstring | denial_codestring | denial_reasonstring | service_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EOB1001 | paid | 0 | IL | PAT2001 | Emily | Stevens | 1986-05-14 | 342 Oak Ave | Springfield | 62704 | USA | PROV3001 | Springfield Medical Group | 2024-03-11 | 99213 | 150 | 110 | 20 | 20 | STMT4001 | 2024-03-18 | 20 | 2024-03-22 | INS5001 | Aetna POS | CLM6001 | blank | blank | Office/outpatient visit, established patient |
| EOB1002 | paid | 0 | OH | PAT2002 | Michael | Nguyen | 1972-11-30 | 789 Chestnut Rd | Columbus | 43215 | USA | PROV3002 | Ohio Family Clinic | 2024-02-19 | 80053 | 75 | 60 | 10 | 5 | STMT4002 | 2024-02-26 | 5 | 2024-03-05 | INS5002 | UnitedHealthcare Select | CLM6002 | blank | blank | Comprehensive metabolic panel |
| EOB1003 | paid | 0 | TX | PAT2003 | Sophia | Garcia | 2001-06-21 | 105 Spruce Blvd | San Antonio | 78205 | USA | PROV3003 | Alamo Health | 2024-04-02 | 93000 | 95 | 70 | 15 | 10 | STMT4003 | 2024-04-09 | 10 | 2024-04-15 | INS5003 | BlueCross BlueShield TX | CLM6003 | blank | blank | Electrocardiogram, routine ECG with interpretation |
| EOB1004 | unpaid | 25 | WI | PAT2004 | David | Smith | 1959-09-09 | 222 Willow Dr | Madison | 53703 | USA | PROV3004 | Madison Cardiology Assoc | 2024-01-15 | 99214 | 205 | 150 | 30 | 25 | STMT4004 | 2024-01-22 | 0 | blank | INS5004 | Humana Gold Plus | CLM6004 | blank | blank | Office/outpatient visit, established patient, moderate complexity |
| EOB1005 | partial payment | 5 | WA | PAT2005 | Linda | Park | 1982-03-03 | 88 Lakeview Ct | Seattle | 98101 | USA | PROV3005 | Seattle Primary Care | 2024-04-20 | 81002 | 35 | 20 | 5 | 10 | STMT4005 | 2024-04-27 | 5 | 2024-05-02 | INS5005 | Kaiser Permanente NW | CLM6005 | blank | blank | Urinalysis, non-automated, without microscopy |
| EOB1006 | paid | 0 | CO | PAT2006 | James | Lee | 1993-12-19 | 444 Cypress St | Denver | 80203 | USA | PROV3006 | Denver Health Center | 2024-03-26 | 36415 | 20 | 15 | 2 | 3 | STMT4006 | 2024-04-02 | 3 | 2024-04-10 | INS5006 | Cigna Open Access | CLM6006 | blank | blank | Routine venipuncture |
| EOB1007 | unpaid | 5 | CA | PAT2007 | Ava | Waters | 2011-07-26 | 17 Pine St | Los Angeles | 90012 | USA | PROV3007 | LA Pediatric Group | 2024-05-01 | 90471 | 50 | 40 | 5 | 5 | STMT4007 | 2024-05-08 | 0 | blank | INS5007 | Anthem Blue Cross CA | CLM6007 | blank | blank | Immunization administration |
| EOB1008 | partial payment | 25 | AZ | PAT2008 | Oliver | Brown | 1967-10-05 | 301 Maple Lane | Phoenix | 85004 | USA | PROV3008 | Phoenix Wellness Center | 2024-02-09 | 70450 | 650 | 500 | 100 | 50 | STMT4008 | 2024-02-16 | 25 | 2024-02-20 | INS5008 | Aetna Choice POS II | CLM6008 | blank | blank | CT scan head/brain without contrast |
| EOB1009 | paid | 0 | TX | PAT2009 | Lucas | Martinez | 1989-02-02 | 505 Elm Ave | Houston | 77002 | USA | PROV3009 | Houston Medical Center | 2024-01-31 | 99203 | 175 | 130 | 25 | 20 | STMT4009 | 2024-02-07 | 20 | 2024-02-12 | INS5009 | Cigna PPO | CLM6009 | blank | blank | Office/outpatient visit, new patient |
| EOB1010 | paid | 0 | FL | PAT2010 | Ella | Johnson | 1997-09-18 | 28 Cedar St | Miami | 33101 | USA | PROV3010 | Miami Healthcare Assoc | 2024-03-06 | 81001 | 40 | 30 | 5 | 5 | STMT4010 | 2024-03-13 | 5 | 2024-03-18 | INS5010 | Florida Blue | CLM6010 | blank | blank | Urinalysis, automated, with microscopy |
| EOB1011 | partial payment | 5 | OR | PAT2011 | Grace | White | 1979-04-22 | 412 Aspen St | Portland | 97205 | USA | PROV3011 | Oregon Health Clinic | 2024-02-28 | 99212 | 135 | 100 | 20 | 15 | STMT4011 | 2024-03-05 | 10 | 2024-03-09 | INS5011 | Moda Health | CLM6011 | blank | blank | Office/outpatient visit, established patient, minor complexity |
| EOB1012 | unpaid | 25 | MN | PAT2012 | Henry | Anderson | 1960-08-11 | 96 Poplar Ave | Minneapolis | 55401 | USA | PROV3012 | Twin Cities Hospital | 2024-01-05 | 99215 | 225 | 170 | 30 | 25 | STMT4012 | 2024-01-12 | 0 | blank | INS5012 | Medica Choice | CLM6012 | blank | blank | Office/outpatient visit, established patient, high complexity |
| EOB1013 | paid | 0 | MD | PAT2013 | Mia | Davis | 1995-01-15 | 733 Redwood Dr | Baltimore | 21201 | USA | PROV3013 | Baltimore Family Practice | 2024-03-12 | 99396 | 120 | 90 | 20 | 10 | STMT4013 | 2024-03-19 | 10 | 2024-03-26 | INS5013 | CareFirst BlueChoice | CLM6013 | blank | blank | Preventive visit, established patient, age 18-39 |
| EOB1014 | paid | 0 | GA | PAT2014 | William | Evans | 1976-07-29 | 56 Magnolia Blvd | Atlanta | 30303 | USA | PROV3014 | Atlanta Medical Group | 2024-02-13 | 85025 | 55 | 40 | 10 | 5 | STMT4014 | 2024-02-20 | 5 | 2024-02-25 | INS5014 | Peach State Health Plan | CLM6014 | blank | blank | Complete blood count, automated |
| EOB1015 | paid | 0 | CA | PAT2015 | Charlotte | Kim | 2009-02-02 | 312 Willowbrook Ln | San Diego | 92101 | USA | PROV3015 | San Diego Pediatrics | 2024-05-10 | 90686 | 45 | 35 | 5 | 5 | STMT4015 | 2024-05-17 | 5 | 2024-05-22 | INS5015 | Sharp Health Plan | CLM6015 | blank | blank | Influenza vaccine, quadrivalent |
| EOB1016 | paid | 0 | MA | PAT2016 | Benjamin | Clark | 1965-10-17 | 1027 Sycamore Pl | Boston | 02108 | USA | PROV3016 | Boston General Hospital | 2024-02-25 | 71020 | 120 | 85 | 25 | 10 | STMT4016 | 2024-03-04 | 10 | 2024-03-10 | INS5016 | Harvard Pilgrim HMO | CLM6016 | blank | blank | Chest x-ray, two views |
| EOB1017 | unpaid | 20 | PA | PAT2017 | Emma | Lewis | 1990-08-30 | 657 Cherry Cir | Philadelphia | 19102 | USA | PROV3017 | Pennsylvania Family Med | 2024-04-06 | 99203 | 175 | 130 | 25 | 20 | STMT4017 | 2024-04-13 | 0 | blank | INS5017 | Independence Blue Cross | CLM6017 | blank | blank | Office/outpatient visit, new patient |
| EOB1018 | paid | 0 | TX | PAT2018 | Jack | Moore | 1985-03-11 | 23 Walnut St | Dallas | 75201 | USA | PROV3018 | Dallas Internal Medicine | 2024-04-12 | 99214 | 205 | 150 | 30 | 25 | STMT4018 | 2024-04-19 | 25 | 2024-04-25 | INS5018 | BlueCross BlueShield TX | CLM6018 | blank | blank | Office/outpatient visit, established patient, moderate complexity |
| EOB1019 | paid | 0 | CA | PAT2019 | Harper | Young | 2007-05-24 | 59 Birch Dr | San Jose | 95112 | USA | PROV3019 | San Jose Pediatrics | 2024-05-15 | 99394 | 80 | 60 | 15 | 5 | STMT4019 | 2024-05-22 | 5 | 2024-05-28 | INS5019 | Santa Clara Family Health | CLM6019 | blank | blank | Preventive visit, established patient, age 12-17 |
| EOB1020 | paid | 0 | NV | PAT2020 | Samuel | Hall | 1974-04-04 | 199 Palm St | Las Vegas | 89101 | USA | PROV3020 | Las Vegas Family Clinic | 2024-01-08 | 90716 | 120 | 90 | 20 | 10 | STMT4020 | 2024-01-15 | 10 | 2024-01-19 | INS5020 | SilverSummit Healthplan | CLM6020 | blank | blank | Varicella vaccine |
What the 100 rows show
from the 100-row sampleUnpaid (statement status) stands out: mean balance_
- 5median balance_
due - 26service codes
- 120median billed_
amount - 90median insurance_
paid_ amount - 25median adjustment_
amount - 12.5median patient_
responsibility_ amount
Median 5, from 0 to 40.
- string 20
- float 6
- date 4
Columns
30 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
eob_id | string | Unique identifier for each Explanation of Benefits documentunique | EOB1001 |
patient_id | string | Unique identifier for the patient associated with the EOB and statement | PAT2001 |
patient_first_name | string | Patient's first name | Emily |
patient_last_name | string | Patient's last name | Stevens |
patient_street_address | string | Patient's street addressoptional | 342 Oak Ave |
patient_city | string | Patient's cityoptional | Springfield |
patient_state | string | Patient's stateoptional | IL |
patient_postal_code | string | Patient's postal codeoptional | 62704 |
patient_country | string | Patient's countryoptional | USA |
provider_id | string | Unique identifier for the healthcare provider | PROV3001 |
provider_name | string | Name of the healthcare provider or facility | Ohio Family Clinic |
service_code | string | Standard code for the medical service/procedure (e.g., CPT, HCPCS) | 99213 |
service_description | string | Description of the medical service rendered | Routine venipuncture |
statement_id | string | Unique identifier for the patient billing statementunique | STMT4001 |
insurance_plan_id | string | Unique identifier for the insurance planoptional | INS5001 |
insurance_plan_name | string | Name of the insurance planoptional | Aetna POS |
claim_number | string | Insurance claim reference numberoptional | CLM6001 |
denial_code | string | Code indicating reason for claim denial, if applicableoptional | |
denial_reason | string | Description of the reason for claim denial, if applicableoptional | |
statement_status | string | Current status of the patient statement (e.g., paid, unpaid, in collections)paid · unpaid · in collections · partial payment · pending | paid |
| Numbers 6 columns | |||
billed_amount | float | Total amount billed for the service0 or more | 150 |
insurance_paid_amount | float | Amount paid by insurance for the service0 or more | 110 |
adjustment_amount | float | Amount adjusted (discounts, write-offs, contractual adjustments)0 or more · optional | 20 |
patient_responsibility_amount | float | Amount the patient is responsible for paying0 or more | 20 |
payment_received_amount | float | Amount of payment received from the patient0 or more · optional | 20 |
balance_due | float | Outstanding balance due from the patient after payments and adjustments0 or more | 0 |
| Dates and times 4 columns | |||
patient_date_of_birth | date | Patient's date of birthoptional | 1986-05-14 |
service_date | date | Date when the medical service was rendered | 2024-03-11 |
statement_date | date | Date the patient billing statement was issued | 2024-03-18 |
payment_received_date | date | Date payment was received from the patientoptional | 2024-03-22 |
Use it for
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.
- Eobs100EOB10010paidEOB10020paidEOB10030paid
A software demo
Believable eobs with patient_
id, patient_ first_ name and patient_ last_ name to fill a screen in front of a buyer.
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.
- 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
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