Contact Us WVGES Home

Owner/Completion

(for permitted and cancelled wells, only OWNERS data are available; for completed wells, both OWNERS and COMPLETIONS data are available; 1 record per episode of drilling)

Fields in the Owner/Completion table
Field NameDescriptionColumn Type
APIAPI NumberNUMBER
SuffixEpisode Of DrillingVARCHAR2(14)
Cmp_DtCompletion Date (date episode was completed)DATE(mm/dd/yyyy)
StatusStatus Of The Permit To Drill The WellCHAR(9)
Surface_OwnerSurface OwnerVARCHAR2(40)
Well_NumWell Number On The FarmVARCHAR2(6)
Co_NumCompany Number (Operator's Number For The Well)VARCHAR2(30)
LeaseLease NameVARCHAR2(30)
Lease_NumLease NumberVARCHAR2(15)
Mineral_OwnMineral Owner (Name Of The Owner Of The Oil And Gas Rights)VARCHAR2(30)
Operator_at_CompletionOperator Name at Time of Well CompletionVARCHAR2(55)
PVDProposed Vertical Depth (feet)NUMBER(5)
Prop_Trgt_FmProposed Target FormationVARCHAR2(20)
TFm_Est_PrTarget Formation Estimated PressureNUMBER(5)
Spud_DtSpud Date (Date Drilling Began)DATE(mm/dd/yyyy)
ElevElevation, Feet (Surface Of The Well)NUMBER(4)
DatumElevation DatumVARCHAR2(15)
FieldField NameVARCHAR2(15)
Deepest_FmFormation At Total DepthVARCHAR2(20)
Deepest_FmTDeepest Formation TestedVARCHAR2(20)
Initial_ClassInitial Well Classification (AAPG Well Classification)VARCHAR2(24)
Final_ClassFinal Well Classification (AAPG Well Classification)VARCHAR2(24)
TypeWell TypeVARCHAR2(15)
RigRig TypeVARCHAR2(10)
Cmp_MthdCompletion MethodVARCHAR2(10)
TVDTotal Vertical Depth, Feet (From The Surface Datum To The Bottom Of The Well)NUMBER(5)
TMDTotal Measured Depth, Feet (From The Surface Datum To The Bottom Of The Well)NUMBER(5)
New_FtgNew Footage, Feet (Footage Drilled During This Episode)NUMBER(5)
KODKick Off Depth, FeetNUMBER(5)
Volumes
G_BefGas Before Treatment or Natural Open Flow, Thousand Cubic Feet (MCF) / DayNUMBER(6)
G_AftGas After Treatment, Thousand Cubic Feet (MCF) / DayNUMBER(6)
O_BefOil Before Treatment or Natural Open Flow, Barrels / Day (1 Barrel = 42 gallons)NUMBER(4)
O_AftOil After Treatment, Barrels / Day (1 Barrel = 42 gallons)NUMBER(4)
NGL_BefNGL Before Treatment or Natural Open Flow, Barrels / Day (1 Barrel = 42 gallons)NUMBER(6)
NGL_AftNGL After Treatment, Barrels / Day (1 Barrel = 42 gallons)NUMBER(6)
Rock Pressure
P_BefSurface Hole Rock Pressure Before Treatment / Stimulation or Natural Rock Pressure, Pounds Per Square InchNUMBER(4)
Ti_BefShut-In Time Before Treatment / Stimulation, HoursNUMBER(4)
P_AftSurface Hole Rock Pressure After Treatment / Stimulation or Treated Rock Pressure, Pounds Per Square InchNUMBER(4)
Ti_AftShut-In Time After Treatment / Stimulation, HoursNUMBER(4)
BH_P_BefBottom Hole Rock Pressure Before Treatment / Stimulation or Natural Rock Pressure, Pounds Per Square InchNUMBER(4)
BH_P_AftBottom Hole Rock Pressure After Treatment / Stimulation or Treated Rock Pressure, Pounds Per Square InchNUMBER(4)
G_Msrd_ByGas Measured By (Estimated, Orifice, or Pitot)VARCHAR2(9)
CommentCommentVARCHAR2(100)