Category Archives: Diversity

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.

Examining Diversity by State 2015

.. states with the highest race/origin diversity in 2015 were Hawaii, California and New Mexico. States with the lowest diversity were West Virginia, Maine and Vermont. Higher levels of diversity tend to provide a better framework for understanding, tolerance and cooperative developments and progress. Use the interactive table to view, rank, compare states on the diversity index, percent population by race/origin and population by race/origin.

What is the chance that the next person I meet will be different from me, in terms of race origin? The Diversity Index is a number on a scale from 0 to 100 that shows the chance that two people chosen randomly from an area will be different by race and origin. A higher number means more diversity, a lower number, less diversity.

2015 Diversity Patterns by State
The following graphic shows patterns of the percent non-White population (see legend in lower right) the 2015 diversity index as a label for each state

– view developed using CVGIS and related project.
– use the software and project to create variations of this view; add your own data.

See the related section on diversity. USA TODAY used ProximityOne population projections to 2060 by county to examine diversity trends between 2010 and 2060 – a 50-year trend analysis.

This section provides a new estimate of the 2015 diversity index for the U.S. by state based on the latest data. The 2015 population by race/origin estimates are the most recent official Federal U.S. by state data (updated annually). See more about these estimates; access individual state profiles. In addition, the computational methodology is summarized. The U.S. by state demographics dataset is provided as a part of the U.S. State Diversity GIS project. Analyze alternative computations and views of the diversity index.

Examining the 2015 Diversity Index & Race/Origin by State
Some illustrative examples of the interactive table to view … click the Diversity Index column header cell in the table to sort states in ascending order on the Diversity Index. Click that column header cell again to sort states/rows in descending order on the Diversity Index. Find state(s) of interest; see what peer group those states are in based on demographic measures of interest.

Double-click the %Hispanic column header cell in the table to see that New Mexico has the highest %Hispanic population. Click the “population columns only” button below the table, navigate to far right and double-click the Hispanic column header cell to see that California has the largest Hispanic population.

Interactive Table Example
The following graphic illustrates use of the interactive table. States are ranked in descend order on the 2015 Diversity Index.

– 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.

Congressional District 2015 Demographic-Economic Characteristics

.. congressional districts vary widely in demographic-economic characteristics.  We have new data for 2015 providing insights to characteristics of the 114th Congressional Districts.  This section summarize a few of these characteristics and provides access to a wide range of data that you can use to view, sort, rank, and compare congressional districts using interactive tables.

Patterns of 2015 Educational Attainment
The following graphic shows patterns of educational attainment (percent college graduate) by congressional district in the Los Angeles area. White label shows the congressional district code; yellow label shows percent college graduate. Legend shows color patterns associated with percent college graduate intervals.

– View developed using CV XE GIS software and associated GIS project.

How Congressional Districts Compare
Reference items refer to items/columns shown in tables described below.

.. general demographics: congressional district UT03 has the smallest median age (27.5 years — item D017) and FL11 has the highest median age (53.5 years).

.. social characteristics: congressional district KY05 has the fewest number of people who speak English less than “very well” (2,676 — item S113) and FL27 has the largest number (281,053).

.. economic characteristics: congressional district ND00 has the lowest unemployment rate (2.6% — item E009) and MI13 has the highest unemployment rate (14.6%).

.. housing characteristics: congressional district MI13 has the lowest median housing value ($63,100 — item H089) and CA18 has the highest median housing value ($1,139,900).

Access the Detailed Interactive Tables
Click a link to view more thematic pattern maps and use the interactive tables.
.. General Demographics
.. Social Characteristics
.. Economic Characteristics
.. Housing Characteristics

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.

New ACS 2015 1-Year Demographic-Economic Data

.. essential data to assess where we are, how things have changed and how things might change in the future down to the sub-neighborhood level. The American Community Survey (ACS) is a nationwide survey designed to provide annually updated demographic-economic data for national and sub-national geography. ACS provides a wide range of important data about people and housing for every community across the nation. The results are used by everyone from planners to retailers to homebuilders and issue stakeholders like you. ACS is a primary source of local data for most of the 40 topics it covers, such as income, education, occupation, language and housing. ProximityOne uses ACS to develop current estimates on these topics and 5-year projections. This section is focused on ACS 2015 data access, integration and use and is progressively updated.

New ACS 2015 1-year estimates are available as of September 15, 2016.

