Real Medical Services Expenditures by Disease: Other: Residual Codes; Unclassified; All E Codes, MEPS Account Basis (RECOUNREXMEPS) | FRED | St. Louis Fed
- Rows
- 22
- Columns
- 2
- Data range
- 2000-01-01 to 2021-01-01
Graph and download economic data for Real Medical Services Expenditures by Disease: Other: Residual Codes; Unclassified; All E Codes, MEPS Account Basis (RECOUNREXMEPS) from 2000 to 2021 about disease, residual, healthcare, medical, health, expenditures, services, real, and USA.
AI analysis
Dataset Analysis: Real Medical Services Expenditures — Residual/Unclassified Disease Codes (RECOUNREXMEPS)
1. What this dataset represents
This is an annual FRED time series (2000–2021, 22 observations) sourced via the St. Louis Fed's API (fredgraph.csv?id=RECOUNREXMEPS), which republishes data from the Medical Expenditure Panel Survey (MEPS) account basis. The series captures real (inflation-adjusted) medical services expenditures attributed to residual/unclassified disease categories and "All E Codes" (external cause-of-injury codes). Because it's a FRED-hosted derivative of a federal survey (AHRQ's MEPS), it carries strong provenance and is refreshed on a slow, annual cadence rather than real-time — appropriate for longitudinal macro-health-economics analysis rather than short-term trend detection. Its value for correlation studies lies in pairing a granular expenditure category with broader healthcare price indices, GDP, or insurance coverage series to see how "unclassified" spending trends relative to overall healthcare inflation.
2. Data quality observations
The dataset is clean at face value: total null cells across both columns = 0, and distinct counts (22) match total rows (22) for both observationdate and RECOUNREXMEPS, indicating no missing years and no duplicate timestamps. No column shows disproportionate nulls. The duplicate-row count is flagged as pending recomputation (Phase D), so full deduplication confidence isn't yet certified, but the distinct-value alignment strongly suggests one clean row per year with no repeated observations. No type-mismatch figures are reported, and the Decimal typing of the value column is consistent with a continuous economic measure.
3. Key columns and distributions
The core measure, RECOUNREXMEPS, ranges from a minimum of 28.22 to a maximum of 49.52, with a mean of 38.79 and median of 38.87 — the near-equality of mean/median plus a skewness of essentially 0 (-0.00099) indicates a symmetric, non-skewed distribution with no significant outliers. The interquartile range (Q1=33.77, Q3=43.46) spans about 9.7 units, roughly consistent with a standard deviation of 6.16, suggesting fairly even dispersion typical of a steadily trending time series rather than one with sharp shocks or structural breaks. This symmetry and low volatility make it a good candidate for linear correlation/regression methods without needing transformation (e.g., log or Box-Cox) to address skew.
4. Recommended join key
observationdate is the clear and only viable join key — it's a clean annual Date field with zero nulls and full distinct coverage (22/22), making it straightforward to merge with other annual or downsampled-to-annual FRED/macroeconomic series using a simple date-equality or year-truncated join.
5. Suggested complementary datasets/topics
Strong pairing candidates include: (a) other MEPS disease-category expenditure series (e.g., circulatory, musculoskeletal, mental health) to compare relative growth and see if "unclassified" spending correlates with better/worse diagnostic coding practices over time; (b) broader healthcare price indices such as CPI Medical Care (CPIMEDSL) or PCE Healthcare deflators to assess whether this series moves with general healthcare inflation; (c) health insurance coverage rates or uninsured population percentages, since unclassified/residual coding can spike with billing/administrative changes; (d) GDP or per-capita health expenditure (CMS National Health Expenditure Accounts) to normalize for economic growth; and (e) ICD coding regime transition dates (e.g., ICD-9 to ICD-10 in 2015) as an event marker, since "residual/unclassified" codes are especially sensitive to coding system changes and could show a level shift around that year.
Columns
- observation_date (date)
- RECOUNREXMEPS (decimal)