Category Archives: Unemployment

The Local Area Monthly Employment Situation

.. in June 2019, the local area unemployment rate ranged from 1.3% (Lyon County, IA) to 19.6% (Yuma County, AZ) among the lower 48 states. 133 counties had an unemployment rate of 7% or more during June 2018 through June 2019. Over the past year, as shown in the this interactive table, the unemployment rate has generally decreased among all counties. We track the local area employment situation historically and develop alternative scenario projections. See the related Web page for more information.

Patterns of Unemployment Rate by County
The following graphic shows patterns of the estimated June 2019 unemployment rate by county. Use the GIS tools and data to develop variations of this view optionally integrated with other data. Click graphic for larger view. Expand browser window for best quality view.

— view created using the ProximityOne CV XE GIS and associated GIS Project

Examine Areas of Interest
This graphic illustrates the monthly over the year employment situation for the Houston, TX metro using the interactive table.

Click graphic for larger view.

Create a similar table for any metro:
Open the interactive table (green and white table midway down).
Click ShowAll button below table.
Key in a 5-character metro code in edit box at right of FindCBSACode.
    … get from scroll list at upper right of table.
    … e.g., 19100 for Dallas, TX metro.
Click FindCBSACode; table refreshes showing only counties in this metro.
Click Current Situation button below table; table refreshes with selected columns.
Click the Pop2018 column header cell twice to rank-order the columns.
Done .. try these steps for an area of interest.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics 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.

Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using 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.

Monthly Local Area Employment Situation; 2015-2016

.. this update on the monthly and over-the-year (August 2015-August 2016) change in the local area employment situation shows general improvement. Yet many areas continue to face challenges due to both oil prices, the energy situation and other factors.  This section provides access to interactive data and GIS/mapping tools that enable viewing and analysis of the monthly labor market characteristics and trends by county and metro for the U.S. See the related Web section for more detail. The civilian labor force, employment, unemployment and unemployment rate are estimated monthly with only a two month lag between the reference date and the data access date (e.g., August 2016 data are available in October 2016).

Unemployment Rate by County – August 2016
The following graphic shows the unemployment rate for each county.

— view created using CV XE GIS and associated LAES GIS Project
— click graphic for larger showing legend details.

As shown in the illustrative interactive table view below, seven of the ten MSAs having the highest August 2016 unemployment rate were in California. Use the table to examine characteristics of counties and metros in regions of interest. As apparent from the monthly patterns shown in the table, some areas are impacted by season factors, but others are not.

View Labor Market Characteristics section in the Metropolitan Area Situation & Outlook Reports, providing the same scope of data as in the table below integrated with other data. See example for the Dallas, TX MSA.

The LAES data and this section are updated monthly. The LAES data, and their their extension, are part of the ProximityOne Situation & Outlook database and information system. ProximityOne extends the LAES data in several ways including monthly update projections of the employment situation one year ahead.

Interactive Analysis
The following graphic shows an illustrative view of the interactive LAES table. Seven of the ten MSAs having the highest August 2016 unemployment rate were in California (ranked on far right column in descending order). Use the table to examine characteristics of counties and metros in regions 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.

State and Regional Decision-Making Information

Organized on a state-by-state basis, use tools and geographic, demographic and economic data resources in these sections to facilitate planning and analysis. Updated frequently, these sections provide a unique means to access to multi-sourced data to develop insights into patterns, characteristics and trends on wide-ranging issues. Bookmark the related main Web page; keep up-to-date.

Using these Resources
Knowing “where we are” and “how things have changed” are key factors in knowing about the where, when and how of future change — and how that change might impact you. There are many sources of this knowledge. Often the required data do not knit together in an ideal manner. Key data are available for different types of geography, become available at different points in time and are often not the perfect subject matter. These sections provide access to relevant data and a means to consume the data more effectively than might otherwise be possible. Use these data, tools and resources in combination with other data to perform wide-ranging data analytics. See examples.

Select a State/Area

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
D.C.
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

Topics for each State — with drill-down to census block
Visual pattern analysis tools … using GIS resources
Digital Map Database
Situation & Outlook
Metropolitan Areas
Congressional Districts
Counties
Cities/Places
Census Tracts
ZIP Code Areas
K-12 Education, Schools & School Districts
Block Groups
Census Blocks

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.

Tools to Analyze the Local Area Employment Situation