Importance of ACS: Assessing Demographic-Economic Change
Oil prices plummeted in late 2014. How has this affected people and households in areas hardest hit? Find out for wide-ranging geographies using the ACS 2015 1-year estimates. Compare to ACS 2014 1-year estimates. Use the ACS 2016 1-year estimates (September 2017) to see how the impact has continued. Demographic-economic conditions change for many reasons; oil price changes are just one.

Keep informed about ACS developments and related tools and applications:
• Updates are sent to ProximityOne User Group members (join here).
… access special extract files and GIS projects available to members.
• ACS updates and applications are covered in the Data Analytics Blog.
• ACS data access, integration & use … join us in a Data Analytics Lab session.

In the weeks ahead, the following ProximityOne information resources will be updated with new ACS 2015 1-year data:
U.S.-State-Metro Interactive Tables
• Demographic component section of Metro Situation & Outlook Reports .. example for Dallas metro
• Housing characteristics component section of Metro Situation & Outlook Reports .. example for Dallas metro
Demographic-Economic Trend Profiles
• Special study reports.

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.

Analyzing ACS 2014 1-Year Supplemental Data

.. examining 2014 characteristics of areas with population 20,000 and over  .. this section summarizes how to use the America Community Survey (ACS2014) “supplemental” data (ACS2014S) to access more current estimates than otherwise available. The America Community Survey “supplemental” data are just that, a supplemental set of ACS 2014 1-year estimates — for areas 20,000 population and over. See the related Web section providing more detail.

The importance of the ACS 2014S data are two fold.
1 – 2014 1-year estimates for a larger number of areas than available from the ACS 2014 1-year (ACS2014) estimates.
2 – more current (2014) data for those areas only available from the 5-year estimates (centric to 2012) that are between 20,000 and 65,000 population.

The ten cities/places with the highest 2014 median family income based on 1-year estimates were all under 65,000 population. These cities were not included in the ACS 2014 1-year standard estimates but were included in the ACS 2014 1-year supplemental estimates. See list below.

This section provides an overview of the ACS 2014 supplemental data and provides a summary of tools, interactive table and GIS project, to analyze characteristics of these areas. These data are used by ProximityOne to develop/update annual county demographic-economic projections. See schedule of related 2016 updates.

Scope of Expanded Geography Available
As shown in the table below, 2014 1-year “supplemental” estimates are available for more than twice as many counties from the ACS2014S compared to the ACS2014 “standard” 1-year estimates. However, there area a more limited set of subject matter data available from the ACS2014S data compared to both the ACS 2014 1-year and 5-year estimates.

MSA/MISA: Metropolitan Statistical Areas/Micropolitan Statistical Areas Counties: county and county equivalent

ACS 2014S Data Availability by County
The following graphic shows the additional counties for which ACS 2014 1-year estimates are available using the “supplemental” data.
• ACS 2014 1-year “standard” estimate counties — blue fill pattern
• ACS 2014 1-year “supplemental” estimate counties — orange fill pattern
• Only ACS 2014 5-year estimates available for remaining counties
Click graphic for larger view; expand browser window for best quality view. The larger view shows metropolitan area (MSA) boundaries. Note that for example, ACS 2014 1 year data are available for all counties in the Austin and San Antonio metros (see pointer) — previously unavailable..

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. any CV XE GIS user can create this view using the default US1.GIS project

ACS2014S Tables — scroll section
The ACS 2014 supplemental data include 42 tables and a total of 229 data items. Br> The table number and descriptions are summarized below.

View full table/item detail in tables shells: ACS 2014S Table shells (xls)

ACS 2014 Selected Supplemental Items for Selected Geography
  — interactive table
The interactive table contains all geography for which the ACS2014S data have been tabulated for these geographies: U.S., state, county, city/place, 114th Congressional District, MSA/MISA, PUMA, urban area and school district. The table provides access to key selected items.

The following graphic illustrates use of the interactive table. First cities/places were selected using the Type drop-down below the table. Next, the table is ranked in descending order on median family income. As shown in the graphic the largest 10 cities/places were under 65,000 population. 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.

Tip of the Day — Census Tract Data Analytics

.. 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.

This section is focused on tools and methods to access and use census tract demographic-economic measures. Median household income ($MHI), median housing value ($MHV) and other selected items are used to illustrate operations and options.

