Category Archives: Trends

Analyzing Block Group Demographics

.. tools & data to analyze sub-census tract households, education, income, housing, more … Block Groups, subdivisions of census tracts, are the smallest geographic areas for which “richer demographics” are developed by the Census Bureau. Block group demographic-economic estimates, based on Census 2010 geography, are annually updated beginning with American Community Survey (ACS) 2010. The latest ACS estimates for these 217,740 areas covering U.S. wall-to-wall are from ACS 2015. The ACS 2016 update will be released in December 2017.  See the related Web section for more detail about accessing and using block group geography and demographic-economic data.

Patterns of Economic Prosperity by Block Group
The following graphic shows patterns of median household income by block group in the Houston, TX area. Markers show block groups with 10 or more housing units having value of $2 million or more. Markers are labeled with the number of housing units having value of $2 million or more in that block group. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using block group demographics and the relative ease to gain insights using geospatial data analytics tools.

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

Block Group Demographic-Economic Data & Shapefiles
… selection of key demographic-economic attributes; annual update
… subject matter categories include:
  • Total population>
  • Population by gender iterated by age
  • Population by race/origin
  • Households by type of household
  • Educational attainment by detailed category
  • Household Income by detailed category
  • Housing units by owner/renter occupancy
  • Housing units by units in structure
  • Housing units by detailed value intervals

See the related Web section for a detailed list of items.

Use these Data on Your Computer
Use the above U.S. national scope dataset with your own software or in ready-to-use GIS projects with the CV XE GIS software.

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.

U.S. State Capital City Demographic-Economic Characteristics

.. tools and data to examine demographic-economic characteristics of each U.S. State capital city. The profiles are part of the America’s Communities Program. The profiles help stakeholders know “where we are”, how things are changing where and by how much, and how things might change in the future. See related web section for more detail.

State Capital Cities
The following graphic shows state capital city locations as markers. This view was developed using GIS tools enabling creation of similar views in context of other geography and subject matter. Orange markers are cities with less than 65,000 population; blue markers are cities with more than 65,000 population. based on percent population change. Click graphic for larger view. Larger view shows city names and urban areas. Expand browser window for best quality view.

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

State Capital City Demographic-Economic Profiles
State capital cities are listed below organized by state. Click the link within the brackets to view a demographic-economic profile for that city. The 2016 total population is shown in parentheses.

Alabama
• Montgomery, AL [0151000] (200,022)
Alaska
• Juneau, AK [0236400] (32,468)
Arizona
• Phoenix, AZ [0455000] (1,615,017)
Arkansas
• Little Rock, AR [0541000] (198,541)
California
• Sacramento, CA [0664000] (495,234)
Colorado
• Denver, CO [0820000] (693,060)
Connecticut
• Hartford, CT [0937000] (123,243)
Delaware
• Dover, DE [1021200] (37,786)
District of Columbia
• Washington, DC [1150000] (681,170)
Florida
• Tallahassee, FL [1270600] (190,894)
Georgia
• Atlanta, GA [1304000] (472,522)
Hawaii
• Honolulu, HI [1571550] (351,792)
Idaho
• Boise City, ID [1608830] (223,154)
Illinois
• Springfield, IL [1772000] (115,715)
Indiana
• Indianapolis, IN [1836003] (855,164)
Iowa
• Des Moines, IA [1921000] (215,472)
Kansas
• Topeka, KS [2071000] (126,808)
Kentucky
• Frankfort, KY [2128900] (27,885)
Louisiana
• Baton Rouge, LA [2205000] (227,715)
Maine
• Augusta, ME [2302100] (18,494)
Maryland
• Annapolis, MD [2401600] (39,418)
Massachusetts
• Boston, MA [2507000] (673,184)
Michigan
• Lansing, MI [2646000] (116,020)
Minnesota
• St. Paul, MN [2758000] (302,398)
Mississippi
• Jackson, MS [2836000] (169,148)
Missouri
• Jefferson City, MO [2937000] (43,013)
Montana
• Helena, MT [3035600] (31,169)
Nebraska
• Lincoln, NE [3128000] (280,364)
Nevada
• Carson City, NV [3209700] (54,742)
New Hampshire
• Concord, NH [3314200] (42,904)
New Jersey
• Trenton, NJ [3474000] (84,056)
New Mexico
• Santa Fe, NM [3570500] (83,875)
New York
• Albany, NY [3601000] (98,111)
North Carolina
• Raleigh, NC [3755000] (458,880)
North Dakota
• Bismarck, ND [3807200] (72,417)
Ohio
• Columbus, OH [3918000] (860,090)
Oklahoma
• Oklahoma City, OK [4055000] (638,367)
Oregon
• Salem, OR [4164900] (167,419)
Pennsylvania
• Harrisburg, PA [4232800] (48,904)
Rhode Island
• Providence, RI [4459000] (179,219)
South Carolina
• Columbia, SC [4516000] (134,309)
South Dakota
• Pierre, SD [4649600] (14,008)
Tennessee
• Nashville, TN [4752006] (660,388)
Texas
• Austin, TX [4805000] (947,890)
Utah
• Salt Lake City, UT [4967000] (193,744)
Vermont
• Montpelier, VT [5046000] (7,535)
Virginia
• Richmond, VA [5167000] (223,170)
Washington
• Olympia, WA [5351300] (51,202)
West Virginia
• Charleston, WV [5414600] (49,138)
Wisconsin
• Madison, WI [5548000] (252,551)
Wyoming
• Cheyenne, WY [5613900] (64,019)

