Medical Services Expenditures by Provider: Nursing Homes Price Index (NURHOMPIHCSA) | FRED | St. Louis Fed
- Rows
- 22
- Columns
- 2
- Data range
- 2000-01-01 to 2021-01-01
Graph and download economic data for Medical Services Expenditures by Provider: Nursing Homes Price Index (NURHOMPIHCSA) from 2000 to 2021 about nursing homes, nursing, healthcare, medical, health, expenditures, services, price index, indexes, price, and USA.
AI analysis
Data Analysis: Nursing Homes Price Index (NURHOMPIHCSA)
1. Dataset Overview
This dataset tracks the Medical Services Expenditures by Provider: Nursing Homes Price Index, sourced from the Federal Reserve Bank of St. Louis's FRED database (via fredgraph.csv?id=NURHOMPIHCSA). FRED is a highly authoritative publisher for economic time series, aggregating data from federal statistical agencies (in this case, likely BEA/CMS national health expenditure accounts). The series spans 2000–2021 at what appears to be an annual frequency (22 observations over 22 years), making it well-suited for long-run trend analysis in healthcare cost inflation. Its value for correlation studies lies in benchmarking nursing home price growth against broader healthcare inflation, demographic aging trends, or macroeconomic indicators (CPI, wage growth) over a two-decade window that includes the 2008 financial crisis and the early COVID-19 period (2020–2021) — a particularly relevant inflection point given the pandemic's severe impact on long-term care facilities.
2. Data Quality Observations
Data quality appears strong at first inspection: zero null cells across both columns and zero missing values in either the date join-key (observationdate, 22 distinct values) or the price index column (NURHOMPIHCSA, 22 distinct values). This 1:1 distinct-value ratio to row count confirms no duplicate timestamps and a clean, fully-populated annual series. However, two caveats limit full confidence: the duplicate-row count is flagged as pending ("Phase D — recomputed against Parquet"), so true row-level duplication hasn't been formally verified yet, and the sample data rows are empty (0 of 22 shown), meaning we cannot visually inspect actual value formatting, date alignment, or edge cases until the Parquet wiring completes. I'd recommend treating this as "provisionally clean" pending that follow-up validation.
3. Key Column Distributions
The NURHOMPIHCSA index ranges from 60.42 to 113.49, nearly doubling over the observation window — consistent with steady healthcare cost inflation. The mean (87.06) sits close to the median (88.985), and skewness is very low (-0.0374), indicating a roughly symmetric distribution with no significant outliers or long tails — expected behavior for a smoothly trending index rather than a volatile metric. The interquartile range (Q1=75, Q3=96.88, IQR≈21.88) combined with a standard deviation of 15.33 suggests fairly steady, gradual year-over-year increases rather than sharp jumps, though this summary statistic alone can't reveal whether growth decelerated or accelerated in specific sub-periods (e.g., post-2020) — a time-series plot would be needed to confirm.
4. Recommended Join Keys
The clear join key is observationdate, given its zero nulls and full distinctness (22/22). Since this is annual data, correlation with other FRED series should be matched on year (truncating higher-frequency series to annual averages or year-end values) to avoid frequency mismatches. Analysts should confirm whether counterpart datasets use January 1 as the anchor date convention, as FRED series sometimes differ in date alignment (start-of-period vs. end-of-period).
5. Suggested Pairings for Correlation Analysis
Strong candidates include: CPI-Medical Care Services and CPI-All Items (to isolate nursing-home-specific inflation vs. general inflation), National Health Expenditure (NHE) data by payer (Medicare/Medicaid spending, since nursing homes are heavily publicly funded), BLS wage/employment data for nursing/residential care facilities (labor cost pass-through), Population 65+ or 85+ demographic series (demand-side driver), and occupancy rate or facility count data from CMS (supply-side context). Given the 2020-2021 tail end of this series, pairing with COVID-19 nursing home mortality/case data could also reveal pandemic-driven price and cost shocks in long-term care.
Columns
- observation_date (date)
- NURHOMPIHCSA (decimal)