Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in St. Louis, MO-IL (CBSA) (APUS24B74714) | FRED | St. Louis Fed
- Rows
- 586
- Columns
- 2
- Data range
- 1978-01-01 to 2026-10-01
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-11-15
Graph and download economic data for Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in St. Louis, MO-IL (CBSA) (APUS24B74714) from Jan 1978 to May 2026 about St. Louis, energy, MO, IL, gas, urban, retail, price, and USA.
AI analysis
Data Analyst Review: St. Louis Unleaded Gasoline Prices (APUS24B74714)
1. Dataset Overview & Value
This dataset tracks the average retail price of unleaded regular gasoline (per gallon) in the St. Louis, MO-IL Core-Based Statistical Area (CBSA), sourced from the Federal Reserve Bank of St. Louis (FRED) via https://fred.stlouisfed.org/graph/fredgraph.csv?id=APUS24B74714. The FRED domain confirms this is a highly reputable, publicly-maintained economic data source (originating from BLS survey data), which lends strong credibility for use in academic or financial correlation studies. Notably, the stated time coverage extends to May 2026, well beyond the current date — this suggests either a forward-dated placeholder/forecast series or a metadata artifact that should be verified before treating "future" rows as valid historical data. As a regional energy-price series, it has strong potential value for studying inflation pass-through, regional cost-of-living dynamics, and consumer spending patterns tied to fuel costs.
2. Data Quality Observations
The dataset is structurally simple (2 columns, 581 rows) but has a significant null problem: 240 of 581 rows (41.3%) are missing values in the sole data column, APUS24B74714. This is a disproportionate and concerning gap — likely reflecting a lower historical reporting frequency (e.g., the series may have started monthly reporting later, or was only sampled periodically in early decades) rather than random missingness. Any time-series or correlation work must explicitly handle this via date-range filtering (e.g., restricting analysis to the period with consistent reporting) rather than imputation, given the economic nature of the data. Duplicate-row and type-mismatch figures are not yet computed (pending Phase D reprocessing), so referential integrity on the date key remains unconfirmed — this should be validated before joins are trusted.
3. Key Column Distributions
The price column shows a mean of $1.579/gallon against a lower median of $1.15, indicating a right-skewed distribution (confirmed by skewness = 1.29) — consistent with gasoline's historical price trajectory of long stable/low periods punctuated by sharp spikes (2008, 2011-2014, 2022). The IQR (Q1 = $0.981, Q3 = $2.237) shows the bulk of historical prices sat below $2.24, while the max of $4.839 represents extreme spike periods, and 4 detected outliers likely correspond to the 2008 and 2022 price shocks. The spread (σ = 0.915) relative to the mean indicates substantial volatility over the full 1978–2026 window, which is expected given multiple oil-price shock cycles captured in this span.
4. Recommended Join Keys
The observationdate column (0 nulls, 581 distinct values, monthly granularity) is the clear and only viable join key. Since it's clean and complete, it can reliably anchor joins to other FRED-style monthly time series. Care should be taken to align frequency (monthly vs. daily/quarterly) and to decide on a join strategy (exact date match vs. nearest-date/asof join) when combining with datasets that don't share the same reporting calendar.
5. Suggested Pairings for Correlation Analysis
Strong candidates include: (a) national/regional CPI or Energy CPI indices to assess pass-through of gas prices to broader inflation; (b) crude oil price benchmarks (WTI/Brent) to study regional price transmission lag; (c) consumer spending or retail sales data for St. Louis or the Midwest to explore discretionary spending effects; (d) household gasoline expenditure share or personal consumption expenditure (PCE) series; and (e) unemployment or wage growth data for the St. Louis CBSA to explore real-income effects of fuel cost changes. Given the long history, pairing with recession indicator series (e.g., NBER recession dates) could also reveal gasoline price spikes as leading/lagging indicators of economic downturns.
Columns
- observation_date (date)
- APUS24B74714 (decimal)