# CT Medicaid Inpatient Hospital Base Rates

`vlada_curated.fact_ct_medicaid_provider_rate` · State programs · status live

CT Medicaid (CMAP) inpatient per-hospital base rate keyed to CCN, EULA-free DRG Calculator. 48 hospitals. Tool ingest_ct_medicaid_inpatient.py.

**Grain.** One row per (CT Medicaid provider/procedure) — Medicaid allowed rate.

| column | type | meaning |
|---|---|---|
| medicaid_number | string |  |
| ccn | string |  |
| hospital_name | string |  |
| operating_rate | double |  |
| capital_rate | double |  |
| base_rate | double |  |
| source_url | string |  |
| content_sha256 | string |  |
| asserted_at | string |  |
| is_current | boolean |  |
| effective_year | int |  |

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