teen birth rates.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Teen birth rates\n",
    "\n",
    "TL;DR, they continued to go down.\n",
    "\n",
    "* Previous story: http://trendct.org/2015/08/11/teenage-pregnancy-rates-are-plummeting-in-connecticut/\n",
    "* Previous story: http://trendct.org/2015/08/12/hispanic-teen-birthrate-is-7-times-larger-than-that-of-white-teens/\n",
    "\n",
    "\n",
    "National data:\n",
    "* http://www.cdc.gov/nchs/data/databriefs/db264_table.pdf#3\n",
    "* http://www.cdc.gov/nchs/data/databriefs/db264.pdf\n",
    "* http://www.healthindicators.gov/Indicators/Births-females-15-19-years-per-1000_22/Profile/Download\n",
    "\n",
    "Goals\n",
    "\n",
    "1. Replicate previous article's figures and extend them to 2014 data\n",
    "2. Determine 2014 birth rate by urban/rural and race/ethnicity\n",
    "3. Put CT in national context"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "0\n",
      "Indicator Description ID\n",
      "22\n",
      "Data Source\n",
      "Bridged-Race Population Estimates for Census 2000 and 2010; National Vital Statistics System-Natality\n",
      "Topics\n",
      "Demographics - Age Group - Adolescents; Maternal and Infant Health - Births - Natality; Maternal and Infant Health - Pregnancy - Teen Birth Rates\n",
      "Initiatives\n",
      "County Health Rankings; Community Health Status Indicators\n",
      "Data Type\n",
      "FLOAT\n",
      "Numerator Description\n",
      "<p>Number of births to females age 15-19</p>\n",
      "Denominator Description\n",
      "<p>Females age 15-19 years</p>\n",
      "Short Description\n",
      "Births: females 15-19 years\n",
      "Full Description\n",
      "Births to females 15-19 years of age per 1,000\n",
      "Caveats and Limitations\n",
      "<p>The primary limitation of this measure is that it does not capture births among teens younger than 15. Though the incidence of teen births in this cohort is particularly low, births at such a young age are more likely to result in adverse health and socioeconomic outcomes.</p><p>Gestational age changed beginning&nbsp;in 2014, OE was used in place LMP. {link:60806}</p>\n",
      "Trend Issues\n",
      "\n",
      "Value Label\n",
      "per 1,000\n",
      "Methodology Notes\n",
      "\"Rates based on fewer than 20 births are considered unreliable and are not shown.\r\n",
      "\r\n",
      "FOR SINGLE DATA YEARS: Birth rates are calculated based on the resident population of the data year involved.  For census years, April 1 census counts are used (e.g. 2010).  For postcensal years, July 1 estimates from the postcensal Vintage that matches the data year are used (e.g. July 1, 2011 resident population estimates from Vintage 2011 are used as the denominator for  2011rates).  For intercensal years, intercensal population estimates are used in rate calculations (e.g. 1991-1999, 2001-2009).  Race-specific population estimates for 1991 and later use bridged-race categories.\r\n",
      "\t \r\n",
      "\tFOR MULTIPLE DATA YEARS: Birth rates are calculated based on the sum of the resident populations for each of the data years involved (e.g. the denominator of a rate for 2008-2010 combined is the sum of the population estimates for 2008, 2009, and 2010).  For census years, April 1 census counts are used (e.g. 2010).  For postcensal years, July 1 estimates from the postcensal Vintage that matches the data year are used (e.g. July 1, 2011 resident population estimates from Vintage 2011).  For intercensal years, intercensal population estimates are used in rate calculations (e.g. 1991-1999, 2000-2009).  Race-specific population estimates for 1991 and later use bridged-race categories.\"\n",
      "Initiative-Specific Topic Area\n",
      "\n",
      "More Information\n",
      "\"|\r\n",
      "http://www.cdc.gov/TeenPregnancy/AboutTeenPreg.htm\"\n",
      "References\n",
      "\n",
      "Interventions\n",
      "\"|\r\n",
      "Prevention of HIV/AIDS, other STIs and Pregnancy: Group-based Comprehensive Risk Reduction Interventions for Adolescents (http://www.thecommunityguide.org/hiv/riskreduction.html) - Comprehensive risk reduction (CRR) promotes behaviors that prevent or reduce the risk of pregnancy, HIV, and other sexually transmitted infections (STIs).\r\n",
      "|\r\n",
      "Youth Development Behavioral Interventions Coordinated with Community Service to Reduce Sexual Risk Behaviors in Adolescents (http://www.thecommunityguide.org/hiv/youthdev-community.html) - Youth development behavioral interventions employ a holistic approach to adolescent health and wellness, and may or may not include components that are focused directly on pregnancy and STI prevention.\"\n",
      "Footnotes\n",
      "\n",
      "HP2020 ID\n",
      "\n",
      "HP2020 Target\n",
      "\n",
      "HP2020 Target-setting Method\n",
      "\n",
      "HP2020 Baseline\n",
      "\n",
      "HP2020 Baseline Year\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "inventory_meta = pd.read_csv(\"data/22 - Births  females 15-19 years (per 1,000) - Connecticut - Metadata.CSV\").transpose()\n",
    "print inventory_meta.to_csv(sep=\"\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Indicator ID</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Missing Value Flag</th>\n",
       "      <th>Confidence Interval Low</th>\n",
       "      <th>Confidence Interval High</th>\n",
       "      <th>Standard Error</th>\n",
       "      <th>LocaleID</th>\n",
       "      <th>Locale</th>\n",
       "      <th>...</th>\n",
       "      <th>Characteristic Of School Or Student</th>\n",
       "      <th>Other</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Modifier1</th>\n",
       "      <th>Modifier2</th>\n",
       "      <th>Modifier3</th>\n",
       "      <th>Modifier4</th>\n",
       "      <th>Modifier5</th>\n",
       "      <th>Numerator</th>\n",
       "      <th>Denominator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>416484936</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>11.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1420.0</td>\n",
       "      <td>123357.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>416484937</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>5.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>391.0</td>\n",
       "      <td>71118.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>416484938</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>19.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.5</td>\n",
       "      <td>20.9</td>\n",
       "      <td>0.6</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1029.0</td>\n",
       "      <td>52239.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>416484945</td>\n",
       "      <td>Aged 15-17 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>17.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.9</td>\n",
       "      <td>19.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>234.0</td>\n",
       "      <td>13659.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>416484939</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>52.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.9</td>\n",
       "      <td>57.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>487.0</td>\n",
       "      <td>9273.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>416484947</td>\n",
       "      <td>Aged 15-17 years; Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45238.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>416484944</td>\n",
       "      <td>Aged 18-19 years; Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34169.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>416484943</td>\n",
       "      <td>Aged 15-17 years; Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8702.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>416484946</td>\n",
       "      <td>Aged 18-19 years; Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6212.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>416484940</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>31.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.1</td>\n",
       "      <td>33.7</td>\n",
       "      <td>1.2</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>721.0</td>\n",
       "      <td>22932.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>416484941</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79407.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>416484942</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14914.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>416487306</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>9.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>10.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>307.0</td>\n",
       "      <td>32927.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>416487307</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.0</td>\n",
       "      <td>19961.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>416487308</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.7</td>\n",
       "      <td>19.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>220.0</td>\n",
       "      <td>12966.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>416487309</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>27.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.7</td>\n",
       "      <td>31.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186.0</td>\n",
       "      <td>6725.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>416487310</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20589.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>416487311</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4098.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>416487312</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>14.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.4</td>\n",
       "      <td>16.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>435.0</td>\n",
       "      <td>29413.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>416487313</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>6.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120.0</td>\n",
       "      <td>17741.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>416487314</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>27.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>315.0</td>\n",
       "      <td>11672.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>416487315</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>38.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.8</td>\n",
       "      <td>43.3</td>\n",
       "      <td>2.4</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>253.0</td>\n",
       "      <td>6560.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>416487316</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16767.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>416487317</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4557.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>416487318</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>7.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.7</td>\n",
       "      <td>10.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>5563.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>416487319</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>416487320</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>18.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.9</td>\n",
       "      <td>25.5</td>\n",
       "      <td>3.1</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1955.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>416487321</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>461.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>416487322</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4817.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>416487323</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>123.0</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",
       "      <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>1650</th>\n",
       "      <td>159068357</td>\n",
       "      <td>Total</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>11.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.7</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>414.0</td>\n",
       "      <td>35037.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651</th>\n",
       "      <td>159068358</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>5.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.2</td>\n",
       "      <td>6.1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112.0</td>\n",
       "      <td>21843.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652</th>\n",
       "      <td>159068359</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>22.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.3</td>\n",
       "      <td>25.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>302.0</td>\n",
       "      <td>13194.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1653</th>\n",
       "      <td>159068360</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>29.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.2</td>\n",
       "      <td>37.4</td>\n",
       "      <td>3.8</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2063.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>159068361</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>9.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>10.5</td>\n",
       "      <td>0.6</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>275.0</td>\n",
       "      <td>29236.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1655</th>\n",
       "      <td>159068362</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>28.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.7</td>\n",
       "      <td>36.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74.0</td>\n",
       "      <td>2557.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656</th>\n",
       "      <td>159068363</td>\n",
       "      <td>Total</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>27.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.2</td>\n",
       "      <td>28.6</td>\n",
       "      <td>0.4</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5839.0</td>\n",
       "      <td>209189.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>159068364</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>15.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.2</td>\n",
       "      <td>16.5</td>\n",
       "      <td>0.4</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1976.0</td>\n",
       "      <td>124673.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>159068365</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>45.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.3</td>\n",
       "      <td>47.1</td>\n",
       "      <td>0.7</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3863.0</td>\n",
       "      <td>84516.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>159068366</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>75.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.1</td>\n",
       "      <td>77.9</td>\n",
       "      <td>1.5</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2580.0</td>\n",
       "      <td>34397.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>159068367</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>11.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.1</td>\n",
       "      <td>12.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1577.0</td>\n",
       "      <td>134869.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>159068368</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>49.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.5</td>\n",
       "      <td>52.3</td>\n",
       "      <td>1.2</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1634.0</td>\n",
       "      <td>32747.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1662</th>\n",
       "      <td>159068369</td>\n",
       "      <td>Total</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>25.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.6</td>\n",
       "      <td>27.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1602.0</td>\n",
       "      <td>62026.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>159068370</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>10.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.5</td>\n",
       "      <td>11.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>406.0</td>\n",
       "      <td>38572.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1664</th>\n",
       "      <td>159068371</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>51.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.1</td>\n",
       "      <td>53.9</td>\n",
       "      <td>1.5</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1196.0</td>\n",
       "      <td>23454.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1665</th>\n",
       "      <td>159068372</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>56.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.5</td>\n",
       "      <td>62.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>333.0</td>\n",
       "      <td>5882.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1666</th>\n",
       "      <td>159068373</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>20.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.1</td>\n",
       "      <td>21.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>49085.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1667</th>\n",
       "      <td>159068374</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>51.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.6</td>\n",
       "      <td>58.1</td>\n",
       "      <td>3.4</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223.0</td>\n",
       "      <td>4342.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1668</th>\n",
       "      <td>159068375</td>\n",
       "      <td>Total</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>7.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.6</td>\n",
       "      <td>8.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>359.0</td>\n",
       "      <td>48672.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1669</th>\n",
       "      <td>159068376</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.0</td>\n",
       "      <td>20067.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1670</th>\n",
       "      <td>159068377</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>9.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>10.6</td>\n",
       "      <td>0.6</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>271.0</td>\n",
       "      <td>28605.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1671</th>\n",
       "      <td>159068378</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>17.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.7</td>\n",
       "      <td>24.2</td>\n",
       "      <td>2.8</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2255.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1672</th>\n",
       "      <td>159068379</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>6.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.9</td>\n",
       "      <td>7.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>283.0</td>\n",
       "      <td>42557.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>159068380</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>14.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.7</td>\n",
       "      <td>21.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1757.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1674</th>\n",
       "      <td>159068381</td>\n",
       "      <td>Total</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>27.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.8</td>\n",
       "      <td>29.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>849.0</td>\n",
       "      <td>30652.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1675</th>\n",
       "      <td>159068382</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>14.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.8</td>\n",
       "      <td>16.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>251.0</td>\n",
       "      <td>17198.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1676</th>\n",
       "      <td>159068383</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>44.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.9</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>598.0</td>\n",
       "      <td>13454.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1677</th>\n",
       "      <td>159068384</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>82.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>5.1</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>259.0</td>\n",
       "      <td>3158.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678</th>\n",
       "      <td>159068385</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>21.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>563.0</td>\n",
       "      <td>26056.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>159068386</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>2002-2008</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>899.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1680 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Indicator ID                                     Dimension List  \\\n",
       "0        416484936                                              Total   \n",
       "1        416484937                       Aged 15-17 years (Of mother)   \n",
       "2        416484938                       Aged 18-19 years (Of mother)   \n",
       "3        416484945   Aged 15-17 years; Hispanic or Latino (Of mother)   \n",
       "4        416484939   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "5        416484947   Aged 15-17 years; Non-Hispanic White (Of mother)   \n",
       "6        416484944   Aged 18-19 years; Non-Hispanic White (Of mother)   \n",
       "7        416484943   Aged 15-17 years; Non-Hispanic Black (Of mother)   \n",
       "8        416484946   Aged 18-19 years; Non-Hispanic Black (Of mother)   \n",
       "9        416484940                     Hispanic or Latino (Of mother)   \n",
       "10       416484941                     Non-Hispanic White (Of mother)   \n",
       "11       416484942                     Non-Hispanic Black (Of mother)   \n",
       "12       416487306                                              Total   \n",
       "13       416487307                       Aged 15-17 years (Of mother)   \n",
       "14       416487308                       Aged 18-19 years (Of mother)   \n",
       "15       416487309                     Hispanic or Latino (Of mother)   \n",
       "16       416487310                     Non-Hispanic White (Of mother)   \n",
       "17       416487311                     Non-Hispanic Black (Of mother)   \n",
       "18       416487312                                              Total   \n",
       "19       416487313                       Aged 15-17 years (Of mother)   \n",
       "20       416487314                       Aged 18-19 years (Of mother)   \n",
       "21       416487315                     Hispanic or Latino (Of mother)   \n",
       "22       416487316                     Non-Hispanic White (Of mother)   \n",
       "23       416487317                     Non-Hispanic Black (Of mother)   \n",
       "24       416487318                                              Total   \n",
       "25       416487319                       Aged 15-17 years (Of mother)   \n",
       "26       416487320                       Aged 18-19 years (Of mother)   \n",
       "27       416487321                     Hispanic or Latino (Of mother)   \n",
       "28       416487322                     Non-Hispanic White (Of mother)   \n",
       "29       416487323                     Non-Hispanic Black (Of mother)   \n",
       "...            ...                                                ...   \n",
       "1650     159068357                                              Total   \n",
       "1651     159068358                       Aged 15-17 years (Of mother)   \n",
       "1652     159068359                       Aged 18-19 years (Of mother)   \n",
       "1653     159068360                     Hispanic or Latino (Of mother)   \n",
       "1654     159068361                    White, non-Hispanic (Of mother)   \n",
       "1655     159068362  Black or African American, non-Hispanic (Of mo...   \n",
       "1656     159068363                                              Total   \n",
       "1657     159068364                       Aged 15-17 years (Of mother)   \n",
       "1658     159068365                       Aged 18-19 years (Of mother)   \n",
       "1659     159068366                     Hispanic or Latino (Of mother)   \n",
       "1660     159068367                    White, non-Hispanic (Of mother)   \n",
       "1661     159068368  Black or African American, non-Hispanic (Of mo...   \n",
       "1662     159068369                                              Total   \n",
       "1663     159068370                       Aged 15-17 years (Of mother)   \n",
       "1664     159068371                       Aged 18-19 years (Of mother)   \n",
       "1665     159068372                     Hispanic or Latino (Of mother)   \n",
       "1666     159068373                    White, non-Hispanic (Of mother)   \n",
       "1667     159068374  Black or African American, non-Hispanic (Of mo...   \n",
       "1668     159068375                                              Total   \n",
       "1669     159068376                       Aged 15-17 years (Of mother)   \n",
       "1670     159068377                       Aged 18-19 years (Of mother)   \n",
       "1671     159068378                     Hispanic or Latino (Of mother)   \n",
       "1672     159068379                    White, non-Hispanic (Of mother)   \n",
       "1673     159068380  Black or African American, non-Hispanic (Of mo...   \n",
       "1674     159068381                                              Total   \n",
       "1675     159068382                       Aged 15-17 years (Of mother)   \n",
       "1676     159068383                       Aged 18-19 years (Of mother)   \n",
       "1677     159068384                     Hispanic or Latino (Of mother)   \n",
       "1678     159068385                    White, non-Hispanic (Of mother)   \n",
       "1679     159068386  Black or African American, non-Hispanic (Of mo...   \n",
       "\n",
       "      Timeframe Numeric Value Missing Value Flag  Confidence Interval Low  \\\n",
       "0          2014          11.5                NaN                     10.9   \n",
       "1          2014           5.5                NaN                      5.0   \n",
       "2          2014          19.7                NaN                     18.5   \n",
       "3          2014          17.1                NaN                     14.9   \n",
       "4          2014          52.5                NaN                     47.9   \n",
       "5          2014           DSU                DSU                      NaN   \n",
       "6          2014           DSU                DSU                      NaN   \n",
       "7          2014           DSU                DSU                      NaN   \n",
       "8          2014           DSU                DSU                      NaN   \n",
       "9          2014          31.4                NaN                     29.1   \n",
       "10         2014           DSU                DSU                      NaN   \n",
       "11         2014           DSU                DSU                      NaN   \n",
       "12         2014           9.3                NaN                      8.3   \n",
       "13         2014           4.4                NaN                      3.5   \n",
       "14         2014          17.0                NaN                     14.7   \n",
       "15         2014          27.7                NaN                     23.7   \n",
       "16         2014           DSU                DSU                      NaN   \n",
       "17         2014           DSU                DSU                      NaN   \n",
       "18         2014          14.8                NaN                     13.4   \n",
       "19         2014           6.8                NaN                      5.6   \n",
       "20         2014          27.0                NaN                     24.0   \n",
       "21         2014          38.6                NaN                     33.8   \n",
       "22         2014           DSU                DSU                      NaN   \n",
       "23         2014           DSU                DSU                      NaN   \n",
       "24         2014           7.9                NaN                      5.7   \n",
       "25         2014           DSU                DSU                      NaN   \n",
       "26         2014          18.4                NaN                     12.9   \n",
       "27         2014           DSU                DSU                      NaN   \n",
       "28         2014           DSU                DSU                      NaN   \n",
       "29         2014           DSU                DSU                      NaN   \n",
       "...         ...           ...                ...                      ...   \n",
       "1650  2002-2008          11.8                NaN                     10.7   \n",
       "1651  2002-2008           5.1                NaN                      4.2   \n",
       "1652  2002-2008          22.9                NaN                     20.3   \n",
       "1653  2002-2008          29.1                NaN                     22.2   \n",
       "1654  2002-2008           9.4                NaN                      8.3   \n",
       "1655  2002-2008          28.9                NaN                     22.7   \n",
       "1656  2002-2008          27.9                NaN                     27.2   \n",
       "1657  2002-2008          15.8                NaN                     15.2   \n",
       "1658  2002-2008          45.7                NaN                     44.3   \n",
       "1659  2002-2008          75.0                NaN                     72.1   \n",
       "1660  2002-2008          11.7                NaN                     11.1   \n",
       "1661  2002-2008          49.9                NaN                     47.5   \n",
       "1662  2002-2008          25.8                NaN                     24.6   \n",
       "1663  2002-2008          10.5                NaN                      9.5   \n",
       "1664  2002-2008          51.0                NaN                     48.1   \n",
       "1665  2002-2008          56.6                NaN                     50.5   \n",
       "1666  2002-2008          20.4                NaN                     19.1   \n",
       "1667  2002-2008          51.4                NaN                     44.6   \n",
       "1668  2002-2008           7.4                NaN                      6.6   \n",
       "1669  2002-2008           4.4                NaN                      3.5   \n",
       "1670  2002-2008           9.5                NaN                      8.3   \n",
       "1671  2002-2008          17.7                NaN                     12.7   \n",
       "1672  2002-2008           6.6                NaN                      5.9   \n",
       "1673  2002-2008          14.8                NaN                      9.7   \n",
       "1674  2002-2008          27.7                NaN                     25.8   \n",
       "1675  2002-2008          14.6                NaN                     12.8   \n",
       "1676  2002-2008          44.4                NaN                     40.9   \n",
       "1677  2002-2008          82.0                NaN                     72.0   \n",
       "1678  2002-2008          21.6                NaN                     19.8   \n",
       "1679  2002-2008           DSU                DSU                      NaN   \n",
       "\n",
       "      Confidence Interval High  Standard Error  LocaleID  \\\n",
       "0                         12.1             0.3         9   \n",
       "1                          6.0             0.3         9   \n",
       "2                         20.9             0.6         9   \n",
       "3                         19.3             1.1         9   \n",
       "4                         57.2             2.4         9   \n",
       "5                          NaN             NaN         9   \n",
       "6                          NaN             NaN         9   \n",
       "7                          NaN             NaN         9   \n",
       "8                          NaN             NaN         9   \n",
       "9                         33.7             1.2         9   \n",
       "10                         NaN             NaN         9   \n",
       "11                         NaN             NaN         9   \n",
       "12                        10.4             0.5       409   \n",
       "13                         5.4             0.5       409   \n",
       "14                        19.2             1.1       409   \n",
       "15                        31.6             2.0       409   \n",
       "16                         NaN             NaN       409   \n",
       "17                         NaN             NaN       409   \n",
       "18                        16.2             0.7       410   \n",
       "19                         8.0             0.6       410   \n",
       "20                        30.0             1.5       410   \n",
       "21                        43.3             2.4       410   \n",
       "22                         NaN             NaN       410   \n",
       "23                         NaN             NaN       410   \n",
       "24                        10.6             1.2       411   \n",
       "25                         NaN             NaN       411   \n",
       "26                        25.5             3.1       411   \n",
       "27                         NaN             NaN       411   \n",
       "28                         NaN             NaN       411   \n",
       "29                         NaN             NaN       411   \n",
       "...                        ...             ...       ...   \n",
       "1650                      13.0             0.6       412   \n",
       "1651                       6.1             0.5       412   \n",
       "1652                      25.5             1.3       412   \n",
       "1653                      37.4             3.8       412   \n",
       "1654                      10.5             0.6       412   \n",
       "1655                      36.3             3.4       412   \n",
       "1656                      28.6             0.4       413   \n",
       "1657                      16.5             0.4       413   \n",
       "1658                      47.1             0.7       413   \n",
       "1659                      77.9             1.5       413   \n",
       "1660                      12.3             0.3       413   \n",
       "1661                      52.3             1.2       413   \n",
       "1662                      27.1             0.6       414   \n",
       "1663                      11.5             0.5       414   \n",
       "1664                      53.9             1.5       414   \n",
       "1665                      62.7             3.1       414   \n",
       "1666                      21.6             0.6       414   \n",
       "1667                      58.1             3.4       414   \n",
       "1668                       8.1             0.4       415   \n",
       "1669                       5.4             0.5       415   \n",
       "1670                      10.6             0.6       415   \n",
       "1671                      24.2             2.8       415   \n",
       "1672                       7.4             0.4       415   \n",
       "1673                      21.7             2.9       415   \n",
       "1674                      29.6             1.0       416   \n",
       "1675                      16.4             0.9       416   \n",
       "1676                      48.0             1.8       416   \n",
       "1677                      92.0             5.1       416   \n",
       "1678                      23.4             0.9       416   \n",
       "1679                       NaN             NaN       416   \n",
       "\n",
       "                        Locale     ...       \\\n",
       "0                  Connecticut     ...        \n",
       "1                  Connecticut     ...        \n",
       "2                  Connecticut     ...        \n",
       "3                  Connecticut     ...        \n",
       "4                  Connecticut     ...        \n",
       "5                  Connecticut     ...        \n",
       "6                  Connecticut     ...        \n",
       "7                  Connecticut     ...        \n",
       "8                  Connecticut     ...        \n",
       "9                  Connecticut     ...        \n",
       "10                 Connecticut     ...        \n",
       "11                 Connecticut     ...        \n",
       "12     Connecticut - Fairfield     ...        \n",
       "13     Connecticut - Fairfield     ...        \n",
       "14     Connecticut - Fairfield     ...        \n",
       "15     Connecticut - Fairfield     ...        \n",
       "16     Connecticut - Fairfield     ...        \n",
       "17     Connecticut - Fairfield     ...        \n",
       "18      Connecticut - Hartford     ...        \n",
       "19      Connecticut - Hartford     ...        \n",
       "20      Connecticut - Hartford     ...        \n",
       "21      Connecticut - Hartford     ...        \n",
       "22      Connecticut - Hartford     ...        \n",
       "23      Connecticut - Hartford     ...        \n",
       "24    Connecticut - Litchfield     ...        \n",
       "25    Connecticut - Litchfield     ...        \n",
       "26    Connecticut - Litchfield     ...        \n",
       "27    Connecticut - Litchfield     ...        \n",
       "28    Connecticut - Litchfield     ...        \n",
       "29    Connecticut - Litchfield     ...        \n",
       "...                        ...     ...        \n",
       "1650   Connecticut - Middlesex     ...        \n",
       "1651   Connecticut - Middlesex     ...        \n",
       "1652   Connecticut - Middlesex     ...        \n",
       "1653   Connecticut - Middlesex     ...        \n",
       "1654   Connecticut - Middlesex     ...        \n",
       "1655   Connecticut - Middlesex     ...        \n",
       "1656   Connecticut - New Haven     ...        \n",
       "1657   Connecticut - New Haven     ...        \n",
       "1658   Connecticut - New Haven     ...        \n",
       "1659   Connecticut - New Haven     ...        \n",
       "1660   Connecticut - New Haven     ...        \n",
       "1661   Connecticut - New Haven     ...        \n",
       "1662  Connecticut - New London     ...        \n",
       "1663  Connecticut - New London     ...        \n",
       "1664  Connecticut - New London     ...        \n",
       "1665  Connecticut - New London     ...        \n",
       "1666  Connecticut - New London     ...        \n",
       "1667  Connecticut - New London     ...        \n",
       "1668     Connecticut - Tolland     ...        \n",
       "1669     Connecticut - Tolland     ...        \n",
       "1670     Connecticut - Tolland     ...        \n",
       "1671     Connecticut - Tolland     ...        \n",
       "1672     Connecticut - Tolland     ...        \n",
       "1673     Connecticut - Tolland     ...        \n",
       "1674     Connecticut - Windham     ...        \n",
       "1675     Connecticut - Windham     ...        \n",
       "1676     Connecticut - Windham     ...        \n",
       "1677     Connecticut - Windham     ...        \n",
       "1678     Connecticut - Windham     ...        \n",
       "1679     Connecticut - Windham     ...        \n",
       "\n",
       "     Characteristic Of School Or Student  Other  Geography    Modifier1  \\\n",
       "0                                    NaN    NaN        NaN          NaN   \n",
       "1                                    NaN    NaN        NaN  (Of mother)   \n",
       "2                                    NaN    NaN        NaN  (Of mother)   \n",
       "3                                    NaN    NaN        NaN  (Of mother)   \n",
       "4                                    NaN    NaN        NaN  (Of mother)   \n",
       "5                                    NaN    NaN        NaN  (Of mother)   \n",
       "6                                    NaN    NaN        NaN  (Of mother)   \n",
       "7                                    NaN    NaN        NaN  (Of mother)   \n",
       "8                                    NaN    NaN        NaN  (Of mother)   \n",
       "9                                    NaN    NaN        NaN  (Of mother)   \n",
       "10                                   NaN    NaN        NaN  (Of mother)   \n",
       "11                                   NaN    NaN        NaN  (Of mother)   \n",
       "12                                   NaN    NaN        NaN          NaN   \n",
       "13                                   NaN    NaN        NaN  (Of mother)   \n",
       "14                                   NaN    NaN        NaN  (Of mother)   \n",
       "15                                   NaN    NaN        NaN  (Of mother)   \n",
       "16                                   NaN    NaN        NaN  (Of mother)   \n",
       "17                                   NaN    NaN        NaN  (Of mother)   \n",
       "18                                   NaN    NaN        NaN          NaN   \n",
       "19                                   NaN    NaN        NaN  (Of mother)   \n",
       "20                                   NaN    NaN        NaN  (Of mother)   \n",
       "21                                   NaN    NaN        NaN  (Of mother)   \n",
       "22                                   NaN    NaN        NaN  (Of mother)   \n",
       "23                                   NaN    NaN        NaN  (Of mother)   \n",
       "24                                   NaN    NaN        NaN          NaN   \n",
       "25                                   NaN    NaN        NaN  (Of mother)   \n",
       "26                                   NaN    NaN        NaN  (Of mother)   \n",
       "27                                   NaN    NaN        NaN  (Of mother)   \n",
       "28                                   NaN    NaN        NaN  (Of mother)   \n",
       "29                                   NaN    NaN        NaN  (Of mother)   \n",
       "...                                  ...    ...        ...          ...   \n",
       "1650                                 NaN    NaN        NaN          NaN   \n",
       "1651                                 NaN    NaN        NaN  (Of mother)   \n",
       "1652                                 NaN    NaN        NaN  (Of mother)   \n",
       "1653                                 NaN    NaN        NaN  (Of mother)   \n",
       "1654                                 NaN    NaN        NaN  (Of mother)   \n",
       "1655                                 NaN    NaN        NaN  (Of mother)   \n",
       "1656                                 NaN    NaN        NaN          NaN   \n",
       "1657                                 NaN    NaN        NaN  (Of mother)   \n",
       "1658                                 NaN    NaN        NaN  (Of mother)   \n",
       "1659                                 NaN    NaN        NaN  (Of mother)   \n",
       "1660                                 NaN    NaN        NaN  (Of mother)   \n",
       "1661                                 NaN    NaN        NaN  (Of mother)   \n",
       "1662                                 NaN    NaN        NaN          NaN   \n",
       "1663                                 NaN    NaN        NaN  (Of mother)   \n",
       "1664                                 NaN    NaN        NaN  (Of mother)   \n",
       "1665                                 NaN    NaN        NaN  (Of mother)   \n",
       "1666                                 NaN    NaN        NaN  (Of mother)   \n",
       "1667                                 NaN    NaN        NaN  (Of mother)   \n",
       "1668                                 NaN    NaN        NaN          NaN   \n",
       "1669                                 NaN    NaN        NaN  (Of mother)   \n",
       "1670                                 NaN    NaN        NaN  (Of mother)   \n",
       "1671                                 NaN    NaN        NaN  (Of mother)   \n",
       "1672                                 NaN    NaN        NaN  (Of mother)   \n",
       "1673                                 NaN    NaN        NaN  (Of mother)   \n",
       "1674                                 NaN    NaN        NaN          NaN   \n",
       "1675                                 NaN    NaN        NaN  (Of mother)   \n",
       "1676                                 NaN    NaN        NaN  (Of mother)   \n",
       "1677                                 NaN    NaN        NaN  (Of mother)   \n",
       "1678                                 NaN    NaN        NaN  (Of mother)   \n",
       "1679                                 NaN    NaN        NaN  (Of mother)   \n",
       "\n",
       "      Modifier2 Modifier3 Modifier4  Modifier5 Numerator  Denominator  \n",
       "0           NaN       NaN       NaN        NaN    1420.0     123357.0  \n",
       "1           NaN       NaN       NaN        NaN     391.0      71118.0  \n",
       "2           NaN       NaN       NaN        NaN    1029.0      52239.0  \n",
       "3           NaN       NaN       NaN        NaN     234.0      13659.0  \n",
       "4           NaN       NaN       NaN        NaN     487.0       9273.0  \n",
       "5           NaN       NaN       NaN        NaN       NaN      45238.0  \n",
       "6           NaN       NaN       NaN        NaN       NaN      34169.0  \n",
       "7           NaN       NaN       NaN        NaN       NaN       8702.0  \n",
       "8           NaN       NaN       NaN        NaN       NaN       6212.0  \n",
       "9           NaN       NaN       NaN        NaN     721.0      22932.0  \n",
       "10          NaN       NaN       NaN        NaN       NaN      79407.0  \n",
       "11          NaN       NaN       NaN        NaN       NaN      14914.0  \n",
       "12          NaN       NaN       NaN        NaN     307.0      32927.0  \n",
       "13          NaN       NaN       NaN        NaN      87.0      19961.0  \n",
       "14          NaN       NaN       NaN        NaN     220.0      12966.0  \n",
       "15          NaN       NaN       NaN        NaN     186.0       6725.0  \n",
       "16          NaN       NaN       NaN        NaN       NaN      20589.0  \n",
       "17          NaN       NaN       NaN        NaN       NaN       4098.0  \n",
       "18          NaN       NaN       NaN        NaN     435.0      29413.0  \n",
       "19          NaN       NaN       NaN        NaN     120.0      17741.0  \n",
       "20          NaN       NaN       NaN        NaN     315.0      11672.0  \n",
       "21          NaN       NaN       NaN        NaN     253.0       6560.0  \n",
       "22          NaN       NaN       NaN        NaN       NaN      16767.0  \n",
       "23          NaN       NaN       NaN        NaN       NaN       4557.0  \n",
       "24          NaN       NaN       NaN        NaN      44.0       5563.0  \n",
       "25          NaN       NaN       NaN        NaN       NaN       3608.0  \n",
       "26          NaN       NaN       NaN        NaN      36.0       1955.0  \n",
       "27          NaN       NaN       NaN        NaN       NaN        461.0  \n",
       "28          NaN       NaN       NaN        NaN       NaN       4817.0  \n",
       "29          NaN       NaN       NaN        NaN       NaN        123.0  \n",
       "...         ...       ...       ...        ...       ...          ...  \n",
       "1650        NaN       NaN       NaN        NaN     414.0      35037.0  \n",
       "1651        NaN       NaN       NaN        NaN     112.0      21843.0  \n",
       "1652        NaN       NaN       NaN        NaN     302.0      13194.0  \n",
       "1653        NaN       NaN       NaN        NaN      60.0       2063.0  \n",
       "1654        NaN       NaN       NaN        NaN     275.0      29236.0  \n",
       "1655        NaN       NaN       NaN        NaN      74.0       2557.0  \n",
       "1656        NaN       NaN       NaN        NaN    5839.0     209189.0  \n",
       "1657        NaN       NaN       NaN        NaN    1976.0     124673.0  \n",
       "1658        NaN       NaN       NaN        NaN    3863.0      84516.0  \n",
       "1659        NaN       NaN       NaN        NaN    2580.0      34397.0  \n",
       "1660        NaN       NaN       NaN        NaN    1577.0     134869.0  \n",
       "1661        NaN       NaN       NaN        NaN    1634.0      32747.0  \n",
       "1662        NaN       NaN       NaN        NaN    1602.0      62026.0  \n",
       "1663        NaN       NaN       NaN        NaN     406.0      38572.0  \n",
       "1664        NaN       NaN       NaN        NaN    1196.0      23454.0  \n",
       "1665        NaN       NaN       NaN        NaN     333.0       5882.0  \n",
       "1666        NaN       NaN       NaN        NaN    1000.0      49085.0  \n",
       "1667        NaN       NaN       NaN        NaN     223.0       4342.0  \n",
       "1668        NaN       NaN       NaN        NaN     359.0      48672.0  \n",
       "1669        NaN       NaN       NaN        NaN      88.0      20067.0  \n",
       "1670        NaN       NaN       NaN        NaN     271.0      28605.0  \n",
       "1671        NaN       NaN       NaN        NaN      40.0       2255.0  \n",
       "1672        NaN       NaN       NaN        NaN     283.0      42557.0  \n",
       "1673        NaN       NaN       NaN        NaN      26.0       1757.0  \n",
       "1674        NaN       NaN       NaN        NaN     849.0      30652.0  \n",
       "1675        NaN       NaN       NaN        NaN     251.0      17198.0  \n",
       "1676        NaN       NaN       NaN        NaN     598.0      13454.0  \n",
       "1677        NaN       NaN       NaN        NaN     259.0       3158.0  \n",
       "1678        NaN       NaN       NaN        NaN     563.0      26056.0  \n",
       "1679        NaN       NaN       NaN        NaN      19.0        899.0  \n",
       "\n",
       "[1680 rows x 39 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory = pd.read_csv(\"data/22 - Births  females 15-19 years (per 1,000) - Connecticut.CSV\")\n",
    "inventory"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Total                                                                    252\n",
       "Hispanic or Latino (Of mother)                                           252\n",
       "Aged 15-17 years (Of mother)                                             252\n",
       "Aged 18-19 years (Of mother)                                             252\n",
       "Black or African American, non-Hispanic (Of mother)                      216\n",
       "White, non-Hispanic (Of mother)                                          216\n",
       "Non-Hispanic White (Of mother)                                            36\n",
       "Non-Hispanic Black (Of mother)                                            36\n",
       "Aged 18-19 years; Hispanic or Latino (Of mother)                          28\n",
       "Aged 15-17 years; Hispanic or Latino (Of mother)                          28\n",
       "Aged 18-19 years; Black or African American, non-Hispanic (Of mother)     24\n",
       "Aged 18-19 years; White, non-Hispanic (Of mother)                         24\n",
       "Aged 15-17 years; White, non-Hispanic (Of mother)                         24\n",
       "Aged 15-17 years; Black or African American, non-Hispanic (Of mother)     24\n",
       "Aged 15-17 years; Non-Hispanic White (Of mother)                           4\n",
       "Aged 18-19 years; Non-Hispanic Black (Of mother)                           4\n",
       "Aged 15-17 years; Non-Hispanic Black (Of mother)                           4\n",
       "Aged 18-19 years; Non-Hispanic White (Of mother)                           4\n",
       "Name: Dimension List, dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory[\"Dimension List\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Indicator ID</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Missing Value Flag</th>\n",
       "      <th>Confidence Interval Low</th>\n",
       "      <th>Confidence Interval High</th>\n",
       "      <th>Standard Error</th>\n",
       "      <th>LocaleID</th>\n",
       "      <th>Locale</th>\n",
       "      <th>...</th>\n",
       "      <th>Characteristic Of School Or Student</th>\n",
       "      <th>Other</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Modifier1</th>\n",
       "      <th>Modifier2</th>\n",
       "      <th>Modifier3</th>\n",
       "      <th>Modifier4</th>\n",
       "      <th>Modifier5</th>\n",
       "      <th>Numerator</th>\n",
       "      <th>Denominator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>416484941</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79407.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>416487310</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20589.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>416487316</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16767.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>416487322</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4817.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>416487328</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4218.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>416487334</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17516.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>416487340</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6132.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>416487346</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>416487352</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3144.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Indicator ID                  Dimension List Timeframe Numeric Value  \\\n",
       "10     416484941  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "16     416487310  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "22     416487316  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "28     416487322  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "34     416487328  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "40     416487334  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "46     416487340  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "52     416487346  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "58     416487352  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "\n",
       "   Missing Value Flag  Confidence Interval Low  Confidence Interval High  \\\n",
       "10                DSU                      NaN                       NaN   \n",
       "16                DSU                      NaN                       NaN   \n",
       "22                DSU                      NaN                       NaN   \n",
       "28                DSU                      NaN                       NaN   \n",
       "34                DSU                      NaN                       NaN   \n",
       "40                DSU                      NaN                       NaN   \n",
       "46                DSU                      NaN                       NaN   \n",
       "52                DSU                      NaN                       NaN   \n",
       "58                DSU                      NaN                       NaN   \n",
       "\n",
       "    Standard Error  LocaleID                    Locale     ...       \\\n",
       "10             NaN         9               Connecticut     ...        \n",
       "16             NaN       409   Connecticut - Fairfield     ...        \n",
       "22             NaN       410    Connecticut - Hartford     ...        \n",
       "28             NaN       411  Connecticut - Litchfield     ...        \n",
       "34             NaN       412   Connecticut - Middlesex     ...        \n",
       "40             NaN       413   Connecticut - New Haven     ...        \n",
       "46             NaN       414  Connecticut - New London     ...        \n",
       "52             NaN       415     Connecticut - Tolland     ...        \n",
       "58             NaN       416     Connecticut - Windham     ...        \n",
       "\n",
       "   Characteristic Of School Or Student  Other  Geography    Modifier1  \\\n",
       "10                                 NaN    NaN        NaN  (Of mother)   \n",
       "16                                 NaN    NaN        NaN  (Of mother)   \n",
       "22                                 NaN    NaN        NaN  (Of mother)   \n",
       "28                                 NaN    NaN        NaN  (Of mother)   \n",
       "34                                 NaN    NaN        NaN  (Of mother)   \n",
       "40                                 NaN    NaN        NaN  (Of mother)   \n",
       "46                                 NaN    NaN        NaN  (Of mother)   \n",
       "52                                 NaN    NaN        NaN  (Of mother)   \n",
       "58                                 NaN    NaN        NaN  (Of mother)   \n",
       "\n",
       "    Modifier2 Modifier3 Modifier4  Modifier5 Numerator  Denominator  \n",
       "10        NaN       NaN       NaN        NaN       NaN      79407.0  \n",
       "16        NaN       NaN       NaN        NaN       NaN      20589.0  \n",
       "22        NaN       NaN       NaN        NaN       NaN      16767.0  \n",
       "28        NaN       NaN       NaN        NaN       NaN       4817.0  \n",
       "34        NaN       NaN       NaN        NaN       NaN       4218.0  \n",
       "40        NaN       NaN       NaN        NaN       NaN      17516.0  \n",
       "46        NaN       NaN       NaN        NaN       NaN       6132.0  \n",
       "52        NaN       NaN       NaN        NaN       NaN       6224.0  \n",
       "58        NaN       NaN       NaN        NaN       NaN       3144.0  \n",
       "\n",
       "[9 rows x 39 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory[(inventory[\"Dimension List\"] == \"Non-Hispanic White (Of mother)\")\n",
    "         & (inventory[\"Timeframe\"] == \"2014\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Connecticut                 336\n",
       "Connecticut - Middlesex     168\n",
       "Connecticut - New Haven     168\n",
       "Connecticut - Fairfield     168\n",
       "Connecticut - Tolland       168\n",
       "Connecticut - New London    168\n",
       "Connecticut - Litchfield    168\n",
       "Connecticut - Hartford      168\n",
       "Connecticut - Windham       168\n",
       "Name: Locale, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory[\"Locale\"].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Statewide rates by year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Indicator ID</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Missing Value Flag</th>\n",
       "      <th>Confidence Interval Low</th>\n",
       "      <th>Confidence Interval High</th>\n",
       "      <th>Standard Error</th>\n",
       "      <th>LocaleID</th>\n",
       "      <th>Locale</th>\n",
       "      <th>...</th>\n",
       "      <th>Characteristic Of School Or Student</th>\n",
       "      <th>Other</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Modifier1</th>\n",
       "      <th>Modifier2</th>\n",
       "      <th>Modifier3</th>\n",
       "      <th>Modifier4</th>\n",
       "      <th>Modifier5</th>\n",
       "      <th>Numerator</th>\n",
       "      <th>Denominator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>416484936</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>11.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1420.0</td>\n",
       "      <td>123357.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>364980867</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>12.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.3</td>\n",
       "      <td>13.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1606.0</td>\n",
       "      <td>124102.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>225126302</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>15.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.4</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1889.0</td>\n",
       "      <td>124986.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>159046499</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>16.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.7</td>\n",
       "      <td>17.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>123249.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>158968619</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>18.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.9</td>\n",
       "      <td>19.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2274.0</td>\n",
       "      <td>121885.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1200</th>\n",
       "      <td>159202259</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>21.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2605.0</td>\n",
       "      <td>123044.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1440</th>\n",
       "      <td>159182789</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>22.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2789.0</td>\n",
       "      <td>123448.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Indicator ID Dimension List Timeframe Numeric Value Missing Value Flag  \\\n",
       "0        416484936          Total      2014          11.5                NaN   \n",
       "240      364980867          Total      2013          12.9                NaN   \n",
       "480      225126302          Total      2012          15.1                NaN   \n",
       "720      159046499          Total      2011          16.4                NaN   \n",
       "960      158968619          Total      2010          18.7                NaN   \n",
       "1200     159202259          Total      2009          21.2                NaN   \n",
       "1440     159182789          Total      2008          22.6                NaN   \n",
       "\n",
       "      Confidence Interval Low  Confidence Interval High  Standard Error  \\\n",
       "0                        10.9                      12.1             0.3   \n",
       "240                      12.3                      13.6             0.3   \n",
       "480                      14.4                      15.8             0.3   \n",
       "720                      15.7                      17.1             0.4   \n",
       "960                      17.9                      19.4             0.4   \n",
       "1200                     20.4                      22.0             0.4   \n",
       "1440                     21.8                      23.4             0.4   \n",
       "\n",
       "      LocaleID       Locale     ...      Characteristic Of School Or Student  \\\n",
       "0            9  Connecticut     ...                                      NaN   \n",
       "240          9  Connecticut     ...                                      NaN   \n",
       "480          9  Connecticut     ...                                      NaN   \n",
       "720          9  Connecticut     ...                                      NaN   \n",
       "960          9  Connecticut     ...                                      NaN   \n",
       "1200         9  Connecticut     ...                                      NaN   \n",
       "1440         9  Connecticut     ...                                      NaN   \n",
       "\n",
       "      Other  Geography  Modifier1  Modifier2 Modifier3 Modifier4  Modifier5  \\\n",
       "0       NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "240     NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "480     NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "720     NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "960     NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "1200    NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "1440    NaN        NaN        NaN        NaN       NaN       NaN        NaN   \n",
       "\n",
       "     Numerator  Denominator  \n",
       "0       1420.0     123357.0  \n",
       "240     1606.0     124102.0  \n",
       "480     1889.0     124986.0  \n",
       "720     2020.0     123249.0  \n",
       "960     2274.0     121885.0  \n",
       "1200    2605.0     123044.0  \n",
       "1440    2789.0     123448.0  \n",
       "\n",
       "[7 rows x 39 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory[(inventory[\"Locale\"] == \"Connecticut\")\n",
    "          & (inventory[\"Dimension List\"] == \"Total\")\n",
    "         & ~(inventory[\"Timeframe\"].str.contains(\"-\"))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Connecticut                 336\n",
       "Connecticut - Middlesex     168\n",
       "Connecticut - New Haven     168\n",
       "Connecticut - Fairfield     168\n",
       "Connecticut - Tolland       168\n",
       "Connecticut - New London    168\n",
       "Connecticut - Litchfield    168\n",
       "Connecticut - Hartford      168\n",
       "Connecticut - Windham       168\n",
       "Name: Locale, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List the counties/locales\n",
    "inventory[\"Locale\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Indicator ID</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Missing Value Flag</th>\n",
       "      <th>Confidence Interval Low</th>\n",
       "      <th>Confidence Interval High</th>\n",
       "      <th>Standard Error</th>\n",
       "      <th>LocaleID</th>\n",
       "      <th>Locale</th>\n",
       "      <th>...</th>\n",
       "      <th>Characteristic Of School Or Student</th>\n",
       "      <th>Other</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Modifier1</th>\n",
       "      <th>Modifier2</th>\n",
       "      <th>Modifier3</th>\n",
       "      <th>Modifier4</th>\n",
       "      <th>Modifier5</th>\n",
       "      <th>Numerator</th>\n",
       "      <th>Denominator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>416484936</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>11.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.9</td>\n",
       "      <td>12.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1420.0</td>\n",
       "      <td>123357.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>416487306</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>9.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>10.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>307.0</td>\n",
       "      <td>32927.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>416487312</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>14.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.4</td>\n",
       "      <td>16.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>435.0</td>\n",
       "      <td>29413.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>416487318</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>7.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.7</td>\n",
       "      <td>10.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>5563.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>416487324</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>6.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.6</td>\n",
       "      <td>9.2</td>\n",
       "      <td>1.1</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>5285.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>416487330</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>14.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.1</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>435.0</td>\n",
       "      <td>30100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>416487336</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>10.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.2</td>\n",
       "      <td>12.6</td>\n",
       "      <td>1.1</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.0</td>\n",
       "      <td>8573.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>416487342</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>3.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.5</td>\n",
       "      <td>5.4</td>\n",
       "      <td>0.7</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>7501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>416487348</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.9</td>\n",
       "      <td>15.9</td>\n",
       "      <td>1.7</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>3995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>364980867</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>12.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.3</td>\n",
       "      <td>13.6</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1606.0</td>\n",
       "      <td>124102.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>364983243</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>11.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.9</td>\n",
       "      <td>12.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>363.0</td>\n",
       "      <td>32832.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>364983249</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>14.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.4</td>\n",
       "      <td>16.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>440.0</td>\n",
       "      <td>29785.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>364983255</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>7.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.1</td>\n",
       "      <td>9.7</td>\n",
       "      <td>1.1</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>5758.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>364983261</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>6.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.8</td>\n",
       "      <td>9.4</td>\n",
       "      <td>1.1</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>5291.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>364983267</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>17.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.9</td>\n",
       "      <td>18.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>525.0</td>\n",
       "      <td>30223.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>364983273</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>13.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.8</td>\n",
       "      <td>15.7</td>\n",
       "      <td>1.2</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>116.0</td>\n",
       "      <td>8758.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>364983279</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>3.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.4</td>\n",
       "      <td>5.3</td>\n",
       "      <td>0.7</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>7416.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>364983285</td>\n",
       "      <td>Total</td>\n",
       "      <td>2013</td>\n",
       "      <td>14.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.9</td>\n",
       "      <td>18.6</td>\n",
       "      <td>1.9</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58.0</td>\n",
       "      <td>4039.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>225126302</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>15.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.4</td>\n",
       "      <td>15.8</td>\n",
       "      <td>0.3</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1889.0</td>\n",
       "      <td>124986.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>225128678</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>11.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.7</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>387.0</td>\n",
       "      <td>32665.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>225128684</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.4</td>\n",
       "      <td>21.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600.0</td>\n",
       "      <td>30071.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>225128690</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>9.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.2</td>\n",
       "      <td>12.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56.0</td>\n",
       "      <td>5905.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>225128696</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>6.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.8</td>\n",
       "      <td>9.5</td>\n",
       "      <td>1.1</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>5250.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>225128702</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>17.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.4</td>\n",
       "      <td>19.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>548.0</td>\n",
       "      <td>30553.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>225128708</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>15.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.6</td>\n",
       "      <td>17.7</td>\n",
       "      <td>1.3</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135.0</td>\n",
       "      <td>8931.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>225128714</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.0</td>\n",
       "      <td>7423.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>225128720</td>\n",
       "      <td>Total</td>\n",
       "      <td>2012</td>\n",
       "      <td>22.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.1</td>\n",
       "      <td>27.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94.0</td>\n",
       "      <td>4188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>159046499</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>16.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.7</td>\n",
       "      <td>17.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>123249.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>159048869</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>14.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15.6</td>\n",
       "      <td>0.7</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>454.0</td>\n",
       "      <td>31747.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>159048875</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>20.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>22.3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>615.0</td>\n",
       "      <td>29795.0</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",
       "      <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>762</th>\n",
       "      <td>159048899</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>17.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.7</td>\n",
       "      <td>20.2</td>\n",
       "      <td>1.4</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>154.0</td>\n",
       "      <td>8840.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>159048905</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>5.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.0</td>\n",
       "      <td>7279.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>159048911</td>\n",
       "      <td>Total</td>\n",
       "      <td>2011</td>\n",
       "      <td>21.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.1</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91.0</td>\n",
       "      <td>4294.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>158968619</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>18.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.9</td>\n",
       "      <td>19.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2274.0</td>\n",
       "      <td>121885.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>158970989</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>15.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>468.0</td>\n",
       "      <td>30376.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>158970995</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>24.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.9</td>\n",
       "      <td>26.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>735.0</td>\n",
       "      <td>29772.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>158971001</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>11.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.7</td>\n",
       "      <td>14.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.0</td>\n",
       "      <td>5781.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>158971007</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>10.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.2</td>\n",
       "      <td>14.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>55.0</td>\n",
       "      <td>5078.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>158971013</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>21.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.5</td>\n",
       "      <td>22.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>648.0</td>\n",
       "      <td>30659.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>158971019</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>18.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.8</td>\n",
       "      <td>21.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>166.0</td>\n",
       "      <td>8918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>158971025</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>6.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.4</td>\n",
       "      <td>8.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>6865.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>158971031</td>\n",
       "      <td>Total</td>\n",
       "      <td>2010</td>\n",
       "      <td>21.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.3</td>\n",
       "      <td>26.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.0</td>\n",
       "      <td>4436.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1200</th>\n",
       "      <td>159202259</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>21.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.4</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2605.0</td>\n",
       "      <td>123044.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>159204629</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>17.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.8</td>\n",
       "      <td>18.8</td>\n",
       "      <td>0.8</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>526.0</td>\n",
       "      <td>30448.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1218</th>\n",
       "      <td>159204635</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>27.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.8</td>\n",
       "      <td>29.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>834.0</td>\n",
       "      <td>30158.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1224</th>\n",
       "      <td>159204641</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>11.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.8</td>\n",
       "      <td>14.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>67.0</td>\n",
       "      <td>5918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1230</th>\n",
       "      <td>159204647</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>10.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.6</td>\n",
       "      <td>13.3</td>\n",
       "      <td>1.4</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>52.0</td>\n",
       "      <td>5113.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1236</th>\n",
       "      <td>159204653</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>24.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.0</td>\n",
       "      <td>26.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>766.0</td>\n",
       "      <td>30969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1242</th>\n",
       "      <td>159204659</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>22.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.2</td>\n",
       "      <td>25.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201.0</td>\n",
       "      <td>9014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1248</th>\n",
       "      <td>159204665</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>7.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.8</td>\n",
       "      <td>10.1</td>\n",
       "      <td>1.1</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54.0</td>\n",
       "      <td>6943.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1254</th>\n",
       "      <td>159204671</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>23.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>27.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>105.0</td>\n",
       "      <td>4481.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1440</th>\n",
       "      <td>159182789</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>22.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.8</td>\n",
       "      <td>23.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>9</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2789.0</td>\n",
       "      <td>123448.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1452</th>\n",
       "      <td>159185159</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>19.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.5</td>\n",
       "      <td>20.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>578.0</td>\n",
       "      <td>30318.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1458</th>\n",
       "      <td>159185165</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>29.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.5</td>\n",
       "      <td>31.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>410</td>\n",
       "      <td>Connecticut - Hartford</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>893.0</td>\n",
       "      <td>30390.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>159185171</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>12.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.1</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>411</td>\n",
       "      <td>Connecticut - Litchfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.0</td>\n",
       "      <td>6011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>159185177</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>11.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.9</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>412</td>\n",
       "      <td>Connecticut - Middlesex</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>5139.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>159185183</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>26.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.4</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>413</td>\n",
       "      <td>Connecticut - New Haven</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>813.0</td>\n",
       "      <td>31046.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>159185189</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.9</td>\n",
       "      <td>25.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>414</td>\n",
       "      <td>Connecticut - New London</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>199.0</td>\n",
       "      <td>9044.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1488</th>\n",
       "      <td>159185195</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>6.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.8</td>\n",
       "      <td>8.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>415</td>\n",
       "      <td>Connecticut - Tolland</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.0</td>\n",
       "      <td>6955.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>159185201</td>\n",
       "      <td>Total</td>\n",
       "      <td>2008</td>\n",
       "      <td>27.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.3</td>\n",
       "      <td>31.8</td>\n",
       "      <td>2.4</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>123.0</td>\n",
       "      <td>4545.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Indicator ID Dimension List Timeframe Numeric Value Missing Value Flag  \\\n",
       "0        416484936          Total      2014          11.5                NaN   \n",
       "12       416487306          Total      2014           9.3                NaN   \n",
       "18       416487312          Total      2014          14.8                NaN   \n",
       "24       416487318          Total      2014           7.9                NaN   \n",
       "30       416487324          Total      2014           6.6                NaN   \n",
       "36       416487330          Total      2014          14.5                NaN   \n",
       "42       416487336          Total      2014          10.3                NaN   \n",
       "48       416487342          Total      2014           3.7                NaN   \n",
       "54       416487348          Total      2014          12.0                NaN   \n",
       "240      364980867          Total      2013          12.9                NaN   \n",
       "252      364983243          Total      2013          11.1                NaN   \n",
       "258      364983249          Total      2013          14.8                NaN   \n",
       "264      364983255          Total      2013           7.1                NaN   \n",
       "270      364983261          Total      2013           6.8                NaN   \n",
       "276      364983267          Total      2013          17.4                NaN   \n",
       "282      364983273          Total      2013          13.2                NaN   \n",
       "288      364983279          Total      2013           3.6                NaN   \n",
       "294      364983285          Total      2013          14.4                NaN   \n",
       "480      225126302          Total      2012          15.1                NaN   \n",
       "492      225128678          Total      2012          11.8                NaN   \n",
       "498      225128684          Total      2012          20.0                NaN   \n",
       "504      225128690          Total      2012           9.5                NaN   \n",
       "510      225128696          Total      2012           6.9                NaN   \n",
       "516      225128702          Total      2012          17.9                NaN   \n",
       "522      225128708          Total      2012          15.1                NaN   \n",
       "528      225128714          Total      2012           4.4                NaN   \n",
       "534      225128720          Total      2012          22.4                NaN   \n",
       "720      159046499          Total      2011          16.4                NaN   \n",
       "732      159048869          Total      2011          14.3                NaN   \n",
       "738      159048875          Total      2011          20.6                NaN   \n",
       "...            ...            ...       ...           ...                ...   \n",
       "762      159048899          Total      2011          17.4                NaN   \n",
       "768      159048905          Total      2011           5.1                NaN   \n",
       "774      159048911          Total      2011          21.2                NaN   \n",
       "960      158968619          Total      2010          18.7                NaN   \n",
       "972      158970989          Total      2010          15.4                NaN   \n",
       "978      158970995          Total      2010          24.7                NaN   \n",
       "984      158971001          Total      2010          11.2                NaN   \n",
       "990      158971007          Total      2010          10.8                NaN   \n",
       "996      158971013          Total      2010          21.1                NaN   \n",
       "1002     158971019          Total      2010          18.6                NaN   \n",
       "1008     158971025          Total      2010           6.1                NaN   \n",
       "1014     158971031          Total      2010          21.4                NaN   \n",
       "1200     159202259          Total      2009          21.2                NaN   \n",
       "1212     159204629          Total      2009          17.3                NaN   \n",
       "1218     159204635          Total      2009          27.7                NaN   \n",
       "1224     159204641          Total      2009          11.3                NaN   \n",
       "1230     159204647          Total      2009          10.2                NaN   \n",
       "1236     159204653          Total      2009          24.7                NaN   \n",
       "1242     159204659          Total      2009          22.3                NaN   \n",
       "1248     159204665          Total      2009           7.8                NaN   \n",
       "1254     159204671          Total      2009          23.4                NaN   \n",
       "1440     159182789          Total      2008          22.6                NaN   \n",
       "1452     159185159          Total      2008          19.1                NaN   \n",
       "1458     159185165          Total      2008          29.4                NaN   \n",
       "1464     159185171          Total      2008          12.8                NaN   \n",
       "1470     159185177          Total      2008          11.7                NaN   \n",
       "1476     159185183          Total      2008          26.2                NaN   \n",
       "1482     159185189          Total      2008          22.0                NaN   \n",
       "1488     159185195          Total      2008           6.6                NaN   \n",
       "1494     159185201          Total      2008          27.1                NaN   \n",
       "\n",
       "      Confidence Interval Low  Confidence Interval High  Standard Error  \\\n",
       "0                        10.9                      12.1             0.3   \n",
       "12                        8.3                      10.4             0.5   \n",
       "18                       13.4                      16.2             0.7   \n",
       "24                        5.7                      10.6             1.2   \n",
       "30                        4.6                       9.2             1.1   \n",
       "36                       13.1                      15.8             0.7   \n",
       "42                        8.2                      12.6             1.1   \n",
       "48                        2.5                       5.4             0.7   \n",
       "54                        8.9                      15.9             1.7   \n",
       "240                      12.3                      13.6             0.3   \n",
       "252                       9.9                      12.2             0.6   \n",
       "258                      13.4                      16.2             0.7   \n",
       "264                       5.1                       9.7             1.1   \n",
       "270                       4.8                       9.4             1.1   \n",
       "276                      15.9                      18.9             0.8   \n",
       "282                      10.8                      15.7             1.2   \n",
       "288                       2.4                       5.3             0.7   \n",
       "294                      10.9                      18.6             1.9   \n",
       "480                      14.4                      15.8             0.3   \n",
       "492                      10.7                      13.0             0.6   \n",
       "498                      18.4                      21.5             0.8   \n",
       "504                       7.2                      12.3             1.3   \n",
       "510                       4.8                       9.5             1.1   \n",
       "516                      16.4                      19.4             0.8   \n",
       "522                      12.6                      17.7             1.3   \n",
       "528                       3.1                       6.2             0.8   \n",
       "534                      18.1                      27.5             2.3   \n",
       "720                      15.7                      17.1             0.4   \n",
       "732                      13.0                      15.6             0.7   \n",
       "738                      19.0                      22.3             0.8   \n",
       "...                       ...                       ...             ...   \n",
       "762                      14.7                      20.2             1.4   \n",
       "768                       3.6                       7.0             0.8   \n",
       "774                      17.1                      26.0             2.2   \n",
       "960                      17.9                      19.4             0.4   \n",
       "972                      14.0                      16.8             0.7   \n",
       "978                      22.9                      26.5             0.9   \n",
       "984                       8.7                      14.3             1.4   \n",
       "990                       8.2                      14.1             1.5   \n",
       "996                      19.5                      22.8             0.8   \n",
       "1002                     15.8                      21.4             1.4   \n",
       "1008                      4.4                       8.3             0.9   \n",
       "1014                     17.3                      26.2             2.2   \n",
       "1200                     20.4                      22.0             0.4   \n",
       "1212                     15.8                      18.8             0.8   \n",
       "1218                     25.8                      29.5             1.0   \n",
       "1224                      8.8                      14.4             1.4   \n",
       "1230                      7.6                      13.3             1.4   \n",
       "1236                     23.0                      26.5             0.9   \n",
       "1242                     19.2                      25.4             1.6   \n",
       "1248                      5.8                      10.1             1.1   \n",
       "1254                     19.0                      27.9             2.3   \n",
       "1440                     21.8                      23.4             0.4   \n",
       "1452                     17.5                      20.6             0.8   \n",
       "1458                     27.5                      31.3             1.0   \n",
       "1464                     10.1                      16.0             1.5   \n",
       "1470                      8.9                      15.0             1.5   \n",
       "1476                     24.4                      28.0             0.9   \n",
       "1482                     18.9                      25.1             1.6   \n",
       "1488                      4.8                       8.8             1.0   \n",
       "1494                     22.3                      31.8             2.4   \n",
       "\n",
       "      LocaleID                    Locale     ...       \\\n",
       "0            9               Connecticut     ...        \n",
       "12         409   Connecticut - Fairfield     ...        \n",
       "18         410    Connecticut - Hartford     ...        \n",
       "24         411  Connecticut - Litchfield     ...        \n",
       "30         412   Connecticut - Middlesex     ...        \n",
       "36         413   Connecticut - New Haven     ...        \n",
       "42         414  Connecticut - New London     ...        \n",
       "48         415     Connecticut - Tolland     ...        \n",
       "54         416     Connecticut - Windham     ...        \n",
       "240          9               Connecticut     ...        \n",
       "252        409   Connecticut - Fairfield     ...        \n",
       "258        410    Connecticut - Hartford     ...        \n",
       "264        411  Connecticut - Litchfield     ...        \n",
       "270        412   Connecticut - Middlesex     ...        \n",
       "276        413   Connecticut - New Haven     ...        \n",
       "282        414  Connecticut - New London     ...        \n",
       "288        415     Connecticut - Tolland     ...        \n",
       "294        416     Connecticut - Windham     ...        \n",
       "480          9               Connecticut     ...        \n",
       "492        409   Connecticut - Fairfield     ...        \n",
       "498        410    Connecticut - Hartford     ...        \n",
       "504        411  Connecticut - Litchfield     ...        \n",
       "510        412   Connecticut - Middlesex     ...        \n",
       "516        413   Connecticut - New Haven     ...        \n",
       "522        414  Connecticut - New London     ...        \n",
       "528        415     Connecticut - Tolland     ...        \n",
       "534        416     Connecticut - Windham     ...        \n",
       "720          9               Connecticut     ...        \n",
       "732        409   Connecticut - Fairfield     ...        \n",
       "738        410    Connecticut - Hartford     ...        \n",
       "...        ...                       ...     ...        \n",
       "762        414  Connecticut - New London     ...        \n",
       "768        415     Connecticut - Tolland     ...        \n",
       "774        416     Connecticut - Windham     ...        \n",
       "960          9               Connecticut     ...        \n",
       "972        409   Connecticut - Fairfield     ...        \n",
       "978        410    Connecticut - Hartford     ...        \n",
       "984        411  Connecticut - Litchfield     ...        \n",
       "990        412   Connecticut - Middlesex     ...        \n",
       "996        413   Connecticut - New Haven     ...        \n",
       "1002       414  Connecticut - New London     ...        \n",
       "1008       415     Connecticut - Tolland     ...        \n",
       "1014       416     Connecticut - Windham     ...        \n",
       "1200         9               Connecticut     ...        \n",
       "1212       409   Connecticut - Fairfield     ...        \n",
       "1218       410    Connecticut - Hartford     ...        \n",
       "1224       411  Connecticut - Litchfield     ...        \n",
       "1230       412   Connecticut - Middlesex     ...        \n",
       "1236       413   Connecticut - New Haven     ...        \n",
       "1242       414  Connecticut - New London     ...        \n",
       "1248       415     Connecticut - Tolland     ...        \n",
       "1254       416     Connecticut - Windham     ...        \n",
       "1440         9               Connecticut     ...        \n",
       "1452       409   Connecticut - Fairfield     ...        \n",
       "1458       410    Connecticut - Hartford     ...        \n",
       "1464       411  Connecticut - Litchfield     ...        \n",
       "1470       412   Connecticut - Middlesex     ...        \n",
       "1476       413   Connecticut - New Haven     ...        \n",
       "1482       414  Connecticut - New London     ...        \n",
       "1488       415     Connecticut - Tolland     ...        \n",
       "1494       416     Connecticut - Windham     ...        \n",
       "\n",
       "     Characteristic Of School Or Student  Other  Geography  Modifier1  \\\n",
       "0                                    NaN    NaN        NaN        NaN   \n",
       "12                                   NaN    NaN        NaN        NaN   \n",
       "18                                   NaN    NaN        NaN        NaN   \n",
       "24                                   NaN    NaN        NaN        NaN   \n",
       "30                                   NaN    NaN        NaN        NaN   \n",
       "36                                   NaN    NaN        NaN        NaN   \n",
       "42                                   NaN    NaN        NaN        NaN   \n",
       "48                                   NaN    NaN        NaN        NaN   \n",
       "54                                   NaN    NaN        NaN        NaN   \n",
       "240                                  NaN    NaN        NaN        NaN   \n",
       "252                                  NaN    NaN        NaN        NaN   \n",
       "258                                  NaN    NaN        NaN        NaN   \n",
       "264                                  NaN    NaN        NaN        NaN   \n",
       "270                                  NaN    NaN        NaN        NaN   \n",
       "276                                  NaN    NaN        NaN        NaN   \n",
       "282                                  NaN    NaN        NaN        NaN   \n",
       "288                                  NaN    NaN        NaN        NaN   \n",
       "294                                  NaN    NaN        NaN        NaN   \n",
       "480                                  NaN    NaN        NaN        NaN   \n",
       "492                                  NaN    NaN        NaN        NaN   \n",
       "498                                  NaN    NaN        NaN        NaN   \n",
       "504                                  NaN    NaN        NaN        NaN   \n",
       "510                                  NaN    NaN        NaN        NaN   \n",
       "516                                  NaN    NaN        NaN        NaN   \n",
       "522                                  NaN    NaN        NaN        NaN   \n",
       "528                                  NaN    NaN        NaN        NaN   \n",
       "534                                  NaN    NaN        NaN        NaN   \n",
       "720                                  NaN    NaN        NaN        NaN   \n",
       "732                                  NaN    NaN        NaN        NaN   \n",
       "738                                  NaN    NaN        NaN        NaN   \n",
       "...                                  ...    ...        ...        ...   \n",
       "762                                  NaN    NaN        NaN        NaN   \n",
       "768                                  NaN    NaN        NaN        NaN   \n",
       "774                                  NaN    NaN        NaN        NaN   \n",
       "960                                  NaN    NaN        NaN        NaN   \n",
       "972                                  NaN    NaN        NaN        NaN   \n",
       "978                                  NaN    NaN        NaN        NaN   \n",
       "984                                  NaN    NaN        NaN        NaN   \n",
       "990                                  NaN    NaN        NaN        NaN   \n",
       "996                                  NaN    NaN        NaN        NaN   \n",
       "1002                                 NaN    NaN        NaN        NaN   \n",
       "1008                                 NaN    NaN        NaN        NaN   \n",
       "1014                                 NaN    NaN        NaN        NaN   \n",
       "1200                                 NaN    NaN        NaN        NaN   \n",
       "1212                                 NaN    NaN        NaN        NaN   \n",
       "1218                                 NaN    NaN        NaN        NaN   \n",
       "1224                                 NaN    NaN        NaN        NaN   \n",
       "1230                                 NaN    NaN        NaN        NaN   \n",
       "1236                                 NaN    NaN        NaN        NaN   \n",
       "1242                                 NaN    NaN        NaN        NaN   \n",
       "1248                                 NaN    NaN        NaN        NaN   \n",
       "1254                                 NaN    NaN        NaN        NaN   \n",
       "1440                                 NaN    NaN        NaN        NaN   \n",
       "1452                                 NaN    NaN        NaN        NaN   \n",
       "1458                                 NaN    NaN        NaN        NaN   \n",
       "1464                                 NaN    NaN        NaN        NaN   \n",
       "1470                                 NaN    NaN        NaN        NaN   \n",
       "1476                                 NaN    NaN        NaN        NaN   \n",
       "1482                                 NaN    NaN        NaN        NaN   \n",
       "1488                                 NaN    NaN        NaN        NaN   \n",
       "1494                                 NaN    NaN        NaN        NaN   \n",
       "\n",
       "      Modifier2 Modifier3 Modifier4  Modifier5 Numerator  Denominator  \n",
       "0           NaN       NaN       NaN        NaN    1420.0     123357.0  \n",
       "12          NaN       NaN       NaN        NaN     307.0      32927.0  \n",
       "18          NaN       NaN       NaN        NaN     435.0      29413.0  \n",
       "24          NaN       NaN       NaN        NaN      44.0       5563.0  \n",
       "30          NaN       NaN       NaN        NaN      35.0       5285.0  \n",
       "36          NaN       NaN       NaN        NaN     435.0      30100.0  \n",
       "42          NaN       NaN       NaN        NaN      88.0       8573.0  \n",
       "48          NaN       NaN       NaN        NaN      28.0       7501.0  \n",
       "54          NaN       NaN       NaN        NaN      48.0       3995.0  \n",
       "240         NaN       NaN       NaN        NaN    1606.0     124102.0  \n",
       "252         NaN       NaN       NaN        NaN     363.0      32832.0  \n",
       "258         NaN       NaN       NaN        NaN     440.0      29785.0  \n",
       "264         NaN       NaN       NaN        NaN      41.0       5758.0  \n",
       "270         NaN       NaN       NaN        NaN      36.0       5291.0  \n",
       "276         NaN       NaN       NaN        NaN     525.0      30223.0  \n",
       "282         NaN       NaN       NaN        NaN     116.0       8758.0  \n",
       "288         NaN       NaN       NaN        NaN      27.0       7416.0  \n",
       "294         NaN       NaN       NaN        NaN      58.0       4039.0  \n",
       "480         NaN       NaN       NaN        NaN    1889.0     124986.0  \n",
       "492         NaN       NaN       NaN        NaN     387.0      32665.0  \n",
       "498         NaN       NaN       NaN        NaN     600.0      30071.0  \n",
       "504         NaN       NaN       NaN        NaN      56.0       5905.0  \n",
       "510         NaN       NaN       NaN        NaN      36.0       5250.0  \n",
       "516         NaN       NaN       NaN        NaN     548.0      30553.0  \n",
       "522         NaN       NaN       NaN        NaN     135.0       8931.0  \n",
       "528         NaN       NaN       NaN        NaN      33.0       7423.0  \n",
       "534         NaN       NaN       NaN        NaN      94.0       4188.0  \n",
       "720         NaN       NaN       NaN        NaN    2020.0     123249.0  \n",
       "732         NaN       NaN       NaN        NaN     454.0      31747.0  \n",
       "738         NaN       NaN       NaN        NaN     615.0      29795.0  \n",
       "...         ...       ...       ...        ...       ...          ...  \n",
       "762         NaN       NaN       NaN        NaN     154.0       8840.0  \n",
       "768         NaN       NaN       NaN        NaN      37.0       7279.0  \n",
       "774         NaN       NaN       NaN        NaN      91.0       4294.0  \n",
       "960         NaN       NaN       NaN        NaN    2274.0     121885.0  \n",
       "972         NaN       NaN       NaN        NaN     468.0      30376.0  \n",
       "978         NaN       NaN       NaN        NaN     735.0      29772.0  \n",
       "984         NaN       NaN       NaN        NaN      65.0       5781.0  \n",
       "990         NaN       NaN       NaN        NaN      55.0       5078.0  \n",
       "996         NaN       NaN       NaN        NaN     648.0      30659.0  \n",
       "1002        NaN       NaN       NaN        NaN     166.0       8918.0  \n",
       "1008        NaN       NaN       NaN        NaN      42.0       6865.0  \n",
       "1014        NaN       NaN       NaN        NaN      95.0       4436.0  \n",
       "1200        NaN       NaN       NaN        NaN    2605.0     123044.0  \n",
       "1212        NaN       NaN       NaN        NaN     526.0      30448.0  \n",
       "1218        NaN       NaN       NaN        NaN     834.0      30158.0  \n",
       "1224        NaN       NaN       NaN        NaN      67.0       5918.0  \n",
       "1230        NaN       NaN       NaN        NaN      52.0       5113.0  \n",
       "1236        NaN       NaN       NaN        NaN     766.0      30969.0  \n",
       "1242        NaN       NaN       NaN        NaN     201.0       9014.0  \n",
       "1248        NaN       NaN       NaN        NaN      54.0       6943.0  \n",
       "1254        NaN       NaN       NaN        NaN     105.0       4481.0  \n",
       "1440        NaN       NaN       NaN        NaN    2789.0     123448.0  \n",
       "1452        NaN       NaN       NaN        NaN     578.0      30318.0  \n",
       "1458        NaN       NaN       NaN        NaN     893.0      30390.0  \n",
       "1464        NaN       NaN       NaN        NaN      77.0       6011.0  \n",
       "1470        NaN       NaN       NaN        NaN      60.0       5139.0  \n",
       "1476        NaN       NaN       NaN        NaN     813.0      31046.0  \n",
       "1482        NaN       NaN       NaN        NaN     199.0       9044.0  \n",
       "1488        NaN       NaN       NaN        NaN      46.0       6955.0  \n",
       "1494        NaN       NaN       NaN        NaN     123.0       4545.0  \n",
       "\n",
       "[63 rows x 39 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory[(inventory[\"Dimension List\"] == \"Total\")\n",
    "         & ~(inventory[\"Timeframe\"].str.contains(\"-\"))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Locale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2014</td>\n",
       "      <td>9.3</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2014</td>\n",
       "      <td>14.8</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2014</td>\n",
       "      <td>7.9</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2014</td>\n",
       "      <td>6.6</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2014</td>\n",
       "      <td>14.5</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2014</td>\n",
       "      <td>10.3</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2014</td>\n",
       "      <td>3.7</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2014</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>2013</td>\n",
       "      <td>11.1</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>2013</td>\n",
       "      <td>14.8</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>2013</td>\n",
       "      <td>7.1</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>2013</td>\n",
       "      <td>6.8</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>2013</td>\n",
       "      <td>17.4</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>2013</td>\n",
       "      <td>13.2</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>2013</td>\n",
       "      <td>3.6</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>2013</td>\n",
       "      <td>14.4</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>2012</td>\n",
       "      <td>11.8</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>2012</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>2012</td>\n",
       "      <td>9.5</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>2012</td>\n",
       "      <td>6.9</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>2012</td>\n",
       "      <td>17.9</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>2012</td>\n",
       "      <td>15.1</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>2012</td>\n",
       "      <td>4.4</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>2012</td>\n",
       "      <td>22.4</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>2011</td>\n",
       "      <td>14.3</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>2011</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>2011</td>\n",
       "      <td>10.3</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>2011</td>\n",
       "      <td>9.4</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>2011</td>\n",
       "      <td>18.5</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>2011</td>\n",
       "      <td>17.4</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>2011</td>\n",
       "      <td>5.1</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>2011</td>\n",
       "      <td>21.2</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>2010</td>\n",
       "      <td>15.4</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>2010</td>\n",
       "      <td>24.7</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>2010</td>\n",
       "      <td>11.2</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>2010</td>\n",
       "      <td>10.8</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>2010</td>\n",
       "      <td>21.1</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>2010</td>\n",
       "      <td>18.6</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>2010</td>\n",
       "      <td>6.1</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>2010</td>\n",
       "      <td>21.4</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>2009</td>\n",
       "      <td>17.3</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1218</th>\n",
       "      <td>2009</td>\n",
       "      <td>27.7</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1224</th>\n",
       "      <td>2009</td>\n",
       "      <td>11.3</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1230</th>\n",
       "      <td>2009</td>\n",
       "      <td>10.2</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1236</th>\n",
       "      <td>2009</td>\n",
       "      <td>24.7</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1242</th>\n",
       "      <td>2009</td>\n",
       "      <td>22.3</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1248</th>\n",
       "      <td>2009</td>\n",
       "      <td>7.8</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1254</th>\n",
       "      <td>2009</td>\n",
       "      <td>23.4</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1452</th>\n",
       "      <td>2008</td>\n",
       "      <td>19.1</td>\n",
       "      <td>Fairfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1458</th>\n",
       "      <td>2008</td>\n",
       "      <td>29.4</td>\n",
       "      <td>Hartford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>2008</td>\n",
       "      <td>12.8</td>\n",
       "      <td>Litchfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1470</th>\n",
       "      <td>2008</td>\n",
       "      <td>11.7</td>\n",
       "      <td>Middlesex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>2008</td>\n",
       "      <td>26.2</td>\n",
       "      <td>New Haven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482</th>\n",
       "      <td>2008</td>\n",
       "      <td>22.0</td>\n",
       "      <td>New London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1488</th>\n",
       "      <td>2008</td>\n",
       "      <td>6.6</td>\n",
       "      <td>Tolland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>2008</td>\n",
       "      <td>27.1</td>\n",
       "      <td>Windham</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Timeframe  Numeric Value      Locale\n",
       "12        2014            9.3   Fairfield\n",
       "18        2014           14.8    Hartford\n",
       "24        2014            7.9  Litchfield\n",
       "30        2014            6.6   Middlesex\n",
       "36        2014           14.5   New Haven\n",
       "42        2014           10.3  New London\n",
       "48        2014            3.7     Tolland\n",
       "54        2014           12.0     Windham\n",
       "252       2013           11.1   Fairfield\n",
       "258       2013           14.8    Hartford\n",
       "264       2013            7.1  Litchfield\n",
       "270       2013            6.8   Middlesex\n",
       "276       2013           17.4   New Haven\n",
       "282       2013           13.2  New London\n",
       "288       2013            3.6     Tolland\n",
       "294       2013           14.4     Windham\n",
       "492       2012           11.8   Fairfield\n",
       "498       2012           20.0    Hartford\n",
       "504       2012            9.5  Litchfield\n",
       "510       2012            6.9   Middlesex\n",
       "516       2012           17.9   New Haven\n",
       "522       2012           15.1  New London\n",
       "528       2012            4.4     Tolland\n",
       "534       2012           22.4     Windham\n",
       "732       2011           14.3   Fairfield\n",
       "738       2011           20.6    Hartford\n",
       "744       2011           10.3  Litchfield\n",
       "750       2011            9.4   Middlesex\n",
       "756       2011           18.5   New Haven\n",
       "762       2011           17.4  New London\n",
       "768       2011            5.1     Tolland\n",
       "774       2011           21.2     Windham\n",
       "972       2010           15.4   Fairfield\n",
       "978       2010           24.7    Hartford\n",
       "984       2010           11.2  Litchfield\n",
       "990       2010           10.8   Middlesex\n",
       "996       2010           21.1   New Haven\n",
       "1002      2010           18.6  New London\n",
       "1008      2010            6.1     Tolland\n",
       "1014      2010           21.4     Windham\n",
       "1212      2009           17.3   Fairfield\n",
       "1218      2009           27.7    Hartford\n",
       "1224      2009           11.3  Litchfield\n",
       "1230      2009           10.2   Middlesex\n",
       "1236      2009           24.7   New Haven\n",
       "1242      2009           22.3  New London\n",
       "1248      2009            7.8     Tolland\n",
       "1254      2009           23.4     Windham\n",
       "1452      2008           19.1   Fairfield\n",
       "1458      2008           29.4    Hartford\n",
       "1464      2008           12.8  Litchfield\n",
       "1470      2008           11.7   Middlesex\n",
       "1476      2008           26.2   New Haven\n",
       "1482      2008           22.0  New London\n",
       "1488      2008            6.6     Tolland\n",
       "1494      2008           27.1     Windham"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "county_year = inventory[inventory[\"Locale\"].str.contains(\"-\") \n",
    "          & ~(inventory[\"Timeframe\"].str.contains(\"-\"))\n",
    "          & (inventory[\"Dimension List\"] == \"Total\")][[\"Timeframe\",\"Numeric Value\",\"Locale\"]]\n",
    "county_year[\"Numeric Value\"] = pd.to_numeric(county_year[\"Numeric Value\"])\n",
    "county_year[\"Locale\"] = county_year[\"Locale\"].apply(lambda x: x.replace(\"Connecticut - \",\"\"))\n",
    "county_year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Locale</th>\n",
       "      <th>Fairfield</th>\n",
       "      <th>Hartford</th>\n",
       "      <th>Litchfield</th>\n",
       "      <th>Middlesex</th>\n",
       "      <th>New Haven</th>\n",
       "      <th>New London</th>\n",
       "      <th>Tolland</th>\n",
       "      <th>Windham</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Timeframe</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>19.1</td>\n",
       "      <td>29.4</td>\n",
       "      <td>12.8</td>\n",
       "      <td>11.7</td>\n",
       "      <td>26.2</td>\n",
       "      <td>22.0</td>\n",
       "      <td>6.6</td>\n",
       "      <td>27.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>17.3</td>\n",
       "      <td>27.7</td>\n",
       "      <td>11.3</td>\n",
       "      <td>10.2</td>\n",
       "      <td>24.7</td>\n",
       "      <td>22.3</td>\n",
       "      <td>7.8</td>\n",
       "      <td>23.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>15.4</td>\n",
       "      <td>24.7</td>\n",
       "      <td>11.2</td>\n",
       "      <td>10.8</td>\n",
       "      <td>21.1</td>\n",
       "      <td>18.6</td>\n",
       "      <td>6.1</td>\n",
       "      <td>21.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>14.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>10.3</td>\n",
       "      <td>9.4</td>\n",
       "      <td>18.5</td>\n",
       "      <td>17.4</td>\n",
       "      <td>5.1</td>\n",
       "      <td>21.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>11.8</td>\n",
       "      <td>20.0</td>\n",
       "      <td>9.5</td>\n",
       "      <td>6.9</td>\n",
       "      <td>17.9</td>\n",
       "      <td>15.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>22.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>11.1</td>\n",
       "      <td>14.8</td>\n",
       "      <td>7.1</td>\n",
       "      <td>6.8</td>\n",
       "      <td>17.4</td>\n",
       "      <td>13.2</td>\n",
       "      <td>3.6</td>\n",
       "      <td>14.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>9.3</td>\n",
       "      <td>14.8</td>\n",
       "      <td>7.9</td>\n",
       "      <td>6.6</td>\n",
       "      <td>14.5</td>\n",
       "      <td>10.3</td>\n",
       "      <td>3.7</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Locale     Fairfield  Hartford  Litchfield  Middlesex  New Haven  New London  \\\n",
       "Timeframe                                                                      \n",
       "2008            19.1      29.4        12.8       11.7       26.2        22.0   \n",
       "2009            17.3      27.7        11.3       10.2       24.7        22.3   \n",
       "2010            15.4      24.7        11.2       10.8       21.1        18.6   \n",
       "2011            14.3      20.6        10.3        9.4       18.5        17.4   \n",
       "2012            11.8      20.0         9.5        6.9       17.9        15.1   \n",
       "2013            11.1      14.8         7.1        6.8       17.4        13.2   \n",
       "2014             9.3      14.8         7.9        6.6       14.5        10.3   \n",
       "\n",
       "Locale     Tolland  Windham  \n",
       "Timeframe                    \n",
       "2008           6.6     27.1  \n",
       "2009           7.8     23.4  \n",
       "2010           6.1     21.4  \n",
       "2011           5.1     21.2  \n",
       "2012           4.4     22.4  \n",
       "2013           3.6     14.4  \n",
       "2014           3.7     12.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.pivot_table(county_year,index=\"Locale\",\n",
    "               columns=\"Timeframe\",\n",
    "               values=\"Numeric Value\").transpose()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Locale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>5.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>19.7</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 15-17 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>17.1</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>52.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 15-17 years; Non-Hispanic White (Of mother)</td>\n",
       "      <td>DSU</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 18-19 years; Non-Hispanic White (Of mother)</td>\n",
       "      <td>DSU</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 15-17 years; Non-Hispanic Black (Of mother)</td>\n",
       "      <td>DSU</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014</td>\n",
       "      <td>Aged 18-19 years; Non-Hispanic Black (Of mother)</td>\n",
       "      <td>DSU</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>31.4</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>DSU</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>DSU</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>6.2</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 15-17 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>19.9</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>62.1</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 15-17 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 18-19 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>9.6</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 15-17 years; Black or African American, n...</td>\n",
       "      <td>9.7</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>2013</td>\n",
       "      <td>Aged 18-19 years; Black or African American, n...</td>\n",
       "      <td>37.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>2013</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>37.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>2013</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>5.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>2013</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>21.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>7.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>25.7</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 15-17 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>23.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 15-17 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>2.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 18-19 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>12.4</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 15-17 years; Black or African American, n...</td>\n",
       "      <td>12.1</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>2012</td>\n",
       "      <td>Aged 18-19 years; Black or African American, n...</td>\n",
       "      <td>41.8</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>2010</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>89.8</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>2010</td>\n",
       "      <td>Aged 15-17 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>2010</td>\n",
       "      <td>Aged 18-19 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>15.8</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967</th>\n",
       "      <td>2010</td>\n",
       "      <td>Aged 15-17 years; Black or African American, n...</td>\n",
       "      <td>15.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>2010</td>\n",
       "      <td>Aged 18-19 years; Black or African American, n...</td>\n",
       "      <td>55.2</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>2010</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>51.9</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>2010</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>7.9</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>2010</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1201</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>10.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1202</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>37.9</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1203</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 15-17 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>33.8</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1204</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>98.8</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1205</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 15-17 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>3.2</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1206</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 18-19 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1207</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 15-17 years; Black or African American, n...</td>\n",
       "      <td>18.8</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1208</th>\n",
       "      <td>2009</td>\n",
       "      <td>Aged 18-19 years; Black or African American, n...</td>\n",
       "      <td>62.7</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1209</th>\n",
       "      <td>2009</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>60.1</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1210</th>\n",
       "      <td>2009</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>8.9</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1211</th>\n",
       "      <td>2009</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>37.0</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1441</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 15-17 years (Of mother)</td>\n",
       "      <td>11.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1442</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 18-19 years (Of mother)</td>\n",
       "      <td>40.1</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1443</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 15-17 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>38.5</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 18-19 years; Hispanic or Latino (Of mother)</td>\n",
       "      <td>109.3</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1445</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 15-17 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>3.6</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1446</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 18-19 years; White, non-Hispanic (Of mother)</td>\n",
       "      <td>18.1</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1447</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 15-17 years; Black or African American, n...</td>\n",
       "      <td>19.4</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1448</th>\n",
       "      <td>2008</td>\n",
       "      <td>Aged 18-19 years; Black or African American, n...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1449</th>\n",
       "      <td>2008</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>66.4</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1450</th>\n",
       "      <td>2008</td>\n",
       "      <td>White, non-Hispanic (Of mother)</td>\n",
       "      <td>9.2</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1451</th>\n",
       "      <td>2008</td>\n",
       "      <td>Black or African American, non-Hispanic (Of mo...</td>\n",
       "      <td>40.9</td>\n",
       "      <td>Connecticut</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>77 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Timeframe                                     Dimension List  \\\n",
       "1         2014                       Aged 15-17 years (Of mother)   \n",
       "2         2014                       Aged 18-19 years (Of mother)   \n",
       "3         2014   Aged 15-17 years; Hispanic or Latino (Of mother)   \n",
       "4         2014   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "5         2014   Aged 15-17 years; Non-Hispanic White (Of mother)   \n",
       "6         2014   Aged 18-19 years; Non-Hispanic White (Of mother)   \n",
       "7         2014   Aged 15-17 years; Non-Hispanic Black (Of mother)   \n",
       "8         2014   Aged 18-19 years; Non-Hispanic Black (Of mother)   \n",
       "9         2014                     Hispanic or Latino (Of mother)   \n",
       "10        2014                     Non-Hispanic White (Of mother)   \n",
       "11        2014                     Non-Hispanic Black (Of mother)   \n",
       "241       2013                       Aged 15-17 years (Of mother)   \n",
       "242       2013                       Aged 18-19 years (Of mother)   \n",
       "243       2013   Aged 15-17 years; Hispanic or Latino (Of mother)   \n",
       "244       2013   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "245       2013  Aged 15-17 years; White, non-Hispanic (Of mother)   \n",
       "246       2013  Aged 18-19 years; White, non-Hispanic (Of mother)   \n",
       "247       2013  Aged 15-17 years; Black or African American, n...   \n",
       "248       2013  Aged 18-19 years; Black or African American, n...   \n",
       "249       2013                     Hispanic or Latino (Of mother)   \n",
       "250       2013                    White, non-Hispanic (Of mother)   \n",
       "251       2013  Black or African American, non-Hispanic (Of mo...   \n",
       "481       2012                       Aged 15-17 years (Of mother)   \n",
       "482       2012                       Aged 18-19 years (Of mother)   \n",
       "483       2012   Aged 15-17 years; Hispanic or Latino (Of mother)   \n",
       "484       2012   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "485       2012  Aged 15-17 years; White, non-Hispanic (Of mother)   \n",
       "486       2012  Aged 18-19 years; White, non-Hispanic (Of mother)   \n",
       "487       2012  Aged 15-17 years; Black or African American, n...   \n",
       "488       2012  Aged 18-19 years; Black or African American, n...   \n",
       "...        ...                                                ...   \n",
       "964       2010   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "965       2010  Aged 15-17 years; White, non-Hispanic (Of mother)   \n",
       "966       2010  Aged 18-19 years; White, non-Hispanic (Of mother)   \n",
       "967       2010  Aged 15-17 years; Black or African American, n...   \n",
       "968       2010  Aged 18-19 years; Black or African American, n...   \n",
       "969       2010                     Hispanic or Latino (Of mother)   \n",
       "970       2010                    White, non-Hispanic (Of mother)   \n",
       "971       2010  Black or African American, non-Hispanic (Of mo...   \n",
       "1201      2009                       Aged 15-17 years (Of mother)   \n",
       "1202      2009                       Aged 18-19 years (Of mother)   \n",
       "1203      2009   Aged 15-17 years; Hispanic or Latino (Of mother)   \n",
       "1204      2009   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "1205      2009  Aged 15-17 years; White, non-Hispanic (Of mother)   \n",
       "1206      2009  Aged 18-19 years; White, non-Hispanic (Of mother)   \n",
       "1207      2009  Aged 15-17 years; Black or African American, n...   \n",
       "1208      2009  Aged 18-19 years; Black or African American, n...   \n",
       "1209      2009                     Hispanic or Latino (Of mother)   \n",
       "1210      2009                    White, non-Hispanic (Of mother)   \n",
       "1211      2009  Black or African American, non-Hispanic (Of mo...   \n",
       "1441      2008                       Aged 15-17 years (Of mother)   \n",
       "1442      2008                       Aged 18-19 years (Of mother)   \n",
       "1443      2008   Aged 15-17 years; Hispanic or Latino (Of mother)   \n",
       "1444      2008   Aged 18-19 years; Hispanic or Latino (Of mother)   \n",
       "1445      2008  Aged 15-17 years; White, non-Hispanic (Of mother)   \n",
       "1446      2008  Aged 18-19 years; White, non-Hispanic (Of mother)   \n",
       "1447      2008  Aged 15-17 years; Black or African American, n...   \n",
       "1448      2008  Aged 18-19 years; Black or African American, n...   \n",
       "1449      2008                     Hispanic or Latino (Of mother)   \n",
       "1450      2008                    White, non-Hispanic (Of mother)   \n",
       "1451      2008  Black or African American, non-Hispanic (Of mo...   \n",
       "\n",
       "     Numeric Value       Locale  \n",
       "1              5.5  Connecticut  \n",
       "2             19.7  Connecticut  \n",
       "3             17.1  Connecticut  \n",
       "4             52.5  Connecticut  \n",
       "5              DSU  Connecticut  \n",
       "6              DSU  Connecticut  \n",
       "7              DSU  Connecticut  \n",
       "8              DSU  Connecticut  \n",
       "9             31.4  Connecticut  \n",
       "10             DSU  Connecticut  \n",
       "11             DSU  Connecticut  \n",
       "241            6.2  Connecticut  \n",
       "242           22.0  Connecticut  \n",
       "243           19.9  Connecticut  \n",
       "244           62.1  Connecticut  \n",
       "245            2.0  Connecticut  \n",
       "246            9.6  Connecticut  \n",
       "247            9.7  Connecticut  \n",
       "248           37.5  Connecticut  \n",
       "249           37.3  Connecticut  \n",
       "250            5.3  Connecticut  \n",
       "251           21.5  Connecticut  \n",
       "481            7.3  Connecticut  \n",
       "482           25.7  Connecticut  \n",
       "483           23.3  Connecticut  \n",
       "484           70.0  Connecticut  \n",
       "485            2.5  Connecticut  \n",
       "486           12.4  Connecticut  \n",
       "487           12.1  Connecticut  \n",
       "488           41.8  Connecticut  \n",
       "...            ...          ...  \n",
       "964           89.8  Connecticut  \n",
       "965            3.0  Connecticut  \n",
       "966           15.8  Connecticut  \n",
       "967           15.5  Connecticut  \n",
       "968           55.2  Connecticut  \n",
       "969           51.9  Connecticut  \n",
       "970            7.9  Connecticut  \n",
       "971           32.0  Connecticut  \n",
       "1201          10.3  Connecticut  \n",
       "1202          37.9  Connecticut  \n",
       "1203          33.8  Connecticut  \n",
       "1204          98.8  Connecticut  \n",
       "1205           3.2  Connecticut  \n",
       "1206          18.0  Connecticut  \n",
       "1207          18.8  Connecticut  \n",
       "1208          62.7  Connecticut  \n",
       "1209          60.1  Connecticut  \n",
       "1210           8.9  Connecticut  \n",
       "1211          37.0  Connecticut  \n",
       "1441          11.3  Connecticut  \n",
       "1442          40.1  Connecticut  \n",
       "1443          38.5  Connecticut  \n",
       "1444         109.3  Connecticut  \n",
       "1445           3.6  Connecticut  \n",
       "1446          18.1  Connecticut  \n",
       "1447          19.4  Connecticut  \n",
       "1448          71.7  Connecticut  \n",
       "1449          66.4  Connecticut  \n",
       "1450           9.2  Connecticut  \n",
       "1451          40.9  Connecticut  \n",
       "\n",
       "[77 rows x 4 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_statewie_data(by_demographics=False):\n",
    "    if by_demographics:\n",
    "        return inventory[~(inventory[\"Locale\"].str.contains(\"-\"))\n",
    "                         & ~(inventory[\"Timeframe\"].str.contains(\"-\"))\n",
    "                         & ~(inventory[\"Dimension List\"] == \"Total\")][[\"Timeframe\",\n",
    "                                                                       \"Dimension List\",\n",
    "                                                                       \"Numeric Value\",\"Locale\"]]    \n",
    "    else:\n",
    "        return inventory[inventory[\"Locale\"].str.contains(\"-\")\n",
    "                         & ~(inventory[\"Timeframe\"].str.contains(\"-\"))\n",
    "                         & (inventory[\"Dimension List\"] == \"Total\")][[\"Timeframe\",\"Numeric Value\",\"Locale\"]]\n",
    "\n",
    "\n",
    "def get_data(by_demographics=False):\n",
    "    if by_demographics:\n",
    "        return inventory[inventory[\"Locale\"].str.contains(\"-\")\n",
    "                         & ~(inventory[\"Timeframe\"].str.contains(\"-\"))\n",
    "                         & ~(inventory[\"Dimension List\"] == \"Total\")][[\"Timeframe\",\n",
    "                                                                       \"Dimension List\",\n",
    "                                                                       \"Numeric Value\",\"Locale\"]]    \n",
    "    else:\n",
    "        return inventory[inventory[\"Locale\"].str.contains(\"-\")\n",
    "                         & ~(inventory[\"Timeframe\"].str.contains(\"-\"))\n",
    "                         & (inventory[\"Dimension List\"] == \"Total\")][[\"Timeframe\",\"Numeric Value\",\"Locale\"]]\n",
    "    \n",
    "get_statewie_data(by_demographics=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Dimension List</th>\n",
       "      <th>Black or African American, non-Hispanic (Of mother)</th>\n",
       "      <th>Hispanic or Latino (Of mother)</th>\n",
       "      <th>Non-Hispanic Black (Of mother)</th>\n",
       "      <th>Non-Hispanic White (Of mother)</th>\n",
       "      <th>White, non-Hispanic (Of mother)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Timeframe</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>40.9</td>\n",
       "      <td>66.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>37.0</td>\n",
       "      <td>60.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>32.0</td>\n",
       "      <td>51.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>29.8</td>\n",
       "      <td>47.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>24.8</td>\n",
       "      <td>42.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>21.5</td>\n",
       "      <td>37.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>NaN</td>\n",
       "      <td>31.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Dimension List  Black or African American, non-Hispanic (Of mother)  \\\n",
       "Timeframe                                                             \n",
       "2008                                                         40.9     \n",
       "2009                                                         37.0     \n",
       "2010                                                         32.0     \n",
       "2011                                                         29.8     \n",
       "2012                                                         24.8     \n",
       "2013                                                         21.5     \n",
       "2014                                                          NaN     \n",
       "\n",
       "Dimension List  Hispanic or Latino (Of mother)  \\\n",
       "Timeframe                                        \n",
       "2008                                      66.4   \n",
       "2009                                      60.1   \n",
       "2010                                      51.9   \n",
       "2011                                      47.0   \n",
       "2012                                      42.6   \n",
       "2013                                      37.3   \n",
       "2014                                      31.4   \n",
       "\n",
       "Dimension List  Non-Hispanic Black (Of mother)  \\\n",
       "Timeframe                                        \n",
       "2008                                       NaN   \n",
       "2009                                       NaN   \n",
       "2010                                       NaN   \n",
       "2011                                       NaN   \n",
       "2012                                       NaN   \n",
       "2013                                       NaN   \n",
       "2014                                       NaN   \n",
       "\n",
       "Dimension List  Non-Hispanic White (Of mother)  \\\n",
       "Timeframe                                        \n",
       "2008                                       NaN   \n",
       "2009                                       NaN   \n",
       "2010                                       NaN   \n",
       "2011                                       NaN   \n",
       "2012                                       NaN   \n",
       "2013                                       NaN   \n",
       "2014                                       NaN   \n",
       "\n",
       "Dimension List  White, non-Hispanic (Of mother)  \n",
       "Timeframe                                        \n",
       "2008                                        9.2  \n",
       "2009                                        8.9  \n",
       "2010                                        7.9  \n",
       "2011                                        6.4  \n",
       "2012                                        6.7  \n",
       "2013                                        5.3  \n",
       "2014                                        NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demographics_county = get_statewie_data(by_demographics=True)\n",
    "demographics_county[\"Numeric Value\"] = pd.to_numeric(demographics_county[\"Numeric Value\"],errors=\"coerce\")\n",
    "\n",
    "\n",
    "race = demographics_county[~demographics_county[\"Dimension List\"].str.contains(\"Aged\")]\n",
    "race = pd.pivot_table(race,index=\"Dimension List\",\n",
    "               columns=\"Timeframe\",\n",
    "               values=\"Numeric Value\").transpose()\n",
    "race"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Dimension List</th>\n",
       "      <th>Aged 15-17 years (Of mother)</th>\n",
       "      <th>Aged 15-17 years; Black or African American, non-Hispanic (Of mother)</th>\n",
       "      <th>Aged 15-17 years; Hispanic or Latino (Of mother)</th>\n",
       "      <th>Aged 15-17 years; Non-Hispanic Black (Of mother)</th>\n",
       "      <th>Aged 15-17 years; Non-Hispanic White (Of mother)</th>\n",
       "      <th>Aged 15-17 years; White, non-Hispanic (Of mother)</th>\n",
       "      <th>Aged 18-19 years (Of mother)</th>\n",
       "      <th>Aged 18-19 years; Black or African American, non-Hispanic (Of mother)</th>\n",
       "      <th>Aged 18-19 years; Hispanic or Latino (Of mother)</th>\n",
       "      <th>Aged 18-19 years; Non-Hispanic Black (Of mother)</th>\n",
       "      <th>Aged 18-19 years; Non-Hispanic White (Of mother)</th>\n",
       "      <th>Aged 18-19 years; White, non-Hispanic (Of mother)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Timeframe</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>11.3</td>\n",
       "      <td>19.4</td>\n",
       "      <td>38.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.6</td>\n",
       "      <td>40.1</td>\n",
       "      <td>71.7</td>\n",
       "      <td>109.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>10.3</td>\n",
       "      <td>18.8</td>\n",
       "      <td>33.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.2</td>\n",
       "      <td>37.9</td>\n",
       "      <td>62.7</td>\n",
       "      <td>98.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>8.4</td>\n",
       "      <td>15.5</td>\n",
       "      <td>25.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>34.5</td>\n",
       "      <td>55.2</td>\n",
       "      <td>89.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>7.3</td>\n",
       "      <td>14.6</td>\n",
       "      <td>22.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.4</td>\n",
       "      <td>29.4</td>\n",
       "      <td>50.6</td>\n",
       "      <td>82.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>7.3</td>\n",
       "      <td>12.1</td>\n",
       "      <td>23.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.5</td>\n",
       "      <td>25.7</td>\n",
       "      <td>41.8</td>\n",
       "      <td>70.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>6.2</td>\n",
       "      <td>9.7</td>\n",
       "      <td>19.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>37.5</td>\n",
       "      <td>62.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>5.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>52.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Dimension List  Aged 15-17 years (Of mother)  \\\n",
       "Timeframe                                      \n",
       "2008                                    11.3   \n",
       "2009                                    10.3   \n",
       "2010                                     8.4   \n",
       "2011                                     7.3   \n",
       "2012                                     7.3   \n",
       "2013                                     6.2   \n",
       "2014                                     5.5   \n",
       "\n",
       "Dimension List  Aged 15-17 years; Black or African American, non-Hispanic (Of mother)  \\\n",
       "Timeframe                                                                               \n",
       "2008                                                         19.4                       \n",
       "2009                                                         18.8                       \n",
       "2010                                                         15.5                       \n",
       "2011                                                         14.6                       \n",
       "2012                                                         12.1                       \n",
       "2013                                                          9.7                       \n",
       "2014                                                          NaN                       \n",
       "\n",
       "Dimension List  Aged 15-17 years; Hispanic or Latino (Of mother)  \\\n",
       "Timeframe                                                          \n",
       "2008                                                        38.5   \n",
       "2009                                                        33.8   \n",
       "2010                                                        25.6   \n",
       "2011                                                        22.4   \n",
       "2012                                                        23.3   \n",
       "2013                                                        19.9   \n",
       "2014                                                        17.1   \n",
       "\n",
       "Dimension List  Aged 15-17 years; Non-Hispanic Black (Of mother)  \\\n",
       "Timeframe                                                          \n",
       "2008                                                         NaN   \n",
       "2009                                                         NaN   \n",
       "2010                                                         NaN   \n",
       "2011                                                         NaN   \n",
       "2012                                                         NaN   \n",
       "2013                                                         NaN   \n",
       "2014                                                         NaN   \n",
       "\n",
       "Dimension List  Aged 15-17 years; Non-Hispanic White (Of mother)  \\\n",
       "Timeframe                                                          \n",
       "2008                                                         NaN   \n",
       "2009                                                         NaN   \n",
       "2010                                                         NaN   \n",
       "2011                                                         NaN   \n",
       "2012                                                         NaN   \n",
       "2013                                                         NaN   \n",
       "2014                                                         NaN   \n",
       "\n",
       "Dimension List  Aged 15-17 years; White, non-Hispanic (Of mother)  \\\n",
       "Timeframe                                                           \n",
       "2008                                                          3.6   \n",
       "2009                                                          3.2   \n",
       "2010                                                          3.0   \n",
       "2011                                                          2.4   \n",
       "2012                                                          2.5   \n",
       "2013                                                          2.0   \n",
       "2014                                                          NaN   \n",
       "\n",
       "Dimension List  Aged 18-19 years (Of mother)  \\\n",
       "Timeframe                                      \n",
       "2008                                    40.1   \n",
       "2009                                    37.9   \n",
       "2010                                    34.5   \n",
       "2011                                    29.4   \n",
       "2012                                    25.7   \n",
       "2013                                    22.0   \n",
       "2014                                    19.7   \n",
       "\n",
       "Dimension List  Aged 18-19 years; Black or African American, non-Hispanic (Of mother)  \\\n",
       "Timeframe                                                                               \n",
       "2008                                                         71.7                       \n",
       "2009                                                         62.7                       \n",
       "2010                                                         55.2                       \n",
       "2011                                                         50.6                       \n",
       "2012                                                         41.8                       \n",
       "2013                                                         37.5                       \n",
       "2014                                                          NaN                       \n",
       "\n",
       "Dimension List  Aged 18-19 years; Hispanic or Latino (Of mother)  \\\n",
       "Timeframe                                                          \n",
       "2008                                                       109.3   \n",
       "2009                                                        98.8   \n",
       "2010                                                        89.8   \n",
       "2011                                                        82.0   \n",
       "2012                                                        70.0   \n",
       "2013                                                        62.1   \n",
       "2014                                                        52.5   \n",
       "\n",
       "Dimension List  Aged 18-19 years; Non-Hispanic Black (Of mother)  \\\n",
       "Timeframe                                                          \n",
       "2008                                                         NaN   \n",
       "2009                                                         NaN   \n",
       "2010                                                         NaN   \n",
       "2011                                                         NaN   \n",
       "2012                                                         NaN   \n",
       "2013                                                         NaN   \n",
       "2014                                                         NaN   \n",
       "\n",
       "Dimension List  Aged 18-19 years; Non-Hispanic White (Of mother)  \\\n",
       "Timeframe                                                          \n",
       "2008                                                         NaN   \n",
       "2009                                                         NaN   \n",
       "2010                                                         NaN   \n",
       "2011                                                         NaN   \n",
       "2012                                                         NaN   \n",
       "2013                                                         NaN   \n",
       "2014                                                         NaN   \n",
       "\n",
       "Dimension List  Aged 18-19 years; White, non-Hispanic (Of mother)  \n",
       "Timeframe                                                          \n",
       "2008                                                         18.1  \n",
       "2009                                                         18.0  \n",
       "2010                                                         15.8  \n",
       "2011                                                         12.2  \n",
       "2012                                                         12.4  \n",
       "2013                                                          9.6  \n",
       "2014                                                          NaN  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "age = demographics_county[demographics_county[\"Dimension List\"].str.contains(\"Aged\")]\n",
    "age = pd.pivot_table(age,\n",
    "                     index=\"Dimension List\",\n",
    "                     columns=\"Timeframe\",\n",
    "                     values=\"Numeric Value\").transpose()\n",
    "age"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# It looks like a lot of 2014 data are missing\n",
    "\n",
    "2014 race data only exists for \n",
    "Aged 15-17 (without race/eth)\n",
    "Aged 18-19 (without race/eth)\n",
    "\n",
    "Aged 15-17 hispanic\n",
    "Aged 18-19 hispanic\n",
    "\n",
    "Hispanic (without age)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Indicator ID</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Missing Value Flag</th>\n",
       "      <th>Confidence Interval Low</th>\n",
       "      <th>Confidence Interval High</th>\n",
       "      <th>Standard Error</th>\n",
       "      <th>LocaleID</th>\n",
       "      <th>Locale</th>\n",
       "      <th>...</th>\n",
       "      <th>Characteristic Of School Or Student</th>\n",
       "      <th>Other</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Modifier1</th>\n",
       "      <th>Modifier2</th>\n",
       "      <th>Modifier3</th>\n",
       "      <th>Modifier4</th>\n",
       "      <th>Modifier5</th>\n",
       "      <th>Numerator</th>\n",
       "      <th>Denominator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>416487306</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>9.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>10.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>307.0</td>\n",
       "      <td>32927.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>416487309</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>27.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.7</td>\n",
       "      <td>31.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186.0</td>\n",
       "      <td>6725.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>416487310</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20589.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>416487311</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>409</td>\n",
       "      <td>Connecticut - Fairfield</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4098.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Indicator ID                  Dimension List Timeframe Numeric Value  \\\n",
       "12     416487306                           Total      2014           9.3   \n",
       "15     416487309  Hispanic or Latino (Of mother)      2014          27.7   \n",
       "16     416487310  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "17     416487311  Non-Hispanic Black (Of mother)      2014           DSU   \n",
       "\n",
       "   Missing Value Flag  Confidence Interval Low  Confidence Interval High  \\\n",
       "12                NaN                      8.3                      10.4   \n",
       "15                NaN                     23.7                      31.6   \n",
       "16                DSU                      NaN                       NaN   \n",
       "17                DSU                      NaN                       NaN   \n",
       "\n",
       "    Standard Error  LocaleID                   Locale     ...       \\\n",
       "12             0.5       409  Connecticut - Fairfield     ...        \n",
       "15             2.0       409  Connecticut - Fairfield     ...        \n",
       "16             NaN       409  Connecticut - Fairfield     ...        \n",
       "17             NaN       409  Connecticut - Fairfield     ...        \n",
       "\n",
       "   Characteristic Of School Or Student  Other  Geography    Modifier1  \\\n",
       "12                                 NaN    NaN        NaN          NaN   \n",
       "15                                 NaN    NaN        NaN  (Of mother)   \n",
       "16                                 NaN    NaN        NaN  (Of mother)   \n",
       "17                                 NaN    NaN        NaN  (Of mother)   \n",
       "\n",
       "    Modifier2 Modifier3 Modifier4  Modifier5 Numerator  Denominator  \n",
       "12        NaN       NaN       NaN        NaN     307.0      32927.0  \n",
       "15        NaN       NaN       NaN        NaN     186.0       6725.0  \n",
       "16        NaN       NaN       NaN        NaN       NaN      20589.0  \n",
       "17        NaN       NaN       NaN        NaN       NaN       4098.0  \n",
       "\n",
       "[4 rows x 39 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def county_data(county):\n",
    "    return inventory[inventory[\"Locale\"].str.contains(county) \n",
    "                     & ~inventory[\"Dimension List\"].str.contains(\"Aged\")\n",
    "                     & ~inventory[\"Timeframe\"].str.contains(\"-\")\n",
    "                     & (inventory[\"Timeframe\"] == \"2014\")]\n",
    "\n",
    "county_data(\"Fairfield\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Connecticut                 336\n",
       "Connecticut - Middlesex     168\n",
       "Connecticut - New Haven     168\n",
       "Connecticut - Fairfield     168\n",
       "Connecticut - Tolland       168\n",
       "Connecticut - New London    168\n",
       "Connecticut - Litchfield    168\n",
       "Connecticut - Hartford      168\n",
       "Connecticut - Windham       168\n",
       "Name: Locale, dtype: int64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inventory[\"Locale\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Indicator ID</th>\n",
       "      <th>Dimension List</th>\n",
       "      <th>Timeframe</th>\n",
       "      <th>Numeric Value</th>\n",
       "      <th>Missing Value Flag</th>\n",
       "      <th>Confidence Interval Low</th>\n",
       "      <th>Confidence Interval High</th>\n",
       "      <th>Standard Error</th>\n",
       "      <th>LocaleID</th>\n",
       "      <th>Locale</th>\n",
       "      <th>...</th>\n",
       "      <th>Characteristic Of School Or Student</th>\n",
       "      <th>Other</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Modifier1</th>\n",
       "      <th>Modifier2</th>\n",
       "      <th>Modifier3</th>\n",
       "      <th>Modifier4</th>\n",
       "      <th>Modifier5</th>\n",
       "      <th>Numerator</th>\n",
       "      <th>Denominator</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>416487348</td>\n",
       "      <td>Total</td>\n",
       "      <td>2014</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.9</td>\n",
       "      <td>15.9</td>\n",
       "      <td>1.7</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>3995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>416487351</td>\n",
       "      <td>Hispanic or Latino (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>581.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>416487352</td>\n",
       "      <td>Non-Hispanic White (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3144.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>416487353</td>\n",
       "      <td>Non-Hispanic Black (Of mother)</td>\n",
       "      <td>2014</td>\n",
       "      <td>DSU</td>\n",
       "      <td>DSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>416</td>\n",
       "      <td>Connecticut - Windham</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(Of mother)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>140.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Indicator ID                  Dimension List Timeframe Numeric Value  \\\n",
       "54     416487348                           Total      2014          12.0   \n",
       "57     416487351  Hispanic or Latino (Of mother)      2014           DSU   \n",
       "58     416487352  Non-Hispanic White (Of mother)      2014           DSU   \n",
       "59     416487353  Non-Hispanic Black (Of mother)      2014           DSU   \n",
       "\n",
       "   Missing Value Flag  Confidence Interval Low  Confidence Interval High  \\\n",
       "54                NaN                      8.9                      15.9   \n",
       "57                DSU                      NaN                       NaN   \n",
       "58                DSU                      NaN                       NaN   \n",
       "59                DSU                      NaN                       NaN   \n",
       "\n",
       "    Standard Error  LocaleID                 Locale     ...       \\\n",
       "54             1.7       416  Connecticut - Windham     ...        \n",
       "57             NaN       416  Connecticut - Windham     ...        \n",
       "58             NaN       416  Connecticut - Windham     ...        \n",
       "59             NaN       416  Connecticut - Windham     ...        \n",
       "\n",
       "   Characteristic Of School Or Student  Other  Geography    Modifier1  \\\n",
       "54                                 NaN    NaN        NaN          NaN   \n",
       "57                                 NaN    NaN        NaN  (Of mother)   \n",
       "58                                 NaN    NaN        NaN  (Of mother)   \n",
       "59                                 NaN    NaN        NaN  (Of mother)   \n",
       "\n",
       "    Modifier2 Modifier3 Modifier4  Modifier5 Numerator  Denominator  \n",
       "54        NaN       NaN       NaN        NaN      48.0       3995.0  \n",
       "57        NaN       NaN       NaN        NaN      13.0        581.0  \n",
       "58        NaN       NaN       NaN        NaN       NaN       3144.0  \n",
       "59        NaN       NaN       NaN        NaN       NaN        140.0  \n",
       "\n",
       "[4 rows x 39 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "county_data(\"Windham\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}