Civic Health ANALYTICSDRAFT

THE EVIDENCE LAB

Ask the data.
Inspect the evidence.

Explore hospital finances and workforce in plain English. Every numerical answer comes from defined measures and a validated query—not a language model’s arithmetic.

21 defined measures8 reporting years48,193 facility-year observations

PLAIN ENGLISH → VALIDATED QUERY

Ask a complicated question

Evidence first
Public provider data only. No patient information.

01 / INTERPRET02 / CALCULATE03 / CITE

Start with a question above or choose an example. Unsupported or ambiguous questions produce a clarification—not an invented answer.

WORKFORCE & HEALTH POLICY

Follow staffing capacity and workload over time

Compare the target hospital with your defined peers using the context above. Payroll FTEs cover all reported employee occupations. These measures describe staffing intensity and inpatient workload; they cannot establish nurse staffing ratios, vacancies or shortages.

Choose a measure to see the target, peer median, coverage and reporting periods.
National research views · rural finances, capacity and workforce

The national research summaries below use their own stated cohorts, regardless of the target and peer filters above. Dollar measures are nominal. Current ownership does not establish historical ownership.

20 Neo4j policy queries ↗ · 6 workforce queries ↗

Loading reproducible summaries…

REPORTED ORGANIZATIONS · DATED EVENTS

Follow ownership across the care continuum

Explore exact organizational IDs reported in CMS ownership disclosures. This view separates ownership interests, enrollment identities and dated hospital change-of-ownership events. Similar names are never merged into a health system.

10 Neo4j ownership inspection queries ↗

National ownership coverage and cross-category footprints

The national summary uses all retained organizational disclosures, independently of peer filters. Facilities can have multiple reported owners; counts cannot be added across organizations.

Loading source coverage…

CHECK BEFORE INTERPRETING

Validation and reporting changes

Extreme workforce and capacity changes are preserved in visible review groups and excluded from national endpoint comparison summaries. Guided target and peer trends retain reported values, with target endpoint warnings where applicable. A review flag does not prove a reporting error.

Loading the bounded source audit…

IDENTITY IS NOT OWNERSHIP

Provider & organizational evidence

CMS enrollment links CCN to legal provider and NPI. CMS owner disclosures identify reported organizational interests or control roles. NPPES enriches organization identity and taxonomy. Current disclosures are not automatically applied to historical financial years.

Choose “Inspect target” to retrieve the linked records.

THE SEMANTIC CONTRACT

One definition for every answer

Definitions include the business meaning, calculation, source fields, scope, missing-value rules and peer minimum. A category such as “nonprofit” does not identify a parent organization.

SOURCE METADATA & LINEAGE

Know what was actually loaded

What this draft can’t establish

Clinical quality, causality, a complete ultimate-parent hierarchy, RAND commercial prices, inflation-adjusted dollars and other HCRIS provider financial families are not established by this hospital subset. Inferred affiliation candidates must remain separate from source-reported ownership. Missing data is never evidence of independence or closure.