/ducsbyoperator#

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#

ducs_by_operator(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.

⮞ Setup the client.

from synmax.hyperion import HyperionApiClient, ApiPayload
access_token = 'your access token goes here'
client = HyperionApiClient(access_token=access_token)

For a more detailed guide on setting up the Hyperion client, please see the Quickstart page.

⮞ Use parameters to narrow down your request.

payload = ApiPayload(start_date='2021-05-01', end_date='2022-06-25', sub_region=['S LA', 'West - TX'])

Tip

Narrow down your request to receive a faster response. Using no parameters will fetch the entire dataset which may take a very long time.

⮞ Call the function.

result_df = client.ducs_by_operator(payload)

⮞ Print the results or save them for later.

# Print the entire response as a string.
print(result_df.to_string())

# Create a CSV file from the output.
result_df.to_csv('output.csv')

# Print the number of items per column.
print(result_df.count())

For more information on outputting to different formats, please see the pandas DataFrame documentation.

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.