# AHRQ NHQDR national and state quality estimates

`medicare_silver.fact_ahrq_nhqdr_quality` · Medicare Advantage, Part D, Medicaid · status live · 855,292 rows

Lossless 855,292-row extract of the official AHRQ National Healthcare Quality and Disparities Report logical table, preserving 666 measures, national and 59 state/territory jurisdiction labels, population subgroups, raw/formatted estimates, error values, footnotes, source links, physical row identity, and exact lineage for data years 1999-2022.

**Grain.** One row per accepted Tableau publisher extract, physical page, and physical row ordinal.

| column | type | meaning |
|---|---|---|
| source_page_number | int |  |
| source_row_ordinal | int |  |
| data_year | int |  |
| measure_id | string |  |
| measure_title | string |  |
| measure_link | string |  |
| source_link | string |  |
| state_code | string |  |
| state_name_raw | string |  |
| estimate_type | string |  |
| estimate_value | double |  |
| estimate_value_raw | string |  |
| estimate_value_status | string |  |
| error_value | double |  |
| error_value_raw | string |  |
| estimate_graph_value | double |  |
| estimate_graph_value_raw | string |  |
| population_category | string |  |
| population_group | string |  |
| population_group_2 | string |  |
| subgroup_description | string |  |
| column_group_name | string |  |
| priority_area | string |  |
| priority_area_copy | string |  |
| section_name | string |  |
| table_title | string |  |
| title | string |  |
| footnote | string |  |
| footnote_type_id | string |  |
| instructions | string |  |
| publisher_row_flag | string |  |
| raw_row_json | string |  |
| exact_row_sha256 | string |  |
| semantic_row_sha256 | string |  |
| publisher_extract_id | string |  |
| 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: `query_substrate` with `SELECT ... FROM medicare_silver.fact_ahrq_nhqdr_quality WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_ahrq_nhqdr_quality")` first.