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

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 Descriptions

payer_slug

Type: string Standardized payer identifier used for consistent referencing and filtering. Example Values:

payer_name

Type: string Full legal or business name of the insurance payer organization. Example Values:

network_slug

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

network_name

Type: string Full name of the insurance network or plan. Example Values:

num_covered_eins

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

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