.. December 2015; updated monthly … current, monthly data on the employment situation are essential to assess recent trends. The only historical source of these data for all metropolitan areas, counties and sub-county areas is the Bureau of Labor Statistics (about these data). The civilian labor force, employment, unemployment and unemployment rate are estimated monthly with only a two month lag between the reference date and the data access date (e.g., February 2016 data are available in April 2016). Historical monthly seasonally adjusted and non-adjusted time-series data are available. Use tools and resources provided/described in this section to access and analyze these Local Area Employment Situation (LAES) data. See related Web page with interactive ranking table.

Unemployment Rate by Metro
The following graphic shows the unemployment rate by metro.
— view created using CV XE GIS and associated LAES GIS Project

The LAES data and this section are updated monthly. The LAES data, and their their extension, are part of the ProximityOne Situation & Outlook database and information system. ProximityOne extends the LAES data in several ways including monthly update projections of the employment situation one year ahead.

Use the interactive table in the related Web page to view, sort, compare employment situation characteristics by Core-Based Statistical Area (CBSA) — metropolitan and micropolitan statistical areas.

Analyze Labor Market Characteristics in Context of Other Data
The Metropolitan Area Situation & Outlook Reports provide a labor market characteristics monthly time-series table. Select a metro using this interactive table. Examine the labor market data in context with wide-ranging related demographic-economic data.

Visual Pattern and GeoSpatial Analysis
Use the CV XE GIS software and LAES GIS project to create thematic pattern maps and integrate the employment situation data with other data. ProximityOne User Group members may install the LAES GIS Project at no fee and prepare thematic pattern maps like the one shown above and below. The map shown below shows the unemployment rate for each CBSA for a year earlier than the above map. Compare the maps and see how patterns have changed.

— view created using CV XE GIS and associated LAES GIS Project

Using the LAES GIS Project
Use the LAES GIS Project to develop maps, such as those shown above, and perform geospatial analysis operations. The LAES GIS Project updates monthly as new data become available. The CBSA layer/shapefile includes monthly civilian labor force, employment, unemployment and unemployment rate estimates for each month from January 2014 through the most recent estimate month (e.g., the December 2015 release includes monthly data from January 2014 through October 2015). Steps to develop custom thematic pattern maps are summarized below (requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the LAES GIS project fileset
… requires ProximityOne User Group ID (join now, no fee)
… unzip LAES GIS project files to local folder c:\laes
3. Open the c:\laes\laes1.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\laes\laes1.gis
4. Done. The start-up view is shown at top of this section.

Join me in a Data Analytics Lab session to discuss accessing, integrating and using these data with other data that relate to your situation.

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.

Resources to Analyze the Local Area Employment Situation

.. April 2015; updated monthly … current, monthly data on the employment situation are essential to assess recent trends. The only historical source of these data for all metropolitan areas, counties and sub-county areas is the Bureau of Labor Statistics (about these data). The civilian labor force, employment, unemployment and unemployment rate are estimated monthly with only a two month lag between the reference date and the data access date (e.g., February 2015 data are available in April 2015). Historical monthly seasonally adjusted and non-adjusted time-series data are available. Use tools and resources provided/described in this section to access and analyze these Local Area Employment Situation (LAES) data. See related Web page with interactive ranking table.

February 2015 Unemployment Rate by Metro (CBSA)
The following graphic shows the February 2015 unemployment rate by metro.
— view created using CV XE GIS and associated LAES GIS Project

The LAES data and this section are updated monthly. The LAES data, and their their extension, are part of the ProximityOne Situation & Outlook database and information system. ProximityOne extends the LAES data in several ways including monthly update projections of the employment situation one year ahead.

Use the interactive table in the related Web page to view, sort, compare employment situation characteristics by Core-Based Statistical Area (CBSA) — metropolitan and micropolitan statistical areas.

Visual Pattern and GeoSpatial Analysis
Use the CV XE GIS software and LAES GIS project to create thematic pattern maps and integrate the employment situation data with other data. ProximityOne User Group members may install the LAES GIS Project at no fee and prepare thematic pattern maps like the one shown above and below. The map shown below shows February 2014 unemployment rate for each CBSA (a year earlier than the above map). Compare the maps and see how patterns have changed.

— view created using CV XE GIS and associated LAES GIS Project

Using the LAES GIS Project
Use the LAES GIS Project to develop maps, such as those shown above, and perform geospatial analysis operations. The LAES GIS Project updates monthly as new data become available. The CBSA layer/shapefile includes monthly civilian labor force, employment, unemployment and unemployment rate estimates for each month from January 2013 through the most recent estimate month (e.g., the April 2015 release includes monthly data from January 2013 through February 2015). Steps to develop custom thematic pattern maps are summarized below (requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the LAES GIS project fileset
… requires ProximityOne User Group ID (join now, no fee)
… unzip LAES GIS project files to local folder c:\laes
3. Open the c:\laes\laes1.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\laes\laes1.gis
4. Done. The start-up view is shown at top of this section.

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.

Local Area Labor Force Characteristics

.. on the one hand, there are many choices for accessing and using local area labor force characteristics data; on the other, the available options often fall short of meeting the needs.  This section provides a guide to accessing, integrating and using selected local area labor force characteristics data for wide-ranging analysis and decision-making applications. A “local area” as used here refers mainly to city/place, county and sub-county geography (census tract and ZIP Code area). See related Web section.

ACS 2013 Employment Situation by ZIP Code Area
  — Using GIS Tools for Visual & Geospatial Analysis

The American Community Survey (ACS) 5-year estimates have evolved into a primary resource for examining labor force characteristics. One important limitation is the time lag between data availability and reference date. The ACS 2013 data (released December 2014) are for the 5-year period 2009-2013 and centric to mid-2011; in mid-2015 these estimates are 4 years old.

However, these data can provide powerful insights. The following graphic shows the percent unemployed by ZIP Code area in the Houston, Texas/Harris County (bold black boundary) area. The ACS 2013 5-year estimates of the unemployment rate, included in the interactive table below, are shown as a thematic map. It is easy to see which areas/ZIP codes are experiencing higher/lower unemployment rates.

Click for larger view; larger view shows mini-profile of ZIP Code 77077.
See more ZIP Code demographic-economic data resources.
View created using CV XE GIS.

This section updates in mid-March (watch in calendar) with new data access information relating to data resources summarized below. The present version of this section is focused on:
1) upcoming updates to the Bureau of Labor Statistics Local Area Unemployment
Statistics program and how this affects labor force data availability and use and
2) an interactive table providing access to ZIP Code area labor force
characteristics based on the American Community Survey 2013 5-year data.

