Frac Crews

This table provides data about users with Frac Crew location specific to a wellpad and its operating dates.

To refer to the Frac Crews API endpoint, click here.

Columns

Column Name	Type	Description	Example Value
WELLPAD_ID	NUMBER	Identifier of the wellpad.	82066
LAT	FLOAT	The latitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	31.9422316
LONG	FLOAT	The longitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	-103.59222
OPERATOR_NAME	VARCHAR	Operator of the well.	“EXXON MOBIL”
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	Frac Crew location date.	2020-09-15
SERVICE_COMPANY	VARCHAR	Company contracted by the operator to perform the Frac job.	“Liberty”
FRAC_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	SERVICE_COMPANY	FRAC_CLASS
82066	31.9422316	-103.59222	EXXON MOBIL	LOVING	TX	West - TX	gulf	2020-09-15	Liberty	oil
72941	28.8853645	-97.9130544	MARATHON OIL COMPANY	KARNES	TX	South - TX	gulf	2020-12-17	NexTier	oil
74595	29.035314778	-97.818832333	MAGNOLIA OIL & GAS OPERATING LLC	KARNES	TX	South - TX	gulf	2022-03-28	Halliburton	oil
5066	32.167616333	-103.625697667	EOG RESOURCES INC	LEA	NM	Permian-NM	west	2020-09-21	FracTech	oil
26958	32.216485	-93.5357735	AETHON ENERGY OPERATING LLC	RED RIVER	LA	Haynesville - LA	gulf	2021-01-05	Halliburton	gas

Usage

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

Sample queries

⮞ Return the total number of wells managed by operator “EXXON MOBIL”

SELECT COUNT(*)
FROM frac_crews
WHERE frac_crews.operator_name = 'EXXON MOBIL';

Output

	COUNT(*)
	11402

⮞ Return WELLPAD_ID, OPERATOR_NAME, COUNTY, and REGION of all wells constructed in the region “gulf”

SELECT frac_crews.wellpad_id,
       frac_crews.operator_name,
       frac_crews.county,
       frac_crews.region
FROM frac_crews
WHERE frac_crews.region = 'gulf';

Output

WELLPAD_ID	OPERATOR_NAME	COUNTY	REGION
82066	EXXON MOBIL	LOVING	gulf
82066	EXXON MOBIL	LOVING	gulf
82066	EXXON MOBIL	LOVING	gulf
82066	EXXON MOBIL	LOVING	gulf
72941	MARATHON OIL COMPANY	KARNES	gulf
72941	MARATHON OIL COMPANY	KARNES	gulf
72941	MARATHON OIL COMPANY	KARNES	gulf
72941	MARATHON OIL COMPANY	KARNES	gulf