economy_fuel_prices_county_year
County x year x product grain. EIA retail fuel prices broadcast to county via PADD/state crosswalk. State price used where EIA publishes one; otherwise county inherits PADD-region price. Regular gasoline and diesel No. 2. value_is_region_derived is always true — NOT county-measured prices.
tier aTier A: EIA survey data. County values are imputed from PADD district prices — not measured at county level.
overview
overview
~147,000 county-year-product rows. EIA regional retail fuel prices imputed to county via PADD district crosswalk.
current vintage — 2025
history — Yes — 1994–2025
provenance
source & licensing
authority
U.S. Energy Information Administration
dataset
EIA Weekly Retail Gasoline and Diesel Prices (county imputed via PADD crosswalk)
source url
methodology
license
Public domain (U.S. Federal Government work)
citation
U.S. Energy Information Administration (2025). Weekly Retail Gasoline and Diesel Prices.
schema
fields
| name | type | definition |
|---|---|---|
| country_id | string | ISO alpha-2. Always US. |
| county_idkey | string | 5-digit county FIPS. |
| methodology_note | string | Free-text methodology note from the region price table. |
| price_source_grain | string | Resolution level of the price: state (EIA publishes state series) or padd (PADD-region fallback). |
| price_usd_per_gal | float64 | Retail price in USD per gallon, including taxes. EIA published price. |
| productkey | string | Fuel product: gasoline_regular or diesel_no2. |
| source_area_code | string | EIA area code the price was sourced from. |
| state_id | string | 2-digit state FIPS. |
| value_is_region_derived | bool | Always true — prices are region-level broadcast to county, not county-native. |
| yearkey | int64 | Reference year. |
relationships
joins
primary key
county_id, year, product
common joins
economy_fuel_prices_region_year on (region, year)
dim.geographies on (county_id)
usage
how to use this table
method
Annual average of weekly EIA regional prices assigned to counties within each PADD district via crosswalk.
do not use for
County-level price comparison — prices are PADD-district averages. Always surface price_source_grain alongside the value.
← previousus_economy.economy_food_insecurity_county_yearnext →us_economy.economy_fuel_prices_region_year
last updated · Jul 7, 2026