Category Archives: Race/Origin

Census Block, Block Group & Census Tract GeoDemographics

Census tracts, block groups and blocks are the important small area statistical geographic areas for which data from Census 2010 are tabulated. Data for census tracts and block groups are also tabulated annually from the American Community Survey. For example. in December 2018, we will have new “richer demographics” annual estimates centric to each year 2008 through 2015 for Census 2010 tracts and block groups … data such as educational attainment, language spoken, housing and household characteristics,  income characteristics and employment and other demographic-economic attributes.

Largest Population New York City (NYC) Census Blocks
The following graphic shows the NYC Census 2010 census block having the largest Census 2010 population that is not a group quarters population block. The Lincoln Center census block shown in the graphic (red boundary) has 4,067 population and 2,922 housing units.

– click graphic for larger view; view developed using CV XE GIS

This block (36 061 015500 6000) occupies 0.033 square miles. It has a population density of 122,333 (population per square mile). The NYC block with the largest population is on Rikers Island and has a group quarters population of 8,634 and 0 housing units. For Census 2010, there were 350,169 census blocks covering the state of New York; 13,356 census blocks were water blocks. For the State of New York, as of Census 2010 the average census block population was 55 (57 excluding water blocks).

Census 2010 and Census 2020
These geographies have generally stable geographic areas and codes from one decennial census (e.g., Census 2010) to the next (e.g., Census 2020). Many of these areas will change in terms of code and area for Census 2020, though the geographic changes will typically be small or not at all.

Census 2020 block, block group and tract codes and geometry will be available in late 2020. Initial block level demographics will be available in March 2021.

Census 2010 & Current GeoDemographics
These areas cover the U.S. from wall-to-wall and generally non-changing in terms of boundary and geographic code (geocode) until Census 2020. This section provides a summary of new Web pages with more detail about each of these geographies:
census tracts and tract codes .. 73,056 areas
census block groups and block group codes .. 217,740 areas
census blocks and block codes .. 11,078,297 areas

Each of these pages provides an interactive table to view tallies of Census 2010 for each of these small area geographies.

Combining Address Data with Small Area Geography
The address of the Office of the California Secretary of State, located at 1500 11th St, Sacramento, CA 95814, was geocoded using the APIGeocoder and converted into a shapefile for Geographic Information System applications.  The location is shown as a red marker in the map views shown below, illustrating each type of small area geography: tracts. block groups and blocks.

Census Tracts
Tracts are labeled with green tract codes. Address 1500 11th St, Sacramento, CA 95814 is shown by red marker.  The address is in tract 06067001101.

View created using CV XE GIS.

Block Groups
Block groups are labeled with red block group codes.  Tract 06067001101 is comprised of block groups: 060670011011 and 060670011012.  See pointer in map view; the block group within tract boundary.

View created using CV XE GIS.

Zoom-in to Census Block
Blocks are labeled with yellow block codes. The address is located in block 060670011011085.

View created using CV XE GIS.

Further Zoom-in Showing Streets
Streets are labeled with street names. Identify tool is used to show mini-profile for 1500 block of 11th Street.

View created using CV XE GIS.

Is the tract code 11.01 or 001101?
Both. Census tracts within a county are identified by a 4-digit basic code between 0001 and 9999, and may have a 2-digit suffix ranging from .01 to .98; for example, 6059.02. The decimal point separating the 4-digit basic tract code from the 2-digit suffix is shown in Census Bureau printed reports and maps. For geo-referencing, the decimal point is implied and does not appear; the 6-character tract code with lead zeroes is used — a character string with no blanks and all numbers.

Accessing and Using these Geographies & Related Demographics
There are several ways these geographies can be used.
• The geocodes are the “handles” to access demographic-economic statistical data.
• The geographies may be visually, geospatially, related as shapefiles.
.. the Census Bureau makes these shapefiles available for use in user appications.
.. the shapefiles typically do not include demographic-economic data.

