diabetic_amputations.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0a2ce24a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import json\n",
    "import censusdata\n",
    "import subprocess\n",
    "import pandas as pd\n",
    "from uszipcode import SearchEngine\n",
    "\n",
    "# This is the location of my Mapshaper binary\n",
    "MAPSHAPER = os.path.join(os.path.expanduser('~'), \"node_modules/mapshaper/bin/mapshaper\")\n",
    "DATA_DIRECTORY = os.path.join(os.getcwd(), \"data\")\n",
    "\n",
    "pd.set_option('display.max_rows', 1000)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "61ed5f37",
   "metadata": {},
   "source": [
    "### (1) Mapping Zip Codes to State FIPS Codes\n",
    "Source: https://www2.census.gov/geo/docs/maps-data/data/rel/zcta_place_rel_10.txt\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "fc2bb58a",
   "metadata": {},
   "outputs": [],
   "source": [
    "zipcode_search = SearchEngine(simple_or_comprehensive=SearchEngine.SimpleOrComprehensiveArgEnum.simple)\n",
    "def get_state_abbreviation_from_zcta(zcta, search_engine=zipcode_search):\n",
    "    zipcode_data = search_engine.by_zipcode(zcta)\n",
    "    if zipcode_data:\n",
    "        return zipcode_data.state\n",
    "    else:\n",
    "        return None"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2c261c9f",
   "metadata": {},
   "source": [
    "### (2) Mapping U.S. State Names, U.S. State Abbreviations and FIPS Codes\n",
    "Source: https://gist.github.com/rogerallen/1583593"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c3617332",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(os.path.join(DATA_DIRECTORY, \"us_state_to_abbrev.json\")) as f:\n",
    "    us_state_to_abbrev = json.loads(f.read())\n",
    "\n",
    "abbrev_to_us_state = dict(map(reversed, us_state_to_abbrev.items()))\n",
    "    \n",
    "with open(os.path.join(DATA_DIRECTORY, \"us_state_abbrev_to_fips.json\")) as f:\n",
    "    us_state_abbrev_to_fips = json.loads(f.read())\n",
    "\n",
    "fips_to_us_state_abbrev = dict(map(reversed, us_state_abbrev_to_fips.items()))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ec9a6ea3",
   "metadata": {},
   "source": [
    "### (3) Read & Format Diabetic Amputation Data by State\n",
    "\n",
    "The State Media Co. filed open records requests to gain hospital discharge data from southeastern states from 2016 to 2020. The data consisted of 76 procedural codes for nontraumatic lower extremity amputations for diabetic patients, broken down by each patient’s ZIP code of residence. Four southeastern states (Louisiana, Arkansas, North Carolina and Tennessee) either did not have data or would not provide it. ZIP code populations, according to 5-year averages from the U.S. Census Bureau, were then divided by the number of amputations for each ZIP code for each year to create a rate. For privacy reasons, some states suppressed amputation data for certain ZIP codes when there were fewer than five procedures. The newspaper then took the population size of 29203 and compared it with ZIP codes the same size or larger in South Carolina, Georgia, Alabama and Mississippi."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5219621c",
   "metadata": {},
   "outputs": [],
   "source": [
    "def add_empty_rows_to_df(df, years=[2016, 2017, 2018, 2019, 2020]):\n",
    "    zipcodes_vec = []\n",
    "    years_vec = []\n",
    "    amputations_vec = []\n",
    "\n",
    "    for zipcode in df.ZIP.unique():\n",
    "        df_years = df[df.ZIP == zipcode].YEAR\n",
    "        empty_years = list(set(years) - set(df_years))\n",
    "\n",
    "        for year in empty_years:\n",
    "            zipcodes_vec.append(zipcode)\n",
    "            years_vec.append(year)\n",
    "            amputations_vec.append(0)\n",
    "    \n",
    "    empty_df = pd.DataFrame({\n",
    "        'ZIP': zipcodes_vec,\n",
    "        'YEAR': years_vec,\n",
    "        'AMPUTATIONS': amputations_vec\n",
    "    })\n",
    "    \n",
    "    return pd.concat([df, empty_df])\n",
    "\n",
    "def format_amputations_df(df, state_fips, us_state_abbrev_to_fips):\n",
    "    # Alabama's amputations column neeeds to be summed by zipcode\n",
    "    # We will aggregate these rows into unique zipcode rows\n",
    "    df['AMPUTATIONS'] = [value if value != \"*\" else 0 for value in df['AMPUTATIONS']]\n",
    "    df = df.groupby(['ZIP', 'YEAR'])['AMPUTATIONS'].sum().reset_index()\n",
    "\n",
    "    # Add empty years (i.e. 0 amputations)\n",
    "    df = add_empty_rows_to_df(df)\n",
    "    \n",
    "    # Each file contains patient zip codes outside of their own state\n",
    "    # For this investigation, we will be dropping these items from each df\n",
    "    zipcodes = df['ZIP']\n",
    "    state_abbreviations = [get_state_abbreviation_from_zcta(zipcode) for zipcode in zipcodes]\n",
    "    df['State'] = state_abbreviations\n",
    "    df['State FIPS'] = [us_state_abbrev_to_fips[abbrev] if abbrev in us_state_abbrev_to_fips else None for abbrev in state_abbreviations]\n",
    "    df = df[df['State FIPS'] == state_fips].reset_index(drop=True)\n",
    "    \n",
    "    return df\n",
    "\n",
    "state_abbreviations = ['AL', 'FL', 'GA', 'KY', 'MS', 'SC', 'VA', 'WV']\n",
    "state_fips_codes = [us_state_abbrev_to_fips[abbrev] for abbrev in state_abbreviations]\n",
    "amputations_dfs = []\n",
    "\n",
    "for state_abbreviation in state_abbreviations:\n",
    "    filename = \"Diabetic Amputations Raw Data - {0}.csv\".format(state_abbreviation)\n",
    "    filepath = os.path.join(DATA_DIRECTORY, filename)\n",
    "    df = pd.read_csv(filepath, dtype={'ZIP': str})\n",
    "    state_fips = us_state_abbrev_to_fips[state_abbreviation]\n",
    "    formatted_df = format_amputations_df(df, state_fips, us_state_abbrev_to_fips)\n",
    "    amputations_dfs.append(formatted_df)\n",
    "    \n",
    "amputations_df = pd.concat(amputations_dfs).sort_values(by=['State', 'ZIP', 'YEAR'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "171168cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZIP</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>AMPUTATIONS</th>\n",
       "      <th>State</th>\n",
       "      <th>State FIPS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>29203</td>\n",
       "      <td>2016</td>\n",
       "      <td>46</td>\n",
       "      <td>SC</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>29203</td>\n",
       "      <td>2017</td>\n",
       "      <td>49</td>\n",
       "      <td>SC</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>29203</td>\n",
       "      <td>2018</td>\n",
       "      <td>35</td>\n",
       "      <td>SC</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>29203</td>\n",
       "      <td>2019</td>\n",
       "      <td>38</td>\n",
       "      <td>SC</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>29203</td>\n",
       "      <td>2020</td>\n",
       "      <td>31</td>\n",
       "      <td>SC</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       ZIP  YEAR AMPUTATIONS State State FIPS\n",
       "207  29203  2016          46    SC         45\n",
       "208  29203  2017          49    SC         45\n",
       "209  29203  2018          35    SC         45\n",
       "210  29203  2019          38    SC         45\n",
       "211  29203  2020          31    SC         45"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amputations_df[amputations_df.ZIP=='29203']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bfa15747",
   "metadata": {},
   "source": [
    "### (4) Get Population Data by Year\n",
    "The Census data we used comes from the ACS 5-year estimates at the ZCTA level (approximate polygons for ZIP codes, which are really delivery routes). We used the 5-year averages since a ZIP code is a very small geographic unit for ACS survey methods, and there simply isn’t high enough precision to get reliable estimates from the 1-year ACS or 3-year ACS datasets."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b590e2d0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Finished processing acs5 2016\n",
      "Finished processing acs5 2017\n",
      "Finished processing acs5 2018\n",
      "Finished processing acs5 2019\n",
      "Finished processing acs5 2020\n"
     ]
    }
   ],
   "source": [
    "# https://api.census.gov/data/2010/acs/acs5/variables.html\n",
    "# B01003_001E - Estimate!!Total - TOTAL POPULATION\n",
    "# API - https://api.census.gov/data/2016/acs/acs5?get=NAME,ZCTA,B01003_001E&for=zip+code+tabulation+area:*&in=state:12\n",
    "years = [2016, 2017, 2018, 2019, 2020]\n",
    "census_product = 'acs5'\n",
    "fips_string = ','.join(state_fips_codes)\n",
    "code_string = 'B01003_001E'\n",
    "year_zcta_population_dict = {}\n",
    "\n",
    "for year in years:\n",
    "    # API didn't seem to support the \"in\" query for specifying states in 2020\n",
    "    if year == 2020:\n",
    "        population_table = censusdata.download(census_product, year,\n",
    "           censusdata.censusgeo([\n",
    "               ('zip%20code%20tabulation%20area', '*')\n",
    "           ]),['ZCTA',code_string])\n",
    "    else:\n",
    "        population_table = censusdata.download(census_product, year,\n",
    "           censusdata.censusgeo([\n",
    "               ('state', fips_string),\n",
    "               ('zip%20code%20tabulation%20area', '*')\n",
    "           ]),['ZCTA',code_string])\n",
    "    zcta_population_dict = dict(zip(population_table.ZCTA, population_table.B01003_001E))\n",
    "    year_zcta_population_dict[year] = zcta_population_dict\n",
    "    print(\"Finished processing {0} {1}\".format(census_product, year))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "bfd5d8ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get population from the back up 2010 Census\n",
    "# There were many ZIP codes with no population, so this was a double check\n",
    "# to see if that data were erroneous or retrievable (albeit through an old decennial)\n",
    "census_2010_population = censusdata.download('sf1', 2010,\n",
    "       censusdata.censusgeo([\n",
    "           ('state', fips_string),\n",
    "           ('zip code tabulation area (or part)', '*')\n",
    "       ]),['ZCTA5','P001001'])\n",
    "census_2010_zcta_population_dict = dict(zip(census_2010_population.ZCTA5, census_2010_population.P001001))    "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a775114b",
   "metadata": {},
   "source": [
    "### (5) Add Population Data to Amputations Data\n",
    "Similarly, we used 5-year averages as more reliable estimates for the amputation rate of a given ZIP code. We also calculated these rates per 10K residents and per 40K residents."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "fdeccd60",
   "metadata": {},
   "outputs": [],
   "source": [
    "population_vec = []\n",
    "\n",
    "for i, row in amputations_df.iterrows():\n",
    "    zcta = int(row.ZIP)\n",
    "    year = row.YEAR\n",
    "    amputations = row.AMPUTATIONS\n",
    "    if zcta not in year_zcta_population_dict[year]:\n",
    "        in_2010_census = zcta in census_2010_zcta_population_dict\n",
    "#         print(\"WARNING: No population found for {0} in {1} {2}\".format(zcta, year, in_2010_census))\n",
    "        if in_2010_census:\n",
    "            print(\"FOUND {0} population in Decennial Census of 2010\".format(zcta))\n",
    "            population = census_2010_zcta_population_dict[zcta]\n",
    "        else:\n",
    "            population = 0\n",
    "    else:\n",
    "        population = year_zcta_population_dict[year][zcta]\n",
    "    population_vec.append(population)\n",
    "\n",
    "amputations_df['POPULATION'] = population_vec\n",
    "amputations_df['AMPUTATIONS_PER_10K'] = [10000 * float(amputations_df.AMPUTATIONS.iloc[i]) / float(amputations_df.POPULATION.iloc[i]) if amputations_df.POPULATION.iloc[i] != 0 else None  for i in range(len(amputations_df))]\n",
    "amputations_df['AMPUTATIONS_PER_40K'] = [40000 * float(amputations_df.AMPUTATIONS.iloc[i]) / float(amputations_df.POPULATION.iloc[i]) if amputations_df.POPULATION.iloc[i] != 0 else None  for i in range(len(amputations_df))]\n",
    "\n",
    "avg_populations_dict = amputations_df.groupby([\"ZIP\"])['POPULATION'].mean().to_dict()\n",
    "amputations_df['AVERAGE POPULATION (2016-2020)'] = [avg_populations_dict[z] for z in amputations_df.ZIP]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "808cae67",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZIP</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>AMPUTATIONS</th>\n",
       "      <th>State</th>\n",
       "      <th>State FIPS</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>AMPUTATIONS_PER_10K</th>\n",
       "      <th>AMPUTATIONS_PER_40K</th>\n",
       "      <th>AVERAGE POPULATION (2016-2020)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1763</th>\n",
       "      <td>35004</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>10418</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11467.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35004</td>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>11167</td>\n",
       "      <td>2.686487</td>\n",
       "      <td>10.745948</td>\n",
       "      <td>11467.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35004</td>\n",
       "      <td>2018</td>\n",
       "      <td>3</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>11762</td>\n",
       "      <td>2.550587</td>\n",
       "      <td>10.202347</td>\n",
       "      <td>11467.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>35004</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>12045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11467.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>35004</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>11944</td>\n",
       "      <td>1.674481</td>\n",
       "      <td>6.697924</td>\n",
       "      <td>11467.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1552</th>\n",
       "      <td>26852</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>782</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2727</th>\n",
       "      <td>26852</td>\n",
       "      <td>2017</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>897</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2728</th>\n",
       "      <td>26852</td>\n",
       "      <td>2018</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>809</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1553</th>\n",
       "      <td>26852</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>742</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2729</th>\n",
       "      <td>26852</td>\n",
       "      <td>2020</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>843</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25725 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ZIP  YEAR AMPUTATIONS State State FIPS  POPULATION  \\\n",
       "1763  35004  2016           0    AL         01       10418   \n",
       "0     35004  2017           3    AL         01       11167   \n",
       "1     35004  2018           3    AL         01       11762   \n",
       "1764  35004  2019           0    AL         01       12045   \n",
       "2     35004  2020           2    AL         01       11944   \n",
       "...     ...   ...         ...   ...        ...         ...   \n",
       "1552  26852  2016           0    WV         54         782   \n",
       "2727  26852  2017           0    WV         54         897   \n",
       "2728  26852  2018           0    WV         54         809   \n",
       "1553  26852  2019           0    WV         54         742   \n",
       "2729  26852  2020           0    WV         54         843   \n",
       "\n",
       "      AMPUTATIONS_PER_10K  AMPUTATIONS_PER_40K  AVERAGE POPULATION (2016-2020)  \n",
       "1763             0.000000             0.000000                         11467.2  \n",
       "0                2.686487            10.745948                         11467.2  \n",
       "1                2.550587            10.202347                         11467.2  \n",
       "1764             0.000000             0.000000                         11467.2  \n",
       "2                1.674481             6.697924                         11467.2  \n",
       "...                   ...                  ...                             ...  \n",
       "1552             0.000000             0.000000                           814.6  \n",
       "2727             0.000000             0.000000                           814.6  \n",
       "2728             0.000000             0.000000                           814.6  \n",
       "1553             0.000000             0.000000                           814.6  \n",
       "2729             0.000000             0.000000                           814.6  \n",
       "\n",
       "[25725 rows x 9 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amputations_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4b60fd33",
   "metadata": {},
   "source": [
    "### (6) Get Insurance Data by Year\n",
    "```\n",
    "S2701_C01_001E - Total!!Estimate!!Civilian noninstitutionalized population\n",
    "S2701_C04_001E - Uninsured!!Estimate!!Civilian noninstitutionalized population\n",
    "S2701_C05_001E - Percent Uninsured!!Estimate!!Civilian noninstitutionalized population\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "a2d37d2d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Finished processing acs5/subject 2016\n",
      "Finished processing acs5/subject 2017\n",
      "Finished processing acs5/subject 2018\n",
      "Finished processing acs5/subject 2019\n",
      "Finished processing acs5/subject 2020\n"
     ]
    }
   ],
   "source": [
    "# https://api.census.gov/data/2015/acs/acs5/subject/groups/S2701.html\n",
    "# S2701_C01_001E - Total!!Estimate!!Civilian noninstitutionalized population\n",
    "# S2701_C04_001E - Uninsured!!Estimate!!Civilian noninstitutionalized population\n",
    "# S2701_C05_001E - Percent Uninsured!!Estimate!!Civilian noninstitutionalized population\n",
    "# https://api.census.gov/data/2015/acs/acs5/subject/?get=NAME,ZCTA,S2701_C05_001E&for=zip+code+tabulation+area:*&in=state:12\n",
    "\n",
    "\n",
    "year_zcta_insurance_dict = {}\n",
    "\n",
    "for year in years:\n",
    "    insurance_table = censusdata.download('acs5/subject', year,\n",
    "           censusdata.censusgeo([\n",
    "               ('zip code tabulation area', '*')\n",
    "           ]),['ZCTA','S2701_C04_001E', 'S2701_C01_001E', 'S2701_C05_001E'])\n",
    "    zcta_insurance_dict = {}\n",
    "    for i, zcta in enumerate(list(insurance_table.ZCTA)):\n",
    "        zcta_insurance_dict[zcta] = {\n",
    "            \"NONINSTITUTIONALIZED POPULATION\": insurance_table.S2701_C01_001E.iloc[i],\n",
    "            \"UNINSURED POPULATION (NON-I)\": insurance_table.S2701_C04_001E.iloc[i],\n",
    "            \"UNINSURED PERCENTAGE (NON-I)\": insurance_table.S2701_C05_001E.iloc[i]\n",
    "        }\n",
    "    year_zcta_insurance_dict[year] = zcta_insurance_dict\n",
    "    print(\"Finished processing {0} {1}\".format('acs5/subject', year))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9cbf16eb",
   "metadata": {},
   "source": [
    "### (7) Add Insurance Data to Amputations Data\n",
    "Merged insurance data with amputation data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "34480c24",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "noninstitutionalized_vec = []\n",
    "uninsured_pop_vec = []\n",
    "uninsured_percentage_vec = []\n",
    "\n",
    "for i, row in amputations_df.iterrows():\n",
    "    zcta = int(row.ZIP)\n",
    "    year = row.YEAR\n",
    "    if zcta not in year_zcta_insurance_dict[year]:\n",
    "        noninstitutionalized_vec.append(None)\n",
    "        uninsured_pop_vec.append(None)\n",
    "        uninsured_percentage_vec.append(None)\n",
    "    elif year_zcta_insurance_dict[year][zcta]['UNINSURED PERCENTAGE (NON-I)'] == -666666666:\n",
    "        noninstitutionalized_vec.append(None)\n",
    "        uninsured_pop_vec.append(None)\n",
    "        uninsured_percentage_vec.append(None)\n",
    "    else: \n",
    "        noninstitutionalized_vec.append(year_zcta_insurance_dict[year][zcta]['NONINSTITUTIONALIZED POPULATION'])\n",
    "        uninsured_pop_vec.append(year_zcta_insurance_dict[year][zcta]['UNINSURED POPULATION (NON-I)'])\n",
    "        uninsured_percentage_vec.append(year_zcta_insurance_dict[year][zcta]['UNINSURED PERCENTAGE (NON-I)'])\n",
    "\n",
    "    \n",
    "amputations_df['NONINSTITUTIONALIZED POPULATION'] = noninstitutionalized_vec\n",
    "amputations_df['UNINSURED POPULATION (NON-I)'] = uninsured_pop_vec\n",
    "amputations_df['UNINSURED PERCENTAGE (NON-I)'] = uninsured_percentage_vec\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e27f228e",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZIP</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>AMPUTATIONS</th>\n",
       "      <th>State</th>\n",
       "      <th>State FIPS</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>AMPUTATIONS_PER_10K</th>\n",
       "      <th>AMPUTATIONS_PER_40K</th>\n",
       "      <th>AVERAGE POPULATION (2016-2020)</th>\n",
       "      <th>NONINSTITUTIONALIZED POPULATION</th>\n",
       "      <th>UNINSURED POPULATION (NON-I)</th>\n",
       "      <th>UNINSURED PERCENTAGE (NON-I)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1763</th>\n",
       "      <td>35004</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>10418</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11467.2</td>\n",
       "      <td>10400.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35004</td>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>11167</td>\n",
       "      <td>2.686487</td>\n",
       "      <td>10.745948</td>\n",
       "      <td>11467.2</td>\n",
       "      <td>11146.0</td>\n",
       "      <td>559.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35004</td>\n",
       "      <td>2018</td>\n",
       "      <td>3</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>11762</td>\n",
       "      <td>2.550587</td>\n",
       "      <td>10.202347</td>\n",
       "      <td>11467.2</td>\n",
       "      <td>11742.0</td>\n",
       "      <td>733.0</td>\n",
       "      <td>6.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>35004</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>12045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11467.2</td>\n",
       "      <td>12019.0</td>\n",
       "      <td>830.0</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>35004</td>\n",
       "      <td>2020</td>\n",
       "      <td>2</td>\n",
       "      <td>AL</td>\n",
       "      <td>01</td>\n",
       "      <td>11944</td>\n",
       "      <td>1.674481</td>\n",
       "      <td>6.697924</td>\n",
       "      <td>11467.2</td>\n",
       "      <td>11912.0</td>\n",
       "      <td>933.0</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1552</th>\n",
       "      <td>26852</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>782</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "      <td>782.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2727</th>\n",
       "      <td>26852</td>\n",
       "      <td>2017</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>897</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "      <td>897.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2728</th>\n",
       "      <td>26852</td>\n",
       "      <td>2018</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>809</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "      <td>809.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>8.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1553</th>\n",
       "      <td>26852</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>742</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "      <td>742.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>12.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2729</th>\n",
       "      <td>26852</td>\n",
       "      <td>2020</td>\n",
       "      <td>0</td>\n",
       "      <td>WV</td>\n",
       "      <td>54</td>\n",
       "      <td>843</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>814.6</td>\n",
       "      <td>843.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>7.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25725 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ZIP  YEAR AMPUTATIONS State State FIPS  POPULATION  \\\n",
       "1763  35004  2016           0    AL         01       10418   \n",
       "0     35004  2017           3    AL         01       11167   \n",
       "1     35004  2018           3    AL         01       11762   \n",
       "1764  35004  2019           0    AL         01       12045   \n",
       "2     35004  2020           2    AL         01       11944   \n",
       "...     ...   ...         ...   ...        ...         ...   \n",
       "1552  26852  2016           0    WV         54         782   \n",
       "2727  26852  2017           0    WV         54         897   \n",
       "2728  26852  2018           0    WV         54         809   \n",
       "1553  26852  2019           0    WV         54         742   \n",
       "2729  26852  2020           0    WV         54         843   \n",
       "\n",
       "      AMPUTATIONS_PER_10K  AMPUTATIONS_PER_40K  \\\n",
       "1763             0.000000             0.000000   \n",
       "0                2.686487            10.745948   \n",
       "1                2.550587            10.202347   \n",
       "1764             0.000000             0.000000   \n",
       "2                1.674481             6.697924   \n",
       "...                   ...                  ...   \n",
       "1552             0.000000             0.000000   \n",
       "2727             0.000000             0.000000   \n",
       "2728             0.000000             0.000000   \n",
       "1553             0.000000             0.000000   \n",
       "2729             0.000000             0.000000   \n",
       "\n",
       "      AVERAGE POPULATION (2016-2020)  NONINSTITUTIONALIZED POPULATION  \\\n",
       "1763                         11467.2                          10400.0   \n",
       "0                            11467.2                          11146.0   \n",
       "1                            11467.2                          11742.0   \n",
       "1764                         11467.2                          12019.0   \n",
       "2                            11467.2                          11912.0   \n",
       "...                              ...                              ...   \n",
       "1552                           814.6                            782.0   \n",
       "2727                           814.6                            897.0   \n",
       "2728                           814.6                            809.0   \n",
       "1553                           814.6                            742.0   \n",
       "2729                           814.6                            843.0   \n",
       "\n",
       "      UNINSURED POPULATION (NON-I)  UNINSURED PERCENTAGE (NON-I)  \n",
       "1763                         344.0                           3.3  \n",
       "0                            559.0                           5.0  \n",
       "1                            733.0                           6.2  \n",
       "1764                         830.0                           6.9  \n",
       "2                            933.0                           7.8  \n",
       "...                            ...                           ...  \n",
       "1552                          13.0                           1.7  \n",
       "2727                          83.0                           9.3  \n",
       "2728                          66.0                           8.2  \n",
       "1553                          91.0                          12.3  \n",
       "2729                          60.0                           7.1  \n",
       "\n",
       "[25725 rows x 12 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amputations_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7d2e4d6f",
   "metadata": {},
   "source": [
    "### (8) Extrapolating VA's Q1-Q3 2020 Data\n",
    "Virginia's dataset does not include 2016 and only includes Q1-Q3 (inclusive) in 2020. We don't have access to the monthly/daily distribution of amputations, so here we are extrapolating linearly to impute values for Q4, then rounding to whole numbers for the final extrapolated total for VA 2020 amputation data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "a2d530c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "amputations_df.loc[\n",
    "    amputations_df.State == 'VA', 'AMPUTATIONS'\n",
    "] = amputations_df.loc[amputations_df.State == 'VA', 'AMPUTATIONS'].apply(lambda x: round(int(x)/.75))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9aad30dc",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/1m/gs67qnm13_zdcfgmdqmjy_sh0000gp/T/ipykernel_54145/1500814753.py:1: FutureWarning: In a future version of pandas all arguments of DataFrame.drop except for the argument 'labels' will be keyword-only\n",
      "  amputations_df = amputations_df.drop(['State FIPS', 'UNINSURED PERCENTAGE (NON-I)'], 1)\n"
     ]
    }
   ],
   "source": [
    "amputations_df = amputations_df.drop(['State FIPS', 'UNINSURED PERCENTAGE (NON-I)'], 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "63ad133d",
   "metadata": {},
   "outputs": [],
   "source": [
    "amputations_df.to_csv(os.path.join(DATA_DIRECTORY, 'amputations.csv'),index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8f1e0258",
   "metadata": {},
   "source": [
    "### (9) Calculating Averages and Rankings\n",
    "\n",
    "This output looks at ZIP codes above 39000 people across Mississippi, Alabama, Georgia and South Carolina from 2016-2020. The purpose is to find rankings and average amputation rates across these years.\n",
    "\n",
    "#### Methodology\n",
    "The authors' chosen methodology was to compare population-wide diabetic amputation rates for ZIP codes **the same size or larger** than the point of reference of 29203 (whose 5-year average population is ~39.9K). However, there are many other options for methods of comparison. \n",
    "\n",
    "From a data similarity perspective, it is likely more appropriate to compare 29203 to a range of populations, both above and below its own population of 39K: for instance a range between 20K and 60K. If we followed this methodology, 29203's amputation rate would have the 11th-worst amputation rate instead of 1st-worst over the 5-year span (when including MS, AL, GA and SC). \n",
    "\n",
    "If we also add the states of Kentucky, West Virginia and Virginia (whose data was also collected by The State Media Co. - Florida was also collected, though there's a chance the methodology may count individual amputation procedures rather than number of individuals who received amputations) into this methodology, 29203 would rank 34th-worst. Separately, it may make sense to compare ZIP codes with similar population densities amongst ZIP codes instead. \n",
    "\n",
    "From a data metric perspective, a population-wide diabetic amputation rate is not the best metric for care specific to people with diabetes. If 100% of the population of a 10,000 person town had diabetes, and 10 people recieved amputations, the population-wide amputation rate would be **10 per 10K residents**. The diabetic-population amputation rate would be **10 per 10K diabetics**, since everyone has diabetes.\n",
    "\n",
    "Now, if 10% of the population of 10,000 person town had diabetes (i.e. 1000 people), and 10 people still received amputations, the population-wide amputation rate would still be **10 per 10K residents**. However, the diabetic-population amputation rate would now be **100 per 10K diabetics%** (5/10). The second group of diabetics are receiving significantly worse care, with much worse outcomes. This metric would better encapsulate a comparison of diabetic amputations across ZIP codes as well. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e3e99f99",
   "metadata": {},
   "outputs": [],
   "source": [
    "amputations_df['AMPUTATIONS'] = amputations_df['AMPUTATIONS'].astype(int)\n",
    "population_filter = 39000\n",
    "state_filter = ['MS', 'AL', 'GA', 'SC']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6749eb05",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Num filtered ZIP codes: 120\n"
     ]
    }
   ],
   "source": [
    "filtered_df = amputations_df[\n",
    "    (amputations_df['AVERAGE POPULATION (2016-2020)'] > population_filter) &\n",
    "    (amputations_df['State'].isin(state_filter))\n",
    "]\n",
    "print(\"Num filtered ZIP codes: {0}\".format(len(filtered_df.ZIP.unique())))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "d2ab45c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "years = [2016, 2017, 2018, 2019, 2020]\n",
    "\n",
    "filtered_cols = ['ZIP', 'State', 'AVERAGE POPULATION (2016-2020)']\n",
    "filtered_zipcodes_states = filtered_df[filtered_cols].drop_duplicates().sort_values(by=['ZIP']).reset_index(drop=True)\n",
    "filtered_amputations_by_year = filtered_df.pivot(index='ZIP', columns='YEAR', values='AMPUTATIONS').reset_index()\n",
    "filtered_population_by_year = filtered_df.pivot(index='ZIP', columns='YEAR', values='POPULATION').reset_index()\n",
    "filtered_amputation_rate_by_year = filtered_amputations_by_year[years] / filtered_population_by_year[years] * 10000\n",
    "filtered_amputation_rank_by_year = filtered_amputation_rate_by_year.rank(ascending=False).astype(int)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6e7a9889",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Avg. Amputations Per 10K (2016-2020)\n",
    "\n",
    "avg_amputations_per_10K = []\n",
    "\n",
    "for i, row in filtered_zipcodes_states.iterrows():\n",
    "    \n",
    "    # We suspect Alabama's data for 2016 and 2017 is undercounted, so we are calculating\n",
    "    # the state's averages only over 2018, 2019 and 2020\n",
    "    if row.State == 'AL':\n",
    "        col_indices = [3,4,5]\n",
    "    elif row.State == 'VA':\n",
    "        # Similarly Virginia's methodology is only valid from 2017-2020\n",
    "        col_indices = [2,3,4,5]\n",
    "    else:\n",
    "        col_indices = [1,2,3,4,5]\n",
    "    \n",
    "    sum_amputations = filtered_amputations_by_year.iloc[i, col_indices].sum()\n",
    "    sum_population = filtered_population_by_year.iloc[i, col_indices].sum()\n",
    "    avg_amputations = round(sum_amputations / sum_population * 10000, 2)\n",
    "    avg_amputations_per_10K.append(avg_amputations)\n",
    "\n",
    "avg_amputations_per_10K_df = pd.DataFrame({\n",
    "    'Avg. Amputations Per 10K (2016-2020)': avg_amputations_per_10K\n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "952ecf8a",
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered_ranks_rates_df = pd.concat([\n",
    "    filtered_zipcodes_states,\n",
    "    filtered_amputation_rank_by_year,\n",
    "    avg_amputations_per_10K_df\n",
    "], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "ba28c3d6",
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered_ranks_rates_df = filtered_ranks_rates_df.sort_values(\n",
    "    by=['Avg. Amputations Per 10K (2016-2020)'], ascending=[False]\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "08e794cb",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_city_from_zipcode(x):\n",
    "    city = SearchEngine().by_zipcode(x).major_city\n",
    "    return city if city else 'None'\n",
    "\n",
    "cities = [get_city_from_zipcode(zipcode) for zipcode in filtered_ranks_rates_df['ZIP']]\n",
    "filtered_ranks_rates_df['City'] = cities\n",
    "\n",
    "rankingData = []\n",
    "\n",
    "for i, row in filtered_ranks_rates_df.iterrows():\n",
    "    rankingData.append(\n",
    "        {\n",
    "            \"zip\": str(row['ZIP']),\n",
    "            \"city\": row['City'],\n",
    "            \"state\": row['State'],\n",
    "            \"state_name\": abbrev_to_us_state[row['State']],\n",
    "            \"rank_2016\": row[2016],\n",
    "            \"rank_2017\": row[2017],\n",
    "            \"rank_2018\": row[2018],\n",
    "            \"rank_2019\": row[2019],\n",
    "            \"rank_2020\": row[2020],\n",
    "            \"amputation_rate\": row['Avg. Amputations Per 10K (2016-2020)'],\n",
    "            \"pop\": int(row['AVERAGE POPULATION (2016-2020)'])\n",
    "        }\n",
    "    )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "ed72a5de",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(os.path.join(DATA_DIRECTORY, 'table_rates_rankings.json'), 'w') as f:\n",
    "    json.dump(rankingData, f)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a50a9886",
   "metadata": {},
   "source": [
    "### (10) Finding population densities\n",
    "\n",
    "We need to add population densities and a number of other features into the Census dataset of zipcodes. And we need to remove other fields that will only take up space. The Census ZCTA shapefile isn't broken down by state (likely because there are many ZIP codes whose area intersects multiple states). So the first few steps are an attempt to geographically filter the zipcodes using Census state shapefiles. For these steps, you need to install [Mapshaper](https://github.com/mbloch/mapshaper)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "466ea3e0",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[filter] Retained 4 of 56 features\n",
      "[o] Wrote /Users/davidnewcomb/notebooks/data/diabetic_amputations/deep_south.json\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "CompletedProcess(args=['/Users/davidnewcomb/node_modules/mapshaper/bin/mapshaper', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/tl_2021_us_state/tl_2021_us_state.shp', '-filter', '\"28,01,13,45\".indexOf(STATEFP) > -1', '-o', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/deep_south.json'], returncode=0)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Manually download and unzip Zip Code Tabulation Area (ZCTA) shapefile from the Census into your DATA_DIRECTORY\n",
    "# https://www2.census.gov/geo/tiger/TIGER2021/ZCTA520/tl_2021_us_zcta520.zip\n",
    "\n",
    "states_census_filepath = os.path.join(DATA_DIRECTORY, 'tl_2021_us_state', 'tl_2021_us_state.shp')\n",
    "deep_south_filepath = os.path.join(DATA_DIRECTORY, 'deep_south.json')\n",
    "filter_expression = '\"28,01,13,45\".indexOf(STATEFP) > -1'\n",
    "\n",
    "subprocess.run([MAPSHAPER, states_census_filepath, \"-filter\", filter_expression, \"-o\", deep_south_filepath])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "843ad227",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[o] Wrote /Users/davidnewcomb/notebooks/data/diabetic_amputations/zcta_deep_south.json\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "CompletedProcess(args=['/Users/davidnewcomb/node_modules/mapshaper/bin/mapshaper', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/tl_2021_us_zcta520/tl_2021_us_zcta520.shp', '-clip', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/deep_south.json', '-o', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/zcta_deep_south.json'], returncode=0)"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zcta_census_filepath = os.path.join(DATA_DIRECTORY, 'tl_2021_us_zcta520', 'tl_2021_us_zcta520.shp')\n",
    "zcta_deep_south_filepath = os.path.join(DATA_DIRECTORY, 'zcta_deep_south.json')\n",
    "\n",
    "subprocess.run([MAPSHAPER, zcta_census_filepath, \"-clip\", deep_south_filepath, \"-o\", zcta_deep_south_filepath])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "6acaf6a5",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[simplify] Repaired 172 intersections\n",
      "[o] Wrote /Users/davidnewcomb/notebooks/data/diabetic_amputations/zipcodes.json\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "CompletedProcess(args=['/Users/davidnewcomb/node_modules/mapshaper/bin/mapshaper', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/zcta_deep_south.json', '-simplify', '12%', '-o', 'format=topojson', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/zipcodes.json'], returncode=0)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zcta_filepath = os.path.join(DATA_DIRECTORY, 'zipcodes.json')\n",
    "\n",
    "subprocess.run([MAPSHAPER, zcta_deep_south_filepath, \"-simplify\", \"12%\", \"-o\", \"format=topojson\", zcta_filepath])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d5b3edd7",
   "metadata": {},
   "source": [
    "Now that we have filtered ZCTA shapes, we can focus on getting population densities, amputation rates, and other information added into the `zipcodes.json` file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "167034e6",
   "metadata": {},
   "outputs": [],
   "source": [
    "deep_south_df = amputations_df[amputations_df.State.isin(['SC', 'AL', 'MS', 'GA'])].reset_index(drop=True)\n",
    "deep_south_df['AMPUTATIONS'] = deep_south_df['AMPUTATIONS'].astype(int)\n",
    "\n",
    "deep_south_avg_populations_df = deep_south_df.groupby([\"ZIP\"])['POPULATION'].mean()\n",
    "deep_south_states_df = deep_south_df.groupby([\"ZIP\"])['State'].first()\n",
    "deep_south_amputations_df = deep_south_df.groupby([\"ZIP\"])['AMPUTATIONS'].sum()\n",
    "deep_south_amputation_rates_df = deep_south_amputations_df / deep_south_df.groupby([\"ZIP\"])['POPULATION'].sum()*10000"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9c8aa874",
   "metadata": {},
   "source": [
    "#### Methodology\n",
    "\n",
    "Alabama's dataset was more accurately reported for 2018-2020, and Virginia's was more accurately reported for 2017-2020. For the overall statistics on number of amputations and amputation rate per 10K residents, these numbers are aggregated/averaged over 3 and 4 years, respectively."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "03150545",
   "metadata": {},
   "outputs": [],
   "source": [
    "AL_df = deep_south_df[(deep_south_df['YEAR'].isin([2018, 2019, 2020])) & (deep_south_df['State'] == 'AL')]\n",
    "AL_amputations_df = AL_df.groupby([\"ZIP\"])['AMPUTATIONS'].sum()\n",
    "AL_amputation_rates_df = AL_amputations_df / AL_df.groupby([\"ZIP\"])['POPULATION'].sum()*10000\n",
    "\n",
    "VA_df = deep_south_df[(deep_south_df['YEAR'].isin([2017, 2018, 2019, 2020])) & (deep_south_df['State'] == 'VA')]\n",
    "VA_amputations_df = VA_df.groupby([\"ZIP\"])['AMPUTATIONS'].sum()\n",
    "VA_amputation_rates_df = VA_amputations_df / VA_df.groupby([\"ZIP\"])['POPULATION'].sum()*10000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "2db476d2",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(zcta_filepath) as f:\n",
    "    zipcodes_json = json.loads(f.read())\n",
    "    \n",
    "final_data = {\n",
    "    'ZIP': [],\n",
    "    'POPDENSITY': [],\n",
    "    'POPULATION_5_YR_AVG': [],\n",
    "    'AMPUTATION_RATE_5_YR_AVG_PER_10K': [],\n",
    "    'AMPUTATIONS': [],\n",
    "    'STATE': []\n",
    "}\n",
    "fields_to_remove = [\n",
    "    'GEOID20', 'CLASSFP20', 'MTFCC20', 'FUNCSTAT20', 'ALAND20', 'AWATER20', 'INTPTLAT20', 'INTPTLON20'\n",
    "]\n",
    "\n",
    "for z in zipcodes_json['objects']['zcta_deep_south']['geometries']:\n",
    "    zipcode_code = z['properties']['ZCTA5CE20']\n",
    "    \n",
    "    # Get land in square miles\n",
    "    zipcode_land = z['properties']['ALAND20'] * 3.86102e-7\n",
    "    \n",
    "    if zipcode_code in deep_south_avg_populations_df:\n",
    "        zipcode_state = deep_south_states_df[zipcode_code]\n",
    "        zipcode_population = deep_south_avg_populations_df[zipcode_code]\n",
    "        \n",
    "        if zipcode_population > 0:\n",
    "            zipcode_density = round(float(zipcode_population) / float(zipcode_land) , 2)\n",
    "\n",
    "            if zipcode_state == 'AL':\n",
    "                zipcode_amputation_rate_avg = AL_amputation_rates_df[zipcode_code]\n",
    "                zipcode_amputations = AL_amputations_df[zipcode_code]\n",
    "            else:\n",
    "                zipcode_amputation_rate_avg = deep_south_amputation_rates_df[zipcode_code]\n",
    "                zipcode_amputations = deep_south_amputations_df[zipcode_code]\n",
    "            \n",
    "            z['properties']['POPDENSITY'] = zipcode_density\n",
    "            z['properties']['POPULATION_5_YR_AVG'] = zipcode_population\n",
    "            z['properties']['AMPUTATION_RATE_5_YR_AVG_PER_10K'] = round(zipcode_amputation_rate_avg, 2)\n",
    "            z['properties']['AMPUTATIONS'] = zipcode_amputations.astype(str)\n",
    "            z['properties']['STATE'] = zipcode_state\n",
    "\n",
    "            final_data['ZIP'].append(zipcode_code)\n",
    "            final_data['POPDENSITY'].append(zipcode_density)\n",
    "            final_data['POPULATION_5_YR_AVG'].append(zipcode_population)\n",
    "            final_data['AMPUTATION_RATE_5_YR_AVG_PER_10K'].append(round(zipcode_amputation_rate_avg, 2))\n",
    "            final_data['AMPUTATIONS'].append(zipcode_amputations)\n",
    "            final_data['STATE'].append(zipcode_state)\n",
    "        else:\n",
    "            z['properties']['POPDENSITY'] = 0\n",
    "            z['properties']['POPULATION_5_YR_AVG'] = 0\n",
    "            z['properties']['AMPUTATION_RATE_5_YR_AVG_PER_10K'] = 0\n",
    "            z['properties']['AMPUTATIONS'] = 0\n",
    "            z['properties']['STATE'] = deep_south_states_df[zipcode_code]\n",
    "    else:\n",
    "        z['properties']['POPDENSITY'] = 0\n",
    "        z['properties']['POPULATION_5_YR_AVG'] = 0\n",
    "        z['properties']['AMPUTATION_RATE_5_YR_AVG_PER_10K'] = 0\n",
    "        z['properties']['AMPUTATIONS'] = 0\n",
    "        \n",
    "        if zipcode_code in deep_south_states_df:\n",
    "            z['properties']['STATE'] = deep_south_states_df[zipcode_code]\n",
    "        elif zipcode_code.startswith('30') or zipcode_code.startswith('31'):\n",
    "            z['properties']['STATE'] = 'GA'\n",
    "        elif zipcode_code.startswith('35') or zipcode_code.startswith('36'):\n",
    "            z['properties']['STATE'] = 'AL'\n",
    "        elif zipcode_code.startswith('38') or zipcode_code.startswith('39'):\n",
    "            z['properties']['STATE'] = 'MS'\n",
    "        elif zipcode_code.startswith('29') or zipcode_code.startswith('39'):\n",
    "            z['properties']['STATE'] = 'SC'\n",
    "        else:\n",
    "            print(zipcode_code)\n",
    "    \n",
    "    for field in fields_to_remove:\n",
    "        if field in z['properties']:\n",
    "            del z['properties'][field]\n",
    "\n",
    "final_df = pd.DataFrame(final_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "1fc7c684",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(os.path.join(DATA_DIRECTORY, 'zipcodes_final.json'), 'w') as f:\n",
    "    json.dump(zipcodes_json, f)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "03905226",
   "metadata": {},
   "source": [
    "For mapping purposes it can help to simplify the geographies, resulting in a smaller file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "88783a02",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[simplify] Repaired 166 intersections; 16 intersections could not be repaired\n",
      "[o] Wrote /Users/davidnewcomb/notebooks/data/diabetic_amputations/zipcodes_condensed.json\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "CompletedProcess(args=['/Users/davidnewcomb/node_modules/mapshaper/bin/mapshaper', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/zipcodes_final.json', '-simplify', '70%', '-o', '/Users/davidnewcomb/notebooks/data/diabetic_amputations/zipcodes_condensed.json'], returncode=0)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zipcodes_filepath = os.path.join(DATA_DIRECTORY, 'zipcodes_final.json')\n",
    "zipcodes_condensed_filepath = os.path.join(DATA_DIRECTORY, 'zipcodes_condensed.json')\n",
    "\n",
    "subprocess.run([MAPSHAPER, zipcodes_filepath, \"-simplify\", \"70%\", \"-o\", zipcodes_condensed_filepath])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a822c3b3",
   "metadata": {},
   "source": [
    "### (11) Looking into Poverty Data \n",
    "\n",
    "Ultimately, for the article we used Low-to-Moderate Income numbers by census tract, found at this [HUD map](https://hudgis-hud.opendata.arcgis.com/datasets/HUD::low-to-moderate-income-population-by-tract/explore?filters=eyJTVEFURSI6WyI0NSJdLCJDT1VOVFkiOlsiMDc5IiwiMDYzIiwiMDE3Il19&location=34.004900%2C-81.118087%2C9.97) (whose data is downloadable). This section gathers poverty data for Lexington County (FIPS: 063) and Richland County (FIPS: 079) in South Carolina."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "eea44f32",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# FIPS Codes\n",
    "# 063 - Lexington County, SC\n",
    "# 079 - Richland County, SC\n",
    "\n",
    "# ACS5 Variables\n",
    "# B06012_002E - Population\n",
    "# B06012_002E - Estimate!!Total!!Below 100 percent of the poverty level\n",
    "\n",
    "poverty_table = censusdata.download('acs5', 2019,\n",
    "   censusdata.censusgeo([\n",
    "       ('state', '45'),\n",
    "       ('county', '063,079'),\n",
    "       ('tract', '*')\n",
    "   ]),['TRACT','B01003_001E', 'B06012_001E', 'B06012_002E', 'B06012_003E', 'B06012_004E'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "82cd6c52",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'000400': 0.2268,\n",
       " '000300': 0.4683,\n",
       " '000100': 0.278,\n",
       " '001000': 0.438,\n",
       " '010200': 0.1466,\n",
       " '010102': 0.1702,\n",
       " '011404': 0.1908,\n",
       " '010703': 0.4105,\n",
       " '010702': 0.2626,\n",
       " '010900': 0.5144,\n",
       " '010804': 0.3386,\n",
       " '000600': 0.1474,\n",
       " '000900': 0.579,\n",
       " '000500': 0.4557,\n",
       " '010600': 0.3943,\n",
       " '010502': 0.488,\n",
       " '010701': 0.1924,\n",
       " '000700': 0.1924,\n",
       " '010501': 0.1599,\n",
       " '000200': 0.2671,\n",
       " '010805': 0.199,\n",
       " '010806': 0.8177}"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tract_ids = [\n",
    "    \"000400\",\n",
    "    \"000300\",\n",
    "    \"000100\",\n",
    "    \"001000\",\n",
    "    \"010200\",\n",
    "    \"010102\",\n",
    "    \"011404\",\n",
    "    \"010703\",\n",
    "    \"010702\",\n",
    "    \"010900\",\n",
    "    \"010804\",\n",
    "    \"000600\",\n",
    "    \"000900\",\n",
    "    \"000500\",\n",
    "    \"010600\",\n",
    "    \"010502\",\n",
    "    \"010701\",\n",
    "    \"000700\",\n",
    "    \"010501\",\n",
    "    \"000200\",\n",
    "    \"010805\",\n",
    "    \"010806\"\n",
    "]\n",
    "\n",
    "poverty_rates = []\n",
    "for tract_id in tract_ids:\n",
    "    total_pop = poverty_table[poverty_table.TRACT == int(tract_id)]['B06012_001E']\n",
    "    poverty_pop = poverty_table[poverty_table.TRACT == int(tract_id)]['B06012_002E']\n",
    "    poverty_rate = round(float(int(poverty_pop)) / float(int(total_pop)), 4)\n",
    "    poverty_rates.append(poverty_rate)\n",
    "    \n",
    "dict(zip(tract_ids, poverty_rates))\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "0feb1d18",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TRACT</th>\n",
       "      <th>B01003_001E</th>\n",
       "      <th>B06012_001E</th>\n",
       "      <th>B06012_002E</th>\n",
       "      <th>B06012_003E</th>\n",
       "      <th>B06012_004E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Census Tract 25, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002500</th>\n",
       "      <td>2500</td>\n",
       "      <td>3743</td>\n",
       "      <td>3695</td>\n",
       "      <td>280</td>\n",
       "      <td>135</td>\n",
       "      <td>3280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 26.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002602</th>\n",
       "      <td>2602</td>\n",
       "      <td>3026</td>\n",
       "      <td>3011</td>\n",
       "      <td>516</td>\n",
       "      <td>248</td>\n",
       "      <td>2247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.08, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010408</th>\n",
       "      <td>10408</td>\n",
       "      <td>4439</td>\n",
       "      <td>200</td>\n",
       "      <td>183</td>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 206.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020605</th>\n",
       "      <td>20605</td>\n",
       "      <td>2457</td>\n",
       "      <td>2457</td>\n",
       "      <td>223</td>\n",
       "      <td>218</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.06, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021106</th>\n",
       "      <td>21106</td>\n",
       "      <td>2825</td>\n",
       "      <td>2825</td>\n",
       "      <td>103</td>\n",
       "      <td>273</td>\n",
       "      <td>2449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.08, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020508</th>\n",
       "      <td>20508</td>\n",
       "      <td>2051</td>\n",
       "      <td>1959</td>\n",
       "      <td>51</td>\n",
       "      <td>75</td>\n",
       "      <td>1833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 203, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020300</th>\n",
       "      <td>20300</td>\n",
       "      <td>3949</td>\n",
       "      <td>3863</td>\n",
       "      <td>1139</td>\n",
       "      <td>685</td>\n",
       "      <td>2039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.11, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020511</th>\n",
       "      <td>20511</td>\n",
       "      <td>3552</td>\n",
       "      <td>3244</td>\n",
       "      <td>305</td>\n",
       "      <td>647</td>\n",
       "      <td>2292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 202.01, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020201</th>\n",
       "      <td>20201</td>\n",
       "      <td>2864</td>\n",
       "      <td>2864</td>\n",
       "      <td>752</td>\n",
       "      <td>373</td>\n",
       "      <td>1739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 206.01, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020601</th>\n",
       "      <td>20601</td>\n",
       "      <td>4384</td>\n",
       "      <td>4384</td>\n",
       "      <td>478</td>\n",
       "      <td>566</td>\n",
       "      <td>3340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 207.03, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020703</th>\n",
       "      <td>20703</td>\n",
       "      <td>4547</td>\n",
       "      <td>4547</td>\n",
       "      <td>951</td>\n",
       "      <td>521</td>\n",
       "      <td>3075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 105.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010502</th>\n",
       "      <td>10502</td>\n",
       "      <td>1211</td>\n",
       "      <td>1211</td>\n",
       "      <td>591</td>\n",
       "      <td>136</td>\n",
       "      <td>484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 106, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010600</th>\n",
       "      <td>10600</td>\n",
       "      <td>4160</td>\n",
       "      <td>4124</td>\n",
       "      <td>1626</td>\n",
       "      <td>418</td>\n",
       "      <td>2080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 107.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010702</th>\n",
       "      <td>10702</td>\n",
       "      <td>3823</td>\n",
       "      <td>3823</td>\n",
       "      <td>1004</td>\n",
       "      <td>453</td>\n",
       "      <td>2366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 107.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010703</th>\n",
       "      <td>10703</td>\n",
       "      <td>3272</td>\n",
       "      <td>3272</td>\n",
       "      <td>1343</td>\n",
       "      <td>369</td>\n",
       "      <td>1560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 112.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011201</th>\n",
       "      <td>11201</td>\n",
       "      <td>1938</td>\n",
       "      <td>1938</td>\n",
       "      <td>53</td>\n",
       "      <td>151</td>\n",
       "      <td>1734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011404</th>\n",
       "      <td>11404</td>\n",
       "      <td>9196</td>\n",
       "      <td>9152</td>\n",
       "      <td>1746</td>\n",
       "      <td>896</td>\n",
       "      <td>6510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 116.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011604</th>\n",
       "      <td>11604</td>\n",
       "      <td>5645</td>\n",
       "      <td>5582</td>\n",
       "      <td>311</td>\n",
       "      <td>139</td>\n",
       "      <td>5132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 120, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:012000</th>\n",
       "      <td>12000</td>\n",
       "      <td>5437</td>\n",
       "      <td>5399</td>\n",
       "      <td>1090</td>\n",
       "      <td>458</td>\n",
       "      <td>3851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.17, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021017</th>\n",
       "      <td>21017</td>\n",
       "      <td>8580</td>\n",
       "      <td>8580</td>\n",
       "      <td>962</td>\n",
       "      <td>975</td>\n",
       "      <td>6643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.09, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021009</th>\n",
       "      <td>21009</td>\n",
       "      <td>11606</td>\n",
       "      <td>11526</td>\n",
       "      <td>1008</td>\n",
       "      <td>1042</td>\n",
       "      <td>9476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.14, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021014</th>\n",
       "      <td>21014</td>\n",
       "      <td>7318</td>\n",
       "      <td>7318</td>\n",
       "      <td>160</td>\n",
       "      <td>246</td>\n",
       "      <td>6912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010403</th>\n",
       "      <td>10403</td>\n",
       "      <td>3709</td>\n",
       "      <td>3702</td>\n",
       "      <td>528</td>\n",
       "      <td>298</td>\n",
       "      <td>2876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 3, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000300</th>\n",
       "      <td>300</td>\n",
       "      <td>2855</td>\n",
       "      <td>2855</td>\n",
       "      <td>1337</td>\n",
       "      <td>346</td>\n",
       "      <td>1172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 11, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:001100</th>\n",
       "      <td>1100</td>\n",
       "      <td>3530</td>\n",
       "      <td>3270</td>\n",
       "      <td>491</td>\n",
       "      <td>452</td>\n",
       "      <td>2327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 12, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:001200</th>\n",
       "      <td>1200</td>\n",
       "      <td>1852</td>\n",
       "      <td>1801</td>\n",
       "      <td>29</td>\n",
       "      <td>31</td>\n",
       "      <td>1741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 16, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:001600</th>\n",
       "      <td>1600</td>\n",
       "      <td>1522</td>\n",
       "      <td>1522</td>\n",
       "      <td>427</td>\n",
       "      <td>106</td>\n",
       "      <td>989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 103.06, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010306</th>\n",
       "      <td>10306</td>\n",
       "      <td>12031</td>\n",
       "      <td>11846</td>\n",
       "      <td>661</td>\n",
       "      <td>470</td>\n",
       "      <td>10715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 112.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011202</th>\n",
       "      <td>11202</td>\n",
       "      <td>3456</td>\n",
       "      <td>3456</td>\n",
       "      <td>353</td>\n",
       "      <td>160</td>\n",
       "      <td>2943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 9, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000900</th>\n",
       "      <td>900</td>\n",
       "      <td>2411</td>\n",
       "      <td>2411</td>\n",
       "      <td>1396</td>\n",
       "      <td>249</td>\n",
       "      <td>766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 102, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010200</th>\n",
       "      <td>10200</td>\n",
       "      <td>5427</td>\n",
       "      <td>5422</td>\n",
       "      <td>795</td>\n",
       "      <td>622</td>\n",
       "      <td>4005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 13, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:001300</th>\n",
       "      <td>1300</td>\n",
       "      <td>2024</td>\n",
       "      <td>1578</td>\n",
       "      <td>509</td>\n",
       "      <td>318</td>\n",
       "      <td>751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 213.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021305</th>\n",
       "      <td>21305</td>\n",
       "      <td>3261</td>\n",
       "      <td>3128</td>\n",
       "      <td>699</td>\n",
       "      <td>468</td>\n",
       "      <td>1961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 213.06, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021306</th>\n",
       "      <td>21306</td>\n",
       "      <td>3721</td>\n",
       "      <td>3709</td>\n",
       "      <td>380</td>\n",
       "      <td>295</td>\n",
       "      <td>3034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 213.07, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021307</th>\n",
       "      <td>21307</td>\n",
       "      <td>1896</td>\n",
       "      <td>1896</td>\n",
       "      <td>380</td>\n",
       "      <td>269</td>\n",
       "      <td>1247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 213.08, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021308</th>\n",
       "      <td>21308</td>\n",
       "      <td>4480</td>\n",
       "      <td>4469</td>\n",
       "      <td>689</td>\n",
       "      <td>412</td>\n",
       "      <td>3368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 214.03, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021403</th>\n",
       "      <td>21403</td>\n",
       "      <td>2480</td>\n",
       "      <td>2465</td>\n",
       "      <td>515</td>\n",
       "      <td>339</td>\n",
       "      <td>1611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 214.04, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021404</th>\n",
       "      <td>21404</td>\n",
       "      <td>3233</td>\n",
       "      <td>3233</td>\n",
       "      <td>349</td>\n",
       "      <td>166</td>\n",
       "      <td>2718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 9801, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:980100</th>\n",
       "      <td>980100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 26.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002604</th>\n",
       "      <td>2604</td>\n",
       "      <td>1527</td>\n",
       "      <td>1510</td>\n",
       "      <td>363</td>\n",
       "      <td>229</td>\n",
       "      <td>918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 26.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002603</th>\n",
       "      <td>2603</td>\n",
       "      <td>3779</td>\n",
       "      <td>3779</td>\n",
       "      <td>1116</td>\n",
       "      <td>532</td>\n",
       "      <td>2131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 29, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002900</th>\n",
       "      <td>2900</td>\n",
       "      <td>3790</td>\n",
       "      <td>1050</td>\n",
       "      <td>410</td>\n",
       "      <td>49</td>\n",
       "      <td>591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 30, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:003000</th>\n",
       "      <td>3000</td>\n",
       "      <td>2627</td>\n",
       "      <td>1614</td>\n",
       "      <td>650</td>\n",
       "      <td>194</td>\n",
       "      <td>770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 207.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020705</th>\n",
       "      <td>20705</td>\n",
       "      <td>3584</td>\n",
       "      <td>3568</td>\n",
       "      <td>894</td>\n",
       "      <td>476</td>\n",
       "      <td>2198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 207.08, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020708</th>\n",
       "      <td>20708</td>\n",
       "      <td>2575</td>\n",
       "      <td>2575</td>\n",
       "      <td>532</td>\n",
       "      <td>98</td>\n",
       "      <td>1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 207.06, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020706</th>\n",
       "      <td>20706</td>\n",
       "      <td>3433</td>\n",
       "      <td>3433</td>\n",
       "      <td>1016</td>\n",
       "      <td>242</td>\n",
       "      <td>2175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 207.07, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020707</th>\n",
       "      <td>20707</td>\n",
       "      <td>3359</td>\n",
       "      <td>3346</td>\n",
       "      <td>709</td>\n",
       "      <td>121</td>\n",
       "      <td>2516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 208.01, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020801</th>\n",
       "      <td>20801</td>\n",
       "      <td>1437</td>\n",
       "      <td>1437</td>\n",
       "      <td>304</td>\n",
       "      <td>100</td>\n",
       "      <td>1033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 208.02, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020802</th>\n",
       "      <td>20802</td>\n",
       "      <td>2592</td>\n",
       "      <td>2578</td>\n",
       "      <td>526</td>\n",
       "      <td>235</td>\n",
       "      <td>1817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 208.03, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020803</th>\n",
       "      <td>20803</td>\n",
       "      <td>2993</td>\n",
       "      <td>2952</td>\n",
       "      <td>700</td>\n",
       "      <td>386</td>\n",
       "      <td>1866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 208.04, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020804</th>\n",
       "      <td>20804</td>\n",
       "      <td>2963</td>\n",
       "      <td>2963</td>\n",
       "      <td>746</td>\n",
       "      <td>610</td>\n",
       "      <td>1607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 208.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020805</th>\n",
       "      <td>20805</td>\n",
       "      <td>5541</td>\n",
       "      <td>5427</td>\n",
       "      <td>1263</td>\n",
       "      <td>1076</td>\n",
       "      <td>3088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 209.03, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020903</th>\n",
       "      <td>20903</td>\n",
       "      <td>5428</td>\n",
       "      <td>5398</td>\n",
       "      <td>1195</td>\n",
       "      <td>557</td>\n",
       "      <td>3646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 101.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010103</th>\n",
       "      <td>10103</td>\n",
       "      <td>21490</td>\n",
       "      <td>21461</td>\n",
       "      <td>1267</td>\n",
       "      <td>1020</td>\n",
       "      <td>19174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 101.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010104</th>\n",
       "      <td>10104</td>\n",
       "      <td>4781</td>\n",
       "      <td>4781</td>\n",
       "      <td>357</td>\n",
       "      <td>394</td>\n",
       "      <td>4030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 103.08, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010308</th>\n",
       "      <td>10308</td>\n",
       "      <td>5724</td>\n",
       "      <td>5724</td>\n",
       "      <td>459</td>\n",
       "      <td>262</td>\n",
       "      <td>5003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 103.09, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010309</th>\n",
       "      <td>10309</td>\n",
       "      <td>9542</td>\n",
       "      <td>9526</td>\n",
       "      <td>291</td>\n",
       "      <td>504</td>\n",
       "      <td>8731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.10, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010410</th>\n",
       "      <td>10410</td>\n",
       "      <td>4083</td>\n",
       "      <td>4054</td>\n",
       "      <td>1101</td>\n",
       "      <td>758</td>\n",
       "      <td>2195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.11, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010411</th>\n",
       "      <td>10411</td>\n",
       "      <td>3666</td>\n",
       "      <td>3666</td>\n",
       "      <td>1220</td>\n",
       "      <td>477</td>\n",
       "      <td>1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.12, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010412</th>\n",
       "      <td>10412</td>\n",
       "      <td>3011</td>\n",
       "      <td>3011</td>\n",
       "      <td>580</td>\n",
       "      <td>351</td>\n",
       "      <td>2080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.13, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010413</th>\n",
       "      <td>10413</td>\n",
       "      <td>2162</td>\n",
       "      <td>1956</td>\n",
       "      <td>285</td>\n",
       "      <td>519</td>\n",
       "      <td>1152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 108.05, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010805</th>\n",
       "      <td>10805</td>\n",
       "      <td>2698</td>\n",
       "      <td>2608</td>\n",
       "      <td>519</td>\n",
       "      <td>744</td>\n",
       "      <td>1345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 108.06, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010806</th>\n",
       "      <td>10806</td>\n",
       "      <td>1054</td>\n",
       "      <td>181</td>\n",
       "      <td>148</td>\n",
       "      <td>25</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.11, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011411</th>\n",
       "      <td>11411</td>\n",
       "      <td>4068</td>\n",
       "      <td>4068</td>\n",
       "      <td>531</td>\n",
       "      <td>203</td>\n",
       "      <td>3334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.12, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011412</th>\n",
       "      <td>11412</td>\n",
       "      <td>4982</td>\n",
       "      <td>4965</td>\n",
       "      <td>846</td>\n",
       "      <td>322</td>\n",
       "      <td>3797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.13, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011413</th>\n",
       "      <td>11413</td>\n",
       "      <td>8466</td>\n",
       "      <td>8386</td>\n",
       "      <td>637</td>\n",
       "      <td>490</td>\n",
       "      <td>7259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.14, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011414</th>\n",
       "      <td>11414</td>\n",
       "      <td>5668</td>\n",
       "      <td>5575</td>\n",
       "      <td>450</td>\n",
       "      <td>417</td>\n",
       "      <td>4708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.15, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011415</th>\n",
       "      <td>11415</td>\n",
       "      <td>12487</td>\n",
       "      <td>12464</td>\n",
       "      <td>931</td>\n",
       "      <td>934</td>\n",
       "      <td>10599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.16, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011416</th>\n",
       "      <td>11416</td>\n",
       "      <td>14051</td>\n",
       "      <td>14051</td>\n",
       "      <td>1296</td>\n",
       "      <td>1174</td>\n",
       "      <td>11581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.17, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011417</th>\n",
       "      <td>11417</td>\n",
       "      <td>8508</td>\n",
       "      <td>8458</td>\n",
       "      <td>472</td>\n",
       "      <td>471</td>\n",
       "      <td>7515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.18, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011418</th>\n",
       "      <td>11418</td>\n",
       "      <td>4099</td>\n",
       "      <td>4099</td>\n",
       "      <td>302</td>\n",
       "      <td>480</td>\n",
       "      <td>3317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.19, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011419</th>\n",
       "      <td>11419</td>\n",
       "      <td>4307</td>\n",
       "      <td>4307</td>\n",
       "      <td>705</td>\n",
       "      <td>262</td>\n",
       "      <td>3340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 115.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011501</th>\n",
       "      <td>11501</td>\n",
       "      <td>11709</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 115.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011502</th>\n",
       "      <td>11502</td>\n",
       "      <td>3271</td>\n",
       "      <td>2740</td>\n",
       "      <td>5</td>\n",
       "      <td>591</td>\n",
       "      <td>2144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 116.07, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011607</th>\n",
       "      <td>11607</td>\n",
       "      <td>4082</td>\n",
       "      <td>4049</td>\n",
       "      <td>997</td>\n",
       "      <td>496</td>\n",
       "      <td>2556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 116.08, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011608</th>\n",
       "      <td>11608</td>\n",
       "      <td>6298</td>\n",
       "      <td>6298</td>\n",
       "      <td>963</td>\n",
       "      <td>589</td>\n",
       "      <td>4746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 9801, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:980100</th>\n",
       "      <td>980100</td>\n",
       "      <td>266</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 31, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:003100</th>\n",
       "      <td>3100</td>\n",
       "      <td>1304</td>\n",
       "      <td>1254</td>\n",
       "      <td>669</td>\n",
       "      <td>90</td>\n",
       "      <td>495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 22, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002200</th>\n",
       "      <td>2200</td>\n",
       "      <td>1135</td>\n",
       "      <td>1135</td>\n",
       "      <td>183</td>\n",
       "      <td>39</td>\n",
       "      <td>913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 103.05, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010305</th>\n",
       "      <td>10305</td>\n",
       "      <td>7209</td>\n",
       "      <td>7209</td>\n",
       "      <td>392</td>\n",
       "      <td>856</td>\n",
       "      <td>5961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 119.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011902</th>\n",
       "      <td>11902</td>\n",
       "      <td>5337</td>\n",
       "      <td>5301</td>\n",
       "      <td>618</td>\n",
       "      <td>648</td>\n",
       "      <td>4035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 111.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011102</th>\n",
       "      <td>11102</td>\n",
       "      <td>4088</td>\n",
       "      <td>4049</td>\n",
       "      <td>271</td>\n",
       "      <td>181</td>\n",
       "      <td>3597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 113.05, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011305</th>\n",
       "      <td>11305</td>\n",
       "      <td>5597</td>\n",
       "      <td>5477</td>\n",
       "      <td>1085</td>\n",
       "      <td>1023</td>\n",
       "      <td>3369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 24, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002400</th>\n",
       "      <td>2400</td>\n",
       "      <td>3676</td>\n",
       "      <td>3676</td>\n",
       "      <td>309</td>\n",
       "      <td>199</td>\n",
       "      <td>3168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 28, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002800</th>\n",
       "      <td>2800</td>\n",
       "      <td>6527</td>\n",
       "      <td>3724</td>\n",
       "      <td>2274</td>\n",
       "      <td>340</td>\n",
       "      <td>1110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 117.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011702</th>\n",
       "      <td>11702</td>\n",
       "      <td>3844</td>\n",
       "      <td>2953</td>\n",
       "      <td>884</td>\n",
       "      <td>367</td>\n",
       "      <td>1702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 2, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000200</th>\n",
       "      <td>200</td>\n",
       "      <td>1620</td>\n",
       "      <td>1606</td>\n",
       "      <td>429</td>\n",
       "      <td>422</td>\n",
       "      <td>755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 23, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002300</th>\n",
       "      <td>2300</td>\n",
       "      <td>2180</td>\n",
       "      <td>2169</td>\n",
       "      <td>104</td>\n",
       "      <td>30</td>\n",
       "      <td>2035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 101.02, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010102</th>\n",
       "      <td>10102</td>\n",
       "      <td>9657</td>\n",
       "      <td>9641</td>\n",
       "      <td>1641</td>\n",
       "      <td>334</td>\n",
       "      <td>7666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 103.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010304</th>\n",
       "      <td>10304</td>\n",
       "      <td>7624</td>\n",
       "      <td>7578</td>\n",
       "      <td>1592</td>\n",
       "      <td>1082</td>\n",
       "      <td>4904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 110, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011000</th>\n",
       "      <td>11000</td>\n",
       "      <td>1826</td>\n",
       "      <td>1792</td>\n",
       "      <td>340</td>\n",
       "      <td>167</td>\n",
       "      <td>1285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 105.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010501</th>\n",
       "      <td>10501</td>\n",
       "      <td>1932</td>\n",
       "      <td>1632</td>\n",
       "      <td>261</td>\n",
       "      <td>213</td>\n",
       "      <td>1158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 111.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011101</th>\n",
       "      <td>11101</td>\n",
       "      <td>3254</td>\n",
       "      <td>3135</td>\n",
       "      <td>462</td>\n",
       "      <td>253</td>\n",
       "      <td>2420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 103.07, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010307</th>\n",
       "      <td>10307</td>\n",
       "      <td>11767</td>\n",
       "      <td>11767</td>\n",
       "      <td>369</td>\n",
       "      <td>154</td>\n",
       "      <td>11244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 107.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010701</th>\n",
       "      <td>10701</td>\n",
       "      <td>2833</td>\n",
       "      <td>2833</td>\n",
       "      <td>545</td>\n",
       "      <td>827</td>\n",
       "      <td>1461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 108.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010804</th>\n",
       "      <td>10804</td>\n",
       "      <td>2489</td>\n",
       "      <td>2448</td>\n",
       "      <td>829</td>\n",
       "      <td>308</td>\n",
       "      <td>1311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 119.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011901</th>\n",
       "      <td>11901</td>\n",
       "      <td>8539</td>\n",
       "      <td>8468</td>\n",
       "      <td>758</td>\n",
       "      <td>997</td>\n",
       "      <td>6713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 109, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010900</th>\n",
       "      <td>10900</td>\n",
       "      <td>2922</td>\n",
       "      <td>2821</td>\n",
       "      <td>1451</td>\n",
       "      <td>566</td>\n",
       "      <td>804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 113.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011303</th>\n",
       "      <td>11303</td>\n",
       "      <td>5006</td>\n",
       "      <td>4920</td>\n",
       "      <td>475</td>\n",
       "      <td>481</td>\n",
       "      <td>3964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 114.07, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011407</th>\n",
       "      <td>11407</td>\n",
       "      <td>4539</td>\n",
       "      <td>4530</td>\n",
       "      <td>482</td>\n",
       "      <td>577</td>\n",
       "      <td>3471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 116.06, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011606</th>\n",
       "      <td>11606</td>\n",
       "      <td>5057</td>\n",
       "      <td>5035</td>\n",
       "      <td>481</td>\n",
       "      <td>644</td>\n",
       "      <td>3910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 117.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011701</th>\n",
       "      <td>11701</td>\n",
       "      <td>4841</td>\n",
       "      <td>4841</td>\n",
       "      <td>2974</td>\n",
       "      <td>789</td>\n",
       "      <td>1078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 1, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000100</th>\n",
       "      <td>100</td>\n",
       "      <td>2244</td>\n",
       "      <td>1903</td>\n",
       "      <td>529</td>\n",
       "      <td>351</td>\n",
       "      <td>1023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 5, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000500</th>\n",
       "      <td>500</td>\n",
       "      <td>2220</td>\n",
       "      <td>2210</td>\n",
       "      <td>1007</td>\n",
       "      <td>417</td>\n",
       "      <td>786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 6, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000600</th>\n",
       "      <td>600</td>\n",
       "      <td>2110</td>\n",
       "      <td>2110</td>\n",
       "      <td>311</td>\n",
       "      <td>276</td>\n",
       "      <td>1523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 10, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:001000</th>\n",
       "      <td>1000</td>\n",
       "      <td>3236</td>\n",
       "      <td>1525</td>\n",
       "      <td>668</td>\n",
       "      <td>297</td>\n",
       "      <td>560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 21, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002100</th>\n",
       "      <td>2100</td>\n",
       "      <td>2866</td>\n",
       "      <td>2854</td>\n",
       "      <td>794</td>\n",
       "      <td>130</td>\n",
       "      <td>1930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 209.04, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020904</th>\n",
       "      <td>20904</td>\n",
       "      <td>2827</td>\n",
       "      <td>2745</td>\n",
       "      <td>337</td>\n",
       "      <td>127</td>\n",
       "      <td>2281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 209.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020905</th>\n",
       "      <td>20905</td>\n",
       "      <td>3597</td>\n",
       "      <td>3563</td>\n",
       "      <td>1027</td>\n",
       "      <td>332</td>\n",
       "      <td>2204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 209.07, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020907</th>\n",
       "      <td>20907</td>\n",
       "      <td>7954</td>\n",
       "      <td>7929</td>\n",
       "      <td>1380</td>\n",
       "      <td>497</td>\n",
       "      <td>6052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 209.08, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020908</th>\n",
       "      <td>20908</td>\n",
       "      <td>3551</td>\n",
       "      <td>3530</td>\n",
       "      <td>226</td>\n",
       "      <td>262</td>\n",
       "      <td>3042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.19, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021019</th>\n",
       "      <td>21019</td>\n",
       "      <td>1866</td>\n",
       "      <td>1854</td>\n",
       "      <td>71</td>\n",
       "      <td>78</td>\n",
       "      <td>1705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.20, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021020</th>\n",
       "      <td>21020</td>\n",
       "      <td>4327</td>\n",
       "      <td>4306</td>\n",
       "      <td>328</td>\n",
       "      <td>333</td>\n",
       "      <td>3645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.21, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021021</th>\n",
       "      <td>21021</td>\n",
       "      <td>1877</td>\n",
       "      <td>1877</td>\n",
       "      <td>93</td>\n",
       "      <td>131</td>\n",
       "      <td>1653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 209.06, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020906</th>\n",
       "      <td>20906</td>\n",
       "      <td>3763</td>\n",
       "      <td>3735</td>\n",
       "      <td>1052</td>\n",
       "      <td>272</td>\n",
       "      <td>2411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.22, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021022</th>\n",
       "      <td>21022</td>\n",
       "      <td>5820</td>\n",
       "      <td>5804</td>\n",
       "      <td>69</td>\n",
       "      <td>551</td>\n",
       "      <td>5184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.23, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021023</th>\n",
       "      <td>21023</td>\n",
       "      <td>2871</td>\n",
       "      <td>2848</td>\n",
       "      <td>175</td>\n",
       "      <td>210</td>\n",
       "      <td>2463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.24, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021024</th>\n",
       "      <td>21024</td>\n",
       "      <td>6484</td>\n",
       "      <td>6459</td>\n",
       "      <td>298</td>\n",
       "      <td>106</td>\n",
       "      <td>6055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.25, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021025</th>\n",
       "      <td>21025</td>\n",
       "      <td>3968</td>\n",
       "      <td>3968</td>\n",
       "      <td>346</td>\n",
       "      <td>88</td>\n",
       "      <td>3534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.26, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021026</th>\n",
       "      <td>21026</td>\n",
       "      <td>5018</td>\n",
       "      <td>5018</td>\n",
       "      <td>175</td>\n",
       "      <td>274</td>\n",
       "      <td>4569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.27, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021027</th>\n",
       "      <td>21027</td>\n",
       "      <td>4475</td>\n",
       "      <td>4053</td>\n",
       "      <td>237</td>\n",
       "      <td>46</td>\n",
       "      <td>3770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.28, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021028</th>\n",
       "      <td>21028</td>\n",
       "      <td>3250</td>\n",
       "      <td>3250</td>\n",
       "      <td>392</td>\n",
       "      <td>97</td>\n",
       "      <td>2761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.29, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021029</th>\n",
       "      <td>21029</td>\n",
       "      <td>4084</td>\n",
       "      <td>2668</td>\n",
       "      <td>400</td>\n",
       "      <td>330</td>\n",
       "      <td>1938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.30, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021030</th>\n",
       "      <td>21030</td>\n",
       "      <td>4974</td>\n",
       "      <td>4862</td>\n",
       "      <td>458</td>\n",
       "      <td>211</td>\n",
       "      <td>4193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.31, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021031</th>\n",
       "      <td>21031</td>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>504</td>\n",
       "      <td>148</td>\n",
       "      <td>3301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.32, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021032</th>\n",
       "      <td>21032</td>\n",
       "      <td>3940</td>\n",
       "      <td>3940</td>\n",
       "      <td>43</td>\n",
       "      <td>132</td>\n",
       "      <td>3765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.33, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021033</th>\n",
       "      <td>21033</td>\n",
       "      <td>4944</td>\n",
       "      <td>4944</td>\n",
       "      <td>138</td>\n",
       "      <td>521</td>\n",
       "      <td>4285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.34, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021034</th>\n",
       "      <td>21034</td>\n",
       "      <td>4879</td>\n",
       "      <td>4824</td>\n",
       "      <td>631</td>\n",
       "      <td>350</td>\n",
       "      <td>3843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 7, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000700</th>\n",
       "      <td>700</td>\n",
       "      <td>1778</td>\n",
       "      <td>1705</td>\n",
       "      <td>328</td>\n",
       "      <td>235</td>\n",
       "      <td>1142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.09, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021109</th>\n",
       "      <td>21109</td>\n",
       "      <td>3307</td>\n",
       "      <td>3307</td>\n",
       "      <td>129</td>\n",
       "      <td>364</td>\n",
       "      <td>2814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.10, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021110</th>\n",
       "      <td>21110</td>\n",
       "      <td>2979</td>\n",
       "      <td>2979</td>\n",
       "      <td>107</td>\n",
       "      <td>95</td>\n",
       "      <td>2777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.11, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021111</th>\n",
       "      <td>21111</td>\n",
       "      <td>2578</td>\n",
       "      <td>2578</td>\n",
       "      <td>195</td>\n",
       "      <td>201</td>\n",
       "      <td>2182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.12, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021112</th>\n",
       "      <td>21112</td>\n",
       "      <td>2831</td>\n",
       "      <td>2822</td>\n",
       "      <td>0</td>\n",
       "      <td>331</td>\n",
       "      <td>2491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.13, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021113</th>\n",
       "      <td>21113</td>\n",
       "      <td>3407</td>\n",
       "      <td>3407</td>\n",
       "      <td>503</td>\n",
       "      <td>191</td>\n",
       "      <td>2713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.14, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021114</th>\n",
       "      <td>21114</td>\n",
       "      <td>3648</td>\n",
       "      <td>3603</td>\n",
       "      <td>340</td>\n",
       "      <td>103</td>\n",
       "      <td>3160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.15, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021115</th>\n",
       "      <td>21115</td>\n",
       "      <td>2466</td>\n",
       "      <td>2466</td>\n",
       "      <td>265</td>\n",
       "      <td>20</td>\n",
       "      <td>2181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 211.16, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021116</th>\n",
       "      <td>21116</td>\n",
       "      <td>3124</td>\n",
       "      <td>3120</td>\n",
       "      <td>150</td>\n",
       "      <td>100</td>\n",
       "      <td>2870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 212.03, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021203</th>\n",
       "      <td>21203</td>\n",
       "      <td>6244</td>\n",
       "      <td>6233</td>\n",
       "      <td>85</td>\n",
       "      <td>83</td>\n",
       "      <td>6065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 212.04, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021204</th>\n",
       "      <td>21204</td>\n",
       "      <td>4370</td>\n",
       "      <td>4348</td>\n",
       "      <td>352</td>\n",
       "      <td>283</td>\n",
       "      <td>3713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 212.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021205</th>\n",
       "      <td>21205</td>\n",
       "      <td>3225</td>\n",
       "      <td>3216</td>\n",
       "      <td>147</td>\n",
       "      <td>135</td>\n",
       "      <td>2934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 212.06, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021206</th>\n",
       "      <td>21206</td>\n",
       "      <td>3326</td>\n",
       "      <td>3326</td>\n",
       "      <td>115</td>\n",
       "      <td>142</td>\n",
       "      <td>3069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 213.03, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021303</th>\n",
       "      <td>21303</td>\n",
       "      <td>4309</td>\n",
       "      <td>4309</td>\n",
       "      <td>460</td>\n",
       "      <td>115</td>\n",
       "      <td>3734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 213.04, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021304</th>\n",
       "      <td>21304</td>\n",
       "      <td>3720</td>\n",
       "      <td>3720</td>\n",
       "      <td>331</td>\n",
       "      <td>402</td>\n",
       "      <td>2987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 27, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:002700</th>\n",
       "      <td>2700</td>\n",
       "      <td>2861</td>\n",
       "      <td>2699</td>\n",
       "      <td>604</td>\n",
       "      <td>330</td>\n",
       "      <td>1765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.07, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010407</th>\n",
       "      <td>10407</td>\n",
       "      <td>3933</td>\n",
       "      <td>3933</td>\n",
       "      <td>1031</td>\n",
       "      <td>460</td>\n",
       "      <td>2442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 104.09, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010409</th>\n",
       "      <td>10409</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>330</td>\n",
       "      <td>330</td>\n",
       "      <td>1140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 108.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:010803</th>\n",
       "      <td>10803</td>\n",
       "      <td>2195</td>\n",
       "      <td>2195</td>\n",
       "      <td>826</td>\n",
       "      <td>228</td>\n",
       "      <td>1141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 113.01, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011301</th>\n",
       "      <td>11301</td>\n",
       "      <td>5937</td>\n",
       "      <td>5916</td>\n",
       "      <td>678</td>\n",
       "      <td>100</td>\n",
       "      <td>5138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 113.04, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011304</th>\n",
       "      <td>11304</td>\n",
       "      <td>4932</td>\n",
       "      <td>4927</td>\n",
       "      <td>1167</td>\n",
       "      <td>495</td>\n",
       "      <td>3265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 116.03, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011603</th>\n",
       "      <td>11603</td>\n",
       "      <td>5835</td>\n",
       "      <td>5835</td>\n",
       "      <td>358</td>\n",
       "      <td>357</td>\n",
       "      <td>5120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 118, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:011800</th>\n",
       "      <td>11800</td>\n",
       "      <td>5804</td>\n",
       "      <td>5804</td>\n",
       "      <td>757</td>\n",
       "      <td>1058</td>\n",
       "      <td>3989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 4, Richland County, South Carolina: Summary level: 140, state:45&gt; county:079&gt; tract:000400</th>\n",
       "      <td>400</td>\n",
       "      <td>1900</td>\n",
       "      <td>1887</td>\n",
       "      <td>428</td>\n",
       "      <td>232</td>\n",
       "      <td>1227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 202.02, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020202</th>\n",
       "      <td>20202</td>\n",
       "      <td>2392</td>\n",
       "      <td>2365</td>\n",
       "      <td>641</td>\n",
       "      <td>227</td>\n",
       "      <td>1497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 210.18, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021018</th>\n",
       "      <td>21018</td>\n",
       "      <td>4741</td>\n",
       "      <td>4741</td>\n",
       "      <td>964</td>\n",
       "      <td>284</td>\n",
       "      <td>3493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 214.02, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:021402</th>\n",
       "      <td>21402</td>\n",
       "      <td>3726</td>\n",
       "      <td>3721</td>\n",
       "      <td>755</td>\n",
       "      <td>445</td>\n",
       "      <td>2521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 206.04, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020604</th>\n",
       "      <td>20604</td>\n",
       "      <td>3424</td>\n",
       "      <td>3424</td>\n",
       "      <td>284</td>\n",
       "      <td>190</td>\n",
       "      <td>2950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.06, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020506</th>\n",
       "      <td>20506</td>\n",
       "      <td>5208</td>\n",
       "      <td>4968</td>\n",
       "      <td>353</td>\n",
       "      <td>539</td>\n",
       "      <td>4076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.09, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020509</th>\n",
       "      <td>20509</td>\n",
       "      <td>3404</td>\n",
       "      <td>3376</td>\n",
       "      <td>688</td>\n",
       "      <td>583</td>\n",
       "      <td>2105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.10, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020510</th>\n",
       "      <td>20510</td>\n",
       "      <td>4598</td>\n",
       "      <td>4598</td>\n",
       "      <td>442</td>\n",
       "      <td>520</td>\n",
       "      <td>3636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 206.02, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020602</th>\n",
       "      <td>20602</td>\n",
       "      <td>4346</td>\n",
       "      <td>4327</td>\n",
       "      <td>604</td>\n",
       "      <td>373</td>\n",
       "      <td>3350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 201, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020100</th>\n",
       "      <td>20100</td>\n",
       "      <td>2745</td>\n",
       "      <td>2745</td>\n",
       "      <td>296</td>\n",
       "      <td>237</td>\n",
       "      <td>2212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.05, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020505</th>\n",
       "      <td>20505</td>\n",
       "      <td>3936</td>\n",
       "      <td>3936</td>\n",
       "      <td>892</td>\n",
       "      <td>420</td>\n",
       "      <td>2624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Census Tract 205.07, Lexington County, South Carolina: Summary level: 140, state:45&gt; county:063&gt; tract:020507</th>\n",
       "      <td>20507</td>\n",
       "      <td>6693</td>\n",
       "      <td>6688</td>\n",
       "      <td>1427</td>\n",
       "      <td>559</td>\n",
       "      <td>4702</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     TRACT  B01003_001E  \\\n",
       "Census Tract 25, Richland County, South Carolin...    2500         3743   \n",
       "Census Tract 26.02, Richland County, South Caro...    2602         3026   \n",
       "Census Tract 104.08, Richland County, South Car...   10408         4439   \n",
       "Census Tract 206.05, Lexington County, South Ca...   20605         2457   \n",
       "Census Tract 211.06, Lexington County, South Ca...   21106         2825   \n",
       "Census Tract 205.08, Lexington County, South Ca...   20508         2051   \n",
       "Census Tract 203, Lexington County, South Carol...   20300         3949   \n",
       "Census Tract 205.11, Lexington County, South Ca...   20511         3552   \n",
       "Census Tract 202.01, Lexington County, South Ca...   20201         2864   \n",
       "Census Tract 206.01, Lexington County, South Ca...   20601         4384   \n",
       "Census Tract 207.03, Lexington County, South Ca...   20703         4547   \n",
       "Census Tract 105.02, Richland County, South Car...   10502         1211   \n",
       "Census Tract 106, Richland County, South Caroli...   10600         4160   \n",
       "Census Tract 107.02, Richland County, South Car...   10702         3823   \n",
       "Census Tract 107.03, Richland County, South Car...   10703         3272   \n",
       "Census Tract 112.01, Richland County, South Car...   11201         1938   \n",
       "Census Tract 114.04, Richland County, South Car...   11404         9196   \n",
       "Census Tract 116.04, Richland County, South Car...   11604         5645   \n",
       "Census Tract 120, Richland County, South Caroli...   12000         5437   \n",
       "Census Tract 210.17, Lexington County, South Ca...   21017         8580   \n",
       "Census Tract 210.09, Lexington County, South Ca...   21009        11606   \n",
       "Census Tract 210.14, Lexington County, South Ca...   21014         7318   \n",
       "Census Tract 104.03, Richland County, South Car...   10403         3709   \n",
       "Census Tract 3, Richland County, South Carolina...     300         2855   \n",
       "Census Tract 11, Richland County, South Carolin...    1100         3530   \n",
       "Census Tract 12, Richland County, South Carolin...    1200         1852   \n",
       "Census Tract 16, Richland County, South Carolin...    1600         1522   \n",
       "Census Tract 103.06, Richland County, South Car...   10306        12031   \n",
       "Census Tract 112.02, Richland County, South Car...   11202         3456   \n",
       "Census Tract 9, Richland County, South Carolina...     900         2411   \n",
       "Census Tract 102, Richland County, South Caroli...   10200         5427   \n",
       "Census Tract 13, Richland County, South Carolin...    1300         2024   \n",
       "Census Tract 213.05, Lexington County, South Ca...   21305         3261   \n",
       "Census Tract 213.06, Lexington County, South Ca...   21306         3721   \n",
       "Census Tract 213.07, Lexington County, South Ca...   21307         1896   \n",
       "Census Tract 213.08, Lexington County, South Ca...   21308         4480   \n",
       "Census Tract 214.03, Lexington County, South Ca...   21403         2480   \n",
       "Census Tract 214.04, Lexington County, South Ca...   21404         3233   \n",
       "Census Tract 9801, Lexington County, South Caro...  980100            0   \n",
       "Census Tract 26.04, Richland County, South Caro...    2604         1527   \n",
       "Census Tract 26.03, Richland County, South Caro...    2603         3779   \n",
       "Census Tract 29, Richland County, South Carolin...    2900         3790   \n",
       "Census Tract 30, Richland County, South Carolin...    3000         2627   \n",
       "Census Tract 207.05, Lexington County, South Ca...   20705         3584   \n",
       "Census Tract 207.08, Lexington County, South Ca...   20708         2575   \n",
       "Census Tract 207.06, Lexington County, South Ca...   20706         3433   \n",
       "Census Tract 207.07, Lexington County, South Ca...   20707         3359   \n",
       "Census Tract 208.01, Lexington County, South Ca...   20801         1437   \n",
       "Census Tract 208.02, Lexington County, South Ca...   20802         2592   \n",
       "Census Tract 208.03, Lexington County, South Ca...   20803         2993   \n",
       "Census Tract 208.04, Lexington County, South Ca...   20804         2963   \n",
       "Census Tract 208.05, Lexington County, South Ca...   20805         5541   \n",
       "Census Tract 209.03, Lexington County, South Ca...   20903         5428   \n",
       "Census Tract 101.03, Richland County, South Car...   10103        21490   \n",
       "Census Tract 101.04, Richland County, South Car...   10104         4781   \n",
       "Census Tract 103.08, Richland County, South Car...   10308         5724   \n",
       "Census Tract 103.09, Richland County, South Car...   10309         9542   \n",
       "Census Tract 104.10, Richland County, South Car...   10410         4083   \n",
       "Census Tract 104.11, Richland County, South Car...   10411         3666   \n",
       "Census Tract 104.12, Richland County, South Car...   10412         3011   \n",
       "Census Tract 104.13, Richland County, South Car...   10413         2162   \n",
       "Census Tract 108.05, Richland County, South Car...   10805         2698   \n",
       "Census Tract 108.06, Richland County, South Car...   10806         1054   \n",
       "Census Tract 114.11, Richland County, South Car...   11411         4068   \n",
       "Census Tract 114.12, Richland County, South Car...   11412         4982   \n",
       "Census Tract 114.13, Richland County, South Car...   11413         8466   \n",
       "Census Tract 114.14, Richland County, South Car...   11414         5668   \n",
       "Census Tract 114.15, Richland County, South Car...   11415        12487   \n",
       "Census Tract 114.16, Richland County, South Car...   11416        14051   \n",
       "Census Tract 114.17, Richland County, South Car...   11417         8508   \n",
       "Census Tract 114.18, Richland County, South Car...   11418         4099   \n",
       "Census Tract 114.19, Richland County, South Car...   11419         4307   \n",
       "Census Tract 115.01, Richland County, South Car...   11501        11709   \n",
       "Census Tract 115.02, Richland County, South Car...   11502         3271   \n",
       "Census Tract 116.07, Richland County, South Car...   11607         4082   \n",
       "Census Tract 116.08, Richland County, South Car...   11608         6298   \n",
       "Census Tract 9801, Richland County, South Carol...  980100          266   \n",
       "Census Tract 31, Richland County, South Carolin...    3100         1304   \n",
       "Census Tract 22, Richland County, South Carolin...    2200         1135   \n",
       "Census Tract 103.05, Richland County, South Car...   10305         7209   \n",
       "Census Tract 119.02, Richland County, South Car...   11902         5337   \n",
       "Census Tract 111.02, Richland County, South Car...   11102         4088   \n",
       "Census Tract 113.05, Richland County, South Car...   11305         5597   \n",
       "Census Tract 24, Richland County, South Carolin...    2400         3676   \n",
       "Census Tract 28, Richland County, South Carolin...    2800         6527   \n",
       "Census Tract 117.02, Richland County, South Car...   11702         3844   \n",
       "Census Tract 2, Richland County, South Carolina...     200         1620   \n",
       "Census Tract 23, Richland County, South Carolin...    2300         2180   \n",
       "Census Tract 101.02, Richland County, South Car...   10102         9657   \n",
       "Census Tract 103.04, Richland County, South Car...   10304         7624   \n",
       "Census Tract 110, Richland County, South Caroli...   11000         1826   \n",
       "Census Tract 105.01, Richland County, South Car...   10501         1932   \n",
       "Census Tract 111.01, Richland County, South Car...   11101         3254   \n",
       "Census Tract 103.07, Richland County, South Car...   10307        11767   \n",
       "Census Tract 107.01, Richland County, South Car...   10701         2833   \n",
       "Census Tract 108.04, Richland County, South Car...   10804         2489   \n",
       "Census Tract 119.01, Richland County, South Car...   11901         8539   \n",
       "Census Tract 109, Richland County, South Caroli...   10900         2922   \n",
       "Census Tract 113.03, Richland County, South Car...   11303         5006   \n",
       "Census Tract 114.07, Richland County, South Car...   11407         4539   \n",
       "Census Tract 116.06, Richland County, South Car...   11606         5057   \n",
       "Census Tract 117.01, Richland County, South Car...   11701         4841   \n",
       "Census Tract 1, Richland County, South Carolina...     100         2244   \n",
       "Census Tract 5, Richland County, South Carolina...     500         2220   \n",
       "Census Tract 6, Richland County, South Carolina...     600         2110   \n",
       "Census Tract 10, Richland County, South Carolin...    1000         3236   \n",
       "Census Tract 21, Richland County, South Carolin...    2100         2866   \n",
       "Census Tract 209.04, Lexington County, South Ca...   20904         2827   \n",
       "Census Tract 209.05, Lexington County, South Ca...   20905         3597   \n",
       "Census Tract 209.07, Lexington County, South Ca...   20907         7954   \n",
       "Census Tract 209.08, Lexington County, South Ca...   20908         3551   \n",
       "Census Tract 210.19, Lexington County, South Ca...   21019         1866   \n",
       "Census Tract 210.20, Lexington County, South Ca...   21020         4327   \n",
       "Census Tract 210.21, Lexington County, South Ca...   21021         1877   \n",
       "Census Tract 209.06, Lexington County, South Ca...   20906         3763   \n",
       "Census Tract 210.22, Lexington County, South Ca...   21022         5820   \n",
       "Census Tract 210.23, Lexington County, South Ca...   21023         2871   \n",
       "Census Tract 210.24, Lexington County, South Ca...   21024         6484   \n",
       "Census Tract 210.25, Lexington County, South Ca...   21025         3968   \n",
       "Census Tract 210.26, Lexington County, South Ca...   21026         5018   \n",
       "Census Tract 210.27, Lexington County, South Ca...   21027         4475   \n",
       "Census Tract 210.28, Lexington County, South Ca...   21028         3250   \n",
       "Census Tract 210.29, Lexington County, South Ca...   21029         4084   \n",
       "Census Tract 210.30, Lexington County, South Ca...   21030         4974   \n",
       "Census Tract 210.31, Lexington County, South Ca...   21031         3953   \n",
       "Census Tract 210.32, Lexington County, South Ca...   21032         3940   \n",
       "Census Tract 210.33, Lexington County, South Ca...   21033         4944   \n",
       "Census Tract 210.34, Lexington County, South Ca...   21034         4879   \n",
       "Census Tract 7, Richland County, South Carolina...     700         1778   \n",
       "Census Tract 211.09, Lexington County, South Ca...   21109         3307   \n",
       "Census Tract 211.10, Lexington County, South Ca...   21110         2979   \n",
       "Census Tract 211.11, Lexington County, South Ca...   21111         2578   \n",
       "Census Tract 211.12, Lexington County, South Ca...   21112         2831   \n",
       "Census Tract 211.13, Lexington County, South Ca...   21113         3407   \n",
       "Census Tract 211.14, Lexington County, South Ca...   21114         3648   \n",
       "Census Tract 211.15, Lexington County, South Ca...   21115         2466   \n",
       "Census Tract 211.16, Lexington County, South Ca...   21116         3124   \n",
       "Census Tract 212.03, Lexington County, South Ca...   21203         6244   \n",
       "Census Tract 212.04, Lexington County, South Ca...   21204         4370   \n",
       "Census Tract 212.05, Lexington County, South Ca...   21205         3225   \n",
       "Census Tract 212.06, Lexington County, South Ca...   21206         3326   \n",
       "Census Tract 213.03, Lexington County, South Ca...   21303         4309   \n",
       "Census Tract 213.04, Lexington County, South Ca...   21304         3720   \n",
       "Census Tract 27, Richland County, South Carolin...    2700         2861   \n",
       "Census Tract 104.07, Richland County, South Car...   10407         3933   \n",
       "Census Tract 104.09, Richland County, South Car...   10409         1800   \n",
       "Census Tract 108.03, Richland County, South Car...   10803         2195   \n",
       "Census Tract 113.01, Richland County, South Car...   11301         5937   \n",
       "Census Tract 113.04, Richland County, South Car...   11304         4932   \n",
       "Census Tract 116.03, Richland County, South Car...   11603         5835   \n",
       "Census Tract 118, Richland County, South Caroli...   11800         5804   \n",
       "Census Tract 4, Richland County, South Carolina...     400         1900   \n",
       "Census Tract 202.02, Lexington County, South Ca...   20202         2392   \n",
       "Census Tract 210.18, Lexington County, South Ca...   21018         4741   \n",
       "Census Tract 214.02, Lexington County, South Ca...   21402         3726   \n",
       "Census Tract 206.04, Lexington County, South Ca...   20604         3424   \n",
       "Census Tract 205.06, Lexington County, South Ca...   20506         5208   \n",
       "Census Tract 205.09, Lexington County, South Ca...   20509         3404   \n",
       "Census Tract 205.10, Lexington County, South Ca...   20510         4598   \n",
       "Census Tract 206.02, Lexington County, South Ca...   20602         4346   \n",
       "Census Tract 201, Lexington County, South Carol...   20100         2745   \n",
       "Census Tract 205.05, Lexington County, South Ca...   20505         3936   \n",
       "Census Tract 205.07, Lexington County, South Ca...   20507         6693   \n",
       "\n",
       "                                                    B06012_001E  B06012_002E  \\\n",
       "Census Tract 25, Richland County, South Carolin...         3695          280   \n",
       "Census Tract 26.02, Richland County, South Caro...         3011          516   \n",
       "Census Tract 104.08, Richland County, South Car...          200          183   \n",
       "Census Tract 206.05, Lexington County, South Ca...         2457          223   \n",
       "Census Tract 211.06, Lexington County, South Ca...         2825          103   \n",
       "Census Tract 205.08, Lexington County, South Ca...         1959           51   \n",
       "Census Tract 203, Lexington County, South Carol...         3863         1139   \n",
       "Census Tract 205.11, Lexington County, South Ca...         3244          305   \n",
       "Census Tract 202.01, Lexington County, South Ca...         2864          752   \n",
       "Census Tract 206.01, Lexington County, South Ca...         4384          478   \n",
       "Census Tract 207.03, Lexington County, South Ca...         4547          951   \n",
       "Census Tract 105.02, Richland County, South Car...         1211          591   \n",
       "Census Tract 106, Richland County, South Caroli...         4124         1626   \n",
       "Census Tract 107.02, Richland County, South Car...         3823         1004   \n",
       "Census Tract 107.03, Richland County, South Car...         3272         1343   \n",
       "Census Tract 112.01, Richland County, South Car...         1938           53   \n",
       "Census Tract 114.04, Richland County, South Car...         9152         1746   \n",
       "Census Tract 116.04, Richland County, South Car...         5582          311   \n",
       "Census Tract 120, Richland County, South Caroli...         5399         1090   \n",
       "Census Tract 210.17, Lexington County, South Ca...         8580          962   \n",
       "Census Tract 210.09, Lexington County, South Ca...        11526         1008   \n",
       "Census Tract 210.14, Lexington County, South Ca...         7318          160   \n",
       "Census Tract 104.03, Richland County, South Car...         3702          528   \n",
       "Census Tract 3, Richland County, South Carolina...         2855         1337   \n",
       "Census Tract 11, Richland County, South Carolin...         3270          491   \n",
       "Census Tract 12, Richland County, South Carolin...         1801           29   \n",
       "Census Tract 16, Richland County, South Carolin...         1522          427   \n",
       "Census Tract 103.06, Richland County, South Car...        11846          661   \n",
       "Census Tract 112.02, Richland County, South Car...         3456          353   \n",
       "Census Tract 9, Richland County, South Carolina...         2411         1396   \n",
       "Census Tract 102, Richland County, South Caroli...         5422          795   \n",
       "Census Tract 13, Richland County, South Carolin...         1578          509   \n",
       "Census Tract 213.05, Lexington County, South Ca...         3128          699   \n",
       "Census Tract 213.06, Lexington County, South Ca...         3709          380   \n",
       "Census Tract 213.07, Lexington County, South Ca...         1896          380   \n",
       "Census Tract 213.08, Lexington County, South Ca...         4469          689   \n",
       "Census Tract 214.03, Lexington County, South Ca...         2465          515   \n",
       "Census Tract 214.04, Lexington County, South Ca...         3233          349   \n",
       "Census Tract 9801, Lexington County, South Caro...            0            0   \n",
       "Census Tract 26.04, Richland County, South Caro...         1510          363   \n",
       "Census Tract 26.03, Richland County, South Caro...         3779         1116   \n",
       "Census Tract 29, Richland County, South Carolin...         1050          410   \n",
       "Census Tract 30, Richland County, South Carolin...         1614          650   \n",
       "Census Tract 207.05, Lexington County, South Ca...         3568          894   \n",
       "Census Tract 207.08, Lexington County, South Ca...         2575          532   \n",
       "Census Tract 207.06, Lexington County, South Ca...         3433         1016   \n",
       "Census Tract 207.07, Lexington County, South Ca...         3346          709   \n",
       "Census Tract 208.01, Lexington County, South Ca...         1437          304   \n",
       "Census Tract 208.02, Lexington County, South Ca...         2578          526   \n",
       "Census Tract 208.03, Lexington County, South Ca...         2952          700   \n",
       "Census Tract 208.04, Lexington County, South Ca...         2963          746   \n",
       "Census Tract 208.05, Lexington County, South Ca...         5427         1263   \n",
       "Census Tract 209.03, Lexington County, South Ca...         5398         1195   \n",
       "Census Tract 101.03, Richland County, South Car...        21461         1267   \n",
       "Census Tract 101.04, Richland County, South Car...         4781          357   \n",
       "Census Tract 103.08, Richland County, South Car...         5724          459   \n",
       "Census Tract 103.09, Richland County, South Car...         9526          291   \n",
       "Census Tract 104.10, Richland County, South Car...         4054         1101   \n",
       "Census Tract 104.11, Richland County, South Car...         3666         1220   \n",
       "Census Tract 104.12, Richland County, South Car...         3011          580   \n",
       "Census Tract 104.13, Richland County, South Car...         1956          285   \n",
       "Census Tract 108.05, Richland County, South Car...         2608          519   \n",
       "Census Tract 108.06, Richland County, South Car...          181          148   \n",
       "Census Tract 114.11, Richland County, South Car...         4068          531   \n",
       "Census Tract 114.12, Richland County, South Car...         4965          846   \n",
       "Census Tract 114.13, Richland County, South Car...         8386          637   \n",
       "Census Tract 114.14, Richland County, South Car...         5575          450   \n",
       "Census Tract 114.15, Richland County, South Car...        12464          931   \n",
       "Census Tract 114.16, Richland County, South Car...        14051         1296   \n",
       "Census Tract 114.17, Richland County, South Car...         8458          472   \n",
       "Census Tract 114.18, Richland County, South Car...         4099          302   \n",
       "Census Tract 114.19, Richland County, South Car...         4307          705   \n",
       "Census Tract 115.01, Richland County, South Car...            0            0   \n",
       "Census Tract 115.02, Richland County, South Car...         2740            5   \n",
       "Census Tract 116.07, Richland County, South Car...         4049          997   \n",
       "Census Tract 116.08, Richland County, South Car...         6298          963   \n",
       "Census Tract 9801, Richland County, South Carol...            9            4   \n",
       "Census Tract 31, Richland County, South Carolin...         1254          669   \n",
       "Census Tract 22, Richland County, South Carolin...         1135          183   \n",
       "Census Tract 103.05, Richland County, South Car...         7209          392   \n",
       "Census Tract 119.02, Richland County, South Car...         5301          618   \n",
       "Census Tract 111.02, Richland County, South Car...         4049          271   \n",
       "Census Tract 113.05, Richland County, South Car...         5477         1085   \n",
       "Census Tract 24, Richland County, South Carolin...         3676          309   \n",
       "Census Tract 28, Richland County, South Carolin...         3724         2274   \n",
       "Census Tract 117.02, Richland County, South Car...         2953          884   \n",
       "Census Tract 2, Richland County, South Carolina...         1606          429   \n",
       "Census Tract 23, Richland County, South Carolin...         2169          104   \n",
       "Census Tract 101.02, Richland County, South Car...         9641         1641   \n",
       "Census Tract 103.04, Richland County, South Car...         7578         1592   \n",
       "Census Tract 110, Richland County, South Caroli...         1792          340   \n",
       "Census Tract 105.01, Richland County, South Car...         1632          261   \n",
       "Census Tract 111.01, Richland County, South Car...         3135          462   \n",
       "Census Tract 103.07, Richland County, South Car...        11767          369   \n",
       "Census Tract 107.01, Richland County, South Car...         2833          545   \n",
       "Census Tract 108.04, Richland County, South Car...         2448          829   \n",
       "Census Tract 119.01, Richland County, South Car...         8468          758   \n",
       "Census Tract 109, Richland County, South Caroli...         2821         1451   \n",
       "Census Tract 113.03, Richland County, South Car...         4920          475   \n",
       "Census Tract 114.07, Richland County, South Car...         4530          482   \n",
       "Census Tract 116.06, Richland County, South Car...         5035          481   \n",
       "Census Tract 117.01, Richland County, South Car...         4841         2974   \n",
       "Census Tract 1, Richland County, South Carolina...         1903          529   \n",
       "Census Tract 5, Richland County, South Carolina...         2210         1007   \n",
       "Census Tract 6, Richland County, South Carolina...         2110          311   \n",
       "Census Tract 10, Richland County, South Carolin...         1525          668   \n",
       "Census Tract 21, Richland County, South Carolin...         2854          794   \n",
       "Census Tract 209.04, Lexington County, South Ca...         2745          337   \n",
       "Census Tract 209.05, Lexington County, South Ca...         3563         1027   \n",
       "Census Tract 209.07, Lexington County, South Ca...         7929         1380   \n",
       "Census Tract 209.08, Lexington County, South Ca...         3530          226   \n",
       "Census Tract 210.19, Lexington County, South Ca...         1854           71   \n",
       "Census Tract 210.20, Lexington County, South Ca...         4306          328   \n",
       "Census Tract 210.21, Lexington County, South Ca...         1877           93   \n",
       "Census Tract 209.06, Lexington County, South Ca...         3735         1052   \n",
       "Census Tract 210.22, Lexington County, South Ca...         5804           69   \n",
       "Census Tract 210.23, Lexington County, South Ca...         2848          175   \n",
       "Census Tract 210.24, Lexington County, South Ca...         6459          298   \n",
       "Census Tract 210.25, Lexington County, South Ca...         3968          346   \n",
       "Census Tract 210.26, Lexington County, South Ca...         5018          175   \n",
       "Census Tract 210.27, Lexington County, South Ca...         4053          237   \n",
       "Census Tract 210.28, Lexington County, South Ca...         3250          392   \n",
       "Census Tract 210.29, Lexington County, South Ca...         2668          400   \n",
       "Census Tract 210.30, Lexington County, South Ca...         4862          458   \n",
       "Census Tract 210.31, Lexington County, South Ca...         3953          504   \n",
       "Census Tract 210.32, Lexington County, South Ca...         3940           43   \n",
       "Census Tract 210.33, Lexington County, South Ca...         4944          138   \n",
       "Census Tract 210.34, Lexington County, South Ca...         4824          631   \n",
       "Census Tract 7, Richland County, South Carolina...         1705          328   \n",
       "Census Tract 211.09, Lexington County, South Ca...         3307          129   \n",
       "Census Tract 211.10, Lexington County, South Ca...         2979          107   \n",
       "Census Tract 211.11, Lexington County, South Ca...         2578          195   \n",
       "Census Tract 211.12, Lexington County, South Ca...         2822            0   \n",
       "Census Tract 211.13, Lexington County, South Ca...         3407          503   \n",
       "Census Tract 211.14, Lexington County, South Ca...         3603          340   \n",
       "Census Tract 211.15, Lexington County, South Ca...         2466          265   \n",
       "Census Tract 211.16, Lexington County, South Ca...         3120          150   \n",
       "Census Tract 212.03, Lexington County, South Ca...         6233           85   \n",
       "Census Tract 212.04, Lexington County, South Ca...         4348          352   \n",
       "Census Tract 212.05, Lexington County, South Ca...         3216          147   \n",
       "Census Tract 212.06, Lexington County, South Ca...         3326          115   \n",
       "Census Tract 213.03, Lexington County, South Ca...         4309          460   \n",
       "Census Tract 213.04, Lexington County, South Ca...         3720          331   \n",
       "Census Tract 27, Richland County, South Carolin...         2699          604   \n",
       "Census Tract 104.07, Richland County, South Car...         3933         1031   \n",
       "Census Tract 104.09, Richland County, South Car...         1800          330   \n",
       "Census Tract 108.03, Richland County, South Car...         2195          826   \n",
       "Census Tract 113.01, Richland County, South Car...         5916          678   \n",
       "Census Tract 113.04, Richland County, South Car...         4927         1167   \n",
       "Census Tract 116.03, Richland County, South Car...         5835          358   \n",
       "Census Tract 118, Richland County, South Caroli...         5804          757   \n",
       "Census Tract 4, Richland County, South Carolina...         1887          428   \n",
       "Census Tract 202.02, Lexington County, South Ca...         2365          641   \n",
       "Census Tract 210.18, Lexington County, South Ca...         4741          964   \n",
       "Census Tract 214.02, Lexington County, South Ca...         3721          755   \n",
       "Census Tract 206.04, Lexington County, South Ca...         3424          284   \n",
       "Census Tract 205.06, Lexington County, South Ca...         4968          353   \n",
       "Census Tract 205.09, Lexington County, South Ca...         3376          688   \n",
       "Census Tract 205.10, Lexington County, South Ca...         4598          442   \n",
       "Census Tract 206.02, Lexington County, South Ca...         4327          604   \n",
       "Census Tract 201, Lexington County, South Carol...         2745          296   \n",
       "Census Tract 205.05, Lexington County, South Ca...         3936          892   \n",
       "Census Tract 205.07, Lexington County, South Ca...         6688         1427   \n",
       "\n",
       "                                                    B06012_003E  B06012_004E  \n",
       "Census Tract 25, Richland County, South Carolin...          135         3280  \n",
       "Census Tract 26.02, Richland County, South Caro...          248         2247  \n",
       "Census Tract 104.08, Richland County, South Car...           13            4  \n",
       "Census Tract 206.05, Lexington County, South Ca...          218         2016  \n",
       "Census Tract 211.06, Lexington County, South Ca...          273         2449  \n",
       "Census Tract 205.08, Lexington County, South Ca...           75         1833  \n",
       "Census Tract 203, Lexington County, South Carol...          685         2039  \n",
       "Census Tract 205.11, Lexington County, South Ca...          647         2292  \n",
       "Census Tract 202.01, Lexington County, South Ca...          373         1739  \n",
       "Census Tract 206.01, Lexington County, South Ca...          566         3340  \n",
       "Census Tract 207.03, Lexington County, South Ca...          521         3075  \n",
       "Census Tract 105.02, Richland County, South Car...          136          484  \n",
       "Census Tract 106, Richland County, South Caroli...          418         2080  \n",
       "Census Tract 107.02, Richland County, South Car...          453         2366  \n",
       "Census Tract 107.03, Richland County, South Car...          369         1560  \n",
       "Census Tract 112.01, Richland County, South Car...          151         1734  \n",
       "Census Tract 114.04, Richland County, South Car...          896         6510  \n",
       "Census Tract 116.04, Richland County, South Car...          139         5132  \n",
       "Census Tract 120, Richland County, South Caroli...          458         3851  \n",
       "Census Tract 210.17, Lexington County, South Ca...          975         6643  \n",
       "Census Tract 210.09, Lexington County, South Ca...         1042         9476  \n",
       "Census Tract 210.14, Lexington County, South Ca...          246         6912  \n",
       "Census Tract 104.03, Richland County, South Car...          298         2876  \n",
       "Census Tract 3, Richland County, South Carolina...          346         1172  \n",
       "Census Tract 11, Richland County, South Carolin...          452         2327  \n",
       "Census Tract 12, Richland County, South Carolin...           31         1741  \n",
       "Census Tract 16, Richland County, South Carolin...          106          989  \n",
       "Census Tract 103.06, Richland County, South Car...          470        10715  \n",
       "Census Tract 112.02, Richland County, South Car...          160         2943  \n",
       "Census Tract 9, Richland County, South Carolina...          249          766  \n",
       "Census Tract 102, Richland County, South Caroli...          622         4005  \n",
       "Census Tract 13, Richland County, South Carolin...          318          751  \n",
       "Census Tract 213.05, Lexington County, South Ca...          468         1961  \n",
       "Census Tract 213.06, Lexington County, South Ca...          295         3034  \n",
       "Census Tract 213.07, Lexington County, South Ca...          269         1247  \n",
       "Census Tract 213.08, Lexington County, South Ca...          412         3368  \n",
       "Census Tract 214.03, Lexington County, South Ca...          339         1611  \n",
       "Census Tract 214.04, Lexington County, South Ca...          166         2718  \n",
       "Census Tract 9801, Lexington County, South Caro...            0            0  \n",
       "Census Tract 26.04, Richland County, South Caro...          229          918  \n",
       "Census Tract 26.03, Richland County, South Caro...          532         2131  \n",
       "Census Tract 29, Richland County, South Carolin...           49          591  \n",
       "Census Tract 30, Richland County, South Carolin...          194          770  \n",
       "Census Tract 207.05, Lexington County, South Ca...          476         2198  \n",
       "Census Tract 207.08, Lexington County, South Ca...           98         1945  \n",
       "Census Tract 207.06, Lexington County, South Ca...          242         2175  \n",
       "Census Tract 207.07, Lexington County, South Ca...          121         2516  \n",
       "Census Tract 208.01, Lexington County, South Ca...          100         1033  \n",
       "Census Tract 208.02, Lexington County, South Ca...          235         1817  \n",
       "Census Tract 208.03, Lexington County, South Ca...          386         1866  \n",
       "Census Tract 208.04, Lexington County, South Ca...          610         1607  \n",
       "Census Tract 208.05, Lexington County, South Ca...         1076         3088  \n",
       "Census Tract 209.03, Lexington County, South Ca...          557         3646  \n",
       "Census Tract 101.03, Richland County, South Car...         1020        19174  \n",
       "Census Tract 101.04, Richland County, South Car...          394         4030  \n",
       "Census Tract 103.08, Richland County, South Car...          262         5003  \n",
       "Census Tract 103.09, Richland County, South Car...          504         8731  \n",
       "Census Tract 104.10, Richland County, South Car...          758         2195  \n",
       "Census Tract 104.11, Richland County, South Car...          477         1969  \n",
       "Census Tract 104.12, Richland County, South Car...          351         2080  \n",
       "Census Tract 104.13, Richland County, South Car...          519         1152  \n",
       "Census Tract 108.05, Richland County, South Car...          744         1345  \n",
       "Census Tract 108.06, Richland County, South Car...           25            8  \n",
       "Census Tract 114.11, Richland County, South Car...          203         3334  \n",
       "Census Tract 114.12, Richland County, South Car...          322         3797  \n",
       "Census Tract 114.13, Richland County, South Car...          490         7259  \n",
       "Census Tract 114.14, Richland County, South Car...          417         4708  \n",
       "Census Tract 114.15, Richland County, South Car...          934        10599  \n",
       "Census Tract 114.16, Richland County, South Car...         1174        11581  \n",
       "Census Tract 114.17, Richland County, South Car...          471         7515  \n",
       "Census Tract 114.18, Richland County, South Car...          480         3317  \n",
       "Census Tract 114.19, Richland County, South Car...          262         3340  \n",
       "Census Tract 115.01, Richland County, South Car...            0            0  \n",
       "Census Tract 115.02, Richland County, South Car...          591         2144  \n",
       "Census Tract 116.07, Richland County, South Car...          496         2556  \n",
       "Census Tract 116.08, Richland County, South Car...          589         4746  \n",
       "Census Tract 9801, Richland County, South Carol...            0            5  \n",
       "Census Tract 31, Richland County, South Carolin...           90          495  \n",
       "Census Tract 22, Richland County, South Carolin...           39          913  \n",
       "Census Tract 103.05, Richland County, South Car...          856         5961  \n",
       "Census Tract 119.02, Richland County, South Car...          648         4035  \n",
       "Census Tract 111.02, Richland County, South Car...          181         3597  \n",
       "Census Tract 113.05, Richland County, South Car...         1023         3369  \n",
       "Census Tract 24, Richland County, South Carolin...          199         3168  \n",
       "Census Tract 28, Richland County, South Carolin...          340         1110  \n",
       "Census Tract 117.02, Richland County, South Car...          367         1702  \n",
       "Census Tract 2, Richland County, South Carolina...          422          755  \n",
       "Census Tract 23, Richland County, South Carolin...           30         2035  \n",
       "Census Tract 101.02, Richland County, South Car...          334         7666  \n",
       "Census Tract 103.04, Richland County, South Car...         1082         4904  \n",
       "Census Tract 110, Richland County, South Caroli...          167         1285  \n",
       "Census Tract 105.01, Richland County, South Car...          213         1158  \n",
       "Census Tract 111.01, Richland County, South Car...          253         2420  \n",
       "Census Tract 103.07, Richland County, South Car...          154        11244  \n",
       "Census Tract 107.01, Richland County, South Car...          827         1461  \n",
       "Census Tract 108.04, Richland County, South Car...          308         1311  \n",
       "Census Tract 119.01, Richland County, South Car...          997         6713  \n",
       "Census Tract 109, Richland County, South Caroli...          566          804  \n",
       "Census Tract 113.03, Richland County, South Car...          481         3964  \n",
       "Census Tract 114.07, Richland County, South Car...          577         3471  \n",
       "Census Tract 116.06, Richland County, South Car...          644         3910  \n",
       "Census Tract 117.01, Richland County, South Car...          789         1078  \n",
       "Census Tract 1, Richland County, South Carolina...          351         1023  \n",
       "Census Tract 5, Richland County, South Carolina...          417          786  \n",
       "Census Tract 6, Richland County, South Carolina...          276         1523  \n",
       "Census Tract 10, Richland County, South Carolin...          297          560  \n",
       "Census Tract 21, Richland County, South Carolin...          130         1930  \n",
       "Census Tract 209.04, Lexington County, South Ca...          127         2281  \n",
       "Census Tract 209.05, Lexington County, South Ca...          332         2204  \n",
       "Census Tract 209.07, Lexington County, South Ca...          497         6052  \n",
       "Census Tract 209.08, Lexington County, South Ca...          262         3042  \n",
       "Census Tract 210.19, Lexington County, South Ca...           78         1705  \n",
       "Census Tract 210.20, Lexington County, South Ca...          333         3645  \n",
       "Census Tract 210.21, Lexington County, South Ca...          131         1653  \n",
       "Census Tract 209.06, Lexington County, South Ca...          272         2411  \n",
       "Census Tract 210.22, Lexington County, South Ca...          551         5184  \n",
       "Census Tract 210.23, Lexington County, South Ca...          210         2463  \n",
       "Census Tract 210.24, Lexington County, South Ca...          106         6055  \n",
       "Census Tract 210.25, Lexington County, South Ca...           88         3534  \n",
       "Census Tract 210.26, Lexington County, South Ca...          274         4569  \n",
       "Census Tract 210.27, Lexington County, South Ca...           46         3770  \n",
       "Census Tract 210.28, Lexington County, South Ca...           97         2761  \n",
       "Census Tract 210.29, Lexington County, South Ca...          330         1938  \n",
       "Census Tract 210.30, Lexington County, South Ca...          211         4193  \n",
       "Census Tract 210.31, Lexington County, South Ca...          148         3301  \n",
       "Census Tract 210.32, Lexington County, South Ca...          132         3765  \n",
       "Census Tract 210.33, Lexington County, South Ca...          521         4285  \n",
       "Census Tract 210.34, Lexington County, South Ca...          350         3843  \n",
       "Census Tract 7, Richland County, South Carolina...          235         1142  \n",
       "Census Tract 211.09, Lexington County, South Ca...          364         2814  \n",
       "Census Tract 211.10, Lexington County, South Ca...           95         2777  \n",
       "Census Tract 211.11, Lexington County, South Ca...          201         2182  \n",
       "Census Tract 211.12, Lexington County, South Ca...          331         2491  \n",
       "Census Tract 211.13, Lexington County, South Ca...          191         2713  \n",
       "Census Tract 211.14, Lexington County, South Ca...          103         3160  \n",
       "Census Tract 211.15, Lexington County, South Ca...           20         2181  \n",
       "Census Tract 211.16, Lexington County, South Ca...          100         2870  \n",
       "Census Tract 212.03, Lexington County, South Ca...           83         6065  \n",
       "Census Tract 212.04, Lexington County, South Ca...          283         3713  \n",
       "Census Tract 212.05, Lexington County, South Ca...          135         2934  \n",
       "Census Tract 212.06, Lexington County, South Ca...          142         3069  \n",
       "Census Tract 213.03, Lexington County, South Ca...          115         3734  \n",
       "Census Tract 213.04, Lexington County, South Ca...          402         2987  \n",
       "Census Tract 27, Richland County, South Carolin...          330         1765  \n",
       "Census Tract 104.07, Richland County, South Car...          460         2442  \n",
       "Census Tract 104.09, Richland County, South Car...          330         1140  \n",
       "Census Tract 108.03, Richland County, South Car...          228         1141  \n",
       "Census Tract 113.01, Richland County, South Car...          100         5138  \n",
       "Census Tract 113.04, Richland County, South Car...          495         3265  \n",
       "Census Tract 116.03, Richland County, South Car...          357         5120  \n",
       "Census Tract 118, Richland County, South Caroli...         1058         3989  \n",
       "Census Tract 4, Richland County, South Carolina...          232         1227  \n",
       "Census Tract 202.02, Lexington County, South Ca...          227         1497  \n",
       "Census Tract 210.18, Lexington County, South Ca...          284         3493  \n",
       "Census Tract 214.02, Lexington County, South Ca...          445         2521  \n",
       "Census Tract 206.04, Lexington County, South Ca...          190         2950  \n",
       "Census Tract 205.06, Lexington County, South Ca...          539         4076  \n",
       "Census Tract 205.09, Lexington County, South Ca...          583         2105  \n",
       "Census Tract 205.10, Lexington County, South Ca...          520         3636  \n",
       "Census Tract 206.02, Lexington County, South Ca...          373         3350  \n",
       "Census Tract 201, Lexington County, South Carol...          237         2212  \n",
       "Census Tract 205.05, Lexington County, South Ca...          420         2624  \n",
       "Census Tract 205.07, Lexington County, South Ca...          559         4702  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "poverty_table"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6b81ca8c",
   "metadata": {},
   "source": [
    "### (12) Vehicle Ownership Data\n",
    "\n",
    "A crucial factor of the USDA's Low-Income, Low-Access designation (modern, more descriptive version of the colloquial food desert) is vehicle ownership. This looks at the Census data for vehicle ownership by ZCTA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "f061bb62",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/1m/gs67qnm13_zdcfgmdqmjy_sh0000gp/T/ipykernel_54145/2848875190.py:29: RuntimeWarning: invalid value encountered in long_scalars\n",
      "  \"No Vehicle %\": vehicle_table.B08201_002E.iloc[i] / vehicle_table.B08201_001E.iloc[i] * 100\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Finished processing acs5 2016\n",
      "Finished processing acs5 2017\n",
      "Finished processing acs5 2018\n",
      "Finished processing acs5 2019\n",
      "Finished processing acs5 2020\n"
     ]
    }
   ],
   "source": [
    "# https://api.census.gov/data/2010/acs/acs5/variables.html\n",
    "# B01003_001E - Estimate!!Total - TOTAL POPULATION\n",
    "# API - https://api.census.gov/data/2016/acs/acs5?get=NAME,ZCTA,B01003_001E&for=zip+code+tabulation+area:*&in=state:12\n",
    "years = [2016, 2017, 2018, 2019, 2020]\n",
    "census_product = 'acs5'\n",
    "fips_string = ','.join(state_fips_codes)\n",
    "code_string = 'B08201_002E'\n",
    "year_zcta_vehicle_dict = {}\n",
    "\n",
    "for year in years:\n",
    "    # API didn't seem to support the \"in\" query for specifying states\n",
    "    if year == 2020:\n",
    "        vehicle_table = censusdata.download(census_product, year,\n",
    "           censusdata.censusgeo([\n",
    "               ('zip%20code%20tabulation%20area', '*')\n",
    "           ]),['ZCTA','B08201_001E','B08201_002E'])\n",
    "    else:\n",
    "        vehicle_table = censusdata.download(census_product, year,\n",
    "           censusdata.censusgeo([\n",
    "               ('state', fips_string),\n",
    "               ('zip%20code%20tabulation%20area', '*')\n",
    "           ]),['ZCTA','B08201_001E','B08201_002E'])\n",
    "        \n",
    "    zcta_vehicle_dict = {}\n",
    "    for i, zcta in enumerate(list(vehicle_table.ZCTA)):\n",
    "        zcta_vehicle_dict[zcta] = {\n",
    "            \"Total Households\": vehicle_table.B08201_001E.iloc[i],\n",
    "            \"No Vehicle\": vehicle_table.B08201_002E.iloc[i],\n",
    "            \"No Vehicle %\": vehicle_table.B08201_002E.iloc[i] / vehicle_table.B08201_001E.iloc[i] * 100\n",
    "        }\n",
    "    year_zcta_vehicle_dict[year] = zcta_vehicle_dict\n",
    "    print(\"Finished processing {0} {1}\".format(census_product, year))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "2d84ffd4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Total Households': 14767, 'No Vehicle': 1912, 'No Vehicle %': 12.947788988961875}\n",
      "{'Total Households': 14934, 'No Vehicle': 2164, 'No Vehicle %': 14.49042453461899}\n",
      "{'Total Households': 15033, 'No Vehicle': 2242, 'No Vehicle %': 14.913856183063926}\n",
      "{'Total Households': 15348, 'No Vehicle': 2365, 'No Vehicle %': 15.409173833724262}\n",
      "{'Total Households': 15589, 'No Vehicle': 2265, 'No Vehicle %': 14.529475912502404}\n"
     ]
    }
   ],
   "source": [
    "for year in years: print(year_zcta_vehicle_dict[year][29203])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}