Related Demographic-Economic Interactive Tables
Use the national scope demographic-economic interactive tables to view, rank, compare selected or all cities/places (approximately 29,500 places) using an extended set of data as used in the community profiles. The data are based the American Community Survey 2015 5-year estimates and organized into four subject matter groups:
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

See the related city population trends 2010-2016 interactive table to view, query, rank compare each cities are changing over time.

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.

City Population Characteristics & Trends: 2010-2016

.. the change in U.S. city population from 2010 to 2016 ranged from growth of 345,647 in New York City to a decline of -38,293 in Detroit, MI. New York City is actually five counties; the next largest city growth was Houston, TX with a 197,857 population gain.  Examine how the population is changing in cities of interest using the interactive table and other tools described in this post.  Use the interactive table to view a selected city, all cities in a state, cities in a county, cities in a metro or cities in a peer group size class.  See related Web section for more details.

Use the U.S. by cities shapefile with your GIS projects. See details. Thematic pattern maps illustrating use of these resources are shown below.

The July 1, 2016 Census Bureau model-based estimates (see about these data) for the U.S. 19,510 incorporated cities show a total population of 203,314,546 compared to 192,174,578 as of Census 2010. These areas are incorporated cities as recognized by their corresponding state governments and granted certain governmental rights and responsibilities.

Patterns of City Percent Change in Population 2010-16
— Cities 10,000 Population & Over
Use the CV XE GIS software with cities GIS project to examine characteristics of city/place population, 2010-2016. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more. Use the interactive table below to see that among cities with 2016 population of 10,000 and over that Buda, TX had the largest percent change (98.8%) while Avenal, CA experienced the largest percent decrease (-18.4).

– View developed using the CV XE GIS software.
– Click graphic for larger view.

Fastest Growing Cities in the Dallas, TX Metro
— Cities 10,000 Population & Over; create views like this for any metro/county
It is easy to see which cities are growing the fastest using the thematic pattern view below. It is also easy to see how the cities relate to each other geographically and in context of county boundaries. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more in the Dallas metro area.

– View developed using the CV XE GIS software.

Drill-down — Fastest Growing Cities in the Dallas, TX Metro
— Cities 10,000 Population & Over
Zoom into the north Dallas metro area and label the cities with name. The following view shows patterns of population percent change, 2010-16 for cities with 2016 population of 10,000 or more in the Dallas metro area.

– View developed using the CV XE GIS software. Click graphic for larger view; expand browser window for best quality view.

City/Place Demographics in Context
State & Regional Demographic-Economic Characteristics & Patterns
.. individual state sections with analytical tools & data access to block level
Metropolitan Area Situation & Outlook
.. continuously updated characteristics, patterns & trends for each/all metros
Related City/Place Demographic-Economic Interactive Tables
ACS 2015 5-year estimates
.. General DemographicsSocialEconomicHousing Characteristics

Using the Interactive Table
Use the full interactive table to examine U.S. national scope cities by annual population and change 2010-2016. The following graphic illustrates use of the table to view the largest cities ranked on 2016 population. Use the tools/buttons below the table to create custom views.

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.

Life Expectancy Change by County, 1980-2014

