"KID","API_NUMBER","API_NUM_NODASH","LEASE","WELL","FIELD","LATITUDE","LONGITUDE","LONG_LAT_SOURCE","TOWNSHIP","TWN_DIR","RANGE","RANGE_DIR","SECTION","SPOT","FEET_NORTH","FEET_EAST","FOOT_REF","ORIG_OPERATOR","CURR_OPERATOR","ELEVATION","ELEV_REF","SURFACE_ELEVATION_LIDAR","DEPTH","FORMATION_AT_TOTAL_DEPTH","PRODUCE_FORM","IP_OIL","IP_GAS","IP_WATER","PERMIT","SPUD","COMPLETION","PLUGGING","MODIFIED","OIL_KID","OIL_DOR_ID","GAS_KID","GAS_DOR_ID","KCC_PERMIT","STATUS","STATUS2","COMMENTS","LEASE_WELL_NAME"
"1001199884","15-009-07372","15009073720000","A. HAMILTON","1","CLAFLIN","38.5065662","-98.5296944","Calc. from footages","18","S","11","W","10","C  NW NE NW","4950","-3630","SE","Imperial Drilling & Production Co.","unavailable","1799"," KB","1790.255","3350","","","","","","","04-DEC-1954","13-DEC-1954","01-APR-1960","09-FEB-2006","","","","","","OIL-P&A","","Spud & comp dates per driller's log-ALW 6/3/2002","A. HAMILTON 1"
"1001199890","15-009-06035","15009060350000","HAMILTON","3","CLAFLIN","38.5065796","-98.5273876","Calc. from footages","18","S","11","W","10","C  NE NE NW","4950","-2970","SE","Bennett & Roberts Drilling Co.","unavailable","1781"," KB","1779.3812","3887","","ARBUCKLE GROUP","","","","","07-JUN-1957","05-JUL-1957","01-APR-1960","03-JUN-2002","","","","","","SWD-P&A","Plugged and Abandoned","","HAMILTON 3"
"1001199848","15-009-73253","15009732530000","SIMMONS","1","CLAFLIN","38.5100903","-98.534276","Calc. from footages","18","S","11","W","3","C  NW SW SW","990","-4950","SE","PANDORA OIL CO","unavailable","1804"," KB","1796.9065","3375","","","","","","","15-FEB-1964","30-APR-1964","01-JAN-1964","07-JAN-2000","","","","","","D&A","Plugged and Abandoned","well number added per plugging match-SKS","SIMMONS 1"
"1006020761","15-009-06387","15009063870000","SIMMONS","1","CLAFLIN","38.5082792","-98.531986","Calc. from footages","18","S","11","W","3","  SE SW SW","330","-4290","SE","DERBY OIL CO.","unavailable","1801"," DF","1797.2018","3361","ARBUCKLE GROUP","","","","","","10-JUL-1947","13-AUG-1947","01-DEC-1947","30-NOV-2021","","","","","","D&A","Plugged and Abandoned","","SIMMONS 1"
"1002887026","15-009-20051","15009200510000","SCHLESSIGER","1","CLAFLIN","38.539044","-98.5408847","Calc. from footages","17","S","11","W","28","C  NE SW SE","990","-1650","SE","Alpine Oil & Royalty Co.","unavailable","1811"," KB","1808.0373","3330","ARBUCKLE GROUP","","","","","","01-MAY-1967","08-MAY-1967","31-MAY-1967","23-AUG-2005","","","","","","D&A","Plugged and Abandoned","The KCC changed the API from 30624. MCM 8-23-2005","SCHLESSIGER 1"
"1006020542","15-009-01622","15009016220000","EVENSON","1","CLAFLIN","38.5300457","-98.5432686","Calc. from footages","17","S","11","W","33","  SW SW NE","2970","-2310","SE","Raymond Oil Co., Inc.","unavailable","1783"," KB","1782.8227","3384","LANSING/KANSAS CITY","","","","","14-DEC-1962","14-DEC-1962","21-DEC-1962","28-OCT-1964","22-SEP-2003","","","","","","OIL-P&A","Plugged and Abandoned","","EVENSON 1"
"1006022101","15-009-20813","15009208130000","ROUTLEDGE","1","CLAFLIN","38.5264227","-98.5467682","Calc. from footages","17","S","11","W","33","C  S2 NE SW","1650","-3300","SE","STEPHENSON L G ETAL","Stephenson, L.G. & CO., Inc.","1782"," KB","1776.8188","3191","LANSING GROUP","","","","","21-MAY-1974","26-SEP-1974","03-OCT-1974","21-DEC-1974","05-DEC-2005","","","","","","D&A","Plugged and Abandoned","","ROUTLEDGE 1"
"1006020406","15-009-01494","15009014940000","Bortz","1","CLAFLIN","38.5354465","-98.5732947","Calc. from footages","17","S","11","W","31","C  NE NE NE","4950","-330","SE","John O. Farmer, Inc.","unavailable","1807"," KB","1803.3991","3404","ARBUCKLE GROUP","","","","","","19-OCT-1962","25-OCT-1962","31-OCT-1962","07-MAY-2003","","","","","","D&A","Plugged and Abandoned","","Bortz 1"
"1006018944","15-009-00503","15009005030000","SIMMONS","1","CLAFLIN","38.5082905","-98.518143","Calc. from footages","18","S","11","W","3","  SE SE SW","330","-330","SE","Francis M. Raymond","unavailable","1798"," KB","1788.7469","3362","ARBUCKLE GROUP","Lansing-Kansas City","","","","","09-OCT-1954","05-JAN-1955","01-APR-1958","05-DEC-2005","1024460941","","","","","OIL-P&A","Plugged and Abandoned","Discovery well for Claflin field.","SIMMONS 1"
"1006025097","15-009-22385","15009223850000","SHAW","1","CLAFLIN","38.5064663","-98.5318907","Calc. from footages","18","S","11","W","10","  NE NW NW","-330","990","NW","EVANS JOHN R","unavailable","1801"," KB","1794.2936","3354","ARBUCKLE GROUP","","","","","","30-MAY-1981","02-JUN-1981","30-JUN-1981","25-JUN-1997","","","","","","D&A","Plugged and Abandoned","","SHAW 1"
"1001199888","15-009-14798","15009147980000","HUNT","1","CLAFLIN","38.5065393","-98.5343082","Calc. from footages","18","S","11","W","10","C  NW NW NW","4950","-4950","SE","RAMSEY PETROLEUM CORP ET","unavailable","1801"," DF","1796.2469","3404","","ARBUCKLE GROUP","","","","","03-MAR-1936","30-MAY-1936","30-MAY-1936","26-MAR-2025","","","","","","D&A","Plugged and Abandoned","","HUNT 1"
"1006018721","15-009-00365","15009003650000","BIEBERLE","1","CLAFLIN","38.4956614","-98.5343471","Calc. from footages","18","S","11","W","10","  NW SW NE","990","330","SW","LAUCK D R OIL","unavailable","1803"," KB","1783.2996","3380","ARBUCKLE GROUP","","","","","","16-DEC-1951","02-JAN-1952","31-DEC-1951","05-DEC-2005","","","","","","D&A","Plugged and Abandoned","","BIEBERLE 1"
"1006018999","15-009-00533","15009005330000","HAMILTON","2","CLAFLIN","38.5046534","-98.5319157","Calc. from footages","18","S","11","W","10","  SE NW NW","-990","990","NW","BENNETT & ROBERTS","unavailable","1794"," KB","1784.1516","3324","ARBUCKLE GROUP","Arbuckle Group","","","","","04-JAN-1957","13-FEB-1957","01-NOV-1959","05-DEC-2005","","","","","","OIL-P&A","Plugged and Abandoned","Discovery well for Claflin field.","HAMILTON 2"
"1006025015","15-009-22340","15009223400000","BIEBERLE","1","CLAFLIN","38.5066065","-98.5227739","Calc. from footages","18","S","11","W","10","  NE NW NE","4950","-1650","SE","RUPE OIL","unavailable","1805"," KB","1791.8069","3351","PENNSYLVANIAN SYSTEM","","","","","","07-MAY-1981","14-MAY-1981","11-JUN-1991","05-DEC-2005","","","","","","D&A","Plugged and Abandoned","","BIEBERLE 1"
"1006022868","15-009-21209","15009212090000","Simmons","1","CLAFLIN","38.5100941","-98.5296617","Calc. from footages","18","S","11","W","3","  NW SE SW","990","-3630","SE","Miles Petroleum Co.","unavailable","1803"," KB","1796.7497","3336","ARBUCKLE GROUP","","","","","","17-AUG-1977","28-FEB-1978","21-NOV-1990","05-DEC-2005","1001114027","105905","","","","OIL-P&A","Well Drilled","","Simmons 1"
"1052103500","15-009-26326","15009263260000","SCHLESSIGER","3-1","CLAFLIN","38.5125438","-98.53021","Calc. from footages","18","S","11","W","3"," NW SW NE SW","1882","1461","SW","K & N Petroleum, Inc.","K & N Petroleum, Inc.","1809"," KB","1799.3796","3410","ARBUCKLE","ARBUCKLE","","","","23-NOV-2021","26-NOV-2021","01-DEC-2021","26-NOV-2021","04-APR-2022","","","","","","OIL-P&A","Plugged and Abandoned","","SCHLESSIGER 3-1"