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
9
Payers
20
Negotiated range
$38.62 – $721.8
Negotiated median
$257.3
CPT 71047 Chest X-ray 3 views · Showing 200 of 265 rate rows
↓ Download CSVSee comparison view →
CmpHospitalSTPayerPlanSettingTypeRate
SHELTERING ARMS INSTITUTEVAmedcost/vhn linkHMO/PPOinpatientnegotiated$721.8
SHELTERING ARMS HOSPITALVAmedcost/vhn linkHMO/PPOinpatientnegotiated$721.8
SHELTERING ARMS HOSPITAL SOUTHVAmedcost/vhn linkHMO/PPOinpatientnegotiated$721.8
CARILION TAZEWELL COMMUNITY HOSPITALVAAnthem BCBSCommercialoutpatientnegotiated$459.41
CARILION GILES COMMUNITY HOSPITALVAAnthem BCBSCommercialoutpatientnegotiated$448.61
CARILION STONEWALL JACKSON HOSPITALVAAnthem BCBSCommercialoutpatientnegotiated$426.43
CARILION FRANKLIN MEMORIAL HOSPITALVAAnthem BCBSCommercialoutpatientnegotiated$426.43
CARILION TAZEWELL COMMUNITY HOSPITALVAAnthem BCBSExchangeoutpatientnegotiated$413.47
CARILION GILES COMMUNITY HOSPITALVAAnthem BCBSExchangeoutpatientnegotiated$403.75
CARILION TAZEWELL COMMUNITY HOSPITALVAnational provider networkCommercialoutpatientnegotiated$398.4
CARILION TAZEWELL COMMUNITY HOSPITALVAvhn - secondary payorsCommercialoutpatientnegotiated$394.25
CARILION NEW RIVER VALLEY MED CENTERVAgateway - tier 1Commercialoutpatientnegotiated$394.25
CARILION STONEWALL JACKSON HOSPITALVAvhn - secondary payorsCommercialoutpatientnegotiated$394.25
CARILION FRANKLIN MEMORIAL HOSPITALVAvhn - secondary payorsCommercialoutpatientnegotiated$394.25
CARILION FRANKLIN MEMORIAL HOSPITALVAgateway - tier 1Commercialoutpatientnegotiated$394.25
CARILION STONEWALL JACKSON HOSPITALVAgateway - tier 1Commercialoutpatientnegotiated$394.25
CARILION MEDICAL CENTERVAgateway - tier 1Commercialoutpatientnegotiated$394.25
CARILION TAZEWELL COMMUNITY HOSPITALVAgateway - tier 1Commercialoutpatientnegotiated$394.25
CARILION NEW RIVER VALLEY MED CENTERVAvhn - secondary payorsCommercialoutpatientnegotiated$394.25
CARILION GILES COMMUNITY HOSPITALVAvhn - secondary payorsCommercialoutpatientnegotiated$394.25
CARILION MEDICAL CENTERVAvhn - secondary payorsCommercialoutpatientnegotiated$394.25
CARILION GILES COMMUNITY HOSPITALVAgateway - tier 1Commercialoutpatientnegotiated$394.25
CARILION STONEWALL JACKSON HOSPITALVAAnthem BCBSExchangeoutpatientnegotiated$383.79
CARILION FRANKLIN MEMORIAL HOSPITALVAAnthem BCBSExchangeoutpatientnegotiated$383.79
CARILION FRANKLIN MEMORIAL HOSPITALVAvhn - linkCommercialoutpatientnegotiated$373.5
CARILION GILES COMMUNITY HOSPITALVAvhn - linkCommercialoutpatientnegotiated$373.5
CARILION MEDICAL CENTERVAvhn - linkCommercialoutpatientnegotiated$373.5
CARILION NEW RIVER VALLEY MED CENTERVAvhn - linkCommercialoutpatientnegotiated$373.5
CARILION STONEWALL JACKSON HOSPITALVAvhn - linkCommercialoutpatientnegotiated$373.5
CARILION TAZEWELL COMMUNITY HOSPITALVAvhn - linkCommercialoutpatientnegotiated$373.5
CARILION NEW RIVER VALLEY MED CENTERVAAnthem BCBSCommercialoutpatientnegotiated$369.77
CARILION TAZEWELL COMMUNITY HOSPITALVAintegrated health planCommercialoutpatientnegotiated$352.75
CARILION NEW RIVER VALLEY MED CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$339.22
CARILION MEDICAL CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$339.22
CARILION TAZEWELL COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$339.22
CARILION GILES COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$339.22
CARILION STONEWALL JACKSON HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$339.22
CARILION FRANKLIN MEMORIAL HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$339.22
CARILION NEW RIVER VALLEY MED CENTERVAAnthem BCBSExchangeoutpatientnegotiated$332.79
CARILION MEDICAL CENTERVAgateway - tier 2Commercialoutpatientnegotiated$332
CARILION TAZEWELL COMMUNITY HOSPITALVAvhnCommercialoutpatientnegotiated$332
CARILION TAZEWELL COMMUNITY HOSPITALVAgateway - tier 2Commercialoutpatientnegotiated$332
CARILION STONEWALL JACKSON HOSPITALVAvhnCommercialoutpatientnegotiated$332
CARILION MEDICAL CENTERVAvhnCommercialoutpatientnegotiated$332
CARILION GILES COMMUNITY HOSPITALVAvhnCommercialoutpatientnegotiated$332
CARILION NEW RIVER VALLEY MED CENTERVAvhnCommercialoutpatientnegotiated$332
CARILION GILES COMMUNITY HOSPITALVAgateway - tier 2Commercialoutpatientnegotiated$332
CARILION FRANKLIN MEMORIAL HOSPITALVAgateway - tier 2Commercialoutpatientnegotiated$332
CARILION STONEWALL JACKSON HOSPITALVAgateway - tier 2Commercialoutpatientnegotiated$332
CARILION NEW RIVER VALLEY MED CENTERVAgateway - tier 2Commercialoutpatientnegotiated$332
CARILION FRANKLIN MEMORIAL HOSPITALVAvhnCommercialoutpatientnegotiated$332
CARILION FRANKLIN MEMORIAL HOSPITALVAvhn - plusCommercialoutpatientnegotiated$319.55
CARILION NEW RIVER VALLEY MED CENTERVAvhn - plusCommercialoutpatientnegotiated$319.55
CARILION TAZEWELL COMMUNITY HOSPITALVAvhn - plusCommercialoutpatientnegotiated$319.55
CARILION GILES COMMUNITY HOSPITALVAvhn - plusCommercialoutpatientnegotiated$319.55
CARILION MEDICAL CENTERVAvhn - plusCommercialoutpatientnegotiated$319.55
CARILION STONEWALL JACKSON HOSPITALVAvhn - plusCommercialoutpatientnegotiated$319.55
CARILION MEDICAL CENTERVAAnthem BCBSCommercialoutpatientnegotiated$316.76
CARILION TAZEWELL COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$299.05
CARILION FRANKLIN MEMORIAL HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$299.05
CARILION STONEWALL JACKSON HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$299.05
CARILION MEDICAL CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$299.05
CARILION GILES COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$299.05
CARILION NEW RIVER VALLEY MED CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$299.05
CARILION GILES COMMUNITY HOSPITALVACignaCommercialoutpatientnegotiated$298.8
CARILION MEDICAL CENTERVACignaCommercialoutpatientnegotiated$298.8
CARILION FRANKLIN MEMORIAL HOSPITALVACignaCommercialoutpatientnegotiated$298.8
CARILION STONEWALL JACKSON HOSPITALVACignaCommercialoutpatientnegotiated$298.8
CARILION NEW RIVER VALLEY MED CENTERVACignaCommercialoutpatientnegotiated$298.8
CARILION STONEWALL JACKSON HOSPITALVAconnecticareCommercialoutpatientnegotiated$290.5
CARILION NEW RIVER VALLEY MED CENTERVAconnecticareCommercialoutpatientnegotiated$290.5
CARILION FRANKLIN MEMORIAL HOSPITALVAconnecticareCommercialoutpatientnegotiated$290.5
CARILION MEDICAL CENTERVAconnecticareCommercialoutpatientnegotiated$290.5
CARILION TAZEWELL COMMUNITY HOSPITALVAconnecticareCommercialoutpatientnegotiated$290.5
CARILION GILES COMMUNITY HOSPITALVAconnecticareCommercialoutpatientnegotiated$290.5
CARILION MEDICAL CENTERVAAnthem BCBSExchangeoutpatientnegotiated$285.09
CARILION TAZEWELL COMMUNITY HOSPITALVACignaCommercialoutpatientnegotiated$280.96
CARILION GILES COMMUNITY HOSPITALVACignaCommercialoutpatientnegotiated$279.71
CARILION NEW RIVER VALLEY MED CENTERVACignaCommercialoutpatientnegotiated$279.71
CARILION STONEWALL JACKSON HOSPITALVACignaCommercialoutpatientnegotiated$279.71
CARILION FRANKLIN MEMORIAL HOSPITALVACignaCommercialoutpatientnegotiated$279.71
CARILION MEDICAL CENTERVACignaCommercialoutpatientnegotiated$279.71
CARILION TAZEWELL COMMUNITY HOSPITALVAAetnaCommercialoutpatientnegotiated$275.56
CARILION STONEWALL JACKSON HOSPITALVAAetnaCommercialoutpatientnegotiated$275.56
CARILION MEDICAL CENTERVAAetnaCommercialoutpatientnegotiated$275.56
CARILION NEW RIVER VALLEY MED CENTERVAAetnaCommercialoutpatientnegotiated$275.56
CARILION FRANKLIN MEMORIAL HOSPITALVAAetnaCommercialoutpatientnegotiated$275.56
CARILION GILES COMMUNITY HOSPITALVAAetnaCommercialoutpatientnegotiated$275.56
CARILION TAZEWELL COMMUNITY HOSPITALVACignaCommercialoutpatientnegotiated$263.52
CARILION MEDICAL CENTERVAsentara health planCommercialoutpatientnegotiated$257.3
CARILION GILES COMMUNITY HOSPITALVAsentara health planCommercialoutpatientnegotiated$257.3
CARILION STONEWALL JACKSON HOSPITALVAsentara health planCommercialoutpatientnegotiated$257.3
CARILION STONEWALL JACKSON HOSPITALVAvhn - ultraCommercialoutpatientnegotiated$257.3
CARILION FRANKLIN MEMORIAL HOSPITALVAsentara health planCommercialoutpatientnegotiated$257.3
CARILION TAZEWELL COMMUNITY HOSPITALVAvhn - ultraCommercialoutpatientnegotiated$257.3
CARILION NEW RIVER VALLEY MED CENTERVAsentara health planCommercialoutpatientnegotiated$257.3
CARILION FRANKLIN MEMORIAL HOSPITALVAvhn - ultraCommercialoutpatientnegotiated$257.3
CARILION NEW RIVER VALLEY MED CENTERVAvhn - ultraCommercialoutpatientnegotiated$257.3
CARILION GILES COMMUNITY HOSPITALVAvhn - ultraCommercialoutpatientnegotiated$257.3
CARILION MEDICAL CENTERVAvhn - ultraCommercialoutpatientnegotiated$257.3
CARILION TAZEWELL COMMUNITY HOSPITALVAsentara health planCommercialoutpatientnegotiated$257.3
CARILION TAZEWELL COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$237.26
CARILION MEDICAL CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$237.26
CARILION GILES COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$237.26
CARILION FRANKLIN MEMORIAL HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$237.26
CARILION NEW RIVER VALLEY MED CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$237.26
CARILION STONEWALL JACKSON HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$237.26
CARILION FRANKLIN MEMORIAL HOSPITALVAgateway - tier 3Commercialoutpatientnegotiated$228.25
CARILION MEDICAL CENTERVAgateway - tier 3Commercialoutpatientnegotiated$228.25
CARILION NEW RIVER VALLEY MED CENTERVAgateway - tier 3Commercialoutpatientnegotiated$228.25
CARILION TAZEWELL COMMUNITY HOSPITALVAgateway - tier 3Commercialoutpatientnegotiated$228.25
CARILION GILES COMMUNITY HOSPITALVAgateway - tier 3Commercialoutpatientnegotiated$228.25
CARILION STONEWALL JACKSON HOSPITALVAgateway - tier 3Commercialoutpatientnegotiated$228.25
CARILION STONEWALL JACKSON HOSPITALVAAetnaChoice POS IIoutpatientnegotiated$214.97
CARILION MEDICAL CENTERVAAetnaChoice POS IIoutpatientnegotiated$214.97
CARILION GILES COMMUNITY HOSPITALVAAetnaChoice POS IIoutpatientnegotiated$214.97
CARILION TAZEWELL COMMUNITY HOSPITALVAAetnaChoice POS IIoutpatientnegotiated$214.97
CARILION FRANKLIN MEMORIAL HOSPITALVAAetnaChoice POS IIoutpatientnegotiated$214.97
CARILION NEW RIVER VALLEY MED CENTERVAAetnaChoice POS IIoutpatientnegotiated$214.97
CARILION FRANKLIN MEMORIAL HOSPITALVAAetnaCommercialoutpatientnegotiated$211.24
CARILION STONEWALL JACKSON HOSPITALVAAetnaCommercialoutpatientnegotiated$211.24
CARILION GILES COMMUNITY HOSPITALVAAetnaCommercialoutpatientnegotiated$211.24
CARILION MEDICAL CENTERVAAetnaCommercialoutpatientnegotiated$211.24
CARILION NEW RIVER VALLEY MED CENTERVAAetnaCommercialoutpatientnegotiated$211.24
CARILION TAZEWELL COMMUNITY HOSPITALVAAetnaCommercialoutpatientnegotiated$211.24
CARILION TAZEWELL COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$207.92
CARILION NEW RIVER VALLEY MED CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$207.92
CARILION STONEWALL JACKSON HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$207.92
CARILION MEDICAL CENTERVAUnitedHealthcareCommercialoutpatientnegotiated$207.92
CARILION FRANKLIN MEMORIAL HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$207.92
CARILION GILES COMMUNITY HOSPITALVAUnitedHealthcareCommercialoutpatientnegotiated$207.92
CARILION GILES COMMUNITY HOSPITALVAsentara health planMedicare Advantageoutpatientnegotiated$85.34
CARILION FRANKLIN MEMORIAL HOSPITALVAsentara health planMedicare Advantageoutpatientnegotiated$85.34
CARILION TAZEWELL COMMUNITY HOSPITALVAsentara health planMedicare Advantageoutpatientnegotiated$85.34
CARILION MEDICAL CENTERVAsentara health planMedicare Advantageoutpatientnegotiated$85.34
CARILION STONEWALL JACKSON HOSPITALVAsentara health planMedicare Advantageoutpatientnegotiated$85.34
CARILION NEW RIVER VALLEY MED CENTERVAsentara health planMedicare Advantageoutpatientnegotiated$85.34
CARILION NEW RIVER VALLEY MED CENTERVAAetnaMedicare Advantageoutpatientnegotiated$83.72
CARILION FRANKLIN MEMORIAL HOSPITALVAUnitedHealthcareMedicare Advantageoutpatientnegotiated$83.72
CARILION GILES COMMUNITY HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$83.72
CARILION STONEWALL JACKSON HOSPITALVAUnitedHealthcareMedicare Advantageoutpatientnegotiated$83.72
CARILION NEW RIVER VALLEY MED CENTERVAUnitedHealthcareMedicare Advantageoutpatientnegotiated$83.72
CARILION TAZEWELL COMMUNITY HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$83.72
CARILION TAZEWELL COMMUNITY HOSPITALVAUnitedHealthcareMedicare Advantageoutpatientnegotiated$83.72
CARILION MEDICAL CENTERVAUnitedHealthcareMedicare Advantageoutpatientnegotiated$83.72
CARILION FRANKLIN MEMORIAL HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$83.72
CARILION GILES COMMUNITY HOSPITALVAUnitedHealthcareMedicare Advantageoutpatientnegotiated$83.72
CARILION STONEWALL JACKSON HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$83.72
CARILION MEDICAL CENTERVAAetnaMedicare Advantageoutpatientnegotiated$83.72
CARILION FRANKLIN MEMORIAL HOSPITALVAAnthem BCBSMedicare Advantageoutpatientnegotiated$82.91
CARILION FRANKLIN MEMORIAL HOSPITALVAHumanaMedicare Advantageoutpatientnegotiated$82.91
CARILION TAZEWELL COMMUNITY HOSPITALVAAnthem BCBSMedicare Advantageoutpatientnegotiated$82.91
CARILION TAZEWELL COMMUNITY HOSPITALVAHumanaMedicare Advantageoutpatientnegotiated$82.91
CARILION NEW RIVER VALLEY MED CENTERVAHumanaMedicare Advantageoutpatientnegotiated$82.91
CARILION GILES COMMUNITY HOSPITALVAAnthem BCBSMedicare Advantageoutpatientnegotiated$82.91
CARILION NEW RIVER VALLEY MED CENTERVAAnthem BCBSMedicare Advantageoutpatientnegotiated$82.91
CARILION GILES COMMUNITY HOSPITALVAHumanaMedicare Advantageoutpatientnegotiated$82.91
CARILION STONEWALL JACKSON HOSPITALVAAnthem BCBSMedicare Advantageoutpatientnegotiated$82.91
CARILION MEDICAL CENTERVAHumanaMedicare Advantageoutpatientnegotiated$82.91
CARILION MEDICAL CENTERVAAnthem BCBSMedicare Advantageoutpatientnegotiated$82.91
CARILION STONEWALL JACKSON HOSPITALVAHumanaMedicare Advantageoutpatientnegotiated$82.91
CARILION TAZEWELL COMMUNITY HOSPITALVAallcareRespite Careoutpatientnegotiated$81.28
CARILION GILES COMMUNITY HOSPITALVAHumanaDual Eligibleoutpatientnegotiated$79.65
CARILION TAZEWELL COMMUNITY HOSPITALVAHumanaDual Eligibleoutpatientnegotiated$79.65
CARILION STONEWALL JACKSON HOSPITALVAHumanaDual Eligibleoutpatientnegotiated$79.65
CARILION NEW RIVER VALLEY MED CENTERVAHumanaDual Eligibleoutpatientnegotiated$79.65
CARILION MEDICAL CENTERVAHumanaDual Eligibleoutpatientnegotiated$79.65
CARILION FRANKLIN MEMORIAL HOSPITALVAHumanaDual Eligibleoutpatientnegotiated$79.65
CARILION STONEWALL JACKSON HOSPITALVAHumanaTricareoutpatientnegotiated$77.79
CARILION TAZEWELL COMMUNITY HOSPITALVAHumanaTricareoutpatientnegotiated$77.79
CARILION GILES COMMUNITY HOSPITALVAHumanaTricareoutpatientnegotiated$77.79
CARILION MEDICAL CENTERVAHumanaTricareoutpatientnegotiated$77.79
CARILION NEW RIVER VALLEY MED CENTERVAHumanaTricareoutpatientnegotiated$77.79
CARILION FRANKLIN MEMORIAL HOSPITALVAHumanaTricareoutpatientnegotiated$77.79
CARILION MEDICAL CENTERVAAetnaMedicare Advantageoutpatientnegotiated$76.4
CARILION STONEWALL JACKSON HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$76.4
CARILION NEW RIVER VALLEY MED CENTERVAAetnaMedicare Advantageoutpatientnegotiated$76.4
CARILION TAZEWELL COMMUNITY HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$76.4
CARILION GILES COMMUNITY HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$76.4
CARILION FRANKLIN MEMORIAL HOSPITALVAAetnaMedicare Advantageoutpatientnegotiated$76.4
CARILION STONEWALL JACKSON HOSPITALVAFirst HealthManaged Medicaidoutpatientnegotiated$39.7
CARILION NEW RIVER VALLEY MED CENTERVAHumanaManaged Medicaidoutpatientnegotiated$39.7
CARILION NEW RIVER VALLEY MED CENTERVAFirst HealthManaged Medicaidoutpatientnegotiated$39.7
CARILION FRANKLIN MEMORIAL HOSPITALVAHumanaManaged Medicaidoutpatientnegotiated$39.7
CARILION GILES COMMUNITY HOSPITALVAFirst HealthManaged Medicaidoutpatientnegotiated$39.7
CARILION TAZEWELL COMMUNITY HOSPITALVAHumanaManaged Medicaidoutpatientnegotiated$39.7
CARILION GILES COMMUNITY HOSPITALVAHumanaManaged Medicaidoutpatientnegotiated$39.7
CARILION NEW RIVER VALLEY MED CENTERVAUnitedHealthcareManaged Medicaidoutpatientnegotiated$39.7
CARILION TAZEWELL COMMUNITY HOSPITALVAFirst HealthManaged Medicaidoutpatientnegotiated$39.7
CARILION STONEWALL JACKSON HOSPITALVAHumanaManaged Medicaidoutpatientnegotiated$39.7
CARILION TAZEWELL COMMUNITY HOSPITALVAUnitedHealthcareManaged Medicaidoutpatientnegotiated$39.7
CARILION MEDICAL CENTERVAFirst HealthManaged Medicaidoutpatientnegotiated$39.7
CARILION STONEWALL JACKSON HOSPITALVAUnitedHealthcareManaged Medicaidoutpatientnegotiated$39.7
CARILION MEDICAL CENTERVAUnitedHealthcareManaged Medicaidoutpatientnegotiated$39.7
CARILION MEDICAL CENTERVAHumanaManaged Medicaidoutpatientnegotiated$39.7
CARILION FRANKLIN MEMORIAL HOSPITALVAFirst HealthManaged Medicaidoutpatientnegotiated$39.7
CARILION GILES COMMUNITY HOSPITALVAUnitedHealthcareManaged Medicaidoutpatientnegotiated$39.7
CARILION FRANKLIN MEMORIAL HOSPITALVAUnitedHealthcareManaged Medicaidoutpatientnegotiated$39.7
CARILION FRANKLIN MEMORIAL HOSPITALVAsentara health planManaged Medicaidoutpatientnegotiated$38.62
CARILION STONEWALL JACKSON HOSPITALVAsentara health planManaged Medicaidoutpatientnegotiated$38.62

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).