Data Schema
Well
Horizontal Frac
the horizontal frac table provides details about unconventional horizontal fracture completions for use in comparative analysis between wells variable data type unit of measure is nullable? default value description uwi string no unique well identifier must match the uwi from the well docid\ p xhbe4jqkjqemay7aol5 table date datetime offset no frac job date datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 averageeffectivespacing double ft yes average distance to offset wells at time of completion mineffectivespacing double ft yes distance to the closest offset at the time of completion type string yes completion type (plug n perf, sliding sleeve, etc) it is important to standardize values to enable grouped analysis fluidtype string yes completion fluid type (x link gel, slickwater, etc) it is important to standardize values to enable grouped analysis stimulatedlength double ft yes total length of stimulated lateral stages int yes number of stages in the frac job totalfluid double bbl yes total fluid used in the frac job totalproppant double lb yes total proppant used in the frac job perforationcount int yes total perforation count in the frac job stagespacing double ft yes stage spacing in the frac job