Medicare Advantage, Part D, Medicaid

CMS IPPS Impact physical provider rows

medicare_silver.ipps_impact_provider_row·live·silver

Rows

428,432

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Full FY1994 through FY2027 proposed physical Impact history with 428,432 rows, retaining proposed/final/correction releases and alternate encodings plus promoted CCN, hospital name, wage area/index, teaching ratio, beds, DSH, uncompensated-care, CCR, case-mix, outlier, provider-type, hospital-specific-rate, and modeled-case fields alongside lossless raw headers and cells.

Grain

Key	Grain
N/A	1One physical provider row per observed period, Impact asset, document, sheet, and source row.

Columns (53)

Column	Type	Meaning
`corpus_snapshot_date`	date
`asset_id`	string
`fiscal_year`	int
`rule_stage`	string
`release_id`	string
`document_path`	string
`sheet_name`	string
`source_row_number`	bigint
`source_encoding`	string
`ccn`	string
`provider_name`	string
`geographic_labor_market_area`	string
`payment_labor_market_area`	string
`county_fips`	string
`wage_index`	double
`resident_to_bed_ratio`	double
`beds`	int
`average_daily_census`	double
`operating_dsh_adjustment`	double
`capital_dsh_adjustment`	double
`dsh_patient_percentage`	double
`uncompensated_care_factor`	double
`uncompensated_care_per_claim`	double
`operating_cost_to_charge_ratio`	double
`capital_cost_to_charge_ratio`	double
`provider_type`	string
`hospital_specific_rate`	double
`medicare_cases`	double
`current_case_mix_index`	double
`operating_outlier_factor`	double
`capital_outlier_factor`	double
`raw_headers_json`	string
`raw_cells_json`	string
`raw_row_json`	string
`semantic_row_sha256`	string
`is_current_release`	boolean
`quality_flags`	string
`is_analytics_eligible`	boolean
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

describe_data_source(source_fqn="medicare_silver.ipps_impact_provider_row")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ipps_impact_provider_row WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`observed_period,asset_id,document_path,sheet_name,source_row_number`
Join	`how_to_join(source_fqn="medicare_silver.ipps_impact_provider_row")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ipps_impact_provider_row

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