Tag Archives: BLS CEW

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.

Establishments, Employment & Earnings Trends: 2015Q1

.. county & metro Establishment, Employment & Earnings (EEE) monthly-quarterly-annual time series by detailed type of business .. financial sector employment in Manhattan (New York County, NY) led the nation in average weekly wages at $8,932 during the first quarter 2015.  Use the interactive table to examine characteristics of establishments (number, employment, earnings) for counties and metros by type of business of interest. See the related Web section for more detail.  Follow that section for quarterly and interim data establishments by sector updates and use of tools to analyze patterns and trends.

The most current and comprehensive measures of business activity by county, metro and higher level geography are provided by the Establishments, Employment & Earnings (EEE) database. Use the interactive table to view, rank, query, compare data on establishments, employment and wages by county, metro and state for high level industries. Subscribers to the ProximityOne Data Service (PDS) database can use the more detailed (6-digit NAICS coverage) with data structured for time-series analysis supported with modeling and data analytics tools.

Where Does America Make Things?
The graphic below shows percent employment in the manufacturing sector (employment in the private manufacturing sector as a percent of total private sector employment January 2015 by county). Click graphic for larger view providing more detail. Use the GIS tools to analyze similar patterns for any industry. Interpreting this map graphic and alternative data resources … join us in a Data Analytics Lab session where we discuss making and interpreting this map view and alternatives.

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

The EEE quarterly data are based on employer reported data and provide EEE characteristics by detailed type of business collected and tabulated by the Bureau of Labor Statistics (BLS). Derived from reports submitted by every employer subject to unemployment insurance (UI) laws, the data cover 9.5 million employers and 136.2 million full- and part-time workers.

Important features of these data …
• Tabulated for all counties, metros, states and the U.S.
• Tabulated for detailed types of business (6-digit NAICS).
• Tabulated quarterly and annually, the data enable time-series modeling.
• Employer-based administratively collected data; not estimates.
• Short lag (5 months) between reporting date and date of data accessibility
– data for second quarter 2015 (2015Q2) are available mid-December 2015.
Limitations of these data.

Use these data to examine how a detailed type of business is changing in a county or metro … or how that type of business in one county/metro compares to another county or metro. Answer questions like how much of the healthcare sector in a particular metro is comprised by offices of physicians. Or, are the number of establishments in a business sector growing or declining? How are the characteristics of establishments in one metro changing relative to another metro?

Establishments, Employment, Earnings — Interactive Table
The following graphic illustrate use of the interactive table to examine characteristics of construction industry for California by county. The rows/counties are ranked on the rightnost column AWW15Q1 (average weekly wages, 1st quarter 2015) in descending order. It is easy to see that California was led by San Francisco county with $1,661 AWW reflecting activity of 1,564 establishments and January employment of 16,850. Click graphic for larger view.

Updates
These data update quarterly. The next update includes data for 2015Q2 and becomes available December 17, 2015 (set reminder).

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.

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.