KGS--Oil and Gas Leases--Monthly Data Saved to File

Directions: The link below contains the data you requested in a comma-delimited, ASCII file that should be readable by normal spreadsheet or database software. Files are deleted after 24 hours. Clicking on the link only opens a text file. Instead,

Right Click the link and select "Save Link As" or "Save Link to Disk" from the pop-up menu.
Save the file to your computer, keeping the extension as .txt
Open Excel or your Database
Select "Open File" and navigate to where you saved your file. Note - in Excel, to find your text (.txt) file, look to the right of the File-Name box for File-Type. Change the type from "All Excel Files" to "All" or "Text." Then you can select and open your file.
Using the Text Import Wizard:

choose "Delimited", then click on "Next."
choose by "Comma" - you’ll see the example data adjusted to columns, then click on "Next."
only if your data includes 2 separate columns for "Lease" & "Well,"" navigate to the "Well" column and change the format to Text; otherwise skip step 3.

Click on "Finish", and your file will open

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:

LEASE KID	Unique ID assigned by the Survey. Not necessarily permanent.
LEASE	Lease name.
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.
MONTH-YEAR	Month and Year for the production information. Yearly data is indicated by Month=0; starting cumulative value indicated by Month=-1.
PRODUCT	O = oil, G = gas (including coalbed methane).
WELLS	Number of wells contributing to the lease. Of limited quality.
PRODUCTION	Production of oil is in barrels; production of gas is 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 webadmin@kgs.ku.edu
URL=http://www.kgs.ku.edu/Magellan/Field/lease.html
Programs Updated May 27, 2014
Data from Kansas Dept. of Revenue files monthly.