Skip to content
Developers
Get an API token

Production and tests

Monthly and weekly production volumes, reported production roll-ups, and well tests.

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. Type is the data model’s logical type, and unit appears where the model declares one. For Snowflake column types, query NOVI_DATA_ACCESS.INFORMATION_SCHEMA.COLUMNS.

36 columns

The production record for a single wellbore at either monthly or weekly granularity, identified by wellbore_key and a period selector.

More about this view

Captures measured volumes at the wellhead (produced) and, optionally, at the downstream custody-transfer point (sales) for oil (bbl), natural gas (Mcf) and natural gas liquids (bbl), plus injection volumes (water/brine in bbl, gas/CO2/N2 in Mcf) for SWD/EOR/CCUS wells. Each volume is non-negative. When producing_days is one or more, at least one positive volume must be present, either produced/sales or injection; zero-volume periods are permitted when producing_days = 0, for example maintenance or shut-in. Also includes producing_days (bounded by period length) and calendar_days (days in the period; monthly 28 to 31, weekly 7) to support rate normalization. For monthly periods use year/month; for weekly periods use week_year/week (ISO week).

Sample query
SELECT WELLBORE_KEY, OPERATOR_ID, PERIOD_GRANULARITY, YEAR, MONTH
FROM NOVI_DATA_ACCESS.NOVI_WELLS.PRODUCTION
LIMIT 10
Columns36
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
OPERATOR_IDinteger
Foreign key to operator.operator_id.
More

The operator of record for this production period, as the source attributes it: Novi's company name for the filer with mergers applied as of the period, so a month filed before an acquisition names the acquired company and a month filed after it names the acquirer. Not re-resolved to today's owner; join WELL.OPERATOR_ID for the current operator and group by OPERATOR_ID for operator tenure. In Oklahoma the source sometimes attributes a month to the gas purchaser or gatherer rather than the operator; those months carry that company. NULL where the regulator recorded a placeholder rather than an operator.

PERIOD_GRANULARITYstring
Granularity of this record's period.
YEARinteger
Calendar year of this production record (UTC).
MONTHinteger
Calendar month number of this production record (1–12).
WEEK_YEARinteger
ISO week-numbering year for weekly records (may differ from calendar year near boundaries).
WEEKinteger
ISO week number (1–53) for weekly records.
PRODUCING_DAYSinteger
Number of days in this period during which the wellbore was actively producing OR injecting.
More

Bounded by period length (0–31 monthly, 0–7 weekly). 0 days legitimately implies zero produced + zero injected volumes (maintenance, shut-in, plugged). For injection-only wells (SWD, EOR injectors), an active-injection period reports producing_days >= 1 even though produced volumes are zero.

CALENDAR_DAYSinteger
Number of calendar days represented for this period (1–31 monthly, exactly 7 weekly).
OPERATING_STATUSstring
Operational status for this period.
More

'producing' or 'injecting' implies producing_days >= 1. 'maintenance', 'shut_in', 'shut_in_injector', and 'temporarily_abandoned' allow zero volumes and require downtime_reason. 'injecting' applies to active injection periods (SWD, EOR injectors); 'shut_in_injector' is the injection-well analog of shut_in.

DOWNTIME_REASONstring
Optional free-text note describing maintenance/shut_in reason or context.
OILnumberbbl
Oil volume produced at the wellhead for the period, measured in barrels (bbl).
More

May carry oil and condensate as a single combined volume, in which case condensate is null. A populated oil beside a null condensate therefore does not assert that no condensate was produced, whether or not the stream was reported separately upstream.

OIL_SALESnumberbbl
Oil volume measured at the downstream custody-transfer (sales) point for the period, in barrels (bbl).
GASnumberMcf
Natural gas volume produced at the wellhead for the period, measured in thousand cubic feet (Mcf).
GAS_SALESnumberMcf
Natural gas volume measured at the downstream custody-transfer (sales) point for the period, in thousand cubic feet (Mcf).
NGLnumberbbl
Natural gas liquids volume produced at the wellhead for the period, measured in barrels (bbl).
NGL_SALESnumberbbl
Natural gas liquids volume measured at the downstream custody-transfer (sales) point for the period, in barrels (bbl).
WATERnumberbbl
Produced water volume for the period, measured in barrels (bbl).
CONDENSATEnumberbbl
Condensate volume produced at the wellhead for the period, measured in barrels (bbl).
More

Null wherever the volume is not carried separately. A null does not establish that none was produced: the volume may be combined into oil, or may simply not have been reported.

