ESA Analytics — Free Data Catalog

ESA Analytics publishes cleaned, standardized U.S. oil & gas data on Snowflake Marketplace, sourced from public state and federal regulatory filings. The tables below make up the free tier — well surface-location points, annual state production, national rig counts, and national oil & gas pricing. All four are available now as an instant-access listing; well-level headers, directional surveys, well logs, and detailed production records are available as a paid subscription through the same listing.

PRODUCTION

State-level annual well counts and oil/gas production, 1887–2025. Includes a national USA aggregate row and federal offshore scope codes (FOG, FOP) alongside individual states. Oil in barrels, gas in Mcf.

RIGS

National annual average rig count, 1968–2025.

PRICE

National annual average oil and gas prices, 1861–2025. Oil in USD per barrel; gas in USD per MMBtu (industry-standard quoting convention — not the same unit as gas volume in the PRODUCTION table).

WELLS

Deduplicated U.S. well surface-location points (state, county, latitude, longitude) for mapping and spatial analysis. No well identifier is included — this table is for location visualization, not joining back to well-level records.

Units Note

Gas price (PRICE.GAS_PRICE_USD_MMBTU) is quoted in USD per MMBtu, the industry-standard convention — while gas volume (PRODUCTION.GAS_MCF) is in Mcf. These are different units (energy content vs. raw volume) and require a conversion factor (~1.037) before multiplying to estimate revenue.

Sample Queries

Table references below use SCHEMA.TABLE — once you mount the share, use whatever database name you gave it in place of the schema prefix as needed.

Preview each table

SELECT * FROM FREE.PRODUCTION LIMIT 10;
SELECT * FROM FREE.PRICE LIMIT 10;
SELECT * FROM FREE.RIGS LIMIT 10;
SELECT * FROM FREE.WELLS LIMIT 10;

Texas production alongside national pricing

SELECT p.year, p.wells, p.oil_bbl, p.gas_mcf,
       pr.oil_price_usd_bbl, pr.gas_price_usd_mmbtu
FROM FREE.PRODUCTION p
JOIN FREE.PRICE pr ON p.year = pr.year
WHERE p.state = 'TX'
ORDER BY p.year;

National production trend vs. rig activity

SELECT p.year, p.wells, p.oil_bbl, p.gas_mcf, r.rigs
FROM FREE.PRODUCTION p
JOIN FREE.RIGS r ON p.year = r.year
WHERE p.state = 'USA'
ORDER BY p.year;

Well count by state

SELECT state, COUNT(*) AS well_spot_count
FROM FREE.WELLS
GROUP BY state
ORDER BY well_spot_count DESC;