# prove_hospital_price

Prove Hospital Price · v1.5.0 · hospital

One hospital, one code, the rate by payer and plan name with a receipt (where negotiated rates by insurer live today; the insurer-file / TiC tools are coming soon). Execute a bounded hospital chargemaster price proof and return rate summary values plus a receipt with source snapshot, filters, raw byte provenance, caveats, input hash, response hash, and replay pointer.

**Inputs.**
- `hospital_ccn` (required): 
- `billing_code` (required): 
- `version_id`: 
- `payer_name`: 
- `plan_name`: 
- `billing_class`: 
- `current_only`: 
- `require_byte_provenance`: 
- `max_rows`: 
- `max_planned_files`: 
- `max_planned_bytes`: 

**A real answer** (customer seat, 2.95 s, args `{"hospital_ccn":"070005","billing_code":"70450","max_rows":60}`):

```json
{
 "value": {
  "proof_kind": "hospital_price_proof",
  "source_table": "fact_hospital_chargemaster",
  "hospital_ccn": "070005",
  "billing_code": "70450",
  "version_id": null,
  "planned_file_count": 1,
  "planned_bytes": 93233000,
  "planned_record_count": 1908186,
  "planned_delete_file_count": 0,
  "plan_manifest_hash": "432b007b75d09646abed67f2ed3107945c3e9902b0518a03d1cffbceaa5b8abb",
  "row_count": 52,
  "status": "ok",
  "all_rows_have_byte_provenance": true,
  "distinct_payer_names": [
   "Aetna",
   "Anthem",
   "Anthem Pathway",
   "Cigna",
   "ConnectiCare",
   "DE-IDENTIFIED",
   "Evernorth Behavioral Health",
   "HOSPITAL",
   "United Behavioral Health",
   "United Healthcare"
  ],
  "distinct_plan_names": [
   "Aggregate Min/Max",
   "Cash Pay",
   "Commercial",
   "Gross Charge",
   "Medicare"
  ],
  "distinct_billing_classes": [
   "facility"
  ],
  "distinct_methodologies": [
   "",
   "case rate",
   "fee schedule",
   "other",
   "percent of total billed charges"
  ],
  "distinct_content_sha256": [
   "9a33aa0b5c67cc2a3c5cee0115ffa2bcf15f6ad5dd0dc69044111bdfdc1064fc"
  ],
  "distinct_raw_s3_keys": [
   "raw_archive/hospital/ccn=070005/9a33aa0b5c67cc2a3c5cee0115ffa2bcf15f6ad5dd0dc69044111bdfdc1064fc.csv"
  ],
  "distinct_mrf_version_ids": [
   "d9385d8c-2051-4955-9ae4-ff855c3ce334"
  ],
  "rate_count": 7,
  "min_rate": 44.03,
  "median_rate": 192.38,
  "p10_rate": 44.03,
  "p90_rate": 357.7,
  "max_rate": 357.7,
  "rate_basis": "fee_schedule",
  "rate_basis_natural_family": "fee_schedule",
  "rate_basis_rule": "min/p10/median/p90/max are over ONE payment basis: the code's natural family (fee_schedule) when posted, else a negotiated dollar with no stated methodology, else the other line/admission family. Gross charge, cash, percent-of-charge, per-diem and non-dollar forms are never pooled into it; each is in rates_by_basis.",
  "rates_by_basis": {
   "case_rate": {
    "row_count": 4,
    "seated": false,
    "rate_count": 4,
    "min_rate": 466.0,
    "median_rate": 524.5,
    "p10_rate": 466.0,
    "p90_rate": 583.0,
    "max_rate": 583.0
   },
   "cash": {
    "row_count": 4,
    "seated": false,
    "rate_count": 4,
    "min_rate": 958.85,
    "median_rate": 958.85,
    "p10_rate": 958.85,
    "p90_rate": 958.85,
    "max_rate": 958.85
   },
   "fee_schedule": {
    "row_count": 7,
    "seated": true,
    "rate_count": 7,
    "min_rate": 44.03,
    "median_rate": 192.38,
    "p10_rate": 44.03,
    "p90_rate": 357.7,
    "max_rate": 357.7
   },
   "gross_charge": {
    "row_count": 4,
    "seated": false,
    "rate_count": 4,
    "min_rate": 1917.69,
    "median_rate": 1917.69,
    "p10_rate": 1917.69,
    "p90_rate": 1917.69,
    "max_rate": 1917.69
   },
   "negotiated_methodology_unstated": {
    "row_count": 1,
    "seated": false,
    "rate_count": 1,
    "min_rate": 44.03,
    "median_rate": 44.03,
    "p10_rate": 44.03,
    "p90_rate": 44.03,
    "max_rate": 44.03
   },
   "non_dollar_form": {
    "row_count": 28,
    "seated": false,
    "rate_count": 0,
    "min_rate": null,
    "median_rate": null,
    "p10_rate": null,
    "p90_rate": null,
    "max_rate": null
   },
   "percent_of_charge": {
    "row_count": 4,
    "seated": false,
    "rate_count": 4,
    "min_rate": 660.84,
    "median_rate": 809.845,
    "p10_rate": 660.84,
    "p90_rate": 958.85,
    "max_rate": 958.85
   }
  },
  "all_rows_rate_count": 24,
  "rates_outside_basis_count": 17,
  "rate_basis_settings": {
   "outpatient": 7
  },
  "rate_basis_billing_classes": {
   "facility": 7
  },
  "summary_source": "fact_hospital_chargemaster",
  "verdict": "ok"
 },
 "unit": "USD",
 "vintage": null,
 "methodology": null,
 "caveats": [],
 "response_hash": "52caf8290716e14507686956574934dc7f25ba8404cb5784cf1caaddab47d113",
 "semantic_version": 1,
 "tool_version": "prove_hospital_price@1.5.0",
 "explanation": null,
 "status": "complete",
 "proof_id": "hospitalprice_19f06a3112497ebd",
 "receipt": {
  "receipt_version": "hospital_price_proof_receipt.v0",
  "substrate": "hospital",
  "proof_kind": "hospital_price_proof",
  "proof_id": "hospitalprice_19f06a3112497ebd",
  "tool_name": "prove_hospital_price",
  "tool_version": "1.5.0",
  "source_table": "fact_hospital_chargemaster",
  "source_descriptor": {
   "table": "fact_hospital_chargemaster",
   "snapshot_id": "4789942790573672775",
   "raw_s3_keys": [
    "raw_archive/hospital/ccn=070005/9a33aa0b5c67cc2a3c5cee0115ffa2bcf15f6ad5dd0dc69044111bdfdc1064fc.csv"
   ],
   "content_sha256": [
    "9a33aa0b5c67cc2a3c5cee0115ffa2bcf15f6ad5dd0dc69044111bdfdc1064fc"
   ],
   "mrf_version_ids": [
    "d9385d8c-2051-4955-9ae4-ff855c3ce334"
   ],
   "source_urls": [
    "https://vlada-platform-raw.s3.amazonaws.com/raw_archive/hospital/ccn%3D070005/9a33aa0b5c67cc2a3c5cee0115ffa2bcf15f6ad5dd0dc69044111bdfdc1064fc.csv"
   ],
   "parser_artifact_hashes": [
    "78df2514944e674eabf04d07f17a93ea1ab6255c6fff2bd4b3ec79d314e4a2b9"
   ],
   "s3_version_ids": []
  },
  "read_snapshot_set": {
   "fact_hospital_chargemaster": "4789942790573672775"
  },
  "filters": {
   "hospital_ccn": "070005",
   "billing_code": "70450",
   "current_only": true
  },
  "guardrails": {
   "max_rows": 60,
   "max_planned_files": 500,
   "max_planned_bytes": 268435456,
   "current_only": true,
   "require_byte_provenance": true,
   "raw_parquet_glob_reads": "disabled",
   "shared_mrf_expansion": "not_performed_mvp"
  },
  "plan": {
   "planned_file_count": 1,
   "planned_bytes": 93233000,
   "planned_record_count": 1908186,
   "planned_delete_file_count": 0,
   "plan_manifest_hash": "432b007b75d09646abed67f2ed3107945c3e9902b0518a03d1cffbceaa5b8abb",
   "planned_files_sample": [
    "data/_VXeSg/hospital_state=CT/hospital_ccn=070005/20261002_010134_00448_k6qzf-35fcae15-3a2d-46e0-8d5d-644da8afbb0b.parquet"
   ]
  },
  "evidence": {
   "plan": {
    "planned_file_count": 1,
    "planned_bytes": 93233000,
    "planned_record_count": 1908186,
    "planned_delete_file_count": 0,
    "plan_manifest_hash
... (truncated)
```

REST: `POST https://api.vladahealth.com/v1/tools/prove_hospital_price` with the inputs as the JSON body. MCP: the tool by name.