Healthcare
17 columns
200 rows
8 formats

Medical Billing

This dataset provides comprehensive healthcare billing records, detailing procedure and diagnosis codes, charges, insurance claim information, and payment statuses. It enables robust analysis of medical billing processes, insurance reimbursements, and patient financial responsibility, supporting operational efficiency and compliance in healthcare finance.

last updated 29 Oct 2025
by GoMask

The brief that made it

Medical billing process optimization and audit

Sample rows

preview · 8 of 200 rows · all 17 columns

billing_idstring	claim_statusstring	patient_responsibility_amountfloat	insurance_companystring	patient_idstring	provider_idstring	service_datedate	procedure_codestring	diagnosis_codestring	charge_amountfloat	insurance_claim_idstring	claim_submission_datedate	claim_approval_datedate	paid_amountfloat	payment_statusstring	payment_datedate	notesstring
BLG0001	approved	10	BlueShield	PT1001	PR3001	2019-01-15	99213	J10.1	125	IC5001	2019-01-16	2019-01-18	115	paid	2019-01-20	Routine checkup, claim approved, patient paid remaining amount.
BLG0002	paid	10	UnitedHealth	PT1002	PR3002	2018-12-30	93000	I10	220	IC5002	2019-01-02	2019-01-05	210	paid	2019-01-07	ECG performed, insurance paid majority, minor patient copay.
BLG0003	approved	15	Aetna	PT1003	PR3003	2022-07-04	80053	E11.9	75	IC5003	2022-07-05	2022-07-07	60	partial	2022-07-09	Blood panel, insurance covered partial amount, patient paid difference.
BLG0004	approved	10	Cigna	PT1004	PR3001	2021-02-28	99214	J45.909	180	IC5004	2021-03-01	2021-03-03	170	paid	2021-03-04	Asthma follow-up, claim processed quickly, small patient copay.
BLG0005	blank	0	blank	PT1002	PR3002	2020-12-25	90791	F41.1	210	blank	blank	blank	210	paid	2020-12-26	Psychiatric evaluation, patient paid in full, no insurance.
BLG0006	blank	55	blank	PT1005	PR3004	2023-03-10	36415	R53.83	55	blank	blank	blank	0	unpaid	blank	Blood draw, self-pay, patient yet to pay.
BLG0007	approved	10	Kaiser	PT1006	PR3005	2018-11-20	99212	B34.9	85	IC5005	2018-11-21	2018-11-23	75	partial	2018-11-25	Minor viral infection, partial insurance payment, remainder by patient.
BLG0008	partially_paid	65	HealthFirst	PT1007	PR3006	2020-05-01	93010	I25.10	325	IC5006	2020-05-02	2020-05-06	260	partial	2020-05-09	Cardiac test, insurance paid large portion, patient covered difference.
BLG0009	approved	10	Oscar	PT1008	PR3007	2022-12-31	99215	E78.5	140	IC5007	2023-01-02	2023-01-04	130	paid	2023-01-06	Year-end appointment, insurance covered majority.
BLG0010	blank	0	blank	PT1009	PR3008	2024-02-29	90471	Z23	65	blank	blank	blank	65	paid	2024-03-01	Flu shot on leap year, patient paid in full.
BLG0011	pending	0	Humana	PT1010	PR3009	2020-07-14	99406	F17.200	155	IC5008	2020-07-15	blank	0	pending	blank	Smoking cessation counseling, claim pending with insurance.
BLG0012	submitted	0	Medicare	PT1011	PR3010	2021-06-15	99203	R51	110	IC5009	2021-06-16	blank	0	pending	blank	Initial consult, insurance claim submitted.
BLG0013	denied	350	DeltaDental	PT1012	PR3011	2019-09-09	99204	K21.9	350	IC5010	2019-09-10	2019-09-14	0	overdue	blank	Consultation, claim denied, patient responsible for full charge.
BLG0014	rejected	150	Tricare	PT1013	PR3012	2023-05-10	90792	F32.9	150	IC5011	2023-05-11	2023-05-13	0	unpaid	blank	Mental health evaluation, claim rejected, patient owes full amount.
BLG0015	partially_paid	30	Horizon	PT1014	PR3013	2022-08-12	81002	N39.0	90	IC5012	2022-08-13	2022-08-18	60	partial	2022-08-20	Urinalysis, partial payment by insurance, remainder covered by patient.
BLG0016	approved	100	Molina	PT1015	PR3014	2018-05-05	99205	J20.9	1800	IC5013	2018-05-06	2018-05-08	1700	paid	2018-05-10	Extended consult, insurance covered majority, patient paid copay.
BLG0017	approved	20	AIG	PT1016	PR3015	2021-10-15	99385	Z00.00	260	IC5014	2021-10-16	2021-10-18	240	paid	2021-10-19	Annual adult physical, insurance covered most of charge.
BLG0018	blank	105	blank	PT1017	PR3016	2020-06-20	G0439	Z12.11	105	blank	blank	blank	0	unpaid	blank	Medicare wellness, self-pay, patient yet to pay.
BLG0019	blank	0	blank	PT1018	PR3017	2022-01-01	99211	R10.9	45	blank	blank	blank	45	paid	2022-01-02	Minor issue, paid in full, no insurance involved.
BLG0020	pending	0	Cigna	PT1019	PR3018	2023-11-24	87880	J02.9	70	IC5015	2023-11-25	blank	0	pending	blank	Strep test, insurance claim pending.

