"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"
"1001296852","15-167-06209","15167062090000","FUNK","1","WALDO","38.9881229","-98.8152863","Calc. from footages","12","S","13","W","19","C  SW SW SW","330","-4950","SE","GARFIELD & BUELL","unavailable","1577"," KB","1573.576","3220","","","","","","","21-FEB-1935","07-APR-1935","22-APR-1935","19-JUN-2009","","","","","","D&A","Plugged and Abandoned","","FUNK 1"
"1001299135","15-167-06203","15167062030000","MCALLISTER","1","Waldo","39.022851","-98.7619827","Calc. from footages","12","S","13","W","9","  NE NE SE","2310","-330","SE","AYLWARD PRODUCTION CO.","unavailable","1770"," KB","1758.3915","3568","","","","","","","30-AUG-1936","02-NOV-1936","10-NOV-1936","01-AUG-2022","","","","","","D&A","Plugged and Abandoned","","MCALLISTER 1"
"1001302513","15-167-06204","15167062040000","BEATTY","1","WALDO","39.0173674","-98.7758962","Calc. from footages","12","S","13","W","9","  SE SW SW","330","-4290","SE","PHIL-HAN OIL CO.","unavailable","1727"," KB","1721.1471","3511","","","","","","","25-OCT-1943","08-DEC-1943","08-DEC-1943","18-JUN-2009","","","","","","D&A","Plugged and Abandoned","","BEATTY 1"
"1002943416","15-167-00439","15167004390000","Wenger","1","WALDO","38.9736413","-98.7957164","Calc. from footages","12","S","13","W","29","  SE SW SW","330","660","SW","Brack Oil Company, Incorporated","unavailable","1550"," DF","1547.1104","3257","ARBUCKLE GROUP","","","","","","28-FEB-1948","01-APR-1948","31-MAR-1948","22-JUN-2009","","","","","","D&A","Plugged and Abandoned","some records marked S2 SW SW - SKS 8/17/2000; e-log marked C S/2 S/2 SW - DN 10/4/2000; Drillers Log lists quarter calls as C S2 S2 SW. (DRL 11/2006)","Wenger 1"
"1002943292","15-167-00320","15167003200000","ROGG FARMS","1","WALDO","38.9973991","-98.7344051","Calc. from footages","12","S","13","W","23","  NE SE NW","3630","-2970","SE","BUMP OIL","unavailable","1593"," KB","1588.5772","3410","ARBUCKLE GROUP","","","","","","12-SEP-1956","23-SEP-1956","23-SEP-1959","31-AUG-2016","","","","","","D&A","Recompleted","Lease listed as Rogg and total depth as 3410 on Driller's Log. (DRL 11/2006)","ROGG FARMS 1"
"1006138065","15-167-22731","15167227310000","L. C. Trapp 'A'","2","WALDO","39.0230319","-98.790024","Calc. from footages","12","S","13","W","8","  NE NE SW","2310","-2970","SE","Rains and Williamson Oil Co., Inc.","unavailable","1724"," KB","1718.398","3220","PENNSYLVANIAN SYSTEM","","","","","","19-FEB-1986","24-FEB-1986","28-FEB-1986","21-DEC-2011","","","","","","D&A","Plugged and Abandoned","","L. C. Trapp 'A' 2"
"1006136319","15-167-21795","15167217950000","TOBIAS","1","WALDO","38.9953083","-98.7324343","Calc. from footages","12","S","13","W","23"," SW SW SW NE","2870","-2410","SE","RAINS & WILLIAMSON OIL CO","unavailable","1574"," KB","1565.8206","3042","PENNSYLVANIAN SYSTEM","","","","","","14-OCT-1981","21-OCT-1981","31-OCT-1981","17-AUG-2000","","","","","","D&A","Plugged and Abandoned","","TOBIAS 1"
"1006138133","15-167-22769","15167227690000","L. C. Trapp 'A'","3","WALDO","39.0286495","-98.7986406","Calc. from footages","12","S","13","W","7"," E2 SE NE NE","4290","-170","SE","Rains and Williamson Oil Co., Inc.","Rains & Williamson Oil Co., Inc.","1714"," KB","1708.2725","2975","PENNSYLVANIAN SYSTEM","","","","","20-FEB-1987","23-FEB-1987","27-FEB-1987","27-FEB-1987","21-DEC-2011","","","","","","D&A","Plugged and Abandoned","","L. C. Trapp 'A' 3"
"1006135514","15-167-21365","15167213650000","TOBIAS","1","WALDO","38.9755457","-98.7481483","Calc. from footages","12","S","13","W","27","  NE SW SE","990","-1650","SE","CRUDE PRODUCERS, INC.","unavailable","1597"," KB","1565.9717","3433","ARBUCKLE GROUP","","","","","11-OCT-1979","07-OCT-1979","15-OCT-1979","15-OCT-1979","19-JUN-2009","","","","","","D&A","Plugged and Abandoned","","TOBIAS 1"
"1006138597","15-167-23014","15167230140000","SPLAWN","2","Waldo","38.9914965","-98.7360248","Calc. from footages","12","S","13","W","23","  SW NE SW","1480","1800","SW","Brungardt Oil and Leasing Co.","Brungardt Oil and Leasing Inc.","1581"," KB","1575.1939","3085","KANSAS CITY GROUP","","","","","24-FEB-1992","14-APR-1992","02-MAY-1992","","25-JAN-2022","","","","","","D&A","Recompleted","e-log marked 1800' FWL - DN 10/4/2000","SPLAWN 2"
"1006135983","15-167-21616","15167216160000","ROGG","2","WALDO","38.995598","-98.7413732","Calc. from footages","12","S","13","W","23","  SW SW NW","2970","-4950","SE","RAINS & WILLIAMSON OIL CO","unavailable","1674"," KB","1666.4501","3143","PENNSYLVANIAN SYSTEM","","","","","","06-JAN-1981","13-JAN-1981","31-JAN-1981","19-MAR-2015","","","","","","D&A","Plugged and Abandoned","","ROGG 2"
"1006135413","15-167-21310","15167213100000","ROGG FARMS","1","WALDO","38.9955902","-98.7367278","Calc. from footages","12","S","13","W","23","  SW SE NW","2970","-3630","SE","RAINS & WILLIAMSON OIL CO","Brungardt Oil and Leasing Inc.","1631"," KB","1623.706","3415","MISSISSIPPIAN","Lansing - Kansas City","","","","","22-JUN-1979","29-JUN-1979","","16-OCT-2015","1001126032","112803","","","","OIL","Producing","Discovery well for Waldo field. GL changed from 1610 per C-10. Spud date and completion date listed as 06/22/1979 and 06/29/1979 respectively. (DRL 11/2006)","ROGG FARMS 1"
"1006138526","15-167-22977","15167229770000","SPLAWN","1","WALDO","38.9937776","-98.7368686","Calc. from footages","12","S","13","W","23","  NW NE SW","2310","-3670","SE","Brungardt Oil & Leasing","Brungardt Oil and Leasing Inc.","1620"," KB","1612.3351","3101","PENNSYLVANIAN SYSTEM","Lansing Kansas City","30","","10","03-JUN-1991","08-JUL-1991","04-AUG-1991","","16-OCT-2015","1001141238","131052","","","","OIL","Producing","Completion date listed as 07-15-1991 per Drillers Log. (DRL 11/2006)","SPLAWN 1"
"1030615531","15-167-23253","15167232530000","ROGG FARMS","3","WALDO","38.9996991","-98.7411365","Calc. from footages","12","S","13","W","23","  SW NW NW","-830","350","NW","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1653"," KB","1648.9539","3442","ARBUCKLE, KANSAS CITY","ARBUCKLE","50","0","0","25-MAR-2004","27-APR-2004","01-JUN-2004","","13-DEC-2007","1001126032","112803","","","","OIL","Producing","","ROGG FARMS 3"
"1030624652","15-167-23014-0001","15167230140001","SPLAWN","2","WALDO","38.9914965","-98.7360248","Calc. from footages","12","S","13","W","23","  SW NE SW","1480","1800","SW","Brungardt Oil and Leasing Co.","Brungardt Oil and Leasing Inc.","1581"," KB","1575.1939","3085","","Lansing Kansas City","","","","","29-AUG-1994","30-AUG-1994","","20-NOV-2008","","","","","","OIL","Converted to EOR Well","","SPLAWN 2"
"1001298169","15-167-06208","15167062080000","BEATTY","1","WALDO","39.010102","-98.7666431","Calc. from footages","12","S","13","W","16","  SE SW NE","2970","-1650","SE","PRAIRIE OIL & GAS CO.","unavailable","1764"," DF","1747.5028","3504","","","","","","","23-JUN-1924","16-OCT-1924","01-AUG-1963","14-DEC-2006","","","","","","D&A","Plugged and Abandoned","1 SAMPLE (CUTTINGS WELL_ID=42916)","BEATTY 1"
"1002943501","15-167-00521","15167005210000","Walter Wilson","1","Waldo","39.0074125","-98.7538854","Calc. from footages","12","S","13","W","15","  NE NE SW","1980","1980","SW","Carter Oil Co.","unavailable","1662"," DF","1655.8911","3485","ARBUCKLE GROUP","","","","","","12-DEC-1944","11-JAN-1945","12-JAN-1945","05-MAY-2016","","","","","","D&A","Plugged and Abandoned","","Walter Wilson 1"
"1027706356","15-167-23175","15167231750000","ZWEIFEL","1","WALDO","39.0283881","-98.7773088","Calc. from footages","12","S","13","W","9","  S2 NW NW","4344","-4675","SE","STEINLE OIL COMPANY","Steinle Oil","1746"," KB","1747.4251","3592","ARBUCKLE","ARBUCKLE","","","","01-SEP-2000","29-SEP-2000","06-OCT-2000","06-OCT-2000","18-JUN-2009","","","","","","D&A","Plugged and Abandoned","","ZWEIFEL 1"
"1006135758","15-167-21495","15167214950000","FOWLER","1","WALDO","39.0083083","-98.7620099","Calc. from footages","12","S","13","W","16","  NE NE SE","2310","-330","SE","RAINS & WILLIAMSON OIL CO","unavailable","1731"," KB","1723.5036","3515","ARBUCKLE GROUP","","","","","","15-JUL-1980","25-JUL-1980","31-JUL-1980","14-DEC-2006","","","","","","D&A","Plugged and Abandoned","","FOWLER 1"
"1031536508","15-167-23264","15167232640000","Rogg 'B'","1","WALDO","39.0010766","-98.7435316","Calc. from footages","12","S","13","W","22","  NE NE NE","-330","-330","NE","Brungardt Oil & Leasing Inc.","Brungardt Oil and Leasing Inc.","1630"," KB","1631.6281","3457","ARBUCKLE","ARBUCKLE","50","","50","09-AUG-2004","23-AUG-2004","15-OCT-2004","","16-OCT-2015","1032046328","136633","","","","OIL","Producing","","Rogg 'B' 1"
"1034969828","15-167-23361","15167233610000","Berans Brothers","1","Waldo","39.0056172","-98.7527505","From GPS","12","S","13","W","15"," S2 SE NE SW","1330","2310","SW","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1601"," KB","1600.8112","3445","ARBUCKLE","Lansing-Kansas City","10","","90","02-JUN-2006","25-JUN-2006","02-AUG-2006","20-NOV-2020","01-AUG-2022","1036179576","137751","","","","OIL-P&A","Plugged and Abandoned","","Berans Brothers 1"
"1033661989","15-167-23309","15167233090000","Dockstader","1","WALDO","39.0045982","-98.740894","From GPS","12","S","13","W","14","  NW SW SW","984","-4916","SE","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1615"," KB","1612.288","3090","ARBUCKLE","ARBUCKLE","40","","5","21-SEP-2005","24-OCT-2005","03-JAN-2006","","16-OCT-2015","1034512157","137330","","","","OIL","Producing","","Dockstader 1"
"1033661991","15-167-23310","15167233100000","Small","1","WALDO","39.0028894","-98.7435289","Calc. from footages","12","S","13","W","15","  SE SE SE","330","-330","SE","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1643"," KB","1640.0103","3454","ARBUCKLE","ARBUCKLE","96","","10","21-SEP-2005","13-OCT-2005","02-JAN-2006","","16-OCT-2015","1034512156","137329","","","","OIL","Producing","","Small 1"
"1037343634","15-167-23469","15167234690000","ROGG B - SPLAWN POOL","1","Waldo","38.990985","-98.7427108","Calc. from footages","12","S","13","W","22","  NE SE SE","1290","-100","SE","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1637"," KB","1630.9363","3490","ARBUCKLE","ARBUCKLE","25","","25","19-OCT-2007","11-NOV-2007","04-JAN-2008","","07-JUN-2023","1032046328","136633","","","","OIL","Producing","","ROGG B - SPLAWN POOL 1"
"1038834348","15-167-23014-0002","15167230140002","SPLAWN","2","Waldo","38.9915569","-98.7360028","From GPS","12","S","13","W","23"," SE SW NE SW","1480","-3380","SE","Brungardt Oil and Leasing Co.","Brungardt Oil and Leasing Inc.","1569"," GL","1575.1397","2959","","","","","","","","01-SEP-1994","09-SEP-2019","25-JAN-2022","","","","","E26945.1","EOR-P&A","Plugged and Abandoned","","SPLAWN 2"
"1038697788","15-167-23541","15167235410000","Berens Brothers","2","WALDO","39.0119859","-98.7436677","Calc. from footages","12","S","13","W","15","  NE SE NE","-1750","-380","NE","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1696"," GL","1698.6791","","ARBUCKLE","ARBUCKLE","","","","07-OCT-2008","","","","02-DEC-2013","","","","","","LOC","Expired Intent to Drill (C-1)","","Berens Brothers 2"
"1042439596","15-167-23638","15167236380000","Berans Brothers","2","Waldo","39.0119859","-98.7436677","Calc. from footages","12","S","13","W","15"," SW NE SE NE","-1750","-380","NE","Brungardt Oil and Leasing Inc.","Farmer, John O., Inc.","1702"," KB","1698.6791","3511","ARBUCKLE","ARBUCKLE","80","","10","26-MAY-2010","13-AUG-2010","14-SEP-2010","","08-NOV-2024","1055861621","148674","","","","OIL","Producing","","Berans Brothers 2"
"1031536500","15-167-00320-0001","15167003200001","Rogg Farms","4","WALDO","38.9974485","-98.7343734","From GPS","12","S","13","W","23","  NE SE NW","3648","-3067","SE","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1592"," KB","1588.748","3576","ARBUCKLE","ARBUCKLE","","","","09-AUG-2004","16-SEP-2004","12-OCT-2004","","13-JUN-2024","","","","","D28424.0","SWD","Authorized Injection Well","Footages changed per ACO-1 from 3648 from South line and 3067 from East line. (DRL 11/2006)","Rogg Farms 4"
"1037343666","15-167-23468","15167234680000","SPLAWN","3","Waldo","38.993782","-98.7394762","Calc. from footages","12","S","13","W","23","  NE NW SW","2310","820","SW","Brungardt Oil and Leasing Inc.","Brungardt Oil and Leasing Inc.","1642"," KB","1638.6364","3456","ARBUCKLE","ARBUCKLE","10","","140","19-OCT-2007","02-NOV-2007","02-JAN-2008","","07-JUN-2023","1001141238","131052","","","","OIL","Producing","","SPLAWN 3"
"1043936598","15-167-23727","15167237270000","Dockstader","2","Waldo","39.0158974","-98.7400253","Calc. from footages","12","S","13","W","14"," E2 NW NW NW","-330","650","NW","Brungardt Oil and Leasing Inc.","Farmer, John O., Inc.","1644"," KB","1637.6643","3480","ARBUCKLE","ARBUCKLE","80","","","29-JUN-2011","13-SEP-2011","14-OCT-2011","","08-NOV-2024","1055861621","148674","","","","OIL","Producing","Drilling time and sample log assembled from pieces.","Dockstader 2"
"1044781708","15-167-23956","15167239560000","Berans Brothers","3","WALDO","39.0158774","-98.7441974","Calc. from footages","12","S","13","W","15"," W2 NE NE NE","-330","-535","NE","Brungardt Oil and Leasing Inc.","Farmer, John O., Inc.","1705"," KB","1699.8052","3187","ARBUCKLE","LANSING-KANSAS CITY","","","","04-MAR-2014","09-MAR-2014","31-MAR-2014","","13-FEB-2025","1055861621","148674","","","","OIL","Converted to EOR Well","","Berans Brothers 3"