CONDENSATE_SALESnumberbbl
Condensate volume measured at the downstream custody-transfer (sales) point for the period, in barrels (bbl).
GAS_FLAREDnumberMcf
Natural gas volume flared in the period, measured in thousand cubic feet (Mcf).
More

Used for emissions and regulatory reporting.

MONTHS_ON_PRODUCTIONinteger
Calendar-month index of the row relative to the wellbore's first month on production.
More

1 = the first month on production; a source that distinguishes an incomplete first month marks it 0, in which case 1 is the first full month. After the first index every calendar month advances it by one whether or not the month produced, so indices are unique and contiguous across a wellbore's monthly rows (one monthly row per calendar month; weekly rows of the same month share its index). The elapsed-time axis for type-curve analysis: it aligns wells of different vintages on months since first production rather than on absolute date (year/month). Elapsed, not produced, a shut-in month still advances it. SUPPLY_PROJECTION shares the convention for cohort joins. On this surface the index starts at 1: the partial first month is not distinguished.

CUMULATIVE_PRODUCING_DAYSintegerday
Cumulative number of producing days since production start.
PRODUCTION_DATEdate
First day of the month for this production record (e.g., "2021-12-01").
More

Convenience field equivalent to year/month.

IS_OIL_FROM_PRODUCTION_SHARINGboolean
True if oil production data is from a proprietary source.
IS_GAS_FROM_PRODUCTION_SHARINGboolean
True if gas production data is from a proprietary source.
IS_GAS_FLARED_FROM_PRODUCTION_SHARINGboolean
True if flared gas data is from a proprietary source.
IS_WATER_FROM_PRODUCTION_SHARINGboolean
True if water production data is from a proprietary source.
INJECTION_WATERnumberbbl
Water or brine injected at the wellbore for the period in barrels (waterflood, saltwater disposal, produced-water disposal).
More

Volumetric, additive across periods for the same wellbore.

INJECTION_GASnumberMcf
Gas injected at the wellbore for the period in thousand cubic feet (gas-injection EOR, CCUS, pressure maintenance, gas storage cycling).
More

Includes hydrocarbon gas, CO2, and N2 reported as one combined gaseous-injectant volume; the individual gases are not reported separately.

OPERATOR_REPORTEDstring
The operator of this wellbore for this period as reported by the state regulatory agency, verbatim.
More

Not resolved to an operator row; OPERATOR_ID carries the resolved operator.

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_ATtimestamp
Timestamp the record was created.
UPDATED_ATtimestamp
Timestamp of the most recent update.
42 columns

Production roll-ups reported at well level: cumulative volumes at the 12-month, 24-month and life horizons, the peak producing month for oil, gas, water and BOE (NGL and condensate are not carried, and BOE is a converted total rather than a production stream), life-to-date gas-oil ratio, and the index of the last month with reported production.

More about this view

Cumulative volume columns end in _REPORTED: reported volumes only, no forecast. Beside them it carries forecast EUR at 20, 30 and 50 years per stream, which is a forecast, not reported production. The roll-ups are REPORTED values, not computed from the production fact, a consumer wanting figures derived from monthly rows should compute them from production, which may give a different answer over a different set of months.

Key columns
Sample query
SELECT WELL_PRODUCTION_SUMMARY_ID, WELLBORE_KEY, CUM_OIL_12_REPORTED, CUM_OIL_24_REPORTED, CUM_OIL_LIFE_REPORTED
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_PRODUCTION_SUMMARY
LIMIT 10
Columns42
WELL_PRODUCTION_SUMMARY_IDinteger
Surrogate key.
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
More

The roll-up is a well-level quantity, carried on the well's lowest-sequence bore (sequence_number 0); the well's other bores have no row, so a well's cumulative is never repeated across its laterals and the volumes stay additive across wellbores. A consequence for aggregation: filtering wellbores on a wellbore attribute before summing can drop a whole well's roll-up, because the carrying bore is the lowest-sequence one and need not be the production lateral. Rows carrying a value are identifiable by a wellbore_key ending in:0.

CUM_OIL_12_REPORTEDnumberbbl
Reported volumes only; excludes forecast volumes.
More

Oil volume accumulated through the twelfth month on production. It may include condensate. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_OIL_24_REPORTEDnumberbbl
Reported volumes only; excludes forecast volumes.
More

Oil volume accumulated through the twenty-fourth month on production. It may include condensate. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_OIL_LIFE_REPORTEDnumberbbl
Reported volumes only; excludes forecast volumes.
More

Oil volume over the well's full reported history. It may include condensate. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_GAS_12_REPORTEDnumberMcf
Reported volumes only; excludes forecast volumes.
More

