TILs

This table provides status of wellpads which are being monitored for Turn-In-Line (TIL) events. It includes wellpads identified as having a delayed TIL (DTIL) status, as well as those without delays.

To refer to the TILs API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
WELLPAD_ID	VARCHAR	Identifier of the wellpad.	“412674”
WELLS	NUMBER	The number of DTIL wells on the wellpad.	2
BCFD	FLOAT	The total expected production from the DTILd wells on the wellpad.	0.044
OPERATOR	VARCHAR	Operator of the wellpad.	“CHK”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“West - TX”
FRAC_END	DATE	The date the frac job ended for the DTIL wells, if NULL then the wells have not completed fracking.	2024-04-05
TIL_DATE	DATE	The date the wells were TILd, if NULL then the wells are currently DTILs.	2024-07-24

Example Data

WELLPAD_ID	WELLS	BCFD	OPERATOR	SUB_REGION	FRAC_END	TIL_DATE
412674	2	0.044	CHK	Haynesville - LA	2024-04-05	2024-07-24
479553	3	0.063	CHK	Haynesville - LA	2024-08-05	2024-09-10
453480	4	0.108	CHK	NE PA	2024-02-20	2024-07-03
189781	4	0.084	CHK	WV	2024-08-06	2024-10-03
474699	3	0.087	CHK	NE PA	2024-02-10	2024-10-17

Usage

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

Sample queries

⮞ Return all the records where the operator is CHK

SELECT
  *
FROM
  GEOML_API.PUBLIC.TILs
WHERE
  operator ILIKE '%CHK%';

Output

WELLPAD_ID	WELLS	BCFD	OPERATOR	SUB_REGION	FRAC_END	TIL_DATE
453480	4	0.108	CHK	NE PA	2024-02-20	2024-07-03
189781	4	0.084	CHK	WV	2024-08-06	2024-10-03
474699	3	0.087	CHK	NE PA	2024-02-10	2024-10-17
479553	3	0.063	CHK	Haynesville - LA	2024-08-05	2024-09-10
412674	2	0.044	CHK	Haynesville - LA	2024-04-05	2024-07-24

⮞ Return the total number of wells constructed by the operator “CHK” during the year 2024

SELECT
  COUNT(*) AS total_wells
FROM
  GEOML_API.PUBLIC.TILs
WHERE
  operator ILIKE '%CHK%'
  AND DATE_PART (YEAR, til_date) = 2024;

Output

	COUNT(*)
1	19