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
| OPERATOR | Operator name |
| KGS_ID | ID code used by the Survey to keep track of operators |
| DOR_ID | ID code assigned by the Kansas Dept. of Revenue |
| KCC_ID | ID code assigned by the Kansas Corporation Commission |
| 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 assigned to this operator |
| GAS_PRODUCTION | Production of gas for the time interval shown; in MCF (1000 cubic feet) |
| GAS_WELLS | Number of wells assigned to this operator |
Kansas Geological Survey
Comments to webadmin@kgs.ku.edu
URL=http://www.kgs.ku.edu/Magellan/Field/operators.html
Programs Updated July 12, 2016
Production data from Kansas Dept. of Revenue files monthly.
Company data from Kansas Dept. of Revenue and Corporation Commission files.
