Completions

This table provides the data of well completions, essential for the production of oil or gas.

To refer to the completions 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.	3507326669
WELLPAD_ID	NUMBER	Identifier of the wellpad.	219152
OPERATOR_NAME	VARCHAR	Operator of the well.	“OVINTIV”
COUNTY	VARCHAR	County in the state where the well is located.	“KINGFISHER”
STATE_AB	VARCHAR	Abbreviation of the state.	“TX”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“West - TX”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“gulf”
START_DATE	DATE	Start date of fracking.	2020-09-17
END_DATE	DATE	End date of fracking.	2020-10-01

Example Data

API	WELLPAD_ID	OPERATOR_NAME	COUNTY	STATE_AB	SUB_REGION	REGION	START_DATE	END_DATE
4232942414	19444	PIONEER NATURAL RESOURCES	MIDLAND	TX	West - TX	gulf	2020-09-15	2020-10-02
4232942413	19444	PIONEER NATURAL RESOURCES	MIDLAND	TX	West - TX	gulf	2020-09-15	2020-10-02
4247538033	24185	DEVON ENERGY	WARD	TX	West - TX	gulf	2020-09-27	2020-10-02
3305309135	319592	DEVON ENERGY	MCKENZIE	ND	North Dakota	midwest	2020-09-17	2020-10-02
3305309136	319592	DEVON ENERGY	MCKENZIE	ND	North Dakota	midwest	2020-09-17	2020-10-02
4247538034	24185	DEVON ENERGY	WARD	TX	West - TX	gulf	2020-09-27	2020-10-02
3001546572	464419	DEVON ENERGY	EDDY	NM	Permian-NM	west	2020-09-30	2020-10-02
3305309277	319592	DEVON ENERGY	MCKENZIE	ND	North Dakota	midwest	2020-09-17	2020-10-02

Usage

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

Sample queries

⮞ Return the total number of wells constructed by “DEVON ENERGY” in “EDDY” county.

SELECT
  COUNT(*) AS total_wells
FROM
  wells
WHERE
  operator_name ILIKE '%DEVON ENERGY%'
  AND county ILIKE '%EDDY%';

Output

	TOTAL_WELLS
1	2650

⮞ Return WELLPAD_ID, OPERATOR_NAME, COUNTY, and REGION of all wells constructed between 2020-09-20 and 2020-09-25

SELECT
  wellpad_id,
  operator_name,
  county,
  region
FROM
  wells
WHERE
  completion_date BETWEEN '2020-09-20' AND '2020-09-25';

Output

WELLPAD_ID	OPERATOR_NAME	COUNTY	REGION
5066	EOG RESOURCES INC	LEA	west
5385	EOG RESOURCES INC	LEA	west
5387	EOG RESOURCES INC	LEA	west
5385	EOG RESOURCES INC	LEA	west
5390	EOG RESOURCES INC	LEA	west
5390	EOG RESOURCES INC	LEA	west
5499	CONOCOPHILLIPS	LEA	west
5665	KAISER-FRANCIS OIL COMPANY	LEA	west