Production By Well#

This table provides monthly oil and gas production figures for a specific well.

To refer to the Production by Well endpoint, click here.

Columns#

Column Name	Type	Description	Example Value
DATE	DATE	Unsynced date on which oil and gas production starts.	2021-02-01
GAS_MONTHLY	FLOAT	Amount of gas produced over one month (in MCF, or 1 thousand cubic feet).	0
OIL_MONTHLY	FLOAT	The amount of oil produced over one month (in BBLS, or barrels).	11
WATER_MONTHLY	FLOAT	The amount of water extracted from the well during a one-month production period (in BBLs, or barrels).	18771
OPERATOR_NAME	VARCHAR	Operator of the well.	“WHITING OIL & GAS CORPORATION”
WELL_NO	VARCHAR	The number assigned to a well at a specific site.	“1373”
WELL_NAME	VARCHAR	The name assigned to a well at a specific site.	“G.w. Obrien Et Al”
API	NUMBER	An API is a unique, permanent, numeric identifier assigned to each well drilled.	4247533361
STATE_AB	VARCHAR	Abbreviation of the state.	“TX”
REGION	NUMBER	Aggregation of multiple major producing basins.	351
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“West - TX”
COUNTY	VARCHAR	County in the state where the well is located.	“Ward”
FIELD_NAME	VARCHAR	The name of a specific oil and gas field - as designated by the appropriate state agency.	“Ward-Estes, North”
FORMATION	VARCHAR	Definition of the geological makeup (formation) at a specific well.	“YATES”
TOWNSHIP	VARCHAR	Townships are divisions of a county, shaped as squares with 6 miles to a side. Township squares are gridded and numbered according to their position north or south of the baseline.	020S
RANGE	VARCHAR	Ranges are columns of townships set side-by-side. Range numbers start at the meridian that passes through the point of origin of each system and runs east to west.	007W
SECTION	VARCHAR	A section is a further subdivision of a township, represented by a numerical value between 1 and 36. Each section is about 1 square mile.	16
PRODUCTION_MONTH	NUMBER	Month of gas or oil production.	338

Example Data#

DATE	GAS_MONTHLY	OPERATOR_NAME	WELL_NO	WELL_NAME	API	STATE_AB	REGION	SUB_REGION	COUNTY	FIELD_NAME	FORMATION	TOWNSHIP	RANGE	SECTION	PRODUCTION_MONTH
2010-07-01	3414	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	186
2010-08-01	2110	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	187
2010-09-01	2584	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	188
2010-10-01	2458	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	189
2010-11-01	2510	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	190
2010-12-01	1780	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	191
2011-01-01	1516	Black Warrior Methane Corp.	1373	CENTER COAL 33-5-3	112522992	AL	970	AL	Tuscaloosa	Brookwood	Pottsville Coal Interval	019S	007W	33	192

Usage#

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

Sample queries#

⮞ Return the total number of OIL_MONTHLY produced from date 2015-02-01 to 2015-03-01

SELECT
  SUM(oil_monthly)
FROM
  production_by_well
WHERE
  date BETWEEN '2015-02-01' AND '2015-03-01';

Output

SUM(OIL_MONTHLY)
422339612

⮞ Return “DATE”, “OIL_MONTHLY” and “GAS_MONTHLY” columns where the WELL_NAME is “G.w. Obrien Et Al” and monthly oil production greater than 40 in last 5 years

SELECT: production_by_well.date, production_by_well.oil_monthly, production_by_well.gas_monthly
FROM: production_by_well
WHERE: production_by_well.well_name ILIKE ‘%G.w. Obrien Et Al%’ AND production_by_well.oil_monthly > 40 AND DATE_PART (YEAR, production_by_well.date) >= DATE_PART (YEAR, CURRENT_DATE) - 5;

Output

Example Data#

DATE	OIL_MONTHLY	GAS_MONTHLY
2023-06-01	2451	0
2023-07-01	2459	0
2023-08-01	2472	0
2023-09-01	2376	0
2020-01-01	2743	2897
2020-02-01	2544	3025
2020-03-01	2527	2754
2020-04-01	2517	2695
2020-05-01	2711	2388
2020-06-01	2606	1971
2020-07-01	2465	2676

Note

Unsynced data in the date column provide a date at the start of the month. However, the actual reported date is for the end of the month.

For example, if the reported date is “2022-1-10”, this means the data pertains to the month of January and was actually reported on “2022-01-31”.

This means that you should ideally interpret the reported date as representing the whole month and not just the specific date at the start of the month.

Operator Classification

Regions