Long Term Forecast Oil

This endpoint returns long-term oil production forecasts use public producer guidance with an adjustment for private producer activity of the lower 48 and its subregions for the next 12 months.

To refer to the Long Term Forecast API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
DATE	VARCHAR	Forecasted month (unsynced).	“2023-09-01”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“AL”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“southeast”
OIL_DAILY	FLOAT	The amount of oil produced in a single day (in BBLS, or barrels).	10.358

Example Data

DATE	SUB_REGION	REGION	OIL_DAILY
2023-09-15	N LA	gulf	10.358
2023-09-14	MT	midwest	66
2023-09-19	MS	southeast	36
2023-09-29	MI	midwest	13
2023-09-19	KY	northeast	6
2023-09-18	Central - TX	gulf	54

Usage

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

Sample queries

⮞ Return the total OIL_DAILY forecast for the region “southeast” from date 2023-09-01 to 2023-10-01

SELECT
    SUM(long_term_forecast_oil.oil_daily) AS total_oil_forecast
FROM
    long_term_forecast_oil
WHERE
    long_term_forecast_oil.region = 'southeast'
    AND long_term_forecast_oil.date BETWEEN '2023-09-01' AND '2023-10-01';

Output

	TOTAL_OIL_FORECAST
1	1426

⮞ Return all the records where the OIL_DAILY forecast is above 4400

SELECT
    *
FROM
    long_term_forecast_oil
WHERE
    long_term_forecast_oil.oil_daily > 4400;

Output

DATE	SUB_REGION	REGION	OIL_DAILY
2024-08-01	West - TX	gulf	4415
2024-08-02	West - TX	gulf	4415
2024-08-03	West - TX	gulf	4415
2024-08-04	West - TX	gulf	4415
2024-08-05	West - TX	gulf	4415
2024-08-06	West - TX	gulf	4415
2024-08-31	West - TX	gulf	4415
2024-11-06	West - TX	gulf	4440
2024-11-25	West - TX	gulf	4440
2024-12-11	West - TX	gulf	4430