Average Price: Gasoline, All Types (Cost per Gallon/3.785 Liters) in Philadelphia-Camden-Wilmington, PA-NJ-DE-MD (CBSA) (APUS12B7471A) | 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-21
Graph and download economic data for Average Price: Gasoline, All Types (Cost per Gallon/3.785 Liters) in Philadelphia-Camden-Wilmington, PA-NJ-DE-MD (CBSA) (APUS12B7471A) from Jan 1978 to May 2026 about DE, Philadelphia, MD, NJ, energy, PA, gas, urban, retail, price, and USA.
AI analysis
Dataset Analysis: Gasoline Prices in Philadelphia-Camden-Wilmington CBSA
1. Dataset Overview and Value
This dataset (APUS12B7471A) tracks average retail gasoline prices (all grades) per gallon in the Philadelphia-Camden-Wilmington, PA-NJ-DE-MD metropolitan area, sourced from the St. Louis Fed's FRED database (fred.stlouisfed.org/graph/fredgraph.csv?id=APUS12B7471A). As a Federal Reserve-published series, it carries strong credibility and is likely sourced from BLS price survey data, updated on a regular cadence. Notably, the time coverage extends to May 2026, suggesting this is a "live"/continuously updated series with forward-dated placeholder rows or scheduled release dates baked in — analysts should verify whether recent/future dates contain actual observations or are just calendar placeholders. With 48+ years of monthly history (1978–2026), this dataset is well-suited for long-run macroeconomic and energy-market correlation studies, including inflation pass-through, regional cost-of-living analysis, and consumer spending elasticity research.
2. Data Quality Observations
Overall data quality is high. Of 581 total rows and 2 columns (1,162 cells), only 1 null cell was detected (0.2% of the single value column, APUS12B7471A), giving a 99.8%+ completeness rate — likely the most recent or a not-yet-collected period. The join key (observationdate) has zero nulls and 581 distinct values, confirming no duplicate timestamps and a clean, gap-free date index. Duplicate-row recomputation is pending Phase D/Parquet wire-up, so that check should be finalized before production use, but no red flags are evident otherwise. The main caveat is the empty sample-data preview (0 rows shown), which limits the ability to sanity-check formatting, decimal precision, or currency units directly — pulling a few live rows before analysis is advisable.
3. Key Column Distributions
The price column (APUS12B7471A) ranges from $0.618 to $5.072 per gallon, with a mean of $2.012 and median of $1.529 — the mean sitting notably above the median indicates a right-skewed distribution (skew = 0.614), consistent with gas prices trending upward over decades (inflation, supply shocks) with periodic spikes pulling the mean higher than typical historical values. The interquartile range (Q1=$1.194, Q3=$2.818) shows that the middle 50% of observations span roughly $1.19–$2.82, meaning historically low 1970s–90s prices anchor the lower quartile while 2010s–2020s prices push the upper end. With 491 distinct values across 581 rows, there's some repetition (likely flat months during stable price periods), but overall granularity is fine (likely to the cent or tenth-cent).
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's a clean, gap-free monthly date field with zero nulls and full distinctness. For cross-dataset correlation, this should be joined against other monthly (or resampled-to-monthly) time series using calendar-date alignment, keeping in mind this series appears to be monthly frequency, so higher-frequency datasets (daily/weekly) would need aggregation first.
5. Complementary Datasets for Correlation Analysis
Strong pairing candidates include: (a) Crude oil price benchmarks (WTI/Brent) to study upstream cost pass-through; (b) CPI for the Philadelphia metro area or U.S. urban CPI to assess real vs. nominal price trends and inflation-adjusted purchasing power; (c) Regional unemployment/personal income data for the Philadelphia-Camden-Wilmington CBSA to explore consumer spending sensitivity; (d) National/regional VMT (vehicle miles traveled) or transportation sector employment data; and (e) Other FRED regional gasoline price series (e.g., neighboring CBSAs or national average APU000074714) to benchmark regional price premiums/discounts and study geographic price convergence or divergence over time.
Columns
- observation_date (date)
- APUS12B7471A (decimal)