What the 200 rows show

from the 200-row sample

Partially_paid (claim status) stands out: mean patient_responsibility_amount is 1,879, against 301.9 for the rest.

10.5median patient_responsibility_amount
5payment statuses
147.3median charge_amount
85.0median paid_amount

Mean patient_responsibility_amount by claim_status135 rows

patient_responsibility_amount200 rows, in bands of 2,000

Median 10.5, from 0.0 to 12,000.

insurance_company135 rows with a value · 65 left blank

Kaiser13
BlueShield12
Humana12
Oscar11
Molina11
AIG10
Aetna9
Cigna9
Medicare9
UnitedHealth8

17 columns by typefrom the column list below

string 10
float 3
date 4

Columns

17 columns in three groups

blueprint · 17 columns
column	type	description	example
Text 10 columns
`billing_id`	string	Unique identifier for each medical billing recordunique	BLG0001
`patient_id`	string	Unique identifier for the patient associated with the billing record	PT1001
`provider_id`	string	Unique identifier for the healthcare provider or facility	PR3001
`procedure_code`	string	Standardized code representing the medical procedure performed (e.g., CPT, HCPCS)	99213
`diagnosis_code`	string	Standardized code representing the patient's diagnosis (e.g., ICD-10)	J10.1
`insurance_claim_id`	string	Unique identifier for the insurance claim associated with the billing recordoptional	IC5001
`insurance_company`	string	Name of the insurance company processing the claimoptional	BlueShield
`claim_status`	string	Current status of the insurance claim7 values · optional	approved
`payment_status`	string	Status of payment for the billing recordunpaid · paid · partial · pending · overdue	paid
`notes`	string	Additional notes or comments related to the billing recordoptional	Routine checkup, claim ap…
Numbers 3 columns
`charge_amount`	float	Total amount charged for the procedure or service0 or more	125
`paid_amount`	float	Amount paid by insurance or patient for the billing record0 or more · optional	115
`patient_responsibility_amount`	float	Amount the patient is responsible for paying after insurance0 or more · optional	10
Dates and times 4 columns
`service_date`	date	Date when the medical service or procedure was performed	2019-01-15
`claim_submission_date`	date	Date the insurance claim was submittedoptional	2019-01-16
`claim_approval_date`	date	Date the insurance claim was approved or finalizedoptional	2019-01-18
`payment_date`	date	Date when payment was received for the billing recordoptional	2019-01-20

Use it for

A healthcare dashboard
Patient_responsibility_amount by claim_status and a breakdown of insurance_company. Excel, Power BI or Tableau.
Why do the 27 partially_paid rows have a mean patient_responsibility_amount of 1,879?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Billings200
BLG000110approved
BLG000210paid
BLG000315approved
A software demo
Believable billings with patient_id, provider_id and service_date to fill a screen in front of a buyer.

This dataset200 rows17 columns

Yours1,000 rows17 columns

blueprint · medical-billing

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 17 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

CPT codes for procedures performed
ICD codes for diagnoses
Claim submission to insurance
Patient responsibility after insurance
Claim status: submitted, approved, denied

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: medical-billing

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A healthcare dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?