Regions#

This table provides information on regions.

To refer to the regions API endpoint, click here.

Columns#

Column Name	Type	Description	Example Value
COUNTY	VARCHAR	County in the state where the well is located.	“BIBB (AL)”
STATE_AB	VARCHAR	Abbreviation of the state.	“AL”
SUB_REGION	VARCHAR	Aggregation of several counties, typically representing a major producing basin.	“AL”
REGION	VARCHAR	Aggregation of multiple major producing basins.	“southeast”

REGION	SUB_REGION	COUNTY	STATE_AB
southeast	AL	AUTAUGA (AL)	AL
midwest	AR	ARKANSAS (AR)	AR
Canada	Canada	AB (CAN)	AB (CAN)
gulf	Central - TX	ARCHER (TX)	TX
west	Colorado wo SJ	ADAMS (CO)	CO
midwest	KS	CLAY (KS)	KS

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

⮞ Return the distinct number of counties belonging to the “southeast” region.

SELECT
  COUNT(DISTINCT county)
FROM
  regions
WHERE
  region ILIKE '%southeast%';

Output

	COUNT(DISTINCT COUNTY)
1	152

⮞ Return all the sub regions belong to “gulf”.

SELECT
  DISTINCT regions.sub_region
FROM
  regions
WHERE
  regions.region ILIKE '%gulf%';

Output