Short Term Forecast

This table provides data about the short-term, monthly gas production forecasts for well APIs.

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

Columns

Column Name	Type	Description	Example Value
API	NUMBER	An API is a unique, permanent, numeric identifier assigned to each well drilled.	4221532392
GAS_MONTHLY	FLOAT	Amount of gas produced over one month (in MCF, or 1 thousand cubic feet).	134.235
STATE_AB	VARCHAR	Abbreviation of the state.	“TX”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“gulf”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“South - TX”
COUNTY_NAME	VARCHAR	County in the state where the well is located.	“HIDALGO”
OPERATOR_NAME	VARCHAR	Operator of the well.	“MERIT ENERGY COMPANY”
DATE	DATE	Forecasted month (unsynced).	2023-07-01
FORECAST_RUN_DATE	DATE	Date of forecast generation (unsynced).	2024-05-23
OIL_MONTHLY	FLOAT	The amount of oil produced over one month (in BBLS, or barrels).	23

Note

Unsynced data in the date column provide a date at the start of the month. However, the actual reported date is for the end of the month.

For example, if the reported date is “2022-1-10”, this means the data pertains to the month of January and was actually reported on “2022-01-31”.

This means that you should ideally interpret the reported date as representing the whole month and not just the specific date at the start of the month.

Example Data

API NUMBER	GAS_MONTHLY	STATE_AB	REGION	SUB_REGION	COUNTY_NAME	OPERATOR_NAME	DATE	FORECAST_RUN_DATE	OIL_MONTHLY
4221532392	134.235	TX	gulf	South - TX	HIDALGO	MERIT ENERGY COMPANY	2023-07-01	2024-05-23	23
4231734801	37.68	TX	gulf	West - TX	MARTIN	PIONEER NATURAL RESOURCES	2023-08-01	2024-05-23	27
4231734801	16.521232969	TX	gulf	West - TX	MARTIN	PIONEER NATURAL RESOURCES	2024-02-01	2024-05-23	16.836598105
4231734801	17.469734363	TX	gulf	West - TX	MARTIN	PIONEER NATURAL RESOURCES	2024-03-01	2024-05-23	17.996704585
4242331041	250.47	TX	gulf	Haynesville - TX	SMITH	LINDER JOHN OPERATING COMPANY LLC	2024-01-01	2024-05-23	24
4242331142	2.97	TX	gulf	Haynesville - TX	SMITH	VESS OIL CORPORATION	2023-08-01	2024-05-23	82
4242331691	615.86638321	TX	gulf	Haynesville - TX	SMITH	SWN	2024-02-01	2024-05-23	6

Usage

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

Sample queries

⮞ Return the total amount of OIL_MONTHLY forecast for “MERIT ENERGY COMPANY” from date 2024-02-01 to 2024-03-01

SELECT
  SUM(short_term_forecast.oil_monthly) AS total_oil_monthly
FROM
  short_term_forecast
WHERE
  short_term_forecast.operator_name = 'MERIT ENERGY COMPANY'
  AND short_term_forecast.date BETWEEN '2024-02-01' AND '2024-03-01';

Output

	TOTAL_OIL_MONTHLY
1	464393.294859967

⮞ Return all the records where the operator is “MERIT ENERGY COMPANY” and belongs to region “gulf”

SELECT
  *
FROM
  short_term_forecast
WHERE
  short_term_forecast.operator_name ILIKE '%MERIT ENERGY COMPANY%'
  AND short_term_forecast.region ILIKE '%gulf%';

Output

API NUMBER	GAS_MONTHLY	STATE_AB	REGION	SUB_REGION	COUNTY_NAME	OPERATOR_NAME	DATE	FORECAST_RUN_DATE	OIL_MONTHLY
4207331211	1890.9	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2023-08-01	2024-05-23	6
4207331211	1629.20083844	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2024-03-01	2024-05-23	0
4207331211	1576.549135988	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2024-04-01	2024-05-23	0
4207331211	1629.006575778	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2024-05-01	2024-05-23	0
4207331211	1576.372161554	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2024-06-01	2024-05-23	0
4207331211	1628.834423565	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2024-07-01	2024-05-23	0
4207331211	1631.52	TX	gulf	Haynesville - TX	CHEROKEE	MERIT ENERGY COMPANY	2023-09-01	2024-05-23	4