Information on oil, gas, storage, solution salt, stratigraphic, and geothermal wells in New York State
This dataset has the following 51 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| API Well Number | api_well_number | number | Unique 14-digit well identification number designed by the American Petroleum Institute (API) and referred to as the API number | 31003256110000 31009220670000 31121037420000 31009701120000 31009629380000 view top 100 |
| County Code | county_code | number | Three-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.) | 3 9 13 29 101 view top 100 |
| API Hole Number | api_hole_number | number | Five-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.) | 30000 60000 30001 30003 30002 view top 100 |
| Sidetrack | sidetrack | number | Two-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.) | 0 1 2 3 4 view top 100 |
| Completion | completion | number | Two-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.) | 0 1 2 3 4 view top 100 |
| Well Name | well_name | text | Name of the well as designated on the permit application; typically the well name is based on the lease or unit name. | Voided Permit Fee 1 Fee 2 Smith 1 Unnamed view top 100 |
| Company Name | company_name | text | Well owner/operator | Bradley Producing Corp. Empire Energy E & P LLC PPP Future Development Inc. Pennzoil Products Co. Quaker State Corp. view top 100 |
| Operator Number | operator_number | number | Unique ID number assigned to each well owner/operator | 9998 101 2544 2740 29 view top 100 |
| Well Type | well_type | text | Well 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 | OD GD NL IW DW view top 100 |
| Map Symbol | map_symbol | text | Denotes 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. | OWP GW O OW OP view top 100 |
| Well Status | well_status | text | Well 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 | PA AC UL IN UM view top 100 |
| Status Date | status_date | calendar_date | Date current well status was assigned | 2009-12-31T00:00:00.000 2017-08-23T13:35:22.000 1991-12-31T00:00:00.000 1968-08-05T00:00:00.000 1982-02-25T00:00:00.000 view top 100 |
| Permit Application Date | permit_application_date | calendar_date | Date permit application was received | 1981-08-25T00:00:00.000 2008-03-17T00:00:00.000 1981-08-24T00:00:00.000 1975-12-16T00:00:00.000 1975-12-19T00:00:00.000 view top 100 |
| Permit Issued Date | permit_issued_date | calendar_date | Date permit was issued/approved | 1981-08-25T00:00:00.000 1975-12-29T00:00:00.000 1979-05-30T00:00:00.000 2006-08-04T00:00:00.000 2009-03-06T00:00:00.000 view top 100 |
| Date Spudded | date_spudded | calendar_date | Date drilling began | 1900-01-01T00:00:00.000 1940-01-01T00:00:00.000 1897-01-01T00:00:00.000 1890-01-01T00:00:00.000 1889-01-01T00:00:00.000 view top 100 |
| Date of Total Depth | date_of_total_depth | calendar_date | Date wellbore was drilled to its endpoint, or total depth | 1940-01-01T00:00:00.000 1976-09-30T00:00:00.000 1983-10-13T00:00:00.000 1982-05-20T00:00:00.000 1976-09-10T00:00:00.000 view top 100 |
| Date Well Completed | date_well_completed | calendar_date | Date 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 | 1940-01-01T00:00:00.000 1900-01-01T00:00:00.000 1935-01-01T00:00:00.000 1920-01-01T00:00:00.000 1943-01-01T00:00:00.000 view top 100 |
| Date Well Plugged | date_well_plugged | calendar_date | Date of completed plugging operations whereby the well was closed permanently with cement plugs | 1968-08-05T00:00:00.000 1968-09-24T00:00:00.000 1968-10-04T00:00:00.000 1968-10-21T00:00:00.000 1968-10-01T00:00:00.000 view top 100 |
| Date Well Confidentiality Ends | date_well_confidentiality_ends | calendar_date | Date confidential status ends/ended | 1990-07-24T00:00:00.000 1986-03-05T00:00:00.000 1985-07-03T00:00:00.000 1986-02-01T00:00:00.000 1988-09-08T00:00:00.000 view top 100 |
| Confidentiality Code | confidentiality_code | text | Confidential 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 | Pre-1989 Well (N/A) Released Application Received or Permit Issued Initial 6-month Period view top 100 |
| Town | town | text | Town where the surface location of the well resides | Allegany Bolivar Alma Carrollton Olean view top 100 |
| Quad | quad | text | United States Geological Survey 7.5-minute quadrangle/topographic map of the location where the well resides | Knapp Creek Allentown Bolivar Olean Whitesville view top 100 |
| Quad Section | quad_section | text | Letter designation (A-I) of the specific section of the United States Geological Survey quadrangle map where the surface location of the well resides | G E I D H view top 100 |
| Producing Field | producing_field | text | Name of the producing field or geographically local area underlain by an accumulation, pool or group of pools of oil/gas | Richburg Lakeshore Bradford Chipmunk Beech Hill-Independence view top 100 |
| Producing Formation | producing_formation | text | Name of the geologic formation from which the well is producing oil, gas, or brine | Medina Richburg Chipmunk Bradford Fulmer Valley view top 100 |
| Financial Security | financial_security | text | Financial 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. | False True view top 100 |
| Slant | slant | text | Orientation of wellbore (Vertical/Horizontal/Directional) | Vertical Horizontal Directional view top 100 |
| County | county | text | County where the surface of the well is located | Allegany Cattaraugus Chautauqua Erie Steuben view top 100 |
| Region | region | number | New 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. | 9 8 7 2 6 view top 100 |
| State Lease | state_lease | text | State 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. | NA ST UD SP UT view top 100 |
| Proposed Depth, ft | proposed_depth_ft | number | Depth (feet) specified on permit application | 0 1500 2000 4000 1200 view top 100 |
| Surface Longitude | surface_longitude | number | Longitude (decimal degrees) of surface location of the well | -78.587320000000005 -78.586770000000001 -78.574740000000006 -78.573300000000003 -77.974279999999993 view top 100 |
| Surface Latitude | surface_latitude | number | Latitude (decimal degrees) of surface location of the well | 42.006799999999998 42.030250000000002 42.02908 42.027979999999999 42.00488 view top 100 |
| Bottom Hole Longitude | bottom_hole_longitude | number | Longitude (decimal degrees) of bottom hole, or lowest/deepest location of the wellbore | -78.587320000000005 -78.586770000000001 -78.574740000000006 -77.974279999999993 -78.573300000000003 view top 100 |
| Bottom Hole Latitude | bottom_hole_latitude | number | Latitude (decimal degrees) of bottom hole, or lowest/deepest location of the wellbore | 42.006799999999998 42.030250000000002 42.02908 42.027979999999999 42.00488 view top 100 |
| True Vertical Depth, ft | true_vertical_depth_ft | number | Total vertical distance (feet) between the bottom hole, or lowest/deepest location of the wellbore and the surface | 0 1000 1300 1200 1400 view top 100 |
| Measured Depth, ft | measured_depth_ft | number | Total measured length (feet) of the wellbore | 0 1000 1200 1300 1500 view top 100 |
| Kickoff, ft | kickoff_ft | number | Depth (feet) in a vertical wellbore at which a deviated or slanted wellbore is started to allow for directional drilling | 0 675 2400 1400 2300 view top 100 |
| Drilled Depth, ft | drilled_depth_ft | number | Total 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 | 0 1000 1200 1300 1500 view top 100 |
| Elevation, ft | elevation_ft | number | Elevation (feet) above sea level at the surface location of the well | 2050 2200 2100 1600 2180 view top 100 |
| Original Well Type | original_well_type | text | Well 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 | NL OD GD GW BR view top 100 |
| Permit Fee | permit_fee | number | Total 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 | 0 860 20 475 600 view top 100 |
| Objective Formation | objective_formation | text | Geologic formation targeted for production as designated on the permit application | Medina Bradford Richburg Upper Devonian Fulmer Valley view top 100 |
| Depth Fee | depth_fee | number | Dollar amount charged as part of the permit fee, based on depth (ft.) of the wellbore | 0 760 375 500 1000 view top 100 |
| Spacing | spacing | text | Indicates 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. | Exempt from Title 5; complies with 6 NYCRR 553.1(a) Conforms to statewide spacing under Title 5 Exempt - not an oil or gas well Exempt from Title 5; variance needed from 6 NYCRR 533.1(a) Non-statutory unit under Title 5; review in progress view top 100 |
| Spacing Acres | spacing_acres | number | Acres comprising the spacing unit | 40 5 220 196 160 view top 100 |
| Integration | integration | text | Integration codes: NO - No integration order required; OI - Integration order issued; OP - Integration order pending; RE - Referred to Office of Hearings and Mediation Services | No integration order required Integration order issued Integration order pending Referred to Office of Hearings and Mediation Services view top 100 |
| Hearing Date | hearing_date | calendar_date | Date of integration hearing | 2006-06-27T00:00:00.000 2007-09-25T00:00:00.000 2009-06-03T00:00:00.000 2007-11-28T00:00:00.000 2009-11-18T00:00:00.000 view top 100 |
| Date Last Modified | date_last_modified | calendar_date | Date record was last modified | 2022-12-16T09:57:23.000 2022-12-16T09:57:26.000 2022-12-16T09:57:25.000 2023-08-15T13:50:08.000 2023-08-15T13:50:07.000 view top 100 |
| DEC Database Link | dec_database_link | url | Link/connect to DEC’s searchable online database record for the individual well | view top 100 |
| Location 1 | location_1 | location | Open Data/Socrata-generated geocoding information | view top 100 |