Skip to content
Developers
Get an API token

Completion and stimulation

Completion design, intensity ratios, and FracFocus disclosures.

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.

20 columns

Completion/stimulation state and summary parameters for a wellbore.

More about this view

One row per completion event per wellbore; a recompletion has the next COMPLETION_SEQUENCE. Mass/volume values represent total injected amounts (proppant_mass in lbs, fluid_volume in gal). PROPPANT_LOADING, PROPPANT_CONCENTRATION and STAGE_SPACING are first-completion ratios computed by Novi; fluid per foot is not published.

Key columns
Sample query
SELECT WELL_COMPLETION_ID, WELLBORE_KEY, COMPLETION_SEQUENCE, COMPLETION_STATE, COMPLETION_END_DATE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.WELL_COMPLETION
LIMIT 10
Columns20
WELL_COMPLETION_IDinteger
Surrogate key for the completion row.
WELLBORE_KEYstring
Foreign key to wellbore.wellbore_key.
COMPLETION_SEQUENCEinteger
1 = first completion; increment for recompletions/re-fracs.
COMPLETION_STATEstring
Completion lifecycle state (derived from events or operational tracking).
COMPLETION_END_DATEdate
Date completion operations ended (if known).
PROPPANT_MASSnumberlb
Total proppant mass injected during completion.
FLUID_VOLUMEnumbergal
Total completion fluid volume injected, in gallons.
STAGE_COUNTinteger
Number of frac stages completed.
More

Omit the field when the stage count is unknown. Do not store 0 for unknown, 0 is not a valid stage count.

PERFORATION_UPPERintegerft
Shallowest perforation depth (MD) in feet.
PERFORATION_LOWERintegerft
Deepest perforation depth (MD) in feet.
PERFORATION_INTERVALintegerft
Perforation interval length in feet (perforation_lower - perforation_upper).
SOAK_TIME_DAYSintegerday
Number of days between the end of the first completion and the start of production (the soak period).
More

NULL when the span is zero or negative, longer than 365 days, or shorter than 30 days where the first-production date is not known accurately. Do not sum across wellbores.

PROPPANT_LOADINGnumberlb/ft
Proppant mass per foot of lateral for the first completion, in lb/ft, computed by Novi rather than from PROPPANT_MASS and a lateral length here.
More

Non-additive ratio, never sum across wellbores. Its denominator is the lateral length Novi selected for the well, so a peer-set figure is an average of ratios rather than a ratio of totals. WELLBORE carries that length as LATERAL_LENGTH, with its method in LATERAL_LENGTH_SOURCE; the ratio need not equal PROPPANT_MASS / LATERAL_LENGTH on every row. Values above 9,000 lb/ft are nulled as physically impossible rather than clamped, so a NULL can mean no credible ratio exists for the well even when PROPPANT_MASS is present. Also NULL when Novi's selected lateral length for the well is unknown or zero. Truncated to whole lb/ft. Populated for the first completion only. WELLBORE_COMPLETION_DESIGN and WELL_DETAIL publish the same number as PROPPANT_LOADING.

PROPPANT_CONCENTRATIONnumberlb/gal
Proppant mass, in pounds, per gallon of completion fluid for the first completion, computed by Novi rather than here from PROPPANT_MASS and FLUID_VOLUME, so it need not equal their quotient on the same row.
More

Non-additive ratio, never sum across wellbores. NULL when proppant mass or fluid volume is unknown or zero, and when the ratio exceeds 8 lb/gal, which Novi treats as not credible; values above 8 are nulled, not clamped. Rounded to 2 decimal places. Populated for the first completion only. WELLBORE_COMPLETION_DESIGN and WELL_DETAIL publish the same number as PROPPANT_CONCENTRATION.

STAGE_SPACINGnumberft
Average distance between frac stages of the first completion, in feet: the lateral length Novi selected for the well (the denominator of PROPPANT_LOADING) divided by the first completion's stage count.
More

Non-additive ratio, never sum across wellbores. WELLBORE carries that length as LATERAL_LENGTH, with its method in LATERAL_LENGTH_SOURCE. NULL when the stage count is zero or the lateral length is unknown. Whole feet. No bounds are applied, so implausibly large or small values (a few under 20 ft) are possible and are published as computed. Populated for the first completion only. WELLBORE_COMPLETION_DESIGN and WELL_DETAIL publish the same number as STAGE_SPACING.

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 completion record was created in this system.
UPDATED_ATtimestamp
Timestamp of the most recent update to this completion record.
30 columns

Summary of a FracFocus chemical disclosure for a hydraulic fracturing event.

More about this view

