Monthly Archives: September 2017

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.

Congressional District & State Legislative District Data Analytics

.. updates on tools, data resources and methods to analyze congressional districts and state legislative districts. Join the Congressional District/State Legislative District Group to receive updates. See details.

Visual Analysis of 115th CDs & 2016 Cycle SLDs
Topeka, KS metro and Kansas State House Districts

Topeka, KS metro: bold brown semi-transparent boundary
115th Congressional Districts: bold orange boundary.
State house districts: black boundary; yellow label showing code.
Topeka city: green fill pattern (entirely with in 115th CD KS02)

See related Web section with more detail.

Analyzing Congressional Districts & State Legislative Districts
– in context of other geography
Illustrative GIS views of examining CDs & SLDs in context
using GIS tools and data

New ACS 2016 1-Year Demographic-Economic Estimates
– American Community Survey 2016 (ACS2016) data for each 115th CD
– Released 9/14/17
… upcoming … interactive tables using these data
… similar to ACS2015 interactive tables

New 115th CD & 2016 SLD Shapefiles
– New 2017 TIGER/Line shapefiles to be released in September
– See about related 2016 vintage data
– These shapefiles may be used with most any GIS software
… map the most current CDs/SLDs in context with other geography

New 115th CD & 2016 SLD Equivalence File
– Flat files with a record for each intersecting SLD and CD
– Developed by ProximityOne; available October 2017
– Functionally similar to relating ZIP codes to census tracts

New Census 2010 Summary File 1 Data for 115th CDs & 2016 SLDs
– Updated Census 2010 Summary File 1 data
– Provides Census 2010 demographic data for 115th Congressional Districts
– Expected October 2017

Ahead in December
– Demographic-economic data for each 2016 cycle state legislative district
– Based on American Community Survey 2016 5-year estimates (ACS1116)
– See related SLD 2014 main page

Related sections & Resources
115th Congressional Districts interactive table with incumbent details
Making Custom 115th CD maps and geospatial analysis
– Congressional Districts main page — http://proximityone.com/cd115.htm

CD & SLD 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.

Important Upcoming Data Releases: September 2017

.. monthly updates on recent & upcoming data analytics tools & resources .. this section provides a monthly update on important new data developments and applications/developments to further their use in data analytics. A focus of this section is on new or revised geographic, demographic and economic data. Most of these data are used to develop and update ProximityOne census tract-level up demographic-economic projections to 2022 and county-level up population by single year of age projections to 2060. See about September projection updates below on this page. This section is organized into recent past data updates and upcoming (month ahead) data releases and may be updated to reflect new or extended details. See related news and updates:
• What’s New daily updates
• Situation & Outlook Calendar

See related Web section.

Recent Past Data Releases/Access

U.S. by Census Tract 2017 HMDA Low & Moderate Income (FFIEC)
• Release date — 8/17; next update — mid 2018
• 2017 annual HMDA data — covers all income levels not only LMI
• New 2017 HMDA data
• See more information – access data.

U.S. by County Population by Single Year of Age (NCHS)
• Release date — 8/22/17; next update — mid 2018
• 2010 through 2016 annual population by single year of age
• New 2016 data extending annual series 2010 forward
• See more information – access updates.

Housing Price Index (FHFA)
• Release date — 8/22/17; next update — 11/28/17
• Quarterly HPI
• New 2017Q2 data extending quarterly time series.
• See more information – access updates.

Quarterly Gross Domestic Product by State (BEA)
• Release date — 9/20/17; next update — 11/21/17
• Quarterly GDP by Industry
• New 2017Q1 data extending quarterly time series.
• See more information – access data.

Upcoming Data Releases/Access 

2017 TIGER Digital Map Database (Census)
• Expected ~ 9/7/17
• Topologically Integrated Geographic Encoding & Referencing (TIGER) data.
• Geographic data; predominately shapefiles.
.. intersection to intersection road segment geography and attributes.
• New 2017 GIS/mapping shapefiles for use with wide-ranging data
.. including with Census 2010, ACS 2016 & other subject matter.
• See more information – updates to access summarized in that section.

Census of Employment and Wages (BLS/CEW)
• Release date — 9/6/17; next update — 12/5/17
• AKA ES-202 data — establishments, employment & wages by NAICS code/type of business
• U.S. by county.
• New 2017Q1 data extending quarterly time series.
• See more information.

2016 American Community Survey 1-year estimates (Census/ACS)
• Release date — 9/14/17
• Wide-ranging demographic-economic data for areas having population 65,000+
.. all states, CDs, PUMAs, MSAs and larger cities/CBSAs/school districts/counties (817 of 3142)
• New 2016 estimates.
• See more information – updates to access summarized in that section.

SY 2015-16 Annual School & School District Characteristics (NCES)
• Expected ~ 9/14/17
• National school school & school district characteristics.
• New 2015-16 school year administratively reported data.
• Schools … see more information – access updates.
• School District … see more information – access updates.

2016 Annual Gross Domestic Product by Metro (BEA)
• Release date — 9/20/17
• GDP by Industry by Metro
• New 2016 data extending time series
• See more information – access updates.

Census Tract Estimates and Projections to 2022 — ProximityOne
• Release data ~ 9/27/17
• National census tract and higher level geography demographic-economic updates
• Annual estimates & projections; 2010 through 2022
• Updated to reflect/integrate data released through 9/2017 as summarized above   • See more information.

County Population by Single Year of Age Projections to 2060 — ProximityOne
• Release data ~ 9/27/17
• National county and higher level geography demographic updates
• Annual estimates & projections; 2010 through 2060
• Updated to reflect/integrate data released through 9/2017 as summarized above.   • See more information.

Notes [goto top]
– BEA – Bureau of Economic Analysis
– BLS – Bureau of Labor Statistics
– Census – Census Bureau
– FFIEC – Federal Financial Institutions Examination Council
– FHFA – Federal Housing Finance Agency
– NCES – National Center for Education Statistics
– NCHS – National Center for Health Statistics

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.