Tag Archives: Largest 50 metropolitan areas

Metro Quarterly Establishments, Employment & Earnings by Industry

.. data, tools and methods to analyze metro business  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 resources described here to analyze establishments, employment and wages by metro for the most recent quarter and over-the-year change — by quarter 2013 through 2015.  Updated quarterly, the 2016Q1 data become available September 7, 2016. See the related Web section for more details.

These metro by metro EEE datasets are  closely integrated with the metros Situation & Outlook reports. Click a CBSA code in the “Code” column in that table then select related section 6.6. to access/download quarterly data for a metro.

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 by county). This view illustrates how the EEE data can be used to develop insights.  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.

Two Key Data Resources
1) Use the interactive table in the Web section to example total establishments, employment and wages for any selected MSA and/or in comparison with other MSAs.

2) Download metro quarterly Establishments, Employment & Earnings (EEE) by type of business data. Click a quarterly download link in Section 6.6 for a selected metro (see above note) and download the full 6-digit NAICS detail data for any/all quarters starting with 2013Q1 (CSV structure). These files provide 6-digit NAICS type of business code detail and included columns for :
for the most recent quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient
for over-the-year change (previous year, same quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient

Using the Interactive Table
Updated quarterly, use the interactive table in the Web section to view, rank, compare individual metros with other metro. The following graphic shows metros ranked in descending order by 2015Q4 average weekly wages. Columns to the right show over-the-year (2014Q4-2015Q4 in this case) characteristics.

– click graphic for larger view.

Using the Downloaded Data
Access/download quarterly establishments, employment & earnings data by detailed NAICS category using theSituation & Outlook Metro Reports. Select a metro from the interactive table by click a link in the “Code” column. The S&O metro report opens in a new page. In the table of contents, select section 6.6. from the table of contents (Establishments, Employment & Earnings by Detailed Type of Business). See this example for the Chicago metro.  See the related Web section for more details on using the download data files. .

Location Quotients
Pre-computed location quotients are included in the downloadable files. Location quotients (LQ) are ratios (indicators) that measure the concentration of an industry within a specific area (metro in this case) to the concentration of that industry nationwide.

If an employment LQ is equal to 1, then the industry has the same share of its area employment as it does in the nation. An employment LQ greater than 1 indicates an industry with a greater share of the local area employment than is the case nationwide. For example, Las Vegas will have an LQ greater than 1 in the Leisure and Hospitality industry because this industry makes up a larger share of the Las Vegas employment total than it does for the nation as a whole.

Employment LQs are calculated by first, dividing local industry employment by the all industry total of local employment. Second, national industry employment is divided by the all industry total for the nation. Finally, the local ratio is divided by the national ratio.

LQs are provided in the downloadable file for:
a) the reference quarter for each of establishments, employment and wages, and
b) over-the-year change for each of establishments, employment and wages.

Location Quotients will be reviewed in more detail in an upcoming blog post.

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 first quarter 2016 (2016Q1) are available mid-September 2016.

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.

Characteristics of Largest 50 U.S. Metropolitan Areas

.. the total population of the largest 50 U.S. metropolitan areas as of 2014 (latest official estimates) was 174,886,265. These 50 metros account for 58.3% of the population in all 917 metropolitan areas and 54.8% of the total U.S. population. By either measure, more than half of the U.S. population resides in these 50 metros. Use tools and data resources described in this section to view and analyze these metros.

View the list of these metros by population rank in the scroll section provided below. Click on a metro link to view the Metro Situation & Outlook Report for that metro. The report provides extensive details on the geographic-demographic-economic attributes of the metro.

Use the largest_50_metros GIS project described in this section to map and explore characteristics of these metros. Create zoom-in views of metros/regions of interest. Label geography. Add other geography and data. The largest_50_metros GIS project/datasets includes all U.S. metros and has been used to develop the views in this section:
View 1 .. 50 Largest Metros Ranked on 2014 Total Population
View 2 .. All Metropolitan & Micropolitan Statistical Areas
View 3 .. Patterns of Percent Population Change 2010-2014
See details about using the largest_50_metros GIS project below in this section.

50 Largest Metros Ranked on 2014 Total Population
The following graphic shows the 50 largest metros by 2014 population rank (blue metros are the largest 10). Click graphic for larger view, more detail and legend color/data intervals (expand browser window for best view).

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

All Metropolitan & Micropolitan Statistical Areas
The following graphic shows all metropolitan statistical areas (blue) and micropolitan statistical areas (orange). Click graphic for larger view, more detail and legend color/data intervals (expand browser window for best view).

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

Patterns of Percent Population Change 2010-2014
The following graphic shows the percent change in total population from 2010 to 2014 for all metros. Click graphic for larger view, more detail and legend color/data intervals (expand browser window for best view). This map illustrates the relative ease to gain insights into patterns of population change using geospatial data analytics tools.

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

50 Largest Metros Ranked on 2014 Total Population — scroll section
Click link to view Metro Situation & Outlook Report

Largest 50 Metros GIS Project/Datasets
1. Install the ProximityOne CV XE GIS
… omit this step if CV XE GIS software already installed.
… run the CV XE GIS installer
… take all defaults during installation
2. Download the Largest 50 Metros GIS project fileset
… requires ProximityOne User Group ID (join now)
… unzip Largest 50 Metros GIS project files to local folder c:\largest_metros
3. Open the large_50_metros1.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\largest_metros\largest_50_metros1.gis
4. Done .. the start-up view is similar to the graphic shown at the top of this section.

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about using metropolitan area geography and using demographic-economic data.  Learn more about integrating these data with other geography, your data and use of data analytics that apply 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.