# Hospital chargemaster + payer-specific rates (HPT)

`vlada_curated.fact_hospital_chargemaster` · Hospital price transparency · status live · 4,350,000,000 rows

Cleaned hospital prices extracted from CMS Hospital Price Transparency machine-readable files. Gross / cash / min / max / payer_specific + v3.0 allowed-amount percentile charge types.

**Grain.** One row per (CCN, payer_name, plan, code, code_type, methodology, charge_type) at the file snapshot.

| column | type | meaning |
|---|---|---|
| rate_id | string |  |
| hospital_ccn | string |  |
| hospital_name | string |  |
| hospital_state | string |  |
| billing_code | string |  |
| code_system | string |  |
| alt_codes_hash | string |  |
| code_1 | string |  |
| code_1_type | string |  |
| code_2 | string |  |
| code_2_type | string |  |
| code_3 | string |  |
| code_3_type | string |  |
| code_4 | string |  |
| code_4_type | string |  |
| code_5 | string |  |
| code_5_type | string |  |
| description | string |  |
| payer_name | string |  |
| plan_name | string |  |
| rate_type | string |  |
| rate | double |  |
| min_rate | double |  |
| max_rate | double |  |
| billing_class | string |  |
| setting | string |  |
| modifiers | string |  |
| additional_info | string |  |
| collected_at | string |  |
| code_valid | boolean |  |
| gross_charge | double |  |
| cash_price | double |  |
| methodology | string |  |
| negotiated_pct | double |  |
| negotiated_algo | string |  |
| estimated_amount | double |  |
| drug_unit | string |  |
| drug_type | string |  |
| median_amount | double |  |
| tenth_percentile | double |  |
| ninetieth_percentile | double |  |
| allowed_count | bigint |  |
| version_id | string |  |
| source_files | array<string> |  |
| loaded_at | timestamp |  |
| methodology_statement | string |  |
| lookback_window_start | date |  |
| lookback_window_end | date |  |
| attestation_statement | string |  |
| confirm_attestation | boolean |  |
| attester_name | string |  |
| attester_title | string |  |
| npi_type2 | array<string> |  |
| cms_hpt_txt_probed | boolean |  |
| cms_hpt_txt_url | string |  |
| homepage_footer_link_present | boolean |  |
| content_sha256 | string |  |
| parser_version | string |  |
| mrf_schema_version | string |  |
| fetched_at | timestamp |  |
| raw_s3_key | string |  |
| pbd_npi | string |  |
| is_off_campus_pbd | boolean |  |
| parent_ccn | string |  |
| mrf_version_id | string |  |
| rate_outlier_flag | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| asserted_at_source | string |  |
| calculation_epoch | date |  |
| vintage | string |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| restatement_of | string |  |
| is_current | boolean |  |
| snapshot_set | string |  |
| s3_version_id | string |  |
| bronze_object_key | string |  |
| sha256_content_hash | string |  |
| source_lineage | string |  |
| parent_vintage_fingerprint | string |  |
| source_id | string |  |
| source_url | string |  |
| parser_artifact_hash | string |  |
| ingested_at | timestamp |  |
| count_of_compared_rates | bigint |  |
| additional_payer_notes | string |  |
| footnote | string |  |
| cbsa_code | string |  |
| chain_parent_id | string |  |
| payer_canonical_id | string |  |
| percentage_source | string |  |
| fact_builder_version | string |  |
| payment_grain | string |  |
| grain_confidence | string |  |
| allowed_count_band | string | CMS per-payer allowed-count enum: 0 / 1 through 10 / count >=11 as digits. NULL = absent, invalid, or row built before migration 034. |

Tools that read it: plan_hospital_price, prove_hospital_price, replay_hospital_price, state_expert

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.fact_hospital_chargemaster WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.fact_hospital_chargemaster")` first.