Oil, Gas, & Other Regulated Wells: Beginning 1860

data.ny.gov | Last Updated 18 Sep 2018

Information on oil, gas, storage, solution salt, stratigraphic, and geothermal wells in New York State

Tags: oil, gas, wells, geology, mineral resources, geothermal, stratigraphic, storage, solution salt

This dataset has the following 51 columns:

Column NameAPI Column NameData TypeDescription
API Well Numberapi_well_numbernumberUnique 14-digit well identification number designed by the American Petroleum Institute (API) and referred to as the API number
County Codecounty_codenumberThree-digit code identifying the county where the surface of the well is located; this code also appears as the third through fifth digits of the API number. A list of the county codes and numbers appears in the attached Data Dictionary document. (Note: The data does not display any preceding zeroes.)
API Hole Numberapi_hole_numbernumberFive-digit code identifying the well; this code also appears as the sixth through tenth digits of the API number. (Note: The data does not display any preceding zeroes.)
SidetracksidetracknumberTwo-digit code identifying any secondary wellbore, called a sidetrack, which is drilled out of and away from the original wellbore; this code also appears as the eleventh and twelfth digits of the API number. (Note: The data does not display any preceding zeroes.)
CompletioncompletionnumberTwo-digit code identifying the number of operations, known as completions, which have occurred in a given wellbore to allow oil/gas to enter the wellbore; this code also appears as the thirteenth and fourteenth digits of the API number. (Note: The data does not display any preceding zeroes.)
Well Namewell_nametextName of the well as designated on the permit application; typically the well name is based on the lease or unit name.
Company Namecompany_nametextWell owner/operator
Operator Numberoperator_numbernumberUnique ID number assigned to each well owner/operator
Well Typewell_typetextWell type codes: BR Brine; DH Dry Hole; DS Disposa; l DW Dry Wildcat; GD Gas Development; GE Gas Extension; GW Gas Wildcat; IG Injection Gas; IW Enhanced Oil Recovery - Injection; LP Liquefied Petroleum Gas Storage; MB Monitoring Brine; MM Monitoring Miscellaneous; MS Monitoring Storage; NL Not Listed; OD Oil Development; OE Oil Extension; OW Oil Wildcat; SG Stratigraphic; ST Storage; TH Geothermal
Map Symbolmap_symboltextDenotes well type and status in a combined code: CON Confidential; GW Gas Well; GWP Gas Well Plugged; OW Oil Well; OWP Oil Well Plugged; S Storage Well; SP Storage Well Plugged; SM Solution Brine Well; SMP Solution Brine Well Plugged; DH Dry Hole; O Other Well*; OP Other Well Plugged* *Other includes: Injection, Stratigraphic, Geothermal, and Not Listed well types.
Well Statuswell_statustextWell status codes: AC Active; AR Application Received to Drill/Plug/Convert; CA Cancelled; DC Drilling Completed; DD Drilled Deeper; DG Drilling in Progress; EX Expired Permit; IN Inactive; NR Not Reported on Annual Well Report; PA Plugged and Abandoned; PI Permit Issued; PB Plugged Back; PM Plugged Back Multilateral; RE Refunded Fee; RW Released - Water Well; SI Shut-In; TA Temporarily Abandoned; TR Transferred Permit; UN Unknown; UL Unknown Located; UM Unknown Not Found; VP Voided Permit
Status Datestatus_datecalendar_dateDate current well status was assigned
Permit Application Datepermit_application_datecalendar_dateDate permit application was received
Permit Issued Datepermit_issued_datecalendar_dateDate permit was issued/approved
Date Spuddeddate_spuddedcalendar_dateDate drilling began
Date of Total Depthdate_of_total_depthcalendar_dateDate wellbore was drilled to its endpoint, or total depth
Date Well Completeddate_well_completedcalendar_dateDate on which all activities and methods of preparing the well for production or other purposes (e.g., disposal, storage, etc.) were completed, making the well fully operational
Date Well Pluggeddate_well_pluggedcalendar_dateDate of completed plugging operations whereby the well was closed permanently with cement plugs
Date Well Confidentiality Endsdate_well_confidentiality_endscalendar_dateDate confidential status ends/ended
Confidentiality Codeconfidentiality_codetextConfidential well data codes: No - Well does not have confidential information; Yes - Well information is held confidential for 6 months after spud date; Extended - Confidential status has been extended for an additional 18 months; Released - Confidential information has been released
TowntowntextTown where the surface location of the well resides
QuadquadtextUnited States Geological Survey 7.5-minute quadrangle/topographic map of the location where the well resides
Quad Sectionquad_sectiontextLetter designation (A-I) of the specific section of the United States Geological Survey quadrangle map where the surface location of the well resides
Producing Fieldproducing_fieldtextName of the producing field or geographically local area underlain by an accumulation, pool or group of pools of oil/gas
Producing Formationproducing_formationtextName of the geologic formation from which the well is producing oil, gas, or brine
Financial Securityfinancial_securitytextFinancial security codes: TRUE – The well is subject to financial security requirements; FALSE – The well is not subject to financial security requirements Financial security is required for all wells drilled after June 5, 1973 to guarantee that funds will be available in the future for ultimate well plugging and surface restoration.
SlantslanttextOrientation of wellbore (Vertical/Horizontal/Directional)
CountycountytextCounty where the surface of the well is located
RegionregionnumberNew York State Department of Environmental Conservation region where the surface of the well is located. A map of NYSDEC regions can be found on NYSDEC’s website at: http://www.dec.ny.gov/about/50230.html.
State Leasestate_leasetextState Lease codes: NA Not Applicable; SD Well on State DOT Land; SP Well on State Park Land; ST Well on State DEC Land; SO Well on State Other Land; UD Unitized with State DOT Land; UP Unitized with State Park Land; UT Unitized with State DEC Land; UO Unitized with Other State Land A well located on state land or unitized with state land must pay a percentage of its revenue to the state for any oil and gas produced.
Proposed Depth, ftproposed_depth_ftnumberDepth (feet) specified on permit application
Surface Longitudesurface_longitudenumberLongitude (decimal degrees) of surface location of the well
Surface Latitudesurface_latitudenumberLatitude (decimal degrees) of surface location of the well
Bottom Hole Longitudebottom_hole_longitudenumberLongitude (decimal degrees) of bottom hole, or lowest/deepest location of the wellbore
Bottom Hole Latitudebottom_hole_latitudenumberLatitude (decimal degrees) of bottom hole, or lowest/deepest location of the wellbore
True Vertical Depth, fttrue_vertical_depth_ftnumberTotal vertical distance (feet) between the bottom hole, or lowest/deepest location of the wellbore and the surface
Measured Depth, ftmeasured_depth_ftnumberTotal measured length (feet) of the wellbore
Kickoff, ftkickoff_ftnumberDepth (feet) in a vertical wellbore at which a deviated or slanted wellbore is started to allow for directional drilling
Drilled Depth, ftdrilled_depth_ftnumberTotal measured length (feet) of the wellbore in a vertical well or the measured length (feet) of the wellbore from the kickoff point to the bottom hole, or total depth, of the wellbore
Elevation, ftelevation_ftnumberElevation (feet) above sea level at the surface location of the well
Original Well Typeoriginal_well_typetextWell type specified on permit application, includes well types codes: BR Brine; DS Disposal; GD Gas Development; GE Gas Extension; GW Gas Wildcat; IG Injection Gas; IW Enhanced Oil Recovery – Injection Well; LP Liquefied Petroleum Gas Storage; MB Monitoring Brine; MM Monitoring Miscellaneous; MS Monitoring Storage; NL Not Listed; OD Oil Development; OE Oil Extension; OW Oil Wildcat; SG Stratigraphic; ST Storage; TH Geothermal
Permit Feepermit_feenumberTotal dollar amount charged for a well permit, including a fee based on depth (ft.) of the wellbore and a mandatory $100 fee to be credited to the oil and gas account. Permit fees can be calculated at: http://www.dec.ny.gov/energy/1779.html
Objective Formationobjective_formationtextGeologic formation targeted for production as designated on the permit application
Depth Feedepth_feenumberDollar amount charged as part of the permit fee, based on depth (ft.) of the wellbore
SpacingspacingtextIndicates whether the spacing unit associated with the well conforms to statewide spacing under Title 5 of Article 23 of the Environmental Conservation Law, whether the unit is non-conforming, or whether the unit is exempt.
Spacing Acresspacing_acresnumberAcres comprising the spacing unit
IntegrationintegrationtextIntegration codes: NO - No integration order required; OI - Integration order issued; OP - Integration order pending; RE - Referred to Office of Hearings and Mediation Services
Hearing Datehearing_datecalendar_dateDate of integration hearing
Date Last Modifieddate_last_modifiedcalendar_dateDate record was last modified
DEC Database Linkdec_database_linkurlLink/connect to DEC’s searchable online database record for the individual well
Location 1location_1locationOpen Data/Socrata-generated geocoding information