Healthcare
16 columns
100 rows
8 formats

Provider Contract and Fee Schedules

This dataset provides a comprehensive view of healthcare provider contracts with payers, detailing contracted rates, payment terms, credentialing status, effective and expiration dates, participation status, and network tier assignments. It enables analysis of provider-payer relationships, reimbursement trends, and network management for claims processing and compliance.

last updated 2 Nov 2025
by GoMask

The brief that made it

Analyzing provider reimbursement trends across payers

Sample rows

preview · 8 of 100 rows · all 16 columns

contract_idstring	rate_unitstring	contracted_ratefloat	payment_termsstring	provider_idstring	provider_namestring	provider_npistring	payer_idstring	payer_namestring	credentialing_statusstring	effective_datedate	expiration_datedate	participation_statusstring	network_tierstring	service_typestring	last_updateddatetime
CONTRACT-001	per_visit	120.5	Net 30, electronic transfer	PROV-1001	Northside Family Medicine	4871920382	PAY-2001	Blue Ridge Health Plan	active	2023-04-01	2025-03-31	participating	tier_1	primary care	2024-05-02T10:12:43
CONTRACT-002	per_visit	95	Net 45, check	PROV-1002	Uptown Pediatrics	8901256437	PAY-2002	Sunstate Insurance	active	2022-09-15	2024-09-14	participating	tier_2	primary care	2024-04-11T16:08:59
CONTRACT-003	per_procedure	250	Net 60, direct deposit	PROV-1003	Westside Cardiology Group	2374981205	PAY-2003	HealthFirst	active	2022-01-01	2024-12-31	participating	tier_1	specialty	2024-03-03T09:45:11
CONTRACT-004	per_procedure	70.25	Net 30, electronic	PROV-1004	Central Imaging Center	9387261540	PAY-2004	Alliance Health	pending	2024-06-01	blank	pending	tier_2	radiology	2024-05-10T13:31:25
CONTRACT-005	per_procedure	39.8	Net 30, ACH	PROV-1005	Riverside Lab Services	6219073841	PAY-2005	MetroCare	active	2022-05-15	2025-05-14	participating	tier_3	lab	2024-05-13T11:02:19
CONTRACT-006	per_visit	92.6	Net 60, check	PROV-1002	Uptown Pediatrics	8901256437	PAY-2006	Premier Choice Health	active	2023-02-18	2026-02-17	participating	tier_2	primary care	2024-04-29T08:14:32
CONTRACT-007	per_procedure	310	Net 45, electronic	PROV-1006	Southern Orthopedics	7109826341	PAY-2007	Magnolia Health Partners	active	2021-04-01	2024-03-31	participating	tier_1	specialty	2024-04-18T15:17:21
CONTRACT-008	per_visit	70	Net 30, direct deposit	PROV-1007	Greenway Behavioral Health	9041372856	PAY-2008	Sunstate Insurance	pending	2024-07-01	blank	pending	tier_2	behavioral health	2024-05-09T11:53:46
CONTRACT-009	per_visit	115.25	Net 30, ACH	PROV-1008	Eastside Women's Health	8017264539	PAY-2009	HealthFirst	active	2023-09-01	2026-08-31	participating	tier_1	primary care	2024-03-14T14:02:35
CONTRACT-010	per_visit	98	Net 30, check	PROV-1009	Summit Pediatrics	2841765309	PAY-2002	Sunstate Insurance	active	2022-11-10	2025-11-09	participating	tier_2	primary care	2024-04-25T09:49:18
CONTRACT-011	per_procedure	185	Net 45, direct deposit	PROV-1010	Midtown Endocrinology	1975348201	PAY-2010	Blue Ridge Health Plan	active	2023-01-01	2027-12-31	participating	tier_2	specialty	2024-04-30T12:19:44
CONTRACT-012	per_visit	89.95	Net 60, check	PROV-1011	Downtown Pediatrics	6038172459	PAY-2011	MetroCare	active	2023-06-01	2026-05-31	participating	tier_1	primary care	2024-05-05T10:24:31
CONTRACT-013	per_procedure	335	Net 45, electronic	PROV-1012	Parkside Orthopedics	1860234957	PAY-2012	Premier Choice Health	active	2021-07-01	2024-06-30	participating	tier_1	specialty	2024-04-20T11:02:47
CONTRACT-014	per_visit	110	Net 30, ACH	PROV-1013	Valley Women's Health	9812457603	PAY-2010	Blue Ridge Health Plan	active	2022-08-01	2025-07-31	participating	tier_2	primary care	2024-04-28T15:55:03
CONTRACT-015	per_procedure	72.5	Net 45, electronic	PROV-1014	Eastside Imaging	2739108256	PAY-2013	HealthFirst	active	2023-02-01	2024-12-31	participating	tier_3	radiology	2024-05-11T14:31:44
CONTRACT-016	per_procedure	41	Net 30, check	PROV-1015	Central Lab Associates	1920458713	PAY-2014	Alliance Health	active	2022-05-01	2025-04-30	participating	tier_2	lab	2024-04-21T13:07:53
CONTRACT-017	per_visit	73.25	Net 30, direct deposit	PROV-1016	Westside Behavioral Group	6038192475	PAY-2015	Sunstate Insurance	pending	2024-07-15	blank	pending	tier_2	behavioral health	2024-05-12T14:19:16
CONTRACT-018	per_visit	97	Net 30, ACH	PROV-1017	Northside Pediatrics	4981203876	PAY-2016	Blue Ridge Health Plan	active	2022-11-01	2025-10-31	participating	tier_1	primary care	2024-04-15T08:51:07
CONTRACT-019	per_procedure	195	Net 45, direct deposit	PROV-1018	Greenway Endocrinology	7109826342	PAY-2017	Premier Choice Health	active	2023-03-01	2026-02-28	participating	tier_2	specialty	2024-03-31T10:21:38
CONTRACT-020	per_procedure	265	Net 60, electronic	PROV-1019	Riverside Cardiology	1847265309	PAY-2018	HealthFirst	active	2022-01-01	2024-12-31	participating	tier_1	specialty	2024-02-23T12:37:29

