Average Price: Electricity per Kilowatt-Hour in San Francisco-Oakland-Hayward, CA (CBSA) (APUS49B72610) | FRED | St. Louis Fed
- Rows
- 554
- Columns
- 2
- Data range
- 1978-11-01 to 2024-12-01
Graph and download economic data for Average Price: Electricity per Kilowatt-Hour in San Francisco-Oakland-Hayward, CA (CBSA) (APUS49B72610) from Nov 1978 to Dec 2024 about San Francisco, electricity, energy, urban, CA, retail, price, and USA.
AI analysis
Data Analyst Review: San Francisco-Oakland-Hayward Electricity Price Series (APUS49B72610)
1. Dataset Representation and Value
This dataset tracks the average retail price of electricity (per kilowatt-hour) for the San Francisco-Oakland-Hayward, CA metropolitan area (CBSA), spanning November 1978 to December 2024 — a remarkable 46-year window. The data is sourced directly from the FRED API (St. Louis Fed), a highly reputable and stable publisher known for maintaining consistent, revision-tracked economic series. The source URL (fredgraph.csv?id=APUS49B72610) confirms this is a live, programmatically refreshable feed, meaning the dataset is likely current through the stated end date and will continue updating as BLS source data (this is a CPI Average Price series) is released — a strong candidate for time-series and correlation work given its long historical depth and monthly granularity.
2. Data Quality Observations
Quality is excellent overall. Out of 554 rows and 2 columns (1,108 cells), only 1 null cell exists total — a negligible 0.09% null rate — and it's isolated entirely to the value column APUS49B72610 (1 null, 0.2% of that column's rows). The join key observationdate has zero nulls and 554 distinct values, indicating no duplicate timestamps and a clean, gapless date index (consistent with a monthly series over ~554 months). No duplicate-row recomputation is available yet (Phase D pending), but given the distinct count equals total rows for the date column, duplication risk appears very low. No type mismatches are flagged. This is a clean, analysis-ready series with virtually no missing-data burden to handle before merging.
3. Key Columns and Distributions
The value column APUS49B72610 ranges from $0.039 to $0.419 per kWh, with a mean of 0.161 and median of 0.145 — the mean exceeding the median signals right-skew, confirmed by a skewness of 0.956 (moderately skewed right). This makes sense for a nominal price series that trends upward over decades (starting near $0.04 in 1978, rising toward $0.40+ recently) — old low values compress the left tail while inflation-driven recent prices stretch the right tail. The interquartile range (Q1=0.109, Q3=0.211) shows the bulk of historical observations cluster in the $0.11–$0.21 range, with 12 outliers likely representing the most recent high-price months or possibly early deregulation-era spikes. Only 139 distinct values across 554 rows suggests price stickiness — electricity rates changed in discrete steps rather than continuously.
4. Recommended Join Key
observationdate is the clear and only viable join key — it's complete (zero nulls), fully distinct (554/554), and monthly-frequency, making it straightforward to align with other FRED series or macroeconomic datasets on a monthly basis. Analysts should verify frequency alignment (e.g., resampling if joining to quarterly or annual series) and confirm date-anchoring convention (start-of-month) matches partner datasets before merging.
5. Suggested Pairings for Correlation Discovery
Strong candidates include: (1) CPI or PCE inflation indices (overall and energy-specific) to decompose how much of the price rise is inflation-driven versus CA-specific; (2) California/Bay Area natural gas prices (a common electricity generation input) and wholesale power/fuel indices to explore cost pass-through; (3) Regional housing costs or rent indices for the same CBSA to study cost-of-living correlations; (4) State/utility regulatory or renewable energy mandate timelines (e.g., California RPS milestones) as a qualitative overlay; and (5) National average electricity price series (other CBSAs) to benchmark whether SF-Oakland-Hayward premiums are structural or cyclical. Given the long time span, this series is also well-suited for recession-period analysis (NBER recession indicators) to test energy price elasticity during downturns.
Columns
- observation_date (date)
- APUS49B72610 (decimal)