VladaOmega
Sign inStart free
State programs

CT Medicaid Inpatient Hospital Base Rates

vlada_curated.fact_ct_medicaid_provider_rate·live·silver·Connecticut Medicaid Inpatient Rates
Rows
N/A
Columns
11
History
N/A
Card
nocolumns only
Typed tools
0

What it is

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

Grain

KeyGrain
N/A
  1. 1One row per (CT Medicaid provider/procedure) — Medicaid allowed rate.

Columns (11)

ColumnTypeMeaning
medicaid_numberstring
ccnstring
hospital_namestring
operating_ratedouble
capital_ratedouble
base_ratedouble
source_urlstring
content_sha256string
asserted_atstring
is_currentboolean
effective_yearint

Query it

describe_data_source(source_fqn="vlada_curated.fact_ct_medicaid_provider_rate")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.fact_ct_medicaid_provider_rate WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keyN/A
Joinhow_to_join(source_fqn="vlada_curated.fact_ct_medicaid_provider_rate")
Raw doorquery_substrate

This page as markdown: /docs-md/data/vlada_curated_fact_ct_medicaid_provider_rate.md · every page in one file: /llms-full.txt