Overview
Consumer Pricing Service is a a pricing layer on top of Clear Rates.
Visit the Clear Rates Technical Documentation Here and User-Friendlier Documentation Here
Where to Find the Data
Latest tables are here:
tq_dev.internal_dev_csong_consumer_pricing_service.pricing_service_ssp_2025_06tq_dev.internal_dev_csong_consumer_pricing_service.pricing_service_rates_2025_06
Tables Explanation
Pricing Service Rates Table
Table Name: pricing_service_rates_YYYYMM
Purpose: Facility and Professional Line Items for each Subpackage-Provider-Payer-Network
Key Fields:
- Identifiers:
id,roid,ssp_id,sub_package_id - Payer Information:
payer_id,payer_name,network_id,network_name - Provider Information:
provider_id,provider_type,npi,state,cbsa,cbsa_name - Billing:
billing_code,billing_code_type,billing_code_description,fee_type - Rates:
validated_rate,validated_prof_fee_rate,negotiated_rate,discounted_cash_rate - Benchmarks:
state_avg_medicare_rate,lower_bound,upper_bound - Metadata:
source,contract_methodology,gross_charge
Pricing Service SSP Table
Table Name: pricing_service_ssp_YYYYMM
Purpose: SSP price for each SSP-Provider-Payer-Network
Key Fields:
Pricing Service SSP
- Identifiers:
roid,ssp_id,ssp_id - Payer Information:
payer_id,payer_name,network_id,network_name - Provider Information:
provider_id,provider_type,state,cbsa,cbsa_name - Fees:
facility_fee,professional_fee,professional_rate_ids - Price:
max_price
Provider Reference Table
Table Name: pricing_service_ref_provider_YYYYMM
Purpose: Comprehensive provider directory
Provider Types Included:
- Hospitals: From hospital spines data
- ASCs (Ambulatory Surgery Centers): From ASC spines data
- Imaging Centers: From imaging center spines data
Key Fields:
- Basic Info:
provider_id,provider_name,provider_name_short,npi - Contact:
website_url,phone_number,street_address,city,state,zip_code - Geographic:
hq_latitude,hq_longitude,cbsa_name - Hospital-Specific:
hospital_type,hospital_overall_rating,logo,ein