# Acreage, activity, and prices

Source: https://developers.novilabs.com/data/tables/activity-land/

> 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

### COMPANY_ACREAGE

Land-parcel acreage positions held by an operator or mineral rights company. 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.

| Column | Description |
| --- | --- |
| `COMPANY_ACREAGE_ID` | Surrogate key. 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. 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. `OPERATOR_ID` resolves to the same company. |
| `STATE` | State name. |
| `COUNTY` | County name. |
| `SUBBASIN` | Sub-basin name. Optional, provides a finer geographic grouping than basin alone. |
| `NRI` | Net revenue interest (fraction) for this parcel. 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. 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. 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. 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. |

## Market and activity

### RIG_ACTIVITY_WEEKLY

Weekly horizontal rig count by county and basin, sourced from Baker Hughes North American Rotary Rig Count. 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.

| Column | Description |
| --- | --- |
| `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. 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. Semi-additive across geography. |
| `GAS_RIGS` | Number of horizontal rigs drilling for gas. Semi-additive. |
| `OTHER_RIGS` | Number of horizontal rigs drilling for other purposes. Semi-additive. |
| `TOTAL_RIGS` | Total horizontal rigs in this county/basin for the week. 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. |

### RIG_FRAC_ACTIVITY

Combined rig and frac fleet activity details. 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.

| Column | Description |
| --- | --- |
| `RIG_FRAC_ACTIVITY_ID` | Surrogate key. |
| `EXTERNAL_ID` | External source identifier for this record. |
| `OPERATOR_ID` | Foreign key to operator.operator\_id. 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. 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. 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. 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. 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. |

### PRICE_WEEKLY

Weekly benchmark commodity prices. 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.

| Column | Description |
| --- | --- |
| `PRICE_WEEKLY_ID` | Surrogate key. |
| `DATE` | Friday date for this weekly price observation. |
| `OIL_PRICE` | WTI oil price in USD per barrel. Non-additive. |
| `GAS_PRICE` | Henry Hub gas price in USD per MMBtu. 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. |
