Pipeline
What has been loaded, when, and what is still switched off.
Last run per source
| Source | Status | Rows | Detail | When |
|---|---|---|---|---|
| cms:chow | ok | 772 | Hospital_CHOW_2026.07.17.csv | 2026-08-09 01:22:44 |
| cms:cost_report | ok | 6,053 | FY2021 from CostReport_2021_Final.csv | 2026-08-09 01:22:38 |
| cms:cost_report | ok | 6,059 | FY2020 from CostReport_2020_Final.csv | 2026-08-09 01:22:38 |
| cms:enrollments | ok | 9,162 | Hospital_Enrollments_2026.07.17.csv | 2026-08-09 01:22:39 |
| cms:owners | ok | 146,886 | Hospital_All_Owners_2026.07.17.csv | 2026-08-09 01:22:44 |
| score | ok | 9,667 | 24081 hospital-years scored | 2026-08-09 01:22:47 |
Table counts
| hospitals | 9,667 |
| hospital_financials | 24,081 |
| hospital_signals | 24,081 |
| hospital_owners | 146,880 |
| ownership_changes | 772 |
| targets | 9,667 |
| articles | 0 |
| deals | 0 |
| deal_advisors | 0 |
| firms | 0 |
| contacts | 0 |
| court_cases | 0 |
| state_notices | 0 |
| call_log | 0 |
Credentials
Each key unlocks one part of the pipeline. Everything under Targets works without any of them — the CMS data is free and needs no authentication.
| ANTHROPIC_API_KEY | not set |
| COURTLISTENER_TOKEN | not set |
| SEARCH_API_KEY | not set |
Commands
| Reload CMS data | dealflow ingest cms |
| Recompute scores | dealflow score |
| Gather deal news | dealflow crawl |
| Structure articles | dealflow extract |
| Link deals and firms | dealflow resolve |
| Rank the call list | dealflow rank-brokers |
| Everything, in order | dealflow refresh |