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

84968 rows \u00d7 79 columns

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

5 rows \u00d7 59 columns

\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 116, "text": [ " MINE_ID CURRENT_MINE_NAME COAL_METAL_IND CURRENT_MINE_TYPE \\\n", "0 100003 O'Neal Quarry & Mill M Surface \n", "1 100004 Brierfield Quarry M Surface \n", "2 100005 Birmingham Plant M Surface \n", "3 100006 Auburn Quarry M Surface \n", "4 100008 Landmark Plant M Surface \n", "\n", " CURRENT_MINE_STATUS CURRENT_STATUS_DT CURRENT_CONTROLLER_ID \\\n", "0 Active 01/22/1979 0041044 \n", "1 Active 03/04/2003 0041044 \n", "2 Abandoned 08/15/1989 0041044 \n", "3 Active 09/24/1976 M00174 \n", "4 Active 11/14/1975 M31753 \n", "\n", " CURRENT_CONTROLLER_NAME CURRENT_OPERATOR_ID \\\n", "0 Lhoist Group L13586 \n", "1 Lhoist Group L13586 \n", "2 Lhoist Group L10998 \n", "3 Martin Marietta Materials Inc L16197 \n", "4 Alan B Cheney L31753 \n", "\n", " CURRENT_OPERATOR_NAME STATE BOM_STATE_CD FIPS_CNTY_CD \\\n", "0 Lhoist North America AL 1 117 \n", "1 Lhoist North America of Alabama, LLC AL 1 7 \n", "2 Allied Lime Company AL 1 73 \n", "3 Martin Marietta Materials, Inc. AL 1 81 \n", "4 Cheney Lime & Cement Company AL 1 117 \n", "\n", " FIPS_CNTY_NM CONG_DIST_CD COMPANY_TYPE CURRENT_CONTROLLER_BEGIN_DT \\\n", "0 Shelby 6 Other 07/01/1989 \n", "1 Bibb 3 Other 06/14/2000 \n", "2 Jefferson 6 Other 07/31/1989 \n", "3 Lee 3 Corporation 01/17/2002 \n", "4 Shelby 6 Corporation 01/01/1950 \n", "\n", " DISTRICT OFFICE_CD OFFICE_NAME \n", "0 M3 M3661 Birmingham AL Field Office ... \n", "1 M3 M3661 Birmingham AL Field Office ... \n", "2 M3 M3661 Birmingham AL Field Office ... \n", "3 M3 M3661 Birmingham AL Field Office ... \n", "4 M3 M3661 Birmingham AL Field Office ... \n", "\n", "[5 rows x 59 columns]" ] } ], "prompt_number": 116 }, { "cell_type": "code", "collapsed": false, "input": [ "for column in df.columns:\n", " print column\n" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "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", "ASSESS_CTRL_NO\n", "PRIMARY_SIC_CD\n", "PRIMARY_SIC\n", "PRIMARY_SIC_CD_1\n", "PRIMARY_SIC_CD_SFX\n", "SECONDARY_SIC_CD\n", "SECONDARY_SIC\n", "SECONDARY_SIC_CD_1\n", "SECONDARY_SIC_CD_SFX\n", "PRIMARY_CANVASS_CD\n", "PRIMARY_CANVASS\n", "SECONDARY_CANVASS_CD\n", "SECONDARY_CANVASS\n", "CURRENT_103I\n", "CURRENT_103I_DT\n", "PORTABLE_OPERATION\n", "PORTABLE_FIPS_ST_CD\n", "DAYS_PER_WEEK\n", "HOURS_PER_SHIFT\n", "PROD_SHIFTS_PER_DAY\n", "MAINT_SHIFTS_PER_DAY\n", "NO_EMPLOYEES\n", "PART48_TRAINING\n", "LONGITUDE\n", "LATITUDE\n", "AVG_MINE_HEIGHT\n", "MINE_GAS_CATEGORY_CD\n", "METHANE_LIBERATION\n", "NO_PRODUCING_PITS\n", "NO_NONPRODUCING_PITS\n", "NO_TAILING_PONDS\n", "PILLAR_RECOVERY_USED\n", "HIGHWALL_MINER_USED\n", "MULTIPLE_PITS\n", "MINERS_REP_IND\n", "SAFETY_COMMITTEE_IND\n", "MILES_FROM_OFFICE\n", "DIRECTIONS_TO_MINE\n", "NEAREST_TOWN\n" ] } ], "prompt_number": 117 }, { "cell_type": "code", "collapsed": false, "input": [ "\n", "pd.unique(data.CURRENT_MINE_TYPE)\n", "#qplot(data.NO_PRODUCING_PITS)+geom_histogram()" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 130, "text": [ "array(['Surface', 'Facility', 'Underground', nan], dtype=object)" ] } ], "prompt_number": 130 }, { "cell_type": "code", "collapsed": false, "input": [ "gold = df.PRIMARY_SIC == \"Gold Ore\"\n", "\n", "data = df[gold]\n", "\n", "data['lon'] = -data.LONGITUDE\n", "data['lon']\n", "\n", "data['CURRENT_MINE_STATUS'][data['CURRENT_MINE_STATUS'] == \"New Mine\"] = \"Active\"\n", "print \"Total Gold Mines since 1970\".format(len(data))\n", "print \"there are {} gold mines missing lat/longs\".format(len(data[data.LONGITUDE.isnull()]))\n", "\n", "active = data[data.CURRENT_MINE_STATUS==\"Active\"]\n", "print \"{} active mines\".format(len(active))\n", "print \"{} active mines with missing lat/long\".format(len(active[active.lon.isnull()]))\n", "\n", "\n", "\n", "from ggplot import *\n", "%matplotlib inline\n", "\n", "ggplot(data, aes(\"lon\", \"LATITUDE\", color = \"CURRENT_MINE_STATUS\"))+geom_point()" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Total Gold Mines since 1970\n", "there are 2544 gold mines missing lat/longs\n", "78 active mines\n", "5 active mines with missing lat/long\n" ] }, { "metadata": {}, "output_type": "display_data", "png": "iVBORw0KGgoAAAANSUhEUgAAArgAAAIACAYAAABpWR83AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzs3Xd4VHXe/vH3mcykTiaNkEqCFCkqQRRFCQIqKIiAaEBA\niqK/ta7os7suIEXsruVZy2ND6YgG15VVEBRFpCgqzQZICQFCCUlIL5PM+f3BMhIgtAyZZLhf18V1\n5ZTvOZ/zIeKdk++cY5imaSIiIiIi4iMs3i5ARERERMSTFHBFRERExKco4IqIiIiIT1HAFRERERGf\nooArIiIiIj5FAVdEREREfIoCroiIiEg9l5GRgcViwWJRdDsV6pKIiIjUOz///DO33norsbGxBAYG\nkpyczB133EFubq63S6vRyJEjsVgsPPbYY6e0/+HAarVa2blzp3v9rFmz3Nu6d+8OQFhYGKNHj2b0\n6NFnpfajLVmyhM6dO+NwOAgNDaVFixbceuut7u3Tpk2rVt+pOt0enSnrWT26iIiIyGlatmwZ1113\nHeXl5bRs2ZIbb7yRvXv38sEHHzB69GgiIyPP6LiVlZVYrcdGn5rW1xWXy8Vbb73F448/DsDrr7/u\n3mYYBgARERG8+OKLdVLP7t276du3L06nk1tuuQWHw8GmTZv4z3/+c8y+h+urd0wRERGReqRVq1am\nYRjmNddcY1ZUVLjX79u3z8zLyzO3b99uGoZhGobh3jZixAjTMAxz0qRJpmma5sSJE03DMMxbbrnF\nTEtLM4OCgsxp06bVuN40TfOdd94x27VrZ9rtdrNly5bmU089ZVZWVpqmaZpTp041DcMwU1NTzdGj\nR5thYWFmQkKCOXv27GrnP/LPyJEjT3idh/eLjIw04+LiTKfTaa5fv969zjAMs3v37qZpmse95sPL\nr7zyitmyZUvTbrebt912W7Weffzxx2bHjh1Nh8NhJicnm//zP/9jlpSUnLCuDz/80DQMw+zfv3+1\n9Xl5edV6ceSfpk2bmqZpmg8//LCZnJxsBgYGmsHBwWanTp3MpUuXnrBHS5curXYM0zTNrl27moZh\nuP9uFi9ebHbo0MEMCQkxw8LCzA4dOpj/+te/arwGTVEQERGReuP3339n8+bNGIbBI488gs1mc29r\n3Lgx4eHh7uXj3T08et2HH37I9u3bGT58OLGxse7tR69/8803ufPOO8nPz2fQoEEEBQUxbtw4nnzy\nyWrHW7FiBatWraJTp05kZWXxpz/9icLCQq677jratGkDQKdOnRg9ejTXXXfdSa/XMAxGjBjB3r17\n+eijj3j99dexWCwMHz68xv2PNmnSJFJTU3G5XMyePZuZM2cCsGjRIvr378+OHTsYMGAAiYmJvPji\ni9x3330nrCk+Ph6A//znP/To0YOJEyeyfPlywsLCALjgggvo0aMHAAkJCYwePZpRo0YBh+YKX3HF\nFdx55510796d7777jrS0NIqKik7aoxP9fd5+++1s2LCBW265hVtuuQU/Pz9++eWXGq9BUxRERESk\n3ti/f7/76+Tk5Fofr3nz5nz33XfuD2etWrXquOsvuOACADp27EhoaCgXXXQRP/30E6+//joTJkxw\nHy8qKoply5ZhsVgIDAykpKSE33//ncGDB7No0SJ+++03rr/++mpjTmbQoEHMmDGDl156iV9++YVe\nvXrRtGnTUx7/5ptvcvPNN+NyuZgxYwbr1q0D4OWXXwagffv2hIeH065dO1auXMn06dN57bXXCAoK\nOu7xOnXqxF/+8hdeeukllixZwpIlS3j88cfp0KEDS5YsoWPHjgwZMoTPP/+cli1bVps6MWXKFNLT\n09mxYwctWrQgODiYAwcO8PPPP9fYo6VLl570GisrKwkMDOTGG2/koosuomXLlpimWeP+CrgiIiJS\nb8TExLi/zsjI4Pzzzz+lcVVVVcddf9lllx33yQNHr8/IyAAO3dmFQ3cODcNg//79FBcXu/dr06YN\n/v7+AISEhFBUVERRUdEp1ViTwMBARo4c6Q6K99xzD5s3bz6lsYZhcPHFFwO477AerufwNX3++ed8\n/vnn7v0Btm/fTtu2bWs87nPPPceYMWP44osvWLJkCVOnTmXNmjW8++67PPTQQ8cNlzk5ObRr1449\ne/a4z3V4v+zs7FO6nsOO/vt88803+etf/0paWhpw6AeNV199lUGDBh13vKYoiIiISL3RokULWrVq\nhWmaPPvss1RUVLi3ZWdnk5+fj91ud68rLCwEDj114XgCAgJOaf15550HwPz583G5XFRVVVFVVcXW\nrVsJCQlx73fkh9GO/pW6n58fUHPYrolhGNx9990YhkHTpk3p1avXaY0/XNPR9Ry+ppdffhmXy+W+\nri1btpww3O7cuZOtW7cSERFBWloab7zxhrumw+H58LW6XC73uG+++YY9e/YQFxfHvn37KCsrc4fu\nw0H3eD063N/Df5dOp/OYgN+rVy82b97MgQMHmDdvHjk5OYwbN67mntS4RURERMQL3njjDa6//nq+\n+uorLrroIrp06UJubi5ffPEFy5cvp127diQmJrJr1y5uu+02AgICWL9+fa3Oef/993Pvvfdy2223\n0b9/f1wuFz/88AMxMTF89dVXNY478k5mUlIScOgxX/n5+fTv359u3bqd8LyHx7do0YJly5YRFRV1\nWk8mONGv6e+77z4WLFjA3/72N1asWEFQUBAbNmwgNzeXbdu21Thu/fr19OvXjyuuuIJWrVpRUlLC\np59+isVi4Zprrql2rT/88AP33nsvHTp04MILLwQOTTMZPXo0W7durXb3+8hxR/aoQ4cOBAcHk5OT\nw/Dhw9m7d+8xd3zbt29P06ZNSUpKcj9SLSIiosZr0B1cERERqVe6du3K6tWrSUtLo6CggJkzZ/Lj\njz9yyy230KRJEwDeeecdmjVrxvLly7FarfTr169aMDw8xeBoNa2/++67mTJlCs2aNePDDz/ks88+\nIyYmhrvuuss97mTHuuuuu7jyyivZvXs3r7zyCmvWrDnptR45vnPnzrRu3brG851s/NH19OrVi48+\n+oiUlBQWLlzIv//9b6xW60mfpXvhhRcyYsQI9u/fzwcffMCCBQtISUlh1qxZXHnllQBcddVVDBky\nBD8/P958803mz59Pp06dGDduHA6Hgy+++IKhQ4eSkJBw0h45HA7eeOMN4uPjWbx4MS1btqRTp07V\nxvXo0YPNmzczY8YMVq5cSffu3ZkyZUrNfTFPFP1FRERERBoYTVEQEREROQtyc3OZPHnyMeujoqIY\nP368Fyr6w5YtW3j11VePWd+yZcuTPkasIaizO7jffPMNGzZswDAMGjduTP/+/amoqGDevHkcPHiQ\n8PBw0tLSanxkhYiIiEhDkpGRQbNmzao9TQCgadOmJ5wDWxeWLl3K1VdffUxt3bp148svv/RiZZ5R\nJwE3Ly+P6dOnc//992O1WklPT6dly5bs37+f4OBgUlNTWb58OaWlpe4HB4uIiIiInIk6+ZBZQEAA\nfn5+OJ1OqqqqcDqdhIaGsmnTJtq3bw9ASkoKGzdurItyRERERMSH1ckc3ODgYK644gpeeuklrFYr\nLVq0oHnz5hQXF7ufZWe32495lISIiIiIyOmqk4Cbm5vLt99+y+jRowkICCA9Pf2Y59Ud/TiMgoKC\nY94MYrfbcTgcZ71eEREREWm46iTgZmVl0aRJE4KDg4FDr7nbtWsXdrudwsJCQkNDKSwsrPamkB9/\n/JGvv/662nG6du1K9+7d66JkEREREWmg6iTgNmrUiK+//hqn04nVamXbtm0kJCRgs9lYv349qamp\nrFu3zv1wY4BLLrmEVq1aVTuO3W4nLy+PysrKuij7jAQEBFBeXu7tMmpktVqJiIhQH2tBPfQM9dEz\n1EfPUB8943AfRbytTgJubGwsKSkpvPXWWxiGQVxcHJdccgnl5eWkp6ezZs0a92PCDnM4HMedjpCd\nnY3T6ayLss+I1Wqt1/UdVllZWa/rbAh9VA89Q330DPXRM9RHEd9QZy96SE1NJTU1tdq64OBgRowY\nUVcliIiIiMg5oE4eEyYiIiIiUlcUcEVERETEpyjgioiIiIhPUcAVEREREZ+igCsiIiIiPkUBV0RE\nRER8igKuiIiIiPgUBVwRERER8SkKuCIiIiIn0bRpU5YsWeJz5zqSxWJh27ZtdX7es0EBV0RERAQo\nKirCbrfTu3fvY7YZhoFhGHVSR12ey1cp4IqIiIgAH374IUlJSSxdupR9+/Z5uxypBQVcEREREWD6\n9OnceeeddO7cmVmzZh2zffXq1VxwwQVERkZyxx13UF5eDsDBgwfp06cPjRs3JjIykhtvvJHdu3e7\nx3Xr1o0JEyaQmpqKw+HguuuuIycnx7195syZJCcn06hRI5566qlq5ywvL2f06NEkJCSQkJDAQw89\nREVFBQBLly4lMTGRF198kZiYGOLj45k2bVq1sX/5y19ITk4mNjaWe+65h7KyMvf2f/zjH8THx5OY\nmMi7777rkR7WFwq4IiIics7bsWMHy5YtY+DAgQwcOJAZM2ZU226aJnPmzGHx4sVs3bqVzZs388QT\nTwDgcrkYNWoUmZmZZGZmEhQUxP33319t/Hvvvce0adPYv38/FRUVPP/88wD8+uuv3HvvvcyePZus\nrCxycnLYtWuXe9yTTz7J6tWrWb9+PevXr2f16tXu8wLs27ePgoICsrKyeOedd7jvvvvIz88H4O9/\n/ztbtmxh/fr1bNmyhd27dzN58mQAPvvsM1544QW++OILNm/ezBdffOH5pnqRAq6IiIic82bOnMll\nl11GYmIiAwYM4Ndff2XdunXu7YZhcP/995OQkEBERATjxo3jvffeAyAyMpKbbrqJwMBA7HY7Y8eO\n5euvv6429vbbb6dFixYEBgYycOBA97HnzZvHjTfeSGpqKv7+/jz++ONYLH/Eszlz5jBhwgQaNWpE\no0aNmDhxIjNnznRvt9lsTJgwAT8/P3r16oXdbmfTpk2Ypsnbb7/Niy++SHh4OHa7nTFjxjB37lwA\nPvjgA+644w7atm1LcHAwjz322Fntb12zersAEREREW+bMWMG99xzDwBRUVF069aN6dOn0759e/c+\nTZo0cX+dlJREVlYWACUlJTz00EMsWrSIvLw84NAH1kzTdH9YLDY21j02KCiIoqIiALKyskhMTHRv\nCw4OJioqyr2clZVFcnLycc97uNYjA3FwcDBFRUVkZ2dTUlLCJZdc4t5mmiYulwuAPXv20LFjx2rH\n9SUKuCIiIlKvFGZsxMzbe8bjjYhYQpu2PuX9V65cyZYtW3jiiSd47rnnDtVQWMiGDRt44YUX3AEy\nMzPTPSYzM5OEhAQAXnjhBTZv3szq1atp3Lgx69ato0OHDtUCbk3i4+P57bff3MslJSXV5ufGx8eT\nkZFBmzZt3OeNj48/6TU1atSIoKAgfv31V+Li4o7ZHhcXd8z1+BIFXBEREalXzLy9OGb/9YzHFwz9\nB5xGwJ0+fTo9e/asNu+2pKSEdu3asWDBAvr06YNpmrz22mv06dOHoKAgnnzySQYNGgQculsbFBRE\nWFgYubm5x/11v2maxz33zTffTKdOnVixYgUdO3ZkwoQJ7rusAIMHD+aJJ55w322dPHkyw4YNO+k1\nWSwW7rrrLkaPHs2rr75KdHQ0u3fv5pdffqFnz54MHDiQ22+/neHDh5OcnOxzUxQ0B1dERETOWWVl\nZaSnp/PAAw/QuHFj95+mTZsybNgwd+g1DIOhQ4fSs2dPmjdvTsuWLXn00UcBGD16NKWlpTRq1Igr\nr7ySXr16HXPn9sjlI59ze8EFF/Daa68xZMgQ4uPjiYyMrDYV4tFHH+XSSy+lXbt2tGvXjksvvdR9\n3qOPe7Rnn32WFi1a0KlTJ8LCwujRowebN28G4Prrr2f06NFcffXVnH/++VxzzTU+9exdw6zpR4p6\nKjs7G6fT6e0yahQUFERpaam3y6iRzWYjOjpafawF9dAz1EfPUB89Q330jMN9rK2CtUtrfQfXcXG3\nWtchDZfu4IqIiIiIT9EcXBEREalXjIjYQ/NoazFezm0KuCIiIlKvhDZtfVofEhM5mqYoiIiIiIhP\nUcAVEREREZ+igCsiIiIiPkUBV0RERER8igKuiIiIiPgUBVwRERER8SkKuCIiIiLiUxRwRURERMSn\nKOCKiIiIiE9RwBURERERn6KAKyIiIiI+RQFXRERERHyKYZqm6e0iTlVZWRllZWXU55ItFgsul8vb\nZdTIMAz8/f2pqKhQH8+QeugZ6qNnqI+eoT56hmEYhIeHe7sMEazeLuB0BAYGUlhYiNPp9HYpNQoK\nCqK0tNTbZdTIZrMRHh5OcXGx+niG1EPPUB89Q330DPXRM2w2m7dLEAE0RUFEREREfIwCroiIiIj4\nFAVcEREREfEpCrgiIiIi4lMUcEVERETEpyjgioiIiIhPUcAVEREREZ+igCsiIiIiPkUBV0RERER8\nigKuiIiIiPgUBVwRERER8SkKuCIiIiLiUxRwRURERDzowgsvZNmyZd4u45ymgCsiIiICFBUVYbfb\n6d279ymPGTlyJOPHj6+27ueff+aqq67ydHlyGhRwRURERIAPP/yQpKQkli5dyr59+7xdjtSCAq6I\niIgIMH36dO688046d+7MrFmzqm1bvnw5V155JRERESQlJTF9+nTefvtt5syZw3PPPUdoaCj9+vUD\noGnTpnz55ZdkZWURHBxMXl6e+zhr164lOjqaqqoqAN59913atm1LZGQk119/PZmZmXV3wT5MAVdE\nRETOeTt27GDZsmUMHDiQgQMHMmPGjGrbevfuzYMPPsiBAwdYt24d7du356677mLo0KE88sgjFBYW\n8vHHHwNgGAYA8fHxXHHFFXz44YfuY82ZM4e0tDT8/Pz4+OOPefrpp/noo484cOAAXbp0YfDgwXV7\n4T5KAVdERETOeTNnzuSyyy4jMTGRAQMG8Ouvv7Ju3TrgUCjt0aMHgwYNws/Pj8jISFJSUtxjTdOs\n8bhDhgzhvffec+/3/vvvM2TIEADeeOMNxowZQ6tWrbBYLIwZM4Z169axc+fOs3il5wYFXBERETnn\nzZgxg7S0NACioqLo1q0b06dPB2Dnzp00a9bsjI47YMAAVq1axd69e1m2bBkWi4XU1FTg0J3hBx98\nkIiICCIiIoiKigJg9+7dHriic5vV2wWIiIiIHCnj4HrynGc+FzXClkTT8JST7/hfK1euZMuWLTzx\nxBM899xzABQWFrJhwwaef/55kpKSWL169XHHHp6OUGMtERH07NmT999/n19//bXaFISkpCTGjx+v\naQlngQKuiIiI1Ct5zkxmVvQ94/HDmE9TTj3gTp8+nZ49e1abd1tSUkK7du1YuHAhQ4cO5amnniI9\nPZ2bbrqJ/Px8du3aRUpKCjExMWzbtu2Exx8yZAjPPPMMmZmZfPXVV+71d999N+PHjyclJYW2bduS\nn5/P4sWL3XeS5cxpioKIiIics8rKykhPT+eBBx6gcePG7j9NmzZl2LBhzJgxgyZNmrBgwQJeeOEF\noqKiuPjii9mwYQMAo0aN4tdffyUiIoIBAwYc9xx9+/Zly5YtxMXFcdFFF7nX9+/fn0ceeYRbb72V\nsLAwLrroIhYtWlQn1+3rdAdXREREzlmBgYHk5uYed9trr73m/jo1NZVvv/32mH1atGjB2rVrq63b\nvn37MecoKCg47jluu+02brvtttMtW05Cd3BFRERExKfoDq6IiIjUKxG2JIYxv1bj5dymgCsiIiL1\nStPwlNP6kJjI0TRFQURERER8igKuiIiIiPgUBVwRERER8SkKuCIiIiLiU+rsQ2YHDhxg3rx57uW8\nvDy6d+9Ou3btmDdvHgcPHiQ8PJy0tDSCgoLqqiwRERER8TF1FnAbNWrE3XffDYDL5eLFF1+kTZs2\nLF++nGbNmpGamsry5ctZvnw5PXr0qKuyRERERMTHeGWKwrZt24iMjCQsLIxNmzbRvn17AFJSUti4\ncaM3ShIRERERH+GVgPvzzz9z4YUXAlBcXIzdbgfAbrdTXFzsjZJERERExEfU+YseKisr2bx583Gn\nIRiG4f66oKCAoqKiatvtdjtWa/1+N4Wfnx82m83bZdTocP/UxzOnHnqG+ugZ6qNnqI+eUd/7J+eO\nOv9O3LJlC3FxcYSEhAAQEhJCYWEhoaGhFBYWutf/+OOPfP3119XGdu3ale7du9d1yT4pIiLC2yU0\neOqhZ6iPnqE+eob6KOIb6jzg/vTTT1x00UXu5VatWrF+/XpSU1NZt24drVu3BuCSSy6hVatW1cba\n7Xby8vKorKys05pPR0BAAOXl5d4uo0ZWq5WIiAj1sRbUQ89QHz1DffQM9dEzDvdRxNvqNOBWVFSw\nbds2+vbt616XmppKeno6a9ascT8mDMDhcOBwOI45RnZ2Nk6ns85qPl1Wq7Ve13dYZWVlva6zIfRR\nPfQM9dEz1EfPUB9FfEOdBlx/f38eeeSRauuCg4MZMWJEXZYhIiIiIj5MbzITEREREZ+igCsiIiIi\nPkUBV0RERER8igKuiIiIiPgUBVwRERER8SkKuCIiIiLiUxRwRURERMSnKOCKiIiIiE9RwBURERER\nn1KnbzITOZkCo5LJ9t/Jt7noYUYwsCze2yWJiIhIA6OAK/WGExdDw9exxr8AgOWhBygxXIwsTfRy\nZSIiItKQaIqC1Bvb/ErYbC12LxdYqvgsINuLFYmIiEhDpIAr9UaI6UeAWf1b0orhpWpERESkoVLA\nlXojscKP3jn+2KsOhdrzKoN4tLC5l6sSERHxrtmzZ3Pdddd5u4wGRQFX6oUDe/dTMPsB3vzf5/j4\n7Xn83+c7uaMkkUcdv5MWvoav/XO8XaKIiPiojIwMLBYLLpfrlPa3WCxs27btLFf1h6FDh7Jo0aIa\nz7906VKaNGnisfNNmjSJYcOGeex43qAPmUm9cGDVK1ydsxeAq7fvIjskiHHByeRZD/1js92vlPcP\ntqd5VYg3yxQREQHANM0zGldZWYnVWvv4dabnP1foDm4Dt8mviPscP3O/4xe2+5V4u5wzZqsqrbb8\nnwvOc4dbgD3WchYFHKjrskRE5Bw0cuRI7rvvPvr06YPD4aBTp07uO6ZXXXUVACkpKYSGhpKeng7A\nJ598Qvv27YmIiKBz58789NNP7uM1bdqU5557jnbt2hEaGsrWrVuxWCxMmzaNpKQkoqKieOONN/j+\n++9p164dERERPPDAA+7x06ZNo0uXLsec3+FwMGPGDHr37k1WVhahoaE4HA727t2LaZo888wztGjR\ngkaNGjFo0CDy8vKAP+5Yz5gxg+TkZKKjo3nqqacA+Oyzz3j66ad5//33CQ0N5eKLLz7L3T47FHAb\nsK1+JYwI38C/g/bzUdA+bgtfz25L6ckH1kM/xbXjYKC/ezmipBLLET+cBrosNKsK8kJlIiJyLnr/\n/feZNGkSeXl5tGjRgnHjxgGwbNkyADZs2EBhYSFpaWmsXbuWUaNG8fbbb5Obm8uf/vQn+vbti9Pp\ndB9v7ty5LFy4kIMHD+Ln5wfA6tWr2bJlC3PnzuXBBx/kqaee4ssvv+SXX37hgw8+cJ/rSEeev6Cg\ngOHDh7Nw4ULi4+MpLCykoKCA2NhYXn75ZebPn8+yZcvYs2cPERER3HfffdWOtWLFCjZv3sySJUuY\nPHkymzZt4vrrr2fs2LHceuutFBYWsnbt2rPS37NNAbcBmxq0k53WMvdyhrWUOUF7vFjRmet56VDe\nu6g3K5o0Z1lya+6wp9GlIpLIKiuNqmz0KW/MdeXR3i5TRETOAYZhMGDAAC699FL8/PwYOnQo69at\nq3H/t956iz/96U907NgRwzAYPnw4AQEBfPvtt+7j/fnPfyYhIYGAgAD3uPHjx+Pv70+PHj0IDQ1l\nyJAhNGrUiPj4eLp06XLK4fJ40xXefPNNnnjiCeLj47HZbEycOJF58+ZVm2c8ceJEAgICaNeuHSkp\nKaxfv959vIY+BUJzcBswh3nUX58JDlfD/CsNDvCjX5fb3ctBQUHMPhjHLksZNizEugJOMFpERMSz\nYmJi3F8HBQVRVFRU4747duxgxowZvPLKK+51TqeTrKws9/LxPgR29DmOXi4uLj5mzKnKyMjgpptu\nwmL5416m1Wpl37597uXY2Fj318HBwSe8xoamYaYhAeDekmSWBuSy3lqIAXRwOhhemuDtsjzGwKCJ\nS9MSRETONesL95DpOvOwlWSxkxIa58GKTnK+pCTGjRvH2LFja9zHMM7ec92Pd+ykpCSmTp3KFVdc\nccy2jIyM0z5eQ6OA24DZTSsf5nbg84AD+JkG11Y0IkCzTkREpIHLdBXR1/7dGY+fX3Q5KbU4/8l+\nPR8TE8PWrVtp1qwZAHfddRc33XQT1157LR07dqSkpISlS5fStWtX7Ha7x+s4+vwxMTHk5ORQUFCA\nw+EA4O6772bs2LFMnz6dpKQksrOzWbVqFX379j3peWNjY/niiy8wTbPBhl2loQYuCD/6lsdwQ0Vj\nhVsREZEzdGSQMwzjmGB35PKkSZMYMWIEERERzJs3j0suuYS3336b+++/n8jISFq2bMmMGTNOGA5P\nJTge3ufoeo4+f+vWrRk8eDDNmjUjMjKSvXv38uCDD9K3b1969uyJw+HgiiuuYPXq1ad0/rS0NACi\noqK49NJLT1pnfWSYDWwWcXZ2drVPJdY3QUFBlJae+pMMTExW2fLI9Cuje0UUMWd5rqnNZiM6Otrn\n+liX1EPPUB89Q330DPXRMw73sbb+k/97re/g3hjWstZ1SMOlKQpe9pfQjXwcuI9Si4ukykBez7+Q\n9pUOb5fl01yYWGiYv3IRERGRk1PA9aKdllIWBxyg1HLokR2Z1jKes29jzsH2Xq7MN6205TIh9HeK\njCriXAG8c/AiIk3/kw8UEZE6lWSxM7/o8lqNl3ObAq4XlRounEb1915X0aBmjNRbBRVOVn9cweU/\nNOaD6zNYdN0u1oTlu3+Y2EkZox2/MSO/Nh9DEBGRsyElNK5WHxIT0aeSvKhZVRCtK//4KTPcZaVf\nWWMvVuRWa4xaAAAgAElEQVQbKl0u9r8YwLCPWrC+2UFe6r2JFRF57nB7WI5fhZcqFBERkbNJd3C9\nyIqFOXntecq+hWw/J33KGnNjuQJubW3IK6HL700xMEi/agd5juMH2fiqwDquTEREROqCAq6XBePH\nE0WtvF1Gg1OYd5DcA5lExzQj2HHoLrhpujAMC0FWg0q/Q3drY/Oqh1jDhISqAM6vsvNiQZs6r1tE\nRETOPgVc8bosSxlTgncSZFr4U0nysa8gPsrS76fwc7O3mJtyFwX+vxBdFsTI0g8oZRtWM5BOjgf5\n8vIbuOnLJJ6Z0oF1zfPY0OwgtgDo6WzE84UKtiIiIr5MAdcXuSBsShj+m/zBD4p6FlF6bf18buIu\nSymDItaRYT1U3+cBOfwrrwPHe0HvJwH7+Wfg79wX8j5LjX+yPfTQmItLp7CXr90P/lrOMwy+vTPT\nLyvmvJXhvPFVe3KCiggMh0S9+ldERMTn6UNmPsg+307w8mBse2zYdtlwfOjAb7eft8s6rv8NyXCH\nW4BfbEV8GLj3mP2+8D/An0N/ps3Pv3DdvH+yP/SP63G4cqo91baYbIqM3fS6KILWfzKIuLWKFo4g\nhVsREZFzRIO6g1tWVobNZsNqrb9lWywWgoJqF6TyqeBHSz4XuxxEcPpvNgvMDMSo/CPy+eX7Yc+0\nU9GiAsMwKCkpqTd9tB2nBn+bP5aq6n38V1A25X7QOsvA5XSwPe6PEJzrF0cTfsHy30eshRJHXFAb\ngoyzE2jrWw9r4onvxbNJffQM9dEz1EfPOJXXz4rUhfr7X/FxBAYGUlhY6NOvUZxoWcP0iBwqLQZ+\nLpOhhY15quL0ngbo18QP2w82d8itclRRnFRMZWklNpuN8PBwiouL60Uf7y9P5JuIA2z/713ci5x2\n+hZG4gp0Veuj3WqADWJLD/BbQgmuI/4NXeYYgt1VSKfyXPwIoAt/h7JASjk70zLqWw9r0hBe6ak+\n1p766Bnqo2fYbDZvlyACNLCAey6YHZaN03roH4hKC8y17+Op3NM7RlG/Ivz2+eH/uz9YoLhHMZUJ\nlWeh2tpLcAXxYV4HpgbtIhALd5Y0IeQ4HzJ7tKgFHwXuZU+Ei2sLf8FihnH4qbYuw8pKx2jePNCl\nbosXERGRekkBtx6pcjmptFSfFl1lMXDhwnI606UtkH93voerO3tiXAH8vbh5tXUf+2XxqWMPFzjt\n3FnaBIdpZUN2Kld3t9F78wyu3ZzKF+fH4bIY+JkG/5fflgPmJj7jYcopIITG3MgbhBjRXroqERER\n8RZ9yKwe8bPYCC8tq7bOXu48vXDrA14JzuDBoJ+YF7SXp0O38mfHrwAEYWVicUt63DuY3eH+XJ65\nh4DKSu4vTqKLM4oF/Jm9rCOPbeziWxbwwGmdtwIXU4N28o+QbWRa6u+vAEVEROTEdAe3nnl+RSaP\nXp5AXlAAjrIKJq3Pg9berqpuLQjMpsByaEpFhWHyne0gZVQRiB/XlUczoCyGJY2tZAPdnQ7+p6Q5\nVWYFpeRVO04x2ad8zkpcDA1fx7f+B3EZ8GHgXqYevIg2VaGevDQRERGpAwq49cy1F99HSt5u9m/+\nmZjGHWnUOt7bJdU5wzxq2YCwHz/BsX4RlWExPNdvDPm2FlQBkeZ/P9Bg+BNkhlPIbve4YBqd8jlX\n2/L53j/f/eG1ndYyXrRn8Hb+RbW8GhEREalrCrj1UHRIAtEhCd4uw2uGlSaQZd1GtqWCEJcf0z5a\nTuT3qzAwsR7cTcxbo+Du6XDUfOVe/JNF/A9l5BNCY3rz8imfsxIXVVRP1uZRyyIiItIwKOBKrc1a\n9TY3bFmJ1eViXWwiHa+eSKDN/4yPN7gsnvZ+USwys7iw0s7VG97E+G/YNABLWQG2rN9wJl5QbVy0\n0YbbWHBG5+zkjKCDM4wfbPlgQFxVAPcWJ5/xNYiIiIj3KOBKrXy0+UeG//QlsUUlACQfLODt4Ne4\nuctDtTpuB1c4bUoD+GHjMlzlxUd9zM4Aw4MfvDPBv9LC3Lz2vBqyg1yjguGlCZp/KyIi0kAp4Eqt\nFOT94g63AIFVLpoW7D7BiFO3/JfP6f/5//3xTZrXBTPvalxhB3A2buWRcwSsDcAxx4FRZuCKdPHI\nwzZcYa6TDxQREZF669x6/pR4lOEsJ7oY9tqD3evK/CxkODwzf7jtmvfxd/03bO6/GTImYOT2wbJj\nBBH/jKLWU2QrwTHLgW23DWuOFf/f/Ql7K6zWdYuIiIh36Q6unLIVtlx+tBWQ4gwlGCsX/7iYUes+\n5B+XXU/vjO8PzcGNSeCGTvfV+lwv+P9O2pGvNM+9HqrCATBcBv5b/bEUWGp1t9VSYMFSXP1nPL8C\nvzM+noiIiNQPCrhySp4P2cY7wTspsFRh+e+d02ctW/kL8LfVn7n3S0y8koJafMAMYIO1gP/z3876\nbteR/uEcAqtcQPUga1pMTEvtbuG6wly4HK5qobYypn6+0lhEREROnQKunJSJyb8D91FgqQJwPyv2\npU5tuHn9b5yXexCASkdjijvcWOvzrbcWkmdx8sklUVwTMoInvlxKlG0pbX+9EGu+P64AF+Up5Zih\nZxBwXRC4MpDA7V9i8V+K8+LzcAXei6XCSmVMJfl3NZxXHIuIiMjxKeDKSZmA6zgTXrPCQxk08hYW\nL9yMv2lQeHkaVeFxtT7f5c4wGrv82W+pYGVrBzec358xRc2J3XSQwLWBOBOdlHcoP6MLiXgpgsCd\nCzDi/w+shcB3VLT6nuxBz4LVVuvaRURExPsUcOWkLBhcWRHBXss+yi2uQ4n3v3dx/cLjKe7VhxKM\nEx7jdJxfZWdiWWtet22jCpPOFRHcUZpIZVIlRUlFZ3xc604rAb8GYCR+9d9w+9/1Obuw5u6ksnEz\nT5QvIiIiXqaAK6fkH4WtaVtpZ40tnyLDhdNwEe3y54nC8zE8GG4PG1zZhP6Fp/6q3VNhVBlQBZjV\n79Sa1gBM/yCPnktERES8RwFXTomBwR2lTbijtIm3SzljziQnzvOc+Gf8GSNgJ2bgDkxrEGUtr/DI\n1AoRERGpHxRw5dzhBzljcgj9VyMsea9Q2fZHKlqH4Yxp7u3KRERExIP0ogc5t/hD4a2F5N9jUty1\ng8KtiIg0aEuXLqVJk9r/drV3797MnDnTAxXVDwq4IiIick7LyMjAYrFwww03VFt/22238dhjj9X6\n+NOmTcPPz4/Q0FDCwsK4+OKL+fTTT2t9XE9asGABw4YN83YZHqOAK/VTlRPbnk1Ys7eDWdt38oqI\niJzc6tWrWbVqlXvZMAwMwzMfpO7cuTOFhYUcPHiQUaNGMXDgQPLzj332elVVlUfOd65TwJV6x6go\nwT7zL0S9P5ZGc8cQ8Z9nFXJFROSs+9vf/sa4ceOqrTOP+P/P22+/TcuWLYmKiqJfv37s2bPHvc1i\nsfDmm29y/vnnExERwf3333/c4xiGwe23305paSlbtmxh0qRJ3HLLLQwbNoywsDCmT59OVlYWffv2\nJSoqipYtWzJlyhT3cUpLSxk5ciSRkZFccMEFfP/999XOY7FY2LZtm3t55MiRjB8/3r388ccf0759\ne8LCwmjRogWLFy8GoFu3brzzzjvAoTvOqamp/PWvfyUyMpJmzZrx2Wd/vLV0+/btXHXVVTgcDnr0\n6MF9991X7+7+KuBKvRO6fBa23b9hcVVicZYSsO17ArZ+5+2yRETEx91zzz1s3ryZJUuWuNcdvoP7\n5ZdfMnbsWNLT09mzZw/Jycnceuut1cZ/+umn/PDDD2zYsIEPPviARYsWHXOOyspKpkyZQmhoKOef\nfz4A8+fPJy0tjfz8fIYMGcKtt95KUlISe/bsYd68eYwdO5avvvoKgMcee4zt27ezbds2Fi1axPTp\n0094l/nIu9CrV69mxIgRvPDCC+Tn57Ns2TKSk5OP2e/wvq1btyYnJ4e//e1vjBo1yr1tyJAhdOrU\nidzcXCZNmsSsWbM8dqfbUxRwpV4ppYrc8gPV1llclfgV553egUwTXPo1j4iInLrg4GDGjRvHo48+\nClS/ezt79mxGjRpF+/bt8ff35+mnn2bVqlVkZma69/n73/+Ow+GgSZMmdO/enXXr1rm3ffvtt0RE\nRBAXF8f777/PRx99RGhoKABXXnklffv2BSA7O5uVK1fy7LPP4u/vT0pKCnfeeSczZswAID09nXHj\nxhEeHk5iYiIPPvhgtTpP5J133mHUqFFcc801AMTHx9OqVavj7pucnMyoUaMwDIPhw4ezZ88e9u/f\nT2ZmJj/88AOTJ0/GarXSuXNn+vbte8o11BUFXKk3DhpObor8kbuujGefPdi9vjIshrLml5107N1h\nP3NLxBq++nUq0dPupfG7dxPx8ZNQ5TzbpYuIiI8YNWoU+/bt45NPPql2V/LwXdvDQkJCiIqKYvfu\n3e51sbGx7q+Dg4MpLi52L3fq1Im8vDx3gL366qvd2xITE91fZ2VlERkZSUhIiHtdUlISWVlZ7u1H\nPjUhKSnplK9t165dNG9+ak8POvpaAIqKitz1BQYGurd74ikOnqbn4Eq98aR9Cz/Zivjp/CT+303d\n+dPqX2hXFY7/lXfgskedcOzI8A18759Ps5yDXL18MbaiEgD8CrJxfDODgm6jTjheRETqj4ysQvIK\nz/yOYESoQdP40DMa6+/vz8SJExk/fjwXXHCBe318fDwZGRnu5eLiYnJyckhISDjjOuHYqQHx8fHk\n5uZSVFSE3W4HIDMz032euLg4MjMzadOmjXvbkYKDgykpKXEv79mzxx1AmzRpwpYtW2pVb1xcHLm5\nuZSWlhIUFOSuob5NUVDA9TFGqYElz0JVoyrw93Y1p6fAUun+ev6FLZh/YQtePtiWm8tjTzAKCoxK\ndvqVAtB6fy5xRX/8h21g4ndw79kpWEREzoq8QpPZXzvOePzQrgU0rcX5hw0bxjPPPMNnn33mnic7\nePBgBg8ezJAhQ2jdujVjx46lU6dONd5BNU3zlH5tf/Q+TZo04corr2TMmDE8//zzbNq0iXfffZc5\nc+YAMHDgQJ5++mkuv/xyioqKeOWVV6qNb9++PbNnz+aJJ57g888/Z9myZVx22aHfgo4aNYqePXvS\np08funXrxp49eygqKqpxmsLxJCcnc+mllzJp0iSeeOIJfvjhBz755BP3FIv6QlMUfEjgqkCix0QT\nPSGa6LHRWLc3rJ9fBpbGEVVlcy83qwyie0XkSccFmxYCTT8A1sdFsyPM7t5mWqw4Y5p5vlgREfEp\nR96BtFgsTJ48mby8Pz7/cc011/D4449z8803Ex8fz/bt25k7d+5xxx9ePrzuRI8bO9629957j4yM\nDOLj4xkwYACTJ092T2mYOHEiycnJnHfeeVx//fUMHz682vh//vOf/Oc//yEiIoI5c+Zw0003ubd1\n7NiRqVOn8tBDDxEeHk63bt2OuQNcU01HLs+ePZtVq1YRFRXF+PHjGTRoEP7+9euummHWt1nBJ5Gd\nnY3TWX/nVAYFBVFaWlr3JzYh+i/R2Pb8ERDLzy8nZ1JOtd1sNhvR0dH1to8L/ffzftAeAv1s/P1g\nU5q6gk8+CJgbmMVL9u3kGZUM+ymDZ5asIbgKKuJakX/t3WB47me5+t7Dw7z2vXiK1EfPUB89Q330\njMN9rK21mwpqfQf34lZnPl5Oz6BBg2jbti0TJ070diluDesWn9TMCUb5UT9tldev+TCnoldFY3pV\nND70j7jr1P8Rv7UsnuvKo9lnKScpNpXioSMoPvkwEREROU0//PADERERnHfeeSxatIj58+czduxY\nb5dVTZ0G3NLSUubPn092djYA/fv3JzIyknnz5nHw4EHCw8NJS0tzT1qW0+APVdFVWHMP/ZWamFQm\nVJ5kkG+JMG1EHDHFQUREGqaIUIOhXQtqNV7Onr179zJgwABycnJo0qQJb7zxBikpKd4uq5o6Dbif\nffYZLVu2ZNCgQVRVVeF0Olm2bBnNmjUjNTWV5cuXs3z5cnr06FGXZfmM3P/JJXxKOJZ8C5XxleSP\nPPYVgCIiIvVd0/jQWn1ITM6uPn360KdPH2+XcUJ19iGzsrIyduzYQYcOHQDw8/MjMDCQTZs20b59\newBSUlLYuHFjXZXkc0y7Sd7oPHIm5pB/Vz7oZqaIiIicg+rsDm5eXh4hISH8+9//Zu/evcTHx3P9\n9ddTXFzsfs6b3W6v9lBkEREREZHTVWcB1+VysWfPHnr37k1CQgILFy5k+fLl1fY58hEUBQUFFBUV\nVdtut9uxWuv35+L8/Pyw2ervrdPD/VMfz5x66Bnqo2eoj56hPnpGfe+fnDvq7DvR4XDgcDjcb+Jo\n27Yty5cvx263U1hYSGhoKIWFhe5X0/344498/fXX1Y7RtWtXunfvXlcl+7SIiAhvl9DgqYeeoT56\nhvroGeqjiG+os4AbGhqKw+HgwIEDNGrUiG3bthEdHU10dDTr168nNTWVdevW0bp1awAuueSSY96s\nYbfbycvLo7Ky/j4dICAggPLycm+XUSOr1UpERIT6WAvqoWeoj56hPnqG+ugZh/so4m11+ruE3r17\n869//YuqqioiIiLo378/LpeL9PR01qxZ435MGPxxx/do9f0h3FartV7Xd1hlZWW9rrMh9PGMe2hC\nyKch+G/1p6JZBcV9iuEsPNGmIfQQ9L3oKeqjZ6iPIr6hTgNubGws/+///b9j1o8YMaIuyxDxqrB3\nwgj6JoissFLGdfuZ0mwno+JiuahKb90RERHxBM0GF6lj/hv9yQ2qoMdzS9iYfOhB5iuqspma144L\nq0K9XJ2IiEjDV2fPwRWR/7LA+90y3OEWIMuvnLdDdnqxKBEREd+hgCtSx4qvKSbEtGKpOrQc4Cqm\nVekqHOU/Ypou7xYnIiLiAzRFQaSOlVxXQo9MO1dkR/JT1Gb6H3yOqKo9WLDxb76kv/lutWdCi4iI\nyOnRHVwRLzCSXMw22jE69zOiqvYA4MJJBl+zm++9XJ2IiEjDpoAr4iU2LMSY1e/UVlFBBYVeqkhE\nRMQ3KOCKeFE7biOYaPdyNG1IpJMXKxIREWn4NAdXxIuaGd3pbf6TDczBRghdeRR/I8TbZYmIiDRo\nCrgiXtbU6EpTunq7DBEREZ+hKQoiIiIi4lMUcEVERETEpyjgioiIiIhPUcAVEREREZ+igCsiIiIi\nPkUBV0RERER8igKuiIiIiPgUBVwRERER8SkKuCIiIiLiUxRwRURERMSnKOCKiIiI+LhvvvmG1q1b\nu5ebNm3KkiVLPH6ebt268c477wAwbdo0unTpckbHqc1YUMAVERGRc9g333xDaGgooaGh2O12LBaL\ne9nhcLBr1y5vl+gRXbp0YePGje5lwzAwDOO0jzNp0iSGDRtW4/YzPa6nWb1dgIiIiIi3dOnShcLC\nQgB27NjBeeedR35+PhZL/bwHaJomwGmFyMrKSqxWz0S++hBeT0X9/NsTERERqWOHw+Nh+fn5jBo1\nivj4eBITExk/fjwulws49Cv0zp078/DDDxMREUGLFi1YuXIlU6dOJSkpiZiYGGbMmOE+1siRI7n7\n7rvp2bMnDoeDbt26kZmZ6d6+cuVKOnbsSHh4OJdddhmrVq1yb+vWrRuPPvoonTt3JiQkhG3btjF1\n6lTatm2Lw+GgefPmvPXWW+79ly5dSmJiIs899xxxcXGMGjWKpUuX0qRJk2Ouee/evYSEhJCbm+te\nt2bNGho3bkxVVdVJe/T555/TunVrwsPDeeCBB47ZfqSNGzfSo0cPoqKiaN26Nenp6e5tOTk59O3b\nl7CwMC6//HK2bt1a43FOhQKuiIiIyHGMHDkSf39/tm7dytq1a1m8eDFTpkxxb1+9ejUpKSnk5uYy\nePBgBg4cyJo1a9i6dSuzZs3i/vvvp6SkxL3/nDlzmDBhAgcOHKB9+/YMHToUgNzcXG644QZGjx5N\nbm4uDz/8MDfccAN5eXnusbNmzWLKlCkUFRWRnJxMTEwMn376KQUFBUydOpWHHnqItWvXuvfft28f\neXl5ZGZm8uabb9Z4jbGxsXTr1o0PPvjAvW7mzJkMHjwYPz+/E/bnwIED3HzzzTz11FPk5OTQvHlz\nVqxYcdx9i4uL6dGjB7fddhvZ2dnMnTuXe++9l99++w2A++67j+DgYPbu3cu7777L1KlTa3W3WAFX\nRERE5Cj79u1j4cKFvPTSSwQFBREdHc3o0aOZO3eue5/zzjuPESNGYBgGAwcOJCsriwkTJmCz2ejR\nowf+/v5s2bLFvX+fPn1ITU3F39+fJ598klWrVrFr1y4+/fRTWrVqxdChQ7FYLNx66620bt2a+fPn\nA4emBYwcOZI2bdpgsViwWq307t2b8847D4CrrrqKnj178s0337jPZbFYeOyxx7DZbAQGBp7wWocP\nH86sWbMAqKqqYu7cuSecZ3vYggULuPDCCxkwYAB+fn6MHj2a2NjY4+77ySefuPtlsVho3749AwYM\nID09naqqKv71r38xefJkgoKCuOCCCxgxYsQJ7wafjObgioiIiBxlx44dOJ1O4uLi3OtcLhdJSUnu\n5ZiYGPfXQUFBAERHR1dbV1RUBBwKqYmJie5tISEhREZGkpWVxZ49e6odFyA5OZmsrCz38tHTCxYu\nXMhjjz3G77//jsvloqSkhHbt2rm3R0dH4+/vf0rX2q9fP+655x4yMjLYuHEjYWFhXHrppScdl5WV\nVe2ajlfnYTt27OC7774jIiLCva6yspLhw4dz4MABKisrq409uh+nSwFXRERE6pXCTYWY+8787p0R\nYxDaKrRWNTRp0oSAgABycnI88oEz0zTZuXOne7moqIjc3FwSEhKIj49nx44d1fbfsWMHvXr1ci8f\n+ev68vJybr75ZmbNmkW/fv3w8/PjpptuqnbH83R+vR8YGEhaWhqzZs1i48aNDB8+/JTGxcfH8/HH\nH9d4jUdKSkqia9euLF68+JhtVVVVWK1WMjMzadWqFUC1+clnQlMUREREpF4x95k4JjjO+E9twvFh\ncXFx9OzZk4cffpjCwkJcLhdbt25l2bJlZ3zMBQsWsGLFCioqKhg/fjxXXHEFCQkJ9OrVi82bN/Pe\ne+9RWVnJ+++/z8aNG+nTp88fPTkivFZUVFBRUUGjRo2wWCwsXLjwuMHxdAwfPpypU6cyf/78U5qe\nANC7d29++eUXPvroIyorK3n55ZfZu3fvcfe94YYb2Lx5M7NmzcLpdOJ0Ovn+++/ZuHEjfn5+DBgw\ngEmTJlFaWsqvv/7K9OnTNQdXRERExBOODFUzZsygoqKCtm3bEhkZSVpamjvAHe95rycKZIZhMGTI\nEB577DGioqJYu3ate95rVFQUn3zyCS+88AKNGjXi+eef55NPPiEyMvK4xw4NDeXll19m4MCBREZG\n8t5779GvX7+T1nKi+jp37ozFYuGSSy6pcZrB0dfdqFEj0tPT+fvf/06jRo3YsmULqampx903NDSU\nxYsXM3fuXBISEoiLi2PMmDFUVFQA8Oqrr1JUVERsbCx33HEHd9xxR401nArDrM0MXi/Izs7G6XR6\nu4waBQUFUVpa6u0yamSz2YiOjlYfa0E99Az10TPUR89QHz3jcB9rq2BZAY4JjjMfP7kAx1VnPv5s\nuP3220lMTOTxxx/3dik1uvbaaxkyZEitw2V9oDm4Ig3MenM2mawgmtZczv0Yhn4RIyJS39X3+4nf\nf/89a9asqTantiFTwBVpQL4xn2EN7+KkmN9ZQDa/cSOve7ssERGPMmIMCiYX1Gp8fVNfXmF7PCNG\njODjjz/m5ZdfJiQkxNvleIQCrkgDsp2vcFIMgAsne1hDlVmBn3Fqj4IREWkIQluFQitvV+FZU6dO\n9XYJNZo+fbq3S/C4BhVwy8rKsNlsHnuf8tlgsVjcz8KrjwzDoKSkRH2sBW/20K/UD474LZcFP4KD\n7FiMY982U597CPpe9BT10TPUR8+or3co5dxTf/8rPo7AwEAKCwv1AYBasNlshIeHU1xcrD6eIW/2\nMMW8nXyepIRsAgijNf0pL6s47r71uYeg70VPUR89Q330DJvN5u0SRIAGFnBFznUXGmnEmBeSyQpi\naUeCcZm3SxIREal3FHBFGphoow3RtPF2GSIiIvWWni8kIiIiIj5FAVdEREREfIoCroiIiIj4FAVc\nEREREfEpCrgiIiIi4lMUcEVERETEpyjgioiIiIhPqVXAPXDggKfqEBERERHxiBMG3MjIyGrL11xz\nTbXlZs2aeb4iEREREZFaOGHAPfp93GvWrKm2bJqm5ysSEREREakFzcEVEREREZ+igCsiIiIiPsV6\noo1lZWUMHz7cPRWhpKSk2nJ5efnZr1BERERE5DScMOCOGzcOwzDcgXbMmDHHbBcRERERqU9OGHAn\nTZpUR2WIiIiIiHjGCQPuYZ9++inffPMNeXl5REZG0qVLF3r37n22axMREREROW0n/JBZRUUF1157\nLQMHDmTVqlUUFBSwfPly0tLSuPrqq6moqKirOkVERERETskJ7+C+9NJL5OTksHHjRpo0aeJev3Pn\nTvr168cLL7xwzLxcERERERFvOuEd3PT0dP73f/+3WrgFaNKkCS+99BLp6elntTgRERERkdN1woD7\n+++/c9lllx13W8eOHdmyZctZKUpERERE5EydMOCapklQUNBxtwUHB5+VgkREREREauOEc3CdTifv\nvvsupmliGEa1baZp4nQ6z2pxIiIiIiKn64QB9/LLL2fmzJk1bu/UqZPHCxIRERERqY0TBtylS5fW\nURkiIiIiIp5xwoC7bdu2Y9bZbDYSEhKwWE44fVdERERExCtOGHBbtGhx/EFWK7fccguvv/46YWFh\nZ6UwEREREZEzccLbsC6X65g/5eXl/Pzzz1T8f/buPEquss7/+PvW2rV2d7o7SWffFwJZSNiDIRAg\nEBcWQUdZFBTBZQZHnRmPI8M4Ikd/KOqI4jJgiKIQRAJKZE9IE9aQBUIWCFk7e6/VVV3rfX5/NKmk\nSaLi4JMAACAASURBVHcn6VRXdVc+r3M8h7p1761vfU9Z+fRTz31uMsm3vvWtfNUpIiIiInJUuhzB\n7Yjb7WbcuHH85je/4ZRTTumJmkREREREuq3bE2lDoRCtra25rEVERERE5Lgd8wjuAQ899BCTJk06\npmPuvvtuvF4vDocDh8PBTTfdRCwW45FHHqGxsZGysjKuuuqqTm8uISIiIiJyJF0G3GuvvfawbalU\nii1btrB+/XoWL158TC9mWRaf+9zn2t0FraamhlGjRjFz5kxqamqoqanhwgsvPKbzioiIiIgc0GXA\nHT16NJZlYYzJbnO73cybN4+5c+dSVVV13AVs2LCBz3/+8wBMmTKF3//+9wq4IiIiItJtXQZcr9fL\nt7/97Zy+4AMPPIBlWcyYMYPp06cTjUYJBoMABINBotFoTl9PRERERE4sXQbcH/zgBzkNuDfeeCOh\nUIhoNMoDDzxAZWVlu+cty8r+d3NzMy0tLe2eDwaDuFzdnjacF06nE7fbXegyOnWgf+pj96mHuaE+\n5ob6mBvqY2709v7JiSOvn8RQKARAIBBg4sSJ1NbWEggEiEQihEIhIpEIgUAAgBUrVrB06dJ2x8+a\nNYvZs2fns+SiVV5eXugS+jz1MDfUx9xQH3NDfRQpDl0G3HQ6zX333Ycxpt3oKpDddsMNNxzVCyWT\nSYwxeL1ekskkmzZtYtasWYwfP57Vq1czc+ZMVq1axYQJEwCYPn0648ePb3eOYDBIQ0MD6XT6WN5j\nXnm9XhKJRKHL6JTL5aK8vFx9PA7qYW6oj7mhPuaG+pgbB/ooUmhdBtxUKsWCBQu6PMHRBtxoNMqf\n//xnoO0OaZMnT2bMmDEMGjSIhQsX8uabb2aXCQMIh8OEw+HDzrNv3z5SqdRRvWYhuFyuXl3fAel0\nulfX2Rf6qB7mhvqYG+pjbqiPIsWhy4Dr8/l44YUXcvJC5eXl3HLLLYdt9/v9XH/99Tl5DRERERGR\nbt/JTEQk14yxC12CiIgUgS5HcIcNG5avOkTkBLbPrGcxtxKnAZ+p4KPcQ7k1stBliYhIH9VlwF27\ndm2+6hCRIuDZuorgikWAoeW0K0gOnXxUx/2Dr7OXtwBoZgeL+Rc+w+M9WCmsML9jLY8Ahgl8gtOt\nL/fo64mISP50GXCHDh3a5cGWZbFt27acFiQifZNrzybKnvoZrpb6tsf7t1F/+W2kq0Z0eZwxhjhN\nYGDUjiBNoSRJ8zarWr7C1GH39EitW00NL3M3cRoBaGI7FWYco605PfJ6IiKSX10G3COtoCAicoB/\n7XPZcAvgaqnDt+4FIlWf7/I4y7LwU0l57X62D4iR8rTNw11e8jcG7jmXgQM+nfNaN/NcNtwCJGhi\nM88xGgVcEZFi0GXAffjhh/nlL3+Zr1pEpA/LhPtjsLAwABjLSSZUdVTHfoxf8bw1l5Tn4K26Y740\ntfufZSC5D7gDmYYLP2liALgoYSCn5vx1RESkMLpcRUEjuCJytKLTPkpi2BRsdwm220di+BRiUy45\nqmPD1mDGmUtxpw5+JfniTqq952UfW/EW/KsX43v7OUgnj6vW8XyMk7maMEMJM4ST+CST+ORxnVNE\nRHoP3TRaRHLD6aL+yv/Ctb9tXn66chhYR78S4cQhd7Jvxzo2h9ZjYTGp6RwGDb8GAEesiYqF/4m7\nbhsGC/9bT1N31f+Ay9OtUi3LYg53YJv/bju/pa9CEZFi0uW3ejKZ5LbbbsMY0+HzlmXxve99r0cK\nE5E+yHIc8aKyTg+1HMwa+jgfMTaW5YCyg88FX/4T7rq24Gxh8Oxaj/+dJcQmX3Rc5SrYiogUpy6/\n3Y0xbN++vdPnLMvqkaJE5MRldTDqa31oSoIFkI7npyAREelzugy4Xq+X+++/P1+1iIh0qGXG5Xi3\nv4WreS8AqX5DaZ14HrWOOA2OFKPTfnw4C1yliIj0Fvp9TkR6vUzFUOouv43g64+C00XkzE/z4/Ry\nFgQdtHjcjLD9zG+cwiC7pNCliohIL9DlFSAzZ87scHtdXR2/+MUvOP3003ukKBEpXlZrM6GaBfiX\n3A+R+iMf8IFMxVCa5v4LTXO+TGT5b/lD/xR7fS5iTsM77ijfDW3swapFRKQv6XIEd/Hixdn/TqVS\n/P3vf2f+/Pk8+eSTDBkyhJtvvrnHCxSR4mG1Rqh8+DvZC8bY/DrW1XeAJ3jU53DvWEukeRsR79R2\n26NWJpeliohIH3bEKQpvvPEG8+fP589//jMAl112GSUlJSxfvpwBAwb0eIEiUjwCq548GG4B9m7B\n99qjJGded3THr3icwOuPEEi2MKauiTWD2m4kEUhmOCdZ3hMli4hIH9TlFIVJkyZx6aWXEo/HefDB\nB9m9eze//e1v8fv9WkFBRPLKSsUJrHwCV6wJfzrD3+9fxGVvv8cFm3by9d0BvhobXugSRUSkl+hy\nBLe1tRW3243P58Pv9+N06iplEem+6LR5+DbWHBzF7T+C1jOO7g5iViLWbrmwIc1RHvnLcuou/y7p\nAaO7PNYRa8RVX0u6bCB2sOKIr1X697so2bYG21NC7LM/gpKyIx4jIiK9R5cBd9OmTbz44ovMnz+f\nSy+9lHA4zBVXXEFra2u+6hORImJKguy/+gcEVj6B04LAxTdiWtOQSh3xWDtQRqZ0AM5YY9u5HC5a\nx888Yrj1bnqN0mfugdYmmsLlWGdcg0lfSuCZAMZhiHwyQnp4Ort/+WN3UPL+a1iAs7WJ0G+/RPRL\n88GjFRpERPqKLqcoWJbFrFmzuO+++9i1axd33nkn77zzDpFIhNmzZ3PPPffkq04RKRLGF6Ll7M8Q\n+8j1EDyGebOWg7rLvkts/Eziw6bQMuMyms+74YiHhZ/7NY+MqWLa1/6JJ/pfwJanfJT+KkTJyhJ8\nK3z0u7uMQM1iwi/8FnftOry1azl0ApaViuPd/taxv1ERESmYo14H1+/3c80113DNNdewY8cO7r//\nfn72s5/xla98pSfrExHJMr4QjfO+BYCVjFG2+G6ckTrSZQNoOv9mcHsPOyaejvLf589l6bcnU1V7\nJpbtO/SMuELfJfzqi1hWGt+GGrA/vBqDRSagC9hERPqSLkdwOzNkyBC+9a1v8d577+W6HhGRo1L+\nxA/xr38Rb+1a/Gufp3zxTzrcb09ZGfNWWlTtnJENt7aV4S/Xf5VNkx7BBFdiWW1TFJyxRtLBKozD\niQEMkBkwivTAMXl6VyIikgu6k5mI9D3G4GrclX1oAa76HR3u+uSsi3Bt90Lm4OjuE5/+d1aesYBL\nH/8C1oh4+1MHwuy57Dv4NtaQ7jcEx+TzQdcdiIj0Kd0awRURKSjLwrjaT0f48OMDHp40kl/NKSFa\nujW7beeIV7nx78MxFX8HK5HdbtseWqbMwy6vJnrGVSTGntUz9YuISI/qcgT3ueee63S922Qy2eF2\nEZGeFjX7efucOGcsdRJodWL8lTTP+nyH+zqB5oDFhN++xqLv76cs6mVo0kVFvZ94xWv4M3Z23yav\nn8S4s/P0LkREpKd0GXBvvPHGLm/oMHy4FlYXkfxKmhYW8in2j17PC0MdDIwM5IzwlxjmOaXD/b/R\nMpL3na3sqIhz7o83c9mukXx8TQi3HWNHv1b67Tu4b1PYiSdP70NERHpOlwF3y5YteSpDROTobGEZ\n+1kPQMJjs7ViJx4eYhhzOtx/RrqMvzRM4zlvHZX7y9i++W+snvAP3nddSdz046svr6F/LE69r4Td\nJ3+EYbpLo4hIn6c5uCLSp3hNAGem/VeXi47n3x4wxPZxfesQrA1DGOy6l4jPyQsjxvHFN95hW1mI\nJSMG8W5VBcNPurInSxcRkTzRKgoi0qec/Nwa1o4MsX5EE7YT+jeGmVX2naM61kOcYVt9nLxuJrX+\n9xna1MLQppbs843vvkRs8tyeKl1ERPJEAVdE+hTvvi3c8NYYNg5rptWbYey+YbT8U4B292/oiJ1h\nTsufKFk/hODmGzhp7E/bPW0A2+3vsbpFRCR/FHBFpE8xLi8OLCZsKwUgXRqk2XN4ul3hauK74Y3E\nrAwj0j4e/9/f4d2/jSRu3BmLskT8sGPiWkFBRKQoaA6uiPQpjRfcTKpiKLbHT8YbonXYVLDaf5Ul\nsfnX0nWsdkd41xXj/ch7uOu2YwFeUliVf6XDS8mc+ptfRKQY6NtcRHo3Y3Dt20x42XwsO0N89BnU\nz/s3Kv76PVyRfQTXPoO7ZR/1l/1nNujudSSotw6u1V0VjWEZc/CcofVg0+5P/HSgHxgDWkVBRKTP\nU8AVkV6lxY6zbvmPmbpxA5WxVixPkJJEDEeqbUqBa88mfOuW4Iq0LWBr2Rk8W1fjqV1HcsgkACpt\nD2XGTT1pAN6uriLi81H6wS13De0HfW0c4PXT/76bSVcMoX7ev4G765UZRESk97KMOXRYo3eLx+PE\n43F6c8kOhwPbto+8Y4FYloXH4yGZTKqP3aQe5kZnfXztqe9w/huv4+7iWDvYD0dLffaxwaLl03eQ\nHj0ju+0F5z6+W7KOqJVmmO3nwa2VDFz0E4g14YhHsoHZ4MB4SnAkYx88huTUS4jN+zrQd/vY26iP\nudEX+lhWVlboMkT61ghuSUkJkUiEVCpV6FI65fP5aP1glKg3crvdlJWVEY1G1cduUg9z47A+ZtI4\now1U76plW1mI0Y0RUpaFy5jD5ssmKkfiMQZntAGAVP9RRKrGwCHv90yCPNNyGgaDhQVB2PvZHwPg\n2fwm4eUPYtkp0qH+eLe8mT3OAkz9rmzv+lwfeyn1MTf6Qh9FeoM+FXBFpDi59m6h4tH/wkq0sKW6\ngrqyEGWtcSoShwcNYzmInHstjkQM/5qnsL1+Iudc0+mUAquDy8mSI09l/8hT255vbabqj9/E0byn\n7fxYpMsH5fDdda7JbOdp/o0kLVQwjgu5E6elmwWLiBwvBVwRKbh+f/1vnLFGAFyZNAmfh/qAr+OA\n63CBMSSHTMrOuT0exhem6YKbCNX8ESuTJFU5nObzbjju8x6JbTI8xo3sYy0Au1gJwFx+3OOvLSJS\n7BRwRaTgHPFI9r9P2tfID08aTdzpZFhjC94PzTdMVw0nXTE0p6+fGDmDxMgZR94xh6LsJcqeQ7YY\n6tiY1xpERIqVAq6IFJxxeSDTNlrrS2c4a/teMsbm+7On87mVGwi2Jtgf9DOybCJNF36FVqeDf/e8\nyuxXluBP2ww45VNM9Y0q8Ls4Nj7KcRMA9me3eQgVriARkSKigCsiBdd03o2UPXsvjkwS43Bydul0\ndp5zFf2e/C9aPV4i/gADR15A42lXAfA9z5v85+9/w9TdbeFw61vrKCsdgQNIDJ1M9PQre/16ti6r\nhHPMN1nOXSSJEmQgF/H/Cl2WiEhRUMAVkYKLT7qAfYNPwrPjHVL9R5LuP4oQEProjyCdAqcTk2zF\nVbeNTLg/095Zng23AMObmqBpNQCenevBgujpnyzQuzl6J1lXMM5cSpwmAlRhWbq5pIhILijgikiv\nkCmrprWs+vAnXG68G1+idNkDOFqbyPhLKRvbv9PzONIJvNve6hMBF9pGcoOUFLoMEZGiouECEend\njCG8/E+4mnbjSLbibtzN5LpXWTsg2PkhHgVGEZETmQKuiPRuxsZKJ9ptWj59K3+8chlN/mT7XYFk\n5XCazr8pjwWKHD/P1pWUPvVzgq8uBDtT6HJE+jxNURCR3s3hJF06EFfzXqAtxNqWIe7N0BxMURo7\neGOETLAf+z/9Q/D4ClSsyLHzrX2e8Iv342xtxlgOPLXrqL/8u73+QkmR3kwjuCLS6zV8/NvsPekj\nrBo0gAww5d1yfK1O3phYR0tJ2/JitquE+JizFW6lz/GvfRZnazMAlrFx73kXZ2RfgasS6ds0gisi\nvZ7x+rl3ynC+/dAyXMCslQMJRd2snubl9XlTmL5lDOnqCcTHnVPoUkW64UMjtZYD43AWphSRIqGA\nKyLHJwOOFgd2yO7R34SimShu22Qfn7qxghHWWcTn/Qctw3vudUV6WsuMy3E27sTVUo/tdJMYNhk7\nWFHoskT6NAVcEek2zzoPpf9XiiPaFnAbbmkgPTLdI6+1fsxEVlVXMnVX2/q3u8IhzLRP9MhrieRT\nYtQM6q+4nZJ3XyZdPpj4+JmFLkmkz1PAFZFuC88P497pBsDZ5KTsd2Xsv2P/EY7qnjsSU/n65z7H\ndc8+SziZomTK5ZxSObFHXksk39KVw2mp1E8RIrmigCsi3WPA2dB+nqBrmwsyQA9MH+xnPMxPnEv6\n3HNw6frYPsVR78DzlodMaYbklORhU05FRHJNAVdEuscC60PLdVoZi/K7y2n4ZkOPvazCbd/i2uKi\n3939cO1z4XP5iJ8Wp/GrjQq5ItKj9C+FiHSPncH4NrXbZGHhft8NyU6OkRNO+OEwrn1tYymOtIOS\nNSW4dmpsRUR6lgKuiHRLybsv4yj/DZBq/4SLvH6z7DcbeMLcwhPmFvabDZ3uZzCdPic96MM35Upz\n2EdGRCTX9Ge0iHSLI96CVbYUBt4Pe64F48WE3iY5LQPOKvKRchvNFh7leprZDsAuVnK1eYgy6+DF\nOo95d/OzwBYSls3YTIB7G0/G1xOThKVDsY/EcG9x44y09Tw1LEV6SM+stCEicoACroh0S3zsWaTe\nfBw3v4WyFzGeKKZkLyURB/3+MqHtVqPOnv2KWcUD2XAL0Mx2VrOAWfwnAPutJHcG32eHKw7AVmec\n20Pv8sPIhB6tSw6KnxPH+A2hl0Mkg0kiV0f0L4+I9DhNURCRbrH9pdRfcTux8R8hNTwOnlocdhJH\nOo53+xr8q57s8RpKKD1sm/eQbVtdrexxJg4+acE2Z7zH65L2EtMSRL8Rpfm6ZkyJpoqISM9TwBWR\nbsuU9qdx3jdIDJuMdcgcV8vYOFt6Zj3cQ03nJqqZTtsl+RbVTGc6X8g+PzLtpzrjzT52GBid9vV4\nXSIiUlj6oUhEjotn0+uUrF+KsSws0xZy08EKWk86P2evsd4sYjNLqGYaU7gWy2pbY8pt+fiUWcgW\nlgAwgvNwWQcDbT/j5vuRcfwo+D4Jy2ZiKshtLWNzVpeIiPROCrgi0m2erauoeOJOLPvgpfKZkiCN\nl/wr6aoRx3XuevMeDWxmG8tZw5/Y7/TiYDm7M2uYy13Z/VyWlzFc3Ol5LkhWckF95XHVIiIifYsC\nroh0W/C1R9uFWwC7JExy6MnHdd7nzW2sYgE2SbAt/lb+ZbZ7TgLL4oXkTs5vTOOx2r6+jDGAwbI0\n40pERNoo4IpI93VwNypTEjiuU+4161nJ7zEfLKC6vuQs3i85FV8mgteO8r57JPcGtnNjtIxfcTBI\njzQXcAXzs9MX8mGLI8Y3S9fTbKUZlvHxs+aJBIy+VkVECk3fxCLSbdEpl+LeswlnooX6YIKHLt5O\ndHCCfuYbXMidOC3PMZ/zNf4XR9om42q7FXC9ewBX132f/unNACTxkoy5+ZWvpV3A3sxzrOC3zOCm\nXL29LhkMXyp7m7fdLQCsdbfgAH7TdEpeXl9ERDqngCsi3ZYYeyYNvjDedc/xu7MWsDvQCDSyk7cB\nmMuPj/mcscg7jKwP8N6wFgwwOfo8AZqyWdaRSIMv0eHo8Xs8fdQBN23iNLIVP1X4rX7HXGeTlWaf\no/09ibUEmYhI76BJayJyXJJDTmLXnKtoDhyy3iyGOjZ263ynrq/gC4vGEoq6wAnVTdFslt3gmU4A\nu9NjRzDrqF6j3mxiAZfyIJ9gARezwtx3zHWGjYvQh6YjlNoaMxAR6Q3yGnBt2+bee+/lwQcfBCAW\ni/HAAw/w85//nAceeIDW1tZ8liMiOVJCGW7az731EOzWuUKBKbgzDm7900RGbw/iNBYHltjNWB4s\nu4MbBRiwcHCm9bWjeo3n+E/q2ECSCBF2soJfkzTRY6rTgcX3ImMZm/ZTnfEwJRniJ826Q5qISG+Q\n1+GGV155haqqKhKJtpGempoaRo0axcyZM6mpqaGmpoYLL7wwnyWJSA64rBLOMd/gJX5MiigBBnAR\nPzrm81ixJiYv3UCrJ01Zi4evPDKBjNPFXV9qYI93AynLS8LXNjf30D/P+yVHckNJTfuTZVKEl96P\nq6GWTLg/Ted9Adxta+SmiLXbNUUrcRrxcGwXyM1KVvBCXT9asfHjPOb3KyIiPSNvI7hNTU28++67\nnHrqqdltGzZsYOrUqQBMmTKF9evX56scEcmxk6wr+TzPcy3/4FoWU2oNPeZzVD70HzjjEfxJN9YH\n90ZrOfOfuLbkecZwMTvdY0jgwzjBFQd3HGaZOw8Pt0DZ4p8SWPUkJVtX4X/rafr9/WDgHshUHIf8\nfR9mMEEGdut9W1hHDLeuuu1431+BI9bYrdcQEZFjk7cR3KeeeoqLLrooO3oLEI1GCQbbfsYMBoNE\no8f2E6GI9C4uq4QQ1d0+3hFravfYAhyptgu3LrPuY2TkYX7g/zSDki9R6d/JWHMqw5nR4bnc+7dk\nbx9s0RYyMQYsi/O4DQcudrOaEsJcyA9xWD0zAht86Y8EVi/GGY+QLh1A/SXfID1ofI+8loiItMlL\nwN2wYQOBQIDq6mo2b97c4T4fXruyubmZlpaWdtuCwSAuV+++iMPpdOJ2uwtdRqcO9E997D71MDc6\n6qMd7IczcfAPXeNwkpxyUfZ9zOCz/CF5CX9If5w6WtjGizzG5/ik8w8McEz60At4D3vs9hxYtszN\nhXzvqOo8nj5aiRjut1/kj2Xfps4zGH8mwuUvPYz7M8d3I4xD6fOYG+pjbvT2/smJIy+fxO3bt7Nh\nwwbeffdd0uk0iUSCRx99lEAgQCQSIRQKEYlECAQOzn9bsWIFS5cubXeeWbNmMXv27HyUXPTKy8sL\nXUKfpx4eo5qHSC/7A5bDjfMzd8DQiQCUp5rg8bshnYIJZ8HaJDTXgcuNNe+fqRg/td1pXm55jLqm\ngys0NFPLavf/8dl+C6BpH+zZDP2HwUe/Co/9P2jaC+FKXBd/kaqqqry+ZXZuZH74Vt4KXZDd9GCq\nH7f2QB36POaG+ihSHCzTdp/LvNmyZQvLly/nM5/5DE8//TR+v5+ZM2eybNky4vF49iKzzkZwM5kM\n6XQ6nyUfE6/X224aRm/jcrkoLy+noaFBfewm9fDYuV59iNSqe+nf6AMg4kvjHH0n/scHYQbfhuWt\nBcB2+4ieew3JcWdjB8rBdfiNIt7O/IUnMl+BQ5YLm+L4LJe9eznBF36HI7IfO1hB9NzrSI49A2f9\nTjJlAzGBsm7Vfjx99Kx/iftWTqC25ODqCqWZfdxwGXhyNLygz2NuqI+5caCPIoVW0N8SZs6cycKF\nC3nzzTcpKyvjqquuyj4XDocJh8OHHbNv3z5SqVQ+yzwmLperV9d3QDqd7tV19oU+qodHb23zTziv\nsSL7ONQSxPx5Irj2Y3l2Zbc7Uq24N68kMvWjbUuDdVD/GDOXIZzODl4DbCoYy9n2t/C/fAfOyH4A\nnC11+F59hJaJ50H/0W0HdrMXx9PHHSXgMe1XbHA7Ddjp7pbTKX0ec0N9FCkOeQ+4I0aMYMSIEQD4\n/X6uv/76fJcgInn0lquZMTs/NBKbrMYky3jhk5/nrE0pfCkn74xs5Mmza0n536fcbGcev+jwVr9O\ny8NV5k9s4AmSxJjAxyixyojZCUoP3TGTyl5Ulm9Wi8VPdyzm/6bbfH376/TfGaTVUY7XkeIjMwpS\nkojICUWzwUWkx3w/+B5/9NXyXMiG3Yc84d7LU9dfwfPnLcHyD2bi5jB/mb2NhtIk0Mo+nsTP7czh\nB9lDImYnzdTSjzH4rHJO4srsc/utJK8MKeOjDbvw2Ia0BesG9qeyEOE2YWH/PMPvv5emLujnPz8x\nkbLoi5xWG+e+0GU4HLqBpIhIT1PAFZEe0WSleKxkD82ODLd/5CL+uull3HZbuGv1NbN13E4yLsMT\ns3bw/GlOoiWZQ4421PN+9tGb5n5e4xfE2E+YIcw1dzPEOj37/DuuFq65+gLuKPMxaU8dGyvLeOb8\nj/N/7afx54XnHQ8Nkb3UBw6u4tAYKGHZSDeZet0fXUQkHxRwRaRHxC2b1AcXgp22xbB1QJTnz9iF\nAc5dNRh/+mAAjPozWHb2jrwAlDIMANukWcFvaflgCLiRLSzl+3yWx7P7Drd99LNK+I9LZ7ZtMHBd\n67HdlSxXjMcwYucovOlXSR/yDeu2IVq/niAWrvIJmqcgItKDFHBFpEf0tz2MSwfY72hkYHwbD176\nPo3htotjdlXF+OR719Gw7zHq/BFctpMhiUnsrmwhTYJ+jOF8/huANHEyJNud2/7Q4+EZH7fEhvF7\n3w5Sls3YdIDbImPz80YPrcvA+/1h3GiLea8O5uGP7AbLwpmxueuVH/GX6k1kHIYBe/ozr/8LuBz+\nvNcoInIiUMAVkR5hYfFA4xR+ENzEppOTpP0Hr/xuDqZZeVITXxu0nR3vPQ/u/riqhhDdu5z06l+S\n8XoxpzdBiQ+PFSRshtDCgdUWHAxk2mGv96XYMG6MDSGJOeKtc3tCxoZHX62gtt6NNc3i6tfPhSEv\ns3FQhM+ufJytwzbQ6mubhtHs38HL+27h3AHz816niMiJQNPBRKTH+HDyPy3jmO2fg2UO+UneQMg3\nDofXj6//GbiCQ0isXUDFou8x8a0IJ7+xB9/DN5JK7CNl4uzlnUPOapOk49t6u3AcVbh1NDsIPRwi\n9HAIK3KwLoPhldh6FsZeZXeq/pje69vb/Gyv82AbBxnL4uVyL1fVTufvzTM4J9aYDbdtBUCzo/aY\nzi8iIkdPAVdEelwl43FYB28v6rS8TOTydvuk31lAv8jBebkD9rtoWfdLtrKU9IcC7fs81+1aHM0O\nKv6ngtBjIUKPhaj8n8psyP1OyyKuHbSVW0dGuTL4Eqti7x71eaMJJ3DovFqLWLLtK7ZqwKcoO+S9\nuZMOBnkv6vZ7EBGRringikiPe4sH282jzZBgI39rt49FBzdVtByUUEr74Ng2/aG7AosDuGsPPFDm\nhwAAHl1JREFUhm33DjfBxUF2tdby5AA3MW/bc1vKAvzYteaozztpSIyw7+AdsILeDJOHtd3kwd//\nHOZGv82w/f0ZUl/Faa2fZGroW91+DyIi0jXNwRWRHldC+1t3WjgJUNVuW6hkMnWhtVR8MNK5pyJB\naOJXKbfKsRmEZWqxABsH53BbzmtMpGKknO3/5rc7Ct2HythU/fo27NR7LJ+1mdKTz8e77TuEGcqM\n0S30Lz0YeIdUf5Gr+WLO6xYRkcMp4IpIjzubf6WW19jNaiwcDOUsJjmubLdP5pI7sZb8kHcjr2I8\nfryz78XtKWetK8L9ZT9iVOuTVKa3s9p3IS3pqUzr5hq30UuilLxRkh3FTQ1O0XJJC0P9wzl5/ypq\nhrYF7PJYnE80+Gh/e7T2Btx1O7jW8JurNrBpaAvwAJ6qvzDeupXB1pe7V6CIiBw3BVwR6XEeK8Cn\nzCPU8jpOPAxiOg7rQ18/Lg/pOd/l0NVrG5b/M++7XDR/7KOsCs7Nbt9p4t2uxQ7b1H23jsDitleK\nXhLFhAxOPPw+NYefrH2KPV6Lj7aUclH13E7P42h24LA20RhOsrviYD1JK8omnuV0FHBFRApFAVdE\n8sJleRnOzOzjSMPrNNZvxOM5Dbd35GH71711B2NXvE+ZL8zwc5rY2q9tKDWYSHFust9x1WKHbSKf\nihy23VdSzndKPt32IHSEkxjA9uBOOXBm2s8JdujyBhGRgtK3sIj0GBuD6WAe69ottzKfy/mV/+s8\nEL+Q7bt+d9g+vq1rKEk5Gdwc5fcPP8O579dy1padfHPpCj5XX5aP8rtkh20y+35EIBpgysZyShJt\ny5OFGco5/HuBqxMRObFpBFdEci6JzZdL32atqwUPDr4YHco18cEAGDvFa2V/JxJoW1WhIdzKS8mf\n82m+0O4cifL+pK0tuIyD8zbX8uKvH2k73nKwe9wRLv7qYc76WkofeRErdQn2hsf4+K63mHTWHrZ/\nsoGhnEXQGlDQ+kRETnQKuCKScz8IvsdT3v3YH/xy/5PgZmYl+zHU9mFnWsk47Hb7ZxyZw85ReuZd\nbK27hqGb47gzFtYHC4mlSwdifEeaP9BzrNYI/f70O9yv3Q6pagBsczYVY6MErUTB6hIRkYM0RUFE\ncm6zszUbbgH2OJO852q7WYPTHaZ/tJIDMxecaRgcH33YORxOL76PL2T3jfeSKh+E7XRh+8I0XPKN\nfLyFTnl2rce1dWI23AI4WkvwLfcVsCoRETmUAq6I5NzEdBDXIbMIBqW9TEgfHHW9pOoZTt95GhP3\njmDm3ouZNeivnZ6r6oU/4GnYhSOTZv3AbSyr/zzr7Md6svwu2YF+GP9esA6unGCwyVQcPgotIiKF\noSkKIpJz34qOYo8jyWp3M24svtYygmr74K1qXc4g8aFjqXe0UJfejo+/cDJXd3guZ2QfAM+ctosl\nM3bTWpLBbb7JLrOS863/zsv7OVRqwGhaz3bga6jBapgOuEmOtYhccfiqDCIiUhgKuCKSc04s7o5M\n7PT5l/kpb9sLse0UAMu4kyHmDMqs4Yftm/G1rZiwalw9rSVto6Qpq5VNPMNsczuW1f3b9nZX00Vf\npuW0Xbh2vUs6NJjMYEu/h4mI9CL6ShaRvNvLWmxS2cdR9rKb1R3u2zT3n0kMnoRx9q6/xzPl1SRO\nGkJmqMKtiEhvo69lEcm7CsZhHfIDkp8qBnByh/vavjB1n/oBYypuwfvBfXPdBBjNhQUZvRURkd6v\ndw2JiMgJ4Ry+ScTawV7HGkzGYhqfp9wa1eUxZ1r/QpWZxBZeZDAzmGB9PE/ViohIX6OAKyJ557Cc\nfMJ9L5WVlezfv59UKnXkg4DR1hxGM6eHqxMRkb5OAVdECqaopxjYGfyrFuNs3kPrxFmkB4wpdEUi\nIicMBVwRKTrNVppbSt9mhzNOwHZyZ2QcU9Kl+SvAGPotugPvllVYJoNvQw2NF3+N5IhT81eDiMgJ\nTBeZiUiv9qq5h/vN+dxvzmeZufOojvl6eB1LvPW854qx2hPh1vB6MpgjH5gjroZaPLXrsUzbsmau\naD3BFYvy9voiIic6jeCKSK+11bzE69xDnCYAIuygwkzkJOuyLo/b44y3e9zgSFLvSFFle3qsVhER\n6T00gisivdY2arLhFiBJlG0sO+JxFZn2QbbUuCm38/f3fLp8MMlBEzCWs+1xoB/RU7XqQ2/USoYf\nBTbxr/61vGnXFbocEckRjeCKSK81mNPxECJJ221w3fgZzOldHpPAps6RBANY4LUdfLd5DK58/j1v\nWdRf9h38qxbjat5DbMIs0gN1kVlvk8Tm0+WreMPdBBa8YOr4pfNkZqRChS5NRI6TAq6I9FqjrNlM\nMzewkScwGEZyHidzdZfHPOTbxWpnM9999lVO376HXeEAr11QwRwq81T1BxxOYqd+NL+vKcdkhbuJ\n1e5m+GAxj1pa+ZVvC/8XP6WwhYnIcVPAFZFe7Vzr35hpvgUceVmxGBkWlGzlx39fys2vvE1Jpu0i\nr7X77oMr7u7xWqVvcWHx4U/U4VtEpC/SHFwR6fUsyzqqNXP/ObyCcZH/4dwt27LhFmD0/gaseEtP\nlih90KmpUs5IluH8YIGNEQT4t9jowhYlIjmhEVwRKRrO5J8YmVpD2EwCfNntLocH4/a229f73qv4\n1y3BLgnSfO71mJJgnquVQnNi8YfGKfy5ZBd17jQ3B04maMdJcXR31hOR3qtPBdx4PI7b7cbl6r1l\nOxwOfD7fkXcsEMuyiMVi6uNxUA9zoyf6GLBjACw+ZyvlT4+gvMlL0u/BnPZxfMFwdj/32iX4n7kH\nR2vbCg3e/VuIXPcTcB2+jNiJ2Mee0Bv7aIxNk6nls5QTyFTiiTtJqo/HpajvTih9Su/9f3EHSkpK\niEQiR33f+kLw+Xy0trYWuoxOud1uysrKiEaj6mM3qYe50VUfS9Yvo2TzCpIDRhGb9jE4yn80P219\nmX9Yr7JlyD5+9k/rGbJ/KBeEf4G/bCoc0gvfqn9kwy2AY8/7pLe9Q6p6/GHn7Mt97E16Wx+TpoW/\ncC31vIcTD5McV/Kpsl+oj8fJ7XYXugQRoI8FXBEpfsFXHiLwxmM4kzFKNi7Ds2cTjZd8/aiOPd1M\nYahZwDJ+jtfn5Oyh/4rfGnfYfsb5oa8+lwfjLslF+dJHLOF71PJa9vEq+w+cm/oSbgYWsCoRyRUF\nXBHpVUreewVnsm2qgSOTxrNjLaSThGsW4N26GuNwEJ08l9Ypczs8vto6hav5becvkE7RPPM63HXb\ncTXuwnZ5iI+cTrpiWE+8Hemlouxr9zhBEw3pLfRXwBUpCgq4ItK7fHg6gmXhX/MU/jVP4UgnAHAu\nf5BU9TjS/Ucd9Wmd9bX0e+Q2XLEGjOWgdeRpNJ/5aexgP5JDTznqaRDSt7h3bcBVt43k0MlkSgdk\nt49gFtt4iRRRAMoYwXDPmfTeH/9F5Fgo4IpIrxKdPBdnzR9wtjaR8fiIjz0Lz6712XAL4GxtwrNj\n7TEF3PInfoi7ZT8AFhn8771McsRUksMm5/w9SM9wxJpw7d9KpnRAu7DamdCy+QRW/wNHMkY6WEHT\nhV8hMXI6ANOsz5E0ETbzAg5czHbdRtBZReuHRnZFpG9SwBWRXqX1lItIVQ6nZMsqUgPHkBg5ncDr\nf8G8+wqWnQYgUxIiNfDwubUAqQz8Y2U5DVEXbqfN+Sc3MaAsjSPW2G4/C4N3+xpaJ1/c4+9Jjp9n\n+9uUPf2/OJv2YAfKaJlxBdHpH+90fyuVwLd+GY4Ppru4WuoIvvJwNuACnGF9jTP4GgBuhy6OEikm\nCrgi0uukq8fTcsiKBtEZl+Oq2463dh3GsohNOp/UoMNXPAB4dk0Z23banNXwB/ont7K+7nwqPzaG\nTKgS1yErJxgg1X9MT78VyZFwzQJcTbsBcEYbCKz6G9Fp88Dh7PiAdBLLzrTbZGH3dJki0kso4IpI\n72c5aJp7KxgbsLqcL5toivDNzZ+nPNP2U/P0yGIaXriMhitvp+LBb+GK7AfLonXUDKIzPpGnNyDH\nzf7Q0l2ZNFY6gfH4O9zdlARJVY3EEW3AwpBx+4iPnJGHQkWkN1DAFZG+wzry3cVn1d6bDbcATmzK\n3n2evbOvYd+NvwZjAJM913bzKsv5MQab8XyUadbneqh4OR7J6vG49209OE2l3+BOwy0AlkX9J75N\n6KU/4mraQ3z4NFonX5SnakWk0BRwRaSoDAs3wZ7229r9VG1ZQNsIcJPZwWK+RjO1AOzjHXymHxOs\nzud2Sv55N7yEq24H6WAFxl9KqmoEzed94cgHOt1EPvK5Hq9PRHqfIw+HiIj0IfFT55E55KYNBkgM\nm9LhXM0tLMmGW2hbC/VdFuejTDlKnu1rKHv+15RsX4O7eQ+Olnpapn8C4/YWujQR6cUUcEWkqKQG\nT6Th8ttIDBhLOtyf5jM/TeO8b3a4bzkjcdP+Z+6QFvrvVXxrX8B5yMWBrpb9+DYuL2BFItIXaIqC\niBSd5JBJ1H32riPuN8w6h4nmct7jaWzSVDGRmfx7xzvbGbYvW82uFj/DhzgZMGVsjquWjmTCVRgs\nLAwAtsNF+ijWwBWRE5sCroic0C6yfsTZ5hukiVPKUKxOLmR76W+bWGlmk3QGeHNzIx9pfouTzh2d\n52pPHM6m3YSf/w2ORIxMqBJHIoqxHCSHnUJ8wrmFLk9EejkFXBE54QWtrkcETTTCRns8SVcAgJir\njDX1gzkpH8WdiNJJ+j32A9x1WwGwHU5aJ11Ay4zLyZRV67bKInJECrgiIkdgHE7MYZcsKGT1FFfj\nLpzNe7OPHXYGV8MuMuWDCliViPQlushMROQIHD4/o7zbcdlxANx2jJGVsQJXVbxsfym2t/3Ff7bH\nV6BqRKQvUsAVETkKs+YOYmS4HicpUg4fbyfGs7NeP4L1BNtfRnTax0iHKrG9QZJVI2mac3OhyxKR\nPkTfziIiRyGdsdidqSLzwddmU8zFsvWlfOrsugJXVpyip11O7OQ5OOIRMuH+4NQ/VyJy9PSNISJy\nFFIZi4zdft6tbWsebk8yvhAZX6jQZYhIH6QpCiIiR8HnsSkPpLOPnQ6bwf0SBaxIREQ6oxFcEZGj\nYFlw+en1LFkbJppwMqg8weljooUuS0REOqCAKyJylDwuw0VTmo68o4iIFJSmKIiIiIhIUVHAFRER\nEZGiooArIiIiIkVFAVdEREREiooCroiIiIgUFQVcERERESkqCrgiIiIiUlQUcEVERESkqOTlRg+p\nVIrf//73pNNpMpkMEyZMYM6cOcRiMR555BEaGxspKyvjqquuwufz5aMkERERESlSeQm4breb66+/\nHo/HQyaT4b777mPr1q1s2LCBUaNGMXPmTGpqaqipqeHCCy/MR0kiIiIiUqTyNkXB4/EAkMlkMMbg\n8/nYsGEDU6dOBWDKlCmsX78+X+WIiIiISJHKywgugG3b/PrXv6ahoYEZM2bQv39/otEowWAQgGAw\nSDQazVc5IiIiIlKk8hZwHQ4Ht9xyC/F4nAULFrB58+Z2z1uW1e5xc3MzLS0t7bYFg0FcrryV3C1O\npxO3213oMjp1oH/qY/eph7mhPuaG+pgb6mNu9Pb+yYkj75/EkpISxo0bx86dOwkEAkQiEUKhEJFI\nhEAgkN1vxYoVLF26tN2xs2bNYvbs2fkuuSiVl5cXuoQ+Tz3MDfUxN9TH3FAfRYqDZYwxPf0i0WgU\nh8OBz+cjlUqxYMECzjvvPN577z38fj8zZ85k2bJlxOPx7EVmnY3gZjIZ0ul0T5fcbV6vl0QiUegy\nOuVyuSgvL6ehoUF97Cb1MDfUx9xQH3NDfcyNA30UKbS8jOC2tLTw17/+FWMMxhimTJnCqFGjGDhw\nIAsXLuTNN9/MLhN2QDgcJhwOH3auffv2kUql8lF2t7hcrl5d3wHpdLpX19kX+qge5ob6mBvqY26o\njyLFIS8Bd8CAAdx8882Hbff7/Vx//fX5KEFEREREThC6k5mIiIiIFBUFXBEREREpKgq4IiIiIlJU\nFHBFREREpKgo4IqIiIhIUVHAFREREZGiooArIiIiIkVFAVdEREREiooCroiIiIgUFQVcERERESkq\nCrgiIiIiUlQUcEVERESkqCjgioiIiEhRUcAVERERkaKigCsiIiIiRUUBV0RERESKigKuiIiIiBQV\nBVwRERERKSoKuCIiIiJSVBRwRURERKSoKOCKiIiISFFRwBURERGRoqKAKyIiIiJFRQFXRERERIqK\nAq6IiIiIFBUFXBEREREpKgq4IiIiIlJUFHBFREREpKgo4IqIiIhIUVHAFREREZGiooArIiIiIkVF\nAVdEREREiooCroiIiIgUFVehCxCRvs3ZuAvfhpdIhyuJT/gIWPq7WURECssyxphCF3G04vE48Xic\n3lyyw+HAtu1Cl9Epy7LweDwkk0n1sZvUw4OctesIPHoHzua9GKeL1OjTiX7yv8Cyjnis+pgb6mNu\nqI+5YVkWZWVlhS5DpG+N4JaUlBCJREilUoUupVM+n4/W1tZCl9Ept9tNWVkZ0WhUfewm9fCgfkvm\n42zeC4CVSePasorUjo2kK4cd8Vj1MTfUx9xQH3PD7XYXugQRQHNwReR4fHiky7bBZApTi4iIyAcU\ncEWk26JT5pLxt/0caYDUgNGkK448eisiItKT+tQUBRHpXRJjzqTBG8L3zrPYwQoiZ1wNDmehyxIR\nkROcAq6IHJfk0Ekkh04qdBkiIiJZmqIgIiIiIkVFAVdEREREiooCroiIiIgUFQVcERERESkqCrgi\nIiIiUlQUcEVERESkqCjgioiIiEhRUcAVERERkaKigCsiIiIiRUUBV0RERESKigKuiIiIiBQVBVwR\nERERKSoKuCIiIiJSVBRwRURERKSoKOCKiIiISFFRwBURERGRoqKAKyIiIiJFRQFXRERERIqKAq6I\niIiIFBUFXBEREREpKgq4IiIiIlJUFHBFREREpKgo4IqIiIhIUVHAFREREZGiooArIiIiIkVFAVdE\nREREioorXy/U1NTEX//6V6LRKADTp0/nzDPPJBaL8cgjj9DY2EhZWRlXXXUVPp8vX2WJiIiISJHJ\nW8B1OBxcfPHFVFdXk0gk+M1vfsPo0aNZuXIlo0aNYubMmdTU1FBTU8OFF16Yr7JEREREpMjkbYpC\nKBSiuroaAK/XS2VlJc3NzWzYsIGpU6cCMGXKFNavX5+vkkRERESkCBVkDm5DQwO7d+9myJAhRKNR\ngsEgAMFgMDuFQURERESkO/I2ReGARCLBww8/zNy5c/F6ve2esywr+9/Nzc20tLS0ez4YDOJy5b3k\nY+J0OnG73YUuo1MH+qc+dp96mBvqY26oj7mhPuZGb++fnDjy+knMZDI8/PDDTJ48mYkTJwIQCASI\nRCKEQiEikQiBQACAFStWsHTp0nbHDx8+nCuvvJLy8vJ8ll1UmpubeeGFF5g+fbr62E3qYW6oj7mh\nPuaG+pgbh/YxHA4Xuhw5geVtioIxhkWLFlFVVcVZZ52V3T5+/HhWr14NwKpVq5gwYQLQtsrCTTfd\nlP3f5ZdfztatWw8b1ZVj09LSwtKlS9XH46Ae5ob6mBvqY26oj7mhPkpvkbcR3G3btrFmzRoGDBjA\nvffeC8AFF1zAzJkzWbhwIW+++WZ2mTCAcDisv/5ERERE5JjlLeAOHz6c22+/vcPnrr/++nyVISIi\nIiJFTncyExEREZGi4ry9s2HVXsYYg8fjYcSIEYetviBHT308fuphbqiPuaE+5ob6mBvqo/QWljHG\nFLqID1u7di1Llixh//79fPGLX2TQoEEApFIpFi1axN69e7FtmylTpnDuuecCsHPnTh577DHS6TRj\nx47lkksuKeRb6BU66yPA7t27+dvf/kYikcCyLG666SZcLpf62IGu+gjQ2NjIPffcw+zZszn77LMB\nfR4/rLMebtq0iWeffZZMJoPT6eSiiy5i5MiRgHrYka4+i8uWLWPlypVYlsUll1zCmDFjAPXxSHbs\n2MGTTz6Jbds4HA7mzZvH4MGDgc57Kh179dVXef3117Esi3HjxmXvSqo+SkGYXmjv3r1m37595v77\n7ze1tbXZ7W+++aZZuHChMcaYZDJp7r77btPQ0GCMMebXv/612b59uzHGmAULFpiNGzfmv/BeprM+\nptNp88tf/tLs3r3bGGNMLBYzmUzGGKM+dqSzPh7w5z//2Tz88MPmpZdeym5TH9vrrIc7d+40zc3N\nxhhj9uzZY+66667sc+rh4Trr4549e8wvf/lLk06nTX19vfnpT39qbNs2xqiPR3LfffeZd9991xhj\nzMaNG839999vjOm4pwe+J+Vw77//vpk/f75Jp9PGGGNaWlqMMeqjFE6vnINbVVVFZWXlYdtDoRDJ\nZBLbtkkmkzidTrxeL5FIhGQyyZAhQwDd8veAzvq4adMmBgwYwIABAwDw+Xw4HA71sROd9RFg3bp1\nlJeXU1VVld2mPh6usx5WV1cTCoWy+6TTaTKZjHrYic76uGHDBk455RScTifl5eX069ePHTt2qI9H\nIRQKEY/HAYjH49nPY0c9ra2tLWSpvdrrr7/OzJkzcTqdANk17dVHKZQ+dcuRMWPGsHr1au666y5S\nqRRz587F5/NRW1vbbkmxcDhMJBIpYKW9W319PQALFiwgFotx8sknc84559Dc3Kw+HoNEIsFLL73E\nddddx/Lly7Pb1cfueeedd6iursbpdKqHxygSiWRDLBzsl9PpVB+PYM6cOdx33308/fTTGGP4whe+\nAHTeU+lYfX09W7du5bnnnsPlcnHRRRcxePBg9VEKpmAB94EHHuhwIegLLriA8ePHd3jM6tWrSafT\nfPOb36S1tZX77ruPUaNG9XSpvVp3+pjJZNi2bRs33XQTbreb+fPnU11dTUlJSU+X22t1p49Llizh\nrLPOwuPxYHrfVPa8604PD9i7dy/PPvss1113XU+V12ccTx+lY5319Pzzz+fVV1/lkksuYeLEiaxd\nu5ZFixbpc9iJrvpo2zbxeJwvfvGL1NbWsnDhQm699dYCVCnSpmABtztfINu3b2fChAk4HA4CgQDD\nhg1j586dDBs2jObm5ux+zc3N2Z+Zil13+lhaWsrw4cPx+/0AjB07ll27djF58mT18RjU1taybt06\nnnnmGeLxOJZl4XK5mDhx4gnZx+6GgqamJh566CGuuOKK7C1Sw+HwCdlD6F4fQ6EQTU1N2ccHRsBD\nodAJ28dDddXTRx99NHvr+JNOOonHH38c6LynJ7Ku+vjGG29k+zh48GAsyyIajaqPUjC9cg5uZyor\nK9m8eTMAyWSSHTt2UFlZSSgUwuv1smPHDowxrF69OnvLXznc6NGj2bt3L6lUikwmw9atW+nfv7/6\neIxuuOEGbr31Vm699VbOPPNMzj33XE4//XT18Ri0trby4IMPMmfOHIYOHZrdrh4em/Hjx/P222+T\nTqdpaGigvr6ewYMHq49HoV+/fmzZsgWAzZs3U1FRAXTeU+nYhAkTsv8+79+/n0wmQyAQUB+lYHrl\nMmHr1q1j8eLFxGIxvF4v1dXVXHPNNaTTaRYtWsSePXswxjBt2rTDlmVKpVKMHTuWSy+9tMDvovA6\n6yPAmjVrWLZsGZZlMXbs2OxyLurj4brq4wFLlizB4/Ho89iJznq4dOlSampqsqEC4NprryUQCKiH\nHejqs/jiiy+ycuVKHA5Hh8uEqY8dq62t5cknnySdTuN2u5k3bx7V1dVA5z2Vw2UyGRYtWsTu3bsP\nW/JPfZRC6JUBV0RERESku/rUFAURERERkSNRwBWR/9/eHaNEDgZgGP6iayN2DggZUU/gPbyAYOEJ\nbLQfRpDU3mBAELyFF5huSjuxCAjTOFhNky0WZtnebPD3ebqf/MVXhbcIBACKInABACiKwAUAoCgC\nFwCAoghcAACKInCB3pycnOT5+XnoGQD8MAIX6E1VVamqaugZAPwwAhcAgKIIXKB36/U619fXGY/H\nGY/Hubm5yXq9TvLnN8eHh4e5v7/PwcFB6rrOw8PDsIMB+NYELtCrruvSNE3m83kWi0UWi0Xm83ma\nptnceX9/z2q1Stu2mc1mubq6ysfHx4CrAfjOBC7Qu6enp0yn04xGo4xGo9ze3ubx8XHzfGdnJ9Pp\nNNvb2zk7O8ve3l5eXl4GXAzAdyZwgd61bZvj4+PN+ejoKG3bbs77+/vZ2vr7Otrd3c3n5+d/3QhA\nOQQu0Lu6rvP6+ro5v729pa7r4QYBUDSBC/Tu4uIiTdNkuVxmuVzm7u4ul5eXQ88CoFC/hh4AlK2q\nqkwmk6xWq5yeniZJzs/PM5lM/rkDAF+l6rquG3oEAAB8FZ8oAABQFIELAEBRBC4AAEURuAAAFEXg\nAgBQFIELAEBRBC4AAEURuAAAFEXgAgBQlN/8EiZdx614xwAAAABJRU5ErkJggg==\n", "text": [ "" ] }, { "metadata": {}, "output_type": "pyout", "prompt_number": 106, "text": [ "" ] } ], "prompt_number": 106 }, { "cell_type": "code", "collapsed": false, "input": [ "data.groupby('CURRENT_MINE_STATUS').size()" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 114, "text": [ "CURRENT_MINE_STATUS\n", "Abandoned 2626\n", "Active 78\n", "Intermittent 92\n", "NonProducing 9\n", "Temporarily Idled 34\n", "dtype: int64" ] } ], "prompt_number": 114 }, { "cell_type": "code", "collapsed": false, "input": [ "# Write to file:\n", "data.to_csv(\"/users/ryankelly/projects/ultura/active_goldmines.csv\", sep=\",\")" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 49 }, { "cell_type": "code", "collapsed": false, "input": [ "#print addr.columns\n", "\n", "gold_addr = addr[addr.PRIMARY_SIC_CD == \"Gold Ore\"]\n", "\n", "print len(gold_addr)\n", "print len(gold_addr[gold_addr.STREET.isnull()])\n", "print len(gold_addr[gold_addr.ZIP_CD.isnull()])\n", "print len(gold_addr[gold_addr.CITY.isnull()])\n", "print len(gold_addr[gold_addr.STATE.isnull()])\n", "\n", "print len(gold_addr[gold_addr.STREET.isnull() & gold_addr.ZIP_CD.isnull()])" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "2691\n", "1146\n", "25\n", "15\n", "22\n", "15\n" ] } ], "prompt_number": 81 }, { "cell_type": "code", "collapsed": false, "input": [ "print addr.columns\n", "gold_addr[['STREET', \"CITY\", \"STATE\", 'MINE_STATUS', 'BUSINESS_NAME', 'CONTACT_TITLE', 'MINE_NAME']].tail()" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Index([u'MINE_ID', u'MINE_NAME', u'CONTACT_TITLE', u'NEAREST_TOWN', u'BUSINESS_NAME', u'STREET', u'PO_BOX', u'CITY', u'STATE_ABBR', u'FIPS_STATE_CD', u'STATE', u'ZIP_CD', u'COUNTRY', u'PROVINCE', u'POSTAL_CD', u'MINE_TYPE_CD', u'MINE_STATUS', u'MINE_STATUS_DT', u'PRIMARY_SIC_CD', u'COAL_METAL_IND'], dtype='object')\n" ] }, { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
STREETCITYSTATEMINE_STATUSBUSINESS_NAMECONTACT_TITLEMINE_NAME
84158 Mile 128 Steese Hwy Central Alaska Intermittent John A Brown Owner John Brown Mine
84159 3937 Dobro Drive Fairbanks Alaska Intermittent Daniel Even Owner Daniel Even
84160 1725 Fiddle Way Fairbanks Alaska Intermittent Tracy Freel Owner Brant, Tracy
84162 3800 Hwy 2 and 52 Minot North Dakota Intermittent Blue Ribbon Gold Inc President Cahoon #1
84163 NA, P.O. box is only avalible option Haines Alaska Intermittent Hurt LLC Owner MK Falls
\n", "

5 rows \u00d7 7 columns

\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 94, "text": [ " STREET CITY STATE \\\n", "84158 Mile 128 Steese Hwy Central Alaska \n", "84159 3937 Dobro Drive Fairbanks Alaska \n", "84160 1725 Fiddle Way Fairbanks Alaska \n", "84162 3800 Hwy 2 and 52 Minot North Dakota \n", "84163 NA, P.O. box is only avalible option Haines Alaska \n", "\n", " MINE_STATUS BUSINESS_NAME CONTACT_TITLE MINE_NAME \n", "84158 Intermittent John A Brown Owner John Brown Mine \n", "84159 Intermittent Daniel Even Owner Daniel Even \n", "84160 Intermittent Tracy Freel Owner Brant, Tracy \n", "84162 Intermittent Blue Ribbon Gold Inc President Cahoon #1 \n", "84163 Intermittent Hurt LLC Owner MK Falls \n", "\n", "[5 rows x 7 columns]" ] } ], "prompt_number": 94 }, { "cell_type": "code", "collapsed": false, "input": [ "#data[['CURRENT_OPERATOR_NAME','STATE']]\n", "gold_addr." ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 103, "text": [ "3541 1\n", "4140 0\n", "5310 0\n", "5556 0\n", "5657 0\n", "5692 0\n", "6278 0\n", "6702 0\n", "6937 1\n", "7405 0\n", "7472 0\n", "7736 0\n", "8675 1\n", "12828 0\n", "12891 0\n", "...\n", "42823 0\n", "42843 0\n", "42846 0\n", "59633 2\n", "60215 0\n", "66382 0\n", "73544 1\n", "73861 1\n", "73966 0\n", "83779 0\n", "83965 1\n", "84035 0\n", "84037 0\n", "84062 0\n", "84274 0\n", "Name: NO_TAILING_PONDS, Length: 78, dtype: float64" ] } ], "prompt_number": 103 }, { "cell_type": "code", "collapsed": false, "input": [], "language": "python", "metadata": {}, "outputs": [] } ], "metadata": {} } ] }