UPMC Hamot

CMS HPT TXT File

Location Name	UPMC Hamot
Source Page URL	https://www.upmc.com/locations/hospitals/hamot/patients-visitors/cdm
MRF URL	https://dam.upmc.com/-/media/upmc/locations/hospitals/documents/cdm-json-files/250965387_upmc-hamot_standardcharges.csv?
Contact Name	Shawn Gronlund
Contact Email	gronlundsp@upmc.edu

Download cms-hpt.txt Download MRF File

MRF File Information

File Name	250965387_upmc-hamot_standardcharges.csv
File Format	Tall CSV
Schema Version	2.x
File Size	84.3 MB
MD5 Hash	09fd9bfb4541bff2c83444e3e83a1e4e
Downloaded	1/12/2026
Last Updated	2025-07-29

Download Metadata

DuckDB Database

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

Database File	upmc_hamot-6dd1c_parsed.duckdb
Database Size	20.0 MB
Source MRF	250965387_upmc-hamot_standardcharges.csv
Last Updated	2025-07-29

Table Row Counts

Standard Charges

15,809

Standard Charge Details

448,420

Modifier Charges

26

Modifier Charge Details

182

Query in Duck-UI → Download Database