ERROR: Python executable not found:
C:\Users\John W Beck\AppData\Local\Python\bin\python.exe

Healthcare Review Queue Summary
===============================

Generated: 2026-05-13 07:43:42
Source CSV: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\source_data\healthcare_metric_sources.csv (44 rows)
Decision CSV: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_decisions.csv (44 rows)
Audit CSV: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\40 - Metrics\App_Data\healthcare_metric_source_review_audit.csv (44 rows)
Verification actionable CSV: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_source_review_verification_v2_actionable.csv (23 rows)

Queue counts:
  SOURCE_REVIEW: 18
  FIELD_MAPPING: 5
  RESOLVED: 21
  CLEANUP_CONTEXT: 0

Decision counts:
  APPROVE_AUTO: 15
  REPLACE_SOURCE: 12
  REVIEW_OFFICIAL_SOURCE: 8
  NEEDS_FIELD_MAPPING: 5
  REFERENCE_SOURCE: 4

Source Review Queue decision mix:
  REPLACE_SOURCE: 10
  REVIEW_OFFICIAL_SOURCE: 8

Field Mapping Queue domains:
  api.bls.gov: 1
  ftp.cdc.gov: 1
  www.cms.gov: 1
  www2.census.gov: 1
  www.oecd.org: 1

Source Review Queue domains:
  www.cms.gov: 7
  www.ahrq.gov: 4
  www.cdc.gov: 3
  www.census.gov: 2
  www2.census.gov: 2

Highest priority next actions:
  1. Work healthcare_source_review_queue.csv first for rows needing replacement or official-source decisions.
  2. Work healthcare_field_mapping_queue.csv separately for rows with good sources but unresolved table/API/field mappings.
  3. Do not treat field-mapping rows as failed source review; they are the next phase.

Outputs:
  Source review queue: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_queue.csv
  Field mapping queue: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_field_mapping_queue.csv
  Resolved queue: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_resolved_source_queue.csv
  Cleanup/context queue: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_cleanup_context_queue.csv
  JSON: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_review_queues.json

Important caution:
  These queues organize work. They do not prove the final extraction field or scoring formula.

Healthcare Source Review Queue v3 Action Plan Summary
=====================================================

Generated: 2026-05-12 20:36:23
Input CSV: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_queue_auto_preview_v3.csv (20 rows)

Triage action counts:
  MOVE_TO_FIELD_MAPPING: 11
  MANUAL_REVIEW_HOLD: 6
  SAFE_PROMOTE_REVIEW: 2
  NEEDS_REPLACEMENT_RESEARCH: 1

Proposed decision counts from v3:
  NEEDS_FIELD_MAPPING: 11
  REVIEW_OFFICIAL_SOURCE: 5
  REPLACE_SOURCE: 4

Rows by triage action:

SAFE_PROMOTE_REVIEW:
  Row 6: HC-SRC-CAND-0018-TEXT-CANDIDATE-SOURCE
    Current: https://www.cdc.gov/nchs/data_access/vitalstatsonline.htm
    Candidate: https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Datasets/DVS/mortality/mort2024us.zip
    Safety: PROMOTION_CANDIDATE | Score: 125 | Direct: YES
    Reason: High-score direct data candidate; promote only after human row review.
  Row 13: HC-SRC-CAND-0233-HC-SRC-CMS-NHE-001-NATIO
    Current: https://www.cms.gov/data-research/statistics-trends-and-reports/national-health-expenditure-data/nhe-fact-sheet
    Candidate: https://www.cms.gov/files/zip/nhe-tables.zip
    Safety: PROMOTION_CANDIDATE | Score: 125 | Direct: YES
    Reason: High-score direct data candidate; promote only after human row review.

