Skip to main content

Release Summary

  • 2.26 billion negotiated rates
  • 407,975 provider records
  • 6,533 unique hospital and health system EINs
  • 60 payers and their widest networks
View the Snowflake Marketplace listing.

Covered Hospital and Health Systems

  • Includes 6,533 unique hospital and health system EINs
  • Covers 12,602 total hospital NPIs
  • Represents acute care, psychiatric, rehabilitation, and military hospitals
  • Includes both single-facility hospitals and multi-facility health systems

Covered Payors and Networks

  • Includes 60 payors and their widest networks
#Payer NameNetwork NameCovered EINsTIC v2
1AetnaAetna Exchange - Aetna PPO5,874
2Anthem BC CaliforniaBlue Cross of California PAR providers552
3Anthem BCBS Central StatesBlue Traditional856
4Anthem BCBS ColoradoBluePreferred PPO113
5Anthem BCBS ConnecticutCentury Preferred76
6Anthem BCBS GeorgiaBCBS Georgia PAR providers291
7Anthem BCBS KentuckyAnthem BCBS Blue High Performance142
8Anthem BCBS MaineAnthem Main Blue Choice71
9Anthem BCBS MissouriBlue Access Choice192
10Anthem BCBS NevadaAnthem Nevada BluePreferred66
11Anthem BCBS New HampshireAnthem BCBS - Preferred Blue89
12Anthem BCBS OhioParticipating Providers140
13Anthem BCBS VirginiaAnthem KeyCare PPO178
14Anthem BCBS WisconsinBlue Preferred POS237
15Arkansas BCBSTrue Blue PPO125
16BCBS of MississippiBCBS Mississippi - PAR Network128
17BCBS of Rhode IslandClassic Blue32
18BCBS Of ArizonaBlue Preferred114
19BCBS of MassachusettsBCBS Massachusetts Blue Care Elect568
20BCBS of MichiganTRUST452
21BCBS of NebraskaNetwork BLUE120
22BCBS of North DakotaTraditional70
23BCBS of WyomingBCBS Wyoming - PAR Network57
24BCBS of AlabamaBCBS Alabama - PAR Network138
25BCBS of HawaiiPreferred Provider Network62
26BCBS of IllinoisBCBS Illinois - Participating Provider Option306
27BCBS of KansasBCBS Kansas Blue Choice154
28BCBS of Kansas CityPreferred Care PPO54
29BCBS of LouisianaBCBS Louisiana Blue High Performance198
30BCBS of MinnesotaBCBS Minnesota Aware162
31BCBS of MontanaBCBS Montana - PAR Network76
32BCBS of New MexicoNew Mexico Par Network64
33BCBS of North CarolinaPreferred Provider Network (PPN)1,328
34BCBS of OklahomaBlue Traditional155
35BCBS of TexasPAR Network (Preview)528
36BCBS of VermontBCBS Vermont - PAR providers32
37BC of IdahoBC Idaho - Preferred Blue86
38BS of CaliforniaBS California - PPO Network304
39BCBS of Puerto RicoTriple S - PAR Network63
40BCBS of South CarolinaPAR providers90
41Capital BCCapital Blue Cross Traditional687
42CareFirst BCBSCareFirst BCBS - PAR Network114
43CignaLocalplus5,475
44Empire BCBSEmpire BCBS - PPO Network419
45Excellus BCBSBlueShield Par99
46Florida BlueBlueChoice243
47Highmark BCBS DelawareBCBS Delaware Blue Choice27
48Highmark BCBS West VirginiaSuper Blue Plus64
49Highmark BCBS of Western New YorkHighMark BlueCross BlueShield of Western New York-PPO53
50Highmark BS PennsylvaniaHighmark BS Network232
51Highmark BS of Northeastern New YorkPPO33
52Horizon BCBS of New JerseySelect Hospitals/PAR Physicians215
53Independence BCIndependence BC - PAR Network181
54Premera BCTraditional182
55Regence BCBS of OregonRegence BCBS Oregon - PAR Network94
56Regence BCBS of UtahValueCare47
57Regence BS of IdahoBlue Shield Preferred Providers71
58Regence BS of WashingtonRegence BS BlueCard PPO88
59UnitedHealthcare Insurance CompanyChoice5,356
60Wellmark BCBS of IowaWellmark BCBS Iowa Alliance Select163

Included Tables and Views

Tables

providers

Contains provider-level information from transparency in coverage files, including:
  • NPI and TIN identifiers
  • Business and provider names
  • Imputed EIN attribution for hospital and health system grouping
  • Network and payer associations
  • Provider taxonomy and location data

rates

Contains negotiated rate information for billing codes:
  • Billing codes (CPT, HCPCS, DRG, etc.) with modifiers
  • Negotiated rates and arrangement types
  • Service settings and classifications
  • Bundled code relationships
  • Rate descriptions and metadata

payer_network_manifest

Metadata table containing:
  • Payer and network names and identifiers
  • Count of covered EINs per payer-network combination
  • TIC v2 format indicator

Views

V_PROVIDER_RATES

A denormalized view that joins the providers and rates tables to provide complete provider and rate context in a single query. This view includes all provider attributes alongside their associated negotiated rates, enabling efficient analysis of provider-specific pricing without needing to manually join the tables. Join Keys:
  • schedule_id
  • payer_slug
  • network_slug
  • date_key

Payer Network Manifest

The payer_network_manifest table contains metadata about each payer-network combination in this release.

Table Columns

#Column NameTypeDescription
1payer_slugstringStandardized payer identifier
2payer_namestringFull payer name
3network_slugstringStandardized network identifier
4network_namestringFull network name
5num_covered_einsnumberCount of covered hospital/health system EINs
6is_tic_v2booleanIndicates TIC v2 format compliance

Column Descriptions

payer_slug

Type: string Standardized payer identifier used for consistent referencing and filtering. Example Values:
bcbs_nc
anthem_bcbs_co
uhc
cigna
aetna

payer_name

Type: string Full legal or business name of the insurance payer organization. Example Values:
Blue Cross and Blue Shield of North Carolina
Anthem Blue Cross and Blue Shield Colorado
UnitedHealthcare Insurance Company

network_slug

Type: string Standardized network identifier, typically includes payer identifier and network name components. Example Values:
bcbs_nc_preferred_provider_network_ppn
anthem_bcbs_co_bluepreferred_ppo
uhc_choice

network_name

Type: string Full name of the insurance network or plan. Example Values:
Preferred Provider Network (PPN)
BluePreferred PPO
Choice

num_covered_eins

Type: number Count of unique hospital and health system EINs with negotiated rates in this payer-network combination. Example Values:
1328
113
5356

is_tic_v2

Type: boolean Indicates TIC v2 (Transparency in Coverage version 2) format compliance. Possible Values:
  • true - Complies with TIC v2 format
  • false - Uses earlier TIC format version