Employment at Place of Work

This page last updated: 10/13/2016
Metadata created using Minnesota Geographic Metadata Guidelines


Go to Section:
1. Overview
2. Data Quality
3. Data Organization
4. Coordinate System
5. Attributes
6. Distribution - Get Data
7. Metadata Reference

Section 1 Overview
Originator Minnesota Department of Employment and Economic Development (DEED) and the Metropolitan Council.
Title Employment at Place of Work
Abstract Minnesota Department of Employment and Economic Development (DEED) compiles quarterly counts of employees, employer establishments, and total wages paid, covered by Unemployment Insurance in Minnesota, as part of a nationwide reporting to US Bureau of Labor Statistics (BLS). DEED publishes summarized statistics of their Quarterly Census of Employment and Wages (QCEW) microdata by North American Industrial Classifications (NAICS) and by ownership category (federal government, state government, local government, private).

This dataset is republished DEED QCEW summary data at the county and community level. Summary statistics at the station area level are developed by the Metropolitan Council based on DEED QCEW, U.S. Census Bureau LODES data, and Minnesota Department of Education staffing counts.


The QCEW microdata is aggregated to Transportation Analysis Zones (TAZ) and supplemented with U.S. Census LED data where data privacy practices perclude the inclusion of QCEW data to generate TAZ employment estimates. These estimate totals are then allocated to station areas for station area level employment
Purpose Used by Metropolitan Council for monitoring regional and local employment trends over time.
Time Period of Content Date 04/01/2015
Currentness Reference DEED data is from the second quarter of each year. The latest year is 2015. LODES was last published with 2014 data. The Department of Education data is based on beginning of the school year data. The latest data used was for the 2014-2015 school year.
Progress Complete
Maintenance and Update Frequency Annually
Spatial Extent of Data DEED: areas within Minnesota. LODES: nationwide.
Bounding Coordinates -94.012
-92.732
45.415
44.471
Place Keywords Twin Cities, Anoka County, Carver County, Dakota County, Hennepin County, Ramsey County, Scott County, Washington County
Theme Keywords employment, jobs, wages, economic statistics, QCEW, LED, TAZ
Theme Keyword Thesaurus None
Access Constraints None. This summary dataset does not include restricted nondisclosable data.
Use Constraints Station Area are defined as half-mile, non-overlapping transit-influenced areas based on existing and planned transitway station locations as defined by MetroTransit. In general, transitway stations are defined as a centrally located, single station point representing multidirectional transit stops or platforms. Additional consolidations of transitway stations were made to "coexisting" multimodal stations (i.e., Blue Line's 46th Street Station (Hiawatha Ave) A-Line's 46th Street Station) before defining Station Area. Both the consolidation of stations and definition of station areas are supported by the Federal Transportation Administration (FTA) Reporting Instructions for the Section 5309 Capital Investment Grant Program.

The source and allocation methodology of data included in the Station Area Statistics can be found in the data layer metadata record.

Because some station areas can represent more than one transitway corridor, the statistics for all Station Areas are provided with the download of any data layer requested at the All Station Area geography. Each Station Area is associated with a transitway Corridor segment (Corridor_ID). A Corridor segment can include one (1) to eighteen (18) stations. Use the following matrix to associate and/or summarize Corridor segments to a specific corridor(s):

Corridor_ID = Corridor
1001, 1002, 1003, 1005, 1014 = Blue Line
1001, 1004 = Northstar Commuter Rail
1005, 1006, 1011 = Red Line
1001, 1002, 1007, 1015 = Green Line
1013, 1014, 1015 = A Line
1008 = Green Line Extension
1009 = Blue Line Extension
1010 = Orange Line
1012 = Gold Line
1016 = C Line
1017 = Red Rock

Note: avoid double counting common Corridor segments (i.e., 2001, 2002) when summarizing multiple corridors (i.e., Blue and Green Lines).
Contact Person Information Paul E. Hanson, GIS Specialist
Metropolitan Council
390 Robert Street North
St. Paul, MN  55101-1805
Phone: 651.602.1642
Email: paul.hanson@metc.state.mn.us
Browse Graphic none available
Associated Data Sets