Access Census 2010 Census Block (and Block Group/Tract) data:
• P.L. 94-171 Redistricting Data — http://proximityone.com/cen2010_pl94171.htm
• Summary File 1 — http://proximityone.com/cen2010_sf1.htm

Access Census Block Group and Tract richer demographics:
• 2016 American Community Survey (ACS) 5-year estimates
  — http://proximityone.com/acs1216.htm
• Access annual counterparts to above section
• Census blocks — http://proximityone.com/cenblk.htm
• Census block groups — http://proximityone.com/blockgroups.htm
• Census tracts — http://proximityone.com/tracts.htm

Alternatively use the Census Bureau APIs or CV XE GIS APIGateway.

Data Analytics Web Sessions
.. is my area urban, rural or …
.. how do census blocks relate to congressional district? redistricting?
.. how can I map census block demographics?
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Communities of U.S. Foreign Born Population

.. examining the U.S. foreign born population and how/where foreign born by country of origin communities exist .. the U.S. foreign born population includes anyone who is not a U.S. citizen at birth, including those who have become U.S. citizens through naturalization. The native born population includes anyone who is a U.S. citizen at birth, including those who were born in the U.S., Puerto Rico, a U.S. Island Area or abroad to U.S. citizen parent(s). Use the interactive table to examine foreign born population by country by census tract.

As of 2016, the U.S. foreign born population was estimated to be 43,739,345 compared to the total U.S. population of 323,127,515 (13.5%). See the related Web section for more detailed information about the U.S. foreign born population.

Chinese Foreign Born Population & $MHI Patterns; New York City Area
– red markers show census tracts with 500 or more Chinese foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Importance of the Foreign Born Data … knowing about the geographic, demographic and economic attributes of the foreign born population tells us about the size, distribution and characteristics of the immigrant population. Projections of the foreign born population tell us how our country will grow. See more in this related section.

An Illustrative View. The Chinese foreign born population is used in the graphic below to illustrate the distribution of U.S.national scope foreign born population. Other population groups could have been used. Based on the ACS 2016 5-year estimates, there are 851 census tracts having 500 or more Chinese foreign born population (of a total 73,056 tracts). Twenty of the 25 tracts having the largest number of Chinese foreign born population are located in New York City. Determine which tracts using the related interactive table.

Chinese Foreign Born Population Patterns
– China is one of 162 country/country groups reviewed in this section
– red markers show census tracts with 500 or more Chinese foreign born
– the distribution is wide and difficult to gain insights

– view developed with CV XE GIS software using related GIS project and datasets.

Communities of Foreign Born Population
These additional views illustrate how selected foreign born country population clusters in many cases. Some develop communities without formal boundaries or any formally designated structure. Use the GIS project and tools to develop your own views for country combinations and areas of interest.

