Rigs

This table provides data about rig locations specific to a wellpad and its operating dates.

To refer to the rigs API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
WELLPAD_ID	NUMBER	Identifier of the wellpad.	17112
LAT	FLOAT	The latitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	31.884649271
LONG	FLOAT	The longitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	-103.545034529
OPERATOR_NAME	VARCHAR	Operator of the well.	“AETHON ENERGY OPERATING LLC”
COUNTY	VARCHAR	County in the state where the well is located.	“LOVING”
STATE_AB	VARCHAR	Abbreviation of the state.	“TX”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“West - TX”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“gulf”
DATE	DATE	Date on which a rig is operating.	2021-06-12
RIG_CLASS	VARCHAR	Classifies wells as either oil or gas wells based on the GOR definition from the EIA.	“oil”

Example Data

WELLPAD_ID	LAT	LONG	OPERATOR_NAME	COUNTY	STATE_AB	SUB_REGION	REGION	DATE	RIG_CLASS
334439	30.320731	-91.307393	BOARDWALK LOUISIANA MIDSTREAM LLC	IBERVILLE	LA	S LA	gulf	2021-01-09	oil
459930	27.913309	-99.299791	AGERON IRONROC ENERGY LLC	WEBB	TX	South - TX	gulf	2022-12-20	gas
341151	32.490883	-94.193898	ARK-LA-TEX ENERGY LLC	HARRISON	TX	Haynesville - TX	gulf	2021-07-16	gas
475727	39.554836	-80.818767	ANTERO RESOURCES CORPORATION	TYLER	WV	WV	northeast	2023-10-29	gas
387589	32.291645	-101.680334	CROWNQUEST OPERATING LLC	HOWARD	TX	West - TX	gulf	2022-10-16	oil
475754	42.927257	-104.91579	CONTINENTAL RESOURCES	CONVERSE	WY	Wyoming	west	2023-12-12	oil
472240	47.875339	-103.148705	CONTINENTAL RESOURCES	MCKENZIE	ND	North Dakota	midwest	2023-08-15	oil

Usage

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

Sample queries

⮞ Return the total number of oil wells in the region “gulf”

SELECT
  COUNT(*)
FROM
  rigs
WHERE
  rigs.region ILIKE 'gulf'
  AND rigs.rig_class ILIKE 'Oil';

Output

	COUNT(*)
1	323040

⮞ Return WELLPAD_ID, OPERATOR_NAME, COUNTY, and REGION of all wells constructed between 2021-06-12 and 2021-06-14

SELECT
  rigs.wellpad_id,
  rigs.operator_name,
  rigs.county,
  rigs.region
FROM
  rigs
WHERE
  rigs.date >= '2021-06-12'
  AND rigs.date <= '2021-06-14';

Output

WELLPAD_ID	OPERATOR_NAME	COUNTY	REGION
339697	AETHON ENERGY OPERATING LLC	RED RIVER	gulf
340311	AGERON IRONROC ENERGY LLC	WASHINGTON	gulf
340311	AGERON IRONROC ENERGY LLC	WASHINGTON	gulf
340311	AGERON IRONROC ENERGY LLC	WASHINGTON	gulf
338206	AETHON ENERGY OPERATING LLC	BOSSIER	gulf
338206	AETHON ENERGY OPERATING LLC	BOSSIER	gulf
338206	AETHON ENERGY OPERATING LLC	BOSSIER	gulf
217715	BCE-MACH LLC	KINGFISHER	midwest
217715	BCE-MACH LLC	KINGFISHER	midwest
217715	BCE-MACH LLC	KINGFISHER	midwest