Skip to content
Developers
Get an API token

Acreage, activity, and prices

Company acreage parcels, rig and frac activity, and weekly benchmark prices.

View MarkdownOpen in Claude(opens in a new tab)

Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3.

16 columns

Land-parcel acreage positions held by an operator or mineral rights company.

More about this view

One row per individual leasehold parcel, a company can hold many parcels in the same (state, county, basin), each with its own polygon, acres, and per-parcel NRI/WI. Consumers needing company-area totals or area-weighted averages should aggregate in their own queries (SUM acres; area-weighted NRI/WI). Use geometry_wkt as the parcel discriminator.

Key columns
Sample query
SELECT COMPANY_ACREAGE_ID, OPERATOR_ID, COMPANY, STATE, COUNTY
FROM NOVI_DATA_ACCESS.NOVI_WELLS.COMPANY_ACREAGE
LIMIT 10
Columns16
COMPANY_ACREAGE_ID
Surrogate key.
More

Per-parcel, distinguished by geometry within a company × state × county × basin × subbasin cell.

OPERATOR_ID
Foreign key to operator.operator_id: the company holding the acreage position, the current holder after mergers as the source states it.
More

Resolves to the same company that COMPANY names.

COMPANY
Name of the company holding the acreage position, as the source states it: the current holder after mergers.
More

OPERATOR_ID resolves to the same company.

STATE
State name.
COUNTY
County name.
SUBBASIN
Sub-basin name.
More

Optional, provides a finer geographic grouping than basin alone.

NRI
Net revenue interest (fraction) for this parcel.
More

Non-additive across parcels (use area-weighted average in the analytics layer if rolling up).

NRI_TYPE
Whether the per-parcel NRI is exactly known or an area average from the source.
WI
Working interest (fraction) for this parcel.
More

Non-additive across parcels (use area-weighted average in the analytics layer if rolling up).

WI_TYPE
Whether the per-parcel WI is exactly known or an area average from the source.
ACRES
Parcel area in acres.
More

Additive across parcels within the same company.

UPDATE_DATE
Date the acreage data was last updated.
GEOMETRY_WKT
Well-known text representation of the parcel boundary.
More

Required, acts as the parcel discriminator within a (company, state, county, basin, subbasin) cell. Large WKT polygons may be up to ~1MB.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SOURCE_ID
Foreign key to source.source_id for data lineage.
UPDATED_AT
Timestamp of the most recent update.
16 columns

Weekly horizontal rig count by county and basin, sourced from Baker Hughes North American Rotary Rig Count.

More about this view

One row per state/county/basin/subbasin per ISO week. Used for drilling activity monitoring and supply forecasting. Rig counts are semi-additive across geography but not across time.

Key columns
Joins to
Sample query
SELECT RIG_ACTIVITY_WEEKLY_ID, STATE, COUNTY, COUNTY_CODE, YEAR
FROM NOVI_DATA_ACCESS.NOVI_WELLS.RIG_ACTIVITY_WEEKLY
LIMIT 10
Columns16
STATE
US state code (USPS two-letter).
COUNTY
County name.
COUNTY_CODE
FIPS county code.
YEAR
ISO week-numbering year.
WEEK
ISO week number.
MONTH
Calendar month of the Friday that falls within this ISO week.
More

When an ISO week spans two months, the month is determined by the Friday date. Provided as a convenience for monthly aggregation.

OIL_RIGS
Number of horizontal rigs drilling for oil.
More

Semi-additive across geography.

GAS_RIGS
Number of horizontal rigs drilling for gas.
More

Semi-additive.

OTHER_RIGS
Number of horizontal rigs drilling for other purposes.
More

Semi-additive.

TOTAL_RIGS
Total horizontal rigs in this county/basin for the week.
More

Semi-additive.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_AT
Timestamp the record was created.
UPDATED_AT
Timestamp of the most recent update.
22 columns

Combined rig and frac fleet activity details.

More about this view

One row per observation record per activity date. A record may represent a single unit or an aggregated count for a location/operator. Tracks active drilling rigs and fracturing fleets across basins with location, operator, and service company information.

Key columns
Sample query
SELECT RIG_FRAC_ACTIVITY_ID, EXTERNAL_ID, OPERATOR_ID, SERVICE_COMPANY, RIG_NUMBER
FROM NOVI_DATA_ACCESS.NOVI_WELLS.RIG_FRAC_ACTIVITY
LIMIT 10
Columns22
RIG_FRAC_ACTIVITY_ID
Surrogate key.
EXTERNAL_ID
External source identifier for this record.
OPERATOR_ID
Foreign key to operator.operator_id.
More

The company operating the rig or frac fleet, as the activity source names it and without further normalization: a name variant (legal suffix, spelling) can resolve to its own operator row.

SERVICE_COMPANY
Service company providing the equipment.
RIG_NUMBER
Specific rig number or identifier.
COUNTRY
Country where equipment is located.
STATE_PROVINCE
State or province.
COUNTY
County name.
LATITUDE
Latitude of the equipment location.
LONGITUDE
Longitude of the equipment location.
EQUIPMENT_TYPE
Type of equipment: Rig or Frac fleet.
LOCATION_TYPE
Deprecated: superseded by LOCATION_METHOD, which carries the same values on every row.
More

Whether the location is estimated or precisely known. It will be removed in a later release, announced in that release's notes.

DATA_SOURCE
The rig/frac data provider.
COUNT
Number of units of this equipment type that the row represents.
More

A row can aggregate several units at one location, operator and activity date; for a rig row that reports a trajectory, the count is of rigs drilling that trajectory, so rows split by trajectory are summed to get the total for their location, operator and date.

ACTIVITY_DATE
Date of the activity observation.
RIG_TRAJECTORY
Trajectory of the well the rig is drilling.
More

Applies to rig rows only and is NULL on frac fleet rows. HORIZONTAL is also carried where the provider reports no trajectory for a rig, so it is not always a reported value; OTHER is a reported value, not a missing one.

LOCATION_METHOD
Method by which the rig or frac fleet location was determined: ESTIMATED or PRECISE.
More

Replaces LOCATION_TYPE, with the same values.

BASIN
Basin name (e.g., Permian, Eagle Ford).
SUBBASIN
Subbasin name (e.g., Delaware, Midland).
SOURCE_ID
Foreign key to source.source_id for data lineage.
CREATED_AT
Timestamp the record was created.
UPDATED_AT
Timestamp of the most recent update.
7 columns

Weekly benchmark commodity prices.

More about this view

One row per week (Friday date). Provides WTI oil and Henry Hub gas prices. Used for economics, benchmarking, and price history analysis. Prices are non-additive point-in-time observations.

Key columns
Joins to
Sample query
SELECT PRICE_WEEKLY_ID, DATE, OIL_PRICE, GAS_PRICE, CURRENCY
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRICE_WEEKLY
LIMIT 10
Columns7
PRICE_WEEKLY_ID
Surrogate key.
DATE
Friday date for this weekly price observation.
OIL_PRICE
WTI oil price in USD per barrel.
More

Non-additive.

GAS_PRICE
Henry Hub gas price in USD per MMBtu.
More

Non-additive.

CURRENCY
Currency for prices (defaults to USD).
SOURCE_ID
Foreign key to source.source_id for data lineage.
UPDATED_AT
Timestamp of the most recent update.