DUCs by Operator

This table provides data about the drilled but uncompleted wells by operator (the company that runs the well).

To refer to the DUCs API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
DATE	DATE	Date on which the DUC count is being compiled.	2016-01-01
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“North Dakota”
COUNTY	VARCHAR	County in the state where the well is located.	“WILLIAMS”
STATE_AB	VARCHAR	Abbreviation of the state.	“ND”
OPERATOR_NAME	VARCHAR	Operator of the well.	“CHORD ENERGY”
COUNT	NUMBER	Number of drilled but uncompleted wells (DUCs) on a specific date within the input date range.	23
REGION	VARCHAR	Aggregation of multiple major producing basins.	“midwest”

Example Data

DATE	SUB_REGION	COUNTY	STATE_AB	OPERATOR_NAME	COUNT	REGION
2016-01-01	New Mexico	SAN JUAN	NM	PROD CORP	1	west
2016-01-01	North Dakota	WILLIAMS	ND	CHORD ENERGY	23	midwest
2016-01-01	North Dakota	MCKENZIE	ND	MARATHON OIL COMPANY	5	midwest
2016-01-01	OH	BELMONT	OH	RICE OPERATING COMPANY	27	northeast
2016-01-01	South - TX	LAVACA	TX	CAPITAL STAR OIL & GAS INC	1	gulf
2016-01-01	South - TX	GUADALUPE	TX	CIVRON PETROLEUM RES., LLC	2	gulf
2016-01-01	South - TX	KARNES	TX	CONOCOPHILLIPS	11	gulf

Usage

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

Sample queries

⮞ Return the total number of uncompleted wells by the operator “GUNN OIL COMPANY”

SELECT COUNT(*)
FROM wells
JOIN ducs ON wells.operator_name = ducs.operator_name
WHERE wells.operator_name ILIKE '%GUNN OIL COMPANY%'
AND wells.completion_date IS NULL;

Output

	COUNT(*)
1	927404

⮞ Return all the records for incomplete wells in the COUNTY “ATOKA”

SELECT ducs.*
FROM ducs
JOIN wells ON ducs.sub_region = wells.sub_region
AND ducs.region = wells.region
AND ducs.county = wells.county
WHERE ducs.county ILIKE '%atoka%'
AND wells.completion_date IS NULL;

Output

DATE	SUB_REGION	COUNTY	STATE_AB	OPERATOR_NAME	COUNT	REGION
2020-11-13	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2020-11-13	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2021-09-18	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2021-09-18	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2021-09-18	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2021-09-18	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2021-09-18	OK	ATOKA	OK	WESTERN OIL AND GAS DEVELOPMENT CORP	1	midwest
2022-02-21	OK	ATOKA	OK	NextEra Energy Inc	1	midwest