.. data and tools to examine changing life expectancy by county. Use the interactive table to examine life expectancy characteristics and related demographics for counties and regions of interest. Use the related GIS project and datasets to examine life expectancy contextually with other geography & subject matter. See details below. These data and tools are part of the ProximityOne health data analytics resources.

Life expectancy is rising overall in the United States, but in some areas, death rates are going in the other direction. These geographic disparities are widening.

Life Expectancy Change by County, 1980-2014
The following graphic shows patterns of the change in life expectancy change from 1980 to 2014. Click graphic for larger view. Expand browser window for best quality view.

– View developed using CV XE GIS and related GIS project.
– see below in this section about using this GIS project.

Life expectancy is greatest in the high country of central Colorado, but in many pockets of the U.S., life expectancy is more than 20 years lower. These data are based on research and analysis by the University of Washington Institute for Health Metrics and Evaluation.

Examining life expectancy by county allows for tracking geographic disparities over time and assessing factors related to these disparities. This information is potentially useful for policymakers, clinicians, and researchers seeking to reduce disparities and increase longevity.

Life Expectancy Change by County, 1980-2014 — drill-down view
— South Central Region
The following graphic shows patterns of the change in life expectancy change from 1980 to 2014. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows counties labeled with change in life expectancy from 1980-2014.

– View developed using CV XE GIS and related GIS project.
– see below in this section about using this GIS project.

Additional Views — use the GIS project to create your own views
.. click link to view
Alaska
Hawaii
Minneapolis metro

Using the Interactive Table
Use the interactive table to view, rank, compare life expectancy characteristics. This graphic shows California counties ranked on life expectancy change 1980-2014 in descending order. Select states or metros of interest. 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.

Examining Houston Metro Demographic-Economic Characteristics

.. tools & data to examine metro demographic-economic characteristics .. this Houston, TX metro focused section is one of several similar metro sections that will be covered in weeks ahead.  Each metro-focused section provides a summary of tools and data that can be used to view, rank, compare, analyze conditions and trends within the metro and this metro relative to other metros, regions and the Nation.  The ready-to-use GIS project/datasets provide the basis for extended data/geographic views and analysis immediately.  See more detail about topics covered in this related Web section.

Relating your data to demographic-economic characteristics and trends in a region involves more than information provided by a report or set of statistical tables. It is important to use your data to be able to identify areas of missed opportunity and competitive position. It is important to have a “10,000 foot” view as well as understanding individual neighborhoods and market/service areas. Geographic Information System (GIS) tools, with the right set of geographic, demographic and economic data can facilitate decision-making through the use of visual and tabular data analytics.

This section provides information on installing and using the Houston Metro Demographic-Economic GIS software and project/datasets. This same scope of data, tools and operation is available for any metro, state or combination.

10,000 Foot View
The following graphic shows patterns of median household income by census tract for the Houston metro area. This is the start-up view when using the GIS tools and data described below. The color patterns/intervals are shown in the highlighted layer in legend at left of map window. Use the GIS tools described below to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CVGIS software.

See more about census tracts; see tracts main page.

Several additional views follow, developed using this same GIS project. These views illustrate different levels of geographic granularity and patterns of different subject matter.

Median Household Value by Block Group
See more about block groups; see block groups main page.

.. view developed using the CVGIS software.

Population/Housing Unit by Block
See more about census blocks; see census block main page.

.. view developed using the CVGIS software.

Zoom-in to Sugarland/Fort Bend County
See more about cities/places; see cities/places main page.
Access data for any city using interactive table.

.. view developed using the CVGIS software.

Further Zoom-in Showing Street/Road Detail
See more about streets.

.. view developed using the CVGIS software.

Additional Information
See the related Houston metro Situation & Outlook Report.