MOVE_TO_FIELD_MAPPING:
  Row 1: HC-SRC-CAND-0016-TEXT-CANDIDATE-SOURCE
    Current: https://www.census.gov/programs-surveys/cps.html
    Candidate: https://www.census.gov/data/tables/time-series/demo/income-poverty/cps-pov.html
    Safety: WEAK_CANDIDATE | Score: 37 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 7: HC-SRC-CAND-0017-TEXT-CANDIDATE-SOURCE
    Current: https://www.census.gov/programs-surveys/cps/technical-documentation.html
    Candidate: https://www.census.gov/programs-surveys/decennial-census/about/rdo/summary-files.html
    Safety: WEAK_CANDIDATE | Score: 34 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 8: HC-MET-006
    Current: https://www.ahrq.gov/data/index.html
    Candidate: https://www.cms.gov/medicare-coverage-database
    Safety: WEAK_CANDIDATE | Score: 31 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 9: HC-SMART-COST-001
    Current: https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/NationalHealthExpendData/NHE-Fact-Sheet.html
    Candidate: https://www.cdc.gov/nchs/nvss/deleted_items_from_birth_fetal_death_files.htm
    Safety: WEAK_CANDIDATE | Score: 31 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 10: HC-MET-004
    Current: https://www.cdc.gov/nchs/
    Reason: Current source appears to be a data landing page but no direct replacement candidate was selected.
  Row 11: HC-SRC-CAND-0032-SRC-CMS-MEASURES-CMS-MEA
    Current: https://www.cms.gov/medicare/quality/measures/cms-measures-inventory
    Candidate: https://www.census.gov/programs-surveys/decennial-census/about/rdo/summary-files.html
    Safety: WEAK_CANDIDATE | Score: 34 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 14: HC-SRC-CAND-0234-HC-SRC-CMS-ACA-001-ACA-M
    Current: https://www.cms.gov/newsroom/press-releases/over-24-million-consumers-selected-affordable-health-coverage-aca-marketplace-2025
    Candidate: https://www.cms.gov/about-cms/contact/database
    Safety: WEAK_CANDIDATE | Score: 31 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 17: HC-SRC-CAND-0073-2026-05-07T19-26-12-HC-S
    Current: https://www.cms.gov/files/zip/national-health-expenditures-type-service-source-funds-cy-1960-2024.zip
    Candidate: https://www.cms.gov/files/zip/national-health-expenditures-type-service-source-funds-cy-1960-2024.zip
    Safety: PROMOTION_CANDIDATE | Score: 114 | Direct: YES
    Reason: Current source is already data-bearing.
  Row 18: HC-SRC-CAND-0074-2026-05-07T19-26-12-HC-S
    Current: https://www.cms.gov/files/zip/nhe-summary-including-share-gdp-cy-1960-2024.zip
    Candidate: https://www.cms.gov/medicare-coverage-database
    Safety: WEAK_CANDIDATE | Score: 31 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 19: HC-SRC-CAND-0026-SRC-CDC-LEX-CDC-NCHS-FAS
    Current: https://www.cdc.gov/nchs/fastats/life-expectancy.htm
    Candidate: https://www.cms.gov/medicare-coverage-database
    Safety: WEAK_CANDIDATE | Score: 31 | Direct: NO
    Reason: Source appears to be a data landing page; identify exact dataset/table/field.
  Row 28: HC-SRC-CAND-0078-2026-05-07T19-26-13-HC-S
    Current: https://www2.census.gov/programs-surveys/demo/tables/p60/288/tableA1.xlsx
    Candidate: https://www2.census.gov/programs-surveys/demo/tables/p60/288/tableA1.xlsx
    Safety: PROMOTION_CANDIDATE | Score: 120 | Direct: YES
    Reason: Current source is already data-bearing.

NEEDS_REPLACEMENT_RESEARCH:
  Row 20: HC-SRC-CAND-0031-SRC-AHRQ-NHQDR-AHRQ-NATI
    Current: https://www.ahrq.gov/research/findings/nhqrdr/index.html
    Reason: No replacement candidate found.

MANUAL_REVIEW_HOLD:
  Row 5: HC-SRC-CAND-0006-TEXT-CANDIDATE-SOURCE
    Current: https://www.cdc.gov/nchs/nvss/life-expectancy.htm
    Candidate: https://www.cdc.gov/nchs/data/datalinkage/public-use-linked-mortality-file-description.pdf
    Safety: WEAK_CANDIDATE | Score: 27 | Direct: NO
    Reason: Manual review still required.
  Row 15: HC-SRC-CAND-0071-2026-05-07T19-26-12-HC-S
    Current: https://www.cms.gov/files/document/highlights.pdf
    Reason: No best candidate URL found.
  Row 16: HC-SRC-CAND-0072-2026-05-07T19-26-12-HC-S
    Current: https://www.cms.gov/files/document/nhe-infographic.pdf
    Candidate: https://data.hrsa.gov/DataDownload/DD_Files/EHB_GRANT_DATAMART_METADATA.XLSX
    Safety: PROMOTION_CANDIDATE | Score: 131 | Direct: YES
    Reason: Cross-agency candidate: current=cms, candidate=hrsa.
  Row 21: HC-SRC-CAND-0023-HC-DBSRC-AHRQ-NHQDR-QUAL
    Current: https://www.ahrq.gov/data/nhqdr.html
    Reason: No best candidate URL found.
  Row 22: HC-SRC-CAND-0022-HC-DBSRC-AHRQ-CAHPS-ACCE
    Current: https://www.ahrq.gov/cahps/surveys-guidance/hp/about/survey-measures.html
    Reason: No best candidate URL found.
  Row 27: HC-SRC-CAND-0077-2026-05-07T19-26-13-HC-S
    Current: https://www2.census.gov/programs-surveys/demo/tables/p60/288/table1.pdf
    Candidate: https://www2.census.gov/programs-surveys/demo/tables/p60/288/table1.pdf
    Safety: WEAK_CANDIDATE | Score: 62 | Direct: NO
    Reason: Manual review still required.

Outputs:
  Action CSV: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_queue_v3_action_plan.csv
  JSON: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\review\healthcare_source_review_queue_v3_action_plan.json
  Summary: G:\voicetocongress.com\40 - Top Issues\020 - Healthcare\_issue_support\metrics\qa\healthcare_source_review_queue_v3_action_plan_summary.txt

Recommended next step:
  Review SAFE_PROMOTE_REVIEW rows first. Promote only one row at a time.
  Move MOVE_TO_FIELD_MAPPING rows to the field-mapping queue.
  Keep MANUAL_REVIEW_HOLD rows in source review until a better source is found.

Important caution:
  This action plan is read-only and conservative. It still requires human review before promotion.