Gas volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_GAS_24_REPORTEDnumberMcf
Reported volumes only; excludes forecast volumes.
More

Gas volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_GAS_LIFE_REPORTEDnumberMcf
Reported volumes only; excludes forecast volumes.
More

Gas volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_WATER_12_REPORTEDnumberbbl
Reported volumes only; excludes forecast volumes.
More

Water volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_WATER_24_REPORTEDnumberbbl
Reported volumes only; excludes forecast volumes.
More

Water volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_WATER_LIFE_REPORTEDnumberbbl
Reported volumes only; excludes forecast volumes.
More

Water volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

CUM_BOE_12_REPORTEDnumberBOE
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the first 12 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. Null when the well has no producing month at index 12 or beyond: a permit-only row, a well whose reported history has not yet reached month 12, or a well that ceased producing before month 12. Never a partial sum.

CUM_BOE_24_REPORTEDnumberBOE
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the first 24 months on production. Additive across wellbores at this horizon; never across horizons, the 12- and 24-month windows overlap. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. Null when the well has no producing month at index 24 or beyond: a permit-only row, a well whose reported history has not yet reached month 24, or a well that ceased producing before month 24. Never a partial sum.

CUM_BOE_LIFE_REPORTEDnumberBOE
Reported volumes only; excludes forecast volumes.
More

Barrel-of-oil-equivalent volume over the well's full reported history. Additive across wellbores; not across time within a wellbore; it is already a running total. BOE comprises oil, condensate and gas at 6 Mcf = 1 BOE, and excludes NGL. 0 where the value is reported as nothing, and null where no value is reported at all. A zero and a null are different statements, and neither alone identifies a well that did not produce.

PEAK_MONTH_OIL_INDEXinteger
Index on the months-on-production axis of the month in which combined oil and condensate volume peaked.
More

The peak is selected on the combined volume, so on a condensate-rich well this can name a different month than an oil-only peak would. Ties resolve to the earliest such month. Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_OIL_AMOUNTnumberbbl
Combined oil and condensate volume in that peak month.
More

A volume, not a rate. Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_GAS_INDEXinteger
Index on the months-on-production axis of the month in which gas volume peaked.
More

Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_GAS_AMOUNTnumberMcf
Gas volume in that peak month.
More

Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_WATER_INDEXinteger
Index on the months-on-production axis of the month in which water volume peaked.
More

Non-additive. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_WATER_AMOUNTnumberbbl
Water volume in that peak month.
More

Non-additive across wellbores. Null when the stream never produced: a zero maximum is not a peak.

PEAK_MONTH_BOE_INDEXinteger
Index on the months-on-production axis of the month in which barrel-of-oil-equivalent volume peaked.
More

The monthly BOE this peak is selected on is oil and gas at 6 Mcf = 1 BOE and EXCLUDES condensate, unlike the cumulative BOE columns, which include it, so on a condensate-rich well the peak month can differ from the one a condensate-inclusive BOE would select. Non-additive. Null when no month carried a positive total: a zero maximum is not a peak.

PEAK_MONTH_BOE_AMOUNTnumberBOE
Barrel-of-oil-equivalent volume in that peak month, as oil and gas at 6 Mcf = 1 BOE.
More

EXCLUDES condensate and NGL, a narrower basis than the cumulative BOE columns, which include condensate. Non-additive across wellbores. Null when no month carried a positive total: a zero maximum is not a peak.

CUM_LIFE_GORnumberMcf/bbl
Life-to-date producing gas-oil ratio: life gas over life liquid, where the liquid denominator is the oil that cum_oil_life_reported carries, which may include condensate.
More

Null when that liquid total is zero, so a gas-only well has no value here rather than an infinite one. Rounded to two decimal places. NON-ADDITIVE, never sum or average across wellbores; recompute from the underlying volumes. Recomputing it needs cum_gas_life_reported and cum_oil_life_reported, which are not guaranteed present on the same row.

LAST_REPORTED_MONTHS_ON_PRODUCTIONinteger
Index on the months-on-production axis of the last month with reported production.
More

An index, not a count: it identifies a month, it does not total them. Reported rather than derived from the monthly production fact, and not guaranteed to agree with an index computed from it. Non-additive.

LAST_REPORTED_MONTHdate
First day of the last month in which the well reported a positive combined volume of oil, condensate, gas, flared gas and water.
More

A month whose volumes are all zero or unreported does not count, so a well that has gone to zero carries the last month before it did. Reported rather than derived from the monthly production fact, and not guaranteed to equal a month computed from it. Non-additive. Null when no month qualifies.

