Acreage, activity, and prices
Company acreage parcels, rig and frac activity, and weekly benchmark prices.
Views live in NOVI_DATA_ACCESS.NOVI_WELLS. Column descriptions are from the Wells data dictionary, release 26.4.3.
Acreage
Section titled “Acreage”COMPANY_ACREAGE
Section titled “COMPANY_ACREAGE”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
COMPANY_ACREAGE_IDSurrogate key.
- Joins to
SELECT COMPANY_ACREAGE_ID, OPERATOR_ID, COMPANY, STATE, COUNTYFROM NOVI_DATA_ACCESS.NOVI_WELLS.COMPANY_ACREAGELIMIT 10- 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_IDresolves 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_idfor data lineage. - UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.
Market and activity
Section titled “Market and activity”RIG_ACTIVITY_WEEKLY
Section titled “RIG_ACTIVITY_WEEKLY”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
RIG_ACTIVITY_WEEKLY_IDSurrogate key.
- Joins to
SELECT RIG_ACTIVITY_WEEKLY_ID, STATE, COUNTY, COUNTY_CODE, YEARFROM NOVI_DATA_ACCESS.NOVI_WELLS.RIG_ACTIVITY_WEEKLYLIMIT 10- RIG_ACTIVITY_WEEKLY_ID
- Surrogate key.
- 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_idfor data lineage. - CREATED_AT
- Timestamp the record was created.
- UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.
RIG_FRAC_ACTIVITY
Section titled “RIG_FRAC_ACTIVITY”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
RIG_FRAC_ACTIVITY_IDSurrogate key.
- Joins to
SELECT RIG_FRAC_ACTIVITY_ID, EXTERNAL_ID, OPERATOR_ID, SERVICE_COMPANY, RIG_NUMBERFROM NOVI_DATA_ACCESS.NOVI_WELLS.RIG_FRAC_ACTIVITYLIMIT 10- 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_idfor data lineage. - CREATED_AT
- Timestamp the record was created.
- UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.
PRICE_WEEKLY
Section titled “PRICE_WEEKLY”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
PRICE_WEEKLY_IDSurrogate key.
- Joins to
SELECT PRICE_WEEKLY_ID, DATE, OIL_PRICE, GAS_PRICE, CURRENCYFROM NOVI_DATA_ACCESS.NOVI_WELLS.PRICE_WEEKLYLIMIT 10- 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_idfor data lineage. - UPDATED_AT
- Timestamp of the most recent update.
No columns match. Try a shorter word.