Department of Environmental Conservation

D E C banner

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.

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:

Production File Metadata
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.

Summary Production Metadata
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.


  • Contact for this Page
  • Division of Mineral Resources
    NYSDEC
    625 Broadway
    Albany, NY
    12233-6500
    518-402-8056
    Send us an email
  • This Page Covers
  • Page applies to all NYS regions