Long Term Forecast

This table provides data about the daily gas production forecasts for each sub region for longterm.

To refer to the long term forecast API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
DATE	VARCHAR	Forecasted date.	“2023-12-01”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“AL”
GAS_DAILY	FLOAT	Average rate of gas production expressed per day (in BCF/day).	0.27

Example Data

DATE	SUB_REGION	GAS_DAILY
2023-12-01	AL	0.27
2023-12-01	AR	0.8
2023-12-01	CA	0.2408
2023-12-01	Central - TX	2.398
2023-12-01	Colorado wo SJ	4
2023-12-01	GOM	1.9
2023-12-01	Haynesville - LA	11.6
2023-12-01	Haynesville - TX	6.028

Usage

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

Sample queries

⮞ Return the total number of gas produced in the year 2024

SELECT SUM(long_term_forecast.gas_daily) AS total_gas_produced
FROM long_term_forecast
WHERE long_term_forecast.date >= '2024-01-01'
AND long_term_forecast.date <= '2024-12-31';

Output

	TOTAL_GAS_PRODUCED
1	1232.639814624

⮞ Return all the records for daily gas production over 11 (in BCF/day)

SELECT *
FROM long_term_forecast
WHERE long_term_forecast.gas_daily > 11;

Output

DATE	SUB_REGION	GAS_DAILY
2023-12-01	Haynesville - LA	11.6
2023-12-01	NE PA	11.7
2023-12-01	West - TX	13.69
2024-01-01	Haynesville - LA	11.5
2024-01-01	NE PA	11.3
2024-01-01	West - TX	13.61
2024-02-01	Haynesville - LA	11.7
2024-02-01	NE PA	11.3