Overview
Statistical programs that provide local area labor force data include:
American Community Survey
  — annual updates, place of residence based
  — geography: block group, ZIP Code area, city/place, census tract up
  — only the ACS provides labor force data for every congressional district
• ProximityOne current estimates and projections
  — annual updates, place of work & residence based
  — geography: ZIP Code area, city/place, census tract up
• BLS Local Area Unemployment Program (city/place, county up) — see below
• BLS Quarterly Census of Employment and Wages
  — quarterly, long time series, place of work based;
  — geography: county up
• BEA Regional Economic Information System
  — annual, long time series
  — geography: county up
• Decennial census Census 2000 and earlier

Advantages/disadvantages, strengths/weaknesses and more about accessing, integrating and using these data will be included in the mid-March update.

BLS LAUS Program. Effective with the March 2015 release of the Bureau of Labor Statistics Local Area Unemployment Statistics (LAUS) estimates for metropolitan areas and smaller geography, new data and methodology are available for analyzing local area employment patterns. These new data have several far-reaching implications for local area labor force analysis.

The fact that the new data are for the 2013 current vintage metropolitan areas CBSAs is very important. It makes the LAUS data consistent with CBSA geography used in other Federal statistical programs including the the American Community Survey (ACS).

The new LAUS estimation methodology makes the local area employment and unemployment estimates more consistent with ACS data which are used in the LAUS estimation. Use of the annually updated ACS data in the LAUS estimates development is an important update to Census 2000-related data previously used in the estimation process. Other methodological changes should lead to more accurate and useful local area employment estimates for sub-county areas not otherwise available.

ACS 2013 Labor Force Characteristics by ZIP Code Area
  — Interactive Table

Use the interactive table in the related Web section to view, rank, compare, query selected labor force characteristics by ZIP code area. These data are based on the ACS 2013 5 year estimates (same data as used in map view above).

