Medical Services Expenditures per Capita by Disease: Other, MEPS Account Basis (DISOTHPCMEPS) | 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 per Capita by Disease: Other, MEPS Account Basis (DISOTHPCMEPS) from 2000 to 2021 about disease, healthcare, medical, health, expenditures, per capita, services, and USA.
AI analysis
Dataset Analysis: Medical Services Expenditures per Capita by Disease: Other (DISOTHPCMEPS)
1. Dataset Overview and Value
This dataset, sourced from FRED (Federal Reserve Bank of St. Louis) via https://fred.stlouisfed.org/graph/fredgraph.csv?id=DISOTHPCMEPS, tracks annual per-capita medical services expenditures for a residual "Other" disease category, compiled on the MEPS (Medical Expenditure Panel Survey) accounting basis. The FRED publisher lends strong credibility and standardization — data is pulled programmatically via a stable API endpoint, suggesting it's refreshed on a regular schedule consistent with MEPS release cycles (typically annual, with a lag). Given its annual frequency spanning 2000–2021 (22 observations), this series is best suited for long-run trend analysis, macro-level healthcare spending studies, and as one input in a basket of disease-category expenditure series (MEPS also publishes analogous series for cancer, heart disease, mental health, etc.) for comparative correlation work.
2. Data Quality Observations
Data quality here is excellent at face value: zero null cells across both columns, and both observationdate and DISOTHPCMEPS show distinct=22, meaning no duplicate dates or repeated values — full one-to-one row integrity for a 22-row series. No column exhibits disproportionate nulls since none exist. That said, the duplicate-row count is flagged as pending ("Phase D — recomputed against Parquet"), so full deduplication validation against the underlying Parquet store is not yet confirmed — this should be treated as an open verification item before final sign-off. Additionally, the sample data rows are not yet populated (0 rows shown), meaning visual spot-checking of actual values hasn't been possible in this pass; this limits the ability to sanity-check the numbers against known MEPS publications independently of summary statistics.
3. Key Column Distributions
The measure column DISOTHPCMEPS ranges from a minimum of $98.21 to a maximum of $263.44, with a mean of $176.76 and median of $173.53 — the close proximity of mean and median, combined with a low skewness of 0.154, indicates a fairly symmetric, near-normal distribution with no major outlier distortion. The interquartile range (Q1=$144.05, Q3=$206.98) spans roughly $63, and the standard deviation of $47.12 (about 27% of the mean) suggests moderate year-over-year variability, consistent with a steadily growing expenditure series over two decades rather than a volatile one. Since this is a time series, the "distribution" stats effectively summarize monotonic growth (2000 baseline near the min, 2021 likely near the max) rather than cross-sectional dispersion — worth keeping in mind when interpreting skew/kurtosis-style metrics.
4. Recommended Join Keys
The observationdate column (Date type, annual granularity, 0 nulls, 22 distinct values) is the clear and only viable join key. For cross-dataset correlation, this should be joined on year (extracted from the date) against other annual series, or aligned via nearest-date/year-truncation logic if pairing with monthly or quarterly datasets (e.g., truncate CPI or GDP data to annual averages before joining).
5. Suggested Complementary Datasets
Strong correlation candidates include: (a) other MEPS disease-category expenditure series (heart disease, cancer, mental disorders, musculoskeletal) to build a full disease-expenditure panel; (b) macro healthcare price indices such as the CPI for Medical Care (CPIMEDSL) or PCE Healthcare series, also FRED-hosted, for consistent join mechanics; (c) demographic/economic indicators like median household income, health insurance coverage rates (e.g., from Census/CPS), or per-capita GDP to explore expenditure elasticity; and (d) disease prevalence or mortality data from CDC/NCHS to test whether "Other" category spending correlates with incidence trends. Because this series is annual and short (22 points), any correlation study should be mindful of low statistical power and potential spurious trend-driven correlation — detrending or using year-over-year growth rates is recommended before regression analysis.
Columns
- observation_date (date)
- DISOTHPCMEPS (decimal)