The link below contains the data you requested in a comma-delimited, ASCII file that should be readable by normal spreadsheet or database software.
Hold your right mouse button down when you click on the link and select "Save Link to Disk" from the pop-up menu or the data file will be displayed as a web page. On Macintosh computers, hold your mouse button down and a pop-up menu should appear.
The file includes an ID code used by the Kansas Geological Survey called the LEASE_KID.
We are saving the Kansas Dept. of Revenue code as column 3.
Finally, we have included the "Month" values for saving monthly data.
Yearly data is indicated by Month=0; Starting cumulative value indicated by Month=-1.
API number is listed if we have tied the production data to our well data.
This is an example of the file layout, not intended to represent the data you requested:
Below is a description of the columns saved.
|LEASE KID||Unique ID assigned by the Survey. Not necessarily permanent.|
|DOR_CODE||ID code assigned by the Kansas Department of Revenue.|
|API_NUMBER||If the Kansas Geological Survey has made a link between one or more wells and the production data shown, then the API number(s) will be listed here.|
|FIELD||Oil and gas field name that this production is assigned to.|
|PRODUCING_ZONE||Producing formation. May be assigned from the field name or information that is associated with the well.|
|OPERATOR||Operator of the lease. Updated by the Dept. of Revenue.|
|COUNTY||County where lease is located.|
|TOWNSHIP||Public Land Survey System township number, 1-35 in Kansas.|
|TWN_DIR||Township direction. S (south) or N (north), Always south in Kansas|
|RANGE||Public Land Survey System range number, 1-43 in west and 1-25 in east.|
|RANGE_DIR||Range direction. E (east) or W (west).|
|SECTION||The PLSS section the site is located in: 1-36|
|SPOT||The legal quarter description qualifiers list as NE, NW, SE, and SW, etc. May be pulled from well data or DOR information; of limited quality|
|LATITUDE||NAD 1927, generated from the legal location.|
|LONGITUDE||The latitude and longitude for production data is generally not as well defined as the location created for well data.|
|YEAR||Year for the production information.|
|MONTH||Month for the production information. Yearly data is indicated by Month=0; starting cumulative value indicated by Month=-1.|
|OIL_PRODUCTION||Production of oil in barrels for the time interval shown; .|
|OIL_WELLS||Number of wells contributing to the lease. Of limited quality.|
|OIL_CUMULATIVE||Cumulative production of oil in barrels.|
|GAS_PRODUCTION||Production of gas for the time interval shown; in MCF (1000 cubic feet).|
|GAS_WELLS||Number of wells contributing to the lease. Of limited quality.|
|GAS_CUMULATIVE||Cumulative production of gas in MCF (1000 cubic feet).|
|URL||Some versions of the file include a URL to the main Lease Production web page.|
Pre-1987 cumulative data and monthly volume data is provided under license agreement to the KGS by IHS Energy. As such, it may be reviewed and used for public service and research purposes. It may not be downloaded or used for purposes of re-packaging, reselling or dissemination to third parties.
Kansas Geological Survey
Comments to firstname.lastname@example.org
Programs Updated May 27, 2014
Data from Kansas Dept. of Revenue files monthly.