{ "cells": [ { "cell_type": "markdown", "metadata": { "id": "7LKLhQBzJMOz" }, "source": [ "## Data discovery: how to explore CARTO's Data Observatory catalog.\n", "\n", "This notebook shows how to use CARTOframes to discover and explore datasets from CARTO's [Data Observatory](https://carto.com/spatial-data-catalog/).\n", "\n", "If you haven't installed CARTOframes yet, please visit our [installation guide](https://carto.com/developers/cartoframes/guides/Installation/).\n", "\n", "The notebook is organized in the following sections:\n", "\n", "0. [Setup](#section0)\n", "\n", " 0.1. [Import packages](#section0.1)\n", " \n", " 0.2. [Set CARTO default credentials](#section0.2)\n", "\n", "\n", "1. [Data discovery](#section1)\n", " \n", " 1.1. [Data catalog structure](#section1.1)\n", " \n", " 1.2. [Combining filters](#section1.2)\n", " \n", " 1.3. [Filter datasets by the type of geography](#section1.3)\n", " \n", " 1.4. [Get a first glimpse of a dataset](#section1.3)\n", " \n", " \n", "**Want to learn more?** Learn how to access and download datasets on the following notebooks Access Public Data and Access Premium Data." ] }, { "cell_type": "markdown", "metadata": { "id": "V4-0hJjiVsen" }, "source": [ "\n", "### 0. Setup" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\n", "#### 0.1. Import packages" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "id": "6vLRH4fEEkms" }, "outputs": [], "source": [ "import geopandas as gpd\n", "import pandas as pd\n", "pd.set_option('display.max_columns', None)\n", "\n", "from cartoframes.auth import set_default_credentials\n", "from cartoframes.data.observatory import *" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\n", "#### 0.2. Set CARTO default credentials\n", "\n", "In order to be able to use the Data Observatory via CARTOframes, you need to set your CARTO account credentials first.\n", "\n", "Please, visit the [Authentication guide](https://carto.com/developers/cartoframes/guides/Authentication/) for further detail." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "id": "2E7lg3CDV2ge" }, "outputs": [], "source": [ "set_default_credentials('creds.json')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**Note about credentials**\n", "\n", "For security reasons, we recommend storing your credentials in an external file to prevent publishing them by accident when sharing your notebooks. You can get more information in the section _Setting your credentials_ of the [Authentication guide](https://carto.com/developers/cartoframes/guides/Authentication/)." ] }, { "cell_type": "markdown", "metadata": { "id": "uwAtCjyeV3QI" }, "source": [ "\n", "### 1. Data Discovery\n", "\n", "CARTO's data catalog consists of a set of datasets organized by:\n", " - Country\n", " - Category\n", " - Provider\n", " - Geography\n", " \n", "In addition, datasets are classified in public and premium data.\n", "\n", "This classification can be used to explore the Catalog and narrow down your search for the dataset most suitable for your analysis.\n", "\n", "For example, you may start exploring by country, then filter by category and finally select a dataset based on the provider. Alternatively, you could start exploring by category or provider." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\n", "#### 1.1. Data catalog structure\n", "\n", "In this subsection we explore each of the four classification categories.\n", "\n", "**Note** results can be displayed in Python list format or in Pandas DataFrame format." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.1.1. Countries" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1000 }, "id": "bowL1MIBgLbX", "outputId": "6f897e48-0238-48bc-f9b9-12b7c0c87d6f" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idname
0abwAruba
1afgAfghanistan
2agoAngola
3aiaAnguilla
4alaÅland Islands
5albAlbania
6andAndorra
7areUnited Arab Emirates
8argArgentina
9armArmenia
\n", "
" ], "text/plain": [ " id name\n", "0 abw Aruba\n", "1 afg Afghanistan\n", "2 ago Angola\n", "3 aia Anguilla\n", "4 ala Åland Islands\n", "5 alb Albania\n", "6 and Andorra\n", "7 are United Arab Emirates\n", "8 arg Argentina\n", "9 arm Armenia" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().countries.to_dataframe().head(10)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.1.2. Categories" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 194 }, "id": "rQqNGRQ_oqdr", "outputId": "1ceae746-0e6e-46ca-fe6c-171ee6542a2f" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idname
0behavioralBehavioral
1covid19Covid-19
2demographicsDemographics
3derivedDerived
4environmentalEnvironmental
5financialFinancial
6housingHousing
7human_mobilityHuman Mobility
8points_of_interestPoints of Interest
9road_trafficRoad Traffic
\n", "
" ], "text/plain": [ " id name\n", "0 behavioral Behavioral\n", "1 covid19 Covid-19\n", "2 demographics Demographics\n", "3 derived Derived\n", "4 environmental Environmental\n", "5 financial Financial\n", "6 housing Housing\n", "7 human_mobility Human Mobility\n", "8 points_of_interest Points of Interest\n", "9 road_traffic Road Traffic" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().categories.to_dataframe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.1.3. Providers" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 514 }, "id": "FSYAZfjMoucY", "outputId": "dde40bfe-f9ab-4c47-b614-6c0b3e5a823b" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idname
0mastercardMastercard
1vodafoneVodafone
2experianExperian
3hereHERE
4tomtomTomTom
5foursquareFoursquare
6preciselyPrecisely
7mbiMichael Bauer International
8unacastUnacast
9safegraphSafeGraph
\n", "
" ], "text/plain": [ " id name\n", "0 mastercard Mastercard\n", "1 vodafone Vodafone\n", "2 experian Experian\n", "3 here HERE\n", "4 tomtom TomTom\n", "5 foursquare Foursquare\n", "6 precisely Precisely\n", "7 mbi Michael Bauer International\n", "8 unacast Unacast\n", "9 safegraph SafeGraph" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().providers.to_dataframe().head(10)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.1.4. Geographies" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 960 }, "id": "HuKsB4E5o1Th", "outputId": "f5ad1d4f-f36c-47ea-f03f-bd7cbb34b1bc" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
slugnamedescriptioncountry_idprovider_idgeom_typegeom_coverageupdate_frequencyis_public_datalangversionprovider_nameid
0mbi_pc_4_digit_5bc747b4PC 4-digit - New ZealandMBI Digital Boundaries for New Zealand at PC 4...nzlmbiMULTIPOLYGONNoneNoneFalseeng2020Michael Bauer Internationalcarto-do.mbi.geography_nzl_pc4digit_2020
1mbi_statistical_b9e153d7Statistical Districts - CzechiaMBI Digital Boundaries for Czech Republic at S...czembiMULTIPOLYGONNoneNoneFalseeng2020Michael Bauer Internationalcarto-do.mbi.geography_cze_statisticaldistrict...
2mbi_zillahs_11fffa06Zillahs - PakistanMBI Digital Boundaries for Pakistan at Zillahs...pakmbiMULTIPOLYGONNoneNoneFalseeng2020Michael Bauer Internationalcarto-do.mbi.geography_pak_zillahs_2020
3tigr_cbsa_2ae03906Core-based Statistical Area - United States of...Core-based Statistical Area TIGER/Line Shapefi...usausa_tigerMULTIPOLYGONNoneNoneTrueeng2019Tiger/Line geographic data from the U.S. Censu...carto-do-public-data.usa_tiger.geography_usa_c...
4tigr_place_89fd760bCensus Place - United States of America (2017)Census Place TIGER/Line Shapefiles from the Un...usausa_tigerMULTIPOLYGONNoneNoneTrueeng2017Tiger/Line geographic data from the U.S. Censu...carto-do-public-data.usa_tiger.geography_usa_p...
\n", "
" ], "text/plain": [ " slug \\\n", "0 mbi_pc_4_digit_5bc747b4 \n", "1 mbi_statistical_b9e153d7 \n", "2 mbi_zillahs_11fffa06 \n", "3 tigr_cbsa_2ae03906 \n", "4 tigr_place_89fd760b \n", "\n", " name \\\n", "0 PC 4-digit - New Zealand \n", "1 Statistical Districts - Czechia \n", "2 Zillahs - Pakistan \n", "3 Core-based Statistical Area - United States of... \n", "4 Census Place - United States of America (2017) \n", "\n", " description country_id provider_id \\\n", "0 MBI Digital Boundaries for New Zealand at PC 4... nzl mbi \n", "1 MBI Digital Boundaries for Czech Republic at S... cze mbi \n", "2 MBI Digital Boundaries for Pakistan at Zillahs... pak mbi \n", "3 Core-based Statistical Area TIGER/Line Shapefi... usa usa_tiger \n", "4 Census Place TIGER/Line Shapefiles from the Un... usa usa_tiger \n", "\n", " geom_type geom_coverage update_frequency is_public_data lang version \\\n", "0 MULTIPOLYGON None None False eng 2020 \n", "1 MULTIPOLYGON None None False eng 2020 \n", "2 MULTIPOLYGON None None False eng 2020 \n", "3 MULTIPOLYGON None None True eng 2019 \n", "4 MULTIPOLYGON None None True eng 2017 \n", "\n", " provider_name \\\n", "0 Michael Bauer International \n", "1 Michael Bauer International \n", "2 Michael Bauer International \n", "3 Tiger/Line geographic data from the U.S. Censu... \n", "4 Tiger/Line geographic data from the U.S. Censu... \n", "\n", " id \n", "0 carto-do.mbi.geography_nzl_pc4digit_2020 \n", "1 carto-do.mbi.geography_cze_statisticaldistrict... \n", "2 carto-do.mbi.geography_pak_zillahs_2020 \n", "3 carto-do-public-data.usa_tiger.geography_usa_c... \n", "4 carto-do-public-data.usa_tiger.geography_usa_p... " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().geographies.to_dataframe().head()" ] }, { "cell_type": "markdown", "metadata": { "id": "asbQxIHQi-9Z" }, "source": [ "\n", "#### 1.2. Combining filters\n", "Let's now take a look at how to combine category and provider filters to get the public demographics datasets available in the US from ACS at the census tract level." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Categories available in the US." ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 194 }, "id": "soKtHxhso5_l", "outputId": "84a21fad-7a99-4548-aa7c-57f6152de6c2" }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "You can find more entities with the Global country filter. To apply that filter run:\n", "\tCatalog().country('glo')\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idname
0behavioralBehavioral
1covid19Covid-19
2demographicsDemographics
3derivedDerived
4environmentalEnvironmental
5financialFinancial
6housingHousing
7human_mobilityHuman Mobility
8points_of_interestPoints of Interest
9road_trafficRoad Traffic
\n", "
" ], "text/plain": [ " id name\n", "0 behavioral Behavioral\n", "1 covid19 Covid-19\n", "2 demographics Demographics\n", "3 derived Derived\n", "4 environmental Environmental\n", "5 financial Financial\n", "6 housing Housing\n", "7 human_mobility Human Mobility\n", "8 points_of_interest Points of Interest\n", "9 road_traffic Road Traffic" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().country('usa').categories.to_dataframe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Providers available in the US." ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 301 }, "id": "FNlJMzn3kfIK", "outputId": "46cd0f10-2dad-4e1c-f84a-77b368e96c75" }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "You can find more entities with the Global country filter. To apply that filter run:\n", "\tCatalog().country('glo')\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idname
0mastercardMastercard
1experianExperian
2hereHERE
3tomtomTomTom
4foursquareFoursquare
\n", "
" ], "text/plain": [ " id name\n", "0 mastercard Mastercard\n", "1 experian Experian\n", "2 here HERE\n", "3 tomtom TomTom\n", "4 foursquare Foursquare" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().country('usa').providers.to_dataframe().head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "List of providers available in the US offering demographics data." ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 105 }, "id": "0TGBWgPwkjDY", "outputId": "145812ec-eeca-4ca3-d39c-05e35484f11a" }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "You can find more entities with the Global country filter. To apply that filter run:\n", "\tCatalog().country('glo')\n" ] }, { "data": { "text/plain": [ "[,\n", " ,\n", " ,\n", " ,\n", " ,\n", " ,\n", " ]" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().country('usa').category('demographics').providers" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "List of providers available in the US offering **public** demographics data." ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "You can find more entities with the Global country filter. To apply that filter run:\n", "\tCatalog().country('glo')\n" ] }, { "data": { "text/plain": [ "[,\n", " ,\n", " ,\n", " ]" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().country('usa').category('demographics').public().providers" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's now take a look at all the demographics datasets provided by ACS in the US." ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 926 }, "id": "txVEvD6ylQoT", "outputId": "1007d1d4-b67e-430e-a511-05e47669c300" }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "You can find more entities with the Global country filter. To apply that filter run:\n", "\tCatalog().country('glo')\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
slugnamedescriptioncategory_idcountry_iddata_source_idprovider_idgeography_namegeography_descriptiontemporal_aggregationtime_coverageupdate_frequencyis_public_datalangversioncategory_nameprovider_namegeography_idid
0acs_sociodemogr_a0c48b07Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCounty - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...yearly[2007-01-01, 2008-01-01)NoneTrueeng2007DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_count...carto-do-public-data.usa_acs.demographics_soci...
1acs_sociodemogr_a03fb95fSociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCongressional District - United States of Amer...Shoreline clipped TIGER/Line boundaries. More ...yearly[2017-01-01, 2018-01-01)NoneTrueeng2017DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_congr...carto-do-public-data.usa_acs.demographics_soci...
2acs_sociodemogr_e7b702b0Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCore-based Statistical Area - United States of...Shoreline clipped TIGER/Line boundaries. More ...3yrs[2006-01-01, 2009-01-01)NoneTrueeng20062008DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_cbsa_...carto-do-public-data.usa_acs.demographics_soci...
3acs_sociodemogr_e1e92d8dSociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCore-based Statistical Area - United States of...Shoreline clipped TIGER/Line boundaries. More ...yearly[2013-01-01, 2014-01-01)NoneTrueeng2013DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_cbsa_...carto-do-public-data.usa_acs.demographics_soci...
4acs_sociodemogr_2960a7d7Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCounty - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...yearly[2018-01-01, 2019-01-01)NoneTrueeng2018DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_count...carto-do-public-data.usa_acs.demographics_soci...
\n", "
" ], "text/plain": [ " slug \\\n", "0 acs_sociodemogr_a0c48b07 \n", "1 acs_sociodemogr_a03fb95f \n", "2 acs_sociodemogr_e7b702b0 \n", "3 acs_sociodemogr_e1e92d8d \n", "4 acs_sociodemogr_2960a7d7 \n", "\n", " name \\\n", "0 Sociodemographics - United States of America (... \n", "1 Sociodemographics - United States of America (... \n", "2 Sociodemographics - United States of America (... \n", "3 Sociodemographics - United States of America (... \n", "4 Sociodemographics - United States of America (... \n", "\n", " description category_id country_id \\\n", "0 The American Community Survey (ACS) is an ongo... demographics usa \n", "1 The American Community Survey (ACS) is an ongo... demographics usa \n", "2 The American Community Survey (ACS) is an ongo... demographics usa \n", "3 The American Community Survey (ACS) is an ongo... demographics usa \n", "4 The American Community Survey (ACS) is an ongo... demographics usa \n", "\n", " data_source_id provider_id \\\n", "0 sociodemographics usa_acs \n", "1 sociodemographics usa_acs \n", "2 sociodemographics usa_acs \n", "3 sociodemographics usa_acs \n", "4 sociodemographics usa_acs \n", "\n", " geography_name \\\n", "0 County - United States of America (2015) \n", "1 Congressional District - United States of Amer... \n", "2 Core-based Statistical Area - United States of... \n", "3 Core-based Statistical Area - United States of... \n", "4 County - United States of America (2015) \n", "\n", " geography_description temporal_aggregation \\\n", "0 Shoreline clipped TIGER/Line boundaries. More ... yearly \n", "1 Shoreline clipped TIGER/Line boundaries. More ... yearly \n", "2 Shoreline clipped TIGER/Line boundaries. More ... 3yrs \n", "3 Shoreline clipped TIGER/Line boundaries. More ... yearly \n", "4 Shoreline clipped TIGER/Line boundaries. More ... yearly \n", "\n", " time_coverage update_frequency is_public_data lang version \\\n", "0 [2007-01-01, 2008-01-01) None True eng 2007 \n", "1 [2017-01-01, 2018-01-01) None True eng 2017 \n", "2 [2006-01-01, 2009-01-01) None True eng 20062008 \n", "3 [2013-01-01, 2014-01-01) None True eng 2013 \n", "4 [2018-01-01, 2019-01-01) None True eng 2018 \n", "\n", " category_name provider_name \\\n", "0 Demographics American Community Survey \n", "1 Demographics American Community Survey \n", "2 Demographics American Community Survey \n", "3 Demographics American Community Survey \n", "4 Demographics American Community Survey \n", "\n", " geography_id \\\n", "0 carto-do-public-data.carto.geography_usa_count... \n", "1 carto-do-public-data.carto.geography_usa_congr... \n", "2 carto-do-public-data.carto.geography_usa_cbsa_... \n", "3 carto-do-public-data.carto.geography_usa_cbsa_... \n", "4 carto-do-public-data.carto.geography_usa_count... \n", "\n", " id \n", "0 carto-do-public-data.usa_acs.demographics_soci... \n", "1 carto-do-public-data.usa_acs.demographics_soci... \n", "2 carto-do-public-data.usa_acs.demographics_soci... \n", "3 carto-do-public-data.usa_acs.demographics_soci... \n", "4 carto-do-public-data.usa_acs.demographics_soci... " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Catalog().country('usa').category('demographics').provider('usa_acs').datasets.to_dataframe().head()" ] }, { "cell_type": "markdown", "metadata": { "id": "KQv9beU-16bi" }, "source": [ "\n", "#### 1.3. Filter datasets by the type of geography\n", "\n", "We can explore the types of geographies for which the datasets are available. In order to filter by a specific type of geography, we have to apply a filter to the geography_name column just like we would for a string column on a Pandas DataFrame." ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "You can find more entities with the Global country filter. To apply that filter run:\n", "\tCatalog().country('glo')\n" ] } ], "source": [ "datasets_acs_df = Catalog().country('usa').category('demographics').provider('usa_acs').datasets.to_dataframe()" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 247 }, "id": "vI6u6tJ9q4AG", "outputId": "3d1dbc5d-5c04-43fa-c0b2-08fc1765f626" }, "outputs": [ { "data": { "text/plain": [ "array(['County - United States of America (2015)',\n", " 'Congressional District - United States of America (2019)',\n", " 'Core-based Statistical Area - United States of America (2019)',\n", " 'Census Tract - United States of America (2015)',\n", " 'Public Use Microdata Area - United States of America (2019)',\n", " 'Census Place - United States of America (2019)',\n", " 'State - United States of America (2015)',\n", " 'School District (secondary) - United States of America (2019)',\n", " 'School District (elementary) - United States of America (2019)',\n", " 'School District (unified) - United States of America (2019)',\n", " '5-digit Zip Code Tabulation Area - United States of America (2015)',\n", " 'Census Block Group - United States of America (2015)'],\n", " dtype=object)" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "datasets_acs_df['geography_name'].unique()" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 707 }, "id": "bMin3NRkrBOz", "outputId": "e79d6841-3ed1-4912-e34a-8aaea416b2ef" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
slugnamedescriptioncategory_idcountry_iddata_source_idprovider_idgeography_namegeography_descriptiontemporal_aggregationtime_coverageupdate_frequencyis_public_datalangversioncategory_nameprovider_namegeography_idid
6acs_sociodemogr_30d1f53Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2012-01-01, 2017-01-01)NoneTrueeng20122016DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
46acs_sociodemogr_cfeb0968Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2009-01-01, 2014-01-01)NoneTrueeng20092013DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
63acs_sociodemogr_9ed5d625Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2007-01-01, 2012-01-01)NoneTrueeng20072011DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
68acs_sociodemogr_496a0675Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2013-01-01, 2018-01-01)NoneTrueeng20132017DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
69acs_sociodemogr_d4b2cf03Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2006-01-01, 2011-01-01)NoneTrueeng20062010DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
180acs_sociodemogr_97c32d1fSociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2010-01-01, 2015-01-01)NoneTrueeng20102014DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
219acs_sociodemogr_dda43439Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2011-01-01, 2016-01-01)NoneTrueeng20112015DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
238acs_sociodemogr_6bf5c7f4Sociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrsNoneNoneTrueeng20142018DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
251acs_sociodemogr_858c104eSociodemographics - United States of America (...The American Community Survey (ACS) is an ongo...demographicsusasociodemographicsusa_acsCensus Tract - United States of America (2015)Shoreline clipped TIGER/Line boundaries. More ...5yrs[2008-01-01, 2013-01-01)NoneTrueeng20082012DemographicsAmerican Community Surveycarto-do-public-data.carto.geography_usa_censu...carto-do-public-data.usa_acs.demographics_soci...
\n", "
" ], "text/plain": [ " slug \\\n", "6 acs_sociodemogr_30d1f53 \n", "46 acs_sociodemogr_cfeb0968 \n", "63 acs_sociodemogr_9ed5d625 \n", "68 acs_sociodemogr_496a0675 \n", "69 acs_sociodemogr_d4b2cf03 \n", "180 acs_sociodemogr_97c32d1f \n", "219 acs_sociodemogr_dda43439 \n", "238 acs_sociodemogr_6bf5c7f4 \n", "251 acs_sociodemogr_858c104e \n", "\n", " name \\\n", "6 Sociodemographics - United States of America (... \n", "46 Sociodemographics - United States of America (... \n", "63 Sociodemographics - United States of America (... \n", "68 Sociodemographics - United States of America (... \n", "69 Sociodemographics - United States of America (... \n", "180 Sociodemographics - United States of America (... \n", "219 Sociodemographics - United States of America (... \n", "238 Sociodemographics - United States of America (... \n", "251 Sociodemographics - United States of America (... \n", "\n", " description category_id \\\n", "6 The American Community Survey (ACS) is an ongo... demographics \n", "46 The American Community Survey (ACS) is an ongo... demographics \n", "63 The American Community Survey (ACS) is an ongo... demographics \n", "68 The American Community Survey (ACS) is an ongo... demographics \n", "69 The American Community Survey (ACS) is an ongo... demographics \n", "180 The American Community Survey (ACS) is an ongo... demographics \n", "219 The American Community Survey (ACS) is an ongo... demographics \n", "238 The American Community Survey (ACS) is an ongo... demographics \n", "251 The American Community Survey (ACS) is an ongo... demographics \n", "\n", " country_id data_source_id provider_id \\\n", "6 usa sociodemographics usa_acs \n", "46 usa sociodemographics usa_acs \n", "63 usa sociodemographics usa_acs \n", "68 usa sociodemographics usa_acs \n", "69 usa sociodemographics usa_acs \n", "180 usa sociodemographics usa_acs \n", "219 usa sociodemographics usa_acs \n", "238 usa sociodemographics usa_acs \n", "251 usa sociodemographics usa_acs \n", "\n", " geography_name \\\n", "6 Census Tract - United States of America (2015) \n", "46 Census Tract - United States of America (2015) \n", "63 Census Tract - United States of America (2015) \n", "68 Census Tract - United States of America (2015) \n", "69 Census Tract - United States of America (2015) \n", "180 Census Tract - United States of America (2015) \n", "219 Census Tract - United States of America (2015) \n", "238 Census Tract - United States of America (2015) \n", "251 Census Tract - United States of America (2015) \n", "\n", " geography_description temporal_aggregation \\\n", "6 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "46 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "63 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "68 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "69 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "180 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "219 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "238 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "251 Shoreline clipped TIGER/Line boundaries. More ... 5yrs \n", "\n", " time_coverage update_frequency is_public_data lang version \\\n", "6 [2012-01-01, 2017-01-01) None True eng 20122016 \n", "46 [2009-01-01, 2014-01-01) None True eng 20092013 \n", "63 [2007-01-01, 2012-01-01) None True eng 20072011 \n", "68 [2013-01-01, 2018-01-01) None True eng 20132017 \n", "69 [2006-01-01, 2011-01-01) None True eng 20062010 \n", "180 [2010-01-01, 2015-01-01) None True eng 20102014 \n", "219 [2011-01-01, 2016-01-01) None True eng 20112015 \n", "238 None None True eng 20142018 \n", "251 [2008-01-01, 2013-01-01) None True eng 20082012 \n", "\n", " category_name provider_name \\\n", "6 Demographics American Community Survey \n", "46 Demographics American Community Survey \n", "63 Demographics American Community Survey \n", "68 Demographics American Community Survey \n", "69 Demographics American Community Survey \n", "180 Demographics American Community Survey \n", "219 Demographics American Community Survey \n", "238 Demographics American Community Survey \n", "251 Demographics American Community Survey \n", "\n", " geography_id \\\n", "6 carto-do-public-data.carto.geography_usa_censu... \n", "46 carto-do-public-data.carto.geography_usa_censu... \n", "63 carto-do-public-data.carto.geography_usa_censu... \n", "68 carto-do-public-data.carto.geography_usa_censu... \n", "69 carto-do-public-data.carto.geography_usa_censu... \n", "180 carto-do-public-data.carto.geography_usa_censu... \n", "219 carto-do-public-data.carto.geography_usa_censu... \n", "238 carto-do-public-data.carto.geography_usa_censu... \n", "251 carto-do-public-data.carto.geography_usa_censu... \n", "\n", " id \n", "6 carto-do-public-data.usa_acs.demographics_soci... \n", "46 carto-do-public-data.usa_acs.demographics_soci... \n", "63 carto-do-public-data.usa_acs.demographics_soci... \n", "68 carto-do-public-data.usa_acs.demographics_soci... \n", "69 carto-do-public-data.usa_acs.demographics_soci... \n", "180 carto-do-public-data.usa_acs.demographics_soci... \n", "219 carto-do-public-data.usa_acs.demographics_soci... \n", "238 carto-do-public-data.usa_acs.demographics_soci... \n", "251 carto-do-public-data.usa_acs.demographics_soci... " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "datasets_acs_df[datasets_acs_df['geography_name'].str.contains('Census Tract')]" ] }, { "cell_type": "markdown", "metadata": { "id": "ZEzr-AfG6uSM" }, "source": [ "\n", "#### 1.4. Get a first glimpse of a dataset\n", "\n", "We select the dataset acs_sociodemogr_496a0675 from the list of datasets above because it is the one with the latest data update.\n", "\n", "CARTOframes allows you to get a first glimpse of the dataset so that you can make sure it's the right dataset for your analysis. This includes:\n", " - Information about the dataset. This includes a description, provider, temporal aggregation, if it is public or premium, etc.\n", " - Information about its variables. This includes a name, description, aggregation method, etc.\n", " - Access to the first 10 rows of the dataset.\n", " - A statistical description of all numerical variables, just like the `describe()` function in Pandas.\n", " - A map with the geometric coverage of the dataset." ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "id": "ty7maPPM66kD" }, "outputs": [], "source": [ "sample_ds = Dataset.get('acs_sociodemogr_496a0675')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.1. Information about the dataset" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 374 }, "id": "A7DIGyXj9Otw", "outputId": "43fcb060-0f9a-42e4-c3b4-4c44cdc152fe" }, "outputs": [ { "data": { "text/plain": [ "{'slug': 'acs_sociodemogr_496a0675',\n", " 'name': 'Sociodemographics - United States of America (Census Tract, 2017, 5yrs)',\n", " 'description': 'The American Community Survey (ACS) is an ongoing survey that provides vital information on a yearly basis about the USA and its people. This dataset contains only a subset of the variables that have been deemed most relevant. More info: https://www.census.gov/programs-surveys/acs/about.html',\n", " 'category_id': 'demographics',\n", " 'country_id': 'usa',\n", " 'data_source_id': 'sociodemographics',\n", " 'provider_id': 'usa_acs',\n", " 'geography_name': 'Census Tract - United States of America (2015)',\n", " 'geography_description': 'Shoreline clipped TIGER/Line boundaries. More info: https://carto.com/blog/tiger-shoreline-clip/',\n", " 'temporal_aggregation': '5yrs',\n", " 'time_coverage': '[2013-01-01, 2018-01-01)',\n", " 'update_frequency': None,\n", " 'is_public_data': True,\n", " 'lang': 'eng',\n", " 'version': '20132017',\n", " 'category_name': 'Demographics',\n", " 'provider_name': 'American Community Survey',\n", " 'geography_id': 'carto-do-public-data.carto.geography_usa_censustract_2015',\n", " 'id': 'carto-do-public-data.usa_acs.demographics_sociodemographics_usa_censustract_2015_5yrs_20132017'}" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.to_dict()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.2. Information about the dataset variables" ] }, { "cell_type": "code", "execution_count": 17, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1000 }, "id": "6eufahA97EOg", "outputId": "da142ec2-29b0-4efb-e45c-715b900bdf29" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
slugnamedescriptiondb_typeagg_methodcolumn_namevariable_group_iddataset_idid
0geoid_e99a58c1geoidUS Census Block Groups GeoidsSTRINGNonegeoidNonecarto-do-public-data.usa_acs.demographics_soci...carto-do-public-data.usa_acs.demographics_soci...
1do_date_45f076c2do_dateFirst day of the year the survey was issuedDATENonedo_dateNonecarto-do-public-data.usa_acs.demographics_soci...carto-do-public-data.usa_acs.demographics_soci...
2total_pop_17ea032fTotal PopulationTotal Population. The total number of all peop...FLOATSUMtotal_popNonecarto-do-public-data.usa_acs.demographics_soci...carto-do-public-data.usa_acs.demographics_soci...
3households_a12defd5Number of householdsHouseholds. A count of the number of household...FLOATSUMhouseholdsNonecarto-do-public-data.usa_acs.demographics_soci...carto-do-public-data.usa_acs.demographics_soci...
4male_pop_eac43e5amale_popMale Population. The number of people within e...FLOATSUMmale_popcarto-do-public-data.usa_acs.demographics_soci...carto-do-public-data.usa_acs.demographics_soci...carto-do-public-data.usa_acs.demographics_soci...
\n", "
" ], "text/plain": [ " slug name \\\n", "0 geoid_e99a58c1 geoid \n", "1 do_date_45f076c2 do_date \n", "2 total_pop_17ea032f Total Population \n", "3 households_a12defd5 Number of households \n", "4 male_pop_eac43e5a male_pop \n", "\n", " description db_type agg_method \\\n", "0 US Census Block Groups Geoids STRING None \n", "1 First day of the year the survey was issued DATE None \n", "2 Total Population. The total number of all peop... FLOAT SUM \n", "3 Households. A count of the number of household... FLOAT SUM \n", "4 Male Population. The number of people within e... FLOAT SUM \n", "\n", " column_name variable_group_id \\\n", "0 geoid None \n", "1 do_date None \n", "2 total_pop None \n", "3 households None \n", "4 male_pop carto-do-public-data.usa_acs.demographics_soci... \n", "\n", " dataset_id \\\n", "0 carto-do-public-data.usa_acs.demographics_soci... \n", "1 carto-do-public-data.usa_acs.demographics_soci... \n", "2 carto-do-public-data.usa_acs.demographics_soci... \n", "3 carto-do-public-data.usa_acs.demographics_soci... \n", "4 carto-do-public-data.usa_acs.demographics_soci... \n", "\n", " id \n", "0 carto-do-public-data.usa_acs.demographics_soci... \n", "1 carto-do-public-data.usa_acs.demographics_soci... \n", "2 carto-do-public-data.usa_acs.demographics_soci... \n", "3 carto-do-public-data.usa_acs.demographics_soci... \n", "4 carto-do-public-data.usa_acs.demographics_soci... " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.variables.to_dataframe().head(5)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.3. Access to the ten first rows of the dataset" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 367 }, "id": "QJqYk6r886_J", "outputId": "fcd88f75-2146-4a61-b176-dc07a1c5a56c" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
geoidno_cardo_datemale_20male_21no_carsone_carpovertychildrenmale_poptwo_carsasian_popblack_popfemale_20female_21in_schoolpop_25_64total_popwhite_popfemale_popgini_indexhouseholdsmale_60_61male_62_64median_agethree_carsmale_5_to_9median_rentpop_16_overpop_widowedarmed_forcesemployed_pophispanic_popmale_under_5mobile_homespop_divorcedfemale_5_to_9housing_unitsmale_10_to_14male_15_to_17male_18_to_19male_22_to_24male_25_to_29male_30_to_34male_35_to_39male_40_to_44male_45_to_49male_45_to_64male_50_to_54male_55_to_59male_65_to_66male_67_to_69male_70_to_74male_75_to_79male_80_to_84median_incomepop_separatedamerindian_popfemale_under_5four_more_carsgroup_quartersmasters_degreeother_race_popunemployed_popwalked_to_workworked_at_homefemale_10_to_14female_15_to_17female_18_to_19female_22_to_24female_25_to_29female_30_to_34female_35_to_39female_40_to_44female_45_to_49female_50_to_54female_55_to_59female_60_to_61female_62_to_64female_65_to_66female_67_to_69female_70_to_74female_75_to_79female_80_to_84pop_15_and_overpop_now_marriedasian_male_45_54asian_male_55_64bachelors_degreeblack_male_45_54black_male_55_64commute_5_9_minscommuters_by_busin_grades_1_to_4in_grades_5_to_8male_85_and_overnot_hispanic_poppop_5_years_overwhite_male_45_54white_male_55_64associates_degreecommuters_16_overdwellings_2_unitsfamily_householdshispanic_any_racein_grades_9_to_12income_less_10000income_per_capitapop_25_years_overpop_never_marriedbachelors_degree_2commute_10_14_minscommute_15_19_minscommute_20_24_minscommute_25_29_minscommute_30_34_minscommute_35_39_minscommute_35_44_minscommute_40_44_minscommute_45_59_minscommute_60_89_minsfemale_85_and_overincome_10000_14999income_15000_19999income_20000_24999income_25000_29999income_30000_34999income_35000_39999income_40000_44999income_45000_49999income_50000_59999income_60000_74999income_75000_99999married_householdsnot_in_labor_forcenot_us_citizen_poppop_in_labor_forcehigh_school_diplomahispanic_male_45_54hispanic_male_55_64occupation_servicesworkers_16_and_overcivilian_labor_forcecommute_60_more_minscommute_90_more_minscommute_less_10_minscommuters_by_carpoolemployed_informationin_undergrad_collegeincome_100000_124999income_125000_149999income_150000_199999male_male_householdsnonfamily_householdsrent_over_50_percentvacant_housing_unitscommuters_drove_aloneemployed_constructionemployed_retail_tradeincome_200000_or_moreless_one_year_collegemale_45_64_grade_9_12one_year_more_collegerent_10_to_15_percentrent_15_to_20_percentrent_20_to_25_percentrent_25_to_30_percentrent_30_to_35_percentrent_35_to_40_percentrent_40_to_50_percentrent_under_10_percentsales_office_employedspeak_spanish_at_hometwo_or_more_races_popdwellings_3_to_4_unitsdwellings_5_to_9_unitsemployed_manufacturingmale_45_64_high_schooloccupied_housing_unitsmale_45_64_some_collegemortgaged_housing_unitsoccupation_sales_officepopulation_3_years_overasian_including_hispanicblack_including_hispanicdwellings_10_to_19_unitsdwellings_20_to_49_unitsemployed_wholesale_tradefemale_female_householdsrent_burden_not_computedwhite_including_hispanichigh_school_including_gedcommuters_by_car_truck_vandwellings_1_units_attacheddwellings_1_units_detacheddwellings_50_or_more_unitshousing_built_2000_to_2004male_45_64_graduate_degreeoccupation_management_artspopulation_1_year_and_overspeak_only_english_at_homehousing_built_2005_or_latermale_45_64_bachelors_degreemedian_year_structure_builtchildren_in_single_female_hhfamilies_with_young_childrengraduate_professional_degreehouseholds_retirement_incomemale_45_64_associates_degreemale_45_64_less_than_9_grademillion_dollar_housing_unitsowner_occupied_housing_unitspercent_income_spent_on_rentaggregate_travel_time_to_workamerindian_including_hispanichousing_built_1939_or_earlierhousing_units_renter_occupiedpop_determined_poverty_statusvacant_housing_units_for_rentvacant_housing_units_for_saleemployed_public_administrationless_than_high_school_graduatecommuters_by_subway_or_elevatedbachelors_degree_or_higher_25_64employed_education_health_socialspeak_spanish_at_home_low_englishcommuters_by_public_transportationdifferent_house_year_ago_same_citysome_college_and_associates_degreehouseholds_public_asst_or_food_stampsmanagement_business_sci_arts_employedemployed_finance_insurance_real_estatedifferent_house_year_ago_different_cityemployed_science_management_admin_wasteone_parent_families_with_young_childrentwo_parent_families_with_young_childrenemployed_other_services_not_public_adminowner_occupied_housing_units_median_valueemployed_transportation_warehousing_utilitiesoccupation_production_transportation_materialfather_one_parent_families_with_young_childrenowner_occupied_housing_units_lower_value_quartileowner_occupied_housing_units_upper_value_quartileemployed_agriculture_forestry_fishing_hunting_miningoccupation_natural_resources_construction_maintenancetwo_parents_in_labor_force_families_with_young_childrenemployed_arts_entertainment_recreation_accommodation_foodrenter_occupied_housing_units_paying_cash_median_gross_renttwo_parents_not_in_labor_force_families_with_young_childrenfather_in_labor_force_one_parent_families_with_young_childrentwo_parents_father_in_labor_force_families_with_young_childrentwo_parents_mother_in_labor_force_families_with_young_children
04715700500076.0201320170.00.0151.0122.0552.0316.0415.064.00.01004.019.042.0331.0328.01042.016.0627.00.4372343.00.02.028.90.038.0391.0749.0None0.0233.00.044.05.0None76.0465.027.026.030.022.011.013.031.011.015.079.021.041.00.05.026.05.031.014410.0None0.024.06.045.013.00.071.07.00.047.034.017.032.034.013.038.019.025.026.022.00.06.022.038.036.013.06.0NoneNone0.00.00.023.035.07.052.090.041.016.01042.0None13.03.028.0233.013.0183.00.0111.079.08747.0564.0None0.04.059.0108.010.020.00.07.07.013.00.038.0105.044.038.013.018.011.00.00.07.010.018.026.0445.00.0304.0188.00.00.058.0233.0304.05.05.07.021.00.063.00.00.00.00.0160.038.0122.0141.024.019.00.022.018.085.011.042.039.033.047.09.041.00.030.0None22.063.069.016.041.0343.010.020.030.0999.00.01004.040.025.02.00.018.016.0235.0162.00.0195.055.010.01.054.01019.0None0.00.01981.0278.075.013.047.07.02.00.065.030.5None0.081.0278.01042.014.00.04.0181.00.01.057.0None52.038.0135.0147.054.00.015.033.075.00.014.0None43.080.00.026600.0231300.00.011.00.021.0507.00.00.00.00.0
1720519900210.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0NoneNaN0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.00.00.00.00.0NaNNone0.00.0NaN0.00.0NaN0.00.00.00.00.0NaNNone0.00.00.00.00.00.00.0NaN0.00.00.0None0.0NaNNaN0.00.00.0NaN0.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
2720719900000.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0NoneNaN0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.00.00.00.00.0NaNNone0.00.0NaN0.00.0NaN0.00.00.00.00.0NaNNone0.00.00.00.00.00.00.0NaN0.00.00.0None0.0NaNNaN0.00.00.0NaN0.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
3010979900000.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
4181279800010.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
5471579801000.0201320170.06.00.00.058.00.038.00.00.04.00.00.00.054.074.070.036.0NaN0.00.00.031.30.00.0NaN74.0None0.00.00.00.00.0None0.00.00.00.06.00.00.06.012.04.00.00.00.00.00.00.00.04.00.0NaNNone0.00.00.074.00.00.00.00.00.00.00.00.04.018.06.00.00.00.05.03.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.074.0None0.00.00.00.00.00.00.00.00.05896.058.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.074.00.00.06.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.018.00.04.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.074.00.04.00.00.00.00.00.070.018.00.00.00.00.00.00.00.074.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.00.074.00.00.00.018.00.00.00.0None0.00.022.00.00.00.063.00.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
6550719900000.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
7250259901010.0201320170.00.00.00.00.00.058.00.00.00.00.00.029.023.071.00.013.0NaN13.00.00.024.013.00.0NaN71.0None0.071.071.00.00.0None0.013.00.00.016.019.00.00.00.00.00.023.00.023.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.013.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.071.00.00.00.00.0None0.00.00.071.00.013.071.00.00.017785.023.0None0.00.00.00.00.036.00.00.00.00.035.00.00.00.00.00.00.00.00.00.00.013.00.00.00.071.071.023.00.023.013.071.071.035.00.00.00.00.029.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.013.00.00.00.00.00.00.00.0None0.013.00.00.023.013.00.00.00.071.00.019.00.00.00.00.00.052.023.00.00.00.00.00.00.016.071.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.013.071.00.00.00.00.00.00.029.0None71.00.00.013.016.00.019.00.00.00.023.0None19.019.00.0NaNNaN0.023.00.00.0NaN0.00.00.00.0
8550259917030.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
9260419900000.0201320170.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaN0.00.00.0NaN0.00.0NaN0.0None0.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0NoneNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.0NaN0.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0None0.00.0NaN0.00.00.00.00.00.00.00.0NaNNone0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.00.00.00.00.00.00.00.00.0None0.00.00.0NaNNaN0.00.00.00.0NaN0.00.00.00.0
\n", "
" ], "text/plain": [ " geoid no_car do_date male_20 male_21 no_cars one_car poverty \\\n", "0 47157005000 76.0 20132017 0.0 0.0 151.0 122.0 552.0 \n", "1 72051990021 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "2 72071990000 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "3 01097990000 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "4 18127980001 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "5 47157980100 0.0 20132017 0.0 6.0 0.0 0.0 58.0 \n", "6 55071990000 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "7 25025990101 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "8 55025991703 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "9 26041990000 0.0 20132017 0.0 0.0 0.0 0.0 0.0 \n", "\n", " children male_pop two_cars asian_pop black_pop female_20 female_21 \\\n", "0 316.0 415.0 64.0 0.0 1004.0 19.0 42.0 \n", "1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "5 0.0 38.0 0.0 0.0 4.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "7 0.0 58.0 0.0 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "\n", " in_school pop_25_64 total_pop white_pop female_pop gini_index \\\n", "0 331.0 328.0 1042.0 16.0 627.0 0.4372 \n", "1 0.0 0.0 0.0 0.0 0.0 NaN \n", "2 0.0 0.0 0.0 0.0 0.0 NaN \n", "3 0.0 0.0 0.0 0.0 0.0 NaN \n", "4 0.0 0.0 0.0 0.0 0.0 NaN \n", "5 0.0 54.0 74.0 70.0 36.0 NaN \n", "6 0.0 0.0 0.0 0.0 0.0 NaN \n", "7 29.0 23.0 71.0 0.0 13.0 NaN \n", "8 0.0 0.0 0.0 0.0 0.0 NaN \n", "9 0.0 0.0 0.0 0.0 0.0 NaN \n", "\n", " households male_60_61 male_62_64 median_age three_cars male_5_to_9 \\\n", "0 343.0 0.0 2.0 28.9 0.0 38.0 \n", "1 0.0 0.0 0.0 NaN 0.0 0.0 \n", "2 0.0 0.0 0.0 NaN 0.0 0.0 \n", "3 0.0 0.0 0.0 NaN 0.0 0.0 \n", "4 0.0 0.0 0.0 NaN 0.0 0.0 \n", "5 0.0 0.0 0.0 31.3 0.0 0.0 \n", "6 0.0 0.0 0.0 NaN 0.0 0.0 \n", "7 13.0 0.0 0.0 24.0 13.0 0.0 \n", "8 0.0 0.0 0.0 NaN 0.0 0.0 \n", "9 0.0 0.0 0.0 NaN 0.0 0.0 \n", "\n", " median_rent pop_16_over pop_widowed armed_forces employed_pop \\\n", "0 391.0 749.0 None 0.0 233.0 \n", "1 NaN 0.0 None 0.0 0.0 \n", "2 NaN 0.0 None 0.0 0.0 \n", "3 NaN 0.0 None 0.0 0.0 \n", "4 NaN 0.0 None 0.0 0.0 \n", "5 NaN 74.0 None 0.0 0.0 \n", "6 NaN 0.0 None 0.0 0.0 \n", "7 NaN 71.0 None 0.0 71.0 \n", "8 NaN 0.0 None 0.0 0.0 \n", "9 NaN 0.0 None 0.0 0.0 \n", "\n", " hispanic_pop male_under_5 mobile_homes pop_divorced female_5_to_9 \\\n", "0 0.0 44.0 5.0 None 76.0 \n", "1 0.0 0.0 0.0 None 0.0 \n", "2 0.0 0.0 0.0 None 0.0 \n", "3 0.0 0.0 0.0 None 0.0 \n", "4 0.0 0.0 0.0 None 0.0 \n", "5 0.0 0.0 0.0 None 0.0 \n", "6 0.0 0.0 0.0 None 0.0 \n", "7 71.0 0.0 0.0 None 0.0 \n", "8 0.0 0.0 0.0 None 0.0 \n", "9 0.0 0.0 0.0 None 0.0 \n", "\n", " housing_units male_10_to_14 male_15_to_17 male_18_to_19 male_22_to_24 \\\n", "0 465.0 27.0 26.0 30.0 22.0 \n", "1 0.0 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 6.0 0.0 \n", "6 0.0 0.0 0.0 0.0 0.0 \n", "7 13.0 0.0 0.0 16.0 19.0 \n", "8 0.0 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 0.0 \n", "\n", " male_25_to_29 male_30_to_34 male_35_to_39 male_40_to_44 male_45_to_49 \\\n", "0 11.0 13.0 31.0 11.0 15.0 \n", "1 0.0 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 0.0 \n", "5 0.0 6.0 12.0 4.0 0.0 \n", "6 0.0 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 0.0 \n", "\n", " male_45_to_64 male_50_to_54 male_55_to_59 male_65_to_66 male_67_to_69 \\\n", "0 79.0 21.0 41.0 0.0 5.0 \n", "1 0.0 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 0.0 \n", "7 23.0 0.0 23.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 0.0 \n", "\n", " male_70_to_74 male_75_to_79 male_80_to_84 median_income pop_separated \\\n", "0 26.0 5.0 31.0 14410.0 None \n", "1 0.0 0.0 0.0 NaN None \n", "2 0.0 0.0 0.0 NaN None \n", "3 0.0 0.0 0.0 NaN None \n", "4 0.0 0.0 0.0 NaN None \n", "5 0.0 4.0 0.0 NaN None \n", "6 0.0 0.0 0.0 NaN None \n", "7 0.0 0.0 0.0 NaN None \n", "8 0.0 0.0 0.0 NaN None \n", "9 0.0 0.0 0.0 NaN None \n", "\n", " amerindian_pop female_under_5 four_more_cars group_quarters \\\n", "0 0.0 24.0 6.0 45.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 74.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " masters_degree other_race_pop unemployed_pop walked_to_work \\\n", "0 13.0 0.0 71.0 7.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " worked_at_home female_10_to_14 female_15_to_17 female_18_to_19 \\\n", "0 0.0 47.0 34.0 17.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " female_22_to_24 female_25_to_29 female_30_to_34 female_35_to_39 \\\n", "0 32.0 34.0 13.0 38.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 4.0 18.0 6.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 13.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " female_40_to_44 female_45_to_49 female_50_to_54 female_55_to_59 \\\n", "0 19.0 25.0 26.0 22.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 5.0 3.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " female_60_to_61 female_62_to_64 female_65_to_66 female_67_to_69 \\\n", "0 0.0 6.0 22.0 38.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " female_70_to_74 female_75_to_79 female_80_to_84 pop_15_and_over \\\n", "0 36.0 13.0 6.0 None \n", "1 0.0 0.0 0.0 None \n", "2 0.0 0.0 0.0 None \n", "3 0.0 0.0 0.0 None \n", "4 0.0 0.0 0.0 None \n", "5 0.0 0.0 0.0 None \n", "6 0.0 0.0 0.0 None \n", "7 0.0 0.0 0.0 None \n", "8 0.0 0.0 0.0 None \n", "9 0.0 0.0 0.0 None \n", "\n", " pop_now_married asian_male_45_54 asian_male_55_64 bachelors_degree \\\n", "0 None 0.0 0.0 0.0 \n", "1 None 0.0 0.0 0.0 \n", "2 None 0.0 0.0 0.0 \n", "3 None 0.0 0.0 0.0 \n", "4 None 0.0 0.0 0.0 \n", "5 None 0.0 0.0 0.0 \n", "6 None 0.0 0.0 0.0 \n", "7 None 0.0 0.0 0.0 \n", "8 None 0.0 0.0 0.0 \n", "9 None 0.0 0.0 0.0 \n", "\n", " black_male_45_54 black_male_55_64 commute_5_9_mins commuters_by_bus \\\n", "0 23.0 35.0 7.0 52.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 71.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " in_grades_1_to_4 in_grades_5_to_8 male_85_and_over not_hispanic_pop \\\n", "0 90.0 41.0 16.0 1042.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 74.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " pop_5_years_over white_male_45_54 white_male_55_64 associates_degree \\\n", "0 None 13.0 3.0 28.0 \n", "1 None 0.0 0.0 0.0 \n", "2 None 0.0 0.0 0.0 \n", "3 None 0.0 0.0 0.0 \n", "4 None 0.0 0.0 0.0 \n", "5 None 0.0 0.0 0.0 \n", "6 None 0.0 0.0 0.0 \n", "7 None 0.0 0.0 0.0 \n", "8 None 0.0 0.0 0.0 \n", "9 None 0.0 0.0 0.0 \n", "\n", " commuters_16_over dwellings_2_units family_households hispanic_any_race \\\n", "0 233.0 13.0 183.0 0.0 \n", "1 0.0 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 0.0 \n", "7 71.0 0.0 13.0 71.0 \n", "8 0.0 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 0.0 \n", "\n", " in_grades_9_to_12 income_less_10000 income_per_capita pop_25_years_over \\\n", "0 111.0 79.0 8747.0 564.0 \n", "1 0.0 0.0 NaN 0.0 \n", "2 0.0 0.0 NaN 0.0 \n", "3 0.0 0.0 NaN 0.0 \n", "4 0.0 0.0 NaN 0.0 \n", "5 0.0 0.0 5896.0 58.0 \n", "6 0.0 0.0 NaN 0.0 \n", "7 0.0 0.0 17785.0 23.0 \n", "8 0.0 0.0 NaN 0.0 \n", "9 0.0 0.0 NaN 0.0 \n", "\n", " pop_never_married bachelors_degree_2 commute_10_14_mins \\\n", "0 None 0.0 4.0 \n", "1 None NaN 0.0 \n", "2 None NaN 0.0 \n", "3 None 0.0 0.0 \n", "4 None 0.0 0.0 \n", "5 None 0.0 0.0 \n", "6 None 0.0 0.0 \n", "7 None 0.0 0.0 \n", "8 None 0.0 0.0 \n", "9 None 0.0 0.0 \n", "\n", " commute_15_19_mins commute_20_24_mins commute_25_29_mins \\\n", "0 59.0 108.0 10.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " commute_30_34_mins commute_35_39_mins commute_35_44_mins \\\n", "0 20.0 0.0 7.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 36.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " commute_40_44_mins commute_45_59_mins commute_60_89_mins \\\n", "0 7.0 13.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 35.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " female_85_and_over income_10000_14999 income_15000_19999 \\\n", "0 38.0 105.0 44.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " income_20000_24999 income_25000_29999 income_30000_34999 \\\n", "0 38.0 13.0 18.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " income_35000_39999 income_40000_44999 income_45000_49999 \\\n", "0 11.0 0.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " income_50000_59999 income_60000_74999 income_75000_99999 \\\n", "0 7.0 10.0 18.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 13.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " married_households not_in_labor_force not_us_citizen_pop \\\n", "0 26.0 445.0 0.0 \n", "1 0.0 0.0 NaN \n", "2 0.0 0.0 NaN \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 74.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 71.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " pop_in_labor_force high_school_diploma hispanic_male_45_54 \\\n", "0 304.0 188.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 6.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 71.0 23.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " hispanic_male_55_64 occupation_services workers_16_and_over \\\n", "0 0.0 58.0 233.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 23.0 13.0 71.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " civilian_labor_force commute_60_more_mins commute_90_more_mins \\\n", "0 304.0 5.0 5.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 71.0 35.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " commute_less_10_mins commuters_by_carpool employed_information \\\n", "0 7.0 21.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " in_undergrad_college income_100000_124999 income_125000_149999 \\\n", "0 63.0 0.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 29.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " income_150000_199999 male_male_households nonfamily_households \\\n", "0 0.0 0.0 160.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " rent_over_50_percent vacant_housing_units commuters_drove_alone \\\n", "0 38.0 122.0 141.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " employed_construction employed_retail_trade income_200000_or_more \\\n", "0 24.0 19.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " less_one_year_college male_45_64_grade_9_12 one_year_more_college \\\n", "0 22.0 18.0 85.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 18.0 0.0 4.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " rent_10_to_15_percent rent_15_to_20_percent rent_20_to_25_percent \\\n", "0 11.0 42.0 39.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 13.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " rent_25_to_30_percent rent_30_to_35_percent rent_35_to_40_percent \\\n", "0 33.0 47.0 9.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " rent_40_to_50_percent rent_under_10_percent sales_office_employed \\\n", "0 41.0 0.0 30.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " speak_spanish_at_home two_or_more_races_pop dwellings_3_to_4_units \\\n", "0 None 22.0 63.0 \n", "1 None 0.0 0.0 \n", "2 None 0.0 0.0 \n", "3 None 0.0 0.0 \n", "4 None 0.0 0.0 \n", "5 None 0.0 0.0 \n", "6 None 0.0 0.0 \n", "7 None 0.0 13.0 \n", "8 None 0.0 0.0 \n", "9 None 0.0 0.0 \n", "\n", " dwellings_5_to_9_units employed_manufacturing male_45_64_high_school \\\n", "0 69.0 16.0 41.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 0.0 23.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " occupied_housing_units male_45_64_some_college mortgaged_housing_units \\\n", "0 343.0 10.0 20.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 13.0 0.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " occupation_sales_office population_3_years_over asian_including_hispanic \\\n", "0 30.0 999.0 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 74.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 71.0 0.0 \n", "8 0.0 0.0 0.0 \n", "9 0.0 0.0 0.0 \n", "\n", " black_including_hispanic dwellings_10_to_19_units \\\n", "0 1004.0 40.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 4.0 0.0 \n", "6 0.0 0.0 \n", "7 19.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " dwellings_20_to_49_units employed_wholesale_trade \\\n", "0 25.0 2.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " female_female_households rent_burden_not_computed \\\n", "0 0.0 18.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " white_including_hispanic high_school_including_ged \\\n", "0 16.0 235.0 \n", "1 0.0 NaN \n", "2 0.0 NaN \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 70.0 18.0 \n", "6 0.0 0.0 \n", "7 52.0 23.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " commuters_by_car_truck_van dwellings_1_units_attached \\\n", "0 162.0 0.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " dwellings_1_units_detached dwellings_50_or_more_units \\\n", "0 195.0 55.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " housing_built_2000_to_2004 male_45_64_graduate_degree \\\n", "0 10.0 1.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " occupation_management_arts population_1_year_and_over \\\n", "0 54.0 1019.0 \n", "1 0.0 NaN \n", "2 0.0 NaN \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 74.0 \n", "6 0.0 0.0 \n", "7 16.0 71.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " speak_only_english_at_home housing_built_2005_or_later \\\n", "0 None 0.0 \n", "1 None 0.0 \n", "2 None 0.0 \n", "3 None 0.0 \n", "4 None 0.0 \n", "5 None 0.0 \n", "6 None 0.0 \n", "7 None 0.0 \n", "8 None 0.0 \n", "9 None 0.0 \n", "\n", " male_45_64_bachelors_degree median_year_structure_built \\\n", "0 0.0 1981.0 \n", "1 0.0 NaN \n", "2 0.0 NaN \n", "3 0.0 NaN \n", "4 0.0 NaN \n", "5 0.0 NaN \n", "6 0.0 NaN \n", "7 0.0 NaN \n", "8 0.0 NaN \n", "9 0.0 NaN \n", "\n", " children_in_single_female_hh families_with_young_children \\\n", "0 278.0 75.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " graduate_professional_degree households_retirement_income \\\n", "0 13.0 47.0 \n", "1 NaN 0.0 \n", "2 NaN 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " male_45_64_associates_degree male_45_64_less_than_9_grade \\\n", "0 7.0 2.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " million_dollar_housing_units owner_occupied_housing_units \\\n", "0 0.0 65.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " percent_income_spent_on_rent aggregate_travel_time_to_work \\\n", "0 30.5 None \n", "1 NaN None \n", "2 NaN None \n", "3 NaN None \n", "4 NaN None \n", "5 NaN None \n", "6 NaN None \n", "7 NaN None \n", "8 NaN None \n", "9 NaN None \n", "\n", " amerindian_including_hispanic housing_built_1939_or_earlier \\\n", "0 0.0 81.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " housing_units_renter_occupied pop_determined_poverty_status \\\n", "0 278.0 1042.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 74.0 \n", "6 0.0 0.0 \n", "7 13.0 71.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " vacant_housing_units_for_rent vacant_housing_units_for_sale \\\n", "0 14.0 0.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " employed_public_administration less_than_high_school_graduate \\\n", "0 4.0 181.0 \n", "1 0.0 NaN \n", "2 0.0 NaN \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 18.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " commuters_by_subway_or_elevated bachelors_degree_or_higher_25_64 \\\n", "0 0.0 1.0 \n", "1 0.0 0.0 \n", "2 0.0 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " employed_education_health_social speak_spanish_at_home_low_english \\\n", "0 57.0 None \n", "1 0.0 None \n", "2 0.0 None \n", "3 0.0 None \n", "4 0.0 None \n", "5 0.0 None \n", "6 0.0 None \n", "7 29.0 None \n", "8 0.0 None \n", "9 0.0 None \n", "\n", " commuters_by_public_transportation different_house_year_ago_same_city \\\n", "0 52.0 38.0 \n", "1 0.0 NaN \n", "2 0.0 NaN \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 0.0 0.0 \n", "6 0.0 0.0 \n", "7 71.0 0.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " some_college_and_associates_degree households_public_asst_or_food_stamps \\\n", "0 135.0 147.0 \n", "1 NaN 0.0 \n", "2 NaN 0.0 \n", "3 0.0 0.0 \n", "4 0.0 0.0 \n", "5 22.0 0.0 \n", "6 0.0 0.0 \n", "7 0.0 13.0 \n", "8 0.0 0.0 \n", "9 0.0 0.0 \n", "\n", " management_business_sci_arts_employed \\\n", "0 54.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 16.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " employed_finance_insurance_real_estate \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " different_house_year_ago_different_city \\\n", "0 15.0 \n", "1 NaN \n", "2 NaN \n", "3 0.0 \n", "4 0.0 \n", "5 63.0 \n", "6 0.0 \n", "7 19.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " employed_science_management_admin_waste \\\n", "0 33.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " one_parent_families_with_young_children \\\n", "0 75.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " two_parent_families_with_young_children \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " employed_other_services_not_public_admin \\\n", "0 14.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 23.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " owner_occupied_housing_units_median_value \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "5 None \n", "6 None \n", "7 None \n", "8 None \n", "9 None \n", "\n", " employed_transportation_warehousing_utilities \\\n", "0 43.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 19.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " occupation_production_transportation_material \\\n", "0 80.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 19.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " father_one_parent_families_with_young_children \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " owner_occupied_housing_units_lower_value_quartile \\\n", "0 26600.0 \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "\n", " owner_occupied_housing_units_upper_value_quartile \\\n", "0 231300.0 \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "\n", " employed_agriculture_forestry_fishing_hunting_mining \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " occupation_natural_resources_construction_maintenance \\\n", "0 11.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 23.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " two_parents_in_labor_force_families_with_young_children \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " employed_arts_entertainment_recreation_accommodation_food \\\n", "0 21.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " renter_occupied_housing_units_paying_cash_median_gross_rent \\\n", "0 507.0 \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "\n", " two_parents_not_in_labor_force_families_with_young_children \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " father_in_labor_force_one_parent_families_with_young_children \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " two_parents_father_in_labor_force_families_with_young_children \\\n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 \n", "\n", " two_parents_mother_in_labor_force_families_with_young_children \n", "0 0.0 \n", "1 0.0 \n", "2 0.0 \n", "3 0.0 \n", "4 0.0 \n", "5 0.0 \n", "6 0.0 \n", "7 0.0 \n", "8 0.0 \n", "9 0.0 " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.4. Summary of different counts over the actual dataset data" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "rows 7.400100e+04\n", "cells 1.864825e+07\n", "null_cells 7.901830e+05\n", "null_cells_percent 4.237303e+00\n", "dtype: float64" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.counts()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.5. Fields by type" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "float 250\n", "string 2\n", "dtype: int64" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.fields_by_type()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.6. Statistical description of numerical variables" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 367 }, "id": "oS8KjzKP89ar", "outputId": "f2255e8d-98c9-45c1-f7bd-1f038ac0bd78" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_pophouseholdsmale_popfemale_popmedian_agemale_under_5male_5_to_9male_10_to_14male_15_to_17male_18_to_19male_20male_21male_22_to_24male_25_to_29male_30_to_34male_35_to_39male_40_to_44male_45_to_49male_50_to_54male_55_to_59male_65_to_66male_67_to_69male_70_to_74male_75_to_79male_80_to_84male_85_and_overfemale_under_5female_5_to_9female_10_to_14female_15_to_17female_18_to_19female_20female_21female_22_to_24female_25_to_29female_30_to_34female_35_to_39female_40_to_44female_45_to_49female_50_to_54female_55_to_59female_60_to_61female_62_to_64female_65_to_66female_67_to_69female_70_to_74female_75_to_79female_80_to_84female_85_and_overwhite_poppopulation_1_year_and_overpopulation_3_years_overpop_5_years_overpop_15_and_overpop_16_overpop_25_years_overpop_25_64pop_never_marriedpop_now_marriedpop_separatedpop_widowedpop_divorcednot_us_citizen_popblack_popasian_pophispanic_popamerindian_popother_race_poptwo_or_more_races_pophispanic_any_racenot_hispanic_popasian_male_45_54asian_male_55_64black_male_45_54black_male_55_64hispanic_male_45_54hispanic_male_55_64white_male_45_54white_male_55_64median_incomeincome_per_capitaincome_less_10000income_10000_14999income_15000_19999income_20000_24999income_25000_29999income_30000_34999income_35000_39999income_40000_44999income_45000_49999income_50000_59999income_60000_74999income_75000_99999income_100000_124999income_125000_149999income_150000_199999income_200000_or_morepop_determined_poverty_statuspovertygini_indexhousing_unitsrenter_occupied_housing_units_paying_cash_median_gross_rentowner_occupied_housing_units_lower_value_quartileowner_occupied_housing_units_median_valueowner_occupied_housing_units_upper_value_quartileoccupied_housing_unitshousing_units_renter_occupiedvacant_housing_unitsvacant_housing_units_for_rentvacant_housing_units_for_saledwellings_1_units_detacheddwellings_1_units_attacheddwellings_2_unitsdwellings_3_to_4_unitsdwellings_5_to_9_unitsdwellings_10_to_19_unitsdwellings_20_to_49_unitsdwellings_50_or_more_unitsmobile_homeshousing_built_2005_or_laterhousing_built_2000_to_2004housing_built_1939_or_earliermedian_year_structure_builtmarried_householdsnonfamily_householdsfamily_householdshouseholds_public_asst_or_food_stampsmale_male_householdsfemale_female_householdschildrenchildren_in_single_female_hhmedian_rentpercent_income_spent_on_rentrent_burden_not_computedrent_over_50_percentrent_40_to_50_percentrent_35_to_40_percentrent_30_to_35_percentrent_25_to_30_percentrent_20_to_25_percentrent_15_to_20_percentrent_10_to_15_percentrent_under_10_percentowner_occupied_housing_unitsmillion_dollar_housing_unitsmortgaged_housing_unitsdifferent_house_year_ago_different_citydifferent_house_year_ago_same_cityfamilies_with_young_childrentwo_parent_families_with_young_childrentwo_parents_in_labor_force_families_with_young_childrentwo_parents_father_in_labor_force_families_with_young_childrentwo_parents_mother_in_labor_force_families_with_young_childrentwo_parents_not_in_labor_force_families_with_young_childrenone_parent_families_with_young_childrenfather_one_parent_families_with_young_childrenfather_in_labor_force_one_parent_families_with_young_childrencommute_less_10_minscommute_10_14_minscommute_15_19_minscommute_20_24_minscommute_25_29_minscommute_30_34_minscommute_35_44_minscommute_45_59_minscommute_60_more_minscommuters_16_overwalked_to_workworked_at_homeno_carno_carsone_cartwo_carsthree_carsfour_more_carsaggregate_travel_time_to_workcommuters_by_public_transportationcommuters_by_buscommuters_by_car_truck_vancommuters_by_carpoolcommuters_by_subway_or_elevatedcommuters_drove_alonegroup_quartersassociates_degreebachelors_degreehigh_school_diplomaless_one_year_collegemasters_degreeone_year_more_collegeless_than_high_school_graduatehigh_school_including_gedbachelors_degree_2bachelors_degree_or_higher_25_64graduate_professional_degreesome_college_and_associates_degreemale_45_64_associates_degreemale_45_64_bachelors_degreemale_45_64_graduate_degreemale_45_64_less_than_9_grademale_45_64_grade_9_12male_45_64_high_schoolmale_45_64_some_collegemale_45_to_64employed_popunemployed_poppop_in_labor_forcenot_in_labor_forceworkers_16_and_overarmed_forcescivilian_labor_forceemployed_agriculture_forestry_fishing_hunting_miningemployed_arts_entertainment_recreation_accommodation_foodemployed_constructionemployed_education_health_socialemployed_finance_insurance_real_estateemployed_informationemployed_manufacturingemployed_other_services_not_public_adminemployed_public_administrationemployed_retail_tradeemployed_science_management_admin_wasteemployed_transportation_warehousing_utilitiesemployed_wholesale_tradeoccupation_management_artsoccupation_natural_resources_construction_maintenanceoccupation_production_transportation_materialoccupation_sales_officeoccupation_servicesmanagement_business_sci_arts_employedsales_office_employedin_grades_1_to_4in_grades_5_to_8in_grades_9_to_12in_schoolin_undergrad_collegespeak_only_english_at_homespeak_spanish_at_homespeak_spanish_at_home_low_english
avg4384.7161622.2552157.7112227.00539.301138.383142.308144.57588.04860.37232.76532.17492.851155.252148.350138.830137.546141.625148.273142.35544.90157.96573.06250.08833.34328.863132.231136.600138.31684.02057.56730.89030.41988.340150.569146.878139.650139.306144.672153.890151.45457.49279.40349.83065.20285.53662.53947.08255.1222666.2374342.5394225.816NoneNone3495.0062954.8582301.326NoneNoneNoneNoneNone305.762533.077229.615810.03228.3629.694100.731810.0323574.68414.91611.69434.40129.04247.00730.485188.315192.63361206.50530651.804112.02979.90379.06681.21176.99078.11172.82372.98964.370124.887160.500198.418139.12887.01493.800101.0164276.775637.7420.4261850.7971058.678176568.474244327.960332960.3681622.255586.179228.54238.84718.6321143.346109.26667.63081.12987.97582.48165.91896.432115.06716.10342.21594.0301971.950782.945552.6841069.572220.1472.8482.9101004.481254.948896.06130.75745.496138.33249.80836.22249.36762.23268.74667.92646.91321.1361036.07614.981655.655411.542195.111312.742201.810118.29874.1806.3412.992110.93225.60122.815243.340261.580294.358280.068122.279263.641131.140156.067171.7181924.19255.15795.26287.285144.230540.504604.804229.571103.14659341.504103.10151.1481729.272184.78438.1831544.488109.820245.286564.903690.444182.175246.894429.059375.563808.881566.375743.548349.192860.34443.028100.06564.98530.09742.240164.811112.808558.0332049.152145.6862208.7071286.2992019.45413.8692194.83838.275198.444129.972473.374134.64843.153210.403100.38496.162233.863231.125104.33155.019766.585182.001249.131482.802368.633766.585482.802222.900225.327232.2261116.528255.724NoneNoneNone
max65528.00021429.00032266.00033262.00085.7003297.0003464.0003137.0002416.0003909.0002845.0003025.0006083.0003956.0002143.0003146.0003718.0002652.0002300.0001741.0001244.0003225.0004708.0003287.0001666.000667.0002829.0003509.0003667.0001601.0004815.0001586.0001330.0002045.0002410.0002840.0003450.0003586.0003628.0001756.0001445.000873.0002105.0002147.0003661.0005268.0002481.0001166.0001337.00038684.00064803.00062438.000NoneNone44642.00039486.00034258.000NoneNoneNoneNoneNone12232.00016655.00013712.00028683.0009644.0001385.0003611.00028683.00050477.0001301.000745.0001094.0001122.0001464.000777.0002189.0002545.000250001.000220253.0001550.000930.000761.0001009.000876.000864.0001530.0001118.000861.0002054.0002789.0003368.0002704.0002157.0003878.0005386.00065332.0009440.0000.82926526.0003501.0002000001.0002000001.0002000001.00021429.0008039.00011924.0004472.000547.00025527.0004280.0001999.0001629.0001863.0005280.0004283.00011518.0003314.0002502.0007206.0006177.0002016.00015105.0006883.00016813.0002325.000355.000174.00023608.0002863.0003501.00050.0001100.0003487.000972.000641.000860.000999.0001382.0001879.0001098.000912.00020473.0001453.00012672.00013064.0005347.0006700.0006517.0003989.0003888.0001308.000285.0001418.000502.000502.00011621.0005838.0007095.0004886.0002205.0004880.0003178.0005390.0006070.00026482.00011621.0007043.0008111.0005847.00015548.00012012.0003231.0001107.000973160.0007759.0003940.00025012.0003023.0005945.00021989.00016421.0004070.00013767.0008215.0004037.0007767.0005621.0005363.0008929.00013767.00022856.00010374.00012745.000855.0002547.0002448.000900.0001626.0002084.0001628.0006993.00028945.0001607.00030552.00034142.00028252.00021214.00030552.0004197.0005211.0001950.0009127.0002853.0001141.0003993.0001175.0001816.0002808.0005115.0001465.0001294.00019097.0003973.0002495.0006162.0003948.00019097.0006162.0005927.0005674.0004965.00023989.00012985.000NoneNoneNone
min0.0000.0000.0000.0007.7000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000NoneNone0.0000.0000.000NoneNoneNoneNoneNone0.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0002499.00032.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0010.00099.0009999.0009999.0009999.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0001939.0000.0000.0000.0000.0000.0000.0000.0000.00099.00010.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.00065.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000NoneNoneNone
sum324473370.000120048527.000159672750.000164800620.0002879750.60010240491.00010530919.00010698700.0006515667.0004467600.0002424606.0002380945.0006871085.00011488834.00010978057.00010273584.00010178564.00010480362.00010972330.00010534395.0003322707.0004289470.0005406639.0003706536.0002467409.0002135919.0009785223.00010108532.00010235546.0006217528.0004259986.0002285886.0002251005.0006537216.00011142266.00010869144.00010334203.00010308819.00010705845.00011387986.00011207768.0004254466.0005875871.0003687460.0004825029.0006329715.0004627940.0003484080.0004079106.000197304205.000317248555.000312714581.000NoneNone258633976.000218662435.000170300425.000NoneNoneNoneNoneNone22337765.00039448215.00016991765.00059943182.0002098847.000717393.0007454186.00059943182.000264530188.0001103826.000865352.0002545740.0002149154.0003478537.0002255952.00013935498.00014255050.0004464586091.0002245428568.0008290228.0005912909.0005850945.0006009672.0005697363.0005780308.0005388955.0005401277.0004763457.0009241728.00011877176.00014683147.00010295604.0006439142.0006941320.0007475296.000316485642.00047193565.00031111.100136960864.00076128487.00012589332219.00017587459517.00023968817977.000120048527.00043377863.00016912337.0002874708.0001378777.00084608778.0008085807.0005004687.0006003655.0006510210.0006103648.0004877964.0007136049.0008515077.0001191642.0003123981.0006958328.000142948661.00057938689.00040899159.00079149368.00016291126.000210721.000215333.00074332606.00018866414.00064273567.0002225701.7003366768.00010236720.0003685848.0002680486.0003653236.0004605232.0005087309.0005026567.0003471635.0001564062.00076670664.0001108620.00048519146.00030065590.00014253996.00023143255.00014934156.0008754150.0005489360.000469236.000221410.0008209099.0001894468.0001688343.00018007425.00019357159.00021782820.00020725344.0009048793.00019509679.0009704493.00011549099.00012707300.000142392112.0004081654.0007049498.0006459181.00010673160.00039997864.00044756070.00016988505.0007632928.0002970754365.0007629599.0003785002.000127967857.00013674224.0002825557.000114293633.0008126758.00018151427.00041803378.00051093567.00013481107.00018270373.00031750818.00027437114.00059093612.00041377068.00055023314.00025510535.00062853315.0003184139.0007404907.0004808988.0002227181.0003125781.00012196143.0008347879.00041295018.000151639301.00010780902.000163446545.00095187431.000149441610.0001026342.000162420203.0002832376.00014685032.0009618071.00035030129.0009964050.0003193371.00015570023.0007428501.0007116087.00017306059.00017103509.0007720629.0004071464.00056728086.00013468231.00018435915.00035727854.00027279215.00056728086.00035727854.00016494816.00016674443.00017184966.00082624168.00018923849.000NoneNoneNone
range65528.00021429.00032266.00033262.00078.0003297.0003464.0003137.0002416.0003909.0002845.0003025.0006083.0003956.0002143.0003146.0003718.0002652.0002300.0001741.0001244.0003225.0004708.0003287.0001666.000667.0002829.0003509.0003667.0001601.0004815.0001586.0001330.0002045.0002410.0002840.0003450.0003586.0003628.0001756.0001445.000873.0002105.0002147.0003661.0005268.0002481.0001166.0001337.00038684.00064803.00062438.000NoneNone44642.00039486.00034258.000NoneNoneNoneNoneNone12232.00016655.00013712.00028683.0009644.0001385.0003611.00028683.00050477.0001301.000745.0001094.0001122.0001464.000777.0002189.0002545.000247502.000220221.0001550.000930.000761.0001009.000876.000864.0001530.0001118.000861.0002054.0002789.0003368.0002704.0002157.0003878.0005386.00065332.0009440.0000.82826526.0003402.0001990002.0001990002.0001990002.00021429.0008039.00011924.0004472.000547.00025527.0004280.0001999.0001629.0001863.0005280.0004283.00011518.0003314.0002502.0007206.0006177.00077.00015105.0006883.00016813.0002325.000355.000174.00023608.0002863.0003402.00040.0001100.0003487.000972.000641.000860.000999.0001382.0001879.0001098.000912.00020473.0001453.00012672.00013064.0005347.0006700.0006517.0003989.0003888.0001308.000285.0001418.000502.000502.00011621.0005838.0007095.0004886.0002205.0004880.0003178.0005390.0006070.00026482.00011621.0007043.0008111.0005847.00015548.00012012.0003231.0001107.000973095.0007759.0003940.00025012.0003023.0005945.00021989.00016421.0004070.00013767.0008215.0004037.0007767.0005621.0005363.0008929.00013767.00022856.00010374.00012745.000855.0002547.0002448.000900.0001626.0002084.0001628.0006993.00028945.0001607.00030552.00034142.00028252.00021214.00030552.0004197.0005211.0001950.0009127.0002853.0001141.0003993.0001175.0001816.0002808.0005115.0001465.0001294.00019097.0003973.0002495.0006162.0003948.00019097.0006162.0005927.0005674.0004965.00023989.00012985.000NoneNoneNone
stdev2228.937793.6171120.5611146.2407.751110.491112.164113.20071.887107.59354.89952.51994.760125.158115.504105.708103.40699.13995.75887.38636.85947.08559.93846.41733.90133.031106.250109.686110.04269.231122.20254.00450.17579.572118.100109.718104.010102.26299.84095.95690.64842.79555.33740.18451.25667.01052.31342.66857.9381907.5042201.7322139.467NoneNone1719.9051474.7481216.138NoneNoneNoneNoneNone453.551909.323503.6081282.778178.95634.688127.0441282.7782056.41739.75231.82863.03353.95783.68958.783152.387145.51630901.05816126.937106.30069.84963.59062.05958.30058.62655.05354.98949.50784.174105.981137.296114.71785.138107.818164.7832216.522561.8140.064895.836464.256164802.630218956.686286614.050793.617479.149313.12267.02028.307754.309195.291113.359116.582132.416151.111144.087299.168225.07847.328103.868116.60117.553505.011363.756585.972196.6138.8997.653676.013240.274458.7207.79549.744143.29955.74743.03155.98766.94972.52472.06153.12231.293654.34355.371479.093393.284249.243231.674182.928114.81790.50618.14511.524114.15537.74435.345225.753196.725213.210208.958110.217215.589129.281160.217190.4051072.317140.448104.734231.521229.842331.457379.998171.13094.48434229.680264.763108.6311041.140144.773196.741947.467444.664169.441482.882409.367126.778255.769262.970354.004479.144484.280706.282380.169506.21140.479100.99186.98149.65445.710115.91081.153303.3561138.865109.2201203.354715.0051129.133161.6171192.20888.749160.030111.691301.579130.57354.003182.62876.19499.876155.195201.50090.18754.514615.676151.202186.202298.801236.678615.676298.801168.745169.223168.723766.285408.312NoneNoneNone
q12627.000998.0001276.0001318.00032.80056.00057.00059.00032.00014.0000.0000.00031.00061.00061.00060.00060.00066.00072.00071.00015.00022.00028.00016.0008.0004.00053.00054.00055.00030.00012.0000.0000.00030.00060.00064.00062.00062.00068.00077.00077.00023.00035.00018.00026.00036.00022.00014.00014.000951.0002604.0002519.000NoneNone2125.0001782.0001328.000NoneNoneNoneNoneNone22.00016.0000.00066.0000.0000.00016.00066.0001943.0000.0000.0000.0000.0000.0000.00053.00060.00036974.00019023.00034.00023.00026.00030.00029.00030.00028.00029.00024.00058.00076.00086.00047.00019.00014.0008.0002559.000212.0000.3741153.000692.00065700.00098800.000149100.000998.000209.00064.0000.0000.000522.0007.0000.0000.0000.0000.0000.0000.0000.0000.0000.0009.0001956.000381.000273.000612.00062.0000.0000.000508.00073.000529.00024.2009.00029.0007.0000.0007.00011.00014.00015.0008.0000.000496.0000.000274.000140.0006.000141.00070.00034.00012.0000.0000.00023.0000.0000.00084.000104.000126.000110.00036.00095.00033.00038.00042.0001072.0000.00023.0007.00029.000278.000301.00085.00024.00033150.0000.0000.000894.00074.0000.000780.0000.000109.000191.000342.00080.00062.000222.000115.000400.000192.000220.00081.000457.00011.00024.0008.0000.0007.00067.00047.000316.0001143.00060.0001245.000746.0001115.0000.0001235.0000.00082.00045.000234.00041.0007.00065.00040.00029.000111.00081.00037.00013.000290.00063.00096.000243.000186.000290.000243.00097.00097.000102.000560.00084.000NoneNoneNone
q34606.0001714.0002254.0002334.00041.100138.000142.000145.00088.00052.00026.00026.00087.000151.000146.000138.000138.000144.000152.000148.00045.00059.00074.00050.00033.00027.000132.000137.000139.00085.00046.00023.00024.00084.000149.000146.000140.000141.000148.000159.000159.00058.00081.00050.00066.00087.00063.00046.00051.0002942.0004525.0004421.000NoneNone3666.0003115.0002398.000NoneNoneNoneNoneNone198.000269.00097.000448.0002.0000.00088.000448.0003809.0000.0000.00016.00013.00023.00013.000200.000210.00060825.00030221.000104.00079.00080.00082.00078.00080.00074.00074.00065.000128.000167.000207.000141.00083.00081.00060.0004496.000605.0000.4351949.0001055.000153300.000210800.000286700.0001714.000570.000188.00031.00015.0001248.00062.00041.00059.00060.00043.00027.00020.00027.0000.00021.00081.0001978.000813.000555.0001126.000210.0000.0000.0001019.000233.000889.00031.40041.000126.00045.00032.00044.00057.00063.00062.00042.00017.0001105.0000.000679.000383.000166.000313.000197.000113.00066.0000.0000.000100.00019.00017.000231.000261.000297.000283.000121.000261.000124.000145.000145.0002014.00034.00087.00048.000109.000556.000636.000240.000102.00060350.00034.00020.0001824.000183.0000.0001637.00020.000252.000550.000728.000189.000216.000438.000339.000850.000547.000683.000295.000902.00042.00092.00049.00019.00039.000172.000115.000582.0002156.000145.0002319.0001325.0002115.0000.0002300.00017.000194.000126.000487.000125.00037.000204.000101.00087.000238.000220.000101.00053.000747.000181.000253.000501.000374.000747.000501.000224.000226.000236.0001120.000212.000NoneNoneNone
median3627.0001357.0001773.0001842.00037.10094.00098.00099.00059.00031.00013.00013.00056.000103.000101.00096.00097.000103.000111.000108.00029.00039.00050.00032.00019.00015.00090.00094.00094.00056.00027.00011.00011.00056.000102.000102.000100.00099.000106.000118.000117.00040.00058.00034.00045.00060.00041.00029.00030.0001989.0003590.0003499.000NoneNone2921.0002453.0001880.000NoneNoneNoneNoneNone82.00082.00028.000187.0000.0000.00047.000187.0002906.0000.0000.0000.0000.0005.0000.000127.000135.00048811.00024552.00064.00048.00051.00055.00052.00053.00049.00050.00044.00092.000120.000145.00092.00048.00040.00026.0003523.000383.0000.4051547.000851.000101100.000147900.000203100.0001357.000374.000120.00010.0000.000915.00026.00015.00023.00019.0009.0000.0000.0000.0000.0004.00040.0001969.000599.000409.000870.000129.0000.0000.000765.000144.000691.00028.10024.00070.00022.00015.00022.00030.00035.00035.00023.0007.000812.0000.000472.000251.00067.000223.000130.00071.00035.0000.0000.00057.0005.0000.000150.000180.000207.000193.00074.000174.00073.00082.00084.0001548.00016.00052.00023.00062.000411.000471.000162.00060.00045995.0008.0002.0001362.000124.0000.0001211.0005.000178.000342.000534.000132.000126.000325.000214.000630.000345.000408.000165.000672.00025.00052.00024.0006.00021.000118.00079.000450.0001651.000100.0001793.0001026.0001622.0000.0001780.0000.000133.00082.000358.00078.00019.000129.00069.00055.000172.000141.00066.00031.000495.000120.000168.000369.000274.000495.000369.000158.000161.000165.000833.000142.000NoneNoneNone
interquartile_range1979.000716.000978.0001016.0008.30082.00085.00086.00056.00038.00026.00026.00056.00090.00085.00078.00078.00078.00080.00077.00030.00037.00046.00034.00025.00023.00079.00083.00084.00055.00034.00023.00024.00054.00089.00082.00078.00079.00080.00082.00082.00035.00046.00032.00040.00051.00041.00032.00037.0001991.0001921.0001902.000NoneNone1541.0001333.0001070.000NoneNoneNoneNoneNone176.000253.00097.000382.0002.0000.00072.000382.0001866.0000.0000.00016.00013.00023.00013.000147.000150.00023851.00011198.00070.00056.00054.00052.00049.00050.00046.00045.00041.00070.00091.000121.00094.00064.00067.00052.0001937.000393.0000.061796.000363.00087600.000112000.000137600.000716.000361.000124.00031.00015.000726.00055.00041.00059.00060.00043.00027.00020.00027.0000.00021.00072.00022.000432.000282.000514.000148.0000.0000.000511.000160.000360.0007.20032.00097.00038.00032.00037.00046.00049.00047.00034.00017.000609.0000.000405.000243.000160.000172.000127.00079.00054.0000.0000.00077.00019.00017.000147.000157.000171.000173.00085.000166.00091.000107.000103.000942.00034.00064.00041.00080.000278.000335.000155.00078.00027200.00034.00020.000930.000109.0000.000857.00020.000143.000359.000386.000109.000154.000216.000224.000450.000355.000463.000214.000445.00031.00068.00041.00019.00032.000105.00068.000266.0001013.00085.0001074.000579.0001000.0000.0001065.00017.000112.00081.000253.00084.00030.000139.00061.00058.000127.000139.00064.00040.000457.000118.000157.000258.000188.000457.000258.000127.000129.000134.000560.000128.000NoneNoneNone
\n", "
" ], "text/plain": [ " total_pop households male_pop female_pop \\\n", "avg 4384.716 1622.255 2157.711 2227.005 \n", "max 65528.000 21429.000 32266.000 33262.000 \n", "min 0.000 0.000 0.000 0.000 \n", "sum 324473370.000 120048527.000 159672750.000 164800620.000 \n", "range 65528.000 21429.000 32266.000 33262.000 \n", "stdev 2228.937 793.617 1120.561 1146.240 \n", "q1 2627.000 998.000 1276.000 1318.000 \n", "q3 4606.000 1714.000 2254.000 2334.000 \n", "median 3627.000 1357.000 1773.000 1842.000 \n", "interquartile_range 1979.000 716.000 978.000 1016.000 \n", "\n", " median_age male_under_5 male_5_to_9 male_10_to_14 \\\n", "avg 39.301 138.383 142.308 144.575 \n", "max 85.700 3297.000 3464.000 3137.000 \n", "min 7.700 0.000 0.000 0.000 \n", "sum 2879750.600 10240491.000 10530919.000 10698700.000 \n", "range 78.000 3297.000 3464.000 3137.000 \n", "stdev 7.751 110.491 112.164 113.200 \n", "q1 32.800 56.000 57.000 59.000 \n", "q3 41.100 138.000 142.000 145.000 \n", "median 37.100 94.000 98.000 99.000 \n", "interquartile_range 8.300 82.000 85.000 86.000 \n", "\n", " male_15_to_17 male_18_to_19 male_20 male_21 \\\n", "avg 88.048 60.372 32.765 32.174 \n", "max 2416.000 3909.000 2845.000 3025.000 \n", "min 0.000 0.000 0.000 0.000 \n", "sum 6515667.000 4467600.000 2424606.000 2380945.000 \n", "range 2416.000 3909.000 2845.000 3025.000 \n", "stdev 71.887 107.593 54.899 52.519 \n", "q1 32.000 14.000 0.000 0.000 \n", "q3 88.000 52.000 26.000 26.000 \n", "median 59.000 31.000 13.000 13.000 \n", "interquartile_range 56.000 38.000 26.000 26.000 \n", "\n", " male_22_to_24 male_25_to_29 male_30_to_34 \\\n", "avg 92.851 155.252 148.350 \n", "max 6083.000 3956.000 2143.000 \n", "min 0.000 0.000 0.000 \n", "sum 6871085.000 11488834.000 10978057.000 \n", "range 6083.000 3956.000 2143.000 \n", "stdev 94.760 125.158 115.504 \n", "q1 31.000 61.000 61.000 \n", "q3 87.000 151.000 146.000 \n", "median 56.000 103.000 101.000 \n", "interquartile_range 56.000 90.000 85.000 \n", "\n", " male_35_to_39 male_40_to_44 male_45_to_49 \\\n", "avg 138.830 137.546 141.625 \n", "max 3146.000 3718.000 2652.000 \n", "min 0.000 0.000 0.000 \n", "sum 10273584.000 10178564.000 10480362.000 \n", "range 3146.000 3718.000 2652.000 \n", "stdev 105.708 103.406 99.139 \n", "q1 60.000 60.000 66.000 \n", "q3 138.000 138.000 144.000 \n", "median 96.000 97.000 103.000 \n", "interquartile_range 78.000 78.000 78.000 \n", "\n", " male_50_to_54 male_55_to_59 male_65_to_66 \\\n", "avg 148.273 142.355 44.901 \n", "max 2300.000 1741.000 1244.000 \n", "min 0.000 0.000 0.000 \n", "sum 10972330.000 10534395.000 3322707.000 \n", "range 2300.000 1741.000 1244.000 \n", "stdev 95.758 87.386 36.859 \n", "q1 72.000 71.000 15.000 \n", "q3 152.000 148.000 45.000 \n", "median 111.000 108.000 29.000 \n", "interquartile_range 80.000 77.000 30.000 \n", "\n", " male_67_to_69 male_70_to_74 male_75_to_79 \\\n", "avg 57.965 73.062 50.088 \n", "max 3225.000 4708.000 3287.000 \n", "min 0.000 0.000 0.000 \n", "sum 4289470.000 5406639.000 3706536.000 \n", "range 3225.000 4708.000 3287.000 \n", "stdev 47.085 59.938 46.417 \n", "q1 22.000 28.000 16.000 \n", "q3 59.000 74.000 50.000 \n", "median 39.000 50.000 32.000 \n", "interquartile_range 37.000 46.000 34.000 \n", "\n", " male_80_to_84 male_85_and_over female_under_5 \\\n", "avg 33.343 28.863 132.231 \n", "max 1666.000 667.000 2829.000 \n", "min 0.000 0.000 0.000 \n", "sum 2467409.000 2135919.000 9785223.000 \n", "range 1666.000 667.000 2829.000 \n", "stdev 33.901 33.031 106.250 \n", "q1 8.000 4.000 53.000 \n", "q3 33.000 27.000 132.000 \n", "median 19.000 15.000 90.000 \n", "interquartile_range 25.000 23.000 79.000 \n", "\n", " female_5_to_9 female_10_to_14 female_15_to_17 \\\n", "avg 136.600 138.316 84.020 \n", "max 3509.000 3667.000 1601.000 \n", "min 0.000 0.000 0.000 \n", "sum 10108532.000 10235546.000 6217528.000 \n", "range 3509.000 3667.000 1601.000 \n", "stdev 109.686 110.042 69.231 \n", "q1 54.000 55.000 30.000 \n", "q3 137.000 139.000 85.000 \n", "median 94.000 94.000 56.000 \n", "interquartile_range 83.000 84.000 55.000 \n", "\n", " female_18_to_19 female_20 female_21 female_22_to_24 \\\n", "avg 57.567 30.890 30.419 88.340 \n", "max 4815.000 1586.000 1330.000 2045.000 \n", "min 0.000 0.000 0.000 0.000 \n", "sum 4259986.000 2285886.000 2251005.000 6537216.000 \n", "range 4815.000 1586.000 1330.000 2045.000 \n", "stdev 122.202 54.004 50.175 79.572 \n", "q1 12.000 0.000 0.000 30.000 \n", "q3 46.000 23.000 24.000 84.000 \n", "median 27.000 11.000 11.000 56.000 \n", "interquartile_range 34.000 23.000 24.000 54.000 \n", "\n", " female_25_to_29 female_30_to_34 female_35_to_39 \\\n", "avg 150.569 146.878 139.650 \n", "max 2410.000 2840.000 3450.000 \n", "min 0.000 0.000 0.000 \n", "sum 11142266.000 10869144.000 10334203.000 \n", "range 2410.000 2840.000 3450.000 \n", "stdev 118.100 109.718 104.010 \n", "q1 60.000 64.000 62.000 \n", "q3 149.000 146.000 140.000 \n", "median 102.000 102.000 100.000 \n", "interquartile_range 89.000 82.000 78.000 \n", "\n", " female_40_to_44 female_45_to_49 female_50_to_54 \\\n", "avg 139.306 144.672 153.890 \n", "max 3586.000 3628.000 1756.000 \n", "min 0.000 0.000 0.000 \n", "sum 10308819.000 10705845.000 11387986.000 \n", "range 3586.000 3628.000 1756.000 \n", "stdev 102.262 99.840 95.956 \n", "q1 62.000 68.000 77.000 \n", "q3 141.000 148.000 159.000 \n", "median 99.000 106.000 118.000 \n", "interquartile_range 79.000 80.000 82.000 \n", "\n", " female_55_to_59 female_60_to_61 female_62_to_64 \\\n", "avg 151.454 57.492 79.403 \n", "max 1445.000 873.000 2105.000 \n", "min 0.000 0.000 0.000 \n", "sum 11207768.000 4254466.000 5875871.000 \n", "range 1445.000 873.000 2105.000 \n", "stdev 90.648 42.795 55.337 \n", "q1 77.000 23.000 35.000 \n", "q3 159.000 58.000 81.000 \n", "median 117.000 40.000 58.000 \n", "interquartile_range 82.000 35.000 46.000 \n", "\n", " female_65_to_66 female_67_to_69 female_70_to_74 \\\n", "avg 49.830 65.202 85.536 \n", "max 2147.000 3661.000 5268.000 \n", "min 0.000 0.000 0.000 \n", "sum 3687460.000 4825029.000 6329715.000 \n", "range 2147.000 3661.000 5268.000 \n", "stdev 40.184 51.256 67.010 \n", "q1 18.000 26.000 36.000 \n", "q3 50.000 66.000 87.000 \n", "median 34.000 45.000 60.000 \n", "interquartile_range 32.000 40.000 51.000 \n", "\n", " female_75_to_79 female_80_to_84 female_85_and_over \\\n", "avg 62.539 47.082 55.122 \n", "max 2481.000 1166.000 1337.000 \n", "min 0.000 0.000 0.000 \n", "sum 4627940.000 3484080.000 4079106.000 \n", "range 2481.000 1166.000 1337.000 \n", "stdev 52.313 42.668 57.938 \n", "q1 22.000 14.000 14.000 \n", "q3 63.000 46.000 51.000 \n", "median 41.000 29.000 30.000 \n", "interquartile_range 41.000 32.000 37.000 \n", "\n", " white_pop population_1_year_and_over \\\n", "avg 2666.237 4342.539 \n", "max 38684.000 64803.000 \n", "min 0.000 0.000 \n", "sum 197304205.000 317248555.000 \n", "range 38684.000 64803.000 \n", "stdev 1907.504 2201.732 \n", "q1 951.000 2604.000 \n", "q3 2942.000 4525.000 \n", "median 1989.000 3590.000 \n", "interquartile_range 1991.000 1921.000 \n", "\n", " population_3_years_over pop_5_years_over pop_15_and_over \\\n", "avg 4225.816 None None \n", "max 62438.000 None None \n", "min 0.000 None None \n", "sum 312714581.000 None None \n", "range 62438.000 None None \n", "stdev 2139.467 None None \n", "q1 2519.000 None None \n", "q3 4421.000 None None \n", "median 3499.000 None None \n", "interquartile_range 1902.000 None None \n", "\n", " pop_16_over pop_25_years_over pop_25_64 \\\n", "avg 3495.006 2954.858 2301.326 \n", "max 44642.000 39486.000 34258.000 \n", "min 0.000 0.000 0.000 \n", "sum 258633976.000 218662435.000 170300425.000 \n", "range 44642.000 39486.000 34258.000 \n", "stdev 1719.905 1474.748 1216.138 \n", "q1 2125.000 1782.000 1328.000 \n", "q3 3666.000 3115.000 2398.000 \n", "median 2921.000 2453.000 1880.000 \n", "interquartile_range 1541.000 1333.000 1070.000 \n", "\n", " pop_never_married pop_now_married pop_separated \\\n", "avg None None None \n", "max None None None \n", "min None None None \n", "sum None None None \n", "range None None None \n", "stdev None None None \n", "q1 None None None \n", "q3 None None None \n", "median None None None \n", "interquartile_range None None None \n", "\n", " pop_widowed pop_divorced not_us_citizen_pop black_pop \\\n", "avg None None 305.762 533.077 \n", "max None None 12232.000 16655.000 \n", "min None None 0.000 0.000 \n", "sum None None 22337765.000 39448215.000 \n", "range None None 12232.000 16655.000 \n", "stdev None None 453.551 909.323 \n", "q1 None None 22.000 16.000 \n", "q3 None None 198.000 269.000 \n", "median None None 82.000 82.000 \n", "interquartile_range None None 176.000 253.000 \n", "\n", " asian_pop hispanic_pop amerindian_pop \\\n", "avg 229.615 810.032 28.362 \n", "max 13712.000 28683.000 9644.000 \n", "min 0.000 0.000 0.000 \n", "sum 16991765.000 59943182.000 2098847.000 \n", "range 13712.000 28683.000 9644.000 \n", "stdev 503.608 1282.778 178.956 \n", "q1 0.000 66.000 0.000 \n", "q3 97.000 448.000 2.000 \n", "median 28.000 187.000 0.000 \n", "interquartile_range 97.000 382.000 2.000 \n", "\n", " other_race_pop two_or_more_races_pop hispanic_any_race \\\n", "avg 9.694 100.731 810.032 \n", "max 1385.000 3611.000 28683.000 \n", "min 0.000 0.000 0.000 \n", "sum 717393.000 7454186.000 59943182.000 \n", "range 1385.000 3611.000 28683.000 \n", "stdev 34.688 127.044 1282.778 \n", "q1 0.000 16.000 66.000 \n", "q3 0.000 88.000 448.000 \n", "median 0.000 47.000 187.000 \n", "interquartile_range 0.000 72.000 382.000 \n", "\n", " not_hispanic_pop asian_male_45_54 asian_male_55_64 \\\n", "avg 3574.684 14.916 11.694 \n", "max 50477.000 1301.000 745.000 \n", "min 0.000 0.000 0.000 \n", "sum 264530188.000 1103826.000 865352.000 \n", "range 50477.000 1301.000 745.000 \n", "stdev 2056.417 39.752 31.828 \n", "q1 1943.000 0.000 0.000 \n", "q3 3809.000 0.000 0.000 \n", "median 2906.000 0.000 0.000 \n", "interquartile_range 1866.000 0.000 0.000 \n", "\n", " black_male_45_54 black_male_55_64 hispanic_male_45_54 \\\n", "avg 34.401 29.042 47.007 \n", "max 1094.000 1122.000 1464.000 \n", "min 0.000 0.000 0.000 \n", "sum 2545740.000 2149154.000 3478537.000 \n", "range 1094.000 1122.000 1464.000 \n", "stdev 63.033 53.957 83.689 \n", "q1 0.000 0.000 0.000 \n", "q3 16.000 13.000 23.000 \n", "median 0.000 0.000 5.000 \n", "interquartile_range 16.000 13.000 23.000 \n", "\n", " hispanic_male_55_64 white_male_45_54 white_male_55_64 \\\n", "avg 30.485 188.315 192.633 \n", "max 777.000 2189.000 2545.000 \n", "min 0.000 0.000 0.000 \n", "sum 2255952.000 13935498.000 14255050.000 \n", "range 777.000 2189.000 2545.000 \n", "stdev 58.783 152.387 145.516 \n", "q1 0.000 53.000 60.000 \n", "q3 13.000 200.000 210.000 \n", "median 0.000 127.000 135.000 \n", "interquartile_range 13.000 147.000 150.000 \n", "\n", " median_income income_per_capita income_less_10000 \\\n", "avg 61206.505 30651.804 112.029 \n", "max 250001.000 220253.000 1550.000 \n", "min 2499.000 32.000 0.000 \n", "sum 4464586091.000 2245428568.000 8290228.000 \n", "range 247502.000 220221.000 1550.000 \n", "stdev 30901.058 16126.937 106.300 \n", "q1 36974.000 19023.000 34.000 \n", "q3 60825.000 30221.000 104.000 \n", "median 48811.000 24552.000 64.000 \n", "interquartile_range 23851.000 11198.000 70.000 \n", "\n", " income_10000_14999 income_15000_19999 \\\n", "avg 79.903 79.066 \n", "max 930.000 761.000 \n", "min 0.000 0.000 \n", "sum 5912909.000 5850945.000 \n", "range 930.000 761.000 \n", "stdev 69.849 63.590 \n", "q1 23.000 26.000 \n", "q3 79.000 80.000 \n", "median 48.000 51.000 \n", "interquartile_range 56.000 54.000 \n", "\n", " income_20000_24999 income_25000_29999 \\\n", "avg 81.211 76.990 \n", "max 1009.000 876.000 \n", "min 0.000 0.000 \n", "sum 6009672.000 5697363.000 \n", "range 1009.000 876.000 \n", "stdev 62.059 58.300 \n", "q1 30.000 29.000 \n", "q3 82.000 78.000 \n", "median 55.000 52.000 \n", "interquartile_range 52.000 49.000 \n", "\n", " income_30000_34999 income_35000_39999 \\\n", "avg 78.111 72.823 \n", "max 864.000 1530.000 \n", "min 0.000 0.000 \n", "sum 5780308.000 5388955.000 \n", "range 864.000 1530.000 \n", "stdev 58.626 55.053 \n", "q1 30.000 28.000 \n", "q3 80.000 74.000 \n", "median 53.000 49.000 \n", "interquartile_range 50.000 46.000 \n", "\n", " income_40000_44999 income_45000_49999 \\\n", "avg 72.989 64.370 \n", "max 1118.000 861.000 \n", "min 0.000 0.000 \n", "sum 5401277.000 4763457.000 \n", "range 1118.000 861.000 \n", "stdev 54.989 49.507 \n", "q1 29.000 24.000 \n", "q3 74.000 65.000 \n", "median 50.000 44.000 \n", "interquartile_range 45.000 41.000 \n", "\n", " income_50000_59999 income_60000_74999 \\\n", "avg 124.887 160.500 \n", "max 2054.000 2789.000 \n", "min 0.000 0.000 \n", "sum 9241728.000 11877176.000 \n", "range 2054.000 2789.000 \n", "stdev 84.174 105.981 \n", "q1 58.000 76.000 \n", "q3 128.000 167.000 \n", "median 92.000 120.000 \n", "interquartile_range 70.000 91.000 \n", "\n", " income_75000_99999 income_100000_124999 \\\n", "avg 198.418 139.128 \n", "max 3368.000 2704.000 \n", "min 0.000 0.000 \n", "sum 14683147.000 10295604.000 \n", "range 3368.000 2704.000 \n", "stdev 137.296 114.717 \n", "q1 86.000 47.000 \n", "q3 207.000 141.000 \n", "median 145.000 92.000 \n", "interquartile_range 121.000 94.000 \n", "\n", " income_125000_149999 income_150000_199999 \\\n", "avg 87.014 93.800 \n", "max 2157.000 3878.000 \n", "min 0.000 0.000 \n", "sum 6439142.000 6941320.000 \n", "range 2157.000 3878.000 \n", "stdev 85.138 107.818 \n", "q1 19.000 14.000 \n", "q3 83.000 81.000 \n", "median 48.000 40.000 \n", "interquartile_range 64.000 67.000 \n", "\n", " income_200000_or_more pop_determined_poverty_status \\\n", "avg 101.016 4276.775 \n", "max 5386.000 65332.000 \n", "min 0.000 0.000 \n", "sum 7475296.000 316485642.000 \n", "range 5386.000 65332.000 \n", "stdev 164.783 2216.522 \n", "q1 8.000 2559.000 \n", "q3 60.000 4496.000 \n", "median 26.000 3523.000 \n", "interquartile_range 52.000 1937.000 \n", "\n", " poverty gini_index housing_units \\\n", "avg 637.742 0.426 1850.797 \n", "max 9440.000 0.829 26526.000 \n", "min 0.000 0.001 0.000 \n", "sum 47193565.000 31111.100 136960864.000 \n", "range 9440.000 0.828 26526.000 \n", "stdev 561.814 0.064 895.836 \n", "q1 212.000 0.374 1153.000 \n", "q3 605.000 0.435 1949.000 \n", "median 383.000 0.405 1547.000 \n", "interquartile_range 393.000 0.061 796.000 \n", "\n", " renter_occupied_housing_units_paying_cash_median_gross_rent \\\n", "avg 1058.678 \n", "max 3501.000 \n", "min 99.000 \n", "sum 76128487.000 \n", "range 3402.000 \n", "stdev 464.256 \n", "q1 692.000 \n", "q3 1055.000 \n", "median 851.000 \n", "interquartile_range 363.000 \n", "\n", " owner_occupied_housing_units_lower_value_quartile \\\n", "avg 176568.474 \n", "max 2000001.000 \n", "min 9999.000 \n", "sum 12589332219.000 \n", "range 1990002.000 \n", "stdev 164802.630 \n", "q1 65700.000 \n", "q3 153300.000 \n", "median 101100.000 \n", "interquartile_range 87600.000 \n", "\n", " owner_occupied_housing_units_median_value \\\n", "avg 244327.960 \n", "max 2000001.000 \n", "min 9999.000 \n", "sum 17587459517.000 \n", "range 1990002.000 \n", "stdev 218956.686 \n", "q1 98800.000 \n", "q3 210800.000 \n", "median 147900.000 \n", "interquartile_range 112000.000 \n", "\n", " owner_occupied_housing_units_upper_value_quartile \\\n", "avg 332960.368 \n", "max 2000001.000 \n", "min 9999.000 \n", "sum 23968817977.000 \n", "range 1990002.000 \n", "stdev 286614.050 \n", "q1 149100.000 \n", "q3 286700.000 \n", "median 203100.000 \n", "interquartile_range 137600.000 \n", "\n", " occupied_housing_units housing_units_renter_occupied \\\n", "avg 1622.255 586.179 \n", "max 21429.000 8039.000 \n", "min 0.000 0.000 \n", "sum 120048527.000 43377863.000 \n", "range 21429.000 8039.000 \n", "stdev 793.617 479.149 \n", "q1 998.000 209.000 \n", "q3 1714.000 570.000 \n", "median 1357.000 374.000 \n", "interquartile_range 716.000 361.000 \n", "\n", " vacant_housing_units vacant_housing_units_for_rent \\\n", "avg 228.542 38.847 \n", "max 11924.000 4472.000 \n", "min 0.000 0.000 \n", "sum 16912337.000 2874708.000 \n", "range 11924.000 4472.000 \n", "stdev 313.122 67.020 \n", "q1 64.000 0.000 \n", "q3 188.000 31.000 \n", "median 120.000 10.000 \n", "interquartile_range 124.000 31.000 \n", "\n", " vacant_housing_units_for_sale \\\n", "avg 18.632 \n", "max 547.000 \n", "min 0.000 \n", "sum 1378777.000 \n", "range 547.000 \n", "stdev 28.307 \n", "q1 0.000 \n", "q3 15.000 \n", "median 0.000 \n", "interquartile_range 15.000 \n", "\n", " dwellings_1_units_detached dwellings_1_units_attached \\\n", "avg 1143.346 109.266 \n", "max 25527.000 4280.000 \n", "min 0.000 0.000 \n", "sum 84608778.000 8085807.000 \n", "range 25527.000 4280.000 \n", "stdev 754.309 195.291 \n", "q1 522.000 7.000 \n", "q3 1248.000 62.000 \n", "median 915.000 26.000 \n", "interquartile_range 726.000 55.000 \n", "\n", " dwellings_2_units dwellings_3_to_4_units \\\n", "avg 67.630 81.129 \n", "max 1999.000 1629.000 \n", "min 0.000 0.000 \n", "sum 5004687.000 6003655.000 \n", "range 1999.000 1629.000 \n", "stdev 113.359 116.582 \n", "q1 0.000 0.000 \n", "q3 41.000 59.000 \n", "median 15.000 23.000 \n", "interquartile_range 41.000 59.000 \n", "\n", " dwellings_5_to_9_units dwellings_10_to_19_units \\\n", "avg 87.975 82.481 \n", "max 1863.000 5280.000 \n", "min 0.000 0.000 \n", "sum 6510210.000 6103648.000 \n", "range 1863.000 5280.000 \n", "stdev 132.416 151.111 \n", "q1 0.000 0.000 \n", "q3 60.000 43.000 \n", "median 19.000 9.000 \n", "interquartile_range 60.000 43.000 \n", "\n", " dwellings_20_to_49_units dwellings_50_or_more_units \\\n", "avg 65.918 96.432 \n", "max 4283.000 11518.000 \n", "min 0.000 0.000 \n", "sum 4877964.000 7136049.000 \n", "range 4283.000 11518.000 \n", "stdev 144.087 299.168 \n", "q1 0.000 0.000 \n", "q3 27.000 20.000 \n", "median 0.000 0.000 \n", "interquartile_range 27.000 20.000 \n", "\n", " mobile_homes housing_built_2005_or_later \\\n", "avg 115.067 16.103 \n", "max 3314.000 2502.000 \n", "min 0.000 0.000 \n", "sum 8515077.000 1191642.000 \n", "range 3314.000 2502.000 \n", "stdev 225.078 47.328 \n", "q1 0.000 0.000 \n", "q3 27.000 0.000 \n", "median 0.000 0.000 \n", "interquartile_range 27.000 0.000 \n", "\n", " housing_built_2000_to_2004 \\\n", "avg 42.215 \n", "max 7206.000 \n", "min 0.000 \n", "sum 3123981.000 \n", "range 7206.000 \n", "stdev 103.868 \n", "q1 0.000 \n", "q3 21.000 \n", "median 4.000 \n", "interquartile_range 21.000 \n", "\n", " housing_built_1939_or_earlier \\\n", "avg 94.030 \n", "max 6177.000 \n", "min 0.000 \n", "sum 6958328.000 \n", "range 6177.000 \n", "stdev 116.601 \n", "q1 9.000 \n", "q3 81.000 \n", "median 40.000 \n", "interquartile_range 72.000 \n", "\n", " median_year_structure_built married_households \\\n", "avg 1971.950 782.945 \n", "max 2016.000 15105.000 \n", "min 1939.000 0.000 \n", "sum 142948661.000 57938689.000 \n", "range 77.000 15105.000 \n", "stdev 17.553 505.011 \n", "q1 1956.000 381.000 \n", "q3 1978.000 813.000 \n", "median 1969.000 599.000 \n", "interquartile_range 22.000 432.000 \n", "\n", " nonfamily_households family_households \\\n", "avg 552.684 1069.572 \n", "max 6883.000 16813.000 \n", "min 0.000 0.000 \n", "sum 40899159.000 79149368.000 \n", "range 6883.000 16813.000 \n", "stdev 363.756 585.972 \n", "q1 273.000 612.000 \n", "q3 555.000 1126.000 \n", "median 409.000 870.000 \n", "interquartile_range 282.000 514.000 \n", "\n", " households_public_asst_or_food_stamps \\\n", "avg 220.147 \n", "max 2325.000 \n", "min 0.000 \n", "sum 16291126.000 \n", "range 2325.000 \n", "stdev 196.613 \n", "q1 62.000 \n", "q3 210.000 \n", "median 129.000 \n", "interquartile_range 148.000 \n", "\n", " male_male_households female_female_households \\\n", "avg 2.848 2.910 \n", "max 355.000 174.000 \n", "min 0.000 0.000 \n", "sum 210721.000 215333.000 \n", "range 355.000 174.000 \n", "stdev 8.899 7.653 \n", "q1 0.000 0.000 \n", "q3 0.000 0.000 \n", "median 0.000 0.000 \n", "interquartile_range 0.000 0.000 \n", "\n", " children children_in_single_female_hh median_rent \\\n", "avg 1004.481 254.948 896.061 \n", "max 23608.000 2863.000 3501.000 \n", "min 0.000 0.000 99.000 \n", "sum 74332606.000 18866414.000 64273567.000 \n", "range 23608.000 2863.000 3402.000 \n", "stdev 676.013 240.274 458.720 \n", "q1 508.000 73.000 529.000 \n", "q3 1019.000 233.000 889.000 \n", "median 765.000 144.000 691.000 \n", "interquartile_range 511.000 160.000 360.000 \n", "\n", " percent_income_spent_on_rent rent_burden_not_computed \\\n", "avg 30.757 45.496 \n", "max 50.000 1100.000 \n", "min 10.000 0.000 \n", "sum 2225701.700 3366768.000 \n", "range 40.000 1100.000 \n", "stdev 7.795 49.744 \n", "q1 24.200 9.000 \n", "q3 31.400 41.000 \n", "median 28.100 24.000 \n", "interquartile_range 7.200 32.000 \n", "\n", " rent_over_50_percent rent_40_to_50_percent \\\n", "avg 138.332 49.808 \n", "max 3487.000 972.000 \n", "min 0.000 0.000 \n", "sum 10236720.000 3685848.000 \n", "range 3487.000 972.000 \n", "stdev 143.299 55.747 \n", "q1 29.000 7.000 \n", "q3 126.000 45.000 \n", "median 70.000 22.000 \n", "interquartile_range 97.000 38.000 \n", "\n", " rent_35_to_40_percent rent_30_to_35_percent \\\n", "avg 36.222 49.367 \n", "max 641.000 860.000 \n", "min 0.000 0.000 \n", "sum 2680486.000 3653236.000 \n", "range 641.000 860.000 \n", "stdev 43.031 55.987 \n", "q1 0.000 7.000 \n", "q3 32.000 44.000 \n", "median 15.000 22.000 \n", "interquartile_range 32.000 37.000 \n", "\n", " rent_25_to_30_percent rent_20_to_25_percent \\\n", "avg 62.232 68.746 \n", "max 999.000 1382.000 \n", "min 0.000 0.000 \n", "sum 4605232.000 5087309.000 \n", "range 999.000 1382.000 \n", "stdev 66.949 72.524 \n", "q1 11.000 14.000 \n", "q3 57.000 63.000 \n", "median 30.000 35.000 \n", "interquartile_range 46.000 49.000 \n", "\n", " rent_15_to_20_percent rent_10_to_15_percent \\\n", "avg 67.926 46.913 \n", "max 1879.000 1098.000 \n", "min 0.000 0.000 \n", "sum 5026567.000 3471635.000 \n", "range 1879.000 1098.000 \n", "stdev 72.061 53.122 \n", "q1 15.000 8.000 \n", "q3 62.000 42.000 \n", "median 35.000 23.000 \n", "interquartile_range 47.000 34.000 \n", "\n", " rent_under_10_percent owner_occupied_housing_units \\\n", "avg 21.136 1036.076 \n", "max 912.000 20473.000 \n", "min 0.000 0.000 \n", "sum 1564062.000 76670664.000 \n", "range 912.000 20473.000 \n", "stdev 31.293 654.343 \n", "q1 0.000 496.000 \n", "q3 17.000 1105.000 \n", "median 7.000 812.000 \n", "interquartile_range 17.000 609.000 \n", "\n", " million_dollar_housing_units mortgaged_housing_units \\\n", "avg 14.981 655.655 \n", "max 1453.000 12672.000 \n", "min 0.000 0.000 \n", "sum 1108620.000 48519146.000 \n", "range 1453.000 12672.000 \n", "stdev 55.371 479.093 \n", "q1 0.000 274.000 \n", "q3 0.000 679.000 \n", "median 0.000 472.000 \n", "interquartile_range 0.000 405.000 \n", "\n", " different_house_year_ago_different_city \\\n", "avg 411.542 \n", "max 13064.000 \n", "min 0.000 \n", "sum 30065590.000 \n", "range 13064.000 \n", "stdev 393.284 \n", "q1 140.000 \n", "q3 383.000 \n", "median 251.000 \n", "interquartile_range 243.000 \n", "\n", " different_house_year_ago_same_city \\\n", "avg 195.111 \n", "max 5347.000 \n", "min 0.000 \n", "sum 14253996.000 \n", "range 5347.000 \n", "stdev 249.243 \n", "q1 6.000 \n", "q3 166.000 \n", "median 67.000 \n", "interquartile_range 160.000 \n", "\n", " families_with_young_children \\\n", "avg 312.742 \n", "max 6700.000 \n", "min 0.000 \n", "sum 23143255.000 \n", "range 6700.000 \n", "stdev 231.674 \n", "q1 141.000 \n", "q3 313.000 \n", "median 223.000 \n", "interquartile_range 172.000 \n", "\n", " two_parent_families_with_young_children \\\n", "avg 201.810 \n", "max 6517.000 \n", "min 0.000 \n", "sum 14934156.000 \n", "range 6517.000 \n", "stdev 182.928 \n", "q1 70.000 \n", "q3 197.000 \n", "median 130.000 \n", "interquartile_range 127.000 \n", "\n", " two_parents_in_labor_force_families_with_young_children \\\n", "avg 118.298 \n", "max 3989.000 \n", "min 0.000 \n", "sum 8754150.000 \n", "range 3989.000 \n", "stdev 114.817 \n", "q1 34.000 \n", "q3 113.000 \n", "median 71.000 \n", "interquartile_range 79.000 \n", "\n", " two_parents_father_in_labor_force_families_with_young_children \\\n", "avg 74.180 \n", "max 3888.000 \n", "min 0.000 \n", "sum 5489360.000 \n", "range 3888.000 \n", "stdev 90.506 \n", "q1 12.000 \n", "q3 66.000 \n", "median 35.000 \n", "interquartile_range 54.000 \n", "\n", " two_parents_mother_in_labor_force_families_with_young_children \\\n", "avg 6.341 \n", "max 1308.000 \n", "min 0.000 \n", "sum 469236.000 \n", "range 1308.000 \n", "stdev 18.145 \n", "q1 0.000 \n", "q3 0.000 \n", "median 0.000 \n", "interquartile_range 0.000 \n", "\n", " two_parents_not_in_labor_force_families_with_young_children \\\n", "avg 2.992 \n", "max 285.000 \n", "min 0.000 \n", "sum 221410.000 \n", "range 285.000 \n", "stdev 11.524 \n", "q1 0.000 \n", "q3 0.000 \n", "median 0.000 \n", "interquartile_range 0.000 \n", "\n", " one_parent_families_with_young_children \\\n", "avg 110.932 \n", "max 1418.000 \n", "min 0.000 \n", "sum 8209099.000 \n", "range 1418.000 \n", "stdev 114.155 \n", "q1 23.000 \n", "q3 100.000 \n", "median 57.000 \n", "interquartile_range 77.000 \n", "\n", " father_one_parent_families_with_young_children \\\n", "avg 25.601 \n", "max 502.000 \n", "min 0.000 \n", "sum 1894468.000 \n", "range 502.000 \n", "stdev 37.744 \n", "q1 0.000 \n", "q3 19.000 \n", "median 5.000 \n", "interquartile_range 19.000 \n", "\n", " father_in_labor_force_one_parent_families_with_young_children \\\n", "avg 22.815 \n", "max 502.000 \n", "min 0.000 \n", "sum 1688343.000 \n", "range 502.000 \n", "stdev 35.345 \n", "q1 0.000 \n", "q3 17.000 \n", "median 0.000 \n", "interquartile_range 17.000 \n", "\n", " commute_less_10_mins commute_10_14_mins \\\n", "avg 243.340 261.580 \n", "max 11621.000 5838.000 \n", "min 0.000 0.000 \n", "sum 18007425.000 19357159.000 \n", "range 11621.000 5838.000 \n", "stdev 225.753 196.725 \n", "q1 84.000 104.000 \n", "q3 231.000 261.000 \n", "median 150.000 180.000 \n", "interquartile_range 147.000 157.000 \n", "\n", " commute_15_19_mins commute_20_24_mins \\\n", "avg 294.358 280.068 \n", "max 7095.000 4886.000 \n", "min 0.000 0.000 \n", "sum 21782820.000 20725344.000 \n", "range 7095.000 4886.000 \n", "stdev 213.210 208.958 \n", "q1 126.000 110.000 \n", "q3 297.000 283.000 \n", "median 207.000 193.000 \n", "interquartile_range 171.000 173.000 \n", "\n", " commute_25_29_mins commute_30_34_mins \\\n", "avg 122.279 263.641 \n", "max 2205.000 4880.000 \n", "min 0.000 0.000 \n", "sum 9048793.000 19509679.000 \n", "range 2205.000 4880.000 \n", "stdev 110.217 215.589 \n", "q1 36.000 95.000 \n", "q3 121.000 261.000 \n", "median 74.000 174.000 \n", "interquartile_range 85.000 166.000 \n", "\n", " commute_35_44_mins commute_45_59_mins \\\n", "avg 131.140 156.067 \n", "max 3178.000 5390.000 \n", "min 0.000 0.000 \n", "sum 9704493.000 11549099.000 \n", "range 3178.000 5390.000 \n", "stdev 129.281 160.217 \n", "q1 33.000 38.000 \n", "q3 124.000 145.000 \n", "median 73.000 82.000 \n", "interquartile_range 91.000 107.000 \n", "\n", " commute_60_more_mins commuters_16_over walked_to_work \\\n", "avg 171.718 1924.192 55.157 \n", "max 6070.000 26482.000 11621.000 \n", "min 0.000 0.000 0.000 \n", "sum 12707300.000 142392112.000 4081654.000 \n", "range 6070.000 26482.000 11621.000 \n", "stdev 190.405 1072.317 140.448 \n", "q1 42.000 1072.000 0.000 \n", "q3 145.000 2014.000 34.000 \n", "median 84.000 1548.000 16.000 \n", "interquartile_range 103.000 942.000 34.000 \n", "\n", " worked_at_home no_car no_cars one_car \\\n", "avg 95.262 87.285 144.230 540.504 \n", "max 7043.000 8111.000 5847.000 15548.000 \n", "min 0.000 0.000 0.000 0.000 \n", "sum 7049498.000 6459181.000 10673160.000 39997864.000 \n", "range 7043.000 8111.000 5847.000 15548.000 \n", "stdev 104.734 231.521 229.842 331.457 \n", "q1 23.000 7.000 29.000 278.000 \n", "q3 87.000 48.000 109.000 556.000 \n", "median 52.000 23.000 62.000 411.000 \n", "interquartile_range 64.000 41.000 80.000 278.000 \n", "\n", " two_cars three_cars four_more_cars \\\n", "avg 604.804 229.571 103.146 \n", "max 12012.000 3231.000 1107.000 \n", "min 0.000 0.000 0.000 \n", "sum 44756070.000 16988505.000 7632928.000 \n", "range 12012.000 3231.000 1107.000 \n", "stdev 379.998 171.130 94.484 \n", "q1 301.000 85.000 24.000 \n", "q3 636.000 240.000 102.000 \n", "median 471.000 162.000 60.000 \n", "interquartile_range 335.000 155.000 78.000 \n", "\n", " aggregate_travel_time_to_work \\\n", "avg 59341.504 \n", "max 973160.000 \n", "min 65.000 \n", "sum 2970754365.000 \n", "range 973095.000 \n", "stdev 34229.680 \n", "q1 33150.000 \n", "q3 60350.000 \n", "median 45995.000 \n", "interquartile_range 27200.000 \n", "\n", " commuters_by_public_transportation commuters_by_bus \\\n", "avg 103.101 51.148 \n", "max 7759.000 3940.000 \n", "min 0.000 0.000 \n", "sum 7629599.000 3785002.000 \n", "range 7759.000 3940.000 \n", "stdev 264.763 108.631 \n", "q1 0.000 0.000 \n", "q3 34.000 20.000 \n", "median 8.000 2.000 \n", "interquartile_range 34.000 20.000 \n", "\n", " commuters_by_car_truck_van commuters_by_carpool \\\n", "avg 1729.272 184.784 \n", "max 25012.000 3023.000 \n", "min 0.000 0.000 \n", "sum 127967857.000 13674224.000 \n", "range 25012.000 3023.000 \n", "stdev 1041.140 144.773 \n", "q1 894.000 74.000 \n", "q3 1824.000 183.000 \n", "median 1362.000 124.000 \n", "interquartile_range 930.000 109.000 \n", "\n", " commuters_by_subway_or_elevated commuters_drove_alone \\\n", "avg 38.183 1544.488 \n", "max 5945.000 21989.000 \n", "min 0.000 0.000 \n", "sum 2825557.000 114293633.000 \n", "range 5945.000 21989.000 \n", "stdev 196.741 947.467 \n", "q1 0.000 780.000 \n", "q3 0.000 1637.000 \n", "median 0.000 1211.000 \n", "interquartile_range 0.000 857.000 \n", "\n", " group_quarters associates_degree bachelors_degree \\\n", "avg 109.820 245.286 564.903 \n", "max 16421.000 4070.000 13767.000 \n", "min 0.000 0.000 0.000 \n", "sum 8126758.000 18151427.000 41803378.000 \n", "range 16421.000 4070.000 13767.000 \n", "stdev 444.664 169.441 482.882 \n", "q1 0.000 109.000 191.000 \n", "q3 20.000 252.000 550.000 \n", "median 5.000 178.000 342.000 \n", "interquartile_range 20.000 143.000 359.000 \n", "\n", " high_school_diploma less_one_year_college \\\n", "avg 690.444 182.175 \n", "max 8215.000 4037.000 \n", "min 0.000 0.000 \n", "sum 51093567.000 13481107.000 \n", "range 8215.000 4037.000 \n", "stdev 409.367 126.778 \n", "q1 342.000 80.000 \n", "q3 728.000 189.000 \n", "median 534.000 132.000 \n", "interquartile_range 386.000 109.000 \n", "\n", " masters_degree one_year_more_college \\\n", "avg 246.894 429.059 \n", "max 7767.000 5621.000 \n", "min 0.000 0.000 \n", "sum 18270373.000 31750818.000 \n", "range 7767.000 5621.000 \n", "stdev 255.769 262.970 \n", "q1 62.000 222.000 \n", "q3 216.000 438.000 \n", "median 126.000 325.000 \n", "interquartile_range 154.000 216.000 \n", "\n", " less_than_high_school_graduate \\\n", "avg 375.563 \n", "max 5363.000 \n", "min 0.000 \n", "sum 27437114.000 \n", "range 5363.000 \n", "stdev 354.004 \n", "q1 115.000 \n", "q3 339.000 \n", "median 214.000 \n", "interquartile_range 224.000 \n", "\n", " high_school_including_ged bachelors_degree_2 \\\n", "avg 808.881 566.375 \n", "max 8929.000 13767.000 \n", "min 0.000 0.000 \n", "sum 59093612.000 41377068.000 \n", "range 8929.000 13767.000 \n", "stdev 479.144 484.280 \n", "q1 400.000 192.000 \n", "q3 850.000 547.000 \n", "median 630.000 345.000 \n", "interquartile_range 450.000 355.000 \n", "\n", " bachelors_degree_or_higher_25_64 \\\n", "avg 743.548 \n", "max 22856.000 \n", "min 0.000 \n", "sum 55023314.000 \n", "range 22856.000 \n", "stdev 706.282 \n", "q1 220.000 \n", "q3 683.000 \n", "median 408.000 \n", "interquartile_range 463.000 \n", "\n", " graduate_professional_degree \\\n", "avg 349.192 \n", "max 10374.000 \n", "min 0.000 \n", "sum 25510535.000 \n", "range 10374.000 \n", "stdev 380.169 \n", "q1 81.000 \n", "q3 295.000 \n", "median 165.000 \n", "interquartile_range 214.000 \n", "\n", " some_college_and_associates_degree \\\n", "avg 860.344 \n", "max 12745.000 \n", "min 0.000 \n", "sum 62853315.000 \n", "range 12745.000 \n", "stdev 506.211 \n", "q1 457.000 \n", "q3 902.000 \n", "median 672.000 \n", "interquartile_range 445.000 \n", "\n", " male_45_64_associates_degree \\\n", "avg 43.028 \n", "max 855.000 \n", "min 0.000 \n", "sum 3184139.000 \n", "range 855.000 \n", "stdev 40.479 \n", "q1 11.000 \n", "q3 42.000 \n", "median 25.000 \n", "interquartile_range 31.000 \n", "\n", " male_45_64_bachelors_degree male_45_64_graduate_degree \\\n", "avg 100.065 64.985 \n", "max 2547.000 2448.000 \n", "min 0.000 0.000 \n", "sum 7404907.000 4808988.000 \n", "range 2547.000 2448.000 \n", "stdev 100.991 86.981 \n", "q1 24.000 8.000 \n", "q3 92.000 49.000 \n", "median 52.000 24.000 \n", "interquartile_range 68.000 41.000 \n", "\n", " male_45_64_less_than_9_grade male_45_64_grade_9_12 \\\n", "avg 30.097 42.240 \n", "max 900.000 1626.000 \n", "min 0.000 0.000 \n", "sum 2227181.000 3125781.000 \n", "range 900.000 1626.000 \n", "stdev 49.654 45.710 \n", "q1 0.000 7.000 \n", "q3 19.000 39.000 \n", "median 6.000 21.000 \n", "interquartile_range 19.000 32.000 \n", "\n", " male_45_64_high_school male_45_64_some_college \\\n", "avg 164.811 112.808 \n", "max 2084.000 1628.000 \n", "min 0.000 0.000 \n", "sum 12196143.000 8347879.000 \n", "range 2084.000 1628.000 \n", "stdev 115.910 81.153 \n", "q1 67.000 47.000 \n", "q3 172.000 115.000 \n", "median 118.000 79.000 \n", "interquartile_range 105.000 68.000 \n", "\n", " male_45_to_64 employed_pop unemployed_pop \\\n", "avg 558.033 2049.152 145.686 \n", "max 6993.000 28945.000 1607.000 \n", "min 0.000 0.000 0.000 \n", "sum 41295018.000 151639301.000 10780902.000 \n", "range 6993.000 28945.000 1607.000 \n", "stdev 303.356 1138.865 109.220 \n", "q1 316.000 1143.000 60.000 \n", "q3 582.000 2156.000 145.000 \n", "median 450.000 1651.000 100.000 \n", "interquartile_range 266.000 1013.000 85.000 \n", "\n", " pop_in_labor_force not_in_labor_force \\\n", "avg 2208.707 1286.299 \n", "max 30552.000 34142.000 \n", "min 0.000 0.000 \n", "sum 163446545.000 95187431.000 \n", "range 30552.000 34142.000 \n", "stdev 1203.354 715.005 \n", "q1 1245.000 746.000 \n", "q3 2319.000 1325.000 \n", "median 1793.000 1026.000 \n", "interquartile_range 1074.000 579.000 \n", "\n", " workers_16_and_over armed_forces civilian_labor_force \\\n", "avg 2019.454 13.869 2194.838 \n", "max 28252.000 21214.000 30552.000 \n", "min 0.000 0.000 0.000 \n", "sum 149441610.000 1026342.000 162420203.000 \n", "range 28252.000 21214.000 30552.000 \n", "stdev 1129.133 161.617 1192.208 \n", "q1 1115.000 0.000 1235.000 \n", "q3 2115.000 0.000 2300.000 \n", "median 1622.000 0.000 1780.000 \n", "interquartile_range 1000.000 0.000 1065.000 \n", "\n", " employed_agriculture_forestry_fishing_hunting_mining \\\n", "avg 38.275 \n", "max 4197.000 \n", "min 0.000 \n", "sum 2832376.000 \n", "range 4197.000 \n", "stdev 88.749 \n", "q1 0.000 \n", "q3 17.000 \n", "median 0.000 \n", "interquartile_range 17.000 \n", "\n", " employed_arts_entertainment_recreation_accommodation_food \\\n", "avg 198.444 \n", "max 5211.000 \n", "min 0.000 \n", "sum 14685032.000 \n", "range 5211.000 \n", "stdev 160.030 \n", "q1 82.000 \n", "q3 194.000 \n", "median 133.000 \n", "interquartile_range 112.000 \n", "\n", " employed_construction employed_education_health_social \\\n", "avg 129.972 473.374 \n", "max 1950.000 9127.000 \n", "min 0.000 0.000 \n", "sum 9618071.000 35030129.000 \n", "range 1950.000 9127.000 \n", "stdev 111.691 301.579 \n", "q1 45.000 234.000 \n", "q3 126.000 487.000 \n", "median 82.000 358.000 \n", "interquartile_range 81.000 253.000 \n", "\n", " employed_finance_insurance_real_estate \\\n", "avg 134.648 \n", "max 2853.000 \n", "min 0.000 \n", "sum 9964050.000 \n", "range 2853.000 \n", "stdev 130.573 \n", "q1 41.000 \n", "q3 125.000 \n", "median 78.000 \n", "interquartile_range 84.000 \n", "\n", " employed_information employed_manufacturing \\\n", "avg 43.153 210.403 \n", "max 1141.000 3993.000 \n", "min 0.000 0.000 \n", "sum 3193371.000 15570023.000 \n", "range 1141.000 3993.000 \n", "stdev 54.003 182.628 \n", "q1 7.000 65.000 \n", "q3 37.000 204.000 \n", "median 19.000 129.000 \n", "interquartile_range 30.000 139.000 \n", "\n", " employed_other_services_not_public_admin \\\n", "avg 100.384 \n", "max 1175.000 \n", "min 0.000 \n", "sum 7428501.000 \n", "range 1175.000 \n", "stdev 76.194 \n", "q1 40.000 \n", "q3 101.000 \n", "median 69.000 \n", "interquartile_range 61.000 \n", "\n", " employed_public_administration employed_retail_trade \\\n", "avg 96.162 233.863 \n", "max 1816.000 2808.000 \n", "min 0.000 0.000 \n", "sum 7116087.000 17306059.000 \n", "range 1816.000 2808.000 \n", "stdev 99.876 155.195 \n", "q1 29.000 111.000 \n", "q3 87.000 238.000 \n", "median 55.000 172.000 \n", "interquartile_range 58.000 127.000 \n", "\n", " employed_science_management_admin_waste \\\n", "avg 231.125 \n", "max 5115.000 \n", "min 0.000 \n", "sum 17103509.000 \n", "range 5115.000 \n", "stdev 201.500 \n", "q1 81.000 \n", "q3 220.000 \n", "median 141.000 \n", "interquartile_range 139.000 \n", "\n", " employed_transportation_warehousing_utilities \\\n", "avg 104.331 \n", "max 1465.000 \n", "min 0.000 \n", "sum 7720629.000 \n", "range 1465.000 \n", "stdev 90.187 \n", "q1 37.000 \n", "q3 101.000 \n", "median 66.000 \n", "interquartile_range 64.000 \n", "\n", " employed_wholesale_trade occupation_management_arts \\\n", "avg 55.019 766.585 \n", "max 1294.000 19097.000 \n", "min 0.000 0.000 \n", "sum 4071464.000 56728086.000 \n", "range 1294.000 19097.000 \n", "stdev 54.514 615.676 \n", "q1 13.000 290.000 \n", "q3 53.000 747.000 \n", "median 31.000 495.000 \n", "interquartile_range 40.000 457.000 \n", "\n", " occupation_natural_resources_construction_maintenance \\\n", "avg 182.001 \n", "max 3973.000 \n", "min 0.000 \n", "sum 13468231.000 \n", "range 3973.000 \n", "stdev 151.202 \n", "q1 63.000 \n", "q3 181.000 \n", "median 120.000 \n", "interquartile_range 118.000 \n", "\n", " occupation_production_transportation_material \\\n", "avg 249.131 \n", "max 2495.000 \n", "min 0.000 \n", "sum 18435915.000 \n", "range 2495.000 \n", "stdev 186.202 \n", "q1 96.000 \n", "q3 253.000 \n", "median 168.000 \n", "interquartile_range 157.000 \n", "\n", " occupation_sales_office occupation_services \\\n", "avg 482.802 368.633 \n", "max 6162.000 3948.000 \n", "min 0.000 0.000 \n", "sum 35727854.000 27279215.000 \n", "range 6162.000 3948.000 \n", "stdev 298.801 236.678 \n", "q1 243.000 186.000 \n", "q3 501.000 374.000 \n", "median 369.000 274.000 \n", "interquartile_range 258.000 188.000 \n", "\n", " management_business_sci_arts_employed \\\n", "avg 766.585 \n", "max 19097.000 \n", "min 0.000 \n", "sum 56728086.000 \n", "range 19097.000 \n", "stdev 615.676 \n", "q1 290.000 \n", "q3 747.000 \n", "median 495.000 \n", "interquartile_range 457.000 \n", "\n", " sales_office_employed in_grades_1_to_4 \\\n", "avg 482.802 222.900 \n", "max 6162.000 5927.000 \n", "min 0.000 0.000 \n", "sum 35727854.000 16494816.000 \n", "range 6162.000 5927.000 \n", "stdev 298.801 168.745 \n", "q1 243.000 97.000 \n", "q3 501.000 224.000 \n", "median 369.000 158.000 \n", "interquartile_range 258.000 127.000 \n", "\n", " in_grades_5_to_8 in_grades_9_to_12 in_school \\\n", "avg 225.327 232.226 1116.528 \n", "max 5674.000 4965.000 23989.000 \n", "min 0.000 0.000 0.000 \n", "sum 16674443.000 17184966.000 82624168.000 \n", "range 5674.000 4965.000 23989.000 \n", "stdev 169.223 168.723 766.285 \n", "q1 97.000 102.000 560.000 \n", "q3 226.000 236.000 1120.000 \n", "median 161.000 165.000 833.000 \n", "interquartile_range 129.000 134.000 560.000 \n", "\n", " in_undergrad_college speak_only_english_at_home \\\n", "avg 255.724 None \n", "max 12985.000 None \n", "min 0.000 None \n", "sum 18923849.000 None \n", "range 12985.000 None \n", "stdev 408.312 None \n", "q1 84.000 None \n", "q3 212.000 None \n", "median 142.000 None \n", "interquartile_range 128.000 None \n", "\n", " speak_spanish_at_home speak_spanish_at_home_low_english \n", "avg None None \n", "max None None \n", "min None None \n", "sum None None \n", "range None None \n", "stdev None None \n", "q1 None None \n", "q3 None None \n", "median None None \n", "interquartile_range None None " ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.describe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### 1.4.5. Visualization of dataset coverage" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 674 }, "id": "vLWOeAhn9Wf1", "outputId": "e4e46f9f-c9e2-4eb4-cd24-9ab08be22a71" }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", " None\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", " \n", "\n", " \n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", " Static map image\n", " \n", " \n", "
\n", "
\n", "
\n", " \n", " \n", "
\n", "
\n", "
\n", "\n", " \n", "\n", "
\n", "
\n", " :\n", "
\n", " \n", " \n", "
\n", "
\n", "\n", "
\n", " StackTrace\n", "
    \n", "
    \n", "
    \n", "\n", "\n", "\n", "\n", "\n", "\">\n", "\n", "" ], "text/plain": [ "" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sample_ds.geom_coverage()" ] } ], "metadata": { "colab": { "collapsed_sections": [], "name": "CARTO | Data Observatory v2.0 - Access to Data.ipynb", "provenance": [], "toc_visible": true }, "kernelspec": { "display_name": "Python 3", "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.5" } }, "nbformat": 4, "nbformat_minor": 4 }