Corrective Eyeglasses and Contact Lenses Expenditures Price Index (COEYEQPIHCSA) | FRED | St. Louis Fed
- Rows
- 22
- Columns
- 2
- Data range
- 2000-01-01 to 2021-01-01
Graph and download economic data for Corrective Eyeglasses and Contact Lenses Expenditures Price Index (COEYEQPIHCSA) from 2000 to 2021 about optical, healthcare, medical, health, expenditures, price index, indexes, price, and USA.
AI analysis
Data Quality and Structure Analysis: Corrective Eyeglasses and Contact Lenses Price Index
1. Dataset Overview and Provenance
This dataset tracks the Corrective Eyeglasses and Contact Lenses Expenditures Price Index (COEYEQPIHCSA), sourced directly from the Federal Reserve Bank of St. Louis's FRED API (https://fred.stlouisfed.org/graph/fredgraph.csv?id=COEYEQPIHCSA). As an official Fed-hosted economic series, this data carries high institutional credibility and is likely derived from BLS (Bureau of Labor Statistics) Consumer Expenditure Survey inputs, making it suitable for rigorous economic and healthcare-pricing research. The series spans 2000 to 2021 (22 annual observations), positioning it as a long-run macro indicator rather than a high-frequency dataset. Its value for correlation studies lies in tracking optical healthcare cost inflation over two decades — useful for benchmarking against broader CPI healthcare components, insurance coverage trends, or consumer discretionary spending shifts.
2. Data Quality Observations
The dataset is exceptionally clean at face value: zero null cells across both columns, and both observationdate and COEYEQPIHCSA show 22 distinct values matching the 22 total rows — indicating no duplicate timestamps or repeated index values. This suggests a well-curated, deduplicated time series with complete annual coverage and no gaps. One caveat: the duplicate-row count is flagged as "(Phase D — recomputed against Parquet)," meaning the definitive duplicate check hasn't been finalized in this report — this should be verified before treating the dataset as fully validated. Additionally, the sample data rows are pending wire-up, so row-level spot-checking isn't yet possible; analysts should confirm actual value formatting (e.g., decimal precision, date parsing) once samples are available.
3. Key Column Distributions
The index column (COEYEQPIHCSA) ranges from 79.92 to 103.57, with a mean of 93.51 and median of 94.75 — the mean sitting slightly below the median, consistent with the negative skew of -0.432, suggesting a modest left tail (likely earlier years with lower index values pulling the average down while later years cluster higher). The interquartile range (Q1=87.84, Q3=99.42) spans roughly 11.6 points, and the standard deviation of 7.31 relative to the ~24-point total range indicates moderate but not extreme volatility year-over-year — consistent with a stable, trending price index rather than a noisy series. With only 22 points, formal outlier detection is less meaningful, but the min/max bounds suggest steady upward drift typical of price indices rather than sharp shocks.
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's a clean Date type with zero nulls and full distinctness, ideal for merging with other annual or resampled-to-annual time series. Since this is FRED-native, it will align naturally with other FRED series using the same date convention (typically January 1 of each year for annual data). Analysts should ensure temporal alignment (e.g., annual vs. quarterly vs. monthly) before joining, as this series appears to be annual snapshots despite the underlying source potentially having higher frequency.
5. Suggested Pairings for Correlation Discovery
Strong candidates include: CPI-U Medical Care Services and CPI Optical Goods and Services subcomponents (to contextualize this index within broader healthcare inflation); Personal Consumption Expenditures (PCE) on Healthcare; Health Insurance Coverage rates (via Census/CDC data) to explore whether insurance penetration affects out-of-pocket vision costs; and median household income or PCE on durable goods to assess affordability trends. Additionally, pairing with BLS optical retail employment/wage data or vision-care utilization rates could reveal whether price increases correlate with supply-side labor cost pressures or demand-side utilization changes — valuable for healthcare economics research.
Columns
- observation_date (date)
- COEYEQPIHCSA (decimal)