New York Hospital Price Transparency: Negotiated Rates

Name: New York Hospital Price Transparency: Negotiated Rates
Creator: Douro Data
Published: 2026-06-13T22:32:52+08:00

Snowflake2026-06-16 更新2026-06-18 收录

医疗支付费率基准比较

医院定价透明度

数据链接：

https://app.snowflake.com/marketplace/listing/GZTSZ25YL20 数据链接链接失效反馈

官方服务：

资源简介：

Tens of millions of hospital-published negotiated dollar rates across 130+ New York hospitals, including NewYork-Presbyterian. CCN-keyed, methodology- and setting-aware, payer-canonicalized, audit-flagged. This is the benchmark companion to our free directory of 150+ NY hospitals: the directory lists every hospital we hold data for, and 130+ of them publish the negotiated dollar rates you benchmark with here (the rest are almost all New York State psychiatric centers that publish standard charges only). The paid product bundles that full directory plus standard charges and a CMS-compliance-violations table. Douro Data turns raw hospital machine-readable price files into clean, query-ready pricing data built for one job: walking into a payer renegotiation knowing exactly what that payer pays your peers. Every negotiated-rate row carries the payer, the contract methodology (case rate, per diem, fee schedule), the rate basis, the care setting, and the procedure code with its type, so you compare dollars to dollars in the same setting on the same methodology, without doing the normalization yourself. The standard-charges surface adds the four CMS-required charges (gross, discounted cash, de-identified minimum and maximum) for the same items. Only records that clear a strict quality gate are published; percent-of-charges contracts surface as a compliance signal, not a benchmarkable rate. A canonical payer key (PAYER_CANONICAL) plus a line-of-business tag collapses the hospital-reported payer-name variants for New York's major payers into single parent entities, so a commercial Aetna comparison never silently absorbs Aetna Medicaid or Medicare Advantage. About two-thirds of negotiated-dollar rows are mapped to a parent today; the rest keep their source PAYER_NAME, present on every row, so the long tail stays matchable. Nothing is dropped. Every row also carries an additive AUDIT_FLAG. We never alter or remove a published value, but where a file shows a source-side fill (magic numbers, $0.01 placeholders) or a blanket plateau, we say so on the row, with the evidence available on request. You choose whether to exclude those rows; both filter recipes are documented. That is the difference: we do not dress up chargemaster placeholders as benchmarks. We lead on hospital-side data quality and provenance, keep contract methodology and care setting first-class so your averages never mix per-diems with case rates, and surface the CMS compliance violations most competitors bury, at a price that does not require an enterprise procurement cycle.

提供机构：

Douro Data

创建时间：

2026-06-13

原始信息汇总

数据集概述：纽约医院价格透明度：协商费率

提供方： Douro Data

核心内容： 该数据集包含来自130多家纽约医院（包括纽约长老会医院）发布的数千万条协商美元费率数据。数据经过整理，包含CMS认证号码（CCN）、方法论、护理环境、支付方规范化以及审计标记等信息。它是其免费纽约医院目录的基准配套数据集。

主要特性：

数据覆盖面： 涵盖130多家纽约医院，包括主要的医疗系统。
数据粒度： 每一条协商费率记录都包含支付方、合同方法论（例如：按病例收费、按日收费、费用表）、费率基础、护理环境以及含类型的手术代码。
支付方规范化： 提供了一个规范的支付方键（PAYER_CANONICAL）和业务线标签，将医院报告的支付方名称变体归并为单一母公司实体（例如，将商业Aetna与Aetna Medicaid或Medicare Advantage区分）。大约三分之二的协商美元行已映射到母公司，其余保留原始支付方名称。
数据质量与审计： 每行数据都带有一个附加的审计标志（AUDIT_FLAG），用于区分真实的按服务定价与来源方填充值（如魔法数字、0.01美元占位符或平顶值）。数据集不更改或删除已发布的值，用户可选择是否排除带审计标记的行。
合规性数据： 包含一个CMS合规性违规表，记录了对医院价格透明度合规性的检查结果。
标准收费： 数据集还包含CMS要求的四种标准收费（总收费、折扣现金价、去标识化的最低和最高价）。

数据表：