Medicare Advantage, Part D, Medicaid

CMS Medicaid/CHIP Child and Adult Core Set State Quality

medicare_silver.fact_medicaid_core_set_quality·live·silver

Rows

31,344

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State-level performance rates and comparison benchmarks for CMS Medicaid and CHIP Child and Adult Core Set measures, preserving populations, methodologies, suppression statuses, notes, state comments, and source lineage.

Grain

Key	Grain
N/A	1One publisher row per reporting year, state, reporting program, measure/rate definition, population, and methodology.

Columns (49)

Column	Type	Meaning
`source_row_number`	int
`reporting_year`	int
`state_code`	string
`state_name_raw`	string
`domain`	string
`reporting_program`	string
`measure_name`	string
`measure_abbreviation`	string
`measure_type`	string
`rate_definition`	string
`population`	string
`methodology`	string
`state_rate_raw`	string
`state_rate_numeric`	double
`state_rate_status`	string
`number_states_reporting_raw`	string
`number_states_reporting`	int
`mean_raw`	string
`mean_numeric`	double
`median_raw`	string
`median_numeric`	double
`bottom_quartile_raw`	string
`bottom_quartile_numeric`	double
`top_quartile_raw`	string
`top_quartile_numeric`	double
`notes`	string
`source_description`	string
`state_specific_comments`	string
`benchmark_used_raw`	string
`benchmark_used`	boolean
`semantic_row_sha256`	string
`publisher_dataset_id`	string
`publisher_modified_date`	date
`publisher_schema_era`	string
`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.fact_medicaid_core_set_quality")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_medicaid_core_set_quality WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`reporting_year,state_code,reporting_program,measure_abbreviation,rate_definition,population,methodology`
Join	`how_to_join(source_fqn="medicare_silver.fact_medicaid_core_set_quality")`
Raw door	Athena (read-only): medicare_silver.fact_medicaid_core_set_quality

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