/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).

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	str arr	Aggregate data by a list of parameters.	`["date", "region"]`
county	str arr	Limit search by a list of counties.	`["Beauregard", "Coleman", "Colorado"]`
end_date	str [“YYYY-MM-DD”]	Limit search to an end date.	`"2022-07-15"`
operator	str arr	Limit search to a list of well operators.	`["ALLEN BROTHERS", "BP"]`
region	str arr	Limit search by a list of regions (clusters of multiple major producing basins).	`["GULF", "WEST"]`
sub_region	str arr	Limit search by a list of subregions (clusters of several counties forming a major producing basin).	`["S LA", "West - TX"]`
start_date	str [“YYYY-MM-DD”]	Limit search to a start date.	`"2022-06-01"`
state_code	str arr	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	int	Number of drilled but uncompleted wells (DUCs) on a specific date within the input date range.	2
county	str	County in the state where the well is located.	“BEAUREGARD”
date	str [“YYYY-MM-DD”]	Date on which the DUC count is being compiled.	“2022-06-01”
operator_name	str	Operator of the well.	“PIE OPERATING, LLC”
region	str	Aggregation of multiple major producing basins.	“GULF”
state_ab	str	Abbreviation of the state.	“LA”
sub_region	str	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

payload = {
   'aggregate_by': 'date'
}

date	ducs_count
2022-11-01	8342
2022-11-02	8289
2022-11-03	8288
2022-11-04	8278
2022-11-05	8309
2022-11-06	8319
2022-11-07	8346
2022-11-08	8333
2022-11-09	8346
2022-11-10	8349

payload = {
   'aggregate_by': 'region'
}

date	ducs_count	region
2022-11-01	1919	west
2022-11-01	4646	gulf
2022-11-01	870	midwest
2022-11-01	907	northeast
2022-11-02	851	midwest
2022-11-02	1929	west
2022-11-02	4617	gulf
2022-11-02	892	northeast
2022-11-03	880	northeast
2022-11-03	4628	gulf

payload = {
   'aggregate_by': 'state_code'
}

date	ducs_count	state_ab
2022-11-01	324	WY
2022-11-01	733	CO
2022-11-01	149	WV
2022-11-01	155	OH
2022-11-01	4279	TX
2022-11-01	367	LA
2022-11-01	603	PA
2022-11-01	537	ND
2022-11-01	862	NM
2022-11-01	333	OK

payload = {
   'aggregate_by': 'sub_region'
}

date	ducs_count	sub_region
2022-11-01	412	NE PA
2022-11-01	39	North - TX
2022-11-01	149	WV
2022-11-01	155	OH
2022-11-01	278	Central - TX
2022-11-01	537	North Dakota
2022-11-01	41	N LA
2022-11-01	5	SanJuan-CO
2022-11-01	189	Haynesville - TX
2022-11-01	728	Colorado wo SJ

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.

/dailyproduction

/fraccrews