Medical Services Expenditures by Disease (MDSBDSEXPHCSA) | 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 Disease (MDSBDSEXPHCSA) from 2000 to 2021 about disease, healthcare, medical, health, expenditures, services, and USA.
AI analysis
Dataset Analysis: Medical Services Expenditures by Disease (MDSBDSEXPHCSA)
1. Dataset Overview and Value
This dataset, sourced from FRED (Federal Reserve Bank of St. Louis) via their API at fredgraph.csv?id=MDSBDSEXPHCSA, tracks annual medical services expenditures by disease category in the USA from 2000 to 2021. FRED is a highly reputable, actively maintained macroeconomic data aggregator, and the direct API sourcing suggests this data can be refreshed programmatically, making it suitable for automated pipelines. As an annual series spanning 22 years, it's well-suited for long-term trend analysis and correlation studies against other macroeconomic indicators (inflation, GDP, insurance coverage rates, demographic shifts) rather than short-term or seasonal analysis, given the coarse yearly granularity.
2. Data Quality Observations
The dataset shows strong quality signals at face value: zero null cells across both columns and zero missing observations (nulls=0 for both observationdate and MDSBDSEXPHCSA). Both columns report 22 distinct values matching the 22 total rows, indicating no duplicate dates and a clean one-to-one time series with no apparent gaps in the 2000–2021 range. However, the duplicate-row check is flagged as pending ("Phase D — recomputed against Parquet"), so full deduplication confirmation is outstanding. Additionally, the sample data rows are not yet populated, meaning row-level spot-checking (e.g., verifying date formatting consistency, checking for placeholder/sentinel values) hasn't been performed — this is a gap worth closing before high-stakes analysis.
3. Key Column Distributions
The core metric, MDSBDSEXPHCSA, ranges from 900.75 to 2556.06, with a mean of 1706.4 and median of 1705.48 — the near-identical mean/median and low skewness (0.0211) indicate a fairly symmetric, non-skewed distribution with no significant outlier pull in either tail. The interquartile range (Q1=1325.63, Q3=2100.63, IQR≈775) shows moderate spread relative to the range, and the standard deviation of 486.4 relative to the mean suggests substantial year-over-year variability (~28% coefficient of variation), consistent with a metric that has grown steadily over two decades. This pattern is typical of a real-terms expenditure series exhibiting a fairly linear or mildly accelerating upward trend rather than cyclical volatility.
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's the designated Join Key column, has zero nulls, and full distinct-value coverage (22/22). For cross-dataset correlation, this should be aligned to annual periodicity (January 1 of each year), so joins should target other annual-frequency FRED series or be aggregated/resampled from higher-frequency datasets (e.g., averaging monthly CPI-Medical data to annual) to prevent join mismatches or the need for interpolation.
5. Suggested Complementary Datasets
Strong pairing candidates include: CPI for Medical Care (CPIMEDSL) and Health Insurance Coverage rates to correlate expenditure with pricing inflation; National Health Expenditure (NHE) data or GDP/Personal Consumption Expenditures on Healthcare for share-of-economy analysis; disease-specific prevalence or mortality data (CDC/NIH sources) to connect spending with incidence trends; and demographic series (aging population %, obesity rates) as leading indicators. Since this series is annual and macro-level, pairing with similarly annual, national-level datasets will minimize join friction and support meaningful regression or correlation studies on healthcare cost drivers.
Columns
- observation_date (date)
- MDSBDSEXPHCSA (decimal)