Wells

Oil wells are created by drilling into an oil or gas reserve. They are mounted with a drilling device such as a pumpjack which allows extraction of oil from the reserve using a variety of different drilling methods.

This endpoint returns well-level data.

To refer to the Wells API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
API	NUMBER	An API is a unique, permanent, numeric identifier assigned to each well drilled.	4200547
WELLPAD_ID	FLOAT	Identifier of the wellpad.	426979
SPUD_DATE	DATE	Spudding is the day the main drill bit enters the ground, which leads to the removal of rock, dirt, and sedimentary materials.	2012-12-17
COMPLETION_DATE	DATE	Date on which the well was completed.	2012-12-24
OPERATOR_NAME	VARCHAR	Operator of the well.	“AMOCO PRODUCTION CO.”
COUNTY	VARCHAR	County in the state where the well is located.	“ANGELINA”
STATE_AB	VARCHAR	Abbreviation of the state.	“TX”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“Haynesville - TX”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“gulf”
LAT	FLOAT	The latitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	32.283661
LONG	FLOAT	The longitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	-94.124666
PERMIT_DATE	DATE	The date on which the well permit was authorized.	1980-08-13
TOTAL_VERTICAL_DEPTH	FLOAT	The total vertical depth of an operating well in feet.	8626
MEASURED_DEPTH	FLOAT	The measured operating depth of a well in feet.	9099
HORIZONTAL_LENGTH	FLOAT	The horizontal length of a well in feet.	2432
WELLBORE_TYPE	VARCHAR	The orientation of the well bore used to locate and extract oil and gas from a well. Valid types are ‘vertical’, ‘horizontal’, and ‘directional’.	“Directional”
LAT_BOTTOMHOLE	FLOAT	The latitude of the bottom hole location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	31.264597
LON_BOTTOMHOLE	FLOAT	The longitude of the bottom hole location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	-87.257753
PRODUCTION_FIRST_DATE	DATE	(Unsynced) date on which the well was first productive after completion.	2010-04-01

Example Data

API	WELLPAD_ID	SPUD_DATE	COMPLETION_DATE	OPERATOR_NAME	COUNTY	STATE_AB	SUB_REGION	REGION	LAT	LONG	PERMIT_DATE	TOTAL_VERTICAL_DEPTH	MEASURED_DEPTH	HORIZONTAL_LENGTH	WELLBORE_TYPE	LAT_BOTTOMHOLE	LON_BOTTOMHOLE	PRODUCTION_FIRST_DATE
1700122186	465855	2022-10-05	2023-03-04	PETROQUEST ENERGY LLC	ACADIA	LA	S LA	gulf	30.132733	-92.612912			12972		Directional	32.129973	-92.615899	2023-05-01
1700122313	410349	2022-04-18	2022-05-13	TEXAS PETROLEUM INVESTMENT COMPANY	ACADIA	LA	S LA	gulf	30.322117	-92.359065			9286	957	Directional	30.320422	-92.357094	2022-07-01
1700122314	412638	2022-05-09	2022-05-31	TEXAS PETROLEUM INVESTMENT COMPANY	ACADIA	LA	S LA	gulf	30.320961	-92.379185			6171	1671	Horizontal	30.316757	-92.377060	2022-05-01
1700122316	458377	2022-10-13	2022-11-11	ZACHRY EXPLORATION	ACADIA	LA	S LA	gulf	30.336661	-92.531839			10517	1706	Directional	30.340812	-92.534055
1700122317	458378	2022-08-22	2023-01-03	CAMEX OPERATING COMPANY	ACADIA	LA	S LA	gulf	30.300517	-92.175919			10102	1290	Directional	30.303089	-92.173168	2023-02-01

Usage

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

Sample queries

⮞ Return the total number of wells completed by the operator “PETROQUEST ENERGY LLC”

SELECT
    COUNT(*)
FROM
    wells
WHERE
    wells.operator_name = 'PETROQUEST ENERGY LLC';

Output

	COUNT(*)
1	196

⮞ Return all the wells constructed in the county “ACADIA” by the operator “PETROQUEST ENERGY LLC”

SELECT
    *
FROM
    wells
WHERE
    wells.county ILIKE '%ACADIA%'
    AND wells.operator_name ILIKE '%PETROQUEST ENERGY LLC%';

Output

API	WELLPAD_ID	SPUD_DATE	COMPLETION_DATE	OPERATOR_NAME	COUNTY	STATE_AB	SUB_REGION	REGION	LAT	LONG	PERMIT_DATE	TOTAL_VERTICAL_DEPTH	MEASURED_DEPTH	HORIZONTAL_LENGTH	WELLBORE_TYPE	LAT_BOTTOMHOLE	LON_BOTTOMHOLE	PRODUCTION_FIRST_DATE
1700122186	465855	2022-10-05	2023-03-04	PETROQUEST ENERGY LLC	ACADIA	LA	SLA	gulf	30.13273306	-92.61291193			12972		Directional	32.129973	-92.615899	2023-05-01