EUR_OIL_20YRnumberbbl
Forecast estimated ultimate recovery of oil through the first 20 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_20YRnumberMcf
Forecast estimated ultimate recovery of gas through the first 20 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_20YRnumberbbl
Forecast estimated ultimate recovery of water through the first 20 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_20YRnumberBOE
Forecast estimated ultimate recovery through the first 20 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

EUR_OIL_30YRnumberbbl
Forecast estimated ultimate recovery of oil through the first 30 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_30YRnumberMcf
Forecast estimated ultimate recovery of gas through the first 30 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_30YRnumberbbl
Forecast estimated ultimate recovery of water through the first 30 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_30YRnumberBOE
Forecast estimated ultimate recovery through the first 30 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

EUR_OIL_50YRnumberbbl
Forecast estimated ultimate recovery of oil through the first 50 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_GAS_50YRnumberMcf
Forecast estimated ultimate recovery of gas through the first 50 years on production, in Mcf.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole Mcf: 0 where the forecast is under one Mcf or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_WATER_50YRnumberbbl
Forecast estimated ultimate recovery of water through the first 50 years on production, in bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. In whole bbl: 0 where the forecast is under one bbl or states no volume for this stream; NULL where no forecast value exists at this horizon.

EUR_BOE_50YRnumberBOE
Forecast estimated ultimate recovery through the first 50 years on production, in barrels of oil equivalent at 6 Mcf = 1 bbl.
More

A forecast for the well as currently producing, not a reported production volume. Additive across wellbores at the same horizon; never add horizons together. Whether condensate is included is not defined. In whole BOE: 0 where the forecast is under one BOE or states no volume; NULL where no forecast value exists at this horizon.

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_ATtimestamp
Timestamp the record was created.
UPDATED_ATtimestamp
Timestamp of the most recent update.
17 columns

Periodic well test measurement for a single wellbore on a specific test date.

More about this view

Captures 24-hour flow rates for oil, gas, and water, along with pressure readings. Used for lease allocation, production calibration, and artificial lift optimization. One row per wellbore per test date.

Key columns
Sample query
SELECT WELL_TEST_ID, WELLBORE_KEY, TEST_DATE, OIL_RATE, GAS_RATE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_TEST
LIMIT 10
Columns17
WELL_TEST_IDinteger
Surrogate key for the well test row.
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
TEST_DATEdate
Date on which the well test was performed.
OIL_RATEnumberbbl/d
24-hour oil production rate in barrels per day.
More

Semi-additive: do not sum across wellbores.

GAS_RATEnumberMcf/d
24-hour gas production rate in Mcf per day.
More

Semi-additive: do not sum across wellbores.

WATER_RATEnumberbbl/d
24-hour water production rate in barrels per day.
More

Semi-additive: do not sum across wellbores.

FLOWING_WELLHEAD_PRESSUREnumberpsi
Pressure at the wellhead while flowing during the test.
More

Semi-additive.

BOTTOM_HOLE_PRESSUREnumberpsi
Bottom hole pressure during the test.
More

Semi-additive.

SHUT_IN_WELLHEAD_PRESSUREnumberpsi
Pressure at the wellhead while shut-in during the test.
More

Semi-additive.

OIL_GRAVITYnumberdeg API
API gravity of produced oil in degrees, measured at standard conditions (60°F).
More

Conventional buckets: <22.3 = heavy, 22.3–31.1 = medium, >31.1 = light, >50 = condensate. Property of the fluid sample at this test event.

GAS_SPECIFIC_GRAVITYnumberSG
Specific gravity of produced gas relative to air, air = 1.0.
More

A property of the fluid sample at this test event, not of the wellbore: a wellbore with several tests has several values, and the most recent one is a derivation rather than this column. Dry pipeline gas is typically 0.55–0.70; richer casinghead and condensate-associated gas runs higher, and values above roughly 1.0 indicate a heavy, NGL-rich stream. Non-additive: never sum, and average only with volume weighting. Sparse by design, NULL means this test reported no gas gravity, which is the common case, while the absence of a row means no test. minimum: 0 is a physical floor, consistent with the other measures on this entity; it is not a range check. Sources that range-guard the value (the primary US source discards readings outside 0.5–1.5) do so before it reaches this column, and a source that does not is not caught here.

REPORT_DATEdate
Date when the test was first reported.
More

May differ from test_date.

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_ATtimestamp
Timestamp the record was created.
UPDATED_ATtimestamp
Timestamp of the most recent update.