Houston area ZIP Code 77007 (shown at pointer in this view) has an ACS 2013 5-year estimated unemployment rate of 3.8%. See ZIP code 77007 in context of all Texas ZIP code areas in the following graphic (click for larger view). Among all 1,934 Texas ZIP code areas, ZIP code 77007 is ranked 201 (there are 200 ZIP code areas with a lower unemployment rate).

Use the interactive table to perform similar analyses on ZIP code areas of interest.

See the main Local Area Labor Force Web section for mid-March updates (watch in calendar).

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.

State & Metro Demographic-Economic Interactive Tables

Goto ProximityOne   New U.S. national scope state and metropolitan area demographic-economic interactive tables are now available.  These tables include approximately 600 subject matter items derived from the American Community Survey 2012 1-year estimates.

The interactive tables are organized into four related sections:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

Use the interactive ranking tables to view, query, rank, compare demographic-economic characteristics of the population and housing for states and/or metros of interest.  A scroll box is provided for each section that lists each of the subject matter items available for each area in the table.

Importance of these Data
These data provide “richer” demographic-economic characteristics for national scope states and metros. While Census 2010 provides data similar to those items in the General Demographics section, only ACS 2010, 2011, 2012 sourced data provide details on topics such as income and poverty, labor force and employment, housing value and costs, educational participation and attainment, language spoken at home, among many related items. The approximate 600 items accessible via the tract dataset are supplemented by a wide range of additional subject matter.  ACS 2013 state and metro data become available in September 2014.

County Monthly Workforce Trends

Goto ProximityOne  Keep up-to-date with current county monthly workforce patterns and trends using the CV APIGateway. Automatically updated with multi-sourced demographic-economic data, the APIGateway Integrated Profile (IP) provides monthly workforce updates from the Bureau of Labor Statistics (BLS) Census of Employment and Wages (place of work data) and Local Area Unemployment Statistics (LAU – place of residence data). This section is focused on data and analytical tools to examine county workforce trends and patterns using the Local Area Unemployment Statistics data.

A unique and important property of the LAU data is that they are the only source of semi-official data available on a national scale for each/all counties and larger places providing current and monthly data on unemployment and the unemployment rate. The next runner-up to these estimates are the ACS 5 year estimates that are a) for a five year period and b) at least 3 years old (to the mid-point of the estimate period) when they become available. These highly perishable and time-sensitive economic measures are important to understanding the relative and absolute strength or weakness of workforce conditions and the employment sector on a local and regional basis.

The table presented below is a section taken from the APIGateway IP for Santa Clara County, CA (San Jose-Cupertino metro). The monthly/annual LAU data shown in the table are available for each/all counties. The APIGateway IP shows these four workforce series from 2011 forward. It auto-updates monthly with only a two-month lag to the reference time period. View a series as a chart: click graphic; on new page click a link shown in the table. Optionally set a wider time interval.
Santa Clara County, CA Monthly Labor Force Characteristics
lau_sc1

Using GIS Resources for Visual Pattern Analysis
Separate from the APIGateway IP, the 2008-2012 annual time series data have been integrated into a U.S. by county shapefile. The graphic shown below illustrates how these tools can be used to examine the change in employment conditions by county since the recession started. This view shows the change in the unemployment rate from 2008 to 2012. Counties with red coloring experienced/are experiencing/ a 3-percent or more increase in the unemployment rate in 2012 compared to 2008. Using this measure alone, it is easy to see the extent to which the economy in many areas is still struggling to compensate for the recession impact and exactly which county/regional areas are impacted and how much. While one county might be prospering, many adjacent or nearby counties are not. View zoom-in to Santa Clara county area.

Interactive Table
Click the graphic shown below to use this interactive table to examine this same set of annual workforce data 2008-2012. Viewing the interactive table, click ShowAll button below table and then FindInName with default value “Santa Clara” to view the 5-year series for the same scope of subject matter as shown above in monthly form. The interactive table provides a convenient structure to view, rank, compare counties using these measures.

lau_table

Next Steps
The U.S. by county shapefile with workforce data shown in the table and used to develop maps shown in this section are available to ProximityOne User Group members. (join now, no cost). Use these resources to develop wide-ranging variations of this view and analyze tabular data on your own computer; integrate your own data; add other types of geography; zoom-in to specific metros/regions. Visit the CountyTrends Web section for more information on county demographic-economic data and analytics.