About the Data used in EconQuery



Source : The Occupation data used in EconQuery originates with the WA State Employment Security Dept: Labor Market Economic Analysis.

More information can be found at : Learn About an Occupation

Information regarding the Occupation Employment Statistics program can be found at the Bureau of Labor Statistics' website.

The Estimated and Projected Employment including Growth Rates and Total Openings are from the 2nd Quarter 2010 - 2nd Quarter 2012 projections series.

The wage data are from the March 2011 release.

The UI Ratio is based on 2nd Quarter 2010

The icons used to describe the data are :

iconapplies toindicates
Demand DesignationDemand
Demand Designationnot in demand
Demand Designationbalanced
Demand Designationdata not available
Trendgrowth
Trenddecline
Trendstable
Trenddata not available

The Demand Designations and Rankings are determined by five factors which are weighted to determine a final ranking for each occupation. These are as follow:

1. Combined rank for short-term (second quarter of 2010 to second quarter of 2012) and long-term (2009-2019) occupational projections (weight = 40%).

2. Unemployment Insurance Ratio 2010 (weight = 15%) :  The UI Ratio is the number of unemployment insurance claims divided by estimated employment for second quarter 2010.

3. Change in Unemployment Insurance Claims (15%):  The percentage change in unemployment claims by occupation from 2005 to 2010.

4. Job Vacancy Survey (15%): Number of statewide job openings collected from the spring 2011 Job Vacancy Survey.

5. Help Wanted OnLine (HWOL) Ratio (15%): The average number of Help Wanted OnLine Advertisements in 2010.

After each occupation has been ranked, the designations are made as follows:

  The occupations in the top third percentile are designated 'Demand',

  The occupations in the middle third percentile are designated 'Balanced', and

  The occupations in the bottom third percentile are designated 'Not in Demand'.

(Those occupations for which there is not sufficient information are given no ranking).

Source : WA State Employment Security Dept: Labor Market Economic Analysis    

In the Spring of 2011 there was a SOC Code revision that affected Occupational Data.

The Standard Occupational Codes (SOC) is the coding system employed by the Bureau of Labor Statistics to classify occupations.

Unfortunately, this happened to affect numerous occupations that are in 'High Demand'. For example,

Occupational TitleStatewide Demand Rank2010 SOC Code2000 SOC Code
Software Developers, Applications115-113215-1031
Software Developers, Systems Software215-113315-1032
Registered Nurses1015-113229-1111

Some Occupations were entirely discombulated, such as, Business Operations Specialists, All Other, which ended up being re-assigned to 3 occupations ('Meeting, Convention, and Event Planners', 'Market Research Analysts and Marketing Specialists' as well as to 'Business Operations Specialists, All Other')

For reasons such as this, some occupations may be unrepresented in EconQuery.

A crosswalk depicting the relationship between new 2010 SOC Codes to previous 2000 SOC Codes can be found here.

Documentation for Local Employment Dynamics data series can be found at the LED Census Bureau site :
lehd.did.census.gov/.   This site includes a variety of tools, such as, QWI On-line and On the Map.


Google as part of their Public Data efforts has put together two Local Employment Dynamics data series for the states of Arizona and Maine.

A good demonstration of the Quarterly Workforce Indicators being utilized in an Analysis Services cube can be found here:
Show me the cube. (Requires Adobe FlowPlayer plugin.)

The terms 'Local Employment Dynamics' (LED) and 'Quarterly Workforce Indicators' (QWIs) are used interchangeably on this site. However, the Quarterly Indicators are actually a subset of a much larger body of LED data (including On the Map). Since only the QWI series is utilized on EconQuery this distinction is not made.

The Local Employment Dynamics data series is complex. If you discover errors, please let us know by using the Contact Us link at the bottom of the page or by e-mailing us at postmaster@econquery.com.

Mismatches may occur due to different release dates of the data used at the Census Bureau QWI site and those employed by EconQuery. The below table depicts the release dates of data on QWI online and this site:

StateCensus Series DateEconQuery Series Date
California2011 q12011 q1
Florida2011 q12011 q1
Hawaii2011 q12011 q1
New York2011 q12011 q1
Oregon2011 q12011 q1
Vermont2011 q12011 q1
Virginia2010 q42010 q4
Washington State2011 q12011 q1

Every effort is made to keep the data as up to date as possible.