Section 2 Data Quality
Attribute Accuracy Valid code tests have been conducted. No known attribute errors exist.
Logical Consistency
Completeness
Horizontal Positional Accuracy
Lineage Data at the community, county, and regional levels are republished data from Minnesota Department of Employment and Economic Development (DEED).

Due to data disclosure restrictions, DEED does not release employment data for all communities. Missing community-level employment totals are estimated by Metropolitan Council based on U.S. Census LODES data. Metropolitan Council estimates are identified in the DATASOURCE field as "METC."

The Metropolitan Council has also made adjustments in this dataset to St. Paul and Maplewood total employment for years 2000-2002, and to Inver Grove Heights total employment for years 2000-2004.

Data at the Station Area level is developed by the Metropolitan Council based on DEED QCEW microdata and enhanced with Minnesota Department of Education staffing counts. Due to known geospatial inaccuracies of reported employment within public school district employers, staffing counts from the Minnesota Department of Education are substituted for public school district employment. Where summary statistics are not disclosable in accordance with Deed's data privacy restrictions, employment estimates at the Transportation Analysis Zones (TAZ) were allocated to station areas based on ratios of observed or planned non-residential (i.e., commercial, industrial, istitutional, etc.) land within a station area.

TAZ employment estimates are developed as an input into the Metropolitan Council transportation model. These employment estimates are based on DEED QCEW microdata, enhanced with Minnesota Department of Education staffing counts and substituted with U.S. Census Bureau's LODES data where counts are not disclosable in accordance with Deed's data privacy restrictions. Where TAZ employment estimates dramatically under or over estimating employment within a station area, the Metropolitan Council inferred a reasonable employment count based on preceeding and subsequent year's employment.

Section 3 Spatial Data Organization (not used in this metadata)

Section 4 Coordinate System
Horizontal Coordinate Scheme
Horizontal Datum
Horizontal Units

Section 5 Attributes
Overview Attributes for Chart Data (Note: Not all attributes are present in every chart):

AVG_YEARLY: Average annual wages. Calculated based on total wages paid within the calendar quarter divided by the total number of employees, multiplied by four.

DATASOURCE: Source of the data
DEED = Minnesota Department of Employment and Economic Development (DEED) QCEW data
METC = Metropolitan Council estimate

EMPLOYMENT: The number of employees who are covered by Minnesota Unemployment Insurance and who worked or received pay during the quarter.

GEOGRAPHY: Name of the city or township.

INDUSTRY: The name of the employment classification under the North American Industrial Classification System (NAICS).

INDUSTRY_CODE_TITLE: The name of the employment classification under the North American Industrial Classification System (NAICS).

SUM_OF_EMPLOYMENT: The number of employees who are covered by Minnesota Unemployment Insurance and who worked or received pay during the quarter.

YEAR: The year of employment data.



Attributes for Tabular Data (County and Community):

CO_CODE: 3 digit FIPS and state standard county ID code
003 = Anoka County
019 = Carver County
037 = Dakota County
053 = Hennepin County
123 = Ramsey County
139 = Scott County
163 = Washington County

CTU_CODE: 5 digit FIPS55 'Place' code for CTU. They are replaced by the GNIS IDs below.

CTU_ID: The Geographic Names Information System (GNIS) official federal unique identifier for each city, township.

COCTU_ID: 11 digit identifier for the combination of county and CTU (concatenation of CO_CODE and CTU_ID_CEN).

CTU_NAME: Name of the city or township.

YEAR: The year of employment data.

QUARTER: The quarter of employment data.

DATASOURCE: Source of the data
DEED -- Minnesota Department of Employment and Economic Development (DEED) QCEW data
METC -- Metropolitan Council estimate

ESTABLISHMENT: Number of establishments whose activities were reported to the Unemployment
Insurance system for the quarter.

EMPLOYMENT: The number of employees who are covered by Minnesota Unemployment Insurance and who worked or received pay during the quarter.

TOTAL_WAGE: The total wages paid by Unemployment Insurance covered employers during the calendar quarter.

AVG_WEEKLY_WAGE: Average weekly wage of covered employees.

