KGS
KGS oil and gas well records download
Data fields description
FieldExplanation
ogIDUnique id number for the data row (useful for GIS - use 'record_number' for KGS identification of the well record).
record_numberUnique serial identifier for each well in the KGS database.
justified_permitPermit issued by the Kentucky Division of Oil and Gas. This is the KGS formatted version of the permit that eliminates dashes.
quadrangle_nameName of the USGS 7.5-minute, 1:24,000-scale quadrangle on which the well is located.
county_nameCounty in which the well is located.
original_resultAn indication of the manner in which the well was originally completed. An explanation of codes can be found at: completion info.
operatorWell operator of record when the well was originally drilled. This name matches the drilling records on file at the Kentucky Geological Survey. This name may not match the current operator as recorded for legal purposes in the Division of Oil and Gas database as wells are transfered to new operators. The most recent operator for a well (if the well operator changed during the well history) is recorded in the "most_recent_operator" field below.
well_numberWell number assigned by the original operator. This number matches the drilling records on file at the Kentucky Geological Survey. This number may change as wells are transferred to new operators.
farm_nameOriginal farm or lease name (usually mineral owner in the case of severed minerals) under which the well was drilled. This name matches the drilling records on file at the Kentucky Geological Survey and may not match the current farm name as recorded for legal purposes in the Division of Oil and Gas database.
tdfm_nameName of the formation penetrated at the total depth of the well. Formation codes are derived from the American Association of Petroleum Geologists stratigraphic code.
date_completedDate well was completed, if known
deeppay_sortCode to sort the deepest or only producing formation. Formation sorting codes are derived from the American Association of Petroleum Geologists stratigraphic code.
surface_elevationGround-level elevation of the well in feet above sea level.
measured_depthDepth of the well drilled plus the depth drilled for a horizontal well (the total depth / length drilled) in feet.
true_vertical_depthVertical depth of the well in feet.
date_permit_issuedDate well was permitted, if known.
original_well_classOriginal API well classification designated the following codes:
  • DEV: Development well
  • DPT: Deeper pool test
  • DPTD: Deeper pool test resulting in development of existing producing formation
  • EXT: Extension (outpost) well
  • MSC: Miscellaneous well
  • NFW: New field wildcat
  • NPW: New pool wildcat
  • SPT: Shallower pool test
  • SRV: Service well, EPA Class II injection
  • STR: Stratigraphic test with records released to the public
  • UNC: Unclassified
  • WSW: Water supply well (note, should be SRV with an Org_Result of WS)
tdfmThe KGS 'formation code' of the formation penetrated at the total depth of the well. Formation codes are derived from the American Association of Petroleum Geologists stratigraphic code.
deepest_payThe KGS 'formation code' of the deepest or only producing formation. Formation codes are derived from the American Association of Petroleum Geologists stratigraphic code.
deepest_pay_nameName of the deepest or only producing formation.
footage_drilledTotal number of feet a well has been drilled.
date_pluggedDate well was plugged and abandoned, if known.
date_spuddedDate that the original drilling of well commenced, if known.
original_result_symbolGeneral well result code for use in plotting the wells in a GIS. Note that the plot symbol codes supplied in this data set have been generalized from the results available in the main Oil and Gas Well Record Database. See the FAQ on result codes for more information.
  • D&A: Dry and abandoned wells (Abnd = -1 by default)
  • GAS: Wells completed as gas wells (including abandoned producers)
  • LOC: Newly permitted locations or historic wells for which completion data are not available in the KGS database
  • MSC: Miscellaneous well types, including cathodic protection, observation, water supply wells, and others
  • O&G: Wells completed as combined oil and gas producers (including abandoned producers)
  • OIL: Wells completed as oil (including abandoned producers)
  • SRV: Secondary recovery input, water injection, and other miscellaneous well types associated with secondary or enhanced oil recovery (EPA Class II wells)
  • STR: Stratigraphic tests released to the public (Abnd = -1 by default)
  • TRM: Locations for which a permit was issued but the permit was cancelled by the operator or allowed to expire. Wells with this designation are included to enable tracking the status of permits.
bore_typeA code indicating the geometry of the well bore:
  • V: Conventional vertical well bore (not intentionally deviated)
  • D: A deviated well bore (intentionally deviated, but does not reach horizontal)
  • H: A horizontal well bore potentially including multiple laterals and pinnate deviations from those laterals
API_NumberThe API-style well identification number for the well. Assigning API numbers is part of an ongoing project to match data between the Kentucky Geological Survey and Division of Oil and Gas databases. As the project proceeds, more API numbers will become available. Due to the nature of the matching process, some API numbers might change as wells are matched and location problems resolved.
most_recent_operatorThe most recent well operator for this well. If there is an entry in this field, the operator changed from the original operator (recorded in the "operator" field above) at some point during the history of the well.
BasinThe basin in which the well is located.
WellReport_urlLink to the web page well report for the record_number. This is the results page for the well.
Documents_urlLink to the pdf of well documents for the record_number, if available.
Elog_urlLink to the web page of Elog documents for the record_number, if available.
HorizontalSurvey_urlLink to the web page containing the horizontal survey for the record_number, if available.
Oil_ProductionData_urlLink to the web page containing oil production data for the record_number, if available.
Gas_ProductionData_urlLink to the web page containing gas production data for the record_number, if available.
CoreInfo_urlLink to the web page containing core information for the record_number, if available.
SampleInfo_urlLink to the web page containing well sample information for the record_number, if available.
TopsData_urlLink to the web page containing interpreted tops data for the record_number, if available.
PayData_urlLink to the web page containing pay data for the record_number, if available.
carter_coordinatesFull carter coordinate for the record_number. The format is (e.g. 24-S-83 150S, 1800W):
[1-minute Carter section number]-
[5-minute Carter section letter]-
[5-minute Carter section number]
[Feet from north or south bounding 1-minute Carter coordinate line][Designation of north (N) or south (S) bounding 1-minute carter section line],
[Feet from east or west bounding 1-minute Carter coordinate line][Designation of east (E) or west (W) bounding 1-minute carter section line].

Note that some well records may not contain the footage data or 1-minute Carter section number. More information about Carter Coordinates.
coordinate_system_nameName of the selected coordinate system for the x_coordinate and y_coordinate.
coordinate_EPSGThe European Petroleum Survey Group (EPSG) Spatial Reference System Identifier (SRID) for the selected coordinate system. This is a standard code describing the selected coordinate system and is useful for GIS and web mapping.
x_coordinateThe x coordinate (latitude or easting) in the selected coordinate system for the record_number, if available.
y_coordinateThe y coordinate (longitude or northing) in the selected coordinate system for the record_number, if available.