/shorttermforecastdeclines#
This endpoint returns short-term forecasts of oil and gas production declines for individual well APIs. It extends the functionality of the short-term forecast by projecting the “well-level” forecast up to ten years into the future from the current date.
Warning
A throttling mechanism with a rate limit of 30 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/shorttermforecastdeclines |
Usage#
Python#
- short_term_forecast_declines(aggregate_by=[None], api=[None], county=[None], end_date=None, first_production_month_end=None, first_production_month_start=None, modeled=None, operator=[None], production_month=[None], region=[None], start_date=None, state_code=[None], sub_region=[None], state_reported=None)#
Returns a prediction of gas production decline (gas_monthly) for the selected month (start_date).
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.short_term_forecast_declines(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. |
|
api |
integer array |
Filter for specific well API numbers that are currently online. |
|
county |
string array |
Limit search by a list of counties. |
|
end_date |
string |
Limit search to an end date. Date formatting - [“YYYY-MM-DD”] |
|
first_production_month_end |
string |
End of the date range for selecting wells that began producing in the specified month (Format: ‘YYYY-MM-01’). |
“2023-03-01” |
first_production_month_start |
string |
Start of the date range for selecting wells that began producing in the specified month (Format: ‘YYYY-MM-01’). |
“2023-11-01” |
modeled |
boolean |
Indicates whether the production numbers are based on our forecast model (True) or from pipescrapes (False). |
True, False |
operator |
string array |
Limit search to a list of well operators. |
|
production_month |
integer array |
Filter for specific production months of selected wells. Represents one or more months since the well started producing. Starts from 1 and increases by 1 for each subsequent month of production. |
|
region |
string array |
Limit search by a list of regions (clusters of multiple major producing basins). |
|
start_date |
string |
Limit search to a start date. Date formatting - [“YYYY-MM-DD”] |
|
state_code |
string array |
Limit search by a list of state codes. |
|
sub_region |
string array |
Limit search by a list of subregions (clusters of several counties forming a major producing basin). |
|
state_reported |
boolean |
Indicates if the well has production measurement(s) from state data sources (True) or if the entire well production was forecasted (False). |
True, False |
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
, first_production_month
, modeled
, operator
, production_month
, region
, state_code
, sub_region
, state_reported
Response#
Parameter |
Type |
Description |
Example |
---|---|---|---|
api |
integer |
An API is a unique, permanent, numeric identifier assigned to each well drilled. |
1701121257 |
county_name |
string |
Name of the county where the well is located. |
“ADAMS” |
date |
string |
Forecasted month (unsynced). Date formatting - [“YYYY-MM-DD”] |
“2022-11-01” |
first_production_month |
string |
Start of date range for selecting wells that started producing in the specific month. Format: Format: “YYYY-MM-01” |
“2009-10-01” |
forecast_run_date |
string |
Date of nearest forecast (unsynced). Date formatting - [“YYYY-MM-DD”] |
“2022-06-01” |
gas_daily |
float |
Average rate of gas production declined expressed per day (in BCF/day). |
23.842 |
gas_monthly |
float |
Amount of gas production declined over one month (in MCF, or 1 thousand cubic feet). |
0.0 |
modeled |
boolean |
Indicates whether the production numbers are from the forecast model (True) or from pipescrapes (False). |
True, False |
oil_daily |
float |
The amount of oil production declined in a single day (in BBLS, or barrels). |
112.9570761 |
oil_monthly |
float |
The amount of oil production declined over one month (in BBLS, or barrels). |
86.0 |
operator_name |
string |
Operator of the well. |
“PIE OPERATING, LLC” |
production_month |
integer |
Specific production months of specific wells. Starts from 1 and increases by 1 for each subsequent month. |
4 |
region |
string |
Aggregation of multiple major producing basins. |
“GULF” |
state_ab |
string |
Abbreviation of the state. |
“LA” |
state_reported |
boolean |
Indicates if the well has production measurement(s) from state data sources (True) or if the entire well production was forecasted (False). |
True, False |
sub_region |
string |
Aggregation of several counties, typically representing a major producing basin. |
“S LA” |
page_size |
integer |
Number of items returned in a single page |
1000 |
start |
integer |
Starting index for the data returned in this request. An index of 0 means that the current data begins from the first item in the complete dataset. |
0 |
total_count |
integer |
Total number of items in the dataset. This is important for calculating how many pages of data exist. |
38258749 |
Responses#
Normal Output#
api |
county_name |
date |
first_production_month |
forecast_run_date |
gas_daily |
gas_monthly |
modeled |
oil_daily |
oil_monthly |
operator_name |
production_month |
region |
state_ab |
state_reported |
sub_region |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
500105242 |
Adams |
2023-01-01 |
2009-10-01 |
2024-11-04 |
0 |
0 |
False |
2.774193548387097 |
86 |
INVESTMENT EQUIPMENT LLC |
31 |
west |
co |
True |
Colorado wo SJ |
500105242 |
Adams |
2023-02-01 |
2009-10-01 |
2024-11-04 |
0 |
0 |
False |
3.0714285714285716 |
86 |
INVESTMENT EQUIPMENT LLC |
32 |
west |
co |
True |
Colorado wo SJ |
500105242 |
Adams |
2023-03-01 |
2009-10-01 |
2024-11-04 |
0 |
0 |
False |
2.903225806451613 |
90 |
INVESTMENT EQUIPMENT LLC |
33 |
west |
co |
True |
Colorado wo SJ |
500105242 |
Adams |
2023-05-01 |
2009-10-01 |
2024-11-04 |
0 |
0 |
False |
2.3548387096774195 |
73 |
INVESTMENT EQUIPMENT LLC |
34 |
west |
co |
True |
Colorado wo SJ |
500105242 |
Adams |
2023-06-01 |
2009-10-01 |
2024-11-04 |
0 |
0 |
False |
2.7 |
81 |
INVESTMENT EQUIPMENT LLC |
35 |
west |
co |
True |
Colorado wo SJ |
500105242 |
Adams |
2023-07-01 |
2009-10-01 |
2024-11-04 |
0 |
0 |
False |
2.870967741935484 |
89 |
INVESTMENT EQUIPMENT LLC |
36 |
west |
co |
True |
Colorado wo SJ |
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_name |
date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
---|---|---|---|---|---|
WILLIAMSON |
2023-01-01 |
0.0 |
0.0 |
21.580645161290324 |
669.0 |
WICHITA |
2023-01-01 |
551.8064516129032 |
17106.0 |
3203.2258064516127 |
99300.0 |
CARTER |
2023-01-01 |
159062.87096774194 |
4930949.0 |
9288.354838709678 |
287939.0 |
BEAVER |
2023-01-01 |
305907.33600387094 |
9483127.416119998 |
1476.032258064516 |
45757.0 |
OCHILTREE |
2023-01-01 |
63438.51612903226 |
1966594.0 |
7855.774193548387 |
243529.0 |
ALLEN |
2023-01-01 |
1620.967741935484 |
50250.0 |
392.48387096774195 |
12167.0 |
ORANGE |
2023-01-01 |
6894.967741935484 |
213744.0 |
1195.0 |
37045.0 |
CLEARFIELD |
2023-01-01 |
23307.707096774197 |
722538.92 |
null |
null |
payload = {
'aggregate_by': 'date'
}
date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
---|---|---|---|---|
2023-01-01 |
72992375.50669348 |
2262763640.707498 |
5292828.096774193 |
164077671.0 |
2023-02-01 |
73056188.75127696 |
2045573285.0357547 |
5345932.464285715 |
149686109.0 |
2023-03-01 |
73595851.86146814 |
2281471407.705512 |
5432769.903225807 |
168415867.0 |
2023-04-01 |
73300825.99995485 |
2199024779.9986453 |
5415878.8 |
162476364.0 |
2023-05-01 |
73668661.16095677 |
2283728495.98966 |
5411956.870967742 |
167770663.0 |
2023-06-01 |
3401842.5247597 |
2202055275.7427907 |
5352901.666666667 |
160587050.0 |
2023-07-01 |
73638236.91250293 |
2282785344.287591 |
5370184.064516129 |
166475706.0 |
2023-08-01 |
74200447.34435892 |
2300213867.6751266 |
5438436.129032258 |
168591520.0 |
2023-09-01 |
107814239.35545444 |
3234427180.6636333 |
9786483.35271054 |
293594500.5813162 |
payload = {
'aggregate_by': 'operator'
}
date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
operator_name |
|
---|---|---|---|---|---|---|
2023-01-01 |
48.483870967741936 |
1503.0 |
118.29032258064517 |
3667.0 |
PETRO-GUARD PRODUCTION LLC |
|
2023-01-01 |
0.0 |
0.0 |
0.8709677419354839 |
27.0 |
KRAMER FRANK & ETHEL FLP |
|
2023-01-01 |
30.451612903225808 |
944.0 |
49.12903225806452 |
1523.0 |
NITRO OIL & GAS |
LLC |
2023-01-01 |
154.48387096774192 |
4789.0 |
25.483870967741936 |
790.0 |
CANOK INTERNATIONAL INC |
|
2023-01-01 |
376.48387096774195 |
11671.0 |
37.516129032258064 |
1163.0 |
CEJA CORPORATION |
|
2023-01-01 |
0.0 |
0.0 |
1.4516129032258065 |
45.0 |
COLEY THOMAS |
|
2023-01-01 |
0.0 |
0.0 |
10.806451612903226 |
335.0 |
DRUM OIL & GAS INC |
|
2023-01-01 |
49.32258064516129 |
1529.0 |
0.0 |
0.0 |
SOUTHERN CRUDE OIL RESOURCES INC |
payload = {
'aggregate_by': 'region'
}
date |
forecast_run_date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
region |
---|---|---|---|---|---|---|
2023-01-01 |
2024-07-25 |
15927567.483870968 |
493754592.0 |
2508682.9677419355 |
77769172.0 |
west |
2023-01-01 |
2024-07-25 |
34844094.11959577 |
1080166917.707469 |
null |
null |
northeast |
2023-01-01 |
2024-07-25 |
11975729.193548387 |
371247605.0 |
1333717.3548387096 |
41345238.0 |
gulf |
2023-01-01 |
2024-07-25 |
0.2903225806451613 |
9.0 |
13.193548387096774 |
409.0 |
southeast |
2023-01-01 |
2024-07-25 |
10244984.41935484 |
317594517.0 |
1450414.5806451612 |
44962852.0 |
midwest |
2023-02-01 |
2024-07-25 |
11028367.857142856 |
308794300.0 |
1547858.357142857 |
43340034.0 |
midwest |
2023-02-01 |
2024-07-25 |
34434290.92984826 |
964160146.0357512 |
null |
null |
northeast |
2023-02-01 |
2024-07-25 |
15774250.535714285 |
441679015.0 |
2462763.75 |
68957385.0 |
west |
payload = {
'aggregate_by': 'state_code'
}
date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
state_ab |
---|---|---|---|---|---|
2023-01-01 |
3392208.2258064514 |
105158455.0 |
242051.67741935485 |
7503602.0 |
WY |
2023-01-01 |
4204618.903225807 |
130343186.0 |
426168.29032258067 |
13211217.0 |
CO |
2023-01-01 |
7396613.451612903 |
229295017.0 |
397777.6451612903 |
12331107.0 |
OK |
2023-01-01 |
11374083.58064516 |
352596591.0 |
1237964.5806451612 |
38376902.0 |
TX |
2023-01-01 |
601645.9032258064 |
18651023.0 |
95765.96774193548 |
2968745.0 |
LA |
2023-01-01 |
21017863.477337733 |
651553767.7974697 |
null |
null |
PA |
2023-01-01 |
6131453.869999999 |
190075069.96999997 |
null |
null |
OH |
2023-01-01 |
7694776.772258064 |
238538079.93999997 |
null |
null |
WV |
2023-01-01 |
2848370.9677419355 |
88299500.0 |
1052636.935483871 |
32631745.0 |
ND |
payload = {
'aggregate_by': 'sub_region'
}
date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
sub_region |
---|---|---|---|---|---|
2023-01-01 |
6131453.87 |
190075069.97 |
null |
null |
OH |
2023-01-01 |
2867031.935483871 |
88877990.0 |
66160.29032258065 |
2050969.0 |
Central - TX |
2023-01-01 |
34278.903225806454 |
1062646.0 |
13371.967741935483 |
414531.0 |
Haynesville - LA |
2023-01-01 |
7396613.451612903 |
229295017.0 |
397777.6451612903 |
12331107.0 |
OK |
2023-01-01 |
244812.35483870967 |
7589183.0 |
9775.548387096775 |
303042.0 |
N LA |
2023-01-01 |
7694776.772258064 |
238538079.93999997 |
null |
null |
WV |
2023-01-01 |
6700207.580645162 |
207706435.0 |
1806290.5483870967 |
55995007.0 |
Permian-NM |
2023-01-01 |
4204618.903225807 |
130343186.0 |
426168.29032258067 |
13211217.0 |
Colorado wo SJ |
2023-01-01 |
9376581.554434506 |
290674028.1874697 |
null |
null |
SW PA |
payload = {
'aggregate_by': 'first_production_month'
}
date |
first_production_month |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
---|---|---|---|---|---|
2025-03-01 |
1997-02-01 |
10019.3475121059 |
310599.7728752829 |
1023.9639444729 |
31742.882278659 |
2025-03-01 |
1983-03-01 |
267.8162031776 |
8302.3022985049 |
89.4718446422 |
2773.627183908 |
2025-03-01 |
2003-03-01 |
18818.6491544916 |
583378.1237892408 |
432.1295378377 |
13396.0156729685 |
2025-03-01 |
1983-09-01 |
1421.8130811968 |
44076.2055170993 |
134.0859388209 |
4156.6641034477 |
2025-03-01 |
2008-10-01 |
83511.6165112061 |
2588860.111847388 |
2349.7005117445 |
72840.7158640784 |
2025-03-01 |
1955-03-01 |
1.1612903226 |
36.0 |
10.4838709677 |
325.0 |
2025-03-01 |
1970-05-01 |
0.0 |
0.0 |
1.935483871 |
60.0 |
payload = {
'aggregate_by': 'modeled'
}
date |
gas_daily |
gas_monthly |
modeled |
oil_daily |
oil_monthly |
---|---|---|---|---|---|
2033-12-01 |
13603118.573884588 |
421696675.7904222 |
True |
1632191.5835263892 |
50597939.08931807 |
2033-12-01 |
7265918.252073348 |
225243465.81427377 |
0.0 |
0.0 |
|
2034-01-01 |
13571623.169802813 |
420720318.2638872 |
True |
1628849.3456666088 |
50494329.71566487 |
2034-01-01 |
6883850.892891507 |
213399377.67963672 |
0.0 |
0.0 |
|
2034-02-01 |
6876124.03123561 |
192531472.87459707 |
0.0 |
0.0 |
|
2034-03-01 |
5400753.492933834 |
167423358.28094885 |
0.0 |
0.0 |
|
2034-04-01 |
421717.641293132 |
12651529.238793962 |
0.0 |
0.0 |
|
2034-05-01 |
415959.5736155271 |
12894746.78208134 |
0.0 |
0.0 |
|
2034-06-01 |
410405.1560950999 |
12312154.682852998 |
0.0 |
0.0 |
payload = {
'aggregate_by': 'production_month'
}
date |
gas_daily |
gas_monthly |
oil_daily |
oil_monthly |
production_month |
---|---|---|---|---|---|
2035-09-01 |
3271.9858727489 |
98159.576182468 |
0.0 |
0.0 |
156.0 |
2035-09-01 |
960.3766118499 |
28811.2983554958 |
0.0 |
0.0 |
160.0 |
2035-09-01 |
123.426341587 |
3702.7902476087 |
0.0 |
0.0 |
183.0 |
2035-09-01 |
717.8476606492 |
21535.4298194765 |
0.0 |
0.0 |
154.0 |
2035-09-01 |
910.6397683088 |
27319.1930492637 |
0.0 |
0.0 |
194.0 |
2035-09-01 |
566.9261628353 |
17007.7848850593 |
0.0 |
0.0 |
171.0 |
2035-09-01 |
1521.5937390841 |
45647.8121725231 |
0.0 |
0.0 |
157.0 |
payload = {
'aggregate_by': 'state_reported'
}
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.