Economic series

Hypothesis

Query US energy data from the Energy Information Administration (EIA) in your own warehouse, with the full history of each series. Also includes [BLS SERIES] from the Bureau of Labor Statistics (BLS).

About this dataset

We load all 13 of the EIA’s bulk datasets, from electricity and natural gas to the Short-Term Energy Outlook. Each series comes with its name, units, frequency, place and the periods it covers. Each dataset’s categories show how its series are grouped.

Analysts joining energy prices and output to their own data
Planning teams charting series by state or country
Data teams who don’t want to maintain their own EIA loads

Tables

Each dataset has 2 tables. The series table has one row per series, with all of its observations. The categories table has the same name, ending in _categories.

Table	EIA dataset
co2_emissions	CO2 emissions
coal	Coal
electricity	Electricity
international_energy	International energy
international_energy_outlook	International Energy Outlook
natural_gas	Natural gas
petroleum	Petroleum
petroleum_imports	Petroleum imports
short_term_energy_outlook	Short-Term Energy Outlook
state_energy_data_system	State Energy Data System
total_energy	Total energy
us_electric_system	US electric system operating data
us_nuclear_outages	US nuclear outages

Series table columns

Column	What it holds
series_id	The EIA’s ID for the series
name, description	What it measures, in the EIA’s words
units	Units, such as thousand megawatthours
f	How often it’s reported: A (annual), Q (quarterly) or M (monthly)
geography	Where it’s measured, with an iso3166 code for countries and states
start, end	First and last periods
last_updated	When the EIA last updated it
data	Observations, as period and value pairs

Sample queries

Each row is a whole series. Find the one you need, then unnest its observations.

Find a series
Search a series table by name or description, or browse its categories.
Unnest its observations
The data column holds every period and value. Flatten it to get one row per period.
Read the period by its frequency
The f column says how often a series is reported. Periods match it: 2024 for a year, 202401 for a month.

SQL

-- One series, one row per period (Snowflake)
select s.series_id, s.name, s.units,
    d.value[0]::string as period,
    d.value[1]::float as value
from electricity s,
    lateral flatten(input => s.data) d
where s.series_id = '[SERIES ID]'
order by period;

Pricing

One monthly plan covers every table. It’s billed through Snowflake Marketplace or AWS Data Exchange, on your existing Snowflake or AWS bill.

Changelog

[DATE] · First release: the EIA’s 13 bulk datasets, in 26 tables.

More from Zym Labs Data

The EIA and the BLS publish this data. Zym Labs isn’t affiliated with or endorsed by either.

Economic series | Zym Labs