notebooks/Exploring Variables.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "8ea9f424-c378-4acb-8e0a-979e8d039c10",
   "metadata": {},
   "source": [
    "# Exploring a Group of Variables\n",
    "\n",
    "There are thousands of different variables avaialble via the US Census\n",
    "API. One way to navigate through them is to look through a hierarchy\n",
    "of web pages starting with a year, like 2020, on a page like \n",
    "https://api.census.gov/data/2020.html. \n",
    "\n",
    "From here we can navigate down\n",
    "to a particular data source, by following the link \n",
    "in the *Group List* column of the first row, which is for the dataset\n",
    "`acs/acs5`. This takes us to \n",
    "https://api.census.gov/data/2020/acs/acs5/groups.html. \n",
    "\n",
    "From there,\n",
    "we can choose the group named B03002, which takes us to \n",
    "https://api.census.gov/data/2020/acs/acs5/groups/B03002.html, where we \n",
    "can see all the variables in the group. \n",
    "\n",
    "Some of these variables are estimates,\n",
    "and some of them are annotations. Normally, we are interested in the estimates.\n",
    "\n",
    "Every variable has a label, which is a string of components seperated by\n",
    "!!. For example, B03002_007E has the label, \n",
    "\"Estimate!!Total:!!Not Hispanic or Latino:!!Native Hawaiian and Other Pacific Islander alone\".\n",
    "The !! seperators imply a tree among the variables, from the root all the way down\n",
    "to leaves. Internal nodes in the tree represent variables that are aggregates of \n",
    "those lower than them in the tree. For example, B03002_002E is the size of the \n",
    "population that is not Hispanic or Latino, regardless of race. It is the sum of\n",
    "B03002_003E, B03002_004E, B03002_005E, B03002_006E, B03002_007E, B03002_008E, and B03002_009E,\n",
    "which count people of different races who are not Hispanic or Latino. All of these\n",
    "are leaves of the tree, except B03002_009E, which is further subdivided into\n",
    "B03002_010E and B03002_011E.\n",
    "\n",
    "All of this can get really confusing when you look at it in the tabular form\n",
    "on the web page. In order to make it less confusing, the `censusdis` package\n",
    "includes code to fetch and present the variable hierarchy in a more understandable\n",
    "way. That's what the remainder of this notebook is about."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "64eb8577-e145-4a74-be7b-bff9798945eb",
   "metadata": {},
   "source": [
    "## Import and Configuration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f047c3d9-1313-4a5b-93d5-a63cb0143feb",
   "metadata": {},
   "outputs": [],
   "source": [
    "import censusdis.data as ced\n",
    "import censusdis.geography as cgeo\n",
    "from censusdis.states import STATE_NJ"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0da51fff-7082-4ee0-be2c-f6b5b6dfface",
   "metadata": {},
   "outputs": [],
   "source": [
    "YEAR = 2020\n",
    "DATASET = \"acs/acs5\"\n",
    "GROUP = \"B03002\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aa789c6e-1f91-4d0f-9f03-56bf9151f484",
   "metadata": {},
   "source": [
    "## Programmatic Access to a Group Variable Tree\n",
    "\n",
    "We can get the whole collection of variables in tree form and print it.\n",
    "This format makes it easier to see the relationships we saw in the\n",
    "table at https://api.census.gov/data/2020/acs/acs5/groups/B03002.html.\n",
    "\n",
    "We can see clearly where variables exist at internal nodes of the tree\n",
    "and where they exist at the leaves. Not all internal nodes have variables\n",
    "but all leaves do."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b0429d06-d3f9-4eb3-83a5-7c653b1dd7f2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+ Estimate\n",
      "    + Total: (B03002_001E)\n",
      "        + Not Hispanic or Latino: (B03002_002E)\n",
      "            + White alone (B03002_003E)\n",
      "            + Black or African American alone (B03002_004E)\n",
      "            + American Indian and Alaska Native alone (B03002_005E)\n",
      "            + Asian alone (B03002_006E)\n",
      "            + Native Hawaiian and Other Pacific Islander alone (B03002_007E)\n",
      "            + Some other race alone (B03002_008E)\n",
      "            + Two or more races: (B03002_009E)\n",
      "                + Two races including Some other race (B03002_010E)\n",
      "                + Two races excluding Some other race, and three or more races (B03002_011E)\n",
      "        + Hispanic or Latino: (B03002_012E)\n",
      "            + White alone (B03002_013E)\n",
      "            + Black or African American alone (B03002_014E)\n",
      "            + American Indian and Alaska Native alone (B03002_015E)\n",
      "            + Asian alone (B03002_016E)\n",
      "            + Native Hawaiian and Other Pacific Islander alone (B03002_017E)\n",
      "            + Some other race alone (B03002_018E)\n",
      "            + Two or more races: (B03002_019E)\n",
      "                + Two races including Some other race (B03002_020E)\n",
      "                + Two races excluding Some other race, and three or more races (B03002_021E)\n"
     ]
    }
   ],
   "source": [
    "tree = ced.variables.group_tree(DATASET, YEAR, GROUP)\n",
    "print(tree)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c0bf6115-7c78-479b-b9da-768d921d29dd",
   "metadata": {},
   "source": [
    "### Accessing a Sub-Tree\n",
    "\n",
    "Most of the time we are only interested in variables that are estimates, so \n",
    "we can look down in that part of the tree alone."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0215cab8-58e1-493a-a606-4bd89f23a0cc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+ Total: (B03002_001E)\n",
      "    + Not Hispanic or Latino: (B03002_002E)\n",
      "        + White alone (B03002_003E)\n",
      "        + Black or African American alone (B03002_004E)\n",
      "        + American Indian and Alaska Native alone (B03002_005E)\n",
      "        + Asian alone (B03002_006E)\n",
      "        + Native Hawaiian and Other Pacific Islander alone (B03002_007E)\n",
      "        + Some other race alone (B03002_008E)\n",
      "        + Two or more races: (B03002_009E)\n",
      "            + Two races including Some other race (B03002_010E)\n",
      "            + Two races excluding Some other race, and three or more races (B03002_011E)\n",
      "    + Hispanic or Latino: (B03002_012E)\n",
      "        + White alone (B03002_013E)\n",
      "        + Black or African American alone (B03002_014E)\n",
      "        + American Indian and Alaska Native alone (B03002_015E)\n",
      "        + Asian alone (B03002_016E)\n",
      "        + Native Hawaiian and Other Pacific Islander alone (B03002_017E)\n",
      "        + Some other race alone (B03002_018E)\n",
      "        + Two or more races: (B03002_019E)\n",
      "            + Two races including Some other race (B03002_020E)\n",
      "            + Two races excluding Some other race, and three or more races (B03002_021E)\n"
     ]
    }
   ],
   "source": [
    "print(tree[\"Estimate\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c902b36d-4778-4f03-a51e-4a807b33906b",
   "metadata": {},
   "source": [
    "### Leaves\n",
    "\n",
    "In many cases, we are really just interested in the leaves, because the\n",
    "internal nodes of the tree contain variables that are aggregate sums of the \n",
    "subtrees below them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "90e6ba8c-404d-4d50-abf6-6526d00c4c69",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['B03002_003E',\n",
       " 'B03002_004E',\n",
       " 'B03002_005E',\n",
       " 'B03002_006E',\n",
       " 'B03002_007E',\n",
       " 'B03002_008E',\n",
       " 'B03002_010E',\n",
       " 'B03002_011E',\n",
       " 'B03002_013E',\n",
       " 'B03002_014E',\n",
       " 'B03002_015E',\n",
       " 'B03002_016E',\n",
       " 'B03002_017E',\n",
       " 'B03002_018E',\n",
       " 'B03002_020E',\n",
       " 'B03002_021E']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "leaves = ced.variables.group_leaves(DATASET, YEAR, GROUP)\n",
    "leaves"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "89782e3c-b0cb-4f9d-8282-dc631b6e8f19",
   "metadata": {},
   "source": [
    "Notice that the set of leaves we got does not include those for\n",
    "annotations. If we really want to see those too, we can add an\n",
    "optional argument."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "baa2920d-4de7-4053-92e0-0b246986d3b9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['B03002_003E',\n",
       " 'B03002_004E',\n",
       " 'B03002_005E',\n",
       " 'B03002_006E',\n",
       " 'B03002_007E',\n",
       " 'B03002_008E',\n",
       " 'B03002_010E',\n",
       " 'B03002_011E',\n",
       " 'B03002_013E',\n",
       " 'B03002_014E',\n",
       " 'B03002_015E',\n",
       " 'B03002_016E',\n",
       " 'B03002_017E',\n",
       " 'B03002_018E',\n",
       " 'B03002_020E',\n",
       " 'B03002_021E']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_leaves = ced.variables.group_leaves(DATASET, YEAR, GROUP, skip_annotations=False)\n",
    "all_leaves"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d0bfbe81-254e-437d-b54e-5d5fb16ad62b",
   "metadata": {},
   "source": [
    "## Programmatic Access to Geographic Hierarchies\n",
    "\n",
    "It's great to know the variables that are available, but in order to make full\n",
    "use of the US Census API and the `censusdis` API around it, we have to know \n",
    "something about the geography hierarchies that are avaialble for each dataset \n",
    "in each year it is available. These are available on web pages like \n",
    "https://api.census.gov/data/2020/acs/acs5/geography.html, which contains a table\n",
    "of the geographies supported by the ACS5 dataset we have been looking at\n",
    "for the year 2020.\n",
    "\n",
    "But again, we'd prefer to have access to this information in a pythonic way.\n",
    "The most common way to get this is by calling `censusdis.geography.geo_path_py_specs` \n",
    "as shown below. This gives us the available hierarchies using Python-friendly\n",
    "snake-case names that we can use to download data.\n",
    "\n",
    "Each item in the dictionary has a key that represents the geography hierarchy and\n",
    "a value that is the list of the components of the hierachy in snake-case as it can\n",
    "be passed as an argument to `censusdis.data.download`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "4a3b2170-1ff7-4a68-89c4-5c426896de7b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'010': ['us'],\n",
       " '020': ['region'],\n",
       " '030': ['division'],\n",
       " '040': ['state'],\n",
       " '050': ['state', 'county'],\n",
       " '060': ['state', 'county', 'county_subdivision'],\n",
       " '067': ['state', 'county', 'county_subdivision', 'subminor_civil_division'],\n",
       " '070': ['state', 'county', 'county_subdivision', 'place_remainder_or_part'],\n",
       " '140': ['state', 'county', 'tract'],\n",
       " '150': ['state', 'county', 'tract', 'block_group'],\n",
       " '155': ['state', 'place', 'county_or_part'],\n",
       " '160': ['state', 'place'],\n",
       " '170': ['state', 'consolidated_city'],\n",
       " '172': ['state', 'consolidated_city', 'place_or_part'],\n",
       " '230': ['state', 'alaska_native_regional_corporation'],\n",
       " '250': ['american_indian_area_alaska_native_area_hawaiian_home_land'],\n",
       " '251': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'tribal_subdivision_remainder'],\n",
       " '252': ['american_indian_area_alaska_native_area_reservation_or_statistical_entity_only'],\n",
       " '254': ['american_indian_area_off_reservation_trust_land_only_hawaiian_home_land'],\n",
       " '256': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'tribal_census_tract'],\n",
       " '258': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'tribal_census_tract',\n",
       "  'tribal_block_group'],\n",
       " '260': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'state_or_part'],\n",
       " '269': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'state_or_part',\n",
       "  'place_remainder_or_part'],\n",
       " '270': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'state_or_part',\n",
       "  'county_or_part'],\n",
       " '280': ['state',\n",
       "  'american_indian_area_alaska_native_area_hawaiian_home_land_or_part'],\n",
       " '283': ['state',\n",
       "  'american_indian_area_alaska_native_area_reservation_or_statistical_entity_only_or_part'],\n",
       " '286': ['state',\n",
       "  'american_indian_area_off_reservation_trust_land_only_hawaiian_home_land_or_part'],\n",
       " '290': ['american_indian_area_alaska_native_area_hawaiian_home_land',\n",
       "  'tribal_subdivision_remainder',\n",
       "  'state_or_part'],\n",
       " '291': ['american_indian_area_reservation_only',\n",
       "  'tribal_census_tract_or_part'],\n",
       " '292': ['american_indian_area_off_reservation_trust_land_only_hawaiian_home_land',\n",
       "  'tribal_census_tract_or_part'],\n",
       " '293': ['american_indian_area_reservation_only',\n",
       "  'tribal_census_tract_or_part',\n",
       "  'tribal_block_group_or_part'],\n",
       " '294': ['american_indian_area_off_reservation_trust_land_only_hawaiian_home_land',\n",
       "  'tribal_census_tract_or_part',\n",
       "  'tribal_block_group_or_part'],\n",
       " '310': ['metropolitan_statistical_area_micropolitan_statistical_area'],\n",
       " '311': ['metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'state_or_part'],\n",
       " '312': ['metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'state_or_part',\n",
       "  'principal_city_or_part'],\n",
       " '313': ['metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'state_or_part',\n",
       "  'county'],\n",
       " '314': ['metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'metropolitan_division'],\n",
       " '315': ['metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'metropolitan_division',\n",
       "  'state_or_part'],\n",
       " '316': ['metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'metropolitan_division',\n",
       "  'state_or_part',\n",
       "  'county'],\n",
       " '320': ['state',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area_or_part'],\n",
       " '321': ['state',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area_or_part',\n",
       "  'principal_city_or_part'],\n",
       " '322': ['state',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area_or_part',\n",
       "  'county'],\n",
       " '323': ['state',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area_or_part',\n",
       "  'metropolitan_division_or_part'],\n",
       " '324': ['state',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area_or_part',\n",
       "  'metropolitan_division_or_part',\n",
       "  'county'],\n",
       " '330': ['combined_statistical_area'],\n",
       " '331': ['combined_statistical_area', 'state_or_part'],\n",
       " '332': ['combined_statistical_area',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area'],\n",
       " '333': ['combined_statistical_area',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area',\n",
       "  'state_or_part'],\n",
       " '335': ['combined_new_england_city_and_town_area'],\n",
       " '336': ['combined_new_england_city_and_town_area', 'state_or_part'],\n",
       " '337': ['combined_new_england_city_and_town_area',\n",
       "  'new_england_city_and_town_area'],\n",
       " '338': ['combined_new_england_city_and_town_area',\n",
       "  'new_england_city_and_town_area',\n",
       "  'state_or_part'],\n",
       " '340': ['state', 'combined_statistical_area_or_part'],\n",
       " '341': ['state',\n",
       "  'combined_statistical_area_or_part',\n",
       "  'metropolitan_statistical_area_micropolitan_statistical_area_or_part'],\n",
       " '345': ['state', 'combined_new_england_city_and_town_area_or_part'],\n",
       " '346': ['state',\n",
       "  'combined_new_england_city_and_town_area_or_part',\n",
       "  'new_england_city_and_town_area_or_part'],\n",
       " '350': ['new_england_city_and_town_area'],\n",
       " '351': ['new_england_city_and_town_area', 'state_or_part'],\n",
       " '352': ['new_england_city_and_town_area', 'state_or_part', 'principal_city'],\n",
       " '353': ['new_england_city_and_town_area', 'state_or_part', 'county_or_part'],\n",
       " '354': ['new_england_city_and_town_area',\n",
       "  'state_or_part',\n",
       "  'county_or_part',\n",
       "  'county_subdivision'],\n",
       " '355': ['new_england_city_and_town_area', 'necta_division'],\n",
       " '356': ['new_england_city_and_town_area', 'necta_division', 'state_or_part'],\n",
       " '357': ['new_england_city_and_town_area',\n",
       "  'necta_division',\n",
       "  'state_or_part',\n",
       "  'county_or_part'],\n",
       " '358': ['new_england_city_and_town_area',\n",
       "  'necta_division',\n",
       "  'state_or_part',\n",
       "  'county_or_part',\n",
       "  'county_subdivision'],\n",
       " '360': ['state', 'new_england_city_and_town_area_or_part'],\n",
       " '361': ['state', 'new_england_city_and_town_area_or_part', 'principal_city'],\n",
       " '362': ['state', 'new_england_city_and_town_area_or_part', 'county_or_part'],\n",
       " '363': ['state',\n",
       "  'new_england_city_and_town_area_or_part',\n",
       "  'county_or_part',\n",
       "  'county_subdivision'],\n",
       " '364': ['state',\n",
       "  'new_england_city_and_town_area_or_part',\n",
       "  'necta_division_or_part'],\n",
       " '365': ['state',\n",
       "  'new_england_city_and_town_area_or_part',\n",
       "  'necta_division_or_part',\n",
       "  'county_or_part'],\n",
       " '366': ['state',\n",
       "  'new_england_city_and_town_area_or_part',\n",
       "  'necta_division_or_part',\n",
       "  'county_or_part',\n",
       "  'county_subdivision'],\n",
       " '400': ['urban_area'],\n",
       " '410': ['urban_area', 'state'],\n",
       " '430': ['urban_area', 'state', 'county'],\n",
       " '500': ['state', 'congressional_district'],\n",
       " '510': ['state', 'congressional_district', 'county_or_part'],\n",
       " '550': ['state',\n",
       "  'congressional_district',\n",
       "  'american_indian_area_alaska_native_area_hawaiian_home_land_or_part'],\n",
       " '610': ['state', 'state_legislative_district_upper_chamber'],\n",
       " '612': ['state',\n",
       "  'state_legislative_district_upper_chamber',\n",
       "  'county_or_part'],\n",
       " '620': ['state', 'state_legislative_district_lower_chamber'],\n",
       " '622': ['state',\n",
       "  'state_legislative_district_lower_chamber',\n",
       "  'county_or_part'],\n",
       " '795': ['state', 'public_use_microdata_area'],\n",
       " '860': ['zip_code_tabulation_area'],\n",
       " '950': ['state', 'school_district_elementary'],\n",
       " '960': ['state', 'school_district_secondary'],\n",
       " '970': ['state', 'school_district_unified']}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cgeo.geo_path_snake_specs(DATASET, YEAR)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f322420c-7af5-4548-ab68-3cfb075c9ea8",
   "metadata": {},
   "source": [
    "## Loading Data for Leaves\n",
    "\n",
    "Once we know the variables we want, for example the leaves of group B03002 that we found\n",
    "above, and we select one of the geogpraphy types and fill in the particular values we want\n",
    "at each level, we can load data for them. In our case, we will use the one with the key `'610'`,\n",
    "which represents the districts of the upper house of the legeslature of a state. The value\n",
    "associated with that key is a list of the keyword arguments we can pass to `censusdis.data.download`\n",
    "to specifiy what state and what district or disctricts within the state we want data for.\n",
    "\n",
    "This call will load data for all the variablles at the leaves of the dataset we examined earlier for\n",
    "all state senate districts in NJ by using the keyword arguments \n",
    "`state=STATE_NJ` and `state_legislative_district_upper_chamber=\"*\"`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "03f1115d-ca1d-45a9-9d9d-c9c6877ca7ca",
   "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>STATE_LEGISLATIVE_DISTRICT_UPPER_CHAMBER</th>\n",
       "      <th>B03002_003E</th>\n",
       "      <th>B03002_004E</th>\n",
       "      <th>B03002_005E</th>\n",
       "      <th>B03002_006E</th>\n",
       "      <th>B03002_007E</th>\n",
       "      <th>B03002_008E</th>\n",
       "      <th>B03002_010E</th>\n",
       "      <th>B03002_011E</th>\n",
       "      <th>B03002_013E</th>\n",
       "      <th>B03002_014E</th>\n",
       "      <th>B03002_015E</th>\n",
       "      <th>B03002_016E</th>\n",
       "      <th>B03002_017E</th>\n",
       "      <th>B03002_018E</th>\n",
       "      <th>B03002_020E</th>\n",
       "      <th>B03002_021E</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34</td>\n",
       "      <td>001</td>\n",
       "      <td>142196</td>\n",
       "      <td>21618</td>\n",
       "      <td>925</td>\n",
       "      <td>1963</td>\n",
       "      <td>6</td>\n",
       "      <td>371</td>\n",
       "      <td>487</td>\n",
       "      <td>4965</td>\n",
       "      <td>24460</td>\n",
       "      <td>1820</td>\n",
       "      <td>191</td>\n",
       "      <td>107</td>\n",
       "      <td>25</td>\n",
       "      <td>9969</td>\n",
       "      <td>2943</td>\n",
       "      <td>1306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34</td>\n",
       "      <td>002</td>\n",
       "      <td>107867</td>\n",
       "      <td>31770</td>\n",
       "      <td>547</td>\n",
       "      <td>17962</td>\n",
       "      <td>98</td>\n",
       "      <td>650</td>\n",
       "      <td>694</td>\n",
       "      <td>5588</td>\n",
       "      <td>16532</td>\n",
       "      <td>1398</td>\n",
       "      <td>694</td>\n",
       "      <td>128</td>\n",
       "      <td>16</td>\n",
       "      <td>18301</td>\n",
       "      <td>4893</td>\n",
       "      <td>1337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34</td>\n",
       "      <td>003</td>\n",
       "      <td>149678</td>\n",
       "      <td>33696</td>\n",
       "      <td>452</td>\n",
       "      <td>4264</td>\n",
       "      <td>24</td>\n",
       "      <td>237</td>\n",
       "      <td>358</td>\n",
       "      <td>4327</td>\n",
       "      <td>15417</td>\n",
       "      <td>931</td>\n",
       "      <td>179</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>6880</td>\n",
       "      <td>3862</td>\n",
       "      <td>590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34</td>\n",
       "      <td>004</td>\n",
       "      <td>148292</td>\n",
       "      <td>39088</td>\n",
       "      <td>216</td>\n",
       "      <td>7032</td>\n",
       "      <td>17</td>\n",
       "      <td>507</td>\n",
       "      <td>411</td>\n",
       "      <td>5723</td>\n",
       "      <td>8885</td>\n",
       "      <td>2564</td>\n",
       "      <td>287</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>5886</td>\n",
       "      <td>1202</td>\n",
       "      <td>1466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>34</td>\n",
       "      <td>005</td>\n",
       "      <td>114996</td>\n",
       "      <td>42660</td>\n",
       "      <td>206</td>\n",
       "      <td>7225</td>\n",
       "      <td>18</td>\n",
       "      <td>690</td>\n",
       "      <td>142</td>\n",
       "      <td>3783</td>\n",
       "      <td>16543</td>\n",
       "      <td>2455</td>\n",
       "      <td>239</td>\n",
       "      <td>64</td>\n",
       "      <td>24</td>\n",
       "      <td>24589</td>\n",
       "      <td>5088</td>\n",
       "      <td>963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>34</td>\n",
       "      <td>006</td>\n",
       "      <td>144747</td>\n",
       "      <td>22647</td>\n",
       "      <td>138</td>\n",
       "      <td>21829</td>\n",
       "      <td>63</td>\n",
       "      <td>1447</td>\n",
       "      <td>570</td>\n",
       "      <td>4509</td>\n",
       "      <td>11936</td>\n",
       "      <td>1762</td>\n",
       "      <td>92</td>\n",
       "      <td>40</td>\n",
       "      <td>71</td>\n",
       "      <td>9901</td>\n",
       "      <td>2583</td>\n",
       "      <td>1188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>34</td>\n",
       "      <td>007</td>\n",
       "      <td>134612</td>\n",
       "      <td>47217</td>\n",
       "      <td>52</td>\n",
       "      <td>12108</td>\n",
       "      <td>50</td>\n",
       "      <td>871</td>\n",
       "      <td>561</td>\n",
       "      <td>7288</td>\n",
       "      <td>9159</td>\n",
       "      <td>1511</td>\n",
       "      <td>332</td>\n",
       "      <td>207</td>\n",
       "      <td>4</td>\n",
       "      <td>4596</td>\n",
       "      <td>2102</td>\n",
       "      <td>948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>34</td>\n",
       "      <td>008</td>\n",
       "      <td>160610</td>\n",
       "      <td>22823</td>\n",
       "      <td>35</td>\n",
       "      <td>7878</td>\n",
       "      <td>113</td>\n",
       "      <td>388</td>\n",
       "      <td>561</td>\n",
       "      <td>6264</td>\n",
       "      <td>8291</td>\n",
       "      <td>1528</td>\n",
       "      <td>170</td>\n",
       "      <td>49</td>\n",
       "      <td>134</td>\n",
       "      <td>4174</td>\n",
       "      <td>2510</td>\n",
       "      <td>984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>34</td>\n",
       "      <td>009</td>\n",
       "      <td>194162</td>\n",
       "      <td>7586</td>\n",
       "      <td>117</td>\n",
       "      <td>5480</td>\n",
       "      <td>46</td>\n",
       "      <td>418</td>\n",
       "      <td>196</td>\n",
       "      <td>4949</td>\n",
       "      <td>11273</td>\n",
       "      <td>928</td>\n",
       "      <td>12</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>3328</td>\n",
       "      <td>1989</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>34</td>\n",
       "      <td>010</td>\n",
       "      <td>188982</td>\n",
       "      <td>7378</td>\n",
       "      <td>188</td>\n",
       "      <td>5765</td>\n",
       "      <td>136</td>\n",
       "      <td>986</td>\n",
       "      <td>209</td>\n",
       "      <td>4130</td>\n",
       "      <td>11925</td>\n",
       "      <td>653</td>\n",
       "      <td>114</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>4483</td>\n",
       "      <td>2396</td>\n",
       "      <td>689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>34</td>\n",
       "      <td>011</td>\n",
       "      <td>139559</td>\n",
       "      <td>29607</td>\n",
       "      <td>133</td>\n",
       "      <td>7849</td>\n",
       "      <td>11</td>\n",
       "      <td>776</td>\n",
       "      <td>599</td>\n",
       "      <td>4654</td>\n",
       "      <td>18109</td>\n",
       "      <td>1774</td>\n",
       "      <td>297</td>\n",
       "      <td>46</td>\n",
       "      <td>15</td>\n",
       "      <td>10266</td>\n",
       "      <td>3385</td>\n",
       "      <td>1317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>34</td>\n",
       "      <td>012</td>\n",
       "      <td>161981</td>\n",
       "      <td>14825</td>\n",
       "      <td>172</td>\n",
       "      <td>17919</td>\n",
       "      <td>0</td>\n",
       "      <td>321</td>\n",
       "      <td>543</td>\n",
       "      <td>3885</td>\n",
       "      <td>16380</td>\n",
       "      <td>1193</td>\n",
       "      <td>141</td>\n",
       "      <td>136</td>\n",
       "      <td>0</td>\n",
       "      <td>4129</td>\n",
       "      <td>3543</td>\n",
       "      <td>428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>34</td>\n",
       "      <td>013</td>\n",
       "      <td>176797</td>\n",
       "      <td>5123</td>\n",
       "      <td>115</td>\n",
       "      <td>17925</td>\n",
       "      <td>71</td>\n",
       "      <td>433</td>\n",
       "      <td>762</td>\n",
       "      <td>3196</td>\n",
       "      <td>10866</td>\n",
       "      <td>207</td>\n",
       "      <td>154</td>\n",
       "      <td>66</td>\n",
       "      <td>9</td>\n",
       "      <td>2256</td>\n",
       "      <td>1645</td>\n",
       "      <td>505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>34</td>\n",
       "      <td>014</td>\n",
       "      <td>129659</td>\n",
       "      <td>18482</td>\n",
       "      <td>222</td>\n",
       "      <td>37101</td>\n",
       "      <td>63</td>\n",
       "      <td>284</td>\n",
       "      <td>591</td>\n",
       "      <td>3335</td>\n",
       "      <td>20948</td>\n",
       "      <td>1050</td>\n",
       "      <td>28</td>\n",
       "      <td>167</td>\n",
       "      <td>7</td>\n",
       "      <td>4978</td>\n",
       "      <td>2207</td>\n",
       "      <td>849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>34</td>\n",
       "      <td>015</td>\n",
       "      <td>88586</td>\n",
       "      <td>55027</td>\n",
       "      <td>407</td>\n",
       "      <td>23661</td>\n",
       "      <td>29</td>\n",
       "      <td>161</td>\n",
       "      <td>278</td>\n",
       "      <td>3645</td>\n",
       "      <td>23449</td>\n",
       "      <td>2288</td>\n",
       "      <td>525</td>\n",
       "      <td>35</td>\n",
       "      <td>164</td>\n",
       "      <td>9688</td>\n",
       "      <td>4578</td>\n",
       "      <td>468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>34</td>\n",
       "      <td>016</td>\n",
       "      <td>138275</td>\n",
       "      <td>11402</td>\n",
       "      <td>512</td>\n",
       "      <td>48874</td>\n",
       "      <td>29</td>\n",
       "      <td>1049</td>\n",
       "      <td>1224</td>\n",
       "      <td>4449</td>\n",
       "      <td>12458</td>\n",
       "      <td>581</td>\n",
       "      <td>168</td>\n",
       "      <td>51</td>\n",
       "      <td>46</td>\n",
       "      <td>3262</td>\n",
       "      <td>2454</td>\n",
       "      <td>458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>34</td>\n",
       "      <td>017</td>\n",
       "      <td>70856</td>\n",
       "      <td>45295</td>\n",
       "      <td>353</td>\n",
       "      <td>52596</td>\n",
       "      <td>24</td>\n",
       "      <td>1699</td>\n",
       "      <td>1144</td>\n",
       "      <td>3791</td>\n",
       "      <td>31629</td>\n",
       "      <td>2269</td>\n",
       "      <td>474</td>\n",
       "      <td>129</td>\n",
       "      <td>6</td>\n",
       "      <td>13613</td>\n",
       "      <td>2775</td>\n",
       "      <td>602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>34</td>\n",
       "      <td>018</td>\n",
       "      <td>96906</td>\n",
       "      <td>16389</td>\n",
       "      <td>144</td>\n",
       "      <td>69965</td>\n",
       "      <td>198</td>\n",
       "      <td>1125</td>\n",
       "      <td>1769</td>\n",
       "      <td>4270</td>\n",
       "      <td>13519</td>\n",
       "      <td>716</td>\n",
       "      <td>107</td>\n",
       "      <td>139</td>\n",
       "      <td>9</td>\n",
       "      <td>7926</td>\n",
       "      <td>3235</td>\n",
       "      <td>1546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>34</td>\n",
       "      <td>019</td>\n",
       "      <td>82172</td>\n",
       "      <td>21725</td>\n",
       "      <td>234</td>\n",
       "      <td>37332</td>\n",
       "      <td>91</td>\n",
       "      <td>1005</td>\n",
       "      <td>836</td>\n",
       "      <td>2655</td>\n",
       "      <td>52658</td>\n",
       "      <td>3034</td>\n",
       "      <td>493</td>\n",
       "      <td>348</td>\n",
       "      <td>42</td>\n",
       "      <td>15201</td>\n",
       "      <td>7470</td>\n",
       "      <td>2693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>34</td>\n",
       "      <td>020</td>\n",
       "      <td>43416</td>\n",
       "      <td>64102</td>\n",
       "      <td>124</td>\n",
       "      <td>9020</td>\n",
       "      <td>32</td>\n",
       "      <td>6246</td>\n",
       "      <td>1034</td>\n",
       "      <td>2581</td>\n",
       "      <td>39353</td>\n",
       "      <td>3078</td>\n",
       "      <td>894</td>\n",
       "      <td>278</td>\n",
       "      <td>0</td>\n",
       "      <td>50647</td>\n",
       "      <td>8436</td>\n",
       "      <td>1632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>34</td>\n",
       "      <td>021</td>\n",
       "      <td>157029</td>\n",
       "      <td>7157</td>\n",
       "      <td>130</td>\n",
       "      <td>23822</td>\n",
       "      <td>4</td>\n",
       "      <td>2092</td>\n",
       "      <td>178</td>\n",
       "      <td>4102</td>\n",
       "      <td>13664</td>\n",
       "      <td>764</td>\n",
       "      <td>27</td>\n",
       "      <td>252</td>\n",
       "      <td>9</td>\n",
       "      <td>6667</td>\n",
       "      <td>3113</td>\n",
       "      <td>745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>34</td>\n",
       "      <td>022</td>\n",
       "      <td>85166</td>\n",
       "      <td>48110</td>\n",
       "      <td>302</td>\n",
       "      <td>10880</td>\n",
       "      <td>0</td>\n",
       "      <td>1933</td>\n",
       "      <td>526</td>\n",
       "      <td>3266</td>\n",
       "      <td>30431</td>\n",
       "      <td>2802</td>\n",
       "      <td>751</td>\n",
       "      <td>82</td>\n",
       "      <td>53</td>\n",
       "      <td>27643</td>\n",
       "      <td>6986</td>\n",
       "      <td>1867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>34</td>\n",
       "      <td>023</td>\n",
       "      <td>158090</td>\n",
       "      <td>8589</td>\n",
       "      <td>137</td>\n",
       "      <td>17450</td>\n",
       "      <td>67</td>\n",
       "      <td>547</td>\n",
       "      <td>823</td>\n",
       "      <td>2975</td>\n",
       "      <td>14501</td>\n",
       "      <td>537</td>\n",
       "      <td>76</td>\n",
       "      <td>227</td>\n",
       "      <td>10</td>\n",
       "      <td>5269</td>\n",
       "      <td>3280</td>\n",
       "      <td>900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>34</td>\n",
       "      <td>024</td>\n",
       "      <td>172261</td>\n",
       "      <td>5102</td>\n",
       "      <td>54</td>\n",
       "      <td>5774</td>\n",
       "      <td>0</td>\n",
       "      <td>366</td>\n",
       "      <td>550</td>\n",
       "      <td>3145</td>\n",
       "      <td>13744</td>\n",
       "      <td>509</td>\n",
       "      <td>33</td>\n",
       "      <td>38</td>\n",
       "      <td>18</td>\n",
       "      <td>2185</td>\n",
       "      <td>2191</td>\n",
       "      <td>778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>34</td>\n",
       "      <td>025</td>\n",
       "      <td>149612</td>\n",
       "      <td>8463</td>\n",
       "      <td>95</td>\n",
       "      <td>12998</td>\n",
       "      <td>0</td>\n",
       "      <td>520</td>\n",
       "      <td>435</td>\n",
       "      <td>4235</td>\n",
       "      <td>23251</td>\n",
       "      <td>561</td>\n",
       "      <td>398</td>\n",
       "      <td>33</td>\n",
       "      <td>43</td>\n",
       "      <td>8778</td>\n",
       "      <td>3354</td>\n",
       "      <td>1009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>34</td>\n",
       "      <td>026</td>\n",
       "      <td>158999</td>\n",
       "      <td>3980</td>\n",
       "      <td>312</td>\n",
       "      <td>29933</td>\n",
       "      <td>68</td>\n",
       "      <td>560</td>\n",
       "      <td>710</td>\n",
       "      <td>3779</td>\n",
       "      <td>15035</td>\n",
       "      <td>276</td>\n",
       "      <td>187</td>\n",
       "      <td>124</td>\n",
       "      <td>0</td>\n",
       "      <td>2051</td>\n",
       "      <td>1752</td>\n",
       "      <td>515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>34</td>\n",
       "      <td>027</td>\n",
       "      <td>135411</td>\n",
       "      <td>27575</td>\n",
       "      <td>149</td>\n",
       "      <td>27637</td>\n",
       "      <td>47</td>\n",
       "      <td>1903</td>\n",
       "      <td>600</td>\n",
       "      <td>5410</td>\n",
       "      <td>13974</td>\n",
       "      <td>1106</td>\n",
       "      <td>117</td>\n",
       "      <td>71</td>\n",
       "      <td>10</td>\n",
       "      <td>4368</td>\n",
       "      <td>3807</td>\n",
       "      <td>949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>34</td>\n",
       "      <td>028</td>\n",
       "      <td>48262</td>\n",
       "      <td>124943</td>\n",
       "      <td>418</td>\n",
       "      <td>9828</td>\n",
       "      <td>0</td>\n",
       "      <td>1361</td>\n",
       "      <td>1550</td>\n",
       "      <td>3354</td>\n",
       "      <td>19526</td>\n",
       "      <td>2941</td>\n",
       "      <td>144</td>\n",
       "      <td>143</td>\n",
       "      <td>6</td>\n",
       "      <td>11208</td>\n",
       "      <td>3433</td>\n",
       "      <td>2255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>34</td>\n",
       "      <td>029</td>\n",
       "      <td>39357</td>\n",
       "      <td>69740</td>\n",
       "      <td>518</td>\n",
       "      <td>6621</td>\n",
       "      <td>133</td>\n",
       "      <td>3461</td>\n",
       "      <td>775</td>\n",
       "      <td>2477</td>\n",
       "      <td>51169</td>\n",
       "      <td>4322</td>\n",
       "      <td>444</td>\n",
       "      <td>140</td>\n",
       "      <td>78</td>\n",
       "      <td>35428</td>\n",
       "      <td>11447</td>\n",
       "      <td>2838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>34</td>\n",
       "      <td>030</td>\n",
       "      <td>198248</td>\n",
       "      <td>5260</td>\n",
       "      <td>79</td>\n",
       "      <td>4598</td>\n",
       "      <td>0</td>\n",
       "      <td>361</td>\n",
       "      <td>560</td>\n",
       "      <td>1229</td>\n",
       "      <td>13560</td>\n",
       "      <td>498</td>\n",
       "      <td>163</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>7169</td>\n",
       "      <td>2567</td>\n",
       "      <td>499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>34</td>\n",
       "      <td>031</td>\n",
       "      <td>61153</td>\n",
       "      <td>54849</td>\n",
       "      <td>533</td>\n",
       "      <td>48350</td>\n",
       "      <td>68</td>\n",
       "      <td>1749</td>\n",
       "      <td>1560</td>\n",
       "      <td>4958</td>\n",
       "      <td>26783</td>\n",
       "      <td>4000</td>\n",
       "      <td>426</td>\n",
       "      <td>575</td>\n",
       "      <td>0</td>\n",
       "      <td>23355</td>\n",
       "      <td>6615</td>\n",
       "      <td>2378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>34</td>\n",
       "      <td>032</td>\n",
       "      <td>61149</td>\n",
       "      <td>6135</td>\n",
       "      <td>235</td>\n",
       "      <td>25696</td>\n",
       "      <td>0</td>\n",
       "      <td>1031</td>\n",
       "      <td>920</td>\n",
       "      <td>2492</td>\n",
       "      <td>73439</td>\n",
       "      <td>2620</td>\n",
       "      <td>1182</td>\n",
       "      <td>731</td>\n",
       "      <td>38</td>\n",
       "      <td>42161</td>\n",
       "      <td>14261</td>\n",
       "      <td>3065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>34</td>\n",
       "      <td>033</td>\n",
       "      <td>79083</td>\n",
       "      <td>10164</td>\n",
       "      <td>264</td>\n",
       "      <td>36231</td>\n",
       "      <td>280</td>\n",
       "      <td>994</td>\n",
       "      <td>886</td>\n",
       "      <td>4272</td>\n",
       "      <td>53524</td>\n",
       "      <td>4358</td>\n",
       "      <td>744</td>\n",
       "      <td>366</td>\n",
       "      <td>13</td>\n",
       "      <td>21507</td>\n",
       "      <td>10898</td>\n",
       "      <td>2940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>034</td>\n",
       "      <td>62307</td>\n",
       "      <td>86049</td>\n",
       "      <td>245</td>\n",
       "      <td>11297</td>\n",
       "      <td>22</td>\n",
       "      <td>1408</td>\n",
       "      <td>1534</td>\n",
       "      <td>3534</td>\n",
       "      <td>23737</td>\n",
       "      <td>2531</td>\n",
       "      <td>244</td>\n",
       "      <td>73</td>\n",
       "      <td>86</td>\n",
       "      <td>20076</td>\n",
       "      <td>4877</td>\n",
       "      <td>1035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>035</td>\n",
       "      <td>48580</td>\n",
       "      <td>41180</td>\n",
       "      <td>60</td>\n",
       "      <td>9525</td>\n",
       "      <td>8</td>\n",
       "      <td>994</td>\n",
       "      <td>418</td>\n",
       "      <td>2014</td>\n",
       "      <td>45974</td>\n",
       "      <td>2416</td>\n",
       "      <td>256</td>\n",
       "      <td>116</td>\n",
       "      <td>35</td>\n",
       "      <td>54886</td>\n",
       "      <td>10741</td>\n",
       "      <td>2598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>34</td>\n",
       "      <td>036</td>\n",
       "      <td>96442</td>\n",
       "      <td>8583</td>\n",
       "      <td>293</td>\n",
       "      <td>24153</td>\n",
       "      <td>90</td>\n",
       "      <td>779</td>\n",
       "      <td>591</td>\n",
       "      <td>2463</td>\n",
       "      <td>59863</td>\n",
       "      <td>1956</td>\n",
       "      <td>538</td>\n",
       "      <td>391</td>\n",
       "      <td>6</td>\n",
       "      <td>15771</td>\n",
       "      <td>14727</td>\n",
       "      <td>1889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>34</td>\n",
       "      <td>037</td>\n",
       "      <td>83635</td>\n",
       "      <td>28162</td>\n",
       "      <td>285</td>\n",
       "      <td>55617</td>\n",
       "      <td>44</td>\n",
       "      <td>949</td>\n",
       "      <td>1060</td>\n",
       "      <td>3964</td>\n",
       "      <td>32260</td>\n",
       "      <td>2368</td>\n",
       "      <td>289</td>\n",
       "      <td>169</td>\n",
       "      <td>23</td>\n",
       "      <td>8331</td>\n",
       "      <td>4299</td>\n",
       "      <td>3252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>34</td>\n",
       "      <td>038</td>\n",
       "      <td>125937</td>\n",
       "      <td>9772</td>\n",
       "      <td>342</td>\n",
       "      <td>33934</td>\n",
       "      <td>43</td>\n",
       "      <td>578</td>\n",
       "      <td>467</td>\n",
       "      <td>3175</td>\n",
       "      <td>29169</td>\n",
       "      <td>1151</td>\n",
       "      <td>261</td>\n",
       "      <td>254</td>\n",
       "      <td>12</td>\n",
       "      <td>5890</td>\n",
       "      <td>5918</td>\n",
       "      <td>1866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>34</td>\n",
       "      <td>039</td>\n",
       "      <td>159377</td>\n",
       "      <td>4062</td>\n",
       "      <td>328</td>\n",
       "      <td>26230</td>\n",
       "      <td>0</td>\n",
       "      <td>550</td>\n",
       "      <td>971</td>\n",
       "      <td>3655</td>\n",
       "      <td>17047</td>\n",
       "      <td>730</td>\n",
       "      <td>100</td>\n",
       "      <td>278</td>\n",
       "      <td>0</td>\n",
       "      <td>2499</td>\n",
       "      <td>2966</td>\n",
       "      <td>954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>34</td>\n",
       "      <td>040</td>\n",
       "      <td>164360</td>\n",
       "      <td>4799</td>\n",
       "      <td>219</td>\n",
       "      <td>17246</td>\n",
       "      <td>129</td>\n",
       "      <td>508</td>\n",
       "      <td>428</td>\n",
       "      <td>3114</td>\n",
       "      <td>16899</td>\n",
       "      <td>361</td>\n",
       "      <td>27</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>3039</td>\n",
       "      <td>3884</td>\n",
       "      <td>604</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE STATE_LEGISLATIVE_DISTRICT_UPPER_CHAMBER  B03002_003E  B03002_004E  \\\n",
       "0     34                                      001       142196        21618   \n",
       "1     34                                      002       107867        31770   \n",
       "2     34                                      003       149678        33696   \n",
       "3     34                                      004       148292        39088   \n",
       "4     34                                      005       114996        42660   \n",
       "5     34                                      006       144747        22647   \n",
       "6     34                                      007       134612        47217   \n",
       "7     34                                      008       160610        22823   \n",
       "8     34                                      009       194162         7586   \n",
       "9     34                                      010       188982         7378   \n",
       "10    34                                      011       139559        29607   \n",
       "11    34                                      012       161981        14825   \n",
       "12    34                                      013       176797         5123   \n",
       "13    34                                      014       129659        18482   \n",
       "14    34                                      015        88586        55027   \n",
       "15    34                                      016       138275        11402   \n",
       "16    34                                      017        70856        45295   \n",
       "17    34                                      018        96906        16389   \n",
       "18    34                                      019        82172        21725   \n",
       "19    34                                      020        43416        64102   \n",
       "20    34                                      021       157029         7157   \n",
       "21    34                                      022        85166        48110   \n",
       "22    34                                      023       158090         8589   \n",
       "23    34                                      024       172261         5102   \n",
       "24    34                                      025       149612         8463   \n",
       "25    34                                      026       158999         3980   \n",
       "26    34                                      027       135411        27575   \n",
       "27    34                                      028        48262       124943   \n",
       "28    34                                      029        39357        69740   \n",
       "29    34                                      030       198248         5260   \n",
       "30    34                                      031        61153        54849   \n",
       "31    34                                      032        61149         6135   \n",
       "32    34                                      033        79083        10164   \n",
       "33    34                                      034        62307        86049   \n",
       "34    34                                      035        48580        41180   \n",
       "35    34                                      036        96442         8583   \n",
       "36    34                                      037        83635        28162   \n",
       "37    34                                      038       125937         9772   \n",
       "38    34                                      039       159377         4062   \n",
       "39    34                                      040       164360         4799   \n",
       "\n",
       "    B03002_005E  B03002_006E  B03002_007E  B03002_008E  B03002_010E  \\\n",
       "0           925         1963            6          371          487   \n",
       "1           547        17962           98          650          694   \n",
       "2           452         4264           24          237          358   \n",
       "3           216         7032           17          507          411   \n",
       "4           206         7225           18          690          142   \n",
       "5           138        21829           63         1447          570   \n",
       "6            52        12108           50          871          561   \n",
       "7            35         7878          113          388          561   \n",
       "8           117         5480           46          418          196   \n",
       "9           188         5765          136          986          209   \n",
       "10          133         7849           11          776          599   \n",
       "11          172        17919            0          321          543   \n",
       "12          115        17925           71          433          762   \n",
       "13          222        37101           63          284          591   \n",
       "14          407        23661           29          161          278   \n",
       "15          512        48874           29         1049         1224   \n",
       "16          353        52596           24         1699         1144   \n",
       "17          144        69965          198         1125         1769   \n",
       "18          234        37332           91         1005          836   \n",
       "19          124         9020           32         6246         1034   \n",
       "20          130        23822            4         2092          178   \n",
       "21          302        10880            0         1933          526   \n",
       "22          137        17450           67          547          823   \n",
       "23           54         5774            0          366          550   \n",
       "24           95        12998            0          520          435   \n",
       "25          312        29933           68          560          710   \n",
       "26          149        27637           47         1903          600   \n",
       "27          418         9828            0         1361         1550   \n",
       "28          518         6621          133         3461          775   \n",
       "29           79         4598            0          361          560   \n",
       "30          533        48350           68         1749         1560   \n",
       "31          235        25696            0         1031          920   \n",
       "32          264        36231          280          994          886   \n",
       "33          245        11297           22         1408         1534   \n",
       "34           60         9525            8          994          418   \n",
       "35          293        24153           90          779          591   \n",
       "36          285        55617           44          949         1060   \n",
       "37          342        33934           43          578          467   \n",
       "38          328        26230            0          550          971   \n",
       "39          219        17246          129          508          428   \n",
       "\n",
       "    B03002_011E  B03002_013E  B03002_014E  B03002_015E  B03002_016E  \\\n",
       "0          4965        24460         1820          191          107   \n",
       "1          5588        16532         1398          694          128   \n",
       "2          4327        15417          931          179           22   \n",
       "3          5723         8885         2564          287           41   \n",
       "4          3783        16543         2455          239           64   \n",
       "5          4509        11936         1762           92           40   \n",
       "6          7288         9159         1511          332          207   \n",
       "7          6264         8291         1528          170           49   \n",
       "8          4949        11273          928           12           64   \n",
       "9          4130        11925          653          114           34   \n",
       "10         4654        18109         1774          297           46   \n",
       "11         3885        16380         1193          141          136   \n",
       "12         3196        10866          207          154           66   \n",
       "13         3335        20948         1050           28          167   \n",
       "14         3645        23449         2288          525           35   \n",
       "15         4449        12458          581          168           51   \n",
       "16         3791        31629         2269          474          129   \n",
       "17         4270        13519          716          107          139   \n",
       "18         2655        52658         3034          493          348   \n",
       "19         2581        39353         3078          894          278   \n",
       "20         4102        13664          764           27          252   \n",
       "21         3266        30431         2802          751           82   \n",
       "22         2975        14501          537           76          227   \n",
       "23         3145        13744          509           33           38   \n",
       "24         4235        23251          561          398           33   \n",
       "25         3779        15035          276          187          124   \n",
       "26         5410        13974         1106          117           71   \n",
       "27         3354        19526         2941          144          143   \n",
       "28         2477        51169         4322          444          140   \n",
       "29         1229        13560          498          163           19   \n",
       "30         4958        26783         4000          426          575   \n",
       "31         2492        73439         2620         1182          731   \n",
       "32         4272        53524         4358          744          366   \n",
       "33         3534        23737         2531          244           73   \n",
       "34         2014        45974         2416          256          116   \n",
       "35         2463        59863         1956          538          391   \n",
       "36         3964        32260         2368          289          169   \n",
       "37         3175        29169         1151          261          254   \n",
       "38         3655        17047          730          100          278   \n",
       "39         3114        16899          361           27           72   \n",
       "\n",
       "    B03002_017E  B03002_018E  B03002_020E  B03002_021E  \n",
       "0            25         9969         2943         1306  \n",
       "1            16        18301         4893         1337  \n",
       "2            22         6880         3862          590  \n",
       "3             0         5886         1202         1466  \n",
       "4            24        24589         5088          963  \n",
       "5            71         9901         2583         1188  \n",
       "6             4         4596         2102          948  \n",
       "7           134         4174         2510          984  \n",
       "8             0         3328         1989          183  \n",
       "9             0         4483         2396          689  \n",
       "10           15        10266         3385         1317  \n",
       "11            0         4129         3543          428  \n",
       "12            9         2256         1645          505  \n",
       "13            7         4978         2207          849  \n",
       "14          164         9688         4578          468  \n",
       "15           46         3262         2454          458  \n",
       "16            6        13613         2775          602  \n",
       "17            9         7926         3235         1546  \n",
       "18           42        15201         7470         2693  \n",
       "19            0        50647         8436         1632  \n",
       "20            9         6667         3113          745  \n",
       "21           53        27643         6986         1867  \n",
       "22           10         5269         3280          900  \n",
       "23           18         2185         2191          778  \n",
       "24           43         8778         3354         1009  \n",
       "25            0         2051         1752          515  \n",
       "26           10         4368         3807          949  \n",
       "27            6        11208         3433         2255  \n",
       "28           78        35428        11447         2838  \n",
       "29            0         7169         2567          499  \n",
       "30            0        23355         6615         2378  \n",
       "31           38        42161        14261         3065  \n",
       "32           13        21507        10898         2940  \n",
       "33           86        20076         4877         1035  \n",
       "34           35        54886        10741         2598  \n",
       "35            6        15771        14727         1889  \n",
       "36           23         8331         4299         3252  \n",
       "37           12         5890         5918         1866  \n",
       "38            0         2499         2966          954  \n",
       "39            0         3039         3884          604  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ced.download(\n",
    "    DATASET, YEAR, leaves, state=STATE_NJ, state_legislative_district_upper_chamber=\"*\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "41349f4e-6501-48a4-82dc-ceb9dab04804",
   "metadata": {},
   "source": [
    "## Error Handling\n",
    "\n",
    "What happens if we get one of the keywords wrong? We can always look \n",
    "a few cells up at the output from `cgeo.geo_path_snake_specs`, but we\n",
    "also get a friendly exception message to tell us what the options are."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b02afc25-2ea8-4f72-9725-4276ed7bb603",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Unable to match the geography specification {'state': '34', 'unknown_geo': '*'}.\n",
      "Supported geographies for dataset='acs/acs5' in year=2020 are:\n",
      "['us']\n",
      "['region']\n",
      "['division']\n",
      "['state']\n",
      "['state', 'county']\n",
      "['state', 'county', 'county_subdivision']\n",
      "['state', 'county', 'county_subdivision', 'subminor_civil_division']\n",
      "['state', 'county', 'county_subdivision', 'place_remainder_or_part']\n",
      "['state', 'county', 'tract']\n",
      "['state', 'county', 'tract', 'block_group']\n",
      "['state', 'place', 'county_or_part']\n",
      "['state', 'place']\n",
      "['state', 'consolidated_city']\n",
      "['state', 'consolidated_city', 'place_or_part']\n",
      "['state', 'alaska_native_regional_corporation']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'tribal_subdivision_remainder']\n",
      "['american_indian_area_alaska_native_area_reservation_or_statistical_entity_only']\n",
      "['american_indian_area_off_reservation_trust_land_only_hawaiian_home_land']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'tribal_census_tract']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'tribal_census_tract', 'tribal_block_group']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'state_or_part']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'state_or_part', 'place_remainder_or_part']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'state_or_part', 'county_or_part']\n",
      "['state', 'american_indian_area_alaska_native_area_hawaiian_home_land_or_part']\n",
      "['state', 'american_indian_area_alaska_native_area_reservation_or_statistical_entity_only_or_part']\n",
      "['state', 'american_indian_area_off_reservation_trust_land_only_hawaiian_home_land_or_part']\n",
      "['american_indian_area_alaska_native_area_hawaiian_home_land', 'tribal_subdivision_remainder', 'state_or_part']\n",
      "['american_indian_area_reservation_only', 'tribal_census_tract_or_part']\n",
      "['american_indian_area_off_reservation_trust_land_only_hawaiian_home_land', 'tribal_census_tract_or_part']\n",
      "['american_indian_area_reservation_only', 'tribal_census_tract_or_part', 'tribal_block_group_or_part']\n",
      "['american_indian_area_off_reservation_trust_land_only_hawaiian_home_land', 'tribal_census_tract_or_part', 'tribal_block_group_or_part']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area', 'state_or_part']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area', 'state_or_part', 'principal_city_or_part']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area', 'state_or_part', 'county']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area', 'metropolitan_division']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area', 'metropolitan_division', 'state_or_part']\n",
      "['metropolitan_statistical_area_micropolitan_statistical_area', 'metropolitan_division', 'state_or_part', 'county']\n",
      "['state', 'metropolitan_statistical_area_micropolitan_statistical_area_or_part']\n",
      "['state', 'metropolitan_statistical_area_micropolitan_statistical_area_or_part', 'principal_city_or_part']\n",
      "['state', 'metropolitan_statistical_area_micropolitan_statistical_area_or_part', 'county']\n",
      "['state', 'metropolitan_statistical_area_micropolitan_statistical_area_or_part', 'metropolitan_division_or_part']\n",
      "['state', 'metropolitan_statistical_area_micropolitan_statistical_area_or_part', 'metropolitan_division_or_part', 'county']\n",
      "['combined_statistical_area']\n",
      "['combined_statistical_area', 'state_or_part']\n",
      "['combined_statistical_area', 'metropolitan_statistical_area_micropolitan_statistical_area']\n",
      "['combined_statistical_area', 'metropolitan_statistical_area_micropolitan_statistical_area', 'state_or_part']\n",
      "['combined_new_england_city_and_town_area']\n",
      "['combined_new_england_city_and_town_area', 'state_or_part']\n",
      "['combined_new_england_city_and_town_area', 'new_england_city_and_town_area']\n",
      "['combined_new_england_city_and_town_area', 'new_england_city_and_town_area', 'state_or_part']\n",
      "['state', 'combined_statistical_area_or_part']\n",
      "['state', 'combined_statistical_area_or_part', 'metropolitan_statistical_area_micropolitan_statistical_area_or_part']\n",
      "['state', 'combined_new_england_city_and_town_area_or_part']\n",
      "['state', 'combined_new_england_city_and_town_area_or_part', 'new_england_city_and_town_area_or_part']\n",
      "['new_england_city_and_town_area']\n",
      "['new_england_city_and_town_area', 'state_or_part']\n",
      "['new_england_city_and_town_area', 'state_or_part', 'principal_city']\n",
      "['new_england_city_and_town_area', 'state_or_part', 'county_or_part']\n",
      "['new_england_city_and_town_area', 'state_or_part', 'county_or_part', 'county_subdivision']\n",
      "['new_england_city_and_town_area', 'necta_division']\n",
      "['new_england_city_and_town_area', 'necta_division', 'state_or_part']\n",
      "['new_england_city_and_town_area', 'necta_division', 'state_or_part', 'county_or_part']\n",
      "['new_england_city_and_town_area', 'necta_division', 'state_or_part', 'county_or_part', 'county_subdivision']\n",
      "['state', 'new_england_city_and_town_area_or_part']\n",
      "['state', 'new_england_city_and_town_area_or_part', 'principal_city']\n",
      "['state', 'new_england_city_and_town_area_or_part', 'county_or_part']\n",
      "['state', 'new_england_city_and_town_area_or_part', 'county_or_part', 'county_subdivision']\n",
      "['state', 'new_england_city_and_town_area_or_part', 'necta_division_or_part']\n",
      "['state', 'new_england_city_and_town_area_or_part', 'necta_division_or_part', 'county_or_part']\n",
      "['state', 'new_england_city_and_town_area_or_part', 'necta_division_or_part', 'county_or_part', 'county_subdivision']\n",
      "['urban_area']\n",
      "['urban_area', 'state']\n",
      "['urban_area', 'state', 'county']\n",
      "['state', 'congressional_district']\n",
      "['state', 'congressional_district', 'county_or_part']\n",
      "['state', 'congressional_district', 'american_indian_area_alaska_native_area_hawaiian_home_land_or_part']\n",
      "['state', 'state_legislative_district_upper_chamber']\n",
      "['state', 'state_legislative_district_upper_chamber', 'county_or_part']\n",
      "['state', 'state_legislative_district_lower_chamber']\n",
      "['state', 'state_legislative_district_lower_chamber', 'county_or_part']\n",
      "['state', 'public_use_microdata_area']\n",
      "['zip_code_tabulation_area']\n",
      "['state', 'school_district_elementary']\n",
      "['state', 'school_district_secondary']\n",
      "['state', 'school_district_unified']\n"
     ]
    }
   ],
   "source": [
    "try:\n",
    "    ced.download(DATASET, YEAR, leaves, state=STATE_NJ, unknown_geo=\"*\")\n",
    "except ced.CensusApiException as e:\n",
    "    print(e)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e5d7322b-f7b8-409d-be01-9a3514689e58",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}