This section illustrates use of census tract data from the 2014 American Community Survey (ACS1014) 5-year estimates. These are the most comprehensive demographic-economic data from the Census Bureau at the census tract level. These “5-year estimates” are centric to mid-2012. See more about 2010-2021 annual estimates and projections.

Methods described here apply to many other geographies; see related tip sections. See related section on ZIP code applications.

Five data access and use options are reviewed. Each method illustrates how $$MHI, $MHV and other data can be analyzed/used in different contexts.

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 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related sections:
Census tracts main section
Evolution of Census Tracts: 1970-2010
Demographic-Economic Estimates & Projections
Census tract and ZIP code equivalencing
Using census tracts versus ZIP code areas
Single year of age demographics

Option 1. View the data as a thematic pattern map; use the GIS tools:
Patterns of Economic Prosperity ($MHI) by Census Tract … the following graphic shows $MHI for a portion of the Los Angeles metro. Accommodating different demographic-economic thresholds/patterns, different legend color/data intervals are used. The pattern layer is set to 80% transparency enabling a view of earth features. Click graphic for larger view, more detail and legend color/data intervals; expand browser window for best quality view.

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

See details about each option in the related Web page.

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 and Moderate Income Demographics by Block Group

.. tools and resources to access and use low and moderate income demographics by block group … the U.S. Department of Housing and Urban Development (HUD) sponsored development of the ACS 2006-10 “low and moderate income population (LMI) by block group” special tabulation released in 2015. This is an important data resource for HUD as well as others who need to examine characteristics of the LMI population by block group and related small area geography. See related Web section for more details on topics covered here data.

This section reviews tools to use these data on a national or local level:
1. Site analysis tools
2. GIS software and national scope LMISD BG GIS project
3. National scope BG-level interactive table
See the related Web section for more detailed information.

Patterns of LMI Population by Block Group
The following graphic shows block groups with 51% or more LMI population with orange fill pattern. See related zoom-in views. Click graphic for broader Chicago area view. Expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Block Groups & American Community Survey (ACS) Data
There are several features of block groups that make this an important geography for data analytics. Block groups average 1,200 population and are the the smallest geographic area for which the ACS data are tabulated. The approximate 220,000 block groups are subdivisions of census tracts and cover the U.S. wall-to-wall. Only ACS provides national scope demographic-economic data at the block group level.

Analytical Tools & the ACS LMI Block Group Data
Tools reviewed below make use of one specific block group (170317115002) in the Chicago area. The tools may be applied to any other block group (BG) or set of BGs. Block groups are uniquely identified by the 12 character BG geocode. The BG code 170317115002 refers to block group 2 in census tract 711500 in county 031 in state 17.

1. Study Area Comparative Analysis Reports
Examine characteristics of circular area reports based on block groups within those areas. The following graphic shows a partial view of a 1- and 3-mile radius report developed for lat-lon location (41.7324422, -87.6410861) BG 170317115002 internal lat-lon. Click graphic to view entire report. This type of report can be prepared for any address/location/lat-lon and area size from less that one mile to many miles. These reports include a much larger set of demographic-economic data than included in the HUD LMISD. The comparative analysis structure makes it easy to compare one site/location with another and their difference.

.. report developed with ProximityOne SiteReport.

2. Using GIS Resources
— LMI 51% or More; Chicago Area Block Groups

Block groups with 51% or more LMI population shown with orange fill pattern. Mini profile displayed for block group at pointer – 170317115002 – find in table below. LMI percent shown as 55.03%. LMI-BG layer shown in context with Public Use Microdata Area 03531. Develop custom estimates of the population for this PUMA using the ACS PUMS data. Integrate other types of geography and data. Click graphic for broader Chicago area view. Expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

See more information here about using the GIS project used to develop maps in this section and more generally develop your own maps and perform geospatial analysis.

3. Using the Interactive Table
Use the interactive table to view, query, rank and analyze LMI demographics by block group. The following graphic illustrates one application. The state of Arizona is selected using the state selection tool below the table. The Low Income column header cell is dbl-clicked, sorting the table on the estimate of the Low Income population by block group. It is easy to see that BG 040270116002(blue highlighted) has the largest Low Income population among all BGs in Arizona.

Try using the interactive table for geography of interest. The interactive table is a very useful tool when used in combination with the GIS application.

What’s next is data integration. Upcoming posts will review similar, but different, updated block group demographics and their use with data reviewed here. See the main block group Web page.

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.