Dashboards
Capability proof
U.S. Hospitals Data Dashboard
Explore U.S. hospitals through CMS facility, type, ownership, rating, emergency-service, and financial data.
Explore the U.S. hospital dataPublic hospital data is abundant but fragmented. CMS Care Compare provides a current view of facilities, geography, hospital type, ownership, emergency services, and ratings. Annual HCRIS cost reports add operating context such as bed counts, total revenue, and net income. Neither source alone provides a complete starting point for national hospital research.
This dashboard connects those sources without erasing their different reporting periods, then makes the combined data practical to segment. A user can move from all U.S. hospitals to a focused group, compare facility scale and financial context, and continue into current Google research for each organization.
The resulting hospital base already supports separate service workflows for Community Health Needs Assessment discovery and hospital price-transparency dashboards, along with website, social, leadership, and market research.
Two CMS datasets. One coherent national research surface.
Connect current facilities to annual financial facts
Why it was difficult
Care Compare and HCRIS describe related but different things, arrive on different schedules, and cannot be flattened without obscuring provenance or reporting year.
The response
Keep releases, facility identity, provider-number history, current snapshots, and annual cost-report facts distinct, then show the source fiscal year beside each bed and financial value.
Make every filter choice informative
Why it was difficult
Static filter menus continue showing national totals after a selection and often offer combinations that lead to dead ends.
The response
Recalculate every facet against the other active choices, preserve the known value set, and disable zero-result combinations so each next decision reflects the market already selected.
Browse a national dataset without losing context
Why it was difficult
Hospital research needs high-level market orientation and record-level comparison without sending thousands of rows to the browser or running unbounded queries.
The response
Use parameterized server queries for maps, summaries, faceted counts, sortable results, and cursor pagination limited to 50 rows, all through a read-only production role.
Turn a record into a research starting point
Why it was difficult
A hospital row is useful evidence, but most work continues elsewhere: confirming a website, finding leadership, locating a CHNA, or finding the correct machine-readable price file.
The response
Expose recognizable facility details and source-year-aware scale signals, then link every hospital name to a prepared Google search using its name, city, and state.
A shared hospital base for research teams and downstream services.
Healthcare growth teams
Market-development and research teams defining a national, regional, or state-level hospital universe.
Segment hospitals by geography, type, ownership, emergency capability, rating, beds, and financial scale before deeper account research.
Replace an unstructured national market with a focused list ready for website, social, leadership, and contact enrichment.
CHNA research
Community-health teams locating current Community Health Needs Assessment reports for relevant hospitals.
Establish the correct facility universe, compare hospital context, and organize facility-specific document discovery.
Reuse the same normalized hospital base that already supports the separate CHNA Dashboards service workflow.
Price transparency
Healthcare data and finance teams identifying hospitals and their public machine-readable price files.
Prioritize facilities, locate the published MRF, and turn selected files into useful private analysis.
Carry a normalized facility identity into the separate Hospital Price Transparency Dashboards workflow for CFO and internal-team views.
A current national roster, connected to annual operating facts.
The May 2026 CMS facility universe
States and represented territories
HCRIS fiscal years 2020 through 2023
Current hospitals with cost-report context
A current operating-capability signal
From the national picture to one hospital’s next research step.
A current national hospital universe, summarized by coverage, hospital type, ownership, and geography.
One hospital-type selection recalculates the relevant market totals and exposes comparable bed and financial facts.
State, hospital type, ownership, and emergency-service filters work together to isolate 13 comparable Illinois facilities.
A hospital result becomes a ready-made current search for the official website, location, and the next research step.
The dashboard creates a reusable first stage for hospital-market research. A user can define the relevant universe once, narrow it with connected filters, and carry recognizable facility identities and useful scale signals into the next workflow.
That same base can reduce a national market before website, social, and leadership enrichment; organize facility-by-facility CHNA discovery; or identify the hospitals whose machine-readable price files should be located, normalized, and analyzed. The dashboard establishes the research universe and shortens the distance to the current source that can confirm the answer.
Healthcare public-data product design: connecting a current national facility roster to multi-year operating and financial facts, preserving source-year context, and turning the result into a reusable research surface through cross-referenced faceting, sortable measures, bounded browsing, and external handoffs.
See the work
← Back to projects