Healthcare Report Card Status

Read-only administrative status page. It does not run ETL, modify files, or publish data. Missing report-card output files are expected until Healthcare report-card exports are intentionally built.

Page version: 2026-05-13-v4-helper-functions

Decision: FOUNDATION READY - REPORT CARD OUTPUTS NOT BUILT

Blockers
0

Review items
3

Ready checks
2

Congress / Year
119 / 2025

Core File Status

File	Status	Size	Modified	Path
Congress Report Card DB Required foundation for report-card data. Missing means this page cannot evaluate report-card readiness.	FOUND	37.6 MB	2026-05-05 17:12:13	`C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\data\congress_report_card.db`
Report Card ETL Script Required foundation to rebuild report-card outputs. Missing means the ETL tool location should be checked.	FOUND	51.1 KB	2026-04-26 09:28:50	`C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\congress_report_card_etl.py`
Healthcare Metrics Rollup Useful context; metrics readiness is handled by Publishing QA.	FOUND	5.5 KB	2026-05-14 19:43:50	`C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\40 - Metrics\App_Data\healthcare_metrics_current.json`
ETL Issue Audit CSV Expected missing until Healthcare report-card exports are generated.	NOT BUILT YET			`C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\output\healthcare_2025_audit.csv`
ETL Senate Audit CSV Optional Senate-focused audit export if used by this issue.	OPTIONAL			`C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\output\healthcare_2025_senate_audit.csv`
ETL Leaderboard JSON Expected missing until Healthcare leaderboard export is generated.	NOT BUILT YET			`C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\output\healthcare_2025_leaderboard.json`
ETL Summary JSON Expected missing until Healthcare summary export is generated.	NOT BUILT YET			`C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\output\healthcare_2025_summary.json`
Public Healthcare Summary JSON Website-facing issue summary file. Expected missing until export/copy step is approved.	NOT BUILT YET			`C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\data\issues\healthcare_2025_summary.json`
Public Healthcare Leaderboard JSON Website-facing leaderboard file. Expected missing until export/copy step is approved.	NOT BUILT YET			`C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\data\leaderboards\healthcare_2025_leaderboard.json`

Counts / Quick Inspections

Artifact	Inspection
Audit CSV	Line count, capped at 20,000: not available
Senate Audit CSV	Line count, capped at 20,000: not available
Public leaderboard JSON	Contains issue slug "healthcare": false
Public summary JSON	Contains issue code "HEALTHCARE": false

Recommended ETL Commands

Use these manually from the ETL folder if Healthcare report-card files are missing or stale. Review command names against your current ETL script before running.

cd /d "C:\WEB\VoiceToCongress.com\70 - Report Card\_etl"
python congress_report_card_etl.py classify-bills --congress 119
python congress_report_card_etl.py build-member-activity --congress 119
python congress_report_card_etl.py export-issue-summary-json --issue HEALTHCARE --year 2025 --outfile "C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\data\issues\healthcare_2025_summary.json"
python congress_report_card_etl.py export-issue-audit --issue HEALTHCARE --year 2025 --outfile "C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\output\healthcare_2025_audit.csv"
python congress_report_card_etl.py export-leaderboard-json --issue HEALTHCARE --year 2025 --outfile "C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\data\leaderboards\healthcare_2025_leaderboard.json"

Public Healthcare Summary JSON Preview

File not found.

C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\data\issues\healthcare_2025_summary.json

Public Healthcare Leaderboard JSON Preview

File not found.

C:\WEB\VoiceToCongress.com\40 - Top Issues\020 - Healthcare\data\leaderboards\healthcare_2025_leaderboard.json

ETL Audit CSV Preview

File not found.

C:\WEB\VoiceToCongress.com\70 - Report Card\_etl\output\healthcare_2025_audit.csv

Interpretation

REPORT CARD DATA NOT READY: The DB or other required foundation is missing.

FOUNDATION READY - REPORT CARD OUTPUTS NOT BUILT: The basic ETL foundation exists, but Healthcare report-card exports have not been intentionally built yet. This is acceptable during setup.

ETL OUTPUT FOUND - PUBLIC EXPORT REVIEW NEEDED: Some ETL evidence exists, but website-facing files are missing or need review.

PUBLIC REPORT CARD FILES FOUND - PAGE REVIEW READY: Website-facing report-card files exist and should be checked visually on the public Healthcare page.