Insight Healthcare Data Dashboard
In this dashboard, you’ll find a series of interactive visualizations and descriptive analytics built from official public data sources, including the U.S. Department of Health and Human Services, the U.S. Census Bureau, and the Government of Puerto Rico.
At Insight Healthcare Advisors, we collect, normalize, and summarize large healthcare datasets using advanced data extraction and wrangling tools. The result: clear, data-driven insights designed to help healthcare leaders understand Puerto Rico’s evolving healthcare landscape.
Some of the information presented here is based on data reported by hospitals to the Centers for Medicare & Medicaid Services (CMS) in their annual cost reports. Because filing deadlines vary by each hospital’s fiscal year, please interpret these insights with caution when comparing across institutions or time periods.
These dashboards are provided solely for informational and educational purposes. They are updated periodically as new data becomes available — so we invite you to check back often for fresh insights and enhancements.
Scratching the Surface
The visualizations presented here only scratch the surface of the insights available within Medicare cost report data and other public datasets.
Our goal is to provide a macro-level view of Puerto Rico’s healthcare system — highlighting trends rather than dissecting every metric.
For hospitals and organizations seeking deeper segmentation, benchmarking, or tailored financial analytics, we offer custom reporting and advisory support.
If you’re interested in custom benchmarking, deeper analytics, or hospital-specific financial reviews, please contact us. We’d be glad to help your organization turn public data into actionable strategies.
Explore the Data
Select any topic below to view the associated visualization or interactive dashboard (Unless otherwise noted, hospital indicators cover Puerto Rico hospitals for reporting periods 2011–2024.):
Medicare Advantage Market Context
Enrollment trends that help frame Puerto Rico’s payer environment.
Market and Utilization Indicators
Capacity, census, patient days, occupancy, and hospital structure.
Financial Indicators
Revenue, expenses, liquidity, receivables, payables, and debt.
Medicare Advantage Enrollment by Organization
The following visual is designed to keep track of enrollment across the different organizations currently holding a Medicare Advantage contract with the Centers for Medicare and Medicaid Services. We include a monthly trend graph to observe the different trends among organizations, which may or may not have an impact on patient mix across providers, proportion enrolled by organization during the latest reported period, total enrollees compared to the total eligible in Puerto Rico as of the last reported date, total enrollees by organization and municipality, and total enrollees by region (we used as a reference, the Puerto Rico Government Health Plan designated regions).
General short-term hospitals remained the dominant hospital category throughout the period. In the most recent year, Puerto Rico reported approximately 48 general short-term hospitals submitting Medicare cost reports. The next largest category was Psychiatric, with approximately 4 hospitals. This chart provides market structure context before reviewing utilization and financial indicators. As stated by CMS, “Medicare-certified institutional providers are required to submit an annual cost report to a Medicare Administrative Contractor (MAC).”, hence there is a reasonable expectation that most hospitals certified in Puerto Rico are accounted for in these statistics.
Hospital Beds and Census
Reported hospital beds declined by 6.1%, while average daily census declined by 18.5%. Reported hospital beds ended the period at approximately 8,011, while average daily census ended at approximately 5,163. The gap between capacity and utilization suggests that market demand softened more than reported bed supply, contributing to sustained occupancy pressure across Puerto Rico hospitals.
Patient Days and Population
Hospital patient days declined by 18.5%, compared with a population decline of 12.9%. Indexed to 2011, this chart shows that patient days weakened more sharply than Puerto Rico’s population. In the most recent year, hospitals reported approximately 1,884,528 inpatient days, while Puerto Rico’s population was approximately 3,203,295. The divergence suggests that inpatient utilization softened beyond what population decline alone would explain.
Medicare-related Inpatient Days
Traditional Medicare / Title XVIII reported inpatient days declined by 53.4% over the period, while Medicare Advantage / HMO inpatient days increased by 237.1%. When both categories are combined, total Medicare-related inpatient days increased by 69.4%. In the most recent year, Puerto Rico hospitals reported approximately 120,866 traditional Medicare inpatient days and approximately 640,167 Medicare Advantage / HMO inpatient days, for a combined total of approximately 761,033 Medicare-related inpatient days. This view separates traditional Medicare from Medicare Advantage / HMO volume and avoids treating Title XVIII reported days as the full Medicare-related inpatient total.
ICU Patient Days
ICU patient days declined by 62.3% over the period. Hospitals reported approximately 18,373 ICU patient days in the most recent year. ICU volume offers a high-acuity utilization signal and provides additional context around the complexity of inpatient care demand.
Hospital Occupancy
Reported occupancy declined by 9.8 percentage points from 2011 to 2024. In the most recent year, hospital occupancy was approximately 64.5%. This metric connects capacity and census, helping illustrate the extent to which bed supply is being utilized across Puerto Rico hospitals.
Beds by Region
Total reported beds across regions declined by 6.1% over the period. Regional bed capacity remains uneven across Puerto Rico. In the most recent year, the region with the largest reported bed count was SAN JUAN, with approximately 2,414 beds. The faceted view helps highlight regional differences that would be difficult to evaluate in a single combined chart.
Beds by Ownership / Control Type
Total reported beds by ownership / control group declined by 6.1% over the period. Among the three main groups, Proprietary hospitals reported the largest bed count in the most recent year, at approximately 3,900 beds. This chart helps show how bed supply is distributed across governmental, nonprofit, and proprietary hospitals.
Reported cash on hand increased by 170.1% over the period. In the most recent year, Puerto Rico hospitals reported approximately $485.7M in cash on hand. This measure provides a broad liquidity signal and helps illustrate how hospitals’ cash position evolved before and after the pandemic-era volatility. The amounts included are limited to reported figures in the General Fund column in the cost report of each hospital, excluding special purpose funds, endowments, or plant funds (the General Fund Column is to be used by hospitals which do not maintain fund-type accounting records, other additional columns are available in the cost report worksheets for those which do use it). These amounts represent cash on deposit in banks and immediately available for use in financing activities, amounts on hand for minor disbursements and amounts invested in savings accounts and certificates of deposit.
Gross accounts receivable increased by 45.1%, allowance increased by 67.1%, and net accounts receivable increased by 29.7%. In the most recent year, hospitals reported approximately $1,415.9M in gross receivables, $670.9M in allowance for doubtful accounts, and $744.9M in net accounts receivable. Viewing the three together helps distinguish reported receivables from the portion hospitals do not expect to collect.
Reported accounts payable declined by 12.1% over the period. In the most recent year, hospitals reported approximately $445.9M in accounts payable. This metric helps frame short-term obligations and can be interpreted alongside liquidity and receivables trends.
Reported long-term debt increased by 12.9% over the period. In the most recent year, Puerto Rico hospitals reported approximately $1.5B in long-term debt. This chart helps illustrate the sector’s longer-term leverage profile and how debt balances have evolved over time.
Total patient revenue increased by 30.7%, discounts and allowances increased by 28.4%, and net patient revenue increased by 32.3%. In the most recent year, hospitals reported approximately $6.0B in total patient revenue, $2.4B in discounts and allowances, and $3.6B in net patient revenue. This view clarifies the relationship between gross patient revenue, deductions, and the net revenue hospitals ultimately report.
Total revenues increased by 41.6%, while other income increased by 328.4%. In the most recent year, hospitals reported approximately $3.9B in total revenues, including approximately $0.4B in other income. This chart helps show the contribution of non-patient revenue sources alongside net patient revenue.
Operating expenses increased by 37.2% over the period. In the most recent year, hospitals reported approximately $4.0B in operating expenses. This measure is a key counterpart to revenue trends and helps frame whether the sector’s cost base has been rising faster than its revenue capacity.
Request a Custom Analysis
Curious how your hospital compares to island-wide trends?
Need a deeper look at your financial or operational performance?
Insight Healthcare Advisors can help you:
-
Benchmark your hospital against comparable providers
-
Model revenue changes under APR-DRG and cost-report data
-
Develop FP&A dashboards tailored to your management team
📩 Request a Custom Benchmark Report
or
📞 Contact us to schedule a consultation.