Average Price: Eggs, Grade A, Large (Cost per Dozen) in U.S. City Average (APU0000708111) | FRED | St. Louis Fed
- Rows
- 562
- Columns
- 2
- Data range
- 1980-01-01 to 2026-10-01
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-11-14
Large white, Grade A chicken eggs, sold in a carton of a dozen. Includes organic, non-organic, cage free, free range, and traditional."
AI analysis
Data Analyst Review: U.S. Average Egg Prices (APU0000708111)
1. Dataset Overview & Value
This dataset tracks the average retail price (per dozen) of Grade A large eggs in U.S. cities, sourced directly from the Federal Reserve Bank of St. Louis's FRED database (fredgraph.csv API endpoint). FRED is a highly reputable, frequently-updated aggregator of BLS/government economic data, which lends strong credibility and reliability to this series. The time coverage spans January 1980 through May 2026 (46+ years of monthly observations), making it one of the longer-running commodity price series available — well-suited for long-horizon trend analysis, seasonality studies, and macroeconomic correlation work (e.g., against CPI, inflation, feed costs, or avian flu event timelines).
2. Data Quality Observations
Overall quality is excellent for a public macroeconomic series: - 557 total rows, only 1 null cell total (0.2% missingness), confined entirely to the price column (APU0000708111). - The date/join-key column has zero nulls and 557 distinct values — indicating no duplicate timestamps and a clean, monotonic time index. - Duplicate-row recomputation is pending Phase D/Parquet validation, so that check is not yet finalized, but the distinct-count parity (557 rows vs. 557 distinct dates) strongly suggests no duplication. - No type mismatches are flagged; the price column is properly typed as Decimal.
The single missing price value is negligible and likely reflects a not-yet-published or in-progress current month observation (consistent with the future-dated 2026-05-01 endpoint) rather than a data quality defect.
3. Key Column Distributions
The price column (APU0000708111) shows 461 distinct values across 556 non-null rows, meaning some price levels repeat across different months (common in slow-moving CPI-style series with periodic stability). Distribution statistics reveal a highly right-skewed series: - Mean = 1.438, Median = 1.1645 — the mean sitting well above the median signals skew driven by upper-tail spikes. - Skewness = 2.38 (strongly positive), consistent with the 23 flagged outliers, almost certainly corresponding to recent price spikes (e.g., 2022–2023 avian influenza-driven egg price surges, where prices hit the max of 6.227). - Interquartile spread (Q1=0.916, Q3=1.77) shows the bulk of historical prices clustered in a modest ~$0.92–$1.77 band, with the tail extending to over 3x that range. - Min (0.678) reflects early-1980s pricing, underscoring the nominal (non-inflation-adjusted) nature of this series — important caveat for correlation work.
4. Recommended Join Key
observationdate is the clear and only viable join key — it's complete (0 nulls), uniquely identifies each row (557 distinct values), and is monthly-grained, which aligns well with most FRED/BLS economic series. Analysts should confirm date alignment (start-of-month convention) when joining to other series that may use end-of-month or different day-of-month conventions.
5. Complementary Datasets for Correlation Analysis
Strong pairing candidates include: - CPI series (e.g., Food at Home CPI, All Items CPI) to normalize for inflation and isolate real egg price movements. - Feed/grain commodity prices (corn, soybean meal) as input-cost drivers. - Poultry/layer flock inventory or avian flu outbreak data (USDA APHIS) to explain the 2022–2023 outlier spike. - Energy prices (diesel, natural gas) given transportation/refrigeration cost pass-through. - Other FRED "Average Price" commodity series (milk, bread, ground beef) for a broader grocery-basket comparison and consumer inflation narrative.
Columns
- observation_date (date)
- APU0000708111 (decimal)