Short Term Forecast Declines#

This table provides data about the short-term forecasts of monthly oil production and monthly gas production declines for well APIs extended up to 10 years in to future.

To refer to the Short Term Forecast Declines 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
DATE	DATE	Forecasted month (unsynced).	2022-07-15
GAS_MONTHLY	FLOAT	Amount of gas produced over one month (in MCF, or 1 thousand cubic feet).	134.235
OIL_MONTHLY	FLOAT	The amount of oil produced over one month (in BBLS, or barrels).	23.0
COMPLETION_DATE	DATE	The date when the well was completed.	2021-10-01
FIRST_PRODUCTION_MONTH	DATE	The first month when the well started producing.	2022-01-01
PRODUCTION_MONTH	NUMBER(38,0)	The production month, representing one or more months since the well started producing.	3
COUNTY_NAME	VARCHAR	County in the state where the well is located.	“HIDALGO”
OPERATOR_NAME	VARCHAR	Operator of the well.	“MERIT ENERGY COMPANY”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“South - TX”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“gulf”
FORECAST_RUN_DATE	DATE	Date of forecast generation (unsynced).	2024-05-23
MODELED	BOOLEAN	Indicates whether the production numbers are based on the forecast model (True) or from pipescrapes (False).	True
API_NO_10	VARCHAR	The first 10 digits of the API well number.	“4200347857”
STATE_AB	VARCHAR	Abbreviation of the state.	“TX”

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	DATE	GAS_MONTHLY	OIL_MONTHLY	FIRST_PRODUCTION_MONTH	PRODUCTION_MONTH	COUNTY_NAME	OPERATOR_NAME	SUB_REGION	REGION	FORECAST_RUN_DATE	MODELED	API_NO_10	STATE_AB
4242330962	2026-12-01	397.287782788	190.610231839	1993-01-01	408	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX
4242330962	2027-01-01	397.287781155	190.610231839	1993-01-01	409	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX
4242330962	2027-02-01	358.840575136	172.164080371	1993-01-01	410	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX
4242330962	2026-03-01	397.287802701	190.610231839	1993-01-01	399	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX
4242330962	2026-04-01	384.472064455	184.461514683	1993-01-01	400	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX
4242330962	2026-05-01	397.28779733	190.610231839	1993-01-01	401	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX
4242330962	2026-06-01	384.472059553	184.461514683	1993-01-01	402	Smith	EXXON MOBIL	Haynesville - TX	gulf	2024-09-11	true	4242330962	TX

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 COUNTY_NAME “Smith”

SELECT
  SUM(oil_monthly) AS total_oil_monthly
FROM
  short_term_forecast_declines
WHERE
  county_name ILIKE '%Smith%';

Output

	TOTAL_OIL_MONTHLY
1	11322247.2277314

⮞ Return all the records where the operator is “EXXON MOBIL” and belongs to region “gulf”

SELECT
  *
FROM
  short_term_forecast_declines
WHERE
  operator_name ILIKE '%EXXON MOBIL%'
  AND region ILIKE '%gulf%';

Output

API	DATE	GAS_MONTHLY	OIL_MONTHLY	FIRST_PRODUCTION_MONTH	PRODUCTION_MONTH	COUNTY_NAME	OPERATOR_NAME	SUB_REGION	REGION	FORECAST_RUN_DATE	MODELED	API_NO_10	STATE_AB
4247537812	2023-09-01	32765.0	3688.0	2020-07-01	39	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	False	4247537812	TX
4247537812	2023-10-01	32721.0	3949.0	2020-07-01	40	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	False	4247537812	TX
4247537812	2023-11-01	29871.0	3103.0	2020-07-01	41	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	False	4247537812	TX
4247537812	2023-12-01	39537.0	4418.0	2020-07-01	42	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	False	4247537812	TX
4247537812	2024-01-01	36906.0	4407.0	2020-07-01	43	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	False	4247537812	TX
4247537812	2024-02-01	39049.0	4157.0	2020-07-01	44	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	False	4247537812	TX
4247537812	2033-09-01	2971.797204429	499.934541124	2020-07-01	159	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	True	4247537812	TX
4247537812	2033-10-01	3034.014680014	516.498986349	2020-07-01	160	Ward	EXXON MOBIL	West - TX	gulf	2024-09-11	True	4247537812	TX

Short Term Forecast

TILs