COMMUNITY DESIGNATION: A designation of each city and township based on the overall state of development and regional issues faced by that community.


Attributes for Tabular Data (Station Areaa):
See Use Constraints for Station Area analysis.

CORRIDOR_SEGMENT_ID: 4 digit indicator of the Corridor Segment.

CORRIDOR_SEGMENT: Description of the Corridor Segment. Corridor
Segments make up full corridors. A Corridor Segment can be part of
multiple corridors

STATION_AREA_ID: Station Area Identifier (COUNTY_CODE + CTU_ID +
Unique Station ID).

STATION_AREA: Description of the Station Area

CTU_ID: The Geographic Names Information System (GNIS)official federal
unique identifier for the city, township or unorganized territory
where the station is located.

COMMUNITY: Description of the community where the Station is located.

COUNTY_CODE: 3 digit FIPS and state standard county ID code where the Station is located

COUNTY: Name of the county where the station is located

YEAR: The year of employment data.

QUARTER: The quarter of employment data.

DATASOURCE: Source of the data
DELE -- Metropolitan Council based on Minnesota Department of Employment and Economic Development (DEED) QCEW, Minnesota Department of Education staffing counts, and U.S. Census Bureau's LODES data.

ESTABLISHMENT: Number of establishments whose activities were reported to the Unemployment
Insurance system for the quarter.

EMPLOYMENT: Estimate of the number of employees who are covered by Minnesota Unemployment Insurance and who worked or received pay during the quarter.

TOTAL_WAGE: The total wages paid by Unemployment Insurance covered employers during the calendar quarter.

AVG_WEEKLY_WAGE: Average weekly wage of covered employees.

COMMUNITY DESIGNATION: A designation of each city and township based on the overall state of development and regional issues faced by that community.
Detailed Citation
Table Detail:

Section 6 Distribution
Publisher Metropolitan Council
Publication Date 08/03/2016
Contact Person Information Paul E. Hanson, GIS Specialist
Metropolitan Council
390 Robert Street North
St. Paul, MN  55101-1805
Phone: 651.602.1642
Email: paul.hanson@metc.state.mn.us
Distributor's Data Set Identifier Employment
Distribution Liability NOTICE: The data to which this notice is attached are made available pursuant to the Minnesota Government Data Practices Act (Minnesota Statutes Chapter 13). THE DATA ARE PROVIDED TO YOU AS IS AND WITHOUT ANY WARRANTY AS TO THEIR PERFORMANCE, MERCHANTABILITY, OR FITNESS FOR ANY PARTICULAR PURPOSE. The Metropolitan Council developed some of the data for its own internal business purposes and is redistributing data developed by other data providers (e.g., the U.S. Census Bureau and the Minnesota Department of Employment and Economic Development). The Metropolitan Council does not represent or warrant that the data or the data documentation are error-free, complete, current, or accurate. You are responsible for any consequences resulting from your use of the data or your reliance on the data. You should consult the data documentation for these particular data to determine the limitations of the data. If you transmit or provide the data (or any portion of it) to another user, it is recommended that the data include a copy of this disclaimer and this metadata.
Ordering Instructions This entire dataset is available on the internet by clicking below after 'Online Linkage'. Doing so will tell your browser to download a 'ZIP' file which will contain the following:

- csv file
- metadata for the dataset (.htm)
- NOTICE.RTF, an important notice about this dataset that can be read by any word processing software.

This dataset can also be viewed and downloaded using the Download Tabular Data tool at http://stats.metc.state.mn.us/data_download/DD_start.aspx.
Online LinkageDownload Page

Section 7 Metadata Reference
Metadata Date 10/13/2016
Contact Person Information Todd Graham, Principal Forecaster
Metropolitan Council
390 Robert Street North
St. Paul, Minnesota  55101-1805
Phone: 651-602-1322
Fax: 651-602-1674
Email: todd.graham@metc.state.mn.us
Metadata Standard Name Minnesota Geographic Metadata Guidelines
Metadata Standard Version 1.2
Metadata Standard Online Linkage http://www.gis.state.mn.us/stds/metadata.htm


This page last updated: 10/13/2016
Go back to top