India Foreign Born Population & $MHI Patterns; New York City Area
– red markers show census tracts with 500 or more India foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Asia Foreign Born Population & $MHI Patterns; Houston, TX Area
– red markers show census tracts with 500 or more Asia foreign born
.. all Asia countries (item 047 in country list above in this section
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Cuba Foreign Born Population & $MHI Patterns; Miami, FL Area
– red markers show census tracts with 500 or more Cuba foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Vietnam Foreign Born Population & $MHI Patterns; Los Angeles, CA Area
– red markers show census tracts with 500 or more Vietnam foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Using the Interactive Table
— Foreign Born Population by Country by Census Tract

The following graphic illustrates use of the interactive table to examine census tracts in Queens County, NY (code 36081, New York City). South East Asia countries (columns) have been selected and sorted in descending order on China. The table shows the size of the China foreign born population by census tract; the census tract code is shown in the left column.

Use the interactive table and examine areas of interest to you.

Data Analytics Web Sessions
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

 

Examining America’s Cities: Demographic-Economic Updates

.. of the approximate 29,500 U.S. cities and places — geographic areas of population concentration — 301 had an ACS 2016 5-year estimated population of 100,000 or more. The median household income among these places, one measure of economic prosperity, ranged from $26,249 (Detroit, MI) to $117,642 (Frisco, TX).

What are the demographic-economic characteristics of your cities/places of interest? How do these compare to peer groups or a metro/state of interest. Learn more using the new city/place demographic interactive tables. Its about more than economic prosperity — using these data provide otherwise unknowable attributes about the demographic, social, economic and housing characteristics of individual cities/places.

Visual Analysis of City/Place Population Dynamics
The following view shows patterns of population percent change by city in the Charlotte, NC/SC metro area.

… view developed using the CV XE GIS software.
… more about above view in City/Place Economic Characteristics section.

Patterns of Economic Prosperity ($MHI) by City/Place
— Northern Virginia, DC, Maryland; part of the Washington, DC metro.

… view developed using the CV XE GIS software.
… click graphic for larger view with places labeled by name and $MHI.

Interactive Tables — new January 2018
Use these interactive tables to get answers, build insights:
• General Demographics
• Social Characteristics
• Economic Characteristics — used to develop data at top of section
• Housing Characteristics
Related:
• City/Place GeoDemographics Main Section
• Annual City/Place Population Estimates & Trends
• Similar ACS tables: Census Tracts | ZIP Codes | State, Metro & County

More About City/Place GeoStatistical Data and Data Analytics
The term “places” as used here refers to incorporated places and Census Designated Places (CDPs). Incorporated places are political areas having certain governmental powers designated by the corresponding state. Unincorporated places, or Census Designated Places (CDPs), are statistical areas having no official standing and no governmental powers but are recognized as being areas of population concentration. Wide-ranging demographic-economic estimates are developed annually for the approximate 29,500 incorporated cities and CDPs based on the American Community Survey 5-year estimates. See more about the ACS 2016 5-year estimates.

Many cities have planning and data development operations that develop important local data including tax parcel data, building permit data, transportation and infrastructure data … bit generally not the data reviewed in this section. Many cities have no planning department to develop, organize and analyze geographic, demographic, economic data … making these data even more essential.

Increasingly in core sections of metropolitan areas, as shown in the above graphics, a large number of cities/places are contiguous. Many retain their own character evolving over many years. Having the detailed ACS demographic-economic data makes it possible to compare places side by side. Use the same data for related drill down geography such as census tracts and block groups to examine neighborhoods and market areas.

Data Analytics Web Sessions
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Creating Custom Demographic Datasets with API Tools

.. develop national scale spreadsheet files with virtually no learning time .. easy-to-use API operations to create national scope demographic-economic datasets based on American Community Survey 2016 1-year estimates .. custom subject matter selections. See more detail in related web sections ACS2016 and ACS2016_API.

Benefits and utility … how to acquire a spreadsheet showing the population of all cities with population estimates based on the ACS 2016 1-year data? … or, housing units, median household income, median housing value, etc.? Variations of this need frequently arise — what is the list of largest California counties sorted on total population: What are the 25 metros having the highest median household income? Which 10 congressional districts have the highest poverty incidence? Which urban areas have the highest educational attainment?

Use simple API calls described below to get answers to these types of questions — and more.  Create files that can be used for recurring applications. An example …

Urban Areas with 2016 Population 65,000+ Population
… results from using the API downloaded data … the following graphic shows urban areas with 65,000 or more 2016 population; zoom-in to Texas. The full national scope GIS project is available as described below; examine U.S. or any region. The file used to develop this view was created using the results of the API call reviewed below (requires integration of those data into the urban areas shapefile). Click graphic for larger view; expand browser window. Larger view shows urban areas labeled with name and mini profile for Dallas UA showing all subject matter items downloaded (via API) as described below.

… View developed using CV XE GIS.
… See more about Urban Population & Urban Areas.

Access ACS 2016 1-Year Data Using API Tools
Here are the API links … use these API calls to access/download selected items for selected geographies. See more about using API tools. Click a link and receive a return page with CSV-like structured data. See usage notes below. As these are ACS 2016 1 year estimates; geographies are only available for areas 65,000+ population.
Click a link:
• All U.S. cities/places
• All U.S. counties
• All U.S. CBSAs
• All U.S. Urban Areas
• All 115th Congressional Districts
• All U.S. states
• U.S. only

The following data retrieval operations are by state. These are examples using Arizona (FIPS state code 04).
• All [within state] Elementary School Districts
• All [within state] Secondary School Districts
• All [within state] Unified School Districts

API Call Returned Data Usage Notes
Clicking the All U.S. cities/places link above generates a new page with content very much like a CSV file. Try it .. click an above link.

See the related ACS2016_API web section for more details.

Items Retrieved in the API Calls
The sample header record above shows the subject matter item listed at the left in the following set of items. Modify API call and use other subject matter items. See full array of subject matter – xlsx file.
.. B01003_001E – Total population
Age
.. B01001_011E — Male: 25 to 29 years (illustrating age cohort access)
.. B01001_035E — Female: 25 to 29 years (illustrating age cohort access)
Race/Origin
.. B02001_002E – White alone
.. B02001_003E – Black or African American alone
.. B02001_004E – American Indian and Alaska Native alone
.. B02001_005E – Asian alone
.. B02001_006E – Native Hawaiian and Other Pacific Islander alone
.. B02001_007E – Some other race alone
.. B02001_008E – Two or more races
.. B03001_003E – Hispanic (of any race)
Income
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
Housing & Households
.. B25001_001E – Total housing units
.. B25002_002E – Occupied housing units (households)
.. B19001_017E — Households with household income $200,000 or more
.. B25003_002E — Owner Occupied housing units
.. B25075_025E — Housing units value $1,000,000 to $1,499,999
.. B25075_026E — Housing units with value $1,500,000 to $1,999,999
.. B25075_027E — Housing units with value $2,000,000 or more
.. B25002_003E – Vacant housing units
.. B25077_001E – Median housing value ($) – owner occupied units
.. B25064_001E – Median gross rent ($) – renter occupied units

The rightmost fields/columns in the rows/records contain the area name and geographic codes.

Using API Tools for Data Analytics
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on L

State of the States: Demographic Economic Update

.. tools and resources to examine the demographic-economic state of the states .. in 2016, the U.S. median housing value was $205,000 while states ranged from $113,900 (Mississippi) to $592,000 (Hawaii). See item/column H089 in the interactive table to view, rank, compare, analyze state based on this measure … in context of related housing characteristics. These data uniquely provide insights into many of the most important housing characteristics.

Use new tools, data and methods to access, integrate and analyze demographic-economic conditions for the U.S. and states. These data will update in September 2018.

Approximately 600 subject matter items from the American Community Survey ACS 2016 database (released September 2017) are included in these four pages/tables:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

GIS, Data Integration & Visual Data Analysis
Use data extracted from these tables in a ready-to-use GIS project. These ACS sourced data (from the four tables listed above) have been integrated with population estimates trend data, components of change and personal income quarterly trend data. See details in this section.

Examining Characteristics & Trends
Below are four thematic pattern maps extracted from the main sections listed above. Click a map graphic for a larger view. Use the GIS project to create variations of these views.

Patterns of Median Age by State
Yellow label shows the state USPS abbreviation; white label shows median age. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column D017 in the interactive table to view, rank, compare, analyze state based on median age.

Patterns of Educational Attainment by State
Yellow label shows the state USPS abbreviation; white label shows % college graduates. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column S067 in the interactive table to view, rank, compare, analyze state based on percent college graduates.

Patterns of Economic Prosperity by State
Yellow label shows the state USPS abbreviation; white label shows $MHI. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column E062 in the interactive table to view, rank, compare, analyze state based on median household income.

Patterns of Median Housing Value by State
Yellow label shows the state USPS abbreviation; white label shows $MHV. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column H089 in the interactive table to view, rank, compare, analyze state based on median housing value.

Examining Characteristics & Trends; Using Data Analytics
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Low & Moderate Income Census Tracts; 2017 Update

..  data and tools to analyze characteristics and patterns of census tract geography with a focus on low and moderate income.   See related Web page for more detail.

Of the total 75,883 census tracts for which low and moderate income data were tabulated in the HMDA 2017 data, 6,023 (8.7%) were low income, 16,873 (24.5%) were moderate income, 32,509 (47.1%) were middle income and 19,159 (27.8%) were upper income. See more about these classifications. Find out about your tracts/neighborhoods of interest and how they compare to others using data and tools provided in this section.

Analysis of the low, moderate, middle, and upper income of the population and households by small area geography is important to housing market stakeholders, lenders, investors, cities/neighborhoods and others. Low and moderate income data by block group and census tract are used for compliance, eligibility determination and program performance in many Federal programs and agencies.

• Use the interactive table below to view, query, compare, sort census tracts.
• Use tract estimates & projections to examine changing characteristics.
– extended demographic-economic measures, annual 2010-2022

Low & Moderate Income by Census Tract
The following view shows census tracts designated as low and moderate income (orange fill pattern) in the the Houston, TX MSA (bold brown boundary) area. These are tracts having income level with codes 1 and 2 in the interactive table. A wide range of market insights can be created zoom-in views for counties, cities and neighborhoods and linking these with other data. Make variations of this view using ProximityOne data and tools described in this section.

– View developed using CV XE GIS and related GIS project.

View similar maps for these areas:
.. Atlanta metro
.. Chicago, IL metro
.. Dallas, TX metro
.. Knoxville, TN metro
.. with drill-down views for Knoxville city
.. Los Angeles, CA metro
.. San Francisco, CA metro

Using the Interactive Table
  – Examining LMI Tracts in Your Metro

Use the interactive table to view, query, sort compare tracts based on various demographic and LMI characteristitcs. The following graphic illustrates how the table can be used to view low and moderate income tracts for the Charlotte, NC-SC metro.
– click ShowAll button below table.
– enter a CBSA code in the edit box at right of Find CBSA LMI>.
– click the Find CBSA LMI button.
Resulting display of Charlotte metro LMI tracts only.

– click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Accessing & Using ZIP Code Demographics

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

… February 2017 updates .. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. updates on accessing/downloading/using American Community Survey (ACS1115) 5-year estimates. See more detail in related Web section.

Site analysis (Option 5 below)
– create site analysis profiles from a location/ZIP code.

Contents
Five data access and use options, listed in the links below, are reviewed. Each method illustrates how ZIP code demographic-economic data can be accessed/ analyzed/used in different contexts. The most basic data access/data download is illustrated in Option 3. The following links open new windows that take you to the related section with more detail.
Option 1 – View the data as a thematic pattern map.
Option 2 – View, compare, rank query data in interactive tables.
Option 3 – Access data using API Tools; create datasets.
.. Option 3a – Extended ZIP Code subject matter access.
.. Option 3b – ZIP code urban/rural data access.
.. Option 3c – Additional API ACS data access resources.
Option 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related ZIP Code Data Access & Use sections
Interactive access to demographics based on an address
Summary of ZIP Code Data Resources & Tools
10 Reasons to use Census Tracts Versus ZIP Codes
Analyzing Census Tract Demographics by ZIP Code Area
ZIP Code to Census Tract Equivalence Table
ZIP Code Urban/Rural Geography & Demographics
Mapping ZIP Code Demograhics
Housing Price Index by 5-digit ZIP Code – time series; annual updates
Housing Price Index by 3-digit ZIP Code – time series; quarterly updates
ZIP Code Business Establishment, Employment & Earnings by industry
ZIP Code Retail Trade Establishment & Sales by industry
ZIP Code Equivalence Tables — ZIP Code to School District

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.