US Energy Information Administration (EIA)

US Energy Information Administration (EIA)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

Learn more
PostHog Wizard hedgehog

Connect US Energy Information Administration (EIA) to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Register for a free API key at EIA Open Data. EIA sends the key by email. Incremental sync reads from the last reporting period. Use a full refresh to collect revisions to older periods.

Configuration

OptionTypeRequired
API keypasswordYes

Linking US Energy Information Administration (EIA) to PostHog

  1. Go to the Data pipeline page in PostHog
  2. Click New source and select US Energy Information Administration (EIA)
  3. Fill in the required configuration fields
  4. Click Next, select the tables you want to sync, and then press Import

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
electricity_retail_sales

Monthly electricity sales, prices, revenue, and customer counts by state and sector.

Incremental, Full refreshperiod—
natural_gas_prices

Monthly natural gas prices by area and price series.

Incremental, Full refreshperiod—
retail_fuel_prices

Weekly retail gasoline and diesel prices by area and product.

Incremental, Full refreshperiod—