What the 100 rows show

from the 100-row sample

96.8median contracted_rate
2credentialing statuses
2participation statuses
3network tiers
15service types

rate_unit100 rows by value

contracted_rate100 rows, in bands of 500

Median 96.8, from 39.8 to 2,650.

payment_terms100 rows · top 10 of 24 values

Net 30, ACH11
Net 60, check7
Net 45, direct deposit7
Net 45, EFT7
Net 45, check6
Net 30, check6
Net 45, electronic5
Net 30, direct deposit5
Net 60, wire5
Net 30, wire transfer5

16 columns by typefrom the column list below

string 12
float 1
date 2
datetime 1

Columns

16 columns in three groups

blueprint · 16 columns
column	type	description	example
Text 12 columns
`contract_id`	string	Unique identifier for each provider-payer contractunique	CONTRACT-001
`provider_id`	string	Unique identifier for the healthcare provider	PROV-1001
`provider_name`	string	Full legal name of the healthcare provider	Uptown Pediatrics
`provider_npi`	string	National Provider Identifier (NPI) for the provideroptional	4871920382
`payer_id`	string	Unique identifier for the payer (insurance company or health plan)	PAY-2001
`payer_name`	string	Name of the payer organization	Blue Ridge Health Plan
`rate_unit`	string	Unit for contracted rate (e.g., per visit, per procedure, percentage)per_visit · per_procedure · percentage · other	per_visit
`payment_terms`	string	Summary of payment terms (e.g., payment timeline, method)optional	Net 45, check
`credentialing_status`	string	Current credentialing status of the provider with the payeractive · pending · expired · suspended · terminated	active
`participation_status`	string	Indicates if provider is currently participating in the payer's networkparticipating · non-participating · terminated · pending	participating
`network_tier`	string	Network tier for claims payment (e.g., Tier 1, Tier 2, Out-of-Network)tier_1 · tier_2 · tier_3 · out_of_network · other	tier_1
`service_type`	string	Type of healthcare service covered by the contract (e.g., primary care, specialty, lab)optional	primary care
Numbers 1 column
`contracted_rate`	float	Negotiated payment rate for services under this contract0 or more	120.5
Dates and times 3 columns
`effective_date`	date	Date when the contract becomes effective	2023-04-01
`expiration_date`	date	Date when the contract expiresoptional	2025-03-31
`last_updated`	datetime	Timestamp of the last update to the contract record	2024-05-02T10:12:43

Use it for

A healthcare dashboard
Contracted_rate by rate_unit and a breakdown of payment_terms. Excel, Power BI or Tableau.
What pattern can you find in 100 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 100 rows.
Contracts100
CONTRACT-001120.5per_visit
CONTRACT-00295per_visit
CONTRACT-003250per_proc…
A software demo
Believable contracts with provider_id, provider_name and provider_npi to fill a screen in front of a buyer.

This dataset100 rows16 columns

Yours10,000 rows16 columns

blueprint · provider-contract-and-fee-schedules

Behind this dataset

Same schema. As many rows as you need.

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

Contract ID unique per provider-payer combination
Provider NPI and TIN (Tax ID Number)
Payer name and payer ID
Contract effective date and termination date
Participation status: in-network, out-of-network
Network tier: Tier 1 (preferred), Tier 2, Tier 3
Credentialing status with payer: active, pending, expired
Fee schedule: percentage of Medicare, percentage of charges, fee schedule

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: provider-contract-and-fee-schedules

What should your data show?

No signup. No card.

Sample rows

What the 100 rows show

Columns

Use it for

A healthcare dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Healthcare

What should your data show?