Hospital MRF Data Directory by Trilliant Health

UCSF Health St. Mary's Hospital

CMS HPT TXT File

Location Name UCSF Health St. Mary's Hospital
Source Page URL
https://sfcommunityhospitals.ucsfhealth.org/st-marys/patients-and-visitors/for-patients/billing-and-payment/hospital-pricing-transparency
MRF URL
https://app.box.com/index.php?rm=box_download_shared_file&shared_name=xsx8jxwcakpxzg78pfllolwmhrhcifxh&file_id=f_1732344688129
Contact Name Laura Jimenez
Contact Email Laura.Jimenez@ucsf.edu
Download cms-hpt.txt Download MRF File

MRF File Information

File Name index.php
File Format JSON
Schema Version 2.x
File Size 77.0 MB
MD5 Hash c4e4acd50c74036b510a1b6df95c49a0
Downloaded 1/12/2026
Last Updated 2025-09-30
Download Metadata

DuckDB Database

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

Database File
ucsf_health_st_marys_hospital-e4678_parsed.duckdb
Database Size 31.5 MB
Source MRF index.php
Last Updated 2025-09-30

Table Row Counts

Standard Charges
23,430
Standard Charge Details
450,993
Modifier Charges
4
Modifier Charge Details
62
Query in Duck-UI → Download Database