Voice to Congress

Healthcare Metric Source Review Decisions

Compact reviewer decision page. Version 9 adds row-level Auto Populate Investigate, decision filters, metric descriptions, and larger note fields.

Data safety note: This version uses a full CSV parser. Reviewer notes may include URLs, commas, quotes, and line breaks without splitting rows.
Resolution cue: The first column now shows whether the row is still pending, needs field mapping, has a replacement suggested, or has no follow-up required.

Files
Decisions CSV: C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_decisions.csv
Worklist CSV: C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_decision_worklist.csv
Summary TXT: C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_source_review_decision_worklist_summary.txt

Total Rows	Follow-up Required	No Follow-up	Auto Approved	Review Recommended	Stale
44	44	0	16	27	1

Review / Follow-up Only All Decisions Back to Source Review Summary Back to Healthcare Admin Home

Decision Filter: All Decisions REVIEW_OFFICIAL_SOURCE REPLACE_SOURCE NEEDS_FIELD_MAPPING DEFER REJECT APPROVE Current filter: NEEDS_FIELD_MAPPING

Reviewer: Saving creates a dated .bak copy of the decisions CSV.

Metric / Description / Source / Status	URL / Problems / Warnings	Decision / Follow-up / Reviewer Notes
Row: 3 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 86 Metric HC-MET-002 Medical care inflation Description: Measures medical care price inflation using CPI medical care data. Source BLS CPI Medical Care Review key: hc_met_002_bls_cpi_medical_https_www_bls_gov_cpi_factsheets_medical_care_htm	Domain / URL https://www.bls.gov/cpi/factsheets/medical-care.htm Problems / Warnings Warnings: No latest year/as-of date detected. \| BLS official source. \| Medical inflation metrics usually fit BLS CPI medical care data.	Decision Follow-up Follow-up Notes BLS CPI medical care API source promoted. Field mapping needed for CUUR0000SAM time-series extraction and inflation formula. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Approved source is the BLS public API series CUUR0000SAM for CPI-U U.S. city average medical care. Use this source for HC-MET-002 medical care price inflation. Next step is field mapping and formula definition, not source replacement. Investigate: https://www.bls.gov/cpi/factsheets/medical-care.htm
Row: 6 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 80 Metric HC-MET-005 International healthcare spending comparison Description: Compares U.S. healthcare spending and outcomes with peer countries. Source OECD Health Data Review key: hc_met_005_oecd_health_https_www_oecd_org_en_data_datasets_oecd_health_statistics_html	Domain / URL https://www.oecd.org/en/data/datasets/oecd-health-statistics.html Problems / Warnings Warnings: HTTPError: 403 Forbidden \| No latest year/as-of date detected. \| OECD international comparison source. \| Spending/expenditure metrics usually fit CMS NHEA, OECD, or BEA context data. International comparison metrics usually fit OECD, WHO, or World Bank data.	Decision Follow-up Follow-up Notes Promote only to NEEDS_FIELD_MAPPING. Source is valid fixed-width CDC mortality data, but official 2024 CDC layout documentation must be mapped before extraction/scoring. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes CDC mortality ZIP source appears valid but requires fixed-width field mapping before scoring. Data source: https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Datasets/DVS/mortality/mort2024us.zip ZIP inspection found one large text-like fixed-width file: VS24MORT.DUSMCPUB_r20251208 The file appears to use fixed-width records with common line length 817. The ZIP does not contain the layout/codebook. Official CDC documentation is external: https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Dataset_Documentation/DVS/mortality/2024-Mortality-Public-Use-File-Documentation.pdf Use the CDC 2024 Mortality Multiple Cause-of-Death Public Use Record documentation for field mapping before scoring. Candidate fields include data year, sex, age, race, Hispanic origin, underlying cause ICD-10, and cause recodes. Do not use for public scoring until field locations, filters, and formula are defined. Investigate: https://www.oecd.org/en/data/datasets/oecd-health-statistics.html
Row: 12 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 80 Metric HC-SRC-CAND-0018-TEXT-CANDIDATE-SOURCE Review candidate source Metric description not found in the decision/source rows. Before promoting a replacement, confirm what this metric is intended to measure. Source CDC Review key: hc_src_cand_0018_text_candidate_source_cdc_004_https_www_cdc_gov_nchs_data_access_vitalstatsonline_htm	Domain / URL https://www.cdc.gov/nchs/data_access/vitalstatsonline.htm Problems / Warnings Warnings: Metric-to-source fit needs review. \| No latest year/as-of date detected. \| CDC official source. \| No specific metric-source fit rule matched; human review may improve confidence.	Decision Follow-up Follow-up Notes Data-bearing downloads found. Run field-mapping inspection before promoting a replacement. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Investigation result: The URL is data-bearing or leads to downloadable data files. Best candidate found: https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Datasets/DVS/mortality/mort1968us.zip. Link text: 1968 (38 MB). Reason: direct downloadable data/file extension; data file extension signal; data keyword signals: data, dataset, datasets, mortality, zip; authoritative health/government domain. Confirm workbook/file/sheet/field mapping before promoting to approved metric extraction. Investigate: https://www.cdc.gov/nchs/data_access/vitalstatsonline.htm
Row: 23 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 83 Metric HC-SRC-CAND-0080-2026-05-07T19-26-19-HC-S 2026-05-07T19:26:19 \| HC-SRC-HRSA-HPSA-001 \| HRSA Shortage Areas Data Downloads \| download_file \| https://data.hrsa.gov/ Metric description not found in the decision/source rows. Before promoting a replacement, confirm what this metric is intended to measure. Source HRSA Shortage Areas Data Downloads Review key: hc_src_cand_0080_2026_05_07t19_26_19_hc_s_hc_src_hrsa_hpsa_001_https_data_hrsa_gov_datadownload_dd_files_hpsa_datamart_metadata_xlsx	Domain / URL https://data.hrsa.gov/DataDownload/DD_Files/HPSA_DATAMART_METADATA.XLSX Problems / Warnings Warnings: Metric-to-source fit needs review. \| Latest detected year is 2026. \| Government domain, but not in preferred healthcare source list. \| No specific metric-source fit rule matched; human review may improve confidence.	Decision Follow-up Follow-up Notes Data-bearing downloads found. Run field-mapping inspection before promoting a replacement. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Investigation result: The URL is data-bearing or leads to downloadable data files. Best candidate found: https://data.hrsa.gov/DataDownload/DD_Files/HPSA_DATAMART_METADATA.XLSX. Link text: Investigated URL is direct downloadable data. Reason: direct downloadable data/file extension; data file extension signal; data keyword signals: data, download, file, xls, xlsx; authoritative health/government domain; government data portal. Confirm workbook/file/sheet/field mapping before promoting to approved metric extraction. Investigate: https://data.hrsa.gov/DataDownload/DD_Files/HPSA_DATAMART_METADATA.XLSX
Row: 24 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 83 Metric HC-SRC-CAND-0081-2026-05-07T19-26-19-HC-S 2026-05-07T19:26:19 \| HC-SRC-HRSA-HPSA-001 \| HRSA Shortage Areas Data Downloads \| download_file \| https://data.hrsa.gov/ Metric description not found in the decision/source rows. Before promoting a replacement, confirm what this metric is intended to measure. Source HRSA Shortage Areas Data Downloads Review key: hc_src_cand_0081_2026_05_07t19_26_19_hc_s_hc_src_hrsa_hpsa_001_https_data_hrsa_gov_datadownload_dd_files_bcd_hpsa_fct_det_pc_xlsx	Domain / URL https://data.hrsa.gov/DataDownload/DD_Files/BCD_HPSA_FCT_DET_PC.xlsx Problems / Warnings Warnings: Metric-to-source fit needs review. \| Latest detected year is 2026. \| Government domain, but not in preferred healthcare source list. \| No specific metric-source fit rule matched; human review may improve confidence.	Decision Follow-up Follow-up Notes Data-bearing downloads found. Run field-mapping inspection before promoting a replacement. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Investigation result: The URL is data-bearing or leads to downloadable data files. Best candidate found: https://data.hrsa.gov/DataDownload/DD_Files/BCD_HPSA_FCT_DET_PC.xlsx. Link text: Investigated URL is direct downloadable data. Reason: direct downloadable data/file extension; data file extension signal; data keyword signals: data, download, file, xls, xlsx; authoritative health/government domain; government data portal. Confirm workbook/file/sheet/field mapping before promoting to approved metric extraction. Investigate: https://data.hrsa.gov/DataDownload/DD_Files/BCD_HPSA_FCT_DET_PC.xlsx
Row: 25 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 83 Metric HC-SRC-CAND-0082-2026-05-07T19-26-19-HC-S 2026-05-07T19:26:19 \| HC-SRC-HRSA-HPSA-001 \| HRSA Shortage Areas Data Downloads \| download_file \| https://data.hrsa.gov/ Metric description not found in the decision/source rows. Before promoting a replacement, confirm what this metric is intended to measure. Source HRSA Shortage Areas Data Downloads Review key: hc_src_cand_0082_2026_05_07t19_26_19_hc_s_hc_src_hrsa_hpsa_001_https_data_hrsa_gov_datadownload_dd_files_bcd_hpsa_fct_det_pc_csv	Domain / URL https://data.hrsa.gov/DataDownload/DD_Files/BCD_HPSA_FCT_DET_PC.csv Problems / Warnings Warnings: Metric-to-source fit needs review. \| Latest detected year is 2026. \| Government domain, but not in preferred healthcare source list. \| No specific metric-source fit rule matched; human review may improve confidence.	Decision Follow-up Follow-up Notes Data-bearing downloads found. Run field-mapping inspection before promoting a replacement. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Investigation result: The URL is data-bearing or leads to downloadable data files. Best candidate found: https://data.hrsa.gov/DataDownload/DD_Files/BCD_HPSA_FCT_DET_PC.csv. Link text: Investigated URL is direct downloadable data. Reason: direct downloadable data/file extension; data file extension signal; data keyword signals: csv, data, download, file; authoritative health/government domain; government data portal. Confirm workbook/file/sheet/field mapping before promoting to approved metric extraction. Investigate: https://data.hrsa.gov/DataDownload/DD_Files/BCD_HPSA_FCT_DET_PC.csv
Row: 26 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status REVIEW_RECOMMENDED Priority: MEDIUM Confidence: 83 Metric HC-SRC-CAND-0083-2026-05-07T19-26-19-HC-S 2026-05-07T19:26:19 \| HC-SRC-HRSA-HPSA-001 \| HRSA Shortage Areas Data Downloads \| download_file \| https://data.hrsa.gov/ Metric description not found in the decision/source rows. Before promoting a replacement, confirm what this metric is intended to measure. Source HRSA Shortage Areas Data Downloads Review key: hc_src_cand_0083_2026_05_07t19_26_19_hc_s_hc_src_hrsa_hpsa_001_https_data_hrsa_gov_datadownload_dd_files_dd_auto_hpsa_site_metadata_xlsx	Domain / URL https://data.hrsa.gov/DataDownload/DD_Files/DD_AUTO_HPSA_SITE_METADATA.XLSX Problems / Warnings Warnings: Metric-to-source fit needs review. \| Latest detected year is 2026. \| Government domain, but not in preferred healthcare source list. \| No specific metric-source fit rule matched; human review may improve confidence.	Decision Follow-up Follow-up Notes Valid shared source. Census Table 1 XLSX supports multiple Healthcare metrics related to health insurance coverage, coverage type, and uninsured population. Duplicate URL is intentional and should not be treated as an error. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Investigation result: The URL is data-bearing or leads to downloadable data files. Best candidate found: https://data.hrsa.gov/DataDownload/DD_Files/DD_AUTO_HPSA_SITE_METADATA.XLSX. Link text: Investigated URL is direct downloadable data. Reason: direct downloadable data/file extension; data file extension signal; data keyword signals: data, download, file, xls, xlsx; authoritative health/government domain; government data portal. Confirm workbook/file/sheet/field mapping before promoting to approved metric extraction. Investigate: https://data.hrsa.gov/DataDownload/DD_Files/DD_AUTO_HPSA_SITE_METADATA.XLSX
Row: 33 Row Automation Auto Populate Auto Populate + Preview Preview Investigate Apply Investigate Auto Populate adds Investigate: current URL, TAP reviewer, and follow-up YES. Preview/Apply uses Investigate URLs in notes. Resolution Needs field mapping Status AUTO_APPROVED Priority: LOW Confidence: 95 Metric HC-SRC-CAND-0071-2026-05-07T19-26-12-HC-S 2026-05-07T19:26:12 \| HC-SRC-CMS-NHE-001 \| National Health Expenditure Accounts - Historical \| download_file \| https://w Metric description not found in the decision/source rows. Before promoting a replacement, confirm what this metric is intended to measure. Source National Health Expenditure Accounts - Historical Review key: hc_src_cand_0071_2026_05_07t19_26_12_hc_s_hc_src_cms_nhe_001_https_www_cms_gov_files_document_highlights_pdf	Domain / URL https://www.cms.gov/files/document/highlights.pdf Problems / Warnings Warnings: Latest detected year is 2026. \| CMS official source. \| Spending/expenditure metrics usually fit CMS NHEA, OECD, or BEA context data.	Decision Follow-up Follow-up Notes OECD source replacement resolved blocked URL. Field mapping still needed for OECD Data Explorer/API extraction. Auto-populated investigation URL from current source. Click Preview Investigate, then Apply Investigate only if the proposal looks correct. Reviewer Notes Approved replacement candidate: https://www.oecd.org/en/data/datasets/oecd-health-statistics.html Current OECD Health at a Glance 2025 publication URL returns HTTP 403 to the source-review checker. OECD Health Statistics is a better source-review URL because it is the OECD dataset page for comparable health and health-system statistics across OECD countries. Use this as the replacement source for international healthcare spending/outcome comparisons. Field mapping may still require OECD Data Explorer/API-specific extraction. Investigate: https://www.cms.gov/files/document/highlights.pdf

Visible rows: 8

Suggested workflow: review official sources first. If the metric description is missing, do not guess; use Reviewer Notes to record that the metric definition must be enriched. Use Auto Populate when the current source URL should be investigated, or manually add Investigate: URL in Reviewer Notes when you found a better data page. Use Preview Investigate first, then Apply Investigate only after the proposal looks right, then run field-map/promoter scripts when needed. Set Follow-up to NO only when the source is resolved.