Using the GIS Software and Project/Datasets
(requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… requires UserID; take all defaults during installation
2. Download the Houston Metro GIS project fileset
… requires UserID; unzip Houston Metro GIS project files to local new folder c:\p1data
3. Open the c:\p1data\us1_metros_houston.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\p1data\us1_metros_houston.gis
4. Done. The start-up view is shown above.

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.

115th Congressional Districts: Analysis and Insights

.. interpretative data analytics; tools, data & methods ..  this section is focused on 115th Congressional District geographic, demographic and economic patterns and characteristics. Use tools and data reviewed here to examine/analyze characteristics of one congressional district (CD) or a group of CDs based on state, party or other attribute. Use the GIS resources described here for general CD reference/pattern/analytical views, to examine current demographics and demographic change and for redistricting applications. See this related Web section for more details.

Examining the 115th Congressional Districts
• the 115th Congress runs from January 2017 through December 2018.
• FL, MN, NC, VA have redistricted since the 114th CD vintage;
  .. some 115th CDs have new boundaries compared the 114th CDs.
• view, rank, compare CDs using the interactive table.
  .. table uses ACS 2015 data for 115th CDs & include incumbent attributes.
  .. examine districts by party affiliation.
• use these more detailed 114th CD interactive tables
  .. data based on 2015 American Community Survey – ACS 2015.
  .. corresponding data for the 115th CDs from ACS 2016 available Sept 2017.
• use the new GIS project including 114th & 115th CDs described below.
  .. create CD thematic and reference maps;
  .. examine CDs in context of other geography & subject matter.
• join us in the April 25 Data Analytics Lab session

Visual Analysis of Congressional Districts
The following views 1) provide insights into patterns among the 115th CDs and 2) illustrate how 114th to 115th geographic change can be examined. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Household Income by 115th Congressional District
The following graphic shows the patterns of the median household income by 115th Congressional District based on the American Community Survey 2015 1-year estimates (ACS2015). The legend in the lower left shows data intervals and color/pattern assignment

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

Charlotte NC-SC Metro Area
  – with 114th/115th Congressional District 12

The following graphic shows North Carolina CD 12 with 114th boundary (blue) and 115th boundary (pale yellow) and Charlotte metro bold brown boundary. Click graphic for larger view with more detail. Expand browser window for best view.

.. view developed using the CVGIS software.

• View zoom-in to Charlotte city & Mecklenburg County.

115th Congressional District Interactive Table
Use the interactive table to examine characteristics of one congressional district (CD) or a group of CDs. The following graphic illustrates use of the interactive table. First, the party type was selected, Democratic incumbents in this example. Next, the income and educational attainment columns were selected. Third, the set of districts were sorted on median household income. It is quick and easy to determine that CA18 has the highest median household income and that the MHI is $1,139,900. Try using the table to examine districts of interest.

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.

County 5-Year Trends: Income & Income Inequality

.. tools and data to examine how the U.S. by county household income and income inequality are changing … how is household income changing in counties of interest? What are the trends; what is causing the change? What are the characteristics of income inequality and how is it changing? How might this change impact your living environment and business?

This section provides access to tools and data to examine U.S. by county measures of household income and income inequality between two 5-year periods (2006-10 and 2011-2015). These data can provide insights into how household income and income inequality are changing for one county, a group of counties and the U.S. overall. Use the interactive table to view median household income and measures income inequality for all counties. See more detail about these topics here. Measures of income inequality can be estimates/examined using the Gini Index.

The Gini Index & Measuring Income Inequality
The Gini Index is a dimensionless statistic that can be used as a measure of income inequality. The Gini index varies from 0 to 1, with a 0 indicating perfect equality, where there is a proportional distribution of income. A Gini index of 1 indicates perfect inequality, where one household has all the income and all others have no income.

At the national level, the 2015 Gini index for U.S. was 0.482 (based on 2015 ACS 1-year estimates) was significantly higher than in the 2014 ACS Index of 0.480 (based on 2014 ACS 1-year estimates). This increase suggests that income inequality increased across the country.

Examining Household Income & Income Inequality Patterns & Change
The following two graphics show patterns of the GIni Index by county. The first view is based on the American Community Survey (ACS) 2010 5-year estimates and the second is based on the ACS 2015 5-year estimates. The ACS 2010 estimates are based on survey respondents during the period 2006 through 2010. The ACS 2015 estimates are based on survey respondents during the period 2011 through 2015. One view compared with the other show how patterns of income inequality has changed at the county/regional level between these two 5-year periods.

Following these Income Inequality views are two corresponding views of median household income; using data from ACS 2010 and ACS 2015. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Income Inequality by County; ACS 2010
The following graphic shows the patterns of the Gini Index by county based on the American Community Survey 2010 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

Patterns of Income Inequality by County; ACS 2015
The following graphic shows the patterns of the Gini Index by county based on the American Community Survey 2015 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

Patterns of Economic Prosperity by County; ACS 2010
The following graphic shows the patterns of median household income ($MHI) by county based on the American Community Survey 2010 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

Patterns of Economic Prosperity by County; ACS 2015
The following graphic shows the patterns of median household income ($MHI) by county based on the American Community Survey 2015 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

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.