One row per wellbore per frac sequence number. Contains processed/cleaned summary data from FracFocus along with Novi quality check scores and original ff-prefixed raw fields. Links to wellbore via wellbore_key; the wellbore's regulatory identifier is available on wellbore.native_id.

Key columns
Sample query
SELECT FRAC_FOCUS_SUMMARY_ID, WELLBORE_KEY, SEQUENCE_NR, START_DATE, END_DATE
FROM NOVI_DATA_ACCESS.NOVI_WELLS.FRAC_FOCUS_SUMMARY
LIMIT 10
Columns30
FRAC_FOCUS_SUMMARY_ID
Surrogate key.
SEQUENCE_NR
Sequence number of this frac event for the wellbore (0 = first).
START_DATE
Start date of the fracturing event.
END_DATE
End date of the fracturing event.
DURATION_DAYS
Duration of the fracturing event in days.
FLUID_VOLUME
Total fluid volume used in gallons.
More

Additive.

PROPPANT_MASS
Total proppant mass in pounds.
More

Additive.

PROPPANT_MAIN_TYPE
Main proppant type (e.g., "Sand").
PROPPANT_MAIN_MESH
Main proppant mesh size (e.g., "20/40").
CHECK_DATE
Quality score for date reliability (0-100; 100 = no inconsistencies).
More

Non-additive.

CHECK_WATER_VOLUME
Quality score for fluid volume reliability.
More

Non-additive.

CHECK_PROPPANT_MASS
Quality score for proppant mass reliability.
More

Non-additive.

FF_TOTAL_BASE_WATER_VOLUME
Original FracFocus total base water volume in gallons.
FF_TOTAL_BASE_NON_WATER_VOLUME
Original FracFocus total non-water volume in gallons.
FF_TVD
Original FracFocus TVD in feet.
FF_LATITUDE
Original FracFocus latitude in decimal degrees, in the geodetic datum stated on the disclosure (NAD27, NAD83 or WGS84); the datum is unknown where the disclosure states none.
More

Coordinates in different datums are not directly comparable.

FF_LONGITUDE
Original FracFocus longitude in decimal degrees, in the geodetic datum stated on the disclosure (NAD27, NAD83 or WGS84); the datum is unknown where the disclosure states none.
More

Coordinates in different datums are not directly comparable.

FF_OPERATOR
Original FracFocus operator name.
FF_PKEY
Original FracFocus primary key.
OFS_COMPANY_ORIGINAL
Original oil field service company that performed the job.
OFS_COMPANY_CURRENT
Current identity of OFS company after M&A.
REPORT_DATE
Date the disclosure was first reported to FracFocus.
FF_PROJECTION
Geodetic datum of ff_latitude and ff_longitude as stated on the FracFocus disclosure.
More

NULL where the disclosure states none. Coordinates in different datums are not directly comparable.

FF_VERSION
Version of the FracFocus disclosure form the disclosure was filed on (e.g. 1.0-4.0).
More

The fields a disclosure carries differ between form versions. NULL where not stated. A label, not a measure: never aggregate.

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.
20 columns

Detailed chemical ingredient from a FracFocus disclosure.

More about this view

One row per ingredient per disclosure. Contains original FracFocus fields (ff-prefixed) for trade name, supplier, purpose, CAS number, and concentration percentages.

Key columns
Sample query
SELECT FRAC_FOCUS_INGREDIENT_ID, WELLBORE_KEY, FRAC_FOCUS_SUMMARY_ID, FF_PKEY, SEQUENCE_NR
FROM NOVI_DATA_ACCESS.NOVI_WELLS.FRAC_FOCUS_INGREDIENT
LIMIT 10
Columns20
FF_PKEY
Original FracFocus primary key for the ingredient row.
SEQUENCE_NR
Sequence number linking to the parent FracFocusSummary.
FF_PKEY_DISCLOSURE
Original primary key of the parent FracFocus disclosure.
More

Required for traceability back to FracFocus source data.

FF_TRADE_NAME
Product trade name as reported by the supplier.
FF_SUPPLIER
Company that supplied the product for the frac job.
FF_PURPOSE
Purpose of the ingredient (e.g., Surfactant, Biocide, Proppant).
FF_INGREDIENT_NAME
Chemical ingredient name from FracFocus.
FF_CAS_NUMBER
Chemical Abstract Service identification number (CAS RN format: 2-7 digits, hyphen, 2 digits, hyphen, 1 check digit).
FF_PERCENT_HIGH_ADDITIVE
Percent of the ingredient in the trade name product (top of range from MSDS).
FF_PERCENT_HF_JOB
Percent of the ingredient in the total hydraulic fracturing volume by mass.
FF_MASS_INGREDIENT
Mass of this ingredient.
FF_CLAIMANT_COMPANY
Company claiming trade secret for this ingredient.
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.