{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Using `cenpy` to analyze Segregation in US Cities\n", "\n", "*Levi John Wolf*\n", "\n", "University of Bristol\n", "\n", "levi.john.wolf@bristol.ac.uk" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "`cenpy` makes it dead simple to fetch demographic data. It works by automatically *discovering* different data products made available by the US Census Bureau, *exposing* these data products in a consistent pythonic fashion, and then *wrangling* the data into a clean `geopandas` dataframe. This is useful in the analysis of segregation in American cities. It's often difficult to do large-scale demographic analysis because demographic data at sufficiently fine-grained spatial resolution is hard to get and process over a large geographic extent. A few cities in a few states rapidly becomes a difficult analytical task. With `cenpy`, though, this becomes easy. \n", "\n", "Further, the new `segregation` package allows for the computation and comparison of segregation measures in different urban systems. While it's often easy to compute a single measure of segregation, it's difficult to conduct *inference* on that measure. Thus, we can easily figure out *how* segregated a place is, but not figure out the intrinsic uncertainty in that estimated segregation measure. Further, *comparing* segregation indices between places or across time should consider this uncertainty. \n", "\n", "Fortunately, using `cenpy` and `segregation` packages in Python, we can conduct fast analyses to examine how segregation changes over time or between cities. Below, I'll walk through an example of how you can examine changes in the segregation of Hispanic populations over time in Phoenix and comparison of segregation between Phoenix and Austin. " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Importing packages" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "First, the packages we need are `cenpy` and `segregation`. But, to help get a sense of what the areas look like, I use `contextily`, a simple package to request basemap tiles to use in matplotlib plots. " ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import cenpy\n", "import segregation\n", "import contextily\n", "%matplotlib inline" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Cenpy has two different ways it can be used. The new `product` API focus on using geographical names to make querying [as simple as possible](https://nbviewer.jupyter.org/gist/ljwolf/3481aeadf1b0fbb46b72553a08bfc4e6?flush_cache=true). But, because it requires a little more prior knowledge about how queries should be formed, there are a limited number of data products that are supported. The 5-year ACS and 2010 Decennial census are supported. By default, the most recent 5-year ACS is fetched. " ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "acs = cenpy.products.ACS()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Once the product is built, it has a few useful attributes. All of the *variables*, or columns in the Census's database, are contained within the dataframe `variables`:" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | attributes | \n", "concept | \n", "group | \n", "label | \n", "limit | \n", "predicateOnly | \n", "predicateType | \n", "required | \n", "values | \n", "
---|---|---|---|---|---|---|---|---|---|
AIANHH | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
AIHHTL | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
AIRES | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
ANRC | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
B00001_001E | \n", "B00001_001EA | \n", "UNWEIGHTED SAMPLE COUNT OF THE POPULATION | \n", "B00001 | \n", "Estimate!!Total | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B00002_001E | \n", "B00002_001EA | \n", "UNWEIGHTED SAMPLE HOUSING UNITS | \n", "B00002 | \n", "Estimate!!Total | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_001E | \n", "B01001A_001M,B01001A_001MA,B01001A_001EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_002E | \n", "B01001A_002M,B01001A_002MA,B01001A_002EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_003E | \n", "B01001A_003M,B01001A_003MA,B01001A_003EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!Under 5 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_004E | \n", "B01001A_004M,B01001A_004MA,B01001A_004EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!5 to 9 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_005E | \n", "B01001A_005M,B01001A_005MA,B01001A_005EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!10 to 14 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_006E | \n", "B01001A_006M,B01001A_006MA,B01001A_006EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!15 to 17 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_007E | \n", "B01001A_007M,B01001A_007MA,B01001A_007EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!18 and 19 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_008E | \n", "B01001A_008M,B01001A_008MA,B01001A_008EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!20 to 24 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_009E | \n", "B01001A_009M,B01001A_009MA,B01001A_009EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!25 to 29 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_010E | \n", "B01001A_010M,B01001A_010MA,B01001A_010EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!30 to 34 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_011E | \n", "B01001A_011M,B01001A_011MA,B01001A_011EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!35 to 44 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_012E | \n", "B01001A_012M,B01001A_012MA,B01001A_012EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!45 to 54 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_013E | \n", "B01001A_013M,B01001A_013MA,B01001A_013EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!55 to 64 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_014E | \n", "B01001A_014M,B01001A_014MA,B01001A_014EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!65 to 74 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_015E | \n", "B01001A_015M,B01001A_015MA,B01001A_015EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!75 to 84 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_016E | \n", "B01001A_016M,B01001A_016MA,B01001A_016EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Male!!85 years and over | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_017E | \n", "B01001A_017M,B01001A_017MA,B01001A_017EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_018E | \n", "B01001A_018M,B01001A_018MA,B01001A_018EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!Under 5 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_019E | \n", "B01001A_019M,B01001A_019MA,B01001A_019EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!5 to 9 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_020E | \n", "B01001A_020M,B01001A_020MA,B01001A_020EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!10 to 14 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_021E | \n", "B01001A_021M,B01001A_021MA,B01001A_021EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!15 to 17 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_022E | \n", "B01001A_022M,B01001A_022MA,B01001A_022EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!18 and 19 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_023E | \n", "B01001A_023M,B01001A_023MA,B01001A_023EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!20 to 24 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B01001A_024E | \n", "B01001A_024M,B01001A_024MA,B01001A_024EA | \n", "SEX BY AGE (WHITE ALONE) | \n", "B01001A | \n", "Estimate!!Total!!Female!!25 to 29 years | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
COUSUB | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
CSA | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
DIVISION | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
GEOCOMP | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geographic Component code | \n", "0 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'R1': 'Not in an offshore area', 'S0... | \n", "
GEO_ID | \n", "NAME | \n", "ALLOCATION OF EDUCATIONAL ATTAINMENT FOR THE P... | \n", "B17015,B18104,B17016,B18105,B17017,B18106,B170... | \n", "Geography | \n", "0 | \n", "NaN | \n", "string | \n", "NaN | \n", "NaN | \n", "
METDIV | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
NATION | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
NECTA | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
NECTADIV | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
PLACE | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
PLACEREM | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
PRINCITY | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
PUMA5 | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
REGION | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
SDELM | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
SDSEC | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
SDUNI | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
SLDL | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
SLDU | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
STATE | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
SUBMCD | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
TRACT | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
TRIBALBG | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
TRIBALCT | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
TRISUBREM | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
UA | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
ZCTA | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Geography | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
for | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Census API FIPS 'for' clause | \n", "0 | \n", "True | \n", "fips-for | \n", "NaN | \n", "NaN | \n", "
in | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Census API FIPS 'in' clause | \n", "0 | \n", "True | \n", "fips-in | \n", "NaN | \n", "NaN | \n", "
ucgid | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Uniform Census Geography Identifier clause | \n", "0 | \n", "True | \n", "ucgid | \n", "NaN | \n", "NaN | \n", "
25110 rows × 9 columns
\n", "\n", " | description | \n", "columns | \n", "
---|---|---|
table_name | \n", "\n", " | \n", " |
B00001 | \n", "UNWEIGHTED SAMPLE COUNT OF THE POPULATION | \n", "[B00001_001E] | \n", "
B00002 | \n", "UNWEIGHTED SAMPLE HOUSING UNITS | \n", "[B00002_001E] | \n", "
B01001 | \n", "SEX BY AGE | \n", "[B01001_001E, B01001_002E, B01001_003E, B01001... | \n", "
B01002 | \n", "MEDIAN AGE BY SEX | \n", "[B01002_001E, B01002_002E, B01002_003E] | \n", "
B01003 | \n", "TOTAL POPULATION | \n", "[B01003_001E] | \n", "
B02001 | \n", "RACE | \n", "[B02001_001E, B02001_002E, B02001_003E, B02001... | \n", "
B02008 | \n", "WHITE ALONE OR IN COMBINATION WITH ONE OR MORE... | \n", "[B02008_001E] | \n", "
B02009 | \n", "BLACK OR AFRICAN AMERICAN ALONE OR IN COMBINAT... | \n", "[B02009_001E] | \n", "
B02010 | \n", "AMERICAN INDIAN AND ALASKA NATIVE ALONE OR IN ... | \n", "[B02010_001E] | \n", "
B02011 | \n", "ASIAN ALONE OR IN COMBINATION WITH ONE OR MORE... | \n", "[B02011_001E] | \n", "
B02012 | \n", "NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALO... | \n", "[B02012_001E] | \n", "
B02013 | \n", "SOME OTHER RACE ALONE OR IN COMBINATION WITH O... | \n", "[B02013_001E] | \n", "
B02014 | \n", "AMERICAN INDIAN AND ALASKA NATIVE ALONE FOR SE... | \n", "[B02014_001E, B02014_002E, B02014_003E, B02014... | \n", "
B02015 | \n", "ASIAN ALONE BY SELECTED GROUPS | \n", "[B02015_001E, B02015_002E, B02015_003E, B02015... | \n", "
B02016 | \n", "NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALO... | \n", "[B02016_001E, B02016_002E, B02016_003E, B02016... | \n", "
B02017 | \n", "AMERICAN INDIAN AND ALASKA NATIVE (AIAN) ALONE... | \n", "[B02017_001E, B02017_002E, B02017_003E, B02017... | \n", "
B02018 | \n", "ASIAN ALONE OR IN ANY COMBINATION BY SELECTED ... | \n", "[B02018_001E, B02018_002E, B02018_003E, B02018... | \n", "
B02019 | \n", "NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALO... | \n", "[B02019_001E, B02019_002E, B02019_003E, B02019... | \n", "
B03001 | \n", "HISPANIC OR LATINO ORIGIN BY SPECIFIC ORIGIN | \n", "[B03001_001E, B03001_002E, B03001_003E, B03001... | \n", "
B03002 | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "[B03002_001E, B03002_002E, B03002_003E, B03002... | \n", "
B03003 | \n", "HISPANIC OR LATINO ORIGIN | \n", "[B03003_001E, B03003_002E, B03003_003E] | \n", "
B04004 | \n", "PEOPLE REPORTING SINGLE ANCESTRY | \n", "[B04004_001E, B04004_002E, B04004_003E, B04004... | \n", "
B04005 | \n", "PEOPLE REPORTING MULTIPLE ANCESTRY | \n", "[B04005_001E, B04005_002E, B04005_003E, B04005... | \n", "
B04006 | \n", "PEOPLE REPORTING ANCESTRY | \n", "[B04006_001E, B04006_002E, B04006_003E, B04006... | \n", "
B04007 | \n", "ANCESTRY | \n", "[B04007_001E, B04007_002E, B04007_003E, B04007... | \n", "
B05001 | \n", "NATIVITY AND CITIZENSHIP STATUS IN THE UNITED ... | \n", "[B05001_001E, B05001_002E, B05001_003E, B05001... | \n", "
B05002 | \n", "PLACE OF BIRTH BY NATIVITY AND CITIZENSHIP STATUS | \n", "[B05002_001E, B05002_002E, B05002_003E, B05002... | \n", "
B05003 | \n", "SEX BY AGE BY NATIVITY AND CITIZENSHIP STATUS | \n", "[B05003_001E, B05003_002E, B05003_003E, B05003... | \n", "
B05004 | \n", "MEDIAN AGE BY NATIVITY AND CITIZENSHIP STATUS ... | \n", "[B05004_001E, B05004_002E, B05004_003E, B05004... | \n", "
B05005 | \n", "PERIOD OF ENTRY BY NATIVITY AND CITIZENSHIP ST... | \n", "[B05005_001E, B05005_002E, B05005_003E, B05005... | \n", "
... | \n", "... | \n", "... | \n", "
C15010 | \n", "FIELD OF BACHELOR'S DEGREE FOR FIRST MAJOR FOR... | \n", "[C15010_001E, C15010_002E, C15010_003E, C15010... | \n", "
C16001 | \n", "LANGUAGE SPOKEN AT HOME FOR THE POPULATION 5 Y... | \n", "[C16001_001E, C16001_002E, C16001_003E, C16001... | \n", "
C16002 | \n", "HOUSEHOLD LANGUAGE BY HOUSEHOLD LIMITED ENGLIS... | \n", "[C16002_001E, C16002_002E, C16002_003E, C16002... | \n", "
C17002 | \n", "RATIO OF INCOME TO POVERTY LEVEL IN THE PAST 1... | \n", "[C17002_001E, C17002_002E, C17002_003E, C17002... | \n", "
C18108 | \n", "AGE BY NUMBER OF DISABILITIES | \n", "[C18108_001E, C18108_002E, C18108_003E, C18108... | \n", "
C18120 | \n", "EMPLOYMENT STATUS BY DISABILITY STATUS | \n", "[C18120_001E, C18120_002E, C18120_003E, C18120... | \n", "
C18121 | \n", "WORK EXPERIENCE BY DISABILITY STATUS | \n", "[C18121_001E, C18121_002E, C18121_003E, C18121... | \n", "
C18130 | \n", "AGE BY DISABILITY STATUS BY POVERTY STATUS | \n", "[C18130_001E, C18130_002E, C18130_003E, C18130... | \n", "
C18131 | \n", "RATIO OF INCOME TO POVERTY LEVEL IN THE PAST 1... | \n", "[C18131_001E, C18131_002E, C18131_003E, C18131... | \n", "
C21007 | \n", "AGE BY VETERAN STATUS BY POVERTY STATUS IN THE... | \n", "[C21007_001E, C21007_002E, C21007_003E, C21007... | \n", "
C24010 | \n", "SEX BY OCCUPATION FOR THE CIVILIAN EMPLOYED PO... | \n", "[C24010_001E, C24010_002E, C24010_003E, C24010... | \n", "
C24020 | \n", "SEX BY OCCUPATION FOR THE FULL-TIME, YEAR-ROUN... | \n", "[C24020_001E, C24020_002E, C24020_003E, C24020... | \n", "
C24030 | \n", "SEX BY INDUSTRY FOR THE CIVILIAN EMPLOYED POPU... | \n", "[C24030_001E, C24030_002E, C24030_003E, C24030... | \n", "
C24040 | \n", "SEX BY INDUSTRY FOR THE FULL-TIME, YEAR-ROUND ... | \n", "[C24040_001E, C24040_002E, C24040_003E, C24040... | \n", "
C24050 | \n", "INDUSTRY BY OCCUPATION FOR THE CIVILIAN EMPLO... | \n", "[C24050_001E, C24050_002E, C24050_003E, C24050... | \n", "
C24060 | \n", "OCCUPATION BY CLASS OF WORKER FOR THE CIVILIAN... | \n", "[C24060_001E, C24060_002E, C24060_003E, C24060... | \n", "
C24070 | \n", "INDUSTRY BY CLASS OF WORKER FOR THE CIVILIAN E... | \n", "[C24070_001E, C24070_002E, C24070_003E, C24070... | \n", "
C27004 | \n", "EMPLOYER-BASED HEALTH INSURANCE BY SEX BY AGE | \n", "[C27004_001E, C27004_002E, C27004_003E, C27004... | \n", "
C27005 | \n", "DIRECT-PURCHASE HEALTH INSURANCE BY SEX BY AGE | \n", "[C27005_001E, C27005_002E, C27005_003E, C27005... | \n", "
C27006 | \n", "MEDICARE COVERAGE BY SEX BY AGE | \n", "[C27006_001E, C27006_002E, C27006_003E, C27006... | \n", "
C27007 | \n", "MEDICAID/MEANS-TESTED PUBLIC COVERAGE BY SEX B... | \n", "[C27007_001E, C27007_002E, C27007_003E, C27007... | \n", "
C27008 | \n", "TRICARE/MILITARY HEALTH COVERAGE BY SEX BY AGE | \n", "[C27008_001E, C27008_002E, C27008_003E, C27008... | \n", "
C27009 | \n", "VA HEALTH CARE BY SEX BY AGE | \n", "[C27009_001E, C27009_002E, C27009_003E, C27009... | \n", "
C27012 | \n", "HEALTH INSURANCE COVERAGE STATUS AND TYPE BY W... | \n", "[C27012_001E, C27012_002E, C27012_003E, C27012... | \n", "
C27013 | \n", "PRIVATE HEALTH INSURANCE BY WORK EXPERIENCE | \n", "[C27013_001E, C27013_002E, C27013_003E, C27013... | \n", "
C27014 | \n", "PUBLIC HEALTH INSURANCE BY WORK EXPERIENCE | \n", "[C27014_001E, C27014_002E, C27014_003E, C27014... | \n", "
C27016 | \n", "HEALTH INSURANCE COVERAGE STATUS BY RATIO OF I... | \n", "[C27016_001E, C27016_002E, C27016_003E, C27016... | \n", "
C27017 | \n", "PRIVATE HEALTH INSURANCE BY RATIO OF INCOME TO... | \n", "[C27017_001E, C27017_002E, C27017_003E, C27017... | \n", "
C27018 | \n", "PUBLIC HEALTH INSURANCE BY RATIO OF INCOME TO ... | \n", "[C27018_001E, C27018_002E, C27018_003E, C27018... | \n", "
C27021 | \n", "HEALTH INSURANCE COVERAGE STATUS BY LIVING AR... | \n", "[C27021_001E, C27021_002E, C27021_003E, C27021... | \n", "
665 rows × 2 columns
\n", "\n", " | description | \n", "columns | \n", "
---|---|---|
table_name | \n", "\n", " | \n", " |
B02001 | \n", "RACE | \n", "[B02001_001E, B02001_002E, B02001_003E, B02001... | \n", "
B02008 | \n", "WHITE ALONE OR IN COMBINATION WITH ONE OR MORE... | \n", "[B02008_001E] | \n", "
B02009 | \n", "BLACK OR AFRICAN AMERICAN ALONE OR IN COMBINAT... | \n", "[B02009_001E] | \n", "
B02010 | \n", "AMERICAN INDIAN AND ALASKA NATIVE ALONE OR IN ... | \n", "[B02010_001E] | \n", "
B02011 | \n", "ASIAN ALONE OR IN COMBINATION WITH ONE OR MORE... | \n", "[B02011_001E] | \n", "
B02012 | \n", "NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALO... | \n", "[B02012_001E] | \n", "
B02013 | \n", "SOME OTHER RACE ALONE OR IN COMBINATION WITH O... | \n", "[B02013_001E] | \n", "
B03002 | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "[B03002_001E, B03002_002E, B03002_003E, B03002... | \n", "
B25006 | \n", "RACE OF HOUSEHOLDER | \n", "[B25006_001E, B25006_002E, B25006_003E, B25006... | \n", "
B98013 | \n", "TOTAL POPULATION COVERAGE RATE BY WEIGHTING RA... | \n", "[B98013_001E, B98013_002E, B98013_003E, B98013... | \n", "
B99021 | \n", "ALLOCATION OF RACE | \n", "[B99021_001E, B99021_002E, B99021_003E] | \n", "
C02003 | \n", "DETAILED RACE | \n", "[C02003_001E, C02003_002E, C02003_003E, C02003... | \n", "
\n", " | description | \n", "columns | \n", "
---|---|---|
table_name | \n", "\n", " | \n", " |
B03001 | \n", "HISPANIC OR LATINO ORIGIN BY SPECIFIC ORIGIN | \n", "[B03001_001E, B03001_002E, B03001_003E, B03001... | \n", "
B03002 | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "[B03002_001E, B03002_002E, B03002_003E, B03002... | \n", "
B03003 | \n", "HISPANIC OR LATINO ORIGIN | \n", "[B03003_001E, B03003_002E, B03003_003E] | \n", "
B16006 | \n", "LANGUAGE SPOKEN AT HOME BY ABILITY TO SPEAK EN... | \n", "[B16006_001E, B16006_002E, B16006_003E, B16006... | \n", "
B98013 | \n", "TOTAL POPULATION COVERAGE RATE BY WEIGHTING RA... | \n", "[B98013_001E, B98013_002E, B98013_003E, B98013... | \n", "
B99031 | \n", "ALLOCATION OF HISPANIC OR LATINO ORIGIN | \n", "[B99031_001E, B99031_002E, B99031_003E] | \n", "
\n", " | attributes | \n", "concept | \n", "group | \n", "label | \n", "limit | \n", "predicateOnly | \n", "predicateType | \n", "required | \n", "values | \n", "
---|---|---|---|---|---|---|---|---|---|
B03002_021E | \n", "B03002_021M,B03002_021MA,B03002_021EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Two or mo... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_020E | \n", "B03002_020M,B03002_020MA,B03002_020EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Two or mo... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_001E | \n", "B03002_001M,B03002_001MA,B03002_001EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_005E | \n", "B03002_005M,B03002_005MA,B03002_005EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Ameri... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_004E | \n", "B03002_004M,B03002_004MA,B03002_004EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Black... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_003E | \n", "B03002_003M,B03002_003MA,B03002_003EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!White... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_002E | \n", "B03002_002M,B03002_002MA,B03002_002EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_009E | \n", "B03002_009M,B03002_009MA,B03002_009EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Two o... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_007E | \n", "B03002_007M,B03002_007MA,B03002_007EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Nativ... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_008E | \n", "B03002_008M,B03002_008MA,B03002_008EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Some ... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_006E | \n", "B03002_006M,B03002_006MA,B03002_006EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Asian... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_013E | \n", "B03002_013M,B03002_013MA,B03002_013EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!White alone | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_012E | \n", "B03002_012M,B03002_012MA,B03002_012EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_011E | \n", "B03002_011M,B03002_011MA,B03002_011EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Two o... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_010E | \n", "B03002_010M,B03002_010MA,B03002_010EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Not Hispanic or Latino!!Two o... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_017E | \n", "B03002_017M,B03002_017MA,B03002_017EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Native Ha... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_016E | \n", "B03002_016M,B03002_016MA,B03002_016EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Asian alone | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_015E | \n", "B03002_015M,B03002_015MA,B03002_015EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!American ... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_014E | \n", "B03002_014M,B03002_014MA,B03002_014EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Black or ... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_018E | \n", "B03002_018M,B03002_018MA,B03002_018EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Some othe... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
B03002_019E | \n", "B03002_019M,B03002_019MA,B03002_019EA | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "B03002 | \n", "Estimate!!Total!!Hispanic or Latino!!Two or mo... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "