State programs

CT OHS Hospital Cost-to-Charge Ratios

vlada_curated.fact_ct_hospital_cost_to_charge·live·silver
Rows
N/A
Columns
8
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1CT per-hospital cost-to-charge ratio (RCC, FY2024), 27 hospitals/6 systems.
  2. 2JS-rendered /-/media/ link found via headless browse.
  3. 3Tool ingest_ct_ohs_ccr.py.

Grain

KeyGrain
N/A
  1. 1One row per (hospital, year) — CT hospital cost-to-charge ratio.

Columns (8)

ColumnTypeMeaning
hospital_namestring
hospital_systemstring
cost_to_charge_ratiodouble
report_yearint
source_urlstring
content_sha256string
asserted_atstring
is_currentboolean

Query it

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

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