This dataset contains annual production information of oil and gas wells in New York State from 2001 to present.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| API Well Number | api_wellno | number | 14 digit API (American Petroleum Institute) unique identifying number | 31009665960000 31013126840000 31009088780000 31009096320000 31011155290000 view top 100 |
| County | cnty | text | County name | Chautauqua Cattaraugus Allegany Erie Genesee view top 100 |
| Company Name | coname | text | Company Name | Empire Energy E&P LLC U S Energy Development Corp. Stedman Energy, Inc. United States Gypsum Co. Minard Run Oil Co. view top 100 |
| API Hole Number | hole | text | 5-digit API hole number | 23104 20968 20917 30004 20902 view top 100 |
| Sidetrack Code | sidetrck | text | 2-digit sidetrack code. Sidetracks are directionally drilled wellbores that deviate from the initial wellbore. Commonly, sidetracks are horizontal but can be at any angle to the initial wellbore. Sidetracks may drilled to access formations that otherwise would not be reachable with conventional methods. They are commonly used to divert the main wellbore around broken tools in the hole, an unstable formation or loss zone, and when the well is being re-entered to drill a horizontal leg. | 00 0 01 1 02 view top 100 |
| Completion Code | completion | text | 2-digit completion code Completions in a well detail how the wellbore is to allow the oil or gas to enter the wellbore. Common examples of a completion are open-hole completions, perforations of the production casing, running in the production tubing, and any necessary stimulation of the wellbore. | 00 0 01 02 1 view top 100 |
| Well Type Code | well_typ | text | Well Type codes: BR Brine; Confidential Type Is Currently Listed As Confidential; DH Dry Hole; DS Disposal; DW Dry Wildcat; GD Gas Development; GE Gas Extension; GW Gas Wildcat; IG Gas Injection Well; IW Enhanced Oil Recovery - Injection; LP Liquefied Petroleum Gas Storage; MB Monitoring Brine; MM Monitoring Miscellaneous; MS Monitoring Storage; NL Not Listed; OB Observation Well; OD Oil Development; OE Oil Extension; OW Oil Wildcat; SG Stratigraphic; ST Storage; TH Geothermal; UN Unknown | GD OD IW GW GE view top 100 |
| Production Field | field | text | Name of production field. A field is designated by a wells that produce from the same formation within a geographically local area. Fields can be isolated areas or may overlap with other fields. For example, five wells within a few miles of each other all producing from Formation A may form their own field (Field 1). Five wells producing from formation B may be part of an overlapping field if the geographic location of the second group (Field 2) is overlapping with that of the first group (Field 1). | Lakeshore Richburg Bradford Chipmunk Beech Hill-Independence view top 100 |
| Well Status Code | wl_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 AWR; 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 | AC IN NR PA SI view top 100 |
| Well Name | well_nm | text | Name of the well | Fee 1 Smith 1 Clark 1 Fee 2 Miller 1 view top 100 |
| Town | town | text | Name of town | Allegany Bolivar Carrollton Busti Olean view top 100 |
| Producing Formation | prod_form | text | Name of geologic formation that the well is producing oil, gas, or brine from. | Medina Richburg Fulmer Valley Bradford Queenston view top 100 |
| Months in Production | production | number | Months in production | 12 0 11 6 10 view top 100 |
| Gas Produced, Mcf | gas | number | Amount of gas produced (Mcf) | 0 1 200 3 5 view top 100 |
| Water Produced, bbl | water | number | Amount of water produced (bbl) | 0 1 2 3 5 view top 100 |
| Oil Produced, bbl | oilprod | number | Amount of oil produced (bbl) | 0 1 2 5 3 view top 100 |
| Reporting Year | year | number | Reporting year | 2011 2012 2010 2008 2009 view top 100 |
| New Georeferenced Column | geocoded_column | location | view top 100 |