Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in Kansas City, MO-KS (CBSA) (APUA21474714) | FRED | St. Louis Fed
- Rows
- 108
- Columns
- 2
- Data range
- 1978-01-01 to 1986-12-01
Graph and download economic data for Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in Kansas City, MO-KS (CBSA) (APUA21474714) from Jan 1978 to Dec 1986 about Kansas City, KS, energy, MO, gas, urban, retail, price, and USA.
AI analysis
Data Analysis: Kansas City Gasoline Prices (1978-1986)
1. Dataset Overview and Value
This dataset, sourced from the Federal Reserve Bank of St. Louis (FRED, series APUA21474714), tracks monthly average retail prices for unleaded regular gasoline in the Kansas City, MO-KS metropolitan area (CBSA) from January 1978 through December 1986. As a Federal Reserve-published series, it carries strong credibility and standardization, making it a reliable benchmark for economic research. The data captures a historically significant period spanning the tail end of the 1970s energy crisis, the 1979-1980 oil price shocks, and the mid-1980s oil price collapse — making it valuable for studying energy price volatility, regional cost-of-living dynamics, and inflationary pressures tied to fuel costs. Its regional (CBSA-level) granularity also makes it useful for comparing local vs. national energy trends.
2. Data Quality
The dataset appears clean and well-structured: with 108 total rows and zero null cells across both columns, there are no missing-value concerns. The duplicate-row check is flagged as pending recomputation ("Phase D"), so full deduplication confidence isn't yet established, but the distinct-value count for the date column (108 distinct out of 108 rows) strongly suggests no duplicate timestamps exist. No type-mismatch issues are noted. Overall, this is a high-integrity, analysis-ready series with minimal cleaning required.
3. Column Distributions
The dataset contains only two columns: a date join-key (observationdate) and the price variable (APUA21474714). The price column ranges from $0.615 to $1.351 per gallon, with a mean of $1.064 and median of $1.155 — the mean sitting notably below the median indicates left (negative) skew, confirmed by the skewness statistic of -0.791. This suggests a longer tail toward lower prices, consistent with the pattern of rapid price spikes (1979-1980 crisis) followed by a gradual decline through the mid-1980s. The interquartile range ($0.899–$1.222) shows that most observations cluster in the upper-middle price range, with fewer but more extreme low-price months pulling the distribution's tail downward. With 96 distinct values across 108 rows, there's modest repetition (~12 repeated values), typical of a price series with occasional flat months.
4. Recommended Join Keys
The observationdate column (monthly, first-of-month timestamps, 1978-01-01 through 1986-12-01) is the clear and only viable join key. Its zero nulls and full distinctness make it ideal for time-series merges. Analysts should ensure any paired dataset uses compatible monthly periodicity and date alignment (first-of-month convention) to avoid misalignment during joins.
5. Complementary Datasets for Correlation Analysis
Strong candidates for correlation studies include: (a) CPI and inflation indices (e.g., FRED's CPI for All Urban Consumers) to assess gasoline's contribution to broader inflation; (b) crude oil price series (WTI or Brent spot prices) to examine pass-through effects from crude to retail; (c) regional/national unemployment or wage data for Kansas City to explore energy cost burden on households; (d) vehicle miles traveled (VMT) or auto sales data to study demand elasticity; and (e) other CBSA-level gasoline price series (other FRED APU series) to benchmark Kansas City against national or peer-city trends during the same energy-shock era.
Columns
- observation_date (date)
- APUA21474714 (decimal)