Downloadable Oil & Gas Production Data
The data file for information pertaining to annual oil and gas production is released on or about July 1st each year following the legislatively mandated six month period of confidentiality. The Division offers production data via the searchable online database with production histories from 1985 forward and in zipped comma-separated values files from 2000 forward. Summary production data from 1985 to 1999 are maintained by Open Data New York. A separate summary production data file for 1967 to 1999 is available below.
Searchable Online Database
The searchable oil and gas online database offers users the ability to tailor information searches. In 2008, the production search capabilities were expanded to include production data from 1985 forward for gas wells and higher volume oil wells. After 2000, all oil and gas production wells are reported through the Annual Well Report. Extensive help on this application is available for your use by clicking the General Search Tips/Help link on the Home Page of the searchable database.
Yearly Oil and Gas Production Files (zipped format)
Click on a year to download the available production data file(s) for that year.
- 2000 zip file - 496 kB Revised 07/05/2023
- 2001 zip file - 426 kB Revised 07/05/2023
- 2002 zip file - 406 kB Revised 07/05/2023
- 2003 zip file - 430 kB Revised 07/05/2023
- 2004 zip file - 414 kB Revised 07/05/2023
- 2005 zip file - 402 kB Revised 07/05/2023
- 2006 zip file - 422 kB Revised 07/05/2023
- 2007 zip file - 434 kB Revised 07/05/2023
- 2008 zip file - 455 kB Revised 07/05/2023
- 2009 zip file - 452 kB Revised 07/05/2023
- 2010 zip file - 461 kB Revised 07/05/2023
- 2011 zip file - 465 kB Revised 07/05/2023
- 2012 zip file - 460 kB Revised 07/05/2023
- 2013 zip file - 456 kB Revised 07/05/2023
- 2014 zip file - 455 kB Revised 07/05/2023
- 2015 zip file - 449 kB Revised 07/05/2023
- 2016 zip file - 441 kB Revised 07/05/2023
- 2017 zip file - 439 kB Revised 07/05/2023
- 2018 zip file - 440 kB Revised 07/05/2023
- 2019 zip file - 444 kB Revised 07/05/2023
- 2020 zip file - 434 kB Revised 07/05/2023
- 2021 zip file - 431 kB Revised 07/05/2023
- 2022 zip file - 427 kB Posted 07/05/2023
Data was entered by Division staff or received in an electronic format. All oil and gas wells reported by a company are included in the file. Each row in the dataset is an individual well; wells are sorted by operator, then county, town, field, and formation. Files are in .csv format with the following fields:
Field Name | Explanation |
---|---|
API_WELLNO | 14-Digit API well number |
CNTY | Name of the county where the well is located |
CONAME | Name of the company operating the well |
HOLE | 5-Digit number identifying the wellbore |
SIDETRCK | 2-Digit sidetrack identifying code |
COMPLETION | 2-Digit completion identifying code |
WELL_TYP | Type of well |
FIELD | Name of the oil or gas field that the well produces from |
WL_STATUS | Status of the well during the production year |
WELL_NM | Name of the well |
TOWN | Town where the is located |
PROD_FORM | Formation from which the well produces oil or gas |
PRODUCTION | Months that the well was in production for reporting year |
GAS | Gas (Mcf) produced from the well during the production year |
WATER | Water (bbl) produced from the well during the production year |
OILPROD | Oil (bbl) produced from the well during the production year |
YEAR | Production year being reported |
Summary Production Data
The Division first collected oil and gas production data in 1967. This data is grouped by Company Name, County, Town, Field, Formation, Lease and Production Volumes. These data were summarized for various reports. The Division digitized this summary data and offers it in a zipped .dbf file format. The summary production history file (Revised 9/10/2009 zip file 517 KB) contains production records between 1967 and 1999. In 2000, the summary system was abandoned in favor of having all operators report annual oil and gas production values for each well individually.
Field Name | Explanation |
---|---|
PYEAR | Production Year |
PDATE | Date that production data was entered |
PORGNO | Operator number |
PCTY | County code |
PTOWN | Town name |
PFLD | Field name |
PFORM | Producing formation name |
OILA | Number of oil wells active |
OILI | Number of oil wells inactive |
GASA | Number of gas wells active |
GASI | Number of gas wells inactive |
INJECT | Number of injection wells |
DISPOSAL | Number of disposal wells |
SELF | Designation if wells are for self use |
OIL | Oil volume produced (bbl) |
GAS | Gas volume produced (Mcf) |
WATER | Water volume produced (bbl) |
PBRCODES | Buyer code |
PCOMM | Comments |
TGAS | Taxable gas |
PBUYG | Gas buyer code |
PBUYO | Oil buyer code |
PBUYGORG | Gas buyer organization number |
PBUYOORG | Oil buyer organization number |
PMODIFY | Login of last modifier |
PREVDATE | Revision Date |
This summary data was entered for the Division's use and has not been verified for quality control purposes.