ESA Analytics — Paid Data Catalog

ESA Analytics publishes cleaned, standardized U.S. oil & gas data on Snowflake Marketplace, sourced from public state and federal regulatory filings. The five tables below make up the paid tier — well headers, monthly production, directional surveys, petrophysical logs, and hydraulic fracturing fluid disclosure — available as a single subscription through the same listing as the free tier.

HEADERS

One row per 14-digit wellbore: identity, location, key dates, and lifetime cumulative production/completion summary. Well-level counterpart to Production, Surveys, and Logs. 4.7M+ wells.

PRODUCTION

Monthly well-level oil/gas/water production as reported to state regulatory agencies. 422M+ rows across all major U.S. producing states.

SURVEYS

Directional survey stations (measured depth, inclination, azimuth, computed position) for each wellbore. 51.8M+ rows.

LOGS

Petrophysical well log curves, one row per depth sample, with along-track Lat/Lon/TVD/TVDss interpolated from each wellbore's directional survey — usable standalone for mapping, top-picking, or interpretation without joining Surveys or Headers. 1B+ rows.

FRACFOCUS

Hydraulic fracturing fluid disclosure, one row per completion job, sourced from FracFocus.org — total ingredient mass/volume by chemical purpose category. 196K+ jobs.

Units Note

FracFocus columns are not uniformly measured: most ingredient categories (PROPPANT, BIOCIDE, FRICTION_REDUCER, and most others) are mass in lbs, but FLUID/ACID are volume in bbl, and CO2/NITROGEN are gas-equivalent volume in Mcf — see the column descriptions above for each field.

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.

Wells and cumulative oil production by state

SELECT h.NAME, h.OPERATOR, h.STATE, SUM(p.OIL) AS cum_oil_bbl
FROM PAID.HEADERS h JOIN PAID.PRODUCTION p ON h.API = p.API
WHERE h.STATE = 'CO'
GROUP BY h.NAME, h.OPERATOR, h.STATE
ORDER BY cum_oil_bbl DESC LIMIT 100;

Monthly production history for a well

SELECT PRODUCTION_DATE, SUM(OIL) AS total_oil_bbl
FROM PAID.PRODUCTION
WHERE API = 'YOUR14DIGITAPI'
GROUP BY PRODUCTION_DATE ORDER BY PRODUCTION_DATE;

Log curve with along-track position for a well

SELECT API, MD, LAT, LON, GR
FROM PAID.LOGS
WHERE API = 'YOUR14DIGITAPI'
ORDER BY MD;

Wellbore total depth from directional surveys

SELECT API, MAX(MD) AS total_md, MAX(TVD) AS max_tvd
FROM PAID.SURVEYS
GROUP BY API LIMIT 1000;

Frac fluid disclosure joined to well header

SELECT h.NAME, f.SOURCE_ID, f.PROPPANT, f.FRICTION_REDUCER
FROM PAID.HEADERS h
JOIN PAID.FRACFOCUS f ON LEFT(h.API, 10) = f.API
WHERE h.STATE = 'TX' LIMIT 100;