Daily Production

This table provides data about the daily gas production model for the lower 48, informed from pipeline scrapes, state data, and our short-term production forecast.

To refer to the daily prod model API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
DATE	VARCHAR	Forecasted month (unsynced).	“2023-04-05”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“GOM”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“gulf”
DRY_GAS	FLOAT	Gas volume in BCF (billions of standard cubic feet of gas).	1.811156728

Example Data

DATE	SUB_REGION	REGION	DRY_GAS
2023-04-19	GOM	gulf	1.80208563
2023-06-11	VA	northeast	0.2400645161
2021-02-20	OH	northeast	6.058454265
2021-05-09	KY	northeast	0.2388064516
2024-04-16	Haynesville - LA	gulf	10.133182119

Note on Dry Gas Production

The dry gas production information for each day is not fully available on that same day, as some pipeline nomination data is still missing. The complete daily production data will be ready by the next day. So, for example, if you want the full data for April 12, 2023, you’ll need to wait until April 13, 2023, to get it.

---

Usage

In Snowflake, you can write SQL queries to return the data you want.

Sample queries

⮞ Return the total amount of gas produced in the sub-region “GOM”

SELECT SUM(daily_prod_model.dry_gas) AS total_gas
FROM daily_prod_model
WHERE daily_prod_model.sub_region ILIKE '%GOM%';

Output

	TOTAL_GAS
1	4854.64607968

⮞ Return DRY_GAS amounts and SUB_REGION for all the gas produced before 2023-04-08

SELECT daily_prod_model.dry_gas, daily_prod_model.sub_region
FROM daily_prod_model
WHERE daily_prod_model.date < '2023-04-08';

Output

DRY_GAS	SUB_REGION
1.811156728	GOM
1.770108005	GOM
1.816712775	GOM
5.98644006	OH
5.984737442	OH
5.998410626	OH
5.978036611	OH
6.018433325	OH