/ducsbyoperator#

Warning

Deprecation Notice for Hyperion API v3 - We are deprecating Hyperion API v3 to concentrate on the improved functionality of newer versions. V3 will no longer receive new features or enhancements.

New Integrations: Please use Hyperion API v4.

Existing v3 Users: We encourage you to migrate to v4.

SynMax will provide migration guides and proactive support to assist with your transition.

Drilled but uncompleted wells (DUCs) are oil and natural gas wells that have been drilled but have not yet undergone various well completion activities. We define a well as a DUC from the date on which drilling begins, up to the date a frac crew finishes completing the well and moves off the wellpad.

This endpoint returns drilled but uncompleted wells by operator (the company that runs the well).

Warning

A throttling mechanism with a rate limit of 300 requests per minute has been implemented for this endpoint. This is temporary and may be adjusted in the future.

Endpoint#

POST

https://hyperion.api.synmax.com/v3/ducsbyoperator

Usage#

Python#

client.ducs_by_operator(payload=ApiPayload(aggregate_by=[None], county=[None], end_date=None, operator=[None], region=[None], start_date=None, state_code=[None], sub_region=[None]))#

Returns drilled but uncompleted wells by county and operator.

Object returned is a pandas DataFrame.

Note

To learn how to setup and use Python client, refer to Setup and Usage .

Parameters#

Query#

Parameter

Type

Description

Example

aggregate_by

string array

Aggregate data by a list of parameters.

["date", "region"]

county

string array

Limit search by a list of counties.

["Beauregard", "Coleman", "Colorado"]

end_date

string

Limit search to an end date. Date formatting - [“YYYY-MM-DD”]

"2022-07-15"

operator

string array

Limit search to a list of well operators.

["ALLEN BROTHERS", "BP"]

region

string array

Limit search by a list of regions (clusters of multiple major producing basins).

["GULF", "WEST"]

sub_region

string array

Limit search by a list of subregions (clusters of several counties forming a major producing basin).

["S LA", "West - TX"]

start_date

string

Limit search to a start date. Date formatting - [“YYYY-MM-DD”]

"2022-06-01"

state_code

string array

Limit search by a list of state codes.

["LA", "CO"]

Aggregation#

Aggregation provides an overview of overall productions levels for a particular operator or across a given region during a given timeframe.

Data is always implicitly aggregated by date. This means all other column data are grouped by date.

Supported parameters: county, date, region, state_code, sub_region

Response#

Parameter

Type

Description

Example

count

integer

Number of drilled but uncompleted wells (DUCs) on a specific date within the input date range.

2

county

string

County in the state where the well is located.

“BEAUREGARD”

date

string

Date on which the DUC count is being compiled. Date formatting - [“YYYY-MM-DD”]

“2022-06-01”

operator_name

string

Operator of the well.

“PIE OPERATING, LLC”

region

string

Aggregation of multiple major producing basins.

“GULF”

state_ab

string

Abbreviation of the state.

“LA”

sub_region

string

Aggregation of several counties, typically representing a major producing basin.

“S LA”

Responses#

Normal Output#

count

county

date

operator_name

region

state_ab

sub_region

41

MIDLAND

2022-09-16

CROWNQUEST OPERATING LLC

gulf

TX

West - TX

1

STERLING

2022-09-16

CROWNQUEST OPERATING LLC

gulf

TX

West - TX

1

REAGAN

2022-09-16

DE3 OPERATING LLC

gulf

TX

West - TX

1

MOTLEY

2022-09-16

DRY FORK PRODUCTION COMPANY LLC

gulf

TX

West - TX

1

MOTLEY

2022-09-16

E N PATTON OIL COMPANY INC

gulf

TX

West - TX

4

REAGAN

2022-09-16

EARTHSTONE

gulf

TX

West - TX

1

MARTIN

2022-09-16

ELEMENT PETROLEUM OPERATING LLC

gulf

TX

West - TX

20

GLASSCOCK

2022-09-16

EXXON MOBIL

gulf

TX

West - TX

19

MIDLAND

2022-09-16

FIREBIRD ENERGY LLC

gulf

TX

West - TX

1

HUDSPETH

2022-09-16

HUDSPETH OPERATING LLC

gulf

TX

West - TX

Note

Output data will return as “null” when input data is invalid or does not exist.

Aggregated Output#

Aggregated by…

payload = {
   'aggregate_by': 'county'
}

county

date

ducs_count

JEFFERSON DAVIS

2022-11-01

3

WASHINGTON

2022-11-01

45

NEWTON

2022-11-01

1

WINKLER

2022-11-01

41

LAVACA

2022-11-01

16

RIO BLANCO

2022-11-01

14

PECOS

2022-11-01

14

CARTER

2022-11-01

20

CALCASIEU

2022-11-01

5

FRIO

2022-11-01

12

Tip

To better explore using the aggregation functionality interactively, consider using our Excel Add-in. By familiarizing yourself with the available options, you can more efficiently query and process the data for your specific needs. To learn how to use the SynMax Excel Add-in, please refer to our Excel Add-in Documentation.