Browse All A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Download All

Mercy San Juan Medical Center

CMS HPT TXT File

Location Name	Mercy San Juan Medical Center
Source Page URL	https://www.dignityhealth.org/sacramento/patients-and-visitors/for-patients/billing-information/hospital-pricing-transparency
MRF URL	https://www.dignityhealth.org/content/dam/dignity-health/documents/mrf-json/northern-california/json/941196203_mercy-san-juan-medical-center_standardcharges.json?target=%22_blank%22
Contact Name	Price Transparency Coordinator
Contact Email	pricetransparency@commonspirit.org

Download cms-hpt.txt Download MRF File

MRF File Information

File Name	941196203_mercy-san-juan-medical-center_standardcharges.json
File Type	JSON
File Size	118.7MB
MD5 Hash	932cb723e7474c98d0089fa6bb73a893
Downloaded	11/8/2025, 12:37:31 AM
Modified	11/8/2025, 12:37:31 AM

Download Metadata

DuckDB Database

Parsed and optimized database file ready for querying. Contains all MRF data in a high-performance analytical format.

Database File	mercy_san_juan_medical_center-64bca_parsed.duckdb
Database Size	44.8 MB
Source MRF	941196203_mercy-san-juan-medical-center_standardcharges.json
Last Updated	2025-09-30

Table Row Counts

Standard Charges

30,763

Standard Charge Details

693,203

Modifier Charges

4

Modifier Charge Details

45

Query in Duck-UI → Download Database