exploration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import geopandas as gpd\n",
    "import os\n",
    "import matplotlib.pyplot as plt\n",
    "import altair as alt\n",
    "from Utilities import Utils"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "byage = pd.read_csv(\"data\\\\USCS-1999-2018-ASCII\\\\BYAGE.TXT\", sep=\"|\", low_memory=False)\n",
    "by_county = pd.read_csv(\"data\\\\USCS-1999-2018-ASCII\\\\BYAREA_COUNTY.TXT\", sep=\"|\", low_memory=False)\n",
    "counties =  gpd.read_file(\"data\\\\2020_us_county_shp\\\\cb_2020_us_county_20m.shp\")\n",
    "\n",
    "geo = counties[counties[\"STUSPS\"] == \"NJ\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "byarea = pd.read_csv(\"data\\\\USCS-1999-2018-ASCII\\\\BYAREA.TXT\", sep=\"|\", low_memory=False)\n",
    "byarea = byarea[['AREA', 'AGE_ADJUSTED_RATE','EVENT_TYPE', 'RACE', 'SEX', 'SITE', 'YEAR']]\n",
    "byarea = byarea[byarea[\"YEAR\"] != '2014-2018']\n",
    "byarea = byarea[byarea[\"RACE\"] == \"All Races\"]\n",
    "byarea = byarea.astype({'YEAR': 'int', 'AREA':'object'})\n",
    "byarea = byarea[(byarea[\"SITE\"] == \"All Cancer Sites Combined\") & (byarea[\"SEX\"] == \"Male and Female\")]\n",
    "byarea = Utils.remove_rows(byarea, ['~', '+', '.', '-'])\n",
    "byarea = Utils.get_mir(byarea, ['AREA', 'RACE', 'SEX', 'SITE', 'YEAR'], 'AGE_ADJUSTED_RATE')\n",
    "byarea = byarea[[\"AREA\",\"YEAR\",\"MIR\"]]\n",
    "byarea = byarea.sort_values(['YEAR'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped = byarea.groupby(by=\"AREA\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "state_change = (grouped['MIR'].last() - grouped['MIR'].first())/grouped['MIR'].first()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Worst Improvement: New Mexico -0.02892027050256729\n",
      "Best improvement: Tennessee -0.3241981863975525\n"
     ]
    }
   ],
   "source": [
    "print(\"Worst Improvement: \" + str(state_change.idxmax()) + \" \" + str(state_change.max()))\n",
    "print(\"Best improvement: \" + str(state_change.idxmin()) + \" \" + str(state_change.min()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-56d459f378ed4ddfb06a91b07477f128\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-56d459f378ed4ddfb06a91b07477f128\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-56d459f378ed4ddfb06a91b07477f128\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"layer\": [{\"mark\": \"line\", \"encoding\": {\"color\": {\"value\": \"lightgray\"}, \"detail\": {\"type\": \"nominal\", \"field\": \"AREA\"}, \"tooltip\": {\"type\": \"nominal\", \"field\": \"AREA\"}, \"x\": {\"type\": \"quantitative\", \"field\": \"YEAR\", \"scale\": {\"domain\": [1999, 2018]}}, \"y\": {\"type\": \"quantitative\", \"field\": \"MIR\", \"scale\": {\"domain\": [0.275, 0.55]}}}}, {\"mark\": \"line\", \"encoding\": {\"color\": {\"type\": \"nominal\", \"field\": \"AREA\"}, \"detail\": {\"type\": \"nominal\", \"field\": \"AREA\"}, \"tooltip\": {\"type\": \"nominal\", \"field\": \"AREA\"}, \"x\": {\"type\": \"quantitative\", \"field\": \"YEAR\", \"scale\": {\"domain\": [1999, 2018]}}, \"y\": {\"type\": \"quantitative\", \"field\": \"MIR\", \"scale\": {\"domain\": [0.275, 0.55]}}}, \"selection\": {\"State\": {\"type\": \"single\", \"fields\": [\"AREA\"], \"bind\": {\"input\": \"select\", \"options\": [\"Alabama\", \"Alaska\", \"Arizona\", \"Arkansas\", \"California\", \"Colorado\", \"Connecticut\", \"Delaware\", \"District of Columbia\", \"Florida\", \"Georgia\", \"Hawaii\", \"Idaho\", \"Illinois\", \"Indiana\", \"Iowa\", \"Kansas\", \"Kentucky\", \"Louisiana\", \"Maine\", \"Maryland\", \"Massachusetts\", \"Michigan\", \"Minnesota\", \"Mississippi\", \"Missouri\", \"Montana\", \"Nebraska\", \"Nevada\", \"New Hampshire\", \"New Jersey\", \"New Mexico\", \"New York\", \"North Carolina\", \"North Dakota\", \"Ohio\", \"Oklahoma\", \"Oregon\", \"Pennsylvania\", \"Rhode Island\", \"South Carolina\", \"South Dakota\", \"Tennessee\", \"Texas\", \"Utah\", \"Vermont\", \"Virginia\", \"Washington\", \"West Virginia\", \"Wisconsin\", \"Wyoming\"]}}}, \"transform\": [{\"filter\": {\"selection\": \"State\"}}]}], \"data\": {\"name\": \"data-10e9b0b02feb0082cb52e48344f3505c\"}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-10e9b0b02feb0082cb52e48344f3505c\": [{\"AREA\": \"Alabama\", \"YEAR\": 1999, \"MIR\": 0.49576669931411743}, {\"AREA\": \"Oregon\", \"YEAR\": 1999, \"MIR\": 0.38908520340919495}, {\"AREA\": \"Louisiana\", \"YEAR\": 1999, \"MIR\": 0.46746402978897095}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 1999, \"MIR\": 0.4154397249221802}, {\"AREA\": \"Arizona\", \"YEAR\": 1999, \"MIR\": 0.42495864629745483}, {\"AREA\": \"Kentucky\", \"YEAR\": 1999, \"MIR\": 0.4315951466560364}, {\"AREA\": \"Kansas\", \"YEAR\": 1999, \"MIR\": 0.4084627032279968}, {\"AREA\": \"Rhode Island\", \"YEAR\": 1999, \"MIR\": 0.3879629671573639}, {\"AREA\": \"Iowa\", \"YEAR\": 1999, \"MIR\": 0.3851972818374634}, {\"AREA\": \"South Carolina\", \"YEAR\": 1999, \"MIR\": 0.4384043216705322}, {\"AREA\": \"New Hampshire\", \"YEAR\": 1999, \"MIR\": 0.41596895456314087}, {\"AREA\": \"Indiana\", \"YEAR\": 1999, \"MIR\": 0.4655098617076874}, {\"AREA\": \"Wisconsin\", \"YEAR\": 1999, \"MIR\": 0.39414143562316895}, {\"AREA\": \"Illinois\", \"YEAR\": 1999, \"MIR\": 0.4250202178955078}, {\"AREA\": \"Maine\", \"YEAR\": 1999, \"MIR\": 0.41973376274108887}, {\"AREA\": \"Idaho\", \"YEAR\": 1999, \"MIR\": 0.4183490574359894}, {\"AREA\": \"Hawaii\", \"YEAR\": 1999, \"MIR\": 0.3587628901004791}, {\"AREA\": \"Texas\", \"YEAR\": 1999, \"MIR\": 0.41918978095054626}, {\"AREA\": \"Georgia\", \"YEAR\": 1999, \"MIR\": 0.4543215334415436}, {\"AREA\": \"Utah\", \"YEAR\": 1999, \"MIR\": 0.3743097186088562}, {\"AREA\": \"Florida\", \"YEAR\": 1999, \"MIR\": 0.3700311481952667}, {\"AREA\": \"District of Columbia\", \"YEAR\": 1999, \"MIR\": 0.4493023157119751}, {\"AREA\": \"Vermont\", \"YEAR\": 1999, \"MIR\": 0.39523160457611084}, {\"AREA\": \"West Virginia\", \"YEAR\": 1999, \"MIR\": 0.44603458046913147}, {\"AREA\": \"California\", \"YEAR\": 1999, \"MIR\": 0.39669954776763916}, {\"AREA\": \"Delaware\", \"YEAR\": 1999, \"MIR\": 0.4438045918941498}, {\"AREA\": \"Virginia\", \"YEAR\": 1999, \"MIR\": 0.48149850964546204}, {\"AREA\": \"Connecticut\", \"YEAR\": 1999, \"MIR\": 0.36909371614456177}, {\"AREA\": \"Washington\", \"YEAR\": 1999, \"MIR\": 0.3833976984024048}, {\"AREA\": \"Tennessee\", \"YEAR\": 1999, \"MIR\": 0.5485773086547852}, {\"AREA\": \"Wyoming\", \"YEAR\": 1999, \"MIR\": 0.41368353366851807}, {\"AREA\": \"Colorado\", \"YEAR\": 1999, \"MIR\": 0.38203245401382446}, {\"AREA\": \"North Carolina\", \"YEAR\": 1999, \"MIR\": 0.4683687388896942}, {\"AREA\": \"New York\", \"YEAR\": 1999, \"MIR\": 0.3969280421733856}, {\"AREA\": \"Montana\", \"YEAR\": 1999, \"MIR\": 0.40036940574645996}, {\"AREA\": \"Minnesota\", \"YEAR\": 1999, \"MIR\": 0.4010729491710663}, {\"AREA\": \"North Dakota\", \"YEAR\": 1999, \"MIR\": 0.4029494822025299}, {\"AREA\": \"Alaska\", \"YEAR\": 1999, \"MIR\": 0.38277703523635864}, {\"AREA\": \"New Mexico\", \"YEAR\": 1999, \"MIR\": 0.40203800797462463}, {\"AREA\": \"Nebraska\", \"YEAR\": 1999, \"MIR\": 0.38830554485321045}, {\"AREA\": \"Michigan\", \"YEAR\": 1999, \"MIR\": 0.39220181107521057}, {\"AREA\": \"Ohio\", \"YEAR\": 1999, \"MIR\": 0.44041770696640015}, {\"AREA\": \"Missouri\", \"YEAR\": 1999, \"MIR\": 0.43454620242118835}, {\"AREA\": \"Massachusetts\", \"YEAR\": 1999, \"MIR\": 0.39961203932762146}, {\"AREA\": \"Oklahoma\", \"YEAR\": 1999, \"MIR\": 0.4516834616661072}, {\"AREA\": \"Maryland\", \"YEAR\": 1999, \"MIR\": 0.4206412732601166}, {\"AREA\": \"Nevada\", \"YEAR\": 1999, \"MIR\": 0.49323201179504395}, {\"AREA\": \"New Jersey\", \"YEAR\": 1999, \"MIR\": 0.3994269371032715}, {\"AREA\": \"New Jersey\", \"YEAR\": 2000, \"MIR\": 0.38698112964630127}, {\"AREA\": \"Texas\", \"YEAR\": 2000, \"MIR\": 0.4138295650482178}, {\"AREA\": \"Georgia\", \"YEAR\": 2000, \"MIR\": 0.43536123633384705}, {\"AREA\": \"Utah\", \"YEAR\": 2000, \"MIR\": 0.37341615557670593}, {\"AREA\": \"Florida\", \"YEAR\": 2000, \"MIR\": 0.36361899971961975}, {\"AREA\": \"Montana\", \"YEAR\": 2000, \"MIR\": 0.38643187284469604}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2000, \"MIR\": 0.4492180049419403}, {\"AREA\": \"Nevada\", \"YEAR\": 2000, \"MIR\": 0.41183340549468994}, {\"AREA\": \"New Mexico\", \"YEAR\": 2000, \"MIR\": 0.40909087657928467}, {\"AREA\": \"Connecticut\", \"YEAR\": 2000, \"MIR\": 0.3592381179332733}, {\"AREA\": \"Vermont\", \"YEAR\": 2000, \"MIR\": 0.40232226252555847}, {\"AREA\": \"Missouri\", \"YEAR\": 2000, \"MIR\": 0.4366616904735565}, {\"AREA\": \"Virginia\", \"YEAR\": 2000, \"MIR\": 0.4739001393318176}, {\"AREA\": \"Nebraska\", \"YEAR\": 2000, \"MIR\": 0.38151121139526367}, {\"AREA\": \"Washington\", \"YEAR\": 2000, \"MIR\": 0.38528311252593994}, {\"AREA\": \"Delaware\", \"YEAR\": 2000, \"MIR\": 0.39102688431739807}, {\"AREA\": \"Maine\", \"YEAR\": 2000, \"MIR\": 0.40007519721984863}, {\"AREA\": \"Tennessee\", \"YEAR\": 2000, \"MIR\": 0.541077196598053}, {\"AREA\": \"Maryland\", \"YEAR\": 2000, \"MIR\": 0.42205169796943665}, {\"AREA\": \"Oregon\", \"YEAR\": 2000, \"MIR\": 0.3952926993370056}, {\"AREA\": \"Louisiana\", \"YEAR\": 2000, \"MIR\": 0.4598422050476074}, {\"AREA\": \"Ohio\", \"YEAR\": 2000, \"MIR\": 0.44524163007736206}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2000, \"MIR\": 0.3980320394039154}, {\"AREA\": \"Kentucky\", \"YEAR\": 2000, \"MIR\": 0.43558865785598755}, {\"AREA\": \"Colorado\", \"YEAR\": 2000, \"MIR\": 0.37296342849731445}, {\"AREA\": \"Kansas\", \"YEAR\": 2000, \"MIR\": 0.39595746994018555}, {\"AREA\": \"Michigan\", \"YEAR\": 2000, \"MIR\": 0.38912293314933777}, {\"AREA\": \"Hawaii\", \"YEAR\": 2000, \"MIR\": 0.3703438639640808}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2000, \"MIR\": 0.3803260624408722}, {\"AREA\": \"North Dakota\", \"YEAR\": 2000, \"MIR\": 0.39642778038978577}, {\"AREA\": \"South Carolina\", \"YEAR\": 2000, \"MIR\": 0.4444444477558136}, {\"AREA\": \"Indiana\", \"YEAR\": 2000, \"MIR\": 0.4445367753505707}, {\"AREA\": \"Illinois\", \"YEAR\": 2000, \"MIR\": 0.42836877703666687}, {\"AREA\": \"Minnesota\", \"YEAR\": 2000, \"MIR\": 0.3992053270339966}, {\"AREA\": \"North Carolina\", \"YEAR\": 2000, \"MIR\": 0.44255873560905457}, {\"AREA\": \"Idaho\", \"YEAR\": 2000, \"MIR\": 0.37845247983932495}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2000, \"MIR\": 0.4497607946395874}, {\"AREA\": \"New York\", \"YEAR\": 2000, \"MIR\": 0.38077229261398315}, {\"AREA\": \"Iowa\", \"YEAR\": 2000, \"MIR\": 0.39258497953414917}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2000, \"MIR\": 0.40824416279792786}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2000, \"MIR\": 0.4055117964744568}, {\"AREA\": \"California\", \"YEAR\": 2000, \"MIR\": 0.3942224085330963}, {\"AREA\": \"West Virginia\", \"YEAR\": 2000, \"MIR\": 0.44195276498794556}, {\"AREA\": \"Arizona\", \"YEAR\": 2000, \"MIR\": 0.4123278260231018}, {\"AREA\": \"Wyoming\", \"YEAR\": 2000, \"MIR\": 0.39703670144081116}, {\"AREA\": \"Alaska\", \"YEAR\": 2000, \"MIR\": 0.40504366159439087}, {\"AREA\": \"Alabama\", \"YEAR\": 2000, \"MIR\": 0.495728462934494}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2000, \"MIR\": 0.39158108830451965}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2001, \"MIR\": 0.3791939616203308}, {\"AREA\": \"California\", \"YEAR\": 2001, \"MIR\": 0.38604751229286194}, {\"AREA\": \"Georgia\", \"YEAR\": 2001, \"MIR\": 0.42016109824180603}, {\"AREA\": \"Iowa\", \"YEAR\": 2001, \"MIR\": 0.37887948751449585}, {\"AREA\": \"Delaware\", \"YEAR\": 2001, \"MIR\": 0.4181336462497711}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2001, \"MIR\": 0.4382571578025818}, {\"AREA\": \"Wyoming\", \"YEAR\": 2001, \"MIR\": 0.4247923195362091}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2001, \"MIR\": 0.38747143745422363}, {\"AREA\": \"North Carolina\", \"YEAR\": 2001, \"MIR\": 0.4379451870918274}, {\"AREA\": \"Virginia\", \"YEAR\": 2001, \"MIR\": 0.4760550260543823}, {\"AREA\": \"Texas\", \"YEAR\": 2001, \"MIR\": 0.39610257744789124}, {\"AREA\": \"Maryland\", \"YEAR\": 2001, \"MIR\": 0.4316607415676117}, {\"AREA\": \"Utah\", \"YEAR\": 2001, \"MIR\": 0.34396570920944214}, {\"AREA\": \"Montana\", \"YEAR\": 2001, \"MIR\": 0.3883684575557709}, {\"AREA\": \"New Jersey\", \"YEAR\": 2001, \"MIR\": 0.3703502416610718}, {\"AREA\": \"Kentucky\", \"YEAR\": 2001, \"MIR\": 0.4316343665122986}, {\"AREA\": \"Vermont\", \"YEAR\": 2001, \"MIR\": 0.39224308729171753}, {\"AREA\": \"West Virginia\", \"YEAR\": 2001, \"MIR\": 0.4227941334247589}, {\"AREA\": \"Florida\", \"YEAR\": 2001, \"MIR\": 0.35753974318504333}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2001, \"MIR\": 0.46044978499412537}, {\"AREA\": \"Arizona\", \"YEAR\": 2001, \"MIR\": 0.3941871225833893}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2001, \"MIR\": 0.38134145736694336}, {\"AREA\": \"South Carolina\", \"YEAR\": 2001, \"MIR\": 0.42772194743156433}, {\"AREA\": \"Ohio\", \"YEAR\": 2001, \"MIR\": 0.4282183051109314}, {\"AREA\": \"Nevada\", \"YEAR\": 2001, \"MIR\": 0.4095522463321686}, {\"AREA\": \"Indiana\", \"YEAR\": 2001, \"MIR\": 0.42475923895835876}, {\"AREA\": \"Hawaii\", \"YEAR\": 2001, \"MIR\": 0.36146241426467896}, {\"AREA\": \"Alabama\", \"YEAR\": 2001, \"MIR\": 0.46810382604599}, {\"AREA\": \"Oregon\", \"YEAR\": 2001, \"MIR\": 0.3923569619655609}, {\"AREA\": \"New York\", \"YEAR\": 2001, \"MIR\": 0.37447741627693176}, {\"AREA\": \"Colorado\", \"YEAR\": 2001, \"MIR\": 0.36413848400115967}, {\"AREA\": \"Idaho\", \"YEAR\": 2001, \"MIR\": 0.3668651580810547}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2001, \"MIR\": 0.3770063519477844}, {\"AREA\": \"North Dakota\", \"YEAR\": 2001, \"MIR\": 0.4043329060077667}, {\"AREA\": \"Washington\", \"YEAR\": 2001, \"MIR\": 0.3733666241168976}, {\"AREA\": \"Arkansas\", \"YEAR\": 2001, \"MIR\": 0.4556575119495392}, {\"AREA\": \"Louisiana\", \"YEAR\": 2001, \"MIR\": 0.4512871205806732}, {\"AREA\": \"Tennessee\", \"YEAR\": 2001, \"MIR\": 0.531273365020752}, {\"AREA\": \"New Mexico\", \"YEAR\": 2001, \"MIR\": 0.38642656803131104}, {\"AREA\": \"Michigan\", \"YEAR\": 2001, \"MIR\": 0.3822009563446045}, {\"AREA\": \"Alaska\", \"YEAR\": 2001, \"MIR\": 0.38024356961250305}, {\"AREA\": \"South Dakota\", \"YEAR\": 2001, \"MIR\": 0.3864337205886841}, {\"AREA\": \"Illinois\", \"YEAR\": 2001, \"MIR\": 0.40634921193122864}, {\"AREA\": \"Kansas\", \"YEAR\": 2001, \"MIR\": 0.4142734706401825}, {\"AREA\": \"Nebraska\", \"YEAR\": 2001, \"MIR\": 0.3806876540184021}, {\"AREA\": \"Minnesota\", \"YEAR\": 2001, \"MIR\": 0.37471920251846313}, {\"AREA\": \"Connecticut\", \"YEAR\": 2001, \"MIR\": 0.3514935374259949}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2001, \"MIR\": 0.3749999701976776}, {\"AREA\": \"Maine\", \"YEAR\": 2001, \"MIR\": 0.38430288434028625}, {\"AREA\": \"Missouri\", \"YEAR\": 2001, \"MIR\": 0.43200334906578064}, {\"AREA\": \"Illinois\", \"YEAR\": 2002, \"MIR\": 0.3968285024166107}, {\"AREA\": \"Oregon\", \"YEAR\": 2002, \"MIR\": 0.4036453366279602}, {\"AREA\": \"South Dakota\", \"YEAR\": 2002, \"MIR\": 0.34531015157699585}, {\"AREA\": \"Florida\", \"YEAR\": 2002, \"MIR\": 0.3611987233161926}, {\"AREA\": \"Louisiana\", \"YEAR\": 2002, \"MIR\": 0.44508785009384155}, {\"AREA\": \"Utah\", \"YEAR\": 2002, \"MIR\": 0.3466794490814209}, {\"AREA\": \"Hawaii\", \"YEAR\": 2002, \"MIR\": 0.34481143951416016}, {\"AREA\": \"Idaho\", \"YEAR\": 2002, \"MIR\": 0.36292868852615356}, {\"AREA\": \"Nebraska\", \"YEAR\": 2002, \"MIR\": 0.3792610764503479}, {\"AREA\": \"Kentucky\", \"YEAR\": 2002, \"MIR\": 0.43603432178497314}, {\"AREA\": \"Texas\", \"YEAR\": 2002, \"MIR\": 0.4000830054283142}, {\"AREA\": \"Minnesota\", \"YEAR\": 2002, \"MIR\": 0.38224974274635315}, {\"AREA\": \"Missouri\", \"YEAR\": 2002, \"MIR\": 0.4262123703956604}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2002, \"MIR\": 0.4301232397556305}, {\"AREA\": \"New Jersey\", \"YEAR\": 2002, \"MIR\": 0.3665308952331543}, {\"AREA\": \"Georgia\", \"YEAR\": 2002, \"MIR\": 0.41265925765037537}, {\"AREA\": \"Arkansas\", \"YEAR\": 2002, \"MIR\": 0.46984755992889404}, {\"AREA\": \"New York\", \"YEAR\": 2002, \"MIR\": 0.3668391704559326}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2002, \"MIR\": 0.3911248743534088}, {\"AREA\": \"Maine\", \"YEAR\": 2002, \"MIR\": 0.4008958637714386}, {\"AREA\": \"Maryland\", \"YEAR\": 2002, \"MIR\": 0.40411093831062317}, {\"AREA\": \"Indiana\", \"YEAR\": 2002, \"MIR\": 0.4203247129917145}, {\"AREA\": \"Tennessee\", \"YEAR\": 2002, \"MIR\": 0.5246461629867554}, {\"AREA\": \"Ohio\", \"YEAR\": 2002, \"MIR\": 0.43161600828170776}, {\"AREA\": \"New Mexico\", \"YEAR\": 2002, \"MIR\": 0.3988492488861084}, {\"AREA\": \"Nevada\", \"YEAR\": 2002, \"MIR\": 0.4035927951335907}, {\"AREA\": \"Alabama\", \"YEAR\": 2002, \"MIR\": 0.4568171501159668}, {\"AREA\": \"Connecticut\", \"YEAR\": 2002, \"MIR\": 0.3555597960948944}, {\"AREA\": \"Virginia\", \"YEAR\": 2002, \"MIR\": 0.46109578013420105}, {\"AREA\": \"California\", \"YEAR\": 2002, \"MIR\": 0.3833693265914917}, {\"AREA\": \"Alaska\", \"YEAR\": 2002, \"MIR\": 0.38139626383781433}, {\"AREA\": \"Michigan\", \"YEAR\": 2002, \"MIR\": 0.38097959756851196}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2002, \"MIR\": 0.3889103829860687}, {\"AREA\": \"Delaware\", \"YEAR\": 2002, \"MIR\": 0.3768620491027832}, {\"AREA\": \"North Carolina\", \"YEAR\": 2002, \"MIR\": 0.43474483489990234}, {\"AREA\": \"North Dakota\", \"YEAR\": 2002, \"MIR\": 0.37260738015174866}, {\"AREA\": \"Wyoming\", \"YEAR\": 2002, \"MIR\": 0.3988296091556549}, {\"AREA\": \"Arizona\", \"YEAR\": 2002, \"MIR\": 0.40041640400886536}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2002, \"MIR\": 0.3693392872810364}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2002, \"MIR\": 0.37933632731437683}, {\"AREA\": \"Colorado\", \"YEAR\": 2002, \"MIR\": 0.37591713666915894}, {\"AREA\": \"Iowa\", \"YEAR\": 2002, \"MIR\": 0.379573792219162}, {\"AREA\": \"Washington\", \"YEAR\": 2002, \"MIR\": 0.37222006916999817}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2002, \"MIR\": 0.3753943145275116}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2002, \"MIR\": 0.41909241676330566}, {\"AREA\": \"Montana\", \"YEAR\": 2002, \"MIR\": 0.3766798675060272}, {\"AREA\": \"Kansas\", \"YEAR\": 2002, \"MIR\": 0.4047260880470276}, {\"AREA\": \"South Carolina\", \"YEAR\": 2002, \"MIR\": 0.40755388140678406}, {\"AREA\": \"Vermont\", \"YEAR\": 2002, \"MIR\": 0.38359788060188293}, {\"AREA\": \"West Virginia\", \"YEAR\": 2002, \"MIR\": 0.4270087480545044}, {\"AREA\": \"North Dakota\", \"YEAR\": 2003, \"MIR\": 0.3834586441516876}, {\"AREA\": \"Hawaii\", \"YEAR\": 2003, \"MIR\": 0.36879101395606995}, {\"AREA\": \"Connecticut\", \"YEAR\": 2003, \"MIR\": 0.35522738099098206}, {\"AREA\": \"Wyoming\", \"YEAR\": 2003, \"MIR\": 0.4084233343601227}, {\"AREA\": \"South Dakota\", \"YEAR\": 2003, \"MIR\": 0.39085668325424194}, {\"AREA\": \"Iowa\", \"YEAR\": 2003, \"MIR\": 0.38526445627212524}, {\"AREA\": \"California\", \"YEAR\": 2003, \"MIR\": 0.3884924054145813}, {\"AREA\": \"Missouri\", \"YEAR\": 2003, \"MIR\": 0.4236825704574585}, {\"AREA\": \"Louisiana\", \"YEAR\": 2003, \"MIR\": 0.4491199851036072}, {\"AREA\": \"Oregon\", \"YEAR\": 2003, \"MIR\": 0.40918755531311035}, {\"AREA\": \"Tennessee\", \"YEAR\": 2003, \"MIR\": 0.4946536421775818}, {\"AREA\": \"Illinois\", \"YEAR\": 2003, \"MIR\": 0.40153968334198}, {\"AREA\": \"Michigan\", \"YEAR\": 2003, \"MIR\": 0.3725527822971344}, {\"AREA\": \"Washington\", \"YEAR\": 2003, \"MIR\": 0.3776237666606903}, {\"AREA\": \"Kansas\", \"YEAR\": 2003, \"MIR\": 0.3932655453681946}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2003, \"MIR\": 0.3739633560180664}, {\"AREA\": \"Arkansas\", \"YEAR\": 2003, \"MIR\": 0.4393484592437744}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2003, \"MIR\": 0.3711240291595459}, {\"AREA\": \"Idaho\", \"YEAR\": 2003, \"MIR\": 0.3918367326259613}, {\"AREA\": \"Colorado\", \"YEAR\": 2003, \"MIR\": 0.37541383504867554}, {\"AREA\": \"New York\", \"YEAR\": 2003, \"MIR\": 0.3619373142719269}, {\"AREA\": \"Alabama\", \"YEAR\": 2003, \"MIR\": 0.4758967161178589}, {\"AREA\": \"Maine\", \"YEAR\": 2003, \"MIR\": 0.38902556896209717}, {\"AREA\": \"Nebraska\", \"YEAR\": 2003, \"MIR\": 0.37510496377944946}, {\"AREA\": \"Ohio\", \"YEAR\": 2003, \"MIR\": 0.43548384308815}, {\"AREA\": \"Montana\", \"YEAR\": 2003, \"MIR\": 0.3676321506500244}, {\"AREA\": \"Utah\", \"YEAR\": 2003, \"MIR\": 0.3423912823200226}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2003, \"MIR\": 0.3633236587047577}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2003, \"MIR\": 0.38185611367225647}, {\"AREA\": \"West Virginia\", \"YEAR\": 2003, \"MIR\": 0.4335865080356598}, {\"AREA\": \"Florida\", \"YEAR\": 2003, \"MIR\": 0.3674173355102539}, {\"AREA\": \"Mississippi\", \"YEAR\": 2003, \"MIR\": 0.45528632402420044}, {\"AREA\": \"Vermont\", \"YEAR\": 2003, \"MIR\": 0.3639422059059143}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2003, \"MIR\": 0.37845733761787415}, {\"AREA\": \"Indiana\", \"YEAR\": 2003, \"MIR\": 0.42166227102279663}, {\"AREA\": \"New Jersey\", \"YEAR\": 2003, \"MIR\": 0.38294151425361633}, {\"AREA\": \"Maryland\", \"YEAR\": 2003, \"MIR\": 0.3896592855453491}, {\"AREA\": \"Nevada\", \"YEAR\": 2003, \"MIR\": 0.4194827079772949}, {\"AREA\": \"Delaware\", \"YEAR\": 2003, \"MIR\": 0.4003576636314392}, {\"AREA\": \"New Mexico\", \"YEAR\": 2003, \"MIR\": 0.40451306104660034}, {\"AREA\": \"Minnesota\", \"YEAR\": 2003, \"MIR\": 0.38357609510421753}, {\"AREA\": \"Georgia\", \"YEAR\": 2003, \"MIR\": 0.41270172595977783}, {\"AREA\": \"Kentucky\", \"YEAR\": 2003, \"MIR\": 0.4316297173500061}, {\"AREA\": \"Arizona\", \"YEAR\": 2003, \"MIR\": 0.40397194027900696}, {\"AREA\": \"North Carolina\", \"YEAR\": 2003, \"MIR\": 0.42342934012413025}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2003, \"MIR\": 0.40779271721839905}, {\"AREA\": \"South Carolina\", \"YEAR\": 2003, \"MIR\": 0.4205012321472168}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2003, \"MIR\": 0.3938376307487488}, {\"AREA\": \"Alaska\", \"YEAR\": 2003, \"MIR\": 0.3845531642436981}, {\"AREA\": \"Texas\", \"YEAR\": 2003, \"MIR\": 0.3913590908050537}, {\"AREA\": \"Virginia\", \"YEAR\": 2003, \"MIR\": 0.4328390657901764}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2004, \"MIR\": 0.3885497748851776}, {\"AREA\": \"New Mexico\", \"YEAR\": 2004, \"MIR\": 0.375983327627182}, {\"AREA\": \"Kentucky\", \"YEAR\": 2004, \"MIR\": 0.4132516384124756}, {\"AREA\": \"Iowa\", \"YEAR\": 2004, \"MIR\": 0.3741510808467865}, {\"AREA\": \"Kansas\", \"YEAR\": 2004, \"MIR\": 0.3855726718902588}, {\"AREA\": \"Illinois\", \"YEAR\": 2004, \"MIR\": 0.3946942090988159}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2004, \"MIR\": 0.3885248899459839}, {\"AREA\": \"Missouri\", \"YEAR\": 2004, \"MIR\": 0.4259377121925354}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2004, \"MIR\": 0.3683420717716217}, {\"AREA\": \"Montana\", \"YEAR\": 2004, \"MIR\": 0.3763915002346039}, {\"AREA\": \"South Carolina\", \"YEAR\": 2004, \"MIR\": 0.403086394071579}, {\"AREA\": \"Indiana\", \"YEAR\": 2004, \"MIR\": 0.4116553068161011}, {\"AREA\": \"Georgia\", \"YEAR\": 2004, \"MIR\": 0.41006892919540405}, {\"AREA\": \"Utah\", \"YEAR\": 2004, \"MIR\": 0.3298245668411255}, {\"AREA\": \"South Dakota\", \"YEAR\": 2004, \"MIR\": 0.36945196986198425}, {\"AREA\": \"Alaska\", \"YEAR\": 2004, \"MIR\": 0.36188435554504395}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2004, \"MIR\": 0.421763151884079}, {\"AREA\": \"West Virginia\", \"YEAR\": 2004, \"MIR\": 0.4292357563972473}, {\"AREA\": \"Vermont\", \"YEAR\": 2004, \"MIR\": 0.3604162633419037}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2004, \"MIR\": 0.3689735531806946}, {\"AREA\": \"Delaware\", \"YEAR\": 2004, \"MIR\": 0.4073638916015625}, {\"AREA\": \"Nevada\", \"YEAR\": 2004, \"MIR\": 0.4017111659049988}, {\"AREA\": \"Virginia\", \"YEAR\": 2004, \"MIR\": 0.41401970386505127}, {\"AREA\": \"North Carolina\", \"YEAR\": 2004, \"MIR\": 0.4036620855331421}, {\"AREA\": \"North Dakota\", \"YEAR\": 2004, \"MIR\": 0.3576500713825226}, {\"AREA\": \"Connecticut\", \"YEAR\": 2004, \"MIR\": 0.3589743673801422}, {\"AREA\": \"California\", \"YEAR\": 2004, \"MIR\": 0.3742819130420685}, {\"AREA\": \"Michigan\", \"YEAR\": 2004, \"MIR\": 0.3789411187171936}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2004, \"MIR\": 0.3723100423812866}, {\"AREA\": \"Colorado\", \"YEAR\": 2004, \"MIR\": 0.35747820138931274}, {\"AREA\": \"Minnesota\", \"YEAR\": 2004, \"MIR\": 0.36733847856521606}, {\"AREA\": \"Washington\", \"YEAR\": 2004, \"MIR\": 0.3649822175502777}, {\"AREA\": \"Wyoming\", \"YEAR\": 2004, \"MIR\": 0.38075223565101624}, {\"AREA\": \"Ohio\", \"YEAR\": 2004, \"MIR\": 0.4204285442829132}, {\"AREA\": \"Florida\", \"YEAR\": 2004, \"MIR\": 0.370546817779541}, {\"AREA\": \"Arizona\", \"YEAR\": 2004, \"MIR\": 0.39537081122398376}, {\"AREA\": \"Texas\", \"YEAR\": 2004, \"MIR\": 0.38967135548591614}, {\"AREA\": \"Alabama\", \"YEAR\": 2004, \"MIR\": 0.4436253309249878}, {\"AREA\": \"Maryland\", \"YEAR\": 2004, \"MIR\": 0.4102729260921478}, {\"AREA\": \"Hawaii\", \"YEAR\": 2004, \"MIR\": 0.34347131848335266}, {\"AREA\": \"Arkansas\", \"YEAR\": 2004, \"MIR\": 0.4496006965637207}, {\"AREA\": \"Nebraska\", \"YEAR\": 2004, \"MIR\": 0.36091476678848267}, {\"AREA\": \"Maine\", \"YEAR\": 2004, \"MIR\": 0.3713708221912384}, {\"AREA\": \"Tennessee\", \"YEAR\": 2004, \"MIR\": 0.46177709102630615}, {\"AREA\": \"New York\", \"YEAR\": 2004, \"MIR\": 0.3568989634513855}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2004, \"MIR\": 0.4097846746444702}, {\"AREA\": \"Idaho\", \"YEAR\": 2004, \"MIR\": 0.36579060554504395}, {\"AREA\": \"Mississippi\", \"YEAR\": 2004, \"MIR\": 0.4471389055252075}, {\"AREA\": \"Louisiana\", \"YEAR\": 2004, \"MIR\": 0.4348524510860443}, {\"AREA\": \"New Jersey\", \"YEAR\": 2004, \"MIR\": 0.3638310134410858}, {\"AREA\": \"Oregon\", \"YEAR\": 2004, \"MIR\": 0.38959968090057373}, {\"AREA\": \"Missouri\", \"YEAR\": 2005, \"MIR\": 0.4019906520843506}, {\"AREA\": \"Michigan\", \"YEAR\": 2005, \"MIR\": 0.38150858879089355}, {\"AREA\": \"Louisiana\", \"YEAR\": 2005, \"MIR\": 0.44633233547210693}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2005, \"MIR\": 0.3850526213645935}, {\"AREA\": \"Kansas\", \"YEAR\": 2005, \"MIR\": 0.39484888315200806}, {\"AREA\": \"Minnesota\", \"YEAR\": 2005, \"MIR\": 0.355326771736145}, {\"AREA\": \"Maryland\", \"YEAR\": 2005, \"MIR\": 0.4096670150756836}, {\"AREA\": \"North Carolina\", \"YEAR\": 2005, \"MIR\": 0.3887198269367218}, {\"AREA\": \"New York\", \"YEAR\": 2005, \"MIR\": 0.3461001515388489}, {\"AREA\": \"North Dakota\", \"YEAR\": 2005, \"MIR\": 0.35322242975234985}, {\"AREA\": \"Kentucky\", \"YEAR\": 2005, \"MIR\": 0.4230102002620697}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2005, \"MIR\": 0.3596287667751312}, {\"AREA\": \"Maine\", \"YEAR\": 2005, \"MIR\": 0.38424015045166016}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2005, \"MIR\": 0.4163162410259247}, {\"AREA\": \"Alaska\", \"YEAR\": 2005, \"MIR\": 0.3591710031032562}, {\"AREA\": \"Mississippi\", \"YEAR\": 2005, \"MIR\": 0.44842952489852905}, {\"AREA\": \"Ohio\", \"YEAR\": 2005, \"MIR\": 0.40719425678253174}, {\"AREA\": \"Wyoming\", \"YEAR\": 2005, \"MIR\": 0.39482277631759644}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2005, \"MIR\": 0.3864581286907196}, {\"AREA\": \"Oregon\", \"YEAR\": 2005, \"MIR\": 0.390142023563385}, {\"AREA\": \"South Carolina\", \"YEAR\": 2005, \"MIR\": 0.40263959765434265}, {\"AREA\": \"Georgia\", \"YEAR\": 2005, \"MIR\": 0.4046659767627716}, {\"AREA\": \"Montana\", \"YEAR\": 2005, \"MIR\": 0.3723984658718109}, {\"AREA\": \"Tennessee\", \"YEAR\": 2005, \"MIR\": 0.43765586614608765}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2005, \"MIR\": 0.3566197156906128}, {\"AREA\": \"Delaware\", \"YEAR\": 2005, \"MIR\": 0.37665534019470215}, {\"AREA\": \"Illinois\", \"YEAR\": 2005, \"MIR\": 0.39161407947540283}, {\"AREA\": \"Nevada\", \"YEAR\": 2005, \"MIR\": 0.4233657419681549}, {\"AREA\": \"California\", \"YEAR\": 2005, \"MIR\": 0.37641823291778564}, {\"AREA\": \"South Dakota\", \"YEAR\": 2005, \"MIR\": 0.3919326961040497}, {\"AREA\": \"Nebraska\", \"YEAR\": 2005, \"MIR\": 0.3602880835533142}, {\"AREA\": \"Arkansas\", \"YEAR\": 2005, \"MIR\": 0.44470638036727905}, {\"AREA\": \"Hawaii\", \"YEAR\": 2005, \"MIR\": 0.3507877588272095}, {\"AREA\": \"Virginia\", \"YEAR\": 2005, \"MIR\": 0.4145280718803406}, {\"AREA\": \"Connecticut\", \"YEAR\": 2005, \"MIR\": 0.34619906544685364}, {\"AREA\": \"Utah\", \"YEAR\": 2005, \"MIR\": 0.33499643206596375}, {\"AREA\": \"Idaho\", \"YEAR\": 2005, \"MIR\": 0.36471816897392273}, {\"AREA\": \"Texas\", \"YEAR\": 2005, \"MIR\": 0.3851931393146515}, {\"AREA\": \"Indiana\", \"YEAR\": 2005, \"MIR\": 0.41194644570350647}, {\"AREA\": \"Alabama\", \"YEAR\": 2005, \"MIR\": 0.4427860677242279}, {\"AREA\": \"Arizona\", \"YEAR\": 2005, \"MIR\": 0.39076629281044006}, {\"AREA\": \"Colorado\", \"YEAR\": 2005, \"MIR\": 0.3583389222621918}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2005, \"MIR\": 0.421590656042099}, {\"AREA\": \"New Mexico\", \"YEAR\": 2005, \"MIR\": 0.38676783442497253}, {\"AREA\": \"New Jersey\", \"YEAR\": 2005, \"MIR\": 0.3606237769126892}, {\"AREA\": \"West Virginia\", \"YEAR\": 2005, \"MIR\": 0.41165974736213684}, {\"AREA\": \"Iowa\", \"YEAR\": 2005, \"MIR\": 0.3746674954891205}, {\"AREA\": \"Vermont\", \"YEAR\": 2005, \"MIR\": 0.35058730840682983}, {\"AREA\": \"Florida\", \"YEAR\": 2005, \"MIR\": 0.3654478192329407}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2005, \"MIR\": 0.3651135563850403}, {\"AREA\": \"Washington\", \"YEAR\": 2005, \"MIR\": 0.35892361402511597}, {\"AREA\": \"Vermont\", \"YEAR\": 2006, \"MIR\": 0.3267308175563812}, {\"AREA\": \"Hawaii\", \"YEAR\": 2006, \"MIR\": 0.3458576500415802}, {\"AREA\": \"New York\", \"YEAR\": 2006, \"MIR\": 0.3335932791233063}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2006, \"MIR\": 0.39422690868377686}, {\"AREA\": \"West Virginia\", \"YEAR\": 2006, \"MIR\": 0.4026845693588257}, {\"AREA\": \"North Dakota\", \"YEAR\": 2006, \"MIR\": 0.3758361339569092}, {\"AREA\": \"Tennessee\", \"YEAR\": 2006, \"MIR\": 0.42610684037208557}, {\"AREA\": \"Nevada\", \"YEAR\": 2006, \"MIR\": 0.39636752009391785}, {\"AREA\": \"Ohio\", \"YEAR\": 2006, \"MIR\": 0.4069647789001465}, {\"AREA\": \"Maine\", \"YEAR\": 2006, \"MIR\": 0.3546725809574127}, {\"AREA\": \"Wyoming\", \"YEAR\": 2006, \"MIR\": 0.38360080122947693}, {\"AREA\": \"Florida\", \"YEAR\": 2006, \"MIR\": 0.36081191897392273}, {\"AREA\": \"Alaska\", \"YEAR\": 2006, \"MIR\": 0.36703431606292725}, {\"AREA\": \"Maryland\", \"YEAR\": 2006, \"MIR\": 0.4068605899810791}, {\"AREA\": \"Delaware\", \"YEAR\": 2006, \"MIR\": 0.352050244808197}, {\"AREA\": \"Nebraska\", \"YEAR\": 2006, \"MIR\": 0.36171954870224}, {\"AREA\": \"Georgia\", \"YEAR\": 2006, \"MIR\": 0.3882822096347809}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2006, \"MIR\": 0.427066445350647}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2006, \"MIR\": 0.35319632291793823}, {\"AREA\": \"Mississippi\", \"YEAR\": 2006, \"MIR\": 0.4421401619911194}, {\"AREA\": \"Texas\", \"YEAR\": 2006, \"MIR\": 0.3846321403980255}, {\"AREA\": \"Arkansas\", \"YEAR\": 2006, \"MIR\": 0.42526501417160034}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2006, \"MIR\": 0.3703776001930237}, {\"AREA\": \"Utah\", \"YEAR\": 2006, \"MIR\": 0.32988235354423523}, {\"AREA\": \"Idaho\", \"YEAR\": 2006, \"MIR\": 0.34492939710617065}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2006, \"MIR\": 0.34205079078674316}, {\"AREA\": \"Minnesota\", \"YEAR\": 2006, \"MIR\": 0.3535248935222626}, {\"AREA\": \"Colorado\", \"YEAR\": 2006, \"MIR\": 0.35942816734313965}, {\"AREA\": \"Indiana\", \"YEAR\": 2006, \"MIR\": 0.4017857313156128}, {\"AREA\": \"South Carolina\", \"YEAR\": 2006, \"MIR\": 0.4000000059604645}, {\"AREA\": \"North Carolina\", \"YEAR\": 2006, \"MIR\": 0.39110931754112244}, {\"AREA\": \"New Jersey\", \"YEAR\": 2006, \"MIR\": 0.3490188419818878}, {\"AREA\": \"Montana\", \"YEAR\": 2006, \"MIR\": 0.36582356691360474}, {\"AREA\": \"Kentucky\", \"YEAR\": 2006, \"MIR\": 0.3975678086280823}, {\"AREA\": \"California\", \"YEAR\": 2006, \"MIR\": 0.36810362339019775}, {\"AREA\": \"Missouri\", \"YEAR\": 2006, \"MIR\": 0.40184614062309265}, {\"AREA\": \"Washington\", \"YEAR\": 2006, \"MIR\": 0.3530001938343048}, {\"AREA\": \"Illinois\", \"YEAR\": 2006, \"MIR\": 0.3766699731349945}, {\"AREA\": \"Iowa\", \"YEAR\": 2006, \"MIR\": 0.36300814151763916}, {\"AREA\": \"Oregon\", \"YEAR\": 2006, \"MIR\": 0.3810924291610718}, {\"AREA\": \"South Dakota\", \"YEAR\": 2006, \"MIR\": 0.3870461583137512}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2006, \"MIR\": 0.3536749482154846}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2006, \"MIR\": 0.3730323314666748}, {\"AREA\": \"Kansas\", \"YEAR\": 2006, \"MIR\": 0.37926673889160156}, {\"AREA\": \"Alabama\", \"YEAR\": 2006, \"MIR\": 0.4291236996650696}, {\"AREA\": \"New Mexico\", \"YEAR\": 2006, \"MIR\": 0.37972262501716614}, {\"AREA\": \"Virginia\", \"YEAR\": 2006, \"MIR\": 0.40391305088996887}, {\"AREA\": \"Arizona\", \"YEAR\": 2006, \"MIR\": 0.3768252432346344}, {\"AREA\": \"Louisiana\", \"YEAR\": 2006, \"MIR\": 0.41738954186439514}, {\"AREA\": \"Connecticut\", \"YEAR\": 2006, \"MIR\": 0.33377760648727417}, {\"AREA\": \"Michigan\", \"YEAR\": 2006, \"MIR\": 0.3776721954345703}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2007, \"MIR\": 0.3944832980632782}, {\"AREA\": \"Utah\", \"YEAR\": 2007, \"MIR\": 0.3175659775733948}, {\"AREA\": \"North Carolina\", \"YEAR\": 2007, \"MIR\": 0.3787664473056793}, {\"AREA\": \"Washington\", \"YEAR\": 2007, \"MIR\": 0.37594297528266907}, {\"AREA\": \"Delaware\", \"YEAR\": 2007, \"MIR\": 0.3629365563392639}, {\"AREA\": \"Colorado\", \"YEAR\": 2007, \"MIR\": 0.3377729058265686}, {\"AREA\": \"Vermont\", \"YEAR\": 2007, \"MIR\": 0.37492549419403076}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2007, \"MIR\": 0.34198471903800964}, {\"AREA\": \"Minnesota\", \"YEAR\": 2007, \"MIR\": 0.3383564054965973}, {\"AREA\": \"Michigan\", \"YEAR\": 2007, \"MIR\": 0.3601236641407013}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2007, \"MIR\": 0.3561670184135437}, {\"AREA\": \"Virginia\", \"YEAR\": 2007, \"MIR\": 0.38938242197036743}, {\"AREA\": \"Nevada\", \"YEAR\": 2007, \"MIR\": 0.40586522221565247}, {\"AREA\": \"North Dakota\", \"YEAR\": 2007, \"MIR\": 0.33265015482902527}, {\"AREA\": \"California\", \"YEAR\": 2007, \"MIR\": 0.3582513630390167}, {\"AREA\": \"Connecticut\", \"YEAR\": 2007, \"MIR\": 0.3221450448036194}, {\"AREA\": \"New Mexico\", \"YEAR\": 2007, \"MIR\": 0.37592020630836487}, {\"AREA\": \"Maryland\", \"YEAR\": 2007, \"MIR\": 0.3732205331325531}, {\"AREA\": \"Ohio\", \"YEAR\": 2007, \"MIR\": 0.40566232800483704}, {\"AREA\": \"Alabama\", \"YEAR\": 2007, \"MIR\": 0.418688029050827}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2007, \"MIR\": 0.36534103751182556}, {\"AREA\": \"South Dakota\", \"YEAR\": 2007, \"MIR\": 0.3666035234928131}, {\"AREA\": \"Oregon\", \"YEAR\": 2007, \"MIR\": 0.3787621855735779}, {\"AREA\": \"Illinois\", \"YEAR\": 2007, \"MIR\": 0.37075304985046387}, {\"AREA\": \"Montana\", \"YEAR\": 2007, \"MIR\": 0.3558192849159241}, {\"AREA\": \"New Jersey\", \"YEAR\": 2007, \"MIR\": 0.3422154486179352}, {\"AREA\": \"Kentucky\", \"YEAR\": 2007, \"MIR\": 0.4010446071624756}, {\"AREA\": \"Indiana\", \"YEAR\": 2007, \"MIR\": 0.39536789059638977}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2007, \"MIR\": 0.3293812572956085}, {\"AREA\": \"Arizona\", \"YEAR\": 2007, \"MIR\": 0.3724202811717987}, {\"AREA\": \"Iowa\", \"YEAR\": 2007, \"MIR\": 0.3610145151615143}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2007, \"MIR\": 0.36068111658096313}, {\"AREA\": \"Missouri\", \"YEAR\": 2007, \"MIR\": 0.39336493611335754}, {\"AREA\": \"Kansas\", \"YEAR\": 2007, \"MIR\": 0.36359935998916626}, {\"AREA\": \"South Carolina\", \"YEAR\": 2007, \"MIR\": 0.3830825388431549}, {\"AREA\": \"Idaho\", \"YEAR\": 2007, \"MIR\": 0.34259259700775146}, {\"AREA\": \"Georgia\", \"YEAR\": 2007, \"MIR\": 0.37702593207359314}, {\"AREA\": \"Wyoming\", \"YEAR\": 2007, \"MIR\": 0.39661478996276855}, {\"AREA\": \"Tennessee\", \"YEAR\": 2007, \"MIR\": 0.414814829826355}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2007, \"MIR\": 0.3912872076034546}, {\"AREA\": \"Florida\", \"YEAR\": 2007, \"MIR\": 0.34878450632095337}, {\"AREA\": \"New York\", \"YEAR\": 2007, \"MIR\": 0.3292587995529175}, {\"AREA\": \"Hawaii\", \"YEAR\": 2007, \"MIR\": 0.3386911451816559}, {\"AREA\": \"Maine\", \"YEAR\": 2007, \"MIR\": 0.3595377802848816}, {\"AREA\": \"West Virginia\", \"YEAR\": 2007, \"MIR\": 0.39894554018974304}, {\"AREA\": \"Texas\", \"YEAR\": 2007, \"MIR\": 0.3685561418533325}, {\"AREA\": \"Alaska\", \"YEAR\": 2007, \"MIR\": 0.38752877712249756}, {\"AREA\": \"Louisiana\", \"YEAR\": 2007, \"MIR\": 0.39531654119491577}, {\"AREA\": \"Mississippi\", \"YEAR\": 2007, \"MIR\": 0.40631917119026184}, {\"AREA\": \"Arkansas\", \"YEAR\": 2007, \"MIR\": 0.42684221267700195}, {\"AREA\": \"Nebraska\", \"YEAR\": 2007, \"MIR\": 0.3540160655975342}, {\"AREA\": \"Missouri\", \"YEAR\": 2008, \"MIR\": 0.39836031198501587}, {\"AREA\": \"Nebraska\", \"YEAR\": 2008, \"MIR\": 0.34987643361091614}, {\"AREA\": \"Mississippi\", \"YEAR\": 2008, \"MIR\": 0.4053567945957184}, {\"AREA\": \"New Mexico\", \"YEAR\": 2008, \"MIR\": 0.3809862434864044}, {\"AREA\": \"Montana\", \"YEAR\": 2008, \"MIR\": 0.34037160873413086}, {\"AREA\": \"Minnesota\", \"YEAR\": 2008, \"MIR\": 0.34776392579078674}, {\"AREA\": \"New York\", \"YEAR\": 2008, \"MIR\": 0.3220568597316742}, {\"AREA\": \"Wyoming\", \"YEAR\": 2008, \"MIR\": 0.3573867678642273}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2008, \"MIR\": 0.3370019197463989}, {\"AREA\": \"Nevada\", \"YEAR\": 2008, \"MIR\": 0.38943037390708923}, {\"AREA\": \"Alabama\", \"YEAR\": 2008, \"MIR\": 0.40580007433891296}, {\"AREA\": \"New Jersey\", \"YEAR\": 2008, \"MIR\": 0.33868780732154846}, {\"AREA\": \"Indiana\", \"YEAR\": 2008, \"MIR\": 0.40140408277511597}, {\"AREA\": \"South Carolina\", \"YEAR\": 2008, \"MIR\": 0.3972860276699066}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2008, \"MIR\": 0.3663713335990906}, {\"AREA\": \"Utah\", \"YEAR\": 2008, \"MIR\": 0.2976106107234955}, {\"AREA\": \"Oregon\", \"YEAR\": 2008, \"MIR\": 0.36528927087783813}, {\"AREA\": \"Florida\", \"YEAR\": 2008, \"MIR\": 0.34689682722091675}, {\"AREA\": \"Kentucky\", \"YEAR\": 2008, \"MIR\": 0.39297187328338623}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2008, \"MIR\": 0.3587295413017273}, {\"AREA\": \"Texas\", \"YEAR\": 2008, \"MIR\": 0.37278494238853455}, {\"AREA\": \"Kansas\", \"YEAR\": 2008, \"MIR\": 0.3529771864414215}, {\"AREA\": \"Arkansas\", \"YEAR\": 2008, \"MIR\": 0.43745920062065125}, {\"AREA\": \"Georgia\", \"YEAR\": 2008, \"MIR\": 0.3597460985183716}, {\"AREA\": \"Tennessee\", \"YEAR\": 2008, \"MIR\": 0.40497225522994995}, {\"AREA\": \"Hawaii\", \"YEAR\": 2008, \"MIR\": 0.3227272629737854}, {\"AREA\": \"Iowa\", \"YEAR\": 2008, \"MIR\": 0.36214327812194824}, {\"AREA\": \"Arizona\", \"YEAR\": 2008, \"MIR\": 0.36809223890304565}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2008, \"MIR\": 0.3341490924358368}, {\"AREA\": \"West Virginia\", \"YEAR\": 2008, \"MIR\": 0.3989919126033783}, {\"AREA\": \"Idaho\", \"YEAR\": 2008, \"MIR\": 0.3558635115623474}, {\"AREA\": \"North Carolina\", \"YEAR\": 2008, \"MIR\": 0.3696982264518738}, {\"AREA\": \"South Dakota\", \"YEAR\": 2008, \"MIR\": 0.36357730627059937}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2008, \"MIR\": 0.4054621756076813}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2008, \"MIR\": 0.4061179459095001}, {\"AREA\": \"Louisiana\", \"YEAR\": 2008, \"MIR\": 0.4088200330734253}, {\"AREA\": \"Ohio\", \"YEAR\": 2008, \"MIR\": 0.3909406363964081}, {\"AREA\": \"Washington\", \"YEAR\": 2008, \"MIR\": 0.35607287287712097}, {\"AREA\": \"Michigan\", \"YEAR\": 2008, \"MIR\": 0.37591686844825745}, {\"AREA\": \"California\", \"YEAR\": 2008, \"MIR\": 0.3506951928138733}, {\"AREA\": \"North Dakota\", \"YEAR\": 2008, \"MIR\": 0.3636363744735718}, {\"AREA\": \"Colorado\", \"YEAR\": 2008, \"MIR\": 0.3371237516403198}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2008, \"MIR\": 0.33843502402305603}, {\"AREA\": \"Maine\", \"YEAR\": 2008, \"MIR\": 0.35928377509117126}, {\"AREA\": \"Virginia\", \"YEAR\": 2008, \"MIR\": 0.38672125339508057}, {\"AREA\": \"Connecticut\", \"YEAR\": 2008, \"MIR\": 0.32174253463745117}, {\"AREA\": \"Maryland\", \"YEAR\": 2008, \"MIR\": 0.3726785182952881}, {\"AREA\": \"Alaska\", \"YEAR\": 2008, \"MIR\": 0.37556377053260803}, {\"AREA\": \"Illinois\", \"YEAR\": 2008, \"MIR\": 0.3656849265098572}, {\"AREA\": \"Delaware\", \"YEAR\": 2008, \"MIR\": 0.36269527673721313}, {\"AREA\": \"Vermont\", \"YEAR\": 2008, \"MIR\": 0.36624401807785034}, {\"AREA\": \"Nebraska\", \"YEAR\": 2009, \"MIR\": 0.3585110902786255}, {\"AREA\": \"Washington\", \"YEAR\": 2009, \"MIR\": 0.3548125624656677}, {\"AREA\": \"South Dakota\", \"YEAR\": 2009, \"MIR\": 0.33530905842781067}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2009, \"MIR\": 0.39538151025772095}, {\"AREA\": \"New Jersey\", \"YEAR\": 2009, \"MIR\": 0.3273220956325531}, {\"AREA\": \"Idaho\", \"YEAR\": 2009, \"MIR\": 0.3387303054332733}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2009, \"MIR\": 0.3370283842086792}, {\"AREA\": \"West Virginia\", \"YEAR\": 2009, \"MIR\": 0.4122059941291809}, {\"AREA\": \"Utah\", \"YEAR\": 2009, \"MIR\": 0.29632267355918884}, {\"AREA\": \"Colorado\", \"YEAR\": 2009, \"MIR\": 0.3398210108280182}, {\"AREA\": \"Hawaii\", \"YEAR\": 2009, \"MIR\": 0.3204808533191681}, {\"AREA\": \"Virginia\", \"YEAR\": 2009, \"MIR\": 0.3835616409778595}, {\"AREA\": \"Montana\", \"YEAR\": 2009, \"MIR\": 0.3380398750305176}, {\"AREA\": \"Tennessee\", \"YEAR\": 2009, \"MIR\": 0.4006078839302063}, {\"AREA\": \"Georgia\", \"YEAR\": 2009, \"MIR\": 0.36418095231056213}, {\"AREA\": \"Vermont\", \"YEAR\": 2009, \"MIR\": 0.3381294906139374}, {\"AREA\": \"Connecticut\", \"YEAR\": 2009, \"MIR\": 0.3158099055290222}, {\"AREA\": \"Nevada\", \"YEAR\": 2009, \"MIR\": 0.3788565397262573}, {\"AREA\": \"Florida\", \"YEAR\": 2009, \"MIR\": 0.34860265254974365}, {\"AREA\": \"Arkansas\", \"YEAR\": 2009, \"MIR\": 0.43203142285346985}, {\"AREA\": \"Texas\", \"YEAR\": 2009, \"MIR\": 0.36671116948127747}, {\"AREA\": \"Delaware\", \"YEAR\": 2009, \"MIR\": 0.34093087911605835}, {\"AREA\": \"North Carolina\", \"YEAR\": 2009, \"MIR\": 0.3550651967525482}, {\"AREA\": \"Wyoming\", \"YEAR\": 2009, \"MIR\": 0.3824422359466553}, {\"AREA\": \"Alaska\", \"YEAR\": 2009, \"MIR\": 0.39395859837532043}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2009, \"MIR\": 0.40268027782440186}, {\"AREA\": \"Ohio\", \"YEAR\": 2009, \"MIR\": 0.3885142207145691}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2009, \"MIR\": 0.3526107668876648}, {\"AREA\": \"Louisiana\", \"YEAR\": 2009, \"MIR\": 0.3919478952884674}, {\"AREA\": \"Illinois\", \"YEAR\": 2009, \"MIR\": 0.36260226368904114}, {\"AREA\": \"Oregon\", \"YEAR\": 2009, \"MIR\": 0.37216827273368835}, {\"AREA\": \"New York\", \"YEAR\": 2009, \"MIR\": 0.3193686604499817}, {\"AREA\": \"Kentucky\", \"YEAR\": 2009, \"MIR\": 0.3903926908969879}, {\"AREA\": \"California\", \"YEAR\": 2009, \"MIR\": 0.3540691137313843}, {\"AREA\": \"Kansas\", \"YEAR\": 2009, \"MIR\": 0.35878661274909973}, {\"AREA\": \"Missouri\", \"YEAR\": 2009, \"MIR\": 0.3831370174884796}, {\"AREA\": \"Mississippi\", \"YEAR\": 2009, \"MIR\": 0.4117525815963745}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2009, \"MIR\": 0.3427174985408783}, {\"AREA\": \"Maryland\", \"YEAR\": 2009, \"MIR\": 0.3742058277130127}, {\"AREA\": \"New Mexico\", \"YEAR\": 2009, \"MIR\": 0.360425740480423}, {\"AREA\": \"South Carolina\", \"YEAR\": 2009, \"MIR\": 0.3856540024280548}, {\"AREA\": \"Michigan\", \"YEAR\": 2009, \"MIR\": 0.37348657846450806}, {\"AREA\": \"Minnesota\", \"YEAR\": 2009, \"MIR\": 0.3526337742805481}, {\"AREA\": \"Indiana\", \"YEAR\": 2009, \"MIR\": 0.4010954201221466}, {\"AREA\": \"North Dakota\", \"YEAR\": 2009, \"MIR\": 0.3375271260738373}, {\"AREA\": \"Arizona\", \"YEAR\": 2009, \"MIR\": 0.35916823148727417}, {\"AREA\": \"Alabama\", \"YEAR\": 2009, \"MIR\": 0.4104976952075958}, {\"AREA\": \"Iowa\", \"YEAR\": 2009, \"MIR\": 0.3400842249393463}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2009, \"MIR\": 0.3558558523654938}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2009, \"MIR\": 0.3319319784641266}, {\"AREA\": \"Maine\", \"YEAR\": 2009, \"MIR\": 0.3707258403301239}, {\"AREA\": \"New York\", \"YEAR\": 2010, \"MIR\": 0.3266128897666931}, {\"AREA\": \"Virginia\", \"YEAR\": 2010, \"MIR\": 0.39763781428337097}, {\"AREA\": \"North Dakota\", \"YEAR\": 2010, \"MIR\": 0.33533963561058044}, {\"AREA\": \"Vermont\", \"YEAR\": 2010, \"MIR\": 0.3760806918144226}, {\"AREA\": \"Ohio\", \"YEAR\": 2010, \"MIR\": 0.39952921867370605}, {\"AREA\": \"North Carolina\", \"YEAR\": 2010, \"MIR\": 0.365637868642807}, {\"AREA\": \"West Virginia\", \"YEAR\": 2010, \"MIR\": 0.4068323075771332}, {\"AREA\": \"Utah\", \"YEAR\": 2010, \"MIR\": 0.3116943836212158}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2010, \"MIR\": 0.41796618700027466}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2010, \"MIR\": 0.3304433524608612}, {\"AREA\": \"Oregon\", \"YEAR\": 2010, \"MIR\": 0.3831154406070709}, {\"AREA\": \"Texas\", \"YEAR\": 2010, \"MIR\": 0.3815576732158661}, {\"AREA\": \"Wyoming\", \"YEAR\": 2010, \"MIR\": 0.39117443561553955}, {\"AREA\": \"New Mexico\", \"YEAR\": 2010, \"MIR\": 0.37812188267707825}, {\"AREA\": \"Tennessee\", \"YEAR\": 2010, \"MIR\": 0.4044453799724579}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2010, \"MIR\": 0.35565185546875}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2010, \"MIR\": 0.3574029207229614}, {\"AREA\": \"New Jersey\", \"YEAR\": 2010, \"MIR\": 0.3356545865535736}, {\"AREA\": \"South Dakota\", \"YEAR\": 2010, \"MIR\": 0.3722051680088043}, {\"AREA\": \"South Carolina\", \"YEAR\": 2010, \"MIR\": 0.3816394805908203}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2010, \"MIR\": 0.362101286649704}, {\"AREA\": \"Washington\", \"YEAR\": 2010, \"MIR\": 0.3503197729587555}, {\"AREA\": \"Missouri\", \"YEAR\": 2010, \"MIR\": 0.3967776596546173}, {\"AREA\": \"Arizona\", \"YEAR\": 2010, \"MIR\": 0.3740813136100769}, {\"AREA\": \"Montana\", \"YEAR\": 2010, \"MIR\": 0.3338901698589325}, {\"AREA\": \"Alaska\", \"YEAR\": 2010, \"MIR\": 0.3758700489997864}, {\"AREA\": \"Idaho\", \"YEAR\": 2010, \"MIR\": 0.3441769480705261}, {\"AREA\": \"Delaware\", \"YEAR\": 2010, \"MIR\": 0.3598048686981201}, {\"AREA\": \"Mississippi\", \"YEAR\": 2010, \"MIR\": 0.4102354049682617}, {\"AREA\": \"Illinois\", \"YEAR\": 2010, \"MIR\": 0.36765921115875244}, {\"AREA\": \"Indiana\", \"YEAR\": 2010, \"MIR\": 0.4001706838607788}, {\"AREA\": \"Minnesota\", \"YEAR\": 2010, \"MIR\": 0.35005271434783936}, {\"AREA\": \"Connecticut\", \"YEAR\": 2010, \"MIR\": 0.3227281868457794}, {\"AREA\": \"Hawaii\", \"YEAR\": 2010, \"MIR\": 0.32919400930404663}, {\"AREA\": \"Iowa\", \"YEAR\": 2010, \"MIR\": 0.347445547580719}, {\"AREA\": \"Arkansas\", \"YEAR\": 2010, \"MIR\": 0.4234805405139923}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2010, \"MIR\": 0.3544752597808838}, {\"AREA\": \"Kansas\", \"YEAR\": 2010, \"MIR\": 0.3607112467288971}, {\"AREA\": \"Maryland\", \"YEAR\": 2010, \"MIR\": 0.3616659343242645}, {\"AREA\": \"Kentucky\", \"YEAR\": 2010, \"MIR\": 0.3928436040878296}, {\"AREA\": \"Colorado\", \"YEAR\": 2010, \"MIR\": 0.34540390968322754}, {\"AREA\": \"Louisiana\", \"YEAR\": 2010, \"MIR\": 0.393071711063385}, {\"AREA\": \"Maine\", \"YEAR\": 2010, \"MIR\": 0.3768174648284912}, {\"AREA\": \"Florida\", \"YEAR\": 2010, \"MIR\": 0.34909477829933167}, {\"AREA\": \"Michigan\", \"YEAR\": 2010, \"MIR\": 0.37059661746025085}, {\"AREA\": \"Alabama\", \"YEAR\": 2010, \"MIR\": 0.4070909917354584}, {\"AREA\": \"California\", \"YEAR\": 2010, \"MIR\": 0.35359489917755127}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2010, \"MIR\": 0.3535473346710205}, {\"AREA\": \"Georgia\", \"YEAR\": 2010, \"MIR\": 0.3751078248023987}, {\"AREA\": \"Nebraska\", \"YEAR\": 2010, \"MIR\": 0.3549349904060364}, {\"AREA\": \"Nevada\", \"YEAR\": 2010, \"MIR\": 0.39807385206222534}, {\"AREA\": \"Nebraska\", \"YEAR\": 2011, \"MIR\": 0.35295382142066956}, {\"AREA\": \"Texas\", \"YEAR\": 2011, \"MIR\": 0.38273346424102783}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2011, \"MIR\": 0.3349282145500183}, {\"AREA\": \"Connecticut\", \"YEAR\": 2011, \"MIR\": 0.31910157203674316}, {\"AREA\": \"North Carolina\", \"YEAR\": 2011, \"MIR\": 0.36138102412223816}, {\"AREA\": \"Indiana\", \"YEAR\": 2011, \"MIR\": 0.39513546228408813}, {\"AREA\": \"Minnesota\", \"YEAR\": 2011, \"MIR\": 0.3347219228744507}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2011, \"MIR\": 0.3424449563026428}, {\"AREA\": \"Arizona\", \"YEAR\": 2011, \"MIR\": 0.3624816834926605}, {\"AREA\": \"California\", \"YEAR\": 2011, \"MIR\": 0.3530503213405609}, {\"AREA\": \"Illinois\", \"YEAR\": 2011, \"MIR\": 0.3592752516269684}, {\"AREA\": \"South Carolina\", \"YEAR\": 2011, \"MIR\": 0.3861175775527954}, {\"AREA\": \"New York\", \"YEAR\": 2011, \"MIR\": 0.31478190422058105}, {\"AREA\": \"Iowa\", \"YEAR\": 2011, \"MIR\": 0.3540768027305603}, {\"AREA\": \"Michigan\", \"YEAR\": 2011, \"MIR\": 0.3630038797855377}, {\"AREA\": \"Virginia\", \"YEAR\": 2011, \"MIR\": 0.39409321546554565}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2011, \"MIR\": 0.3393803536891937}, {\"AREA\": \"Florida\", \"YEAR\": 2011, \"MIR\": 0.3306567966938019}, {\"AREA\": \"Washington\", \"YEAR\": 2011, \"MIR\": 0.3465285003185272}, {\"AREA\": \"Louisiana\", \"YEAR\": 2011, \"MIR\": 0.38754257559776306}, {\"AREA\": \"Maine\", \"YEAR\": 2011, \"MIR\": 0.37243643403053284}, {\"AREA\": \"Kentucky\", \"YEAR\": 2011, \"MIR\": 0.3829137980937958}, {\"AREA\": \"Oregon\", \"YEAR\": 2011, \"MIR\": 0.37243905663490295}, {\"AREA\": \"Colorado\", \"YEAR\": 2011, \"MIR\": 0.33865290880203247}, {\"AREA\": \"Mississippi\", \"YEAR\": 2011, \"MIR\": 0.4107329249382019}, {\"AREA\": \"Ohio\", \"YEAR\": 2011, \"MIR\": 0.3886665105819702}, {\"AREA\": \"Maryland\", \"YEAR\": 2011, \"MIR\": 0.35837650299072266}, {\"AREA\": \"Kansas\", \"YEAR\": 2011, \"MIR\": 0.3543750047683716}, {\"AREA\": \"Arkansas\", \"YEAR\": 2011, \"MIR\": 0.4256455600261688}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2011, \"MIR\": 0.3420138657093048}, {\"AREA\": \"West Virginia\", \"YEAR\": 2011, \"MIR\": 0.4007234573364258}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2011, \"MIR\": 0.3458089530467987}, {\"AREA\": \"North Dakota\", \"YEAR\": 2011, \"MIR\": 0.3385295867919922}, {\"AREA\": \"Nevada\", \"YEAR\": 2011, \"MIR\": 0.39174312353134155}, {\"AREA\": \"Vermont\", \"YEAR\": 2011, \"MIR\": 0.3683549761772156}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2011, \"MIR\": 0.42068207263946533}, {\"AREA\": \"Georgia\", \"YEAR\": 2011, \"MIR\": 0.3612343966960907}, {\"AREA\": \"Wyoming\", \"YEAR\": 2011, \"MIR\": 0.3545081913471222}, {\"AREA\": \"Montana\", \"YEAR\": 2011, \"MIR\": 0.34469062089920044}, {\"AREA\": \"Hawaii\", \"YEAR\": 2011, \"MIR\": 0.3271736800670624}, {\"AREA\": \"Missouri\", \"YEAR\": 2011, \"MIR\": 0.37842974066734314}, {\"AREA\": \"New Mexico\", \"YEAR\": 2011, \"MIR\": 0.3798549771308899}, {\"AREA\": \"Tennessee\", \"YEAR\": 2011, \"MIR\": 0.3953585922718048}, {\"AREA\": \"Delaware\", \"YEAR\": 2011, \"MIR\": 0.34732162952423096}, {\"AREA\": \"New Jersey\", \"YEAR\": 2011, \"MIR\": 0.32701048254966736}, {\"AREA\": \"South Dakota\", \"YEAR\": 2011, \"MIR\": 0.35094258189201355}, {\"AREA\": \"Idaho\", \"YEAR\": 2011, \"MIR\": 0.3440087139606476}, {\"AREA\": \"Alaska\", \"YEAR\": 2011, \"MIR\": 0.39406028389930725}, {\"AREA\": \"Utah\", \"YEAR\": 2011, \"MIR\": 0.29447564482688904}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2011, \"MIR\": 0.35914772748947144}, {\"AREA\": \"Alabama\", \"YEAR\": 2011, \"MIR\": 0.4075685143470764}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2012, \"MIR\": 0.34388184547424316}, {\"AREA\": \"California\", \"YEAR\": 2012, \"MIR\": 0.35870081186294556}, {\"AREA\": \"Hawaii\", \"YEAR\": 2012, \"MIR\": 0.32005757093429565}, {\"AREA\": \"North Dakota\", \"YEAR\": 2012, \"MIR\": 0.3190002143383026}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2012, \"MIR\": 0.3565022349357605}, {\"AREA\": \"Georgia\", \"YEAR\": 2012, \"MIR\": 0.35961008071899414}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2012, \"MIR\": 0.41697824001312256}, {\"AREA\": \"Montana\", \"YEAR\": 2012, \"MIR\": 0.3423961102962494}, {\"AREA\": \"Texas\", \"YEAR\": 2012, \"MIR\": 0.38249287009239197}, {\"AREA\": \"Arkansas\", \"YEAR\": 2012, \"MIR\": 0.41260120272636414}, {\"AREA\": \"Nebraska\", \"YEAR\": 2012, \"MIR\": 0.36632561683654785}, {\"AREA\": \"Kansas\", \"YEAR\": 2012, \"MIR\": 0.3564146161079407}, {\"AREA\": \"Louisiana\", \"YEAR\": 2012, \"MIR\": 0.3877343237400055}, {\"AREA\": \"Maryland\", \"YEAR\": 2012, \"MIR\": 0.3669988811016083}, {\"AREA\": \"Alabama\", \"YEAR\": 2012, \"MIR\": 0.4046369194984436}, {\"AREA\": \"Tennessee\", \"YEAR\": 2012, \"MIR\": 0.39936307072639465}, {\"AREA\": \"Washington\", \"YEAR\": 2012, \"MIR\": 0.34583422541618347}, {\"AREA\": \"Virginia\", \"YEAR\": 2012, \"MIR\": 0.39239904284477234}, {\"AREA\": \"Ohio\", \"YEAR\": 2012, \"MIR\": 0.3973827660083771}, {\"AREA\": \"Utah\", \"YEAR\": 2012, \"MIR\": 0.31191110610961914}, {\"AREA\": \"Nevada\", \"YEAR\": 2012, \"MIR\": 0.3989322781562805}, {\"AREA\": \"Oregon\", \"YEAR\": 2012, \"MIR\": 0.3816949129104614}, {\"AREA\": \"New Jersey\", \"YEAR\": 2012, \"MIR\": 0.3243353068828583}, {\"AREA\": \"Florida\", \"YEAR\": 2012, \"MIR\": 0.34145814180374146}, {\"AREA\": \"Kentucky\", \"YEAR\": 2012, \"MIR\": 0.3822467625141144}, {\"AREA\": \"Maine\", \"YEAR\": 2012, \"MIR\": 0.3699648976325989}, {\"AREA\": \"Colorado\", \"YEAR\": 2012, \"MIR\": 0.3469879627227783}, {\"AREA\": \"Mississippi\", \"YEAR\": 2012, \"MIR\": 0.42400509119033813}, {\"AREA\": \"West Virginia\", \"YEAR\": 2012, \"MIR\": 0.3959801197052002}, {\"AREA\": \"Wyoming\", \"YEAR\": 2012, \"MIR\": 0.3851907253265381}, {\"AREA\": \"Vermont\", \"YEAR\": 2012, \"MIR\": 0.35497742891311646}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2012, \"MIR\": 0.354002982378006}, {\"AREA\": \"New York\", \"YEAR\": 2012, \"MIR\": 0.3270931839942932}, {\"AREA\": \"South Carolina\", \"YEAR\": 2012, \"MIR\": 0.3823152482509613}, {\"AREA\": \"Idaho\", \"YEAR\": 2012, \"MIR\": 0.34070107340812683}, {\"AREA\": \"Alaska\", \"YEAR\": 2012, \"MIR\": 0.40028220415115356}, {\"AREA\": \"Illinois\", \"YEAR\": 2012, \"MIR\": 0.37244462966918945}, {\"AREA\": \"South Dakota\", \"YEAR\": 2012, \"MIR\": 0.3568935692310333}, {\"AREA\": \"Minnesota\", \"YEAR\": 2012, \"MIR\": 0.3328351676464081}, {\"AREA\": \"Arizona\", \"YEAR\": 2012, \"MIR\": 0.37674179673194885}, {\"AREA\": \"Indiana\", \"YEAR\": 2012, \"MIR\": 0.3973252773284912}, {\"AREA\": \"New Mexico\", \"YEAR\": 2012, \"MIR\": 0.38922470808029175}, {\"AREA\": \"North Carolina\", \"YEAR\": 2012, \"MIR\": 0.36429640650749207}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2012, \"MIR\": 0.3569988012313843}, {\"AREA\": \"Connecticut\", \"YEAR\": 2012, \"MIR\": 0.31123918294906616}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2012, \"MIR\": 0.32326045632362366}, {\"AREA\": \"Missouri\", \"YEAR\": 2012, \"MIR\": 0.3897216320037842}, {\"AREA\": \"Iowa\", \"YEAR\": 2012, \"MIR\": 0.35569193959236145}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2012, \"MIR\": 0.3394811451435089}, {\"AREA\": \"Delaware\", \"YEAR\": 2012, \"MIR\": 0.3490491211414337}, {\"AREA\": \"Michigan\", \"YEAR\": 2012, \"MIR\": 0.3752422034740448}, {\"AREA\": \"Idaho\", \"YEAR\": 2013, \"MIR\": 0.36403611302375793}, {\"AREA\": \"Iowa\", \"YEAR\": 2013, \"MIR\": 0.36002564430236816}, {\"AREA\": \"Louisiana\", \"YEAR\": 2013, \"MIR\": 0.39088085293769836}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2013, \"MIR\": 0.3440404236316681}, {\"AREA\": \"Vermont\", \"YEAR\": 2013, \"MIR\": 0.36482298374176025}, {\"AREA\": \"Georgia\", \"YEAR\": 2013, \"MIR\": 0.363400936126709}, {\"AREA\": \"South Carolina\", \"YEAR\": 2013, \"MIR\": 0.3780381977558136}, {\"AREA\": \"Hawaii\", \"YEAR\": 2013, \"MIR\": 0.31541725993156433}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2013, \"MIR\": 0.38236576318740845}, {\"AREA\": \"Kansas\", \"YEAR\": 2013, \"MIR\": 0.35633188486099243}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2013, \"MIR\": 0.3478958010673523}, {\"AREA\": \"Delaware\", \"YEAR\": 2013, \"MIR\": 0.3246753215789795}, {\"AREA\": \"Virginia\", \"YEAR\": 2013, \"MIR\": 0.3793829083442688}, {\"AREA\": \"Illinois\", \"YEAR\": 2013, \"MIR\": 0.3673819601535797}, {\"AREA\": \"Oregon\", \"YEAR\": 2013, \"MIR\": 0.36353591084480286}, {\"AREA\": \"Florida\", \"YEAR\": 2013, \"MIR\": 0.3288973271846771}, {\"AREA\": \"South Dakota\", \"YEAR\": 2013, \"MIR\": 0.33107247948646545}, {\"AREA\": \"Colorado\", \"YEAR\": 2013, \"MIR\": 0.3406432867050171}, {\"AREA\": \"Utah\", \"YEAR\": 2013, \"MIR\": 0.31886935234069824}, {\"AREA\": \"Tennessee\", \"YEAR\": 2013, \"MIR\": 0.3987124562263489}, {\"AREA\": \"Connecticut\", \"YEAR\": 2013, \"MIR\": 0.30621612071990967}, {\"AREA\": \"Texas\", \"YEAR\": 2013, \"MIR\": 0.37896254658699036}, {\"AREA\": \"California\", \"YEAR\": 2013, \"MIR\": 0.35574838519096375}, {\"AREA\": \"Kentucky\", \"YEAR\": 2013, \"MIR\": 0.38143542408943176}, {\"AREA\": \"Indiana\", \"YEAR\": 2013, \"MIR\": 0.38794034719467163}, {\"AREA\": \"Maryland\", \"YEAR\": 2013, \"MIR\": 0.35200342535972595}, {\"AREA\": \"Arkansas\", \"YEAR\": 2013, \"MIR\": 0.40637704730033875}, {\"AREA\": \"New Mexico\", \"YEAR\": 2013, \"MIR\": 0.38366273045539856}, {\"AREA\": \"Missouri\", \"YEAR\": 2013, \"MIR\": 0.3941926956176758}, {\"AREA\": \"North Carolina\", \"YEAR\": 2013, \"MIR\": 0.3550295829772949}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2013, \"MIR\": 0.34590378403663635}, {\"AREA\": \"Mississippi\", \"YEAR\": 2013, \"MIR\": 0.4184713363647461}, {\"AREA\": \"Alaska\", \"YEAR\": 2013, \"MIR\": 0.40731191635131836}, {\"AREA\": \"Montana\", \"YEAR\": 2013, \"MIR\": 0.34343209862709045}, {\"AREA\": \"New York\", \"YEAR\": 2013, \"MIR\": 0.3130171597003937}, {\"AREA\": \"Ohio\", \"YEAR\": 2013, \"MIR\": 0.3825431168079376}, {\"AREA\": \"Alabama\", \"YEAR\": 2013, \"MIR\": 0.40425530076026917}, {\"AREA\": \"West Virginia\", \"YEAR\": 2013, \"MIR\": 0.3948952257633209}, {\"AREA\": \"North Dakota\", \"YEAR\": 2013, \"MIR\": 0.33503326773643494}, {\"AREA\": \"Michigan\", \"YEAR\": 2013, \"MIR\": 0.37544092535972595}, {\"AREA\": \"New Jersey\", \"YEAR\": 2013, \"MIR\": 0.3148222863674164}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2013, \"MIR\": 0.3511563837528229}, {\"AREA\": \"Wyoming\", \"YEAR\": 2013, \"MIR\": 0.382557213306427}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2013, \"MIR\": 0.4104263186454773}, {\"AREA\": \"Minnesota\", \"YEAR\": 2013, \"MIR\": 0.3385484516620636}, {\"AREA\": \"Arizona\", \"YEAR\": 2013, \"MIR\": 0.3726927638053894}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2013, \"MIR\": 0.3184469938278198}, {\"AREA\": \"Nebraska\", \"YEAR\": 2013, \"MIR\": 0.35274797677993774}, {\"AREA\": \"Nevada\", \"YEAR\": 2013, \"MIR\": 0.4031083285808563}, {\"AREA\": \"Maine\", \"YEAR\": 2013, \"MIR\": 0.3711252808570862}, {\"AREA\": \"Washington\", \"YEAR\": 2013, \"MIR\": 0.34159600734710693}, {\"AREA\": \"Idaho\", \"YEAR\": 2014, \"MIR\": 0.3540583550930023}, {\"AREA\": \"Mississippi\", \"YEAR\": 2014, \"MIR\": 0.4083139896392822}, {\"AREA\": \"Michigan\", \"YEAR\": 2014, \"MIR\": 0.38660138845443726}, {\"AREA\": \"South Carolina\", \"YEAR\": 2014, \"MIR\": 0.37399259209632874}, {\"AREA\": \"Alaska\", \"YEAR\": 2014, \"MIR\": 0.3806004822254181}, {\"AREA\": \"Illinois\", \"YEAR\": 2014, \"MIR\": 0.3585428297519684}, {\"AREA\": \"Vermont\", \"YEAR\": 2014, \"MIR\": 0.3604353070259094}, {\"AREA\": \"New York\", \"YEAR\": 2014, \"MIR\": 0.3101109564304352}, {\"AREA\": \"Connecticut\", \"YEAR\": 2014, \"MIR\": 0.3081333637237549}, {\"AREA\": \"Arizona\", \"YEAR\": 2014, \"MIR\": 0.3599699139595032}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2014, \"MIR\": 0.39404553174972534}, {\"AREA\": \"New Mexico\", \"YEAR\": 2014, \"MIR\": 0.37219613790512085}, {\"AREA\": \"Nevada\", \"YEAR\": 2014, \"MIR\": 0.41485369205474854}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2014, \"MIR\": 0.383504718542099}, {\"AREA\": \"Texas\", \"YEAR\": 2014, \"MIR\": 0.3712978661060333}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2014, \"MIR\": 0.3312564790248871}, {\"AREA\": \"Florida\", \"YEAR\": 2014, \"MIR\": 0.3265785276889801}, {\"AREA\": \"Wyoming\", \"YEAR\": 2014, \"MIR\": 0.34928110241889954}, {\"AREA\": \"Nebraska\", \"YEAR\": 2014, \"MIR\": 0.35206905007362366}, {\"AREA\": \"Georgia\", \"YEAR\": 2014, \"MIR\": 0.35517609119415283}, {\"AREA\": \"Montana\", \"YEAR\": 2014, \"MIR\": 0.35031136870384216}, {\"AREA\": \"New Jersey\", \"YEAR\": 2014, \"MIR\": 0.32023856043815613}, {\"AREA\": \"Tennessee\", \"YEAR\": 2014, \"MIR\": 0.40340909361839294}, {\"AREA\": \"Alabama\", \"YEAR\": 2014, \"MIR\": 0.4003150165081024}, {\"AREA\": \"Utah\", \"YEAR\": 2014, \"MIR\": 0.31576353311538696}, {\"AREA\": \"Hawaii\", \"YEAR\": 2014, \"MIR\": 0.3363370895385742}, {\"AREA\": \"Delaware\", \"YEAR\": 2014, \"MIR\": 0.336352676153183}, {\"AREA\": \"Missouri\", \"YEAR\": 2014, \"MIR\": 0.38593819737434387}, {\"AREA\": \"South Dakota\", \"YEAR\": 2014, \"MIR\": 0.3518912196159363}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2014, \"MIR\": 0.34369057416915894}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2014, \"MIR\": 0.33487996459007263}, {\"AREA\": \"Minnesota\", \"YEAR\": 2014, \"MIR\": 0.33253589272499084}, {\"AREA\": \"Iowa\", \"YEAR\": 2014, \"MIR\": 0.3431757092475891}, {\"AREA\": \"Colorado\", \"YEAR\": 2014, \"MIR\": 0.33818089962005615}, {\"AREA\": \"North Carolina\", \"YEAR\": 2014, \"MIR\": 0.36018654704093933}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2014, \"MIR\": 0.34744197130203247}, {\"AREA\": \"West Virginia\", \"YEAR\": 2014, \"MIR\": 0.4068720042705536}, {\"AREA\": \"North Dakota\", \"YEAR\": 2014, \"MIR\": 0.3372557759284973}, {\"AREA\": \"Washington\", \"YEAR\": 2014, \"MIR\": 0.34366071224212646}, {\"AREA\": \"Ohio\", \"YEAR\": 2014, \"MIR\": 0.3811158835887909}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2014, \"MIR\": 0.3370297849178314}, {\"AREA\": \"Kentucky\", \"YEAR\": 2014, \"MIR\": 0.37832698225975037}, {\"AREA\": \"Arkansas\", \"YEAR\": 2014, \"MIR\": 0.38886526226997375}, {\"AREA\": \"Virginia\", \"YEAR\": 2014, \"MIR\": 0.38017892837524414}, {\"AREA\": \"California\", \"YEAR\": 2014, \"MIR\": 0.35342732071876526}, {\"AREA\": \"Maine\", \"YEAR\": 2014, \"MIR\": 0.3519286513328552}, {\"AREA\": \"Indiana\", \"YEAR\": 2014, \"MIR\": 0.3863001763820648}, {\"AREA\": \"Maryland\", \"YEAR\": 2014, \"MIR\": 0.35730040073394775}, {\"AREA\": \"Louisiana\", \"YEAR\": 2014, \"MIR\": 0.38317179679870605}, {\"AREA\": \"Kansas\", \"YEAR\": 2014, \"MIR\": 0.3667546212673187}, {\"AREA\": \"Oregon\", \"YEAR\": 2014, \"MIR\": 0.3604547381401062}, {\"AREA\": \"Utah\", \"YEAR\": 2015, \"MIR\": 0.30857279896736145}, {\"AREA\": \"Arkansas\", \"YEAR\": 2015, \"MIR\": 0.38506224751472473}, {\"AREA\": \"Missouri\", \"YEAR\": 2015, \"MIR\": 0.37630435824394226}, {\"AREA\": \"Virginia\", \"YEAR\": 2015, \"MIR\": 0.3843930661678314}, {\"AREA\": \"New Jersey\", \"YEAR\": 2015, \"MIR\": 0.3058321475982666}, {\"AREA\": \"Tennessee\", \"YEAR\": 2015, \"MIR\": 0.3826821446418762}, {\"AREA\": \"Oregon\", \"YEAR\": 2015, \"MIR\": 0.3633916676044464}, {\"AREA\": \"Alabama\", \"YEAR\": 2015, \"MIR\": 0.3856108784675598}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2015, \"MIR\": 0.3382231295108795}, {\"AREA\": \"Georgia\", \"YEAR\": 2015, \"MIR\": 0.3476695120334625}, {\"AREA\": \"Montana\", \"YEAR\": 2015, \"MIR\": 0.33908048272132874}, {\"AREA\": \"Washington\", \"YEAR\": 2015, \"MIR\": 0.35831063985824585}, {\"AREA\": \"Nebraska\", \"YEAR\": 2015, \"MIR\": 0.3408699631690979}, {\"AREA\": \"Maine\", \"YEAR\": 2015, \"MIR\": 0.3732409179210663}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2015, \"MIR\": 0.3368004858493805}, {\"AREA\": \"Florida\", \"YEAR\": 2015, \"MIR\": 0.3181052803993225}, {\"AREA\": \"Kentucky\", \"YEAR\": 2015, \"MIR\": 0.374022513628006}, {\"AREA\": \"California\", \"YEAR\": 2015, \"MIR\": 0.3511803448200226}, {\"AREA\": \"Wyoming\", \"YEAR\": 2015, \"MIR\": 0.35273277759552}, {\"AREA\": \"Texas\", \"YEAR\": 2015, \"MIR\": 0.36500242352485657}, {\"AREA\": \"Louisiana\", \"YEAR\": 2015, \"MIR\": 0.3720785677433014}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2015, \"MIR\": 0.39259079098701477}, {\"AREA\": \"Nevada\", \"YEAR\": 2015, \"MIR\": 0.41699451208114624}, {\"AREA\": \"Ohio\", \"YEAR\": 2015, \"MIR\": 0.3677798807621002}, {\"AREA\": \"Hawaii\", \"YEAR\": 2015, \"MIR\": 0.32247164845466614}, {\"AREA\": \"Kansas\", \"YEAR\": 2015, \"MIR\": 0.35197436809539795}, {\"AREA\": \"Delaware\", \"YEAR\": 2015, \"MIR\": 0.33320000767707825}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2015, \"MIR\": 0.40112996101379395}, {\"AREA\": \"Minnesota\", \"YEAR\": 2015, \"MIR\": 0.3194184899330139}, {\"AREA\": \"Vermont\", \"YEAR\": 2015, \"MIR\": 0.37055161595344543}, {\"AREA\": \"Alaska\", \"YEAR\": 2015, \"MIR\": 0.3744441866874695}, {\"AREA\": \"New York\", \"YEAR\": 2015, \"MIR\": 0.3025071918964386}, {\"AREA\": \"West Virginia\", \"YEAR\": 2015, \"MIR\": 0.3913942873477936}, {\"AREA\": \"South Carolina\", \"YEAR\": 2015, \"MIR\": 0.35554608702659607}, {\"AREA\": \"Iowa\", \"YEAR\": 2015, \"MIR\": 0.3408433198928833}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2015, \"MIR\": 0.32846400141716003}, {\"AREA\": \"Connecticut\", \"YEAR\": 2015, \"MIR\": 0.30707159638404846}, {\"AREA\": \"Colorado\", \"YEAR\": 2015, \"MIR\": 0.34113794565200806}, {\"AREA\": \"Idaho\", \"YEAR\": 2015, \"MIR\": 0.34261101484298706}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2015, \"MIR\": 0.34052953124046326}, {\"AREA\": \"Mississippi\", \"YEAR\": 2015, \"MIR\": 0.40025413036346436}, {\"AREA\": \"North Dakota\", \"YEAR\": 2015, \"MIR\": 0.33501535654067993}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2015, \"MIR\": 0.3396785259246826}, {\"AREA\": \"New Mexico\", \"YEAR\": 2015, \"MIR\": 0.37578287720680237}, {\"AREA\": \"Indiana\", \"YEAR\": 2015, \"MIR\": 0.37420448660850525}, {\"AREA\": \"Michigan\", \"YEAR\": 2015, \"MIR\": 0.3705337643623352}, {\"AREA\": \"Arizona\", \"YEAR\": 2015, \"MIR\": 0.3623409569263458}, {\"AREA\": \"North Carolina\", \"YEAR\": 2015, \"MIR\": 0.3463956415653229}, {\"AREA\": \"South Dakota\", \"YEAR\": 2015, \"MIR\": 0.34740114212036133}, {\"AREA\": \"Maryland\", \"YEAR\": 2015, \"MIR\": 0.3391532003879547}, {\"AREA\": \"Illinois\", \"YEAR\": 2015, \"MIR\": 0.35249364376068115}, {\"AREA\": \"West Virginia\", \"YEAR\": 2016, \"MIR\": 0.3773898482322693}, {\"AREA\": \"Wyoming\", \"YEAR\": 2016, \"MIR\": 0.34665679931640625}, {\"AREA\": \"Vermont\", \"YEAR\": 2016, \"MIR\": 0.3473983407020569}, {\"AREA\": \"Colorado\", \"YEAR\": 2016, \"MIR\": 0.34863772988319397}, {\"AREA\": \"Washington\", \"YEAR\": 2016, \"MIR\": 0.3392658531665802}, {\"AREA\": \"Delaware\", \"YEAR\": 2016, \"MIR\": 0.34601375460624695}, {\"AREA\": \"Arkansas\", \"YEAR\": 2016, \"MIR\": 0.37332776188850403}, {\"AREA\": \"Connecticut\", \"YEAR\": 2016, \"MIR\": 0.3035714328289032}, {\"AREA\": \"California\", \"YEAR\": 2016, \"MIR\": 0.3495531380176544}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2016, \"MIR\": 0.33579573035240173}, {\"AREA\": \"Utah\", \"YEAR\": 2016, \"MIR\": 0.31002506613731384}, {\"AREA\": \"Arizona\", \"YEAR\": 2016, \"MIR\": 0.35701367259025574}, {\"AREA\": \"Virginia\", \"YEAR\": 2016, \"MIR\": 0.3738340139389038}, {\"AREA\": \"Alabama\", \"YEAR\": 2016, \"MIR\": 0.3763510584831238}, {\"AREA\": \"Alaska\", \"YEAR\": 2016, \"MIR\": 0.3793348968029022}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2016, \"MIR\": 0.38664016127586365}, {\"AREA\": \"Nevada\", \"YEAR\": 2016, \"MIR\": 0.3987990617752075}, {\"AREA\": \"Louisiana\", \"YEAR\": 2016, \"MIR\": 0.35899582505226135}, {\"AREA\": \"South Carolina\", \"YEAR\": 2016, \"MIR\": 0.37012559175491333}, {\"AREA\": \"Illinois\", \"YEAR\": 2016, \"MIR\": 0.34414759278297424}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2016, \"MIR\": 0.3359474539756775}, {\"AREA\": \"Indiana\", \"YEAR\": 2016, \"MIR\": 0.3665957450866699}, {\"AREA\": \"Iowa\", \"YEAR\": 2016, \"MIR\": 0.3278084695339203}, {\"AREA\": \"Missouri\", \"YEAR\": 2016, \"MIR\": 0.3683977723121643}, {\"AREA\": \"Michigan\", \"YEAR\": 2016, \"MIR\": 0.35983535647392273}, {\"AREA\": \"New Mexico\", \"YEAR\": 2016, \"MIR\": 0.3678251802921295}, {\"AREA\": \"Kansas\", \"YEAR\": 2016, \"MIR\": 0.34677422046661377}, {\"AREA\": \"Oregon\", \"YEAR\": 2016, \"MIR\": 0.36685290932655334}, {\"AREA\": \"Kentucky\", \"YEAR\": 2016, \"MIR\": 0.37377241253852844}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2016, \"MIR\": 0.3924245536327362}, {\"AREA\": \"Maine\", \"YEAR\": 2016, \"MIR\": 0.35249844193458557}, {\"AREA\": \"Mississippi\", \"YEAR\": 2016, \"MIR\": 0.3931106626987457}, {\"AREA\": \"Ohio\", \"YEAR\": 2016, \"MIR\": 0.3715999126434326}, {\"AREA\": \"New York\", \"YEAR\": 2016, \"MIR\": 0.30179715156555176}, {\"AREA\": \"Maryland\", \"YEAR\": 2016, \"MIR\": 0.3452983796596527}, {\"AREA\": \"North Dakota\", \"YEAR\": 2016, \"MIR\": 0.31156110763549805}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2016, \"MIR\": 0.31853896379470825}, {\"AREA\": \"Minnesota\", \"YEAR\": 2016, \"MIR\": 0.32053205370903015}, {\"AREA\": \"North Carolina\", \"YEAR\": 2016, \"MIR\": 0.34329307079315186}, {\"AREA\": \"New Jersey\", \"YEAR\": 2016, \"MIR\": 0.3059426248073578}, {\"AREA\": \"Montana\", \"YEAR\": 2016, \"MIR\": 0.3161042332649231}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2016, \"MIR\": 0.33730241656303406}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2016, \"MIR\": 0.3342164158821106}, {\"AREA\": \"Hawaii\", \"YEAR\": 2016, \"MIR\": 0.3052304685115814}, {\"AREA\": \"South Dakota\", \"YEAR\": 2016, \"MIR\": 0.34404456615448}, {\"AREA\": \"Georgia\", \"YEAR\": 2016, \"MIR\": 0.33781513571739197}, {\"AREA\": \"Texas\", \"YEAR\": 2016, \"MIR\": 0.36719706654548645}, {\"AREA\": \"Florida\", \"YEAR\": 2016, \"MIR\": 0.3131248652935028}, {\"AREA\": \"Idaho\", \"YEAR\": 2016, \"MIR\": 0.3373042047023773}, {\"AREA\": \"Nebraska\", \"YEAR\": 2016, \"MIR\": 0.3288547694683075}, {\"AREA\": \"Tennessee\", \"YEAR\": 2016, \"MIR\": 0.38461539149284363}, {\"AREA\": \"Ohio\", \"YEAR\": 2017, \"MIR\": 0.3664171099662781}, {\"AREA\": \"Tennessee\", \"YEAR\": 2017, \"MIR\": 0.3646292984485626}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2017, \"MIR\": 0.34858185052871704}, {\"AREA\": \"Louisiana\", \"YEAR\": 2017, \"MIR\": 0.36365529894828796}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2017, \"MIR\": 0.40045300126075745}, {\"AREA\": \"Wyoming\", \"YEAR\": 2017, \"MIR\": 0.32897287607192993}, {\"AREA\": \"Kentucky\", \"YEAR\": 2017, \"MIR\": 0.36037954688072205}, {\"AREA\": \"Mississippi\", \"YEAR\": 2017, \"MIR\": 0.3850683569908142}, {\"AREA\": \"Washington\", \"YEAR\": 2017, \"MIR\": 0.33919599652290344}, {\"AREA\": \"Connecticut\", \"YEAR\": 2017, \"MIR\": 0.2994217276573181}, {\"AREA\": \"Arkansas\", \"YEAR\": 2017, \"MIR\": 0.36375075578689575}, {\"AREA\": \"Maine\", \"YEAR\": 2017, \"MIR\": 0.35587188601493835}, {\"AREA\": \"Nebraska\", \"YEAR\": 2017, \"MIR\": 0.32293424010276794}, {\"AREA\": \"Florida\", \"YEAR\": 2017, \"MIR\": 0.3217449188232422}, {\"AREA\": \"Maryland\", \"YEAR\": 2017, \"MIR\": 0.3344348967075348}, {\"AREA\": \"New York\", \"YEAR\": 2017, \"MIR\": 0.2917095422744751}, {\"AREA\": \"Alaska\", \"YEAR\": 2017, \"MIR\": 0.3375180959701538}, {\"AREA\": \"Arizona\", \"YEAR\": 2017, \"MIR\": 0.3517600893974304}, {\"AREA\": \"North Dakota\", \"YEAR\": 2017, \"MIR\": 0.30630242824554443}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2017, \"MIR\": 0.3229706585407257}, {\"AREA\": \"Texas\", \"YEAR\": 2017, \"MIR\": 0.35949307680130005}, {\"AREA\": \"North Carolina\", \"YEAR\": 2017, \"MIR\": 0.3354659974575043}, {\"AREA\": \"West Virginia\", \"YEAR\": 2017, \"MIR\": 0.3631739616394043}, {\"AREA\": \"Minnesota\", \"YEAR\": 2017, \"MIR\": 0.3054749071598053}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2017, \"MIR\": 0.3184265196323395}, {\"AREA\": \"Georgia\", \"YEAR\": 2017, \"MIR\": 0.3329051434993744}, {\"AREA\": \"Hawaii\", \"YEAR\": 2017, \"MIR\": 0.30328837037086487}, {\"AREA\": \"Idaho\", \"YEAR\": 2017, \"MIR\": 0.3417186141014099}, {\"AREA\": \"New Jersey\", \"YEAR\": 2017, \"MIR\": 0.2982384264469147}, {\"AREA\": \"South Carolina\", \"YEAR\": 2017, \"MIR\": 0.3681231737136841}, {\"AREA\": \"South Dakota\", \"YEAR\": 2017, \"MIR\": 0.3446093201637268}, {\"AREA\": \"Montana\", \"YEAR\": 2017, \"MIR\": 0.32064759731292725}, {\"AREA\": \"Illinois\", \"YEAR\": 2017, \"MIR\": 0.33983704447746277}, {\"AREA\": \"Vermont\", \"YEAR\": 2017, \"MIR\": 0.35208556056022644}, {\"AREA\": \"Nevada\", \"YEAR\": 2017, \"MIR\": 0.37799274921417236}, {\"AREA\": \"Alabama\", \"YEAR\": 2017, \"MIR\": 0.3763035237789154}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2017, \"MIR\": 0.33859995007514954}, {\"AREA\": \"California\", \"YEAR\": 2017, \"MIR\": 0.3434999883174896}, {\"AREA\": \"Colorado\", \"YEAR\": 2017, \"MIR\": 0.3296482264995575}, {\"AREA\": \"Indiana\", \"YEAR\": 2017, \"MIR\": 0.3748626708984375}, {\"AREA\": \"Michigan\", \"YEAR\": 2017, \"MIR\": 0.365158349275589}, {\"AREA\": \"Missouri\", \"YEAR\": 2017, \"MIR\": 0.36345863342285156}, {\"AREA\": \"Oregon\", \"YEAR\": 2017, \"MIR\": 0.3595714867115021}, {\"AREA\": \"New Mexico\", \"YEAR\": 2017, \"MIR\": 0.3728129267692566}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2017, \"MIR\": 0.32813167572021484}, {\"AREA\": \"Virginia\", \"YEAR\": 2017, \"MIR\": 0.3777557611465454}, {\"AREA\": \"Utah\", \"YEAR\": 2017, \"MIR\": 0.30089375376701355}, {\"AREA\": \"Kansas\", \"YEAR\": 2017, \"MIR\": 0.34010371565818787}, {\"AREA\": \"Iowa\", \"YEAR\": 2017, \"MIR\": 0.32404181361198425}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2017, \"MIR\": 0.33796003460884094}, {\"AREA\": \"Delaware\", \"YEAR\": 2017, \"MIR\": 0.3513336181640625}, {\"AREA\": \"Missouri\", \"YEAR\": 2018, \"MIR\": 0.3839181959629059}, {\"AREA\": \"Alaska\", \"YEAR\": 2018, \"MIR\": 0.35512852668762207}, {\"AREA\": \"New Jersey\", \"YEAR\": 2018, \"MIR\": 0.2936028242111206}, {\"AREA\": \"Minnesota\", \"YEAR\": 2018, \"MIR\": 0.3126772940158844}, {\"AREA\": \"Montana\", \"YEAR\": 2018, \"MIR\": 0.31193268299102783}, {\"AREA\": \"Wisconsin\", \"YEAR\": 2018, \"MIR\": 0.33238449692726135}, {\"AREA\": \"Mississippi\", \"YEAR\": 2018, \"MIR\": 0.38162916898727417}, {\"AREA\": \"New York\", \"YEAR\": 2018, \"MIR\": 0.2918255031108856}, {\"AREA\": \"Alabama\", \"YEAR\": 2018, \"MIR\": 0.3866061270236969}, {\"AREA\": \"Michigan\", \"YEAR\": 2018, \"MIR\": 0.36815693974494934}, {\"AREA\": \"Nebraska\", \"YEAR\": 2018, \"MIR\": 0.31567928194999695}, {\"AREA\": \"New Hampshire\", \"YEAR\": 2018, \"MIR\": 0.3137340247631073}, {\"AREA\": \"New Mexico\", \"YEAR\": 2018, \"MIR\": 0.3904109597206116}, {\"AREA\": \"District of Columbia\", \"YEAR\": 2018, \"MIR\": 0.3720373213291168}, {\"AREA\": \"North Carolina\", \"YEAR\": 2018, \"MIR\": 0.3385256826877594}, {\"AREA\": \"Rhode Island\", \"YEAR\": 2018, \"MIR\": 0.332092821598053}, {\"AREA\": \"Illinois\", \"YEAR\": 2018, \"MIR\": 0.3382515013217926}, {\"AREA\": \"Vermont\", \"YEAR\": 2018, \"MIR\": 0.3521190285682678}, {\"AREA\": \"South Carolina\", \"YEAR\": 2018, \"MIR\": 0.36928486824035645}, {\"AREA\": \"Idaho\", \"YEAR\": 2018, \"MIR\": 0.349476158618927}, {\"AREA\": \"Connecticut\", \"YEAR\": 2018, \"MIR\": 0.3007165193557739}, {\"AREA\": \"Colorado\", \"YEAR\": 2018, \"MIR\": 0.33109501004219055}, {\"AREA\": \"South Dakota\", \"YEAR\": 2018, \"MIR\": 0.32508912682533264}, {\"AREA\": \"Delaware\", \"YEAR\": 2018, \"MIR\": 0.35095837712287903}, {\"AREA\": \"Utah\", \"YEAR\": 2018, \"MIR\": 0.2960784435272217}, {\"AREA\": \"Georgia\", \"YEAR\": 2018, \"MIR\": 0.3326077461242676}, {\"AREA\": \"Tennessee\", \"YEAR\": 2018, \"MIR\": 0.3707295358181}, {\"AREA\": \"Florida\", \"YEAR\": 2018, \"MIR\": 0.32275012135505676}, {\"AREA\": \"Texas\", \"YEAR\": 2018, \"MIR\": 0.3504273593425751}, {\"AREA\": \"Hawaii\", \"YEAR\": 2018, \"MIR\": 0.29909953474998474}, {\"AREA\": \"Indiana\", \"YEAR\": 2018, \"MIR\": 0.3873600959777832}, {\"AREA\": \"Pennsylvania\", \"YEAR\": 2018, \"MIR\": 0.3398522138595581}, {\"AREA\": \"Iowa\", \"YEAR\": 2018, \"MIR\": 0.32667645812034607}, {\"AREA\": \"Massachusetts\", \"YEAR\": 2018, \"MIR\": 0.33623120188713074}, {\"AREA\": \"Arizona\", \"YEAR\": 2018, \"MIR\": 0.3585982024669647}, {\"AREA\": \"North Dakota\", \"YEAR\": 2018, \"MIR\": 0.33455798029899597}, {\"AREA\": \"Maryland\", \"YEAR\": 2018, \"MIR\": 0.33836790919303894}, {\"AREA\": \"Maine\", \"YEAR\": 2018, \"MIR\": 0.34628596901893616}, {\"AREA\": \"Arkansas\", \"YEAR\": 2018, \"MIR\": 0.34703949093818665}, {\"AREA\": \"Washington\", \"YEAR\": 2018, \"MIR\": 0.33820798993110657}, {\"AREA\": \"Ohio\", \"YEAR\": 2018, \"MIR\": 0.35805684328079224}, {\"AREA\": \"Louisiana\", \"YEAR\": 2018, \"MIR\": 0.3471023142337799}, {\"AREA\": \"Oklahoma\", \"YEAR\": 2018, \"MIR\": 0.40528231859207153}, {\"AREA\": \"Kentucky\", \"YEAR\": 2018, \"MIR\": 0.36114421486854553}, {\"AREA\": \"California\", \"YEAR\": 2018, \"MIR\": 0.34835222363471985}, {\"AREA\": \"Oregon\", \"YEAR\": 2018, \"MIR\": 0.3749068081378937}, {\"AREA\": \"Kansas\", \"YEAR\": 2018, \"MIR\": 0.3529147207736969}, {\"AREA\": \"Virginia\", \"YEAR\": 2018, \"MIR\": 0.3785153031349182}, {\"AREA\": \"West Virginia\", \"YEAR\": 2018, \"MIR\": 0.36857321858406067}, {\"AREA\": \"Wyoming\", \"YEAR\": 2018, \"MIR\": 0.35676226019859314}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.LayerChart(...)"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "states = byarea[\"AREA\"].unique()\n",
    "states.sort()\n",
    "state_dropdown = alt.binding_select(options=states)\n",
    "state_select = alt.selection_single(fields=['AREA'], bind=state_dropdown, name=\"State\")\n",
    "state_color_condition = alt.condition(state_select, alt.Color('AREA:N', legend=None), alt.value('lightgray'))\n",
    "background_chart = alt.Chart(byarea).mark_line().encode(\n",
    "    x=alt.X(\"YEAR\", scale=alt.Scale(domain=[1999,2018])),\n",
    "    y=alt.Y('MIR', scale=alt.Scale(domain=[0.275, 0.55])),\n",
    "    detail=\"AREA\",\n",
    "    tooltip=\"AREA\",\n",
    "    color = alt.value(\"lightgray\")\n",
    ")\n",
    "\n",
    "selected_state = alt.Chart(byarea).mark_line().encode(\n",
    "    x=alt.X(\"YEAR\", scale=alt.Scale(domain=[1999,2018])),\n",
    "    y=alt.Y('MIR', scale=alt.Scale(domain=[0.275, 0.55])),\n",
    "    detail=\"AREA\",\n",
    "    tooltip=\"AREA\",\n",
    "    color=\"AREA\"\n",
    ").add_selection(\n",
    "    state_select\n",
    ").transform_filter(\n",
    "    state_select\n",
    ")\n",
    "\n",
    "background_chart + selected_state"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "type object 'Utils' has no attribute '_strip_county_name'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m~\\AppData\\Local\\Temp/ipykernel_14212/2215082615.py\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0mby_county\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mUtils\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mremove_rows\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mby_county\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;34m\"~\"\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m\"+\"\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m\"-\"\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m\"~\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mby_county\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"AREA\"\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mby_county\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"AREA\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mUtils\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_strip_county_name\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: type object 'Utils' has no attribute '_strip_county_name'"
     ]
    }
   ],
   "source": [
    "by_county = Utils.remove_rows(by_county, [\"~\",\"+\",\"-\",\"~\"])\n",
    "by_county.loc[:, \"AREA\"] = by_county.loc[:, \"AREA\"].apply(Utils._strip_county_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAC4CAYAAADt9yebAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAvZ0lEQVR4nO2deZRcV3ngf1+tvW9SS7K61erG+25wWwLMgE3CJjt2CPEZwxhICOOQhDnMcDgGH7JMCE6Yw5BxWA6x4rCNcRwnOR6McbCNidiNFkuWJVvW2tpaUkvqTb1WV9c3f9Sr7uruqq7lvXrvVdX9nSN1veXe+7377vve975773dFVTEYDAZD5RLwWgCDwWAwlBaj6A0Gg6HCMYreYDAYKhyj6A0Gg6HCMYreYDAYKpyQ1wJkYuXKldrd3e21GAaDwVA27Nix45yqtmc65ktF393dzfbt270Ww2AwGMoGETma7Zhx3RgMBkOFYxS9wWAwVDh5K3oRCYrIThF5ytr+KxHZLSK7RORZEVmbJd27ReQ1ETkoIp9xSnCDwWAw5EchFv0ngFfTtr+oqtep6g3AU8CfL04gIkHga8B7gKuA94vIVcWLazAYDIZCyUvRi0gncBvwcGqfqo6mnVIPZAqaswE4qKqHVTUGPAbcWby4BoPBYCiUfEfdPAjcBzSm7xSRB4APASPArRnSdQDH07ZPABszFSAi9wL3AnR1deUp1kKOD07w5ecP5DwvnzBuNaEAU/HEgn2S/lvS98vSfeknZzoOtNSGGZmaWZJP+rkLy1yQ6aLzspRRF2FkMrYgvaRlvDhdKnmmfOeyTs9nGRmWHM8g/3JkCri3eFeme7n4HBFIZAne50RMv2LbU36ZL8xdsxzStCPv39BFZ2td4WUZKpacil5EbgcGVHWHiNySfkxVPwt8VkTuBz4O/MXi5BmyzPhcqOpmYDNAb29vUY/f0ESMf9lxopikS4iGAkwX82AWwPWdzbx0YqSkZWzoaWXrkaGSluF3ilayDnJxez2Hzo67UlYsnuCztxkPqWGefFw3NwN3iEgfSdfL20XkkUXnPAq8L0PaE8C6tO1OoL8IOV1nOp6gLlz+g5Ik47vW4DaFfs3Y4ZEXjrGtb9C18gz+J6cmU9X7VbVTVbuBu4Efq+o9InJp2ml3APsyJN8GXCoiPSISsdI/6YDcrtBcFylp/i4++waPcfNeT87M8vvf3MaPXjnDzKy3XzIGf2BnZuwXRORyIAEcBT4GYA2zfFhVN6lqXEQ+DjwDBIFvqOpeu0Jnw2nrtbEmxKkSelbcWPIlm2/a4C5uv9PHpuN89DvbaawJ8YGNXfzxLZfQXBt2WQqDXyhI0avqFmCL9TuTqwZV7Qc2pW0/DTxdtIQeUhMOljR/N9wqswmj6P1AIIdJXxMKcF1nMwA7jw8zM+vMfbswFeehnxzmsa3H+eRvXsbdG9cRDZW2XRv8R/k7oUtINFTi6nFBBzulMAz2yKbnVzZE2NjTRjgUYGvfEFv7huhsraWjpcbR8kcmZ3h8xzFu/eIWvvL8AfqHJwvOY+exIfrOjRdlPBw4c4EdRwe5MDVDfDbBrw+f5+DAWMaRVQbn8WVQM7+QywqzjQvf8zHjo2U2obQ3Rjl7YdozGRZ/vXWvqGNFfZSXTgzz6yMLO06PnJugLhJkQ3crZ8diHD0/jhMfZiIB+kem+NJz+/nSc/vpXd/KbdddxJ03dNBWv3x/1DN7T/OH/3cHADXhAFesaeLqtU1ceVETsXiCg2fHOHhmjBNDE4SCAWrDQZprw2zoaWMmkeCbv+gjZo18qosEmYjNArC6Kcp3P/pGLlnVYP8CDVmpKEXvtF6uBGNjembWaxE8ZyahNERCrO2sKflw1myk2ua1HU3MJuCVU6P0nZ/Iev5EbJatfclhsdFQgPUr6mipjTCbSHB6dJqTRVjkgUXPx/ajQ2w/OsQ3fnGERz/6Rta1ZR97/8gL84ERp2YS7Do+zK7jwznLVJRtfQuH96aUPMCZ0Wn+5ulX+YcP9RJYLKDBMYzrZhniidJaw26MxJiaMRY9QENNkJdOjHBTdyvrWmtdLXtday3tDVHWtdXy8slRXjk1mjtRGtPxBPvPjLG1b5Adx4Y5OTxJYzTEtR1NXL46f0s4W3M7PjjJf37oV7x2+kLG44fPjvGzA+cKkrkQnt83wEe/s52RiZncJxuKoqIseqcp9YSpU8OTJZ9IMx6LlyzvcqI2kuyATFmXDZEg61fW0RANMzUzy4mhSc6Pxxwpq7k2xMXtDQREODo4wfGhSY4PTdJU49zjdmE6zssnky+M6zqakQBMxRJcmJ5heDzGRIYX/HJfqP0jU7zv67/kqx94Pbdcvmpu/97+ET7yrW2OyZ2NH+8b4Le++nO+fs8buHptc8nLqzaMoveQ06PTvL6rtNbl2LRR9LDURz4Wm2Vv/0ILtr0hSkdrDdFQkAtTcY6eH2c8lr/rqyES5KqOZrb3DfLiseElx2sjQUannL8fu08udUdFQwFa6sI01oSpiwSJBAPURZYfbTM2Hecj39rGb165mrHpOIPjMQ6fG5/zrZeaY4MT3P6Vn1v3oZa1LbW85ZIV3H1Tl6sTzioRo+grHNWkAhorQGFVK2fHpjk7trDDdl1rLauaogRFGJyY4ej58YwjmXrXt3Lo7Bhbj2SfkVryzv00puMJzoxOc2Z0/no683BZJRSefeWMY3IU2s+lCgMXphm4MM3OY8P0nRtn57FhPv/b16Iop0em6GqrM4q/QIyirwLqa0JG0RdJyu2SYmVDhIQm/zZEQ4SDAQbHY2w/mjuekJuK3i84ccmPbz/BT/ef4/z4NDOzyg3rWvjof+rh3VevIRQ03Yz5YBR9FVBb4olf1UQ4GODUyBSDRfjzzaCSwklV2enRqbl9u44P8/FHd9LRUsvf33Mj13Yan34uKup1aIZXZqbUM3yribANC9K4G4pgmSo7OTzJl557zT1Zyhhj0S9DpTyXkVLP8K0iwsHiG0WwCk16u8ZSrjAhW147y8a//hFNNWHefPEK/vLOa+wVWKEYDVAF2FFOhoXYs+gdFKRqyP2mODM6zYGBMTMLfBkqStFXiqvFaYJSUbfZU+xY5dXYGWuf/Ousq62+hHKUN0YDVAFGvzhHyIai9/o2eF1+MRQi8z/+/DD7z2Se3Vvt5K3oRSQoIjtF5Clr+4sisk9EdovIEyLSkiVdn4i8LCK7RGS7Q3IbCsB86DiHnXgsxqIvggKq7NxYjLs3v8DR8+4s2VhOFGLRfwJ4NW37OeAaVb0O2A/cv0zaW1X1BlXtLULGvHHadVMpriATk945gjaUtdHzpWdwPMZffv8Vr8XwHXkpehHpBG4DHk7tU9VnVTU1n/sFkuvBeooa2zUjcdNJ5Rh2lHUVDrqx7S/KN3k4IGzsaWNDdxtjUzNseW3AXsEVRr7DKx8E7gMasxz/CPDPWY4p8KyIKPCQqm4uSEKDbcxoBOewo+jNOPrSURMJLojrf+zfXub6dc2MTsaZis+y+YO9tDdGPZTQW3IqehG5HRhQ1R0ickuG458F4sB3s2Rxs6r2i8gq4DkR2aeqP82Qz73AvQBdXV35X4EhJyZUsXPYWf7RqPkiyLPSFo+GOj06xem987Np/+t3ttNcG6Z/eJI/uuVi3vv6jqp68ebjurkZuENE+oDHgLeLyCMAIvJh4Hbgv2iWNcGsNWRR1QHgCWBDlvM2q2qvqva2t7cXfCGG7EyaODeOYcc56LVeKUfHZr5Vlquje9fxYX6y/ywHBsb45OMv8Wff22NfuDIip0WvqvdjdbRaFv2nVPUeEXk38GngbaqacakcEakHAqp6wfr9TuBzDsleckYmZ9jQ3WptWQ1JlJRdpwuPQJZ9qf2L0yjJcLLhoJR0bVcTqthBbNwmr0fdDFyY5qb1rSBp7VNk7poUTb6MFOZOSrteEQgKxHXJIawUS4iEAmzsaZtr/yOTM+zLssBJZvKrs0I7yd988cqCzi937IRA+CoQJemOAXhBVT8mImuBh1V1E7AaeMI6HgIeVdUf2pTZNU4OT3JqZNKR9TqXY/2KOo4us6ycXcam4xkfTIPLeGzRx+IJXjw2hB2b4vLVjbxmY6z6xp624gtfhkI6ujtaannX1WtKIodfKUjRq+oWYIv1+5Is5/QDm6zfh4HrbUlYAHb8p17ihqXXWBtidLJ6LXs/vOTKtX16Sd6umwI0/aqmaNXFHTIzY32AG22uMVrd8euydCEVk1PRKb320VcyhRhL1dhnVd1Pv09ww7qo9pj03qt5zz03viC6yGe/9K8iCKrJF2O+7baQZ6jUa0H7EaPofYAbrpuaSHXf6oRDHS127pQfXDdeu7Cm44kF491z8fqulrzOK6RmTw5PcujsGBe3NxSQqrypKNdNuX4au+G6qfZQxQmHXDe2cqnuWwCU7kVTiI8+Fk/w8Ud3MjVTPS6cilL05YobEzfCgeq+1X6YHGz0fOnqIEDSmAkFkkNAc5Xz6qlRvvRM9axOVd3f8z7BDddNuX7tOEU8YTS9HyjUoh+dnOGmubksCwnI/As8ocrMuey5ByT5nIkkDSsB/uHnR3jb5at4y6WVP6beKHofUGUjvTwh7oMInuY2F14Hh86Oc+hs5rDDG3pa2X50KK98EpruvptvC/3DkwVKVJ5U9/e8T3DD2vaDovMSP0TwNIreWR+9E53bdtYXKCeMovcBbvjoZ3yg6LzEqRAT5f669HqNBSdbuhNzIzpbax2QxP8YRe8D3LApYlU4djgdp67f1r2qDuPRRexX6KWrqmOIpVH0PsANi36iCmcDpuOPmPxG0zuKA9X5w72n7WdSBhhF7wPc8NFPxKo3zg04Z9Hb8RYYNe+s68sJ181nn9jD/3luv4MhMvyJUfQ+wA0FMDpV3Yq+Gqe9+xEn27pTef3d8wf40rP7HcrNn5jhlTlIKNywroWzF6Y5WaKhWG5Y9LF4gg09rXOxxlNlpmKM5EJJWlCLY+qnBvMoOmftzg1i03mrK6HWir6aOldQ1bnfCdXkuZJKl56Pzv3VVP6akilVetrvufTJq0vJFRByhpxe7l6oKuGQsLopauVnjfuQ+bkQAbFGg1iTdsTaFoGacIBL2uvn6ijlskuP9TIvSHJnSp75cxYJuPzmEvafuWDrq2RlQ4RIqGleEskg/9yEpfT/kzREQ/NhDRbIMX+x6fItvWfzG3WRINd3NpP5aHJjcmaWAwNjOa9rv43Qy+WAUfR5sOv4MBt72kqm6EcmZkqS72K29Q05OuriklUNHMzjIcqXDd2tbO3Lb1x0fvm1sbUv/7gqubhiTSO/OlR8fufHYwzbuNfBgDBrc5hsR2stJ4eKb8fnxmK249HvPDac9/k3dbfyoo02ceWabMtcL6S+wqO75u26EZGgiOwUkaes7S+KyD4R2S0iT4hIS5Z07xaR10TkoIh8xiG5K4rXzozR0VL6YV4V7oZcis+c4nb9wE74kSNBe97acpthnW+NRUKBivbTF3LXPwG8mrb9HHCNql4H7MdabjAdEQkCXwPeA1wFvF9Eripe3Mqlo8TjecNlMTHEYRkr7MGtrKvJD/vXnDuHrrY6nnqpnz/49nbOjE7lPL8cyet7RUQ6gduAB4BPAqjqs2mnvAD8boakG4CD1kpTiMhjwJ3AKzZkzkpA4GLLB5o+ZDH1a97fKWl+xPlji1OkWy+1kSBXXdS0IArivB843V+c/JGwdqb7mVO+5YS1NxIMEA4GCAWFAHDj+hbQhf7ddETSvaG6xF+byd8uMi/n1iPOuUXIUFYVZGgLu0rLD+8tty16u8UlNLl0YHp/Amm/BRgcn2Y8NsuP9w3wrgd/yt+891rec+1FNkv2F/k6ph4E7gOyObw+Avxzhv0dwPG07RPAxkwZiMi9wL0AXV1deYq1kISSNS6GE7xuZT2Hz5Uu/9eva2HncWeVcWNNiAtlMuKmwvW8T7D3tii3KhWkoL614YkZ/ui7L3LXjZ38xR1X01AhvvucrhsRuR0YUNUdWY5/FogD3810OMO+jC1NVTeraq+q9ra3t+cSyxNKblCV4CkqtwfTSfzmc/WHOPZahN3Jfb6ogjz4lx0n+MlrZ70WwzHyeV3dDNwhIpuAGqBJRB5R1XtE5MPA7cBvaOan6gSwLm27E+i3K3Q2/PEgFU8plLIbs24NhnwptDV69UiHg8JbL6uc8MU5Fb2q3o/V0SoitwCfspT8u4FPA29T1YksybcBl4pID3ASuBv4gANyVyTlppLNO6RAHLBE0ucxFENLbZiutroFfVJiObAX+7FTcdvT+37cvuX2yyuutt508Uoaa8K2S/cLdhxQXwWiwHOW1fiCqn5MRNYCD6vqJlWNi8jHgWeAIPANVd1rW2qPKL0rwGhOw/KkOteLZWgixrHBbHZZbq7paCq+cA8o1hgZnZxJThCsEGumIEWvqluALdbvS7Kc0w9sStt+Gni6aAmriVL46EvYTsvcU+Y6TtSX12rHDwucu8Gu48M8/fJpbruuMkbfmFg3PqIkPvoS5OlG3obMeG1gul++dxf8v364r2LCextFX+FUyqdnMfiuc94Beby2qKupOR0bnODhnx/2WgxHMIq+AEqtOPpHShFLx2/azmALry161wWw237tyfvgcwfYd3rUpgzeYxR9AZS6ifcPT3FFnkGY8qd0Ujv90Ff6K6kifPRlNjPWLrHZBH/99D6PpbBPRSn6UjdCdUEVOR1Fz+sHpRDKSVav8Np1Uo33qBLWla2M+b0VxCv9I9SEA0zNONMJlFDlouaotSUL4/1gDddj6Tjp+f2LYqanxUdvqg3S3VZHYlEM+IQVhz5h7UvGmk8dmz+uCrMJnYtVL5KMKaSLzrGj3MLBhYkzxUBKXe+C89KPWj+DAaEuEsySfmns9cVZ1ISDS89ZRC5TIhIUQgGdzyftfliCzP1JHw+fq9x8iYYCrG2pma8fWdh20ttNepuRtPTdK+ryLy8cTI77Z35NhLk6mosllSHelNUm6yJB1jTVzK2XMDUzW/AiPBt72go6348YRV8A9dEwUJqY9CkmZxKsbooyNTPtSH5DafHPr1jTyL7Tzi2wMDoVZ3A85lh+LxxeGuu9rT5SdBnbjw6xuinKmdH0uiz+q2xvvz1f7ehUnGs7mnn55EjRebyuo4mXTxYvh91w2LHZBP3DxUd47Du/cAz/xp42fn0ke4z/xecXusbA6dGFz1Hv+la2Hy0sntQGo+j9R1Nt8pKS1oUsslQXWiHp1q0ssr7mfsv8ec11lTNTrmyodMe9y4RDFeWtLTnXdjRzUbNx3fiO0cnSRWpc15r/J6cdfDcsMCtuCFo2lVEllLeXPijCTd2tQFrA70VNLLUZn01w+3Vr3RSvZFScoi8lbqmcUnW4OS9/6R96o+YXUs3zIpwgrsqOAlw3D7z32hJK4x7mO64A3BpDXD4WfekxVeEwPqtQt8UpdM3dVU3R3CeVAUbRF4TPnpJCcVh8N157fospbxfbQ3Q9rg6n77nb3yfxRGGj2drqIiWSxF0qStGXfhy9O1SWarOHqYvKxu37G58trEQ7I6T8REUpesPyOD3hyw13cYUZ9IZF+N2i/9cdJ0okibvkrehFJCgiO0XkKWv7LhHZKyIJEeldJl2fiLwsIrtEZLsTQhuqCKPpF2D/5eqv+nRbmukCo1E+tftUwX59P1LIqJtPAK8CqZUH9gC/AzyUR9pbVfVcgbIVjNeR/Zyi0vzSdjA14TA23hQBSc40XlEfISDJuSfxWWVwwrlJc6UmVuCM85HJGf5p6zFODE3yy0Pn+JePvYloKJg7oc/IS9GLSCdwG/AA8EkAVX3VOlYy4aqVUr2wnH5/uPJirTRN7/O+2Na6MJesaiAgwmxCmY4nGJuOMzIZY2hihl8tmr186aoGW4rebe0Rmy08tMif/r89c7/3nBzlxvWtTorkCvla9A8C9wHFhFZU4FkRUeAhVd2c6SQRuRe4F6Crq6uIYiqpM7ZEJTlcP24Eeas0Pe/nj87r1zVz9PwE2/oKCxFQToxOzrCmuYbTI8WFcdh5bKgsFX1OH72I3A4MqOqOIsu4WVXfALwH+BMReWumk1R1s6r2qmpve3t7kUWVFh8/o/nhtEXvwteccWM5TzAgGf+9dHyE4bTYSJXIrEJtOEikyFAQ3999ih1Hh0iUmd8+H4v+ZuAOEdkE1ABNIvKIqt6TTwHWGrKo6oCIPAFsAH5arMBeUqjOSY8EmXl74YGyf5GUgPJ6nMoALXzSUCnJV5Lm2hCXr26iPhrkxvWtBAPJp0VVicUTTM0kGJ+OMzI1w4Uc0SmPnBvnxvWtBc2QTfHS8WHe9/Vfcsvl7Xzr9zcUnN4rcip6Vb0fuB9ARG4BPpWvkheReiCgqhes3+8EPle0tDnLK1XOSQJWgLN8FX7qtCXn65IfC+hqq+PcmPMdXE4/3u5MmHKhkDKi8oyB5W/wNWubCAcD7OkfYWvfIBt72nIq6IBAc22Yxpow7Q1R+kcmODWyMIrljqNDRUWynC+jvO5E0bFuROS9wFeAduAHIrJLVd8lImuBh1V1E7AaeML6xA8Bj6rqDx2Q2xNS8dVLjZOhfxeQh/CLm+/SOO3zBCT5T7V0lrcb/QBuUo4jNpykLhygpT5CfSTIyGQ8Y4f+qsYo3SvrOXp+nD2LQkPn0xoSmgzPPTQxw7HBCcJBYUN3G6+dGWUkLejhS8eHubi9nkNnxwu+jgaHFwgqNQVJq6pbgC3W7yeAJzKc0w9ssn4fBq63K2T+AkJLbXiZBQrm9y88Zi1coPOLG8wdTks7U0SPfTH0nZ9wdPGRG9a1sOv4MAfzaNBLPj6WebIWx/pOLwsWuqpk7q9kDRO9ILS0zC92Eg0tbz0t11fgtxmBIrmvZzlqw0FqwkuvKusIqEW7oyUOU5wpXnzPynpWNUYZHI/RVh+Ziz8fCQUIBYUb17cyNhWnNhwkrgn29o8ycCHzegzF1NzMrLK1b5CGaJCbuls5MDA2d+z82DStBYYfF4Q1ZRYDp7xeS7kQGJ6sjM6kcnVZpD+IS1xXmr6XDGc6T3OtO6Gl8yUATMeLv96EYssACASddTkEs7w3utrqWN0U5ej5CY6cG+fIuaSRkb5aUyye4BcHzxdUnp2WMjY9y7a+IW7samXHMXsjiyYdMsLcoqIUfcmVo4tuOUcvpUxfGk6Q6rTzDTZ9u3Zdw0GHG/Hir6loKMDru1rYeWyYY4MTWVLZKM+BPM5cKH6FrBQTsVkHJHEPv33Z+ho3VYajwwrdFNxnenXxmrGeY/O+2m4VDldHeqdkY02I8+PT7Dw27GwhaTjxVJwYmuSKNcVMCZrn0Nmxshr6W1EWfenxmdIw5MR/oyNsWvQlLr2jpYb2xiihQIBAQOZWYJpVJT6bIDabHMo4GZtlPBbnlVOjtNVHaK0Lc+jsOK+ccm5N4mLkz5f0Rd6LYdfxYb6/+xR3XF8eK1BVlKIvoxdsTpy8FldHrvjsHoSyOZG9wuP3znJt4cauVl7uH+FkAYt/t9SFqY8Gixq54iW7TwzTUhe2NUHsH3922Ch6Lyi1QnPVdeNgXq7qFp8Z0L5z0XtcfiyuNNeG52RR5v3+hXZQNtaEaKkN03feeV98qYkn4PLVjXMjgIrhHVetdlCi0lJZit5n1qQdysn/52d81xlrEydaxYgDI9PqI0FWNUZdt+SdfCrsdhbfcvkqhyQpPRWl6EuOizqjLhxwt8AKpcL0vC9aRG0kSEdrLfvPjOU+2cecGpni6rVN7F00KasSMYrep4zHEn5zd+eFHxRROv7rjC1voqEA69vq2He6tJ2u2XD6bjZEgwvG9i9GSXNxLdr/Sv8Ip0emuOXydv/1BS2iohR9qb0dRmXkxm8vp0pbL8Hr+t3Q3crPCpzk5GcSCtv6ivPTbz0ySH0kyJ6/fJfDUjmPv19DBVJpcVHKkcpSq/7Dy/q9cX0rsQIX1/Y7dr/4ulfWl4UxUVGK3mBYjP8fwfLg4vZ6Xjs1WnGmlN1BDx0ttQ5JUlqM68ZgMGTlklUN1IWD7D45AlTei3PGZmz+8djyse/9QkUp+lJTKYuPG7zDri3iljFz6aoGouEAe04WHia4lDhdvt1FWIbGyyOIYt6KXkSCwHbgpKreLiJ3Af8TuBLYoKrbs6R7N/B3QJBknPov2JbaK4yeLzuKWQy6lNhvQqVXtTd1t2ZdN7bSHoF85llcv66ZkAihYICRyRmGJmJz4ctTk8/8TiEW/SeAV4Ema3sP8DvAQ9kSWC+HrwHvAE4A20TkSVV9pThxvcWtdSLrI0HGHYyO52Zn0di0vz5ldx4b5oo1jcTi7ij85towI5MzqRUOFljgCpwenWL9ioWhk3PdnfT7N3BhmpsvWUH/MmEKlls8JpRDsS2n5CGpGHtW1qftWTjwMJfPOxoK0N1Wt2BGblLG+Y3FS26mfouV/pJVDfMlptYxmNujVrqF1ykC4WCA3SdGFuyfmpnNutJUV1sdDdEgLx0fWXIsxbrWCvLRi0gncBvwAPBJAFV91Tq2XNINwEFrARJE5DHgTqAsFb1bSszpySi5Hm4n2X9mjNWNUc5kWTjCC04MTbp279a11nJ8aLKkZbTWR+biuxfKchZoLiUPSVdHsWUDrG6qoc/GjNSm2ggHB4p7NuojAXq7W+devqrK8cFJXh27wHUdzZwcnuT8eIzGaIgrL2pi+9FBctl2E7FZVNX3I2/ytegfBO4DCo3t2QEcT9s+AWzMdKKI3AvcC9DV1VVgMUm6V9bzzd+7aVHGGcpaWnbG44sX8RaZt14kUwKw7cdXlIAICas15pNfrjb27N7TDI7H0mye9PLmxV9sfWY6K5vFlr53ZUPEV4re34+gu2Sri3yUfLkjImzPco27T47QWBNiY08b+06PLlklKxv7Tl8oiyiWORW9iNwODKjqDmtx8ELI1K4yagpV3QxsBujt7S3KR9JcG+bWK8on/oRb/Me+AVdjkqysL69l1soOhz2IhSh5rztjS8mFqXhRQc4+9/1X2HTNGl/Pjs1HspuBO0SkD3gMeLuIPJJn/ieAdWnbnUB/QRIayhCfqQMXTXo3PuHtFLH4zhRqyZuvo6XMzCZ8Hzwvp6JX1ftVtVNVu4G7gR+r6j155r8NuFREekQkYqV/smhpDeWBv9t8VZP+IqoGd40bdK+o872PvuhvDRF5r4icAN4E/EBEnrH2rxWRpwFUNQ58HHiG5Iidx1V1r32xDX7Gb/MN3F1HoPRfM06UUKyS99m3mi/Yd/oCp0ZK2wFvl4IUvapuUdXbrd9PWJZ+VFVXq+q7rP39qropLc3TqnqZql6sqg84K77B4C/ceKnYLcOOJe+vV7g/mI4n+PYvj3otxrL4t/fAYHAIv39Wu4mAp+6aSvwiEIHfuv4ir8VYFqPoqwGj5wwWdkMo2FXUldgUf+OKVVy9ttlrMZbFKHqD41SzAV3p117hl1cU5fDFaBS9wXH89nleBs+hoYw5P+afyYHZMNErDY5j9Kqf8dtr2D00odzU3ZrfuZq/gXDZ6kIDBriPUfSGisfVF4/f9ajNyvD75S2HiDjeEd2zsp6HPni5o3mWAuO6qQLcHtfut3H0buLGtXtZu9V7ZzPz0AdvpK0+4rUYOTGK3uA4flu7txw6ywx54rNl5J7Zc9prEfLCuG6qgKba0ALf5MII4hm2F/knMz5bsnQzdV5AhN71rXN5z+ejab/ny1Z07kRVqI8GGZt2Lh4/ZFrbcz607Ir6COfHYznziAQDTMUT7D05kvVVNjHjrNyLqQ0HaawJ84aulgX7BZl7wYrI0ptq0RANcuP6/PzUwJJ8GmpChaVfXH4qfRb5yLRbmGsffltI5mtbDvLeN3TQ2VqX+2QPMYq+ChidjJd8kkxNKKkEneCSVfUcHHAv2ubGnrYlC1IsxzVrmzhybpzaSJCacJBoKEA4mPxXEw5wUUsNR89PMBmLMx23Z4GKwMUr61nREGV0coYDAxc4OzbN3v7R3IkzYLduN/S0sSPDIh35stFm+ms7mnKf5CJTMwk+9I2tfP63r+HNF6/0WpysGEVvcIRy9o4Uo4rHY7N5rwIWDAiRYIBIKEA4KFyxppHjQxNEggGCgQChoBAKBAgGhIC1YhIizMwmOHR2jINnxznoYphpQ2EcPjvOB/7h1/zem7v5n3dc7bU4GTGK3uAIgTLW9IVKXuiLYTahTCZmmbTcOrF4gqPn/R0EKxu5lgosNX7u6P/WL/v43Rs7uabDf7NkTWeswRGcfPx81t+2BK87d72sH/+qWX/w9S2HvBYhI0bRG5yhqjSAx1ath3Vt98ptj8jyeTt762X+9NPnrehFJCgiO0XkKWu7TUSeE5ED1t+MXfEi0iciL4vILhHZ7pTgBn/htZXrKj7/4igldl0nfna9OEFDNPvi615SiEX/CZKLh6T4DPC8ql4KPG9tZ+NWVb1BVXuLkNFQBlSTnq+ma/Ubfq/606NTXouQkbw6Y0WkE7gNeAD4pLX7TuAW6/e3gS3Ap50Vz1AulHNnrCF/vJ4M11YfYWNP29x2ajj+MsPy5wgIJIoQPxQQ4hkSpvakl7vj6CB958b5w7e9zldj6/MddfMgcB+QHr1ntaqeAlDVUyKyKktaBZ4VEQUeUtXNxQpr8C9GzVcHXt/nwfEYLxUw5yGd+kgw7yGx6Vy5ppFXT18oKE1dNMj977my4LJKRU7XjYjcDgyo6o4iy7hZVd8AvAf4ExF5a5Zy7hWR7SKy/ezZs0UWZfCKSve9plNN1+o3yqV75N9f9ldohHx89DcDd4hIH/AY8HYReQQ4IyIXAVh/BzIlVtV+6+8A8ASwIct5m1W1V1V729vbC74Qg8cY3VcV2B51Uy6a2ibHBic4dHbMazHmyKnoVfV+axHwbuBu4Meqeg/wJPBh67QPA99bnFZE6kWkMfUbeCewxyHZDT6inMbRX7GmkQ3dbcl/Pa0MT+SOc2NIYvc+2+7KKaMXxePbj3stwhx2ZsZ+AXhcRP4AOAbcBSAia4GHVXUTsBp4whp6FwIeVdUf2hPZ4EfKqTO2qTbM1iODxWfg8aV6WbzXetbrzuBC+LcdJ/jUOy8nHPR+ulJBil5Vt5AcXYOqngd+I8M5/cAm6/dh4Hq7Qhr8TxnpeYMtqu9GF/tqOTcW4+cHznHrFdnGqbiH968aQ0VQVoq+WhzFFUi53bmdx4e9FgEwQc2qgqaahfHo08cdJ/8mY5mnby88OS1AvfUzeb7M5RMJBeheUb9gbLFaCQRJ6tZUtukbMh8oKyVHNBRgdVMNs4lEqsg5mVJyplDSZuUu1gIyf1b6NUWCsmAsdqHURwK20jdGQ0vS5zMOPEVtJFh0+eGgsKI+mvV4LjkaMsheCKlrn29/8+0jFUY/KcjiHckEg2WwEHc6K3yy+pRR9FXAyNRMyePRX9xezyEHQ+lu7Gljq0Myp61b4QhXr20qOh48wIbuVlvX1r2ijr7zE0WlrQsHmJgpft2AazuaePmkjWvvabPVP/K6lfVFp/WCS1c3eC0CYFw3hiqg3D73DZXDB/9xK3dv/hVPv3zK0xDPRtEbDAViXPyGfJlNKC8cHuSPv/sif/Y970aWG9dNNeCCYnK6L9ZpkYuNc5KZ6tX0tqOUeviWVNUla+3mQ10kyOu7WhCSbWiuZ2quz2nhJqT6lDS1XBgAQ+MxpuOzRENBG1dRHEbRGxzB6cfX6RdHMCAkZp2RspzVvH1FbVsAz4oPiPDiseGi01+ztok9NvpmAH51+Mfc1dvJ77+5hzXNNbbyKgTjujE4gt/j0Tspn3HdGIplcDzGQz85zAuHz7tarlH0hqog4O/3kKEMcPL93rXC3RDGRtFXAeVogDruCnLSoncspyqkjCvPyTb0y4PnHMsrH4yiNziC0waz4z56J11LHvup7Sgcz4OSGQD42+f28wsXlb1R9IaqwFk9X8ZmqcEGzt33hMJ/+6edHCty4luhGEVvcAS/q75yiq7pZ/x+n8uJwfEYv/etrUzE4iUvyyj6KsCNGXnlMI7eKbwfdeO5AAaHmJ5JuDKu3ih6gy9x3OdfUZ2xNq7F6w8br8u3Qwlu/DuuWk3QhSFheSt6EQmKyE4RecrabhOR50TkgPW3NUu6d4vIayJyUEQ+45TgBkMhmOGVBruUwvv3/Zf6uTA143zGiyjEov8E8Gra9meA51X1UuB5a3sBIhIEvkZyYfCrgPeLyFXFi2vwLT5XpI5O6PLed+MZPr/NZcf58Rj3/etuvvL8gZL66vMKgSAincBtwAPAJ63ddwK3WL+/TXLlqU8vSroBOGitNIWIPGale8WO0IbCuGx1I++8avXc9mI1Na+3dMk+XXBedgXXVh+hs6U2YxmZ8spFZ2stkdC8HaI6P9pFNT3PpblmErOhJsSFqSwPUhbBUrHS00LnA7CyIUp7Y3L6usi8pSd5qsF1rbVEQ/nZWJleUG11YbraMk+4yVXHkYAQKyDoz+J7vqaphqba8DLnZ9lvSdbZWkcoIAvOS7+v8/sW/0jSWh9mZcN8jPdc7TR9fzQUYGomsTDmfdo56W0qfQkGQRCBjpbaufuRqf0tkD/TtbC0PgGOnBvnyLlxTo9O8bk7rymJKyffWDcPAvcBjWn7VqvqKQBVPSUimdbL6gDSV8g9AWzMVICI3AvcC9DV1ZWnWIZ8uKt3HXf1rvNaDIPB4BE5zQoRuR0YUNUdReSf6dWU8Z2vqptVtVdVe9vb24soymAwGAyZyMeivxm4Q0Q2ATVAk4g8ApwRkYssa/4iYCBD2hNAuinZCfTbFdpgMBgM+ZPTolfV+1W1U1W7gbuBH6vqPcCTwIet0z4MfC9D8m3ApSLSIyIRK/2TjkhuMBgMhrywM47+C8A7ROQA8A5rGxFZKyJPA6hqHPg48AzJETuPq+peeyIbDAaDoRDEy3UMs9Hb26vbt2/3WgyDwWAoG0Rkh6r2ZjpmZsYaDAZDheNLi15EzgJHbWazEnA36LP/MXWSGVMvSzF1khk/18t6Vc04ZNGXit4JRGR7ts+YasXUSWZMvSzF1ElmyrVejOvGYDAYKhyj6A0Gg6HCqWRFv9lrAXyIqZPMmHpZiqmTzJRlvVSsj95gMBgMSSrZojcYDAYDRtEbDAZDxVP2il5E7hKRvSKSEJHeRcfut1a2ek1E3pUh7ZMissc9ad2j0HoRkToR+YGI7LPSfcEbyUtHMW1FRG4UkZetY18WR1cw8R8icr2I/Mq65u+LSJO1Pywi37b2vyoi93stq5tkqxfr2HXWsb3W8RovZc2Iqpb1P+BK4HKSC5/0pu2/CngJiAI9wCEgmHb8d4BHgT1eX4Mf6gWoA261zokAPwPe4/V1eN1WgK3Am0iG3P73SquTDHW0DXib9fsjwF9Zvz8APGb9rgP6gG6v5fVBvYSA3cD11vaKdD3jl39lb9Gr6quq+lqGQ3eSbJjTqnoEOEhyxStEpIHkSlmfd09Sdym0XlR1QlX/w0obA14kGVa6Yii0Tqzw202q+itNPsXfAX7bPYk94XLgp9bv54D3Wb8VqBeREFALxIBR98XzjGz18k5gt6q+BKCq51V11gP5lqXsFf0yZFrdqsP6/VfAl4AJt4XyAcvVCwAi0gL8Fsm1gKuBbHXSYf1evL+S2QPcYf2+i/n1JP4VGAdOAceA/62qg+6L5xnZ6uUyQEXkGRF5UUTu80S6HOS7lKCniMiPgDUZDn1WVTPFwYcsq1uJyA3AJar6P0Sk2yERPcHJeknLMwT8E/Bltdb6LSccrpO8V0grJ5arI5JuiS+LyJ+TXDsiZh3bAMwCa4FW4Gci8qNybCPZKLJeQsBbgJtIGo7PW1EkfWUklYWiV9XfLCJZttWt3gTcKCJ9JK9/lYhsUdVb7MrpNg7XS4rNwAFVfdCGaJ7hcJ2cYKH7qiJWSMujjt4JICKXAbdZ+z4A/FBVZ4ABEfkF0AtUjKIvsl5OAD9R1XPWsaeBN+Czr+FKdt08CdwtIlER6QEuBbaq6tdVda0mV8x6C7C/HJW8DTLWC4CIfB5oBv67d+J5Qra2cgq4ICJvtEbbfIjMK6lVDCKyyvobAP4U+Hvr0DHg7ZKkHngjsM8bKd1nmXp5BrjOGrUWAt4GvOKNlNkpe0UvIu8VkRMkLfUfiMgzAJpcyepxkpX+Q+BP/NhJUioKrRcR6ST5iXoV8KKI7BKRj3okfkkosq38EfAwyQ7aQyRH3lQy7xeR/SSVeD/wTWv/14AGkr7qbcA3VXW3NyJ6QsZ6UdUh4G9J1sku4EVV/YFXQmbDhEAwGAyGCqfsLXqDwWAwLI9R9AaDwVDhGEVvMBgMFY5R9AaDwVDhGEVvMBgMFY5R9AaDwVDhGEVvMBgMFc7/B4w44LszwhluAAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "geo[geo[\"STUSPS\"] == \"NE\"].plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATEFP</th>\n",
       "      <th>COUNTYFP</th>\n",
       "      <th>COUNTYNS</th>\n",
       "      <th>AFFGEOID</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>STUSPS</th>\n",
       "      <th>STATE_NAME</th>\n",
       "      <th>LSAD</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>05</td>\n",
       "      <td>121</td>\n",
       "      <td>00069178</td>\n",
       "      <td>0500000US05121</td>\n",
       "      <td>05121</td>\n",
       "      <td>Randolph</td>\n",
       "      <td>Randolph County</td>\n",
       "      <td>AR</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>06</td>\n",
       "      <td>1688445990</td>\n",
       "      <td>10370823</td>\n",
       "      <td>POLYGON ((-91.40492 36.49712, -91.12654 36.497...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>08</td>\n",
       "      <td>069</td>\n",
       "      <td>00198150</td>\n",
       "      <td>0500000US08069</td>\n",
       "      <td>08069</td>\n",
       "      <td>Larimer</td>\n",
       "      <td>Larimer County</td>\n",
       "      <td>CO</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>06</td>\n",
       "      <td>6723014102</td>\n",
       "      <td>98984559</td>\n",
       "      <td>POLYGON ((-106.19055 40.99775, -105.27714 40.9...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26</td>\n",
       "      <td>105</td>\n",
       "      <td>01622995</td>\n",
       "      <td>0500000US26105</td>\n",
       "      <td>26105</td>\n",
       "      <td>Mason</td>\n",
       "      <td>Mason County</td>\n",
       "      <td>MI</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>06</td>\n",
       "      <td>1281963206</td>\n",
       "      <td>1935616622</td>\n",
       "      <td>POLYGON ((-86.51470 44.05812, -86.45807 44.099...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28</td>\n",
       "      <td>153</td>\n",
       "      <td>00695797</td>\n",
       "      <td>0500000US28153</td>\n",
       "      <td>28153</td>\n",
       "      <td>Wayne</td>\n",
       "      <td>Wayne County</td>\n",
       "      <td>MS</td>\n",
       "      <td>Mississippi</td>\n",
       "      <td>06</td>\n",
       "      <td>2099745602</td>\n",
       "      <td>7255476</td>\n",
       "      <td>POLYGON ((-88.94335 31.82456, -88.91046 31.826...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>38</td>\n",
       "      <td>075</td>\n",
       "      <td>01034229</td>\n",
       "      <td>0500000US38075</td>\n",
       "      <td>38075</td>\n",
       "      <td>Renville</td>\n",
       "      <td>Renville County</td>\n",
       "      <td>ND</td>\n",
       "      <td>North Dakota</td>\n",
       "      <td>06</td>\n",
       "      <td>2272050275</td>\n",
       "      <td>40658499</td>\n",
       "      <td>POLYGON ((-102.02164 48.80711, -102.02122 48.9...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3216</th>\n",
       "      <td>16</td>\n",
       "      <td>077</td>\n",
       "      <td>00394951</td>\n",
       "      <td>0500000US16077</td>\n",
       "      <td>16077</td>\n",
       "      <td>Power</td>\n",
       "      <td>Power County</td>\n",
       "      <td>ID</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>06</td>\n",
       "      <td>3635892401</td>\n",
       "      <td>99205466</td>\n",
       "      <td>POLYGON ((-113.24348 43.11095, -113.00771 43.1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3217</th>\n",
       "      <td>46</td>\n",
       "      <td>085</td>\n",
       "      <td>01265789</td>\n",
       "      <td>0500000US46085</td>\n",
       "      <td>46085</td>\n",
       "      <td>Lyman</td>\n",
       "      <td>Lyman County</td>\n",
       "      <td>SD</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>06</td>\n",
       "      <td>4253498542</td>\n",
       "      <td>167300393</td>\n",
       "      <td>POLYGON ((-100.36725 44.19462, -99.93822 44.19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3218</th>\n",
       "      <td>55</td>\n",
       "      <td>115</td>\n",
       "      <td>01581117</td>\n",
       "      <td>0500000US55115</td>\n",
       "      <td>55115</td>\n",
       "      <td>Shawano</td>\n",
       "      <td>Shawano County</td>\n",
       "      <td>WI</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>06</td>\n",
       "      <td>2313441749</td>\n",
       "      <td>41883059</td>\n",
       "      <td>POLYGON ((-89.22381 45.02925, -88.98168 45.028...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3219</th>\n",
       "      <td>16</td>\n",
       "      <td>069</td>\n",
       "      <td>00399394</td>\n",
       "      <td>0500000US16069</td>\n",
       "      <td>16069</td>\n",
       "      <td>Nez Perce</td>\n",
       "      <td>Nez Perce County</td>\n",
       "      <td>ID</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>06</td>\n",
       "      <td>2197139835</td>\n",
       "      <td>21252880</td>\n",
       "      <td>POLYGON ((-117.03554 46.41001, -117.03665 46.4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3220</th>\n",
       "      <td>46</td>\n",
       "      <td>029</td>\n",
       "      <td>01265791</td>\n",
       "      <td>0500000US46029</td>\n",
       "      <td>46029</td>\n",
       "      <td>Codington</td>\n",
       "      <td>Codington County</td>\n",
       "      <td>SD</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>06</td>\n",
       "      <td>1780837048</td>\n",
       "      <td>76608858</td>\n",
       "      <td>POLYGON ((-97.49425 45.15163, -97.24913 45.151...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3186 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     STATEFP COUNTYFP  COUNTYNS        AFFGEOID  GEOID       NAME  \\\n",
       "0         05      121  00069178  0500000US05121  05121   Randolph   \n",
       "1         08      069  00198150  0500000US08069  08069    Larimer   \n",
       "2         26      105  01622995  0500000US26105  26105      Mason   \n",
       "3         28      153  00695797  0500000US28153  28153      Wayne   \n",
       "4         38      075  01034229  0500000US38075  38075   Renville   \n",
       "...      ...      ...       ...             ...    ...        ...   \n",
       "3216      16      077  00394951  0500000US16077  16077      Power   \n",
       "3217      46      085  01265789  0500000US46085  46085      Lyman   \n",
       "3218      55      115  01581117  0500000US55115  55115    Shawano   \n",
       "3219      16      069  00399394  0500000US16069  16069  Nez Perce   \n",
       "3220      46      029  01265791  0500000US46029  46029  Codington   \n",
       "\n",
       "              NAMELSAD STUSPS    STATE_NAME LSAD       ALAND      AWATER  \\\n",
       "0      Randolph County     AR      Arkansas   06  1688445990    10370823   \n",
       "1       Larimer County     CO      Colorado   06  6723014102    98984559   \n",
       "2         Mason County     MI      Michigan   06  1281963206  1935616622   \n",
       "3         Wayne County     MS   Mississippi   06  2099745602     7255476   \n",
       "4      Renville County     ND  North Dakota   06  2272050275    40658499   \n",
       "...                ...    ...           ...  ...         ...         ...   \n",
       "3216      Power County     ID         Idaho   06  3635892401    99205466   \n",
       "3217      Lyman County     SD  South Dakota   06  4253498542   167300393   \n",
       "3218    Shawano County     WI     Wisconsin   06  2313441749    41883059   \n",
       "3219  Nez Perce County     ID         Idaho   06  2197139835    21252880   \n",
       "3220  Codington County     SD  South Dakota   06  1780837048    76608858   \n",
       "\n",
       "                                               geometry  \n",
       "0     POLYGON ((-91.40492 36.49712, -91.12654 36.497...  \n",
       "1     POLYGON ((-106.19055 40.99775, -105.27714 40.9...  \n",
       "2     POLYGON ((-86.51470 44.05812, -86.45807 44.099...  \n",
       "3     POLYGON ((-88.94335 31.82456, -88.91046 31.826...  \n",
       "4     POLYGON ((-102.02164 48.80711, -102.02122 48.9...  \n",
       "...                                                 ...  \n",
       "3216  POLYGON ((-113.24348 43.11095, -113.00771 43.1...  \n",
       "3217  POLYGON ((-100.36725 44.19462, -99.93822 44.19...  \n",
       "3218  POLYGON ((-89.22381 45.02925, -88.98168 45.028...  \n",
       "3219  POLYGON ((-117.03554 46.41001, -117.03665 46.4...  \n",
       "3220  POLYGON ((-97.49425 45.15163, -97.24913 45.151...  \n",
       "\n",
       "[3186 rows x 13 columns]"
      ]
     },
     "execution_count": 162,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "counties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n"
     ]
    }
   ],
   "source": [
    "conds_for_by_county = (by_county[\"STATE\"] != \"AK\") & \\\n",
    "                        (by_county[\"STATE\"] != \"HI\") # & \\\n",
    "                        # (by_county[\"RACE\"].notna())\n",
    "states_for_counties = (counties[\"STUSPS\"] != \"AK\") & \\\n",
    "                        (counties[\"STUSPS\"] != \"HI\")\n",
    "by_county = by_county[conds_for_by_county]\n",
    "counties = counties[states_for_counties]\n",
    "\n",
    "by_county_c = by_county[[\"AREA\", \"RACE\", \"SITE\", \"YEAR\", \"EVENT_TYPE\",\n",
    "                            \"AGE_ADJUSTED_RATE\", \"SEX\", \"STATE\"]].copy()\n",
    "print(len(by_county[by_county_c[\"RACE\"].isnull()]))\n",
    "counties_c = counties[[\"GEOID\", \"NAMELSAD\", \"STUSPS\", \"STATE_NAME\",\n",
    "                        \"geometry\"]].copy()\n",
    "by_county_c = by_county_c[(by_county_c[\"SITE\"] == \"All Cancer Sites Combined\") & (by_county_c[\"SEX\"] == \"Male and Female\")]\n",
    "by_county_c = Utils.remove_rows(data=by_county_c,\n",
    "                                chars=['+', '~', '.', '-'])\n",
    "by_county_c = Utils.get_mir(data=by_county_c, \n",
    "                            on=['AREA', 'RACE', 'SEX', 'SITE', 'YEAR'],\n",
    "                            rate_col='AGE_ADJUSTED_RATE')\n",
    "races = [str(race) for race in by_county[\"RACE\"].unique()]\n",
    "prepared_shp, states_shp = Utils._clean_join_shp(by_county_c, counties_c)\n",
    "\n",
    "# races = prepared_shp[\"RACE\"] == \"All Races\"\n",
    "# sites = prepared_shp[\"SITE\"] == \"All Cancer Sites Combined\"\n",
    "# sexes = prepared_shp[\"SEX\"] == \"Male and Female\"\n",
    "# prepared_shp = prepared_shp[races & sites & sexes]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(8042, 13)\n",
      "(3186, 5)\n",
      "(8374, 18)\n"
     ]
    }
   ],
   "source": [
    "print(by_county_c.shape)\n",
    "print(counties_c.shape)\n",
    "print(prepared_shp.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {},
   "outputs": [],
   "source": [
    "alt.data_transformers.disable_max_rows()\n",
    "scale = alt.Scale(domain=[0.10, 1.12])\n",
    "\n",
    "race_dropdown = alt.binding_select(options = races)\n",
    "race_select = alt.selection_single(fields = [\"RACE\"], bind=race_dropdown, init={\"RACE\":races[0]})\n",
    "\n",
    "background = alt.Chart(states_shp) \\\n",
    "                .mark_geoshape(fill=\"lightgray\", stroke=\"white\")\n",
    "\n",
    "mir_highlight = alt.Chart(prepared_shp).mark_geoshape().encode(\n",
    "    color=alt.Color(\"MIR:Q\", scale=scale)\n",
    ").add_selection(\n",
    "    race_select\n",
    ").transform_filter(\n",
    "    race_select\n",
    ")\n",
    "\n",
    "(background + mir_highlight).save(\"interactive_test.html\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>STUSPS</th>\n",
       "      <th>STATE_NAME</th>\n",
       "      <th>geometry</th>\n",
       "      <th>AREA</th>\n",
       "      <th>RACE</th>\n",
       "      <th>SITE</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>EVENT_TYPE_x</th>\n",
       "      <th>AGE_ADJUSTED_RATE_x</th>\n",
       "      <th>SEX</th>\n",
       "      <th>STATE_x</th>\n",
       "      <th>EVENT_TYPE_y</th>\n",
       "      <th>AGE_ADJUSTED_RATE_y</th>\n",
       "      <th>STATE_y</th>\n",
       "      <th>MIR</th>\n",
       "      <th>geoid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5121.0</td>\n",
       "      <td>Randolph County</td>\n",
       "      <td>AR</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>POLYGON ((-91.40492 36.49712, -91.12654 36.497...</td>\n",
       "      <td>AR: Randolph County (05121)</td>\n",
       "      <td>All Races</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>202.699997</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>AR</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>539.000000</td>\n",
       "      <td>AR</td>\n",
       "      <td>0.376067</td>\n",
       "      <td>5121.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5121.0</td>\n",
       "      <td>Randolph County</td>\n",
       "      <td>AR</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>POLYGON ((-91.40492 36.49712, -91.12654 36.497...</td>\n",
       "      <td>AR: Randolph County (05121)</td>\n",
       "      <td>White</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>206.199997</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>AR</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>544.799988</td>\n",
       "      <td>AR</td>\n",
       "      <td>0.378488</td>\n",
       "      <td>5121.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8069.0</td>\n",
       "      <td>Larimer County</td>\n",
       "      <td>CO</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>POLYGON ((-106.19055 40.99775, -105.27714 40.9...</td>\n",
       "      <td>CO: Larimer County (08069)</td>\n",
       "      <td>All Races</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>130.800003</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>CO</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>414.600006</td>\n",
       "      <td>CO</td>\n",
       "      <td>0.315485</td>\n",
       "      <td>8069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8069.0</td>\n",
       "      <td>Larimer County</td>\n",
       "      <td>CO</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>POLYGON ((-106.19055 40.99775, -105.27714 40.9...</td>\n",
       "      <td>CO: Larimer County (08069)</td>\n",
       "      <td>Hispanic</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>127.599998</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>CO</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>400.299988</td>\n",
       "      <td>CO</td>\n",
       "      <td>0.318761</td>\n",
       "      <td>8069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8069.0</td>\n",
       "      <td>Larimer County</td>\n",
       "      <td>CO</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>POLYGON ((-106.19055 40.99775, -105.27714 40.9...</td>\n",
       "      <td>CO: Larimer County (08069)</td>\n",
       "      <td>White</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>132.399994</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>CO</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>417.200012</td>\n",
       "      <td>CO</td>\n",
       "      <td>0.317354</td>\n",
       "      <td>8069.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8369</th>\n",
       "      <td>16069.0</td>\n",
       "      <td>Nez Perce County</td>\n",
       "      <td>ID</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>POLYGON ((-117.03554 46.41001, -117.03665 46.4...</td>\n",
       "      <td>ID: Nez Perce County (16069)</td>\n",
       "      <td>All Races</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>181.600006</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>ID</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>446.200012</td>\n",
       "      <td>ID</td>\n",
       "      <td>0.406992</td>\n",
       "      <td>16069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8370</th>\n",
       "      <td>16069.0</td>\n",
       "      <td>Nez Perce County</td>\n",
       "      <td>ID</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>POLYGON ((-117.03554 46.41001, -117.03665 46.4...</td>\n",
       "      <td>ID: Nez Perce County (16069)</td>\n",
       "      <td>American Indian/Alaska Native</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>190.300003</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>ID</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>444.500000</td>\n",
       "      <td>ID</td>\n",
       "      <td>0.428121</td>\n",
       "      <td>16069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8371</th>\n",
       "      <td>16069.0</td>\n",
       "      <td>Nez Perce County</td>\n",
       "      <td>ID</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>POLYGON ((-117.03554 46.41001, -117.03665 46.4...</td>\n",
       "      <td>ID: Nez Perce County (16069)</td>\n",
       "      <td>White</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>180.800003</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>ID</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>444.299988</td>\n",
       "      <td>ID</td>\n",
       "      <td>0.406932</td>\n",
       "      <td>16069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8372</th>\n",
       "      <td>46029.0</td>\n",
       "      <td>Codington County</td>\n",
       "      <td>SD</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>POLYGON ((-97.49425 45.15163, -97.24913 45.151...</td>\n",
       "      <td>SD: Codington County (46029)</td>\n",
       "      <td>All Races</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>167.800003</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>SD</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>466.399994</td>\n",
       "      <td>SD</td>\n",
       "      <td>0.359777</td>\n",
       "      <td>46029.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8373</th>\n",
       "      <td>46029.0</td>\n",
       "      <td>Codington County</td>\n",
       "      <td>SD</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>POLYGON ((-97.49425 45.15163, -97.24913 45.151...</td>\n",
       "      <td>SD: Codington County (46029)</td>\n",
       "      <td>White</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>166.800003</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>SD</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>456.700012</td>\n",
       "      <td>SD</td>\n",
       "      <td>0.365229</td>\n",
       "      <td>46029.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8374 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        GEOID          NAMELSAD STUSPS    STATE_NAME  \\\n",
       "0      5121.0   Randolph County     AR      Arkansas   \n",
       "1      5121.0   Randolph County     AR      Arkansas   \n",
       "2      8069.0    Larimer County     CO      Colorado   \n",
       "3      8069.0    Larimer County     CO      Colorado   \n",
       "4      8069.0    Larimer County     CO      Colorado   \n",
       "...       ...               ...    ...           ...   \n",
       "8369  16069.0  Nez Perce County     ID         Idaho   \n",
       "8370  16069.0  Nez Perce County     ID         Idaho   \n",
       "8371  16069.0  Nez Perce County     ID         Idaho   \n",
       "8372  46029.0  Codington County     SD  South Dakota   \n",
       "8373  46029.0  Codington County     SD  South Dakota   \n",
       "\n",
       "                                               geometry  \\\n",
       "0     POLYGON ((-91.40492 36.49712, -91.12654 36.497...   \n",
       "1     POLYGON ((-91.40492 36.49712, -91.12654 36.497...   \n",
       "2     POLYGON ((-106.19055 40.99775, -105.27714 40.9...   \n",
       "3     POLYGON ((-106.19055 40.99775, -105.27714 40.9...   \n",
       "4     POLYGON ((-106.19055 40.99775, -105.27714 40.9...   \n",
       "...                                                 ...   \n",
       "8369  POLYGON ((-117.03554 46.41001, -117.03665 46.4...   \n",
       "8370  POLYGON ((-117.03554 46.41001, -117.03665 46.4...   \n",
       "8371  POLYGON ((-117.03554 46.41001, -117.03665 46.4...   \n",
       "8372  POLYGON ((-97.49425 45.15163, -97.24913 45.151...   \n",
       "8373  POLYGON ((-97.49425 45.15163, -97.24913 45.151...   \n",
       "\n",
       "                              AREA                           RACE  \\\n",
       "0      AR: Randolph County (05121)                      All Races   \n",
       "1      AR: Randolph County (05121)                          White   \n",
       "2       CO: Larimer County (08069)                      All Races   \n",
       "3       CO: Larimer County (08069)                       Hispanic   \n",
       "4       CO: Larimer County (08069)                          White   \n",
       "...                            ...                            ...   \n",
       "8369  ID: Nez Perce County (16069)                      All Races   \n",
       "8370  ID: Nez Perce County (16069)  American Indian/Alaska Native   \n",
       "8371  ID: Nez Perce County (16069)                          White   \n",
       "8372  SD: Codington County (46029)                      All Races   \n",
       "8373  SD: Codington County (46029)                          White   \n",
       "\n",
       "                           SITE       YEAR EVENT_TYPE_x  AGE_ADJUSTED_RATE_x  \\\n",
       "0     All Cancer Sites Combined  2014-2018    Mortality           202.699997   \n",
       "1     All Cancer Sites Combined  2014-2018    Mortality           206.199997   \n",
       "2     All Cancer Sites Combined  2014-2018    Mortality           130.800003   \n",
       "3     All Cancer Sites Combined  2014-2018    Mortality           127.599998   \n",
       "4     All Cancer Sites Combined  2014-2018    Mortality           132.399994   \n",
       "...                         ...        ...          ...                  ...   \n",
       "8369  All Cancer Sites Combined  2014-2018    Mortality           181.600006   \n",
       "8370  All Cancer Sites Combined  2014-2018    Mortality           190.300003   \n",
       "8371  All Cancer Sites Combined  2014-2018    Mortality           180.800003   \n",
       "8372  All Cancer Sites Combined  2014-2018    Mortality           167.800003   \n",
       "8373  All Cancer Sites Combined  2014-2018    Mortality           166.800003   \n",
       "\n",
       "                  SEX STATE_x EVENT_TYPE_y  AGE_ADJUSTED_RATE_y STATE_y  \\\n",
       "0     Male and Female      AR    Incidence           539.000000      AR   \n",
       "1     Male and Female      AR    Incidence           544.799988      AR   \n",
       "2     Male and Female      CO    Incidence           414.600006      CO   \n",
       "3     Male and Female      CO    Incidence           400.299988      CO   \n",
       "4     Male and Female      CO    Incidence           417.200012      CO   \n",
       "...               ...     ...          ...                  ...     ...   \n",
       "8369  Male and Female      ID    Incidence           446.200012      ID   \n",
       "8370  Male and Female      ID    Incidence           444.500000      ID   \n",
       "8371  Male and Female      ID    Incidence           444.299988      ID   \n",
       "8372  Male and Female      SD    Incidence           466.399994      SD   \n",
       "8373  Male and Female      SD    Incidence           456.700012      SD   \n",
       "\n",
       "           MIR    geoid  \n",
       "0     0.376067   5121.0  \n",
       "1     0.378488   5121.0  \n",
       "2     0.315485   8069.0  \n",
       "3     0.318761   8069.0  \n",
       "4     0.317354   8069.0  \n",
       "...        ...      ...  \n",
       "8369  0.406992  16069.0  \n",
       "8370  0.428121  16069.0  \n",
       "8371  0.406932  16069.0  \n",
       "8372  0.359777  46029.0  \n",
       "8373  0.365229  46029.0  \n",
       "\n",
       "[8374 rows x 18 columns]"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prepared_shp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>STUSPS</th>\n",
       "      <th>STATE_NAME</th>\n",
       "      <th>geometry</th>\n",
       "      <th>AREA</th>\n",
       "      <th>RACE</th>\n",
       "      <th>SITE</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>EVENT_TYPE_x</th>\n",
       "      <th>AGE_ADJUSTED_RATE_x</th>\n",
       "      <th>SEX</th>\n",
       "      <th>STATE_x</th>\n",
       "      <th>EVENT_TYPE_y</th>\n",
       "      <th>AGE_ADJUSTED_RATE_y</th>\n",
       "      <th>STATE_y</th>\n",
       "      <th>MIR</th>\n",
       "      <th>geoid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>34013.0</td>\n",
       "      <td>Essex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>POLYGON ((-74.36714 40.76111, -74.32611 40.908...</td>\n",
       "      <td>NJ: Essex County (34013)</td>\n",
       "      <td>All Races</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>148.300003</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>462.600006</td>\n",
       "      <td>NJ</td>\n",
       "      <td>0.320579</td>\n",
       "      <td>34013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>34013.0</td>\n",
       "      <td>Essex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>POLYGON ((-74.36714 40.76111, -74.32611 40.908...</td>\n",
       "      <td>NJ: Essex County (34013)</td>\n",
       "      <td>Asian/Pacific Islander</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>71.500000</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>305.100006</td>\n",
       "      <td>NJ</td>\n",
       "      <td>0.234349</td>\n",
       "      <td>34013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>34013.0</td>\n",
       "      <td>Essex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>POLYGON ((-74.36714 40.76111, -74.32611 40.908...</td>\n",
       "      <td>NJ: Essex County (34013)</td>\n",
       "      <td>Black</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>439.799988</td>\n",
       "      <td>NJ</td>\n",
       "      <td>0.393361</td>\n",
       "      <td>34013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>34013.0</td>\n",
       "      <td>Essex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>POLYGON ((-74.36714 40.76111, -74.32611 40.908...</td>\n",
       "      <td>NJ: Essex County (34013)</td>\n",
       "      <td>Hispanic</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>103.099998</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>414.600006</td>\n",
       "      <td>NJ</td>\n",
       "      <td>0.248673</td>\n",
       "      <td>34013.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>34013.0</td>\n",
       "      <td>Essex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>POLYGON ((-74.36714 40.76111, -74.32611 40.908...</td>\n",
       "      <td>NJ: Essex County (34013)</td>\n",
       "      <td>White</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>138.399994</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>471.100006</td>\n",
       "      <td>NJ</td>\n",
       "      <td>0.293781</td>\n",
       "      <td>34013.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       GEOID      NAMELSAD STUSPS  STATE_NAME  \\\n",
       "36   34013.0  Essex County     NJ  New Jersey   \n",
       "62   34013.0  Essex County     NJ  New Jersey   \n",
       "97   34013.0  Essex County     NJ  New Jersey   \n",
       "129  34013.0  Essex County     NJ  New Jersey   \n",
       "174  34013.0  Essex County     NJ  New Jersey   \n",
       "\n",
       "                                              geometry  \\\n",
       "36   POLYGON ((-74.36714 40.76111, -74.32611 40.908...   \n",
       "62   POLYGON ((-74.36714 40.76111, -74.32611 40.908...   \n",
       "97   POLYGON ((-74.36714 40.76111, -74.32611 40.908...   \n",
       "129  POLYGON ((-74.36714 40.76111, -74.32611 40.908...   \n",
       "174  POLYGON ((-74.36714 40.76111, -74.32611 40.908...   \n",
       "\n",
       "                         AREA                    RACE  \\\n",
       "36   NJ: Essex County (34013)               All Races   \n",
       "62   NJ: Essex County (34013)  Asian/Pacific Islander   \n",
       "97   NJ: Essex County (34013)                   Black   \n",
       "129  NJ: Essex County (34013)                Hispanic   \n",
       "174  NJ: Essex County (34013)                   White   \n",
       "\n",
       "                          SITE       YEAR EVENT_TYPE_x  AGE_ADJUSTED_RATE_x  \\\n",
       "36   All Cancer Sites Combined  2014-2018    Mortality           148.300003   \n",
       "62   All Cancer Sites Combined  2014-2018    Mortality            71.500000   \n",
       "97   All Cancer Sites Combined  2014-2018    Mortality           173.000000   \n",
       "129  All Cancer Sites Combined  2014-2018    Mortality           103.099998   \n",
       "174  All Cancer Sites Combined  2014-2018    Mortality           138.399994   \n",
       "\n",
       "                 SEX STATE_x EVENT_TYPE_y  AGE_ADJUSTED_RATE_y STATE_y  \\\n",
       "36   Male and Female      NJ    Incidence           462.600006      NJ   \n",
       "62   Male and Female      NJ    Incidence           305.100006      NJ   \n",
       "97   Male and Female      NJ    Incidence           439.799988      NJ   \n",
       "129  Male and Female      NJ    Incidence           414.600006      NJ   \n",
       "174  Male and Female      NJ    Incidence           471.100006      NJ   \n",
       "\n",
       "          MIR    geoid  \n",
       "36   0.320579  34013.0  \n",
       "62   0.234349  34013.0  \n",
       "97   0.393361  34013.0  \n",
       "129  0.248673  34013.0  \n",
       "174  0.293781  34013.0  "
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "background = alt.Chart(states_shp) \\\n",
    "                .mark_geoshape(fill=\"lightgray\", stroke=\"white\")\n",
    "\n",
    "race_dropdown = alt.binding_select(options=races, name=\"Race\")\n",
    "race_select = alt.selection_single(bind=race_dropdown,\n",
    "                                    fields=[\"Race\", \"geometry\"])\n",
    "\n",
    "mir_highlight = alt.Chart(prepared_shp) \\\n",
    "    .mark_geoshape() \\\n",
    "    .encode(color = alt.Color(\"MIR:Q\", scale=scale)) \\\n",
    "    .add_selection(race_select) \\\n",
    "    .transform_filter(race_select) \\\n",
    "    .properties(title=\"Mortality Incidence Rate for US counties (2014-2018)\")\n",
    "\n",
    "(background + mir_highlight).save(\"interactive_test.html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATEFP</th>\n",
       "      <th>COUNTYFP</th>\n",
       "      <th>COUNTYNS</th>\n",
       "      <th>AFFGEOID</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>NAME</th>\n",
       "      <th>NAMELSAD</th>\n",
       "      <th>STUSPS</th>\n",
       "      <th>STATE_NAME</th>\n",
       "      <th>LSAD</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>34</td>\n",
       "      <td>013</td>\n",
       "      <td>00882276</td>\n",
       "      <td>0500000US34013</td>\n",
       "      <td>34013</td>\n",
       "      <td>Essex</td>\n",
       "      <td>Essex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>326557433</td>\n",
       "      <td>8638155</td>\n",
       "      <td>POLYGON ((-74.36714 40.76111, -74.32611 40.908...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>34</td>\n",
       "      <td>001</td>\n",
       "      <td>00882270</td>\n",
       "      <td>0500000US34001</td>\n",
       "      <td>34001</td>\n",
       "      <td>Atlantic</td>\n",
       "      <td>Atlantic County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1438774368</td>\n",
       "      <td>301270979</td>\n",
       "      <td>POLYGON ((-74.91188 39.57846, -74.87726 39.608...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>34</td>\n",
       "      <td>029</td>\n",
       "      <td>00882279</td>\n",
       "      <td>0500000US34029</td>\n",
       "      <td>34029</td>\n",
       "      <td>Ocean</td>\n",
       "      <td>Ocean County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1627252596</td>\n",
       "      <td>742162038</td>\n",
       "      <td>POLYGON ((-74.55311 40.07913, -74.40671 40.172...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>34</td>\n",
       "      <td>027</td>\n",
       "      <td>00882231</td>\n",
       "      <td>0500000US34027</td>\n",
       "      <td>34027</td>\n",
       "      <td>Morris</td>\n",
       "      <td>Morris County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1193911893</td>\n",
       "      <td>53230151</td>\n",
       "      <td>POLYGON ((-74.85051 40.80396, -74.76942 40.910...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1202</th>\n",
       "      <td>34</td>\n",
       "      <td>009</td>\n",
       "      <td>00882274</td>\n",
       "      <td>0500000US34009</td>\n",
       "      <td>34009</td>\n",
       "      <td>Cape May</td>\n",
       "      <td>Cape May County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>651437935</td>\n",
       "      <td>955149083</td>\n",
       "      <td>POLYGON ((-74.95536 39.00126, -74.90366 39.087...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1343</th>\n",
       "      <td>34</td>\n",
       "      <td>011</td>\n",
       "      <td>00882275</td>\n",
       "      <td>0500000US34011</td>\n",
       "      <td>34011</td>\n",
       "      <td>Cumberland</td>\n",
       "      <td>Cumberland County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1251898249</td>\n",
       "      <td>503713126</td>\n",
       "      <td>POLYGON ((-75.41711 39.38891, -75.36821 39.456...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1544</th>\n",
       "      <td>34</td>\n",
       "      <td>021</td>\n",
       "      <td>00882229</td>\n",
       "      <td>0500000US34021</td>\n",
       "      <td>34021</td>\n",
       "      <td>Mercer</td>\n",
       "      <td>Mercer County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>581297767</td>\n",
       "      <td>11434809</td>\n",
       "      <td>POLYGON ((-74.92811 40.33983, -74.85626 40.346...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1602</th>\n",
       "      <td>34</td>\n",
       "      <td>015</td>\n",
       "      <td>00882277</td>\n",
       "      <td>0500000US34015</td>\n",
       "      <td>34015</td>\n",
       "      <td>Gloucester</td>\n",
       "      <td>Gloucester County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>833976887</td>\n",
       "      <td>38259771</td>\n",
       "      <td>POLYGON ((-75.41049 39.80467, -75.34176 39.846...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>34</td>\n",
       "      <td>039</td>\n",
       "      <td>00882235</td>\n",
       "      <td>0500000US34039</td>\n",
       "      <td>34039</td>\n",
       "      <td>Union</td>\n",
       "      <td>Union County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>266163567</td>\n",
       "      <td>6847407</td>\n",
       "      <td>POLYGON ((-74.46329 40.59919, -74.42440 40.619...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1718</th>\n",
       "      <td>34</td>\n",
       "      <td>007</td>\n",
       "      <td>00882273</td>\n",
       "      <td>0500000US34007</td>\n",
       "      <td>34007</td>\n",
       "      <td>Camden</td>\n",
       "      <td>Camden County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>573315345</td>\n",
       "      <td>15699106</td>\n",
       "      <td>POLYGON ((-75.13342 39.89621, -75.13459 39.922...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1971</th>\n",
       "      <td>34</td>\n",
       "      <td>041</td>\n",
       "      <td>00882237</td>\n",
       "      <td>0500000US34041</td>\n",
       "      <td>34041</td>\n",
       "      <td>Warren</td>\n",
       "      <td>Warren County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>923435921</td>\n",
       "      <td>15822933</td>\n",
       "      <td>POLYGON ((-75.19261 40.71587, -75.17748 40.764...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2096</th>\n",
       "      <td>34</td>\n",
       "      <td>037</td>\n",
       "      <td>00882236</td>\n",
       "      <td>0500000US34037</td>\n",
       "      <td>34037</td>\n",
       "      <td>Sussex</td>\n",
       "      <td>Sussex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1343325260</td>\n",
       "      <td>43712954</td>\n",
       "      <td>POLYGON ((-74.97987 41.11042, -74.90526 41.155...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2256</th>\n",
       "      <td>34</td>\n",
       "      <td>035</td>\n",
       "      <td>00882234</td>\n",
       "      <td>0500000US34035</td>\n",
       "      <td>34035</td>\n",
       "      <td>Somerset</td>\n",
       "      <td>Somerset County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>781829190</td>\n",
       "      <td>7996119</td>\n",
       "      <td>POLYGON ((-74.79784 40.51556, -74.71315 40.583...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2348</th>\n",
       "      <td>34</td>\n",
       "      <td>003</td>\n",
       "      <td>00882271</td>\n",
       "      <td>0500000US34003</td>\n",
       "      <td>34003</td>\n",
       "      <td>Bergen</td>\n",
       "      <td>Bergen County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>602918754</td>\n",
       "      <td>35387155</td>\n",
       "      <td>POLYGON ((-74.25046 41.06082, -74.21162 41.132...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2415</th>\n",
       "      <td>34</td>\n",
       "      <td>005</td>\n",
       "      <td>00882272</td>\n",
       "      <td>0500000US34005</td>\n",
       "      <td>34005</td>\n",
       "      <td>Burlington</td>\n",
       "      <td>Burlington County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>2070157273</td>\n",
       "      <td>54113878</td>\n",
       "      <td>POLYGON ((-75.05902 39.99251, -74.98991 40.037...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2735</th>\n",
       "      <td>34</td>\n",
       "      <td>023</td>\n",
       "      <td>00882230</td>\n",
       "      <td>0500000US34023</td>\n",
       "      <td>34023</td>\n",
       "      <td>Middlesex</td>\n",
       "      <td>Middlesex County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>800881307</td>\n",
       "      <td>35356734</td>\n",
       "      <td>POLYGON ((-74.62024 40.37375, -74.58499 40.418...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2737</th>\n",
       "      <td>34</td>\n",
       "      <td>031</td>\n",
       "      <td>00882232</td>\n",
       "      <td>0500000US34031</td>\n",
       "      <td>34031</td>\n",
       "      <td>Passaic</td>\n",
       "      <td>Passaic County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>481772300</td>\n",
       "      <td>32052581</td>\n",
       "      <td>POLYGON ((-74.50321 41.08587, -74.36704 41.204...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2961</th>\n",
       "      <td>34</td>\n",
       "      <td>017</td>\n",
       "      <td>00882278</td>\n",
       "      <td>0500000US34017</td>\n",
       "      <td>34017</td>\n",
       "      <td>Hudson</td>\n",
       "      <td>Hudson County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>119640822</td>\n",
       "      <td>41836491</td>\n",
       "      <td>POLYGON ((-74.14753 40.78649, -74.09079 40.761...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3014</th>\n",
       "      <td>34</td>\n",
       "      <td>033</td>\n",
       "      <td>00882233</td>\n",
       "      <td>0500000US34033</td>\n",
       "      <td>34033</td>\n",
       "      <td>Salem</td>\n",
       "      <td>Salem County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>859519174</td>\n",
       "      <td>105385672</td>\n",
       "      <td>POLYGON ((-75.55945 39.62981, -75.53514 39.647...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3048</th>\n",
       "      <td>34</td>\n",
       "      <td>025</td>\n",
       "      <td>00882910</td>\n",
       "      <td>0500000US34025</td>\n",
       "      <td>34025</td>\n",
       "      <td>Monmouth</td>\n",
       "      <td>Monmouth County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1212585330</td>\n",
       "      <td>500431205</td>\n",
       "      <td>POLYGON ((-74.61458 40.18238, -74.54327 40.216...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3080</th>\n",
       "      <td>34</td>\n",
       "      <td>019</td>\n",
       "      <td>00882228</td>\n",
       "      <td>0500000US34019</td>\n",
       "      <td>34019</td>\n",
       "      <td>Hunterdon</td>\n",
       "      <td>Hunterdon County</td>\n",
       "      <td>NJ</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>06</td>\n",
       "      <td>1108086284</td>\n",
       "      <td>24761598</td>\n",
       "      <td>POLYGON ((-75.18820 40.59261, -75.14591 40.628...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     STATEFP COUNTYFP  COUNTYNS        AFFGEOID  GEOID        NAME  \\\n",
       "41        34      013  00882276  0500000US34013  34013       Essex   \n",
       "435       34      001  00882270  0500000US34001  34001    Atlantic   \n",
       "559       34      029  00882279  0500000US34029  34029       Ocean   \n",
       "601       34      027  00882231  0500000US34027  34027      Morris   \n",
       "1202      34      009  00882274  0500000US34009  34009    Cape May   \n",
       "1343      34      011  00882275  0500000US34011  34011  Cumberland   \n",
       "1544      34      021  00882229  0500000US34021  34021      Mercer   \n",
       "1602      34      015  00882277  0500000US34015  34015  Gloucester   \n",
       "1658      34      039  00882235  0500000US34039  34039       Union   \n",
       "1718      34      007  00882273  0500000US34007  34007      Camden   \n",
       "1971      34      041  00882237  0500000US34041  34041      Warren   \n",
       "2096      34      037  00882236  0500000US34037  34037      Sussex   \n",
       "2256      34      035  00882234  0500000US34035  34035    Somerset   \n",
       "2348      34      003  00882271  0500000US34003  34003      Bergen   \n",
       "2415      34      005  00882272  0500000US34005  34005  Burlington   \n",
       "2735      34      023  00882230  0500000US34023  34023   Middlesex   \n",
       "2737      34      031  00882232  0500000US34031  34031     Passaic   \n",
       "2961      34      017  00882278  0500000US34017  34017      Hudson   \n",
       "3014      34      033  00882233  0500000US34033  34033       Salem   \n",
       "3048      34      025  00882910  0500000US34025  34025    Monmouth   \n",
       "3080      34      019  00882228  0500000US34019  34019   Hunterdon   \n",
       "\n",
       "               NAMELSAD STUSPS  STATE_NAME LSAD       ALAND     AWATER  \\\n",
       "41         Essex County     NJ  New Jersey   06   326557433    8638155   \n",
       "435     Atlantic County     NJ  New Jersey   06  1438774368  301270979   \n",
       "559        Ocean County     NJ  New Jersey   06  1627252596  742162038   \n",
       "601       Morris County     NJ  New Jersey   06  1193911893   53230151   \n",
       "1202    Cape May County     NJ  New Jersey   06   651437935  955149083   \n",
       "1343  Cumberland County     NJ  New Jersey   06  1251898249  503713126   \n",
       "1544      Mercer County     NJ  New Jersey   06   581297767   11434809   \n",
       "1602  Gloucester County     NJ  New Jersey   06   833976887   38259771   \n",
       "1658       Union County     NJ  New Jersey   06   266163567    6847407   \n",
       "1718      Camden County     NJ  New Jersey   06   573315345   15699106   \n",
       "1971      Warren County     NJ  New Jersey   06   923435921   15822933   \n",
       "2096      Sussex County     NJ  New Jersey   06  1343325260   43712954   \n",
       "2256    Somerset County     NJ  New Jersey   06   781829190    7996119   \n",
       "2348      Bergen County     NJ  New Jersey   06   602918754   35387155   \n",
       "2415  Burlington County     NJ  New Jersey   06  2070157273   54113878   \n",
       "2735   Middlesex County     NJ  New Jersey   06   800881307   35356734   \n",
       "2737     Passaic County     NJ  New Jersey   06   481772300   32052581   \n",
       "2961      Hudson County     NJ  New Jersey   06   119640822   41836491   \n",
       "3014       Salem County     NJ  New Jersey   06   859519174  105385672   \n",
       "3048    Monmouth County     NJ  New Jersey   06  1212585330  500431205   \n",
       "3080   Hunterdon County     NJ  New Jersey   06  1108086284   24761598   \n",
       "\n",
       "                                               geometry  \n",
       "41    POLYGON ((-74.36714 40.76111, -74.32611 40.908...  \n",
       "435   POLYGON ((-74.91188 39.57846, -74.87726 39.608...  \n",
       "559   POLYGON ((-74.55311 40.07913, -74.40671 40.172...  \n",
       "601   POLYGON ((-74.85051 40.80396, -74.76942 40.910...  \n",
       "1202  POLYGON ((-74.95536 39.00126, -74.90366 39.087...  \n",
       "1343  POLYGON ((-75.41711 39.38891, -75.36821 39.456...  \n",
       "1544  POLYGON ((-74.92811 40.33983, -74.85626 40.346...  \n",
       "1602  POLYGON ((-75.41049 39.80467, -75.34176 39.846...  \n",
       "1658  POLYGON ((-74.46329 40.59919, -74.42440 40.619...  \n",
       "1718  POLYGON ((-75.13342 39.89621, -75.13459 39.922...  \n",
       "1971  POLYGON ((-75.19261 40.71587, -75.17748 40.764...  \n",
       "2096  POLYGON ((-74.97987 41.11042, -74.90526 41.155...  \n",
       "2256  POLYGON ((-74.79784 40.51556, -74.71315 40.583...  \n",
       "2348  POLYGON ((-74.25046 41.06082, -74.21162 41.132...  \n",
       "2415  POLYGON ((-75.05902 39.99251, -74.98991 40.037...  \n",
       "2735  POLYGON ((-74.62024 40.37375, -74.58499 40.418...  \n",
       "2737  POLYGON ((-74.50321 41.08587, -74.36704 41.204...  \n",
       "2961  POLYGON ((-74.14753 40.78649, -74.09079 40.761...  \n",
       "3014  POLYGON ((-75.55945 39.62981, -75.53514 39.647...  \n",
       "3048  POLYGON ((-74.61458 40.18238, -74.54327 40.216...  \n",
       "3080  POLYGON ((-75.18820 40.59261, -75.14591 40.628...  "
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATE</th>\n",
       "      <th>AREA</th>\n",
       "      <th>AGE_ADJUSTED_CI_LOWER</th>\n",
       "      <th>AGE_ADJUSTED_CI_UPPER</th>\n",
       "      <th>AGE_ADJUSTED_RATE</th>\n",
       "      <th>COUNT</th>\n",
       "      <th>EVENT_TYPE</th>\n",
       "      <th>POPULATION</th>\n",
       "      <th>RACE</th>\n",
       "      <th>SEX</th>\n",
       "      <th>SITE</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>CRUDE_CI_LOWER</th>\n",
       "      <th>CRUDE_CI_UPPER</th>\n",
       "      <th>CRUDE_RATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28416</th>\n",
       "      <td>AL</td>\n",
       "      <td>AL: Autauga County (01001)</td>\n",
       "      <td>399.1</td>\n",
       "      <td>463.4</td>\n",
       "      <td>430.3</td>\n",
       "      <td>727</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>141421</td>\n",
       "      <td>All Races</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>477.4</td>\n",
       "      <td>552.8</td>\n",
       "      <td>514.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28417</th>\n",
       "      <td>AL</td>\n",
       "      <td>AL: Autauga County (01001)</td>\n",
       "      <td>119.2</td>\n",
       "      <td>154.9</td>\n",
       "      <td>136.1</td>\n",
       "      <td>238</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>141421</td>\n",
       "      <td>All Races</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Cancer Sites Combined</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>147.6</td>\n",
       "      <td>191.1</td>\n",
       "      <td>168.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28418</th>\n",
       "      <td>AL</td>\n",
       "      <td>AL: Autauga County (01001)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>141421</td>\n",
       "      <td>All Races</td>\n",
       "      <td>Female</td>\n",
       "      <td>Brain and Other Nervous System</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28419</th>\n",
       "      <td>AL</td>\n",
       "      <td>AL: Autauga County (01001)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>141421</td>\n",
       "      <td>All Races</td>\n",
       "      <td>Female</td>\n",
       "      <td>Brain and Other Nervous System</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28420</th>\n",
       "      <td>AL</td>\n",
       "      <td>AL: Autauga County (01001)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>141421</td>\n",
       "      <td>All Races</td>\n",
       "      <td>Female</td>\n",
       "      <td>Cervix</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718055</th>\n",
       "      <td>WY</td>\n",
       "      <td>WY: Weston County (56045)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>17864</td>\n",
       "      <td>White</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>Testis</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718056</th>\n",
       "      <td>WY</td>\n",
       "      <td>WY: Weston County (56045)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>33965</td>\n",
       "      <td>White</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>Thyroid</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718057</th>\n",
       "      <td>WY</td>\n",
       "      <td>WY: Weston County (56045)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>33965</td>\n",
       "      <td>White</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>Thyroid</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718058</th>\n",
       "      <td>WY</td>\n",
       "      <td>WY: Weston County (56045)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Incidence</td>\n",
       "      <td>33965</td>\n",
       "      <td>White</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>Urinary Bladder</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718059</th>\n",
       "      <td>WY</td>\n",
       "      <td>WY: Weston County (56045)</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>Mortality</td>\n",
       "      <td>33965</td>\n",
       "      <td>White</td>\n",
       "      <td>Male and Female</td>\n",
       "      <td>Urinary Bladder</td>\n",
       "      <td>2014-2018</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "      <td>~</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2684754 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        STATE                        AREA AGE_ADJUSTED_CI_LOWER  \\\n",
       "28416      AL  AL: Autauga County (01001)                 399.1   \n",
       "28417      AL  AL: Autauga County (01001)                 119.2   \n",
       "28418      AL  AL: Autauga County (01001)                     ~   \n",
       "28419      AL  AL: Autauga County (01001)                     ~   \n",
       "28420      AL  AL: Autauga County (01001)                     ~   \n",
       "...       ...                         ...                   ...   \n",
       "2718055    WY   WY: Weston County (56045)                     ~   \n",
       "2718056    WY   WY: Weston County (56045)                     ~   \n",
       "2718057    WY   WY: Weston County (56045)                     ~   \n",
       "2718058    WY   WY: Weston County (56045)                     ~   \n",
       "2718059    WY   WY: Weston County (56045)                     ~   \n",
       "\n",
       "        AGE_ADJUSTED_CI_UPPER AGE_ADJUSTED_RATE COUNT EVENT_TYPE  POPULATION  \\\n",
       "28416                   463.4             430.3   727  Incidence      141421   \n",
       "28417                   154.9             136.1   238  Mortality      141421   \n",
       "28418                       ~                 ~     ~  Incidence      141421   \n",
       "28419                       ~                 ~     ~  Mortality      141421   \n",
       "28420                       ~                 ~     ~  Incidence      141421   \n",
       "...                       ...               ...   ...        ...         ...   \n",
       "2718055                     ~                 ~     ~  Mortality       17864   \n",
       "2718056                     ~                 ~     ~  Incidence       33965   \n",
       "2718057                     ~                 ~     ~  Mortality       33965   \n",
       "2718058                     ~                 ~     ~  Incidence       33965   \n",
       "2718059                     ~                 ~     ~  Mortality       33965   \n",
       "\n",
       "              RACE              SEX                            SITE  \\\n",
       "28416    All Races           Female       All Cancer Sites Combined   \n",
       "28417    All Races           Female       All Cancer Sites Combined   \n",
       "28418    All Races           Female  Brain and Other Nervous System   \n",
       "28419    All Races           Female  Brain and Other Nervous System   \n",
       "28420    All Races           Female                          Cervix   \n",
       "...            ...              ...                             ...   \n",
       "2718055      White  Male and Female                          Testis   \n",
       "2718056      White  Male and Female                         Thyroid   \n",
       "2718057      White  Male and Female                         Thyroid   \n",
       "2718058      White  Male and Female                 Urinary Bladder   \n",
       "2718059      White  Male and Female                 Urinary Bladder   \n",
       "\n",
       "              YEAR CRUDE_CI_LOWER CRUDE_CI_UPPER CRUDE_RATE  \n",
       "28416    2014-2018          477.4          552.8      514.1  \n",
       "28417    2014-2018          147.6          191.1      168.3  \n",
       "28418    2014-2018              ~              ~          ~  \n",
       "28419    2014-2018              ~              ~          ~  \n",
       "28420    2014-2018              ~              ~          ~  \n",
       "...            ...            ...            ...        ...  \n",
       "2718055  2014-2018              ~              ~          ~  \n",
       "2718056  2014-2018              ~              ~          ~  \n",
       "2718057  2014-2018              ~              ~          ~  \n",
       "2718058  2014-2018              ~              ~          ~  \n",
       "2718059  2014-2018              ~              ~          ~  \n",
       "\n",
       "[2684754 rows x 15 columns]"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "by_county"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "3f05f904208be84caf8b657309614a48fcf696a50650fab2e63768aa325b810b"
  },
  "kernelspec": {
   "display_name": "Python 3.7.1 ('base')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.12"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}