PriceTransparencypowered by▸healthparse
Hospital searchCompare ratesAI QueryCompliance scorecardPricingAPI
Hospital searchCompare ratesAI QueryCompliance scorecardPricingAPI
▸ Search · Loading…
PriceTransparencypowered by▸healthparse
Hospital searchCompare ratesAI QueryCompliance scorecardPricingAPI
Hospital searchCompare ratesAI QueryCompliance scorecardPricingAPI
▸ Search · PriceTransparency

Search hospital rates

Pick a procedure and (optionally) a state or payer. Rates come from each hospital's federally-mandated machine-readable file.

Hospitals
8
Payers
36
Negotiated range
$243.98 – $43,617
Negotiated median
$1,256.69
CPT 45385 Colonoscopy with polyp removal · Showing 200 of 265 rate rows
↓ Download CSVSee comparison view →
CmpHospitalSTPayerPlanSettingTypeRate
MT. GRAHAM REGIONAL MEDICAL CENTERAZeff date——negotiated$43,617
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZBlue Cross Blue Shield——negotiated$4,768.59
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZCigna——negotiated$4,377
CARONDELET ST. JOSEPH HOSPITALAZBlue Cross Blue Shield——negotiated$4,263.47
CHANDLER REGIONAL MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$4,213.72
MERCY GILBERT MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$4,213.72
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZUnitedHealthcare——negotiated$3,822
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZHumana——negotiated$3,503
YAVAPAI REGIONAL MEDICAL CENTERAZHealth NetCommercial|All Plansoutpatientnegotiated$3,284.42
YAVAPAI REGIONAL MEDICAL CENTERAZHealth NetCommercial|All Plansinpatientnegotiated$3,284.42
YAVAPAI REGIONAL MEDICAL CENTERAZFirst HealthCommercial|All Plansoutpatientnegotiated$3,216.7
YAVAPAI REGIONAL MEDICAL CENTERAZFirst HealthCommercial|All Plansinpatientnegotiated$3,216.7
CARONDELET ST. JOSEPH HOSPITALAZCigna——negotiated$3,194
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZCigna——negotiated$3,173
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZUnitedHealthcare——negotiated$3,155
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZBlue Cross Blue Shield——negotiated$3,056.98
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZAetna——negotiated$3,055
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaCommercial|PPOoutpatientnegotiated$3,047.4
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaCommercial|All Other Plansinpatientnegotiated$3,047.4
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaCommercial|All Other Plansoutpatientnegotiated$3,047.4
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaCommercial|PPOinpatientnegotiated$3,047.4
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZcommercial | connected care | intel——negotiated$3,016
MERCY GILBERT MEDICAL CENTERAZCigna——negotiated$2,990
CHANDLER REGIONAL MEDICAL CENTERAZCigna——negotiated$2,990
YAVAPAI REGIONAL MEDICAL CENTERAZCignaCommercial|All Other Plansoutpatientnegotiated$2,955.98
YAVAPAI REGIONAL MEDICAL CENTERAZCignaCommercial|All Other Plansinpatientnegotiated$2,955.98
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareCommercial|All Other Plansoutpatientnegotiated$2,945.82
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareCommercial|Choiceoutpatientnegotiated$2,945.82
YAVAPAI REGIONAL MEDICAL CENTERAZBlue Cross Blue ShieldCommercial|All Plansoutpatientnegotiated$2,881.49
YAVAPAI REGIONAL MEDICAL CENTERAZCignaCommercial|IFPinpatientnegotiated$2,878.1
YAVAPAI REGIONAL MEDICAL CENTERAZCignaCommercial|IFPoutpatientnegotiated$2,878.1
CARONDELET ST. JOSEPH HOSPITALAZBlue Cross Blue Shield——negotiated$2,732.91
MERCY GILBERT MEDICAL CENTERAZUnitedHealthcare——negotiated$2,721
CHANDLER REGIONAL MEDICAL CENTERAZUnitedHealthcare——negotiated$2,718
CHANDLER REGIONAL MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$2,701.12
MERCY GILBERT MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$2,701.12
CHANDLER REGIONAL MEDICAL CENTERAZHumana——negotiated$2,694
CARONDELET ST. JOSEPH HOSPITALAZHumana——negotiated$2,694
MERCY GILBERT MEDICAL CENTERAZHumana——negotiated$2,694
CHANDLER REGIONAL MEDICAL CENTERAZUnitedHealthcare——negotiated$2,643
CARONDELET ST. JOSEPH HOSPITALAZUnitedHealthcare——negotiated$2,643
MERCY GILBERT MEDICAL CENTERAZUnitedHealthcare——negotiated$2,593
CARONDELET ST. JOSEPH HOSPITALAZUnitedHealthcare——negotiated$2,581
CARONDELET ST. JOSEPH HOSPITALAZAetna——negotiated$2,472
CHANDLER REGIONAL MEDICAL CENTERAZAetna——negotiated$2,413
MERCY GILBERT MEDICAL CENTERAZAetna——negotiated$2,413
CARONDELET ST. JOSEPH HOSPITALAZCigna——negotiated$2,382
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZBlue Cross Blue Shield——negotiated$2,292.74
CHANDLER REGIONAL MEDICAL CENTERAZcommercial | connected care | intel——negotiated$2,255
MERCY GILBERT MEDICAL CENTERAZcommercial | connected care | intel——negotiated$2,255
CARONDELET ST. JOSEPH HOSPITALAZcommercial | connected care | intel——negotiated$2,255
MERCY GILBERT MEDICAL CENTERAZCigna——negotiated$2,213
CHANDLER REGIONAL MEDICAL CENTERAZCigna——negotiated$2,213
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZCigna——negotiated$2,193
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOYC+outpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareSEL+POSoutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOYCoutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareAARP MEDICARE ADVANTAGEoutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareAARP MCARE ADVANTAGE PATRIOToutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZMeritain HealthAETNA CHOICE POS IIoutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZHumanaMEDICARE ADVANTAGE PPOoutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZAetnaTRADITIONAL CHOICEoutpatientnegotiated$2,160
MT. GRAHAM REGIONAL MEDICAL CENTERAZAetnaESA - MEDICARE (AETNA)outpatientnegotiated$2,105
CHANDLER REGIONAL MEDICAL CENTERAZUnitedHealthcare——negotiated$2,102
CARONDELET ST. JOSEPH HOSPITALAZUnitedHealthcare——negotiated$2,072
MERCY GILBERT MEDICAL CENTERAZUnitedHealthcare——negotiated$2,052
CARONDELET ST. JOSEPH HOSPITALAZBlue Cross Blue Shield——negotiated$2,049.51
CHANDLER REGIONAL MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$2,026.01
MERCY GILBERT MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$2,026.01
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZUnitedHealthcare——negotiated$1,994
ARIZONA GENERAL HOSPITALAZCigna——negotiated$1,722
ARIZONA GENERAL HOSPITALAZAetna——negotiated$1,722
ARIZONA GENERAL HOSPITALAZBlue Cross Blue Shield——negotiated$1,722
ARIZONA GENERAL HOSPITALAZHumana——negotiated$1,722
ARIZONA GENERAL HOSPITALAZUnitedHealthcare——negotiated$1,722
CARONDELET ST. JOSEPH HOSPITALAZCigna——negotiated$1,656
MERCY GILBERT MEDICAL CENTERAZCigna——negotiated$1,646
CHANDLER REGIONAL MEDICAL CENTERAZCigna——negotiated$1,646
ARIZONA GENERAL HOSPITALAZBlue Cross Blue Shield——negotiated$1,623.85
CARONDELET ST. JOSEPH HOSPITALAZcommercial | az foundation | pos——negotiated$1,513.26
ARIZONA GENERAL HOSPITALAZcommercial | azfmc | all other plans——negotiated$1,513.26
CARONDELET ST. JOSEPH HOSPITALAZcommercial | az foundation | ppo——negotiated$1,513.26
ARIZONA GENERAL HOSPITALAZcommercial | azfmc | pos——negotiated$1,513.26
ARIZONA GENERAL HOSPITALAZMultiplan——negotiated$1,406.87
CHANDLER REGIONAL MEDICAL CENTERAZcommercial | az foundation | ppo——negotiated$1,405.86
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZcommercial | az foundation | pos——negotiated$1,405.86
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZcommercial | az foundation | ppo——negotiated$1,405.86
CHANDLER REGIONAL MEDICAL CENTERAZcommercial | az foundation | pos——negotiated$1,405.86
MERCY GILBERT MEDICAL CENTERAZcommercial | az foundation | pos——negotiated$1,405.86
MERCY GILBERT MEDICAL CENTERAZcommercial | az foundation | ppo——negotiated$1,405.86
MT. GRAHAM REGIONAL MEDICAL CENTERAZAetnaAETNA HEALTHFUND AETNA CHOICEoutpatientnegotiated$1,403.33
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOYC+outpatientnegotiated$1,403.33
YAVAPAI REGIONAL MEDICAL CENTERAZdevoted healthMedicare|All Plansoutpatientnegotiated$1,332.1
YAVAPAI REGIONAL MEDICAL CENTERAZimperial insuranceMedicare|All Plansoutpatientnegotiated$1,319.53
YAVAPAI REGIONAL MEDICAL CENTERAZWellCareMedicare|All Plansoutpatientnegotiated$1,319.53
YAVAPAI REGIONAL MEDICAL CENTERAZBlue Cross Blue ShieldMedicare|All Plansoutpatientnegotiated$1,294.4
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareMedicare|All Plansoutpatientnegotiated$1,288.11
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZFirst HealthMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZWellCareMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZarizona medical networkMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZbanner healthMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZbridgeway health solutionsMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZrural arizona networkMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZCignaMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZHumanaMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZHealth NetMedicare|Allwelloutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZhealth management networkMedicare|All Plansoutpatientnegotiated$1,256.69
YAVAPAI REGIONAL MEDICAL CENTERAZhealth choice pathwayMedicare|All Plansoutpatientnegotiated$1,256.69
CARONDELET ST. JOSEPH HOSPITALAZMedicare——negotiated$1,121.88
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZMedicare——negotiated$1,121.88
ARIZONA GENERAL HOSPITALAZMedicare——negotiated$1,097.31
ARIZONA GENERAL HOSPITALAZMedicare——negotiated$1,086.66
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOICE PLUS POSoutpatientnegotiated$1,080
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareASRSoutpatientnegotiated$1,080
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOYC+outpatientnegotiated$1,080
MT. GRAHAM REGIONAL MEDICAL CENTERAZMeritain HealthBLUE CROSS BLUE SHIELD OF ARIZoutpatientnegotiated$1,080
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareUHC COMPLETE CARE SUPPORToutpatientnegotiated$1,080
ARIZONA GENERAL HOSPITALAZMedicare——negotiated$1,076
ARIZONA GENERAL HOSPITALAZMedicare——negotiated$1,065.35
ARIZONA GENERAL HOSPITALAZHumana——negotiated$1,065.35
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZMedicare——negotiated$1,051.86
CARONDELET ST. JOSEPH HOSPITALAZMedicare——negotiated$1,051.86
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZBlue Cross Blue Shield——negotiated$1,021.22
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZAetna——negotiated$1,021.22
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZHumana——negotiated$1,021.22
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZMedicare——negotiated$1,021.22
MERCY GILBERT MEDICAL CENTERAZCigna——negotiated$1,021.22
CARONDELET ST. JOSEPH HOSPITALAZCigna——negotiated$1,021.22
CHANDLER REGIONAL MEDICAL CENTERAZAetna——negotiated$1,021.22
CARONDELET ST. JOSEPH HOSPITALAZBlue Cross Blue Shield——negotiated$1,021.22
CHANDLER REGIONAL MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$1,021.22
CHANDLER REGIONAL MEDICAL CENTERAZCigna——negotiated$1,021.22
CARONDELET ST. JOSEPH HOSPITALAZAetna——negotiated$1,021.22
CHANDLER REGIONAL MEDICAL CENTERAZHumana——negotiated$1,021.22
CHANDLER REGIONAL MEDICAL CENTERAZMedicare——negotiated$1,021.22
CARONDELET ST. JOSEPH HOSPITALAZMedicare——negotiated$1,021.22
CARONDELET ST. JOSEPH HOSPITALAZHumana——negotiated$1,021.22
MERCY GILBERT MEDICAL CENTERAZMedicare——negotiated$1,021.22
MERCY GILBERT MEDICAL CENTERAZHumana——negotiated$1,021.22
MERCY GILBERT MEDICAL CENTERAZAetna——negotiated$1,021.22
MERCY GILBERT MEDICAL CENTERAZBlue Cross Blue Shield——negotiated$1,021.22
ST. JOSEPHS HOSPITAL & MEDICAL CTRAZCigna——negotiated$1,021.22
ARIZONA GENERAL HOSPITALAZFirst Health——negotiated$912.66
MT. GRAHAM REGIONAL MEDICAL CENTERAZAetnaTRADITIONAL CHOICE NET 00588inpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZAetnaAETNA HEALTHFUND AETNA CHOICEinpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZAetnaESA - MEDICARE (AETNA)outpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareSEL+POSinpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareUHC COMPLETE CARE SUPPORToutpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareAARP MCARE ADVANTAGE PATRIOToutpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOICE PLUS POSinpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOYCinpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZUnitedHealthcareCHOYC+inpatientnegotiated$804.73
MT. GRAHAM REGIONAL MEDICAL CENTERAZHumanaMEDICARE SUPPLEMENTinpatientnegotiated$804.73
ARIZONA GENERAL HOSPITALAZMedicaid——negotiated$770.6
CARONDELET ST. JOSEPH HOSPITALAZMedicaid——negotiated$770.6
YAVAPAI REGIONAL MEDICAL CENTERAZdevoted healthMedicare|All Plansoutpatientnegotiated$555.44
YAVAPAI REGIONAL MEDICAL CENTERAZWellCareMedicare|All Plansoutpatientnegotiated$550.2
YAVAPAI REGIONAL MEDICAL CENTERAZimperial insuranceMedicare|All Plansoutpatientnegotiated$550.2
YAVAPAI REGIONAL MEDICAL CENTERAZBlue Cross Blue ShieldMedicare|All Plansoutpatientnegotiated$539.72
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareMedicare|All Plansoutpatientnegotiated$537.1
YAVAPAI REGIONAL MEDICAL CENTERAZWellCareMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZarizona medical networkMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZbanner healthMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZbridgeway health solutionsMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZCignaMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZFirst HealthMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZhealth choice pathwayMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZhealth management networkMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZHealth NetMedicare|Allwelloutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZHumanaMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZrural arizona networkMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareMedicare|All Plansoutpatientnegotiated$524
YAVAPAI REGIONAL MEDICAL CENTERAZHealth NetCommercial|All Plansoutpatientnegotiated$508.28
YAVAPAI REGIONAL MEDICAL CENTERAZFirst HealthCommercial|All Plansoutpatientnegotiated$497.8
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaCommercial|All Other Plansoutpatientnegotiated$471.6
YAVAPAI REGIONAL MEDICAL CENTERAZAetnaCommercial|PPOoutpatientnegotiated$471.6
YAVAPAI REGIONAL MEDICAL CENTERAZCignaCommercial|All Other Plansoutpatientnegotiated$457.46
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareCommercial|All Other Plansoutpatientnegotiated$455.88
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareCommercial|Choiceoutpatientnegotiated$455.88
YAVAPAI REGIONAL MEDICAL CENTERAZBlue Cross Blue ShieldCommercial|All Plansoutpatientnegotiated$445.93
YAVAPAI REGIONAL MEDICAL CENTERAZCignaCommercial|IFPoutpatientnegotiated$445.4
ARIZONA GENERAL HOSPITALAZBright Health——negotiated$422.58
MT. GRAHAM REGIONAL MEDICAL CENTERAZamount——negotiated$410
SANTA CRUZ VALLEY REGIONAL HOSPITALAZAetnaMedicaidbothnegotiated$401.36
MT. GRAHAM REGIONAL MEDICAL CENTERAZde-identified max——negotiated$377.2
SANTA CRUZ VALLEY REGIONAL HOSPITALAZcaresoure kentuckyCommercialbothnegotiated$357.56
MT. GRAHAM REGIONAL MEDICAL CENTERAZde-identified min——negotiated$287
YAVAPAI REGIONAL MEDICAL CENTERAZhealth choiceMedicaid|All Plansoutpatientnegotiated$276
YAVAPAI REGIONAL MEDICAL CENTERAZmercy careMedicaid|All Plansoutpatientnegotiated$276
YAVAPAI REGIONAL MEDICAL CENTERAZHealth NetMedicaid|All Plansoutpatientnegotiated$262.85
YAVAPAI REGIONAL MEDICAL CENTERAZHumanaMedicaid|All Plansoutpatientnegotiated$262.85
YAVAPAI REGIONAL MEDICAL CENTERAZcare 1stMedicaid|All Plansoutpatientnegotiated$262.85
YAVAPAI REGIONAL MEDICAL CENTERAZbanner healthMedicaid|All Plansoutpatientnegotiated$262.85
YAVAPAI REGIONAL MEDICAL CENTERAZarizona complete healthMedicaid|All Plansoutpatientnegotiated$262.85
YAVAPAI REGIONAL MEDICAL CENTERAZUnitedHealthcareMedicaid|All Plansoutpatientnegotiated$262.85
YAVAPAI REGIONAL MEDICAL CENTERAZacchsMedicaid|All Plansoutpatientnegotiated$262.85
SANTA CRUZ VALLEY REGIONAL HOSPITALAZWellCareMedicaidbothnegotiated$243.98

Rates are point-in-time snapshots from each hospital's machine-readable file. Payers can negotiate different rates for different plans within the same network — this view shows the latest snapshot per (hospital, payer, plan, rate type).