Average Price: Gasoline, All Types (Cost per Gallon/3.785 Liters) in Los Angeles-Long Beach-Anaheim, CA (CBSA) (APUS49A7471A) | FRED | St. Louis Fed
- Rows
- 585
- Columns
- 2
- Data range
- 1978-01-01 to 2026-09-01
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-10-25
Graph and download economic data for Average Price: Gasoline, All Types (Cost per Gallon/3.785 Liters) in Los Angeles-Long Beach-Anaheim, CA (CBSA) (APUS49A7471A) from Jan 1978 to May 2026 about Los Angeles, energy, gas, urban, CA, retail, price, and USA.
AI analysis
Dataset Analysis: Average Gasoline Prices, Los Angeles-Long Beach-Anaheim CBSA
1. Dataset Overview and Value
This dataset (FRED series APUS49A7471A), sourced directly from the St. Louis Federal Reserve's API (https://fred.stlouisfed.org/graph/fredgraph.csv?id=APUS49A7471A), tracks average retail gasoline prices (all types, per gallon) in the Los Angeles-Long Beach-Anaheim metro area from January 1978 through May 2026. As a FRED-published series, it benefits from institutional credibility, standardized formatting, and regular update cycles — the extended coverage through 2026 suggests this is an actively maintained, forward-projected or continuously refreshed series rather than a static historical archive. With nearly five decades of monthly observations, this is a strong candidate for long-run time-series correlation work, particularly studies on regional energy costs, inflation pass-through, and consumer spending behavior in one of the largest U.S. metro economies.
2. Data Quality Observations
Overall data quality is high. Out of 581 total rows and 2 columns (1,162 cells), only 1 null value exists (0.2% missing), located in the price column (APUS49A7471A) — likely a single unreported or pending observation period, possibly at the series' leading or trailing edge. The join-key column (observationdate) has zero nulls and 581 distinct values, confirming one clean, unique timestamp per row with no apparent duplication. Duplicate-row recomputation is still pending (Phase D/Parquet wire-up), so that check should be finalized before production use, but based on the distinct-count parity (581 rows, 581 distinct dates), duplication risk appears low. No type mismatches are flagged.
3. Key Column Distributions
The price column shows substantial historical variation, ranging from $0.652 to $6.423 per gallon — reflecting the full arc from the late-1970s energy environment to modern price levels. The mean ($2.360) sits noticeably above the median ($1.701), and skewness is 0.755 (moderately right-skewed), indicating a long tail of higher recent prices pulling the average upward relative to the bulk of historically lower values. The interquartile range ($1.241–$3.379) spans roughly $2.14, reinforcing that most historical prices clustered in the low-to-mid range before recent escalation. With 509 distinct values across 580 non-null observations, there's some repetition (likely months with identical rounded prices), but overall granularity is fine-grained enough for robust trend and volatility analysis.
4. Recommended Join Key
observationdate is the clear and only viable join key — it's complete (zero nulls), fully distinct (581/581), and spans a monthly cadence from 1978–2026. Any correlation study should align other datasets to this same monthly (or resampled) frequency using this date field as the primary merge key.
5. Suggested Complementary Datasets
Strong pairing candidates include: (a) CPI/inflation series (e.g., CPI-U for Los Angeles or U.S. All Items) to assess real vs. nominal price trends; (b) crude oil price benchmarks (WTI/Brent) to study upstream cost pass-through; (c) California-specific fuel tax or regulatory indices, given the state's unique gasoline formulation and tax structure; (d) regional employment/commute data or vehicle miles traveled (VMT) statistics to explore demand elasticity; and (e) national gasoline price series (e.g., other CBSAs) to benchmark LA's premium against broader U.S. trends, especially useful given California's historically higher price volatility.
Columns
- observation_date (date)
- APUS49A7471A (decimal)