{ "metadata": { "name": "", "signature": "sha256:61c1bfc1c618f8ac38a7cfa5409866100885b295a81ebcad57d4fb52aeec623e" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "\n", "df = pd.read_csv(\"/users/ryankelly/downloads/Mines.txt\", sep=\"|\")\n", "addr = pd.read_csv('/users/ryankelly/projects/ultura/AddressOfRecord.txt', sep=\"|\")\n", "\n", "df.join(addr, on='MINE_ID',rsuffix=\"joined\")\n" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | MINE_ID | \n", "CURRENT_MINE_NAME | \n", "COAL_METAL_IND | \n", "CURRENT_MINE_TYPE | \n", "CURRENT_MINE_STATUS | \n", "CURRENT_STATUS_DT | \n", "CURRENT_CONTROLLER_ID | \n", "CURRENT_CONTROLLER_NAME | \n", "CURRENT_OPERATOR_ID | \n", "CURRENT_OPERATOR_NAME | \n", "STATE | \n", "BOM_STATE_CD | \n", "FIPS_CNTY_CD | \n", "FIPS_CNTY_NM | \n", "CONG_DIST_CD | \n", "COMPANY_TYPE | \n", "CURRENT_CONTROLLER_BEGIN_DT | \n", "DISTRICT | \n", "OFFICE_CD | \n", "OFFICE_NAME | \n", "\n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "100003 | \n", "O'Neal Quarry & Mill | \n", "M | \n", "Surface | \n", "Active | \n", "01/22/1979 | \n", "0041044 | \n", "Lhoist Group | \n", "L13586 | \n", "Lhoist North America | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Other | \n", "07/01/1989 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
1 | \n", "100004 | \n", "Brierfield Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "03/04/2003 | \n", "0041044 | \n", "Lhoist Group | \n", "L13586 | \n", "Lhoist North America of Alabama, LLC | \n", "AL | \n", "1 | \n", "7 | \n", "Bibb | \n", "3 | \n", "Other | \n", "06/14/2000 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
2 | \n", "100005 | \n", "Birmingham Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "08/15/1989 | \n", "0041044 | \n", "Lhoist Group | \n", "L10998 | \n", "Allied Lime Company | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Other | \n", "07/31/1989 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
3 | \n", "100006 | \n", "Auburn Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "09/24/1976 | \n", "M00174 | \n", "Martin Marietta Materials Inc | \n", "L16197 | \n", "Martin Marietta Materials, Inc. | \n", "AL | \n", "1 | \n", "81 | \n", "Lee | \n", "3 | \n", "Corporation | \n", "01/17/2002 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
4 | \n", "100008 | \n", "Landmark Plant | \n", "M | \n", "Surface | \n", "Active | \n", "11/14/1975 | \n", "M31753 | \n", "Alan B Cheney | \n", "L31753 | \n", "Cheney Lime & Cement Company | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
5 | \n", "100009 | \n", "Dolcito Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "07/04/1976 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Construction Materials, L.P. | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Partnership | \n", "04/21/1989 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
6 | \n", "100010 | \n", "Rockwood Mine | \n", "M | \n", "Underground | \n", "Active | \n", "10/01/1994 | \n", "M01727 | \n", "Vetter Stone Company | \n", "L16123 | \n", "Alabama Stone Company | \n", "AL | \n", "1 | \n", "59 | \n", "Franklin | \n", "4 | \n", "Corporation | \n", "07/01/1998 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
7 | \n", "100011 | \n", "Imerys Sylacauga Operations | \n", "M | \n", "Surface | \n", "Active | \n", "11/14/1975 | \n", "M11763 | \n", "Imerys S A | \n", "0090005 | \n", "Imerys Carbonates LLC | \n", "AL | \n", "1 | \n", "121 | \n", "Talladega | \n", "3 | \n", "Other | \n", "02/12/2008 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
8 | \n", "100012 | \n", "Ohatchee Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "12/13/2011 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Constr. Materials, L.P. | \n", "AL | \n", "1 | \n", "15 | \n", "Calhoun | \n", "3 | \n", "Partnership | \n", "01/01/1986 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
9 | \n", "100013 | \n", "C A Langford Co Inc | \n", "M | \n", "Surface | \n", "Active | \n", "11/14/1975 | \n", "M31370 | \n", "Charles A Langford; William S Langford | \n", "L31370 | \n", "C A Langford Company Inc | \n", "AL | \n", "1 | \n", "95 | \n", "Marshall | \n", "4 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
10 | \n", "100015 | \n", "Citadel Cement | \n", "M | \n", "Facility | \n", "Abandoned | \n", "10/01/1995 | \n", "M00187 | \n", "Medusa Corp | \n", "L13248 | \n", "Medusa Corp | \n", "AL | \n", "1 | \n", "63 | \n", "Greene | \n", "7 | \n", "Corporation | \n", "06/29/1993 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
11 | \n", "100016 | \n", "Demopolis Plant Cemex Inc | \n", "M | \n", "Facility | \n", "Active | \n", "04/12/1976 | \n", "M09149 | \n", "Cemex S A | \n", "L18165 | \n", "Cemex Inc | \n", "AL | \n", "1 | \n", "91 | \n", "Marengo | \n", "7 | \n", "Corporation | \n", "08/27/2001 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
12 | \n", "100017 | \n", "ST. STEPHENS QUARRY | \n", "M | \n", "Surface | \n", "Abandoned | \n", "09/20/1999 | \n", "M08390 | \n", "Bailey Jack A Sr | \n", "L10825 | \n", "Bailey'S Construction Company Inc | \n", "AL | \n", "1 | \n", "129 | \n", "Washington | \n", "1 | \n", "Other | \n", "12/16/1991 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
13 | \n", "100018 | \n", "Longview #2 Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "11/02/1981 | \n", "M00223 | \n", "Dravo Corp | \n", "L00238 | \n", "Southern Stone Company Inc | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Other | \n", "06/01/1979 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
14 | \n", "100020 | \n", "Madison Quarry Or Madison Quarry #117 | \n", "M | \n", "Surface | \n", "Abandoned | \n", "01/24/1994 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L00017 | \n", "Vulcan Materials Company | \n", "AL | \n", "1 | \n", "89 | \n", "Madison | \n", "5 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3811 | \n", "Franklin TN Field Office | \n", "... | \n", "
15 | \n", "100021 | \n", "HUNTSVILLE NORTH QUARRY | \n", "M | \n", "Surface | \n", "Active | \n", "04/18/1975 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Constr. Materials, L.P. | \n", "AL | \n", "1 | \n", "89 | \n", "Madison | \n", "5 | \n", "Partnership | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
16 | \n", "100025 | \n", "Montevallo Quarry And Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "05/31/1985 | \n", "M00223 | \n", "Dravo Corp | \n", "L00238 | \n", "Southern Stone Company Inc | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Other | \n", "06/01/1979 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
17 | \n", "100026 | \n", "Moretti Harrah Quarry | \n", "M | \n", "Surface | \n", "Abandoned | \n", "10/23/1986 | \n", "M07019 | \n", "Moretti-Harrah Marble Company | \n", "L08875 | \n", "Moretti-Harrah Marble Company | \n", "AL | \n", "1 | \n", "121 | \n", "Talladega | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
18 | \n", "100027 | \n", "NATIONAL CEMENT COMPANY | \n", "M | \n", "Facility | \n", "Active | \n", "11/26/1975 | \n", "M02802 | \n", "Vicat S A | \n", "L12645 | \n", "National Cement Co., of AL., Inc. | \n", "AL | \n", "1 | \n", "115 | \n", "St Clair | \n", "3 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
19 | \n", "100028 | \n", "Fort Payne Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "03/25/1977 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Construction Materials, L.P. | \n", "AL | \n", "1 | \n", "49 | \n", "De Kalb | \n", "4 | \n", "Partnership | \n", "05/04/2007 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
20 | \n", "100029 | \n", "Gull Dredge Or Dredge Gull | \n", "M | \n", "Surface | \n", "Abandoned | \n", "12/09/1982 | \n", "M00223 | \n", "Dravo Corp | \n", "L03645 | \n", "Radcliff Materials Inc | \n", "AL | \n", "1 | \n", "97 | \n", "Mobile | \n", "1 | \n", "Other | \n", "06/01/1979 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
21 | \n", "100030 | \n", "Tuscumbia Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "06/21/1984 | \n", "M00452 | \n", "Rogers Group Inc | \n", "L06514 | \n", "Rogers Group Inc | \n", "AL | \n", "1 | \n", "33 | \n", "Colbert | \n", "5 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
22 | \n", "100031 | \n", "Woodstock Quarry & Mill | \n", "M | \n", "Surface | \n", "Abandoned | \n", "02/09/1981 | \n", "M00223 | \n", "Dravo Corp | \n", "L00238 | \n", "Southern Stone Company Inc | \n", "AL | \n", "1 | \n", "7 | \n", "Bibb | \n", "3 | \n", "Other | \n", "06/01/1979 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
23 | \n", "100032 | \n", "OYSTER SHELL PRODUCTS | \n", "M | \n", "Facility | \n", "Abandoned | \n", "07/31/2000 | \n", "M00174 | \n", "Martin Marietta Materials Inc | \n", "L08284 | \n", "Martin Marietta Magnesia Specialties | \n", "AL | \n", "1 | \n", "97 | \n", "Mobile | \n", "1 | \n", "Other | \n", "01/03/1995 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
24 | \n", "100033 | \n", "Oakwood Quarry | \n", "M | \n", "Surface | \n", "Abandoned | \n", "03/12/1990 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L00017 | \n", "Vulcan Materials Company | \n", "AL | \n", "1 | \n", "87 | \n", "Macon | \n", "3 | \n", "Partnership | \n", "01/01/1950 | \n", "M3 | \n", "M3811 | \n", "Franklin TN Field Office | \n", "... | \n", "
25 | \n", "100034 | \n", "LIVLITE DIVISION | \n", "M | \n", "Surface | \n", "Active | \n", "11/26/1975 | \n", "M06183 | \n", "CRH PLC | \n", "L09995 | \n", "Big River Industries Inc | \n", "AL | \n", "1 | \n", "119 | \n", "Sumter | \n", "7 | \n", "Corporation | \n", "08/23/1988 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
26 | \n", "100036 | \n", "Cherokee Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "12/27/1984 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Constr. Materials, L.P. | \n", "AL | \n", "1 | \n", "33 | \n", "Colbert | \n", "5 | \n", "Partnership | \n", "05/06/1996 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
27 | \n", "100037 | \n", "CHILDERSBURG QUARRY | \n", "M | \n", "Surface | \n", "Active | \n", "11/26/1975 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Construction Materials, L.P. | \n", "AL | \n", "1 | \n", "121 | \n", "Talladega | \n", "3 | \n", "Partnership | \n", "11/01/1984 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
28 | \n", "100038 | \n", "Cyprus Industrial Minerals Company | \n", "M | \n", "Surface | \n", "Abandoned | \n", "08/12/1988 | \n", "M03644 | \n", "Cyprus Amax Minerals Company | \n", "L04522 | \n", "Cyprus Industrial Minerals Company | \n", "AL | \n", "1 | \n", "121 | \n", "Talladega | \n", "3 | \n", "Other | \n", "09/22/1980 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
29 | \n", "100039 | \n", "Trinity Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "12/27/1984 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Constr. Materials, L.P. | \n", "AL | \n", "1 | \n", "103 | \n", "Morgan | \n", "5 | \n", "Partnership | \n", "03/28/1981 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
30 | \n", "100040 | \n", "Montevallo Quarry & Mill | \n", "M | \n", "Surface | \n", "Active | \n", "04/05/1988 | \n", "0041044 | \n", "Lhoist Group | \n", "L13586 | \n", "Lhoist North America of Alabama, LLC | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Other | \n", "07/31/1989 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
31 | \n", "100042 | \n", "Bessemer Plant & Quarry | \n", "M | \n", "Surface | \n", "Abandoned | \n", "12/17/1985 | \n", "M00223 | \n", "Dravo Corp | \n", "L06813 | \n", "Dravo Basic Materials Company Inc | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Other | \n", "07/14/1980 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
32 | \n", "100043 | \n", "Leeds Plant | \n", "M | \n", "Facility | \n", "Active | \n", "12/05/1975 | \n", "M00004 | \n", "Heidelberg Cement AG | \n", "L17551 | \n", "Lehigh Cement Company LLC | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Other | \n", "02/01/2002 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
33 | \n", "100045 | \n", "TUSCUMBIA QUARRY | \n", "M | \n", "Surface | \n", "Active | \n", "01/30/1998 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Construction Materials, L.P. | \n", "AL | \n", "1 | \n", "33 | \n", "Colbert | \n", "5 | \n", "Partnership | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
34 | \n", "100047 | \n", "GLENCOE QUARRY | \n", "M | \n", "Surface | \n", "Active | \n", "12/05/1975 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Construction Materials, L.P. | \n", "AL | \n", "1 | \n", "55 | \n", "Etowah | \n", "4 | \n", "Partnership | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
35 | \n", "100048 | \n", "Russellville Quarry | \n", "M | \n", "Surface | \n", "Abandoned | \n", "07/23/1993 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L00017 | \n", "Vulcan Materials Company | \n", "AL | \n", "1 | \n", "59 | \n", "Franklin | \n", "4 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3811 | \n", "Franklin TN Field Office | \n", "... | \n", "
36 | \n", "100050 | \n", "Calera Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "12/05/1975 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L16168 | \n", "Vulcan Constr. Materials, L.P. | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Partnership | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
37 | \n", "100052 | \n", "Wade Sand & Gravel Co., Inc. | \n", "M | \n", "Surface | \n", "Active | \n", "12/05/1975 | \n", "M38913 | \n", "Robin A Wade Jr | \n", "L39961 | \n", "Wade Sand & Gravel Co., Inc | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
38 | \n", "100093 | \n", "Sandy Ridge Mill | \n", "M | \n", "Facility | \n", "Active | \n", "12/05/1975 | \n", "M00015 | \n", "Amcol International Corp | \n", "L00006 | \n", "American Colloid Company Mineral Group | \n", "AL | \n", "1 | \n", "85 | \n", "Lowndes | \n", "7 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
39 | \n", "100094 | \n", "Bessemer Shale Mine | \n", "M | \n", "Surface | \n", "Active | \n", "03/11/1990 | \n", "M00202 | \n", "Boral Limited | \n", "L09675 | \n", "Boral Bricks Inc | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Corporation | \n", "07/20/1995 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
40 | \n", "100095 | \n", "No 3 Plant & Cilla Mine Or Cilla Mine | \n", "M | \n", "Surface | \n", "Abandoned | \n", "11/06/1980 | \n", "M00037 | \n", "R H Bickerstaff | \n", "L00003 | \n", "Bickerstaff Clay Products Company Inc | \n", "AL | \n", "1 | \n", "113 | \n", "Russell | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
41 | \n", "100096 | \n", "BORAL CLAY PITS | \n", "M | \n", "Surface | \n", "Intermittent | \n", "03/16/2011 | \n", "M00202 | \n", "Boral Limited | \n", "L09675 | \n", "Boral Bricks Inc | \n", "AL | \n", "1 | \n", "113 | \n", "Russell | \n", "3 | \n", "Corporation | \n", "07/20/1995 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
42 | \n", "100097 | \n", "No 4 Mines & Mill Or No 4 Mines | \n", "M | \n", "Surface | \n", "Abandoned | \n", "06/08/1979 | \n", "M00037 | \n", "R H Bickerstaff | \n", "L00003 | \n", "Bickerstaff Clay Products Company Inc | \n", "AL | \n", "1 | \n", "113 | \n", "Russell | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
43 | \n", "100098 | \n", "Dixie Pit And Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "07/05/1993 | \n", "M32627 | \n", "Powell Gerald-W F Andrews | \n", "L32627 | \n", "Dixie Clay Company Of Alabama | \n", "AL | \n", "1 | \n", "15 | \n", "Calhoun | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
44 | \n", "100099 | \n", "SOUTHEAST REFRACTORIES, INC. | \n", "M | \n", "Surface | \n", "Abandoned | \n", "01/03/2001 | \n", "M32684 | \n", "Jim Farrell; Doug Doss | \n", "L32684 | \n", "South East Refractories Inc | \n", "AL | \n", "1 | \n", "15 | \n", "Calhoun | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
45 | \n", "100100 | \n", "Fairhope Clay Products Incorporated | \n", "M | \n", "Surface | \n", "Abandoned | \n", "03/13/1985 | \n", "M33158 | \n", "Jennings Bart Jr | \n", "L33158 | \n", "Fairhope Clay Products Inc | \n", "AL | \n", "1 | \n", "3 | \n", "Baldwin | \n", "1 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
46 | \n", "100101 | \n", "Stewart Mine | \n", "M | \n", "Surface | \n", "Abandoned | \n", "01/08/1979 | \n", "M01265 | \n", "Dudley P Frame | \n", "L01420 | \n", "Frame Brick & Tile Company | \n", "AL | \n", "1 | \n", "15 | \n", "Calhoun | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
47 | \n", "100102 | \n", "Frame Mine & Mill Or Frame Mine | \n", "M | \n", "Surface | \n", "Abandoned | \n", "10/13/1981 | \n", "M01265 | \n", "Dudley P Frame | \n", "L01420 | \n", "Frame Brick & Tile Company | \n", "AL | \n", "1 | \n", "15 | \n", "Calhoun | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
48 | \n", "100103 | \n", "Wheeler Lake | \n", "M | \n", "Surface | \n", "Abandoned | \n", "03/06/1989 | \n", "M07480 | \n", "Marley Plc | \n", "L09534 | \n", "General Shale Products Corp | \n", "AL | \n", "1 | \n", "89 | \n", "Madison | \n", "5 | \n", "Corporation | \n", "06/30/1986 | \n", "M3 | \n", "M3811 | \n", "Franklin TN Field Office | \n", "... | \n", "
49 | \n", "100107 | \n", "Henry County Mine | \n", "M | \n", "Surface | \n", "Abandoned | \n", "07/22/1988 | \n", "M00003 | \n", "Dresser Industries Inc | \n", "L00005 | \n", "Harbison-Walker Refractories U S | \n", "AL | \n", "1 | \n", "67 | \n", "Henry | \n", "2 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
50 | \n", "100109 | \n", "AXIS QUARRY | \n", "M | \n", "Surface | \n", "Abandoned | \n", "04/22/2004 | \n", "M01644 | \n", "Holcim Ltd | \n", "0051046 | \n", "Holcim (US) Incorporated | \n", "AL | \n", "1 | \n", "97 | \n", "Mobile | \n", "1 | \n", "Corporation | \n", "12/12/2001 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
51 | \n", "100110 | \n", "Browder Pit | \n", "M | \n", "Surface | \n", "Abandoned | \n", "08/21/1981 | \n", "M01543 | \n", "Jenkins Brick Company | \n", "L01719 | \n", "Jenkins Brick Company | \n", "AL | \n", "1 | \n", "101 | \n", "Montgomery | \n", "2 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
52 | \n", "100111 | \n", "Gober Pit | \n", "M | \n", "Surface | \n", "Abandoned | \n", "07/05/1994 | \n", "M01543 | \n", "Jenkins Brick Company | \n", "L01719 | \n", "Jenkins Brick Company | \n", "AL | \n", "1 | \n", "51 | \n", "Elmore | \n", "2 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
53 | \n", "100113 | \n", "Brewton Mine And Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "01/08/1980 | \n", "M35119 | \n", "Keego Clay Prod Company Inc | \n", "L35119 | \n", "Keego Clay Prod Company Inc | \n", "AL | \n", "1 | \n", "53 | \n", "Escambia | \n", "1 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3000 | \n", "Southeast District - Birmingham | \n", "... | \n", "
54 | \n", "100114 | \n", "Cordova Loading | \n", "C | \n", "Facility | \n", "Abandoned | \n", "07/29/1998 | \n", "C00866 | \n", "Drummond Company Inc | \n", "P17353 | \n", "Drummond Company, Inc. | \n", "AL | \n", "1 | \n", "127 | \n", "Walker | \n", "4 | \n", "Corporation | \n", "01/01/1950 | \n", "C11 | \n", "C1101 | \n", "Bessemer AL Field Office | \n", "... | \n", "
55 | \n", "100115 | \n", "Ragland | \n", "M | \n", "Surface | \n", "Active | \n", "01/25/2013 | \n", "M11407 | \n", "G Geoff Dunlap | \n", "L14985 | \n", "Ragland Clay Products | \n", "AL | \n", "1 | \n", "115 | \n", "St Clair | \n", "3 | \n", "Corporation | \n", "11/08/1996 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
56 | \n", "100122 | \n", "Parkwood Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "03/04/1994 | \n", "0071891 | \n", "Vulcan Materials Company | \n", "L00017 | \n", "Vulcan Materials Company | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
57 | \n", "100123 | \n", "Coosa River Clay Pit | \n", "M | \n", "Surface | \n", "Abandoned | \n", "11/15/1982 | \n", "M00624 | \n", "Hepworth Plc | \n", "L00761 | \n", "W S Dickey Clay Manufacturing Company | \n", "AL | \n", "1 | \n", "7 | \n", "Bibb | \n", "3 | \n", "Other | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
58 | \n", "100124 | \n", "Bessemer Clay Mines | \n", "M | \n", "Facility | \n", "Abandoned | \n", "05/14/1990 | \n", "M06908 | \n", "Hardin Donald A | \n", "L08724 | \n", "Donald Hardin Construction Company Inc | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Other | \n", "04/09/1986 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
59 | \n", "100125 | \n", "Watkins Brick & Tile Corp Mine #1 | \n", "M | \n", "Surface | \n", "Abandoned | \n", "09/21/1989 | \n", "M07434 | \n", "Araneta Francisco | \n", "L09476 | \n", "Watkins Brick & Tile Corp | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Corporation | \n", "05/01/1986 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
\n", " | ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
84968 rows \u00d7 79 columns
\n", "\n", " | MINE_ID | \n", "CURRENT_MINE_NAME | \n", "COAL_METAL_IND | \n", "CURRENT_MINE_TYPE | \n", "CURRENT_MINE_STATUS | \n", "CURRENT_STATUS_DT | \n", "CURRENT_CONTROLLER_ID | \n", "CURRENT_CONTROLLER_NAME | \n", "CURRENT_OPERATOR_ID | \n", "CURRENT_OPERATOR_NAME | \n", "STATE | \n", "BOM_STATE_CD | \n", "FIPS_CNTY_CD | \n", "FIPS_CNTY_NM | \n", "CONG_DIST_CD | \n", "COMPANY_TYPE | \n", "CURRENT_CONTROLLER_BEGIN_DT | \n", "DISTRICT | \n", "OFFICE_CD | \n", "OFFICE_NAME | \n", "\n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "100003 | \n", "O'Neal Quarry & Mill | \n", "M | \n", "Surface | \n", "Active | \n", "01/22/1979 | \n", "0041044 | \n", "Lhoist Group | \n", "L13586 | \n", "Lhoist North America | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Other | \n", "07/01/1989 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
1 | \n", "100004 | \n", "Brierfield Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "03/04/2003 | \n", "0041044 | \n", "Lhoist Group | \n", "L13586 | \n", "Lhoist North America of Alabama, LLC | \n", "AL | \n", "1 | \n", "7 | \n", "Bibb | \n", "3 | \n", "Other | \n", "06/14/2000 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
2 | \n", "100005 | \n", "Birmingham Plant | \n", "M | \n", "Surface | \n", "Abandoned | \n", "08/15/1989 | \n", "0041044 | \n", "Lhoist Group | \n", "L10998 | \n", "Allied Lime Company | \n", "AL | \n", "1 | \n", "73 | \n", "Jefferson | \n", "6 | \n", "Other | \n", "07/31/1989 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
3 | \n", "100006 | \n", "Auburn Quarry | \n", "M | \n", "Surface | \n", "Active | \n", "09/24/1976 | \n", "M00174 | \n", "Martin Marietta Materials Inc | \n", "L16197 | \n", "Martin Marietta Materials, Inc. | \n", "AL | \n", "1 | \n", "81 | \n", "Lee | \n", "3 | \n", "Corporation | \n", "01/17/2002 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
4 | \n", "100008 | \n", "Landmark Plant | \n", "M | \n", "Surface | \n", "Active | \n", "11/14/1975 | \n", "M31753 | \n", "Alan B Cheney | \n", "L31753 | \n", "Cheney Lime & Cement Company | \n", "AL | \n", "1 | \n", "117 | \n", "Shelby | \n", "6 | \n", "Corporation | \n", "01/01/1950 | \n", "M3 | \n", "M3661 | \n", "Birmingham AL Field Office | \n", "... | \n", "
5 rows \u00d7 59 columns
\n", "\n", " | STREET | \n", "CITY | \n", "STATE | \n", "MINE_STATUS | \n", "BUSINESS_NAME | \n", "CONTACT_TITLE | \n", "MINE_NAME | \n", "
---|---|---|---|---|---|---|---|
84158 | \n", "Mile 128 Steese Hwy | \n", "Central | \n", "Alaska | \n", "Intermittent | \n", "John A Brown | \n", "Owner | \n", "John Brown Mine | \n", "
84159 | \n", "3937 Dobro Drive | \n", "Fairbanks | \n", "Alaska | \n", "Intermittent | \n", "Daniel Even | \n", "Owner | \n", "Daniel Even | \n", "
84160 | \n", "1725 Fiddle Way | \n", "Fairbanks | \n", "Alaska | \n", "Intermittent | \n", "Tracy Freel | \n", "Owner | \n", "Brant, Tracy | \n", "
84162 | \n", "3800 Hwy 2 and 52 | \n", "Minot | \n", "North Dakota | \n", "Intermittent | \n", "Blue Ribbon Gold Inc | \n", "President | \n", "Cahoon #1 | \n", "
84163 | \n", "NA, P.O. box is only avalible option | \n", "Haines | \n", "Alaska | \n", "Intermittent | \n", "Hurt LLC | \n", "Owner | \n", "MK Falls | \n", "
5 rows \u00d7 7 columns
\n", "