Employment at Place of Work
Go to Section:- Overview
- Data Quality
- Data Organization
- Coordinate System
- Attributes
- Distribution - Get Data
- 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, state, 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. U.S. Census LODES data is substituted in where QCEW data is not available because of QCEW nondisclosure protections. Department of Education data is substituted for the local schools sector. Estimates for zone areas are 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:
2022
Currentness Reference:
DEED data is from the second quarter of each year. The latest QCEW data is 2022. The latest LODES data is 2020. The most recent data available at this level is 2022 QCEW with 2018 LODES data.
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
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 (30) 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, 1025, 1027, 1036, 1039 = Blue Line
1001, 1004 = Northstar Commuter Rail
1005, 1006 = Red Line
1001, 1002, 1007, 1015, 1025, 1027, 1031, 1039 = Green Line
1008, 1026, 1032 = Green Line Extension
1009, 1024, 1026 = Blue Line Extension
1010, 1027, 1034 = Orange Line
1012, 1029, 1033 = Gold Line
1019, 1029, 1031 = Purpled Line
1013, 1014, 1015, 1037 = A Line
1028, 1032, 1033, 1035, 1036, 1037, 1038 = B Line
1016, 1022, 1024, 1026, 1027 = C Line
1018, 1022, 1026, 1027, 1035 = D Line
1030, 1038, 1039, 1040 = E Line
1023, 1025, 1029, 1033 = Riverview
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: [email protected]
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 staff. 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.
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 estimate employment within a station area, the Metropolitan Council inferred a reasonable employment count based on preceeding and subsequent year's employment.
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 districts, 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 nondisclosure restrictions, employment estimates were allocated to station areas from the TAZ employment estimates based on ratios of observed or planned nonresidential land (i.e., commercial, industrial, institutional) within a station area.Where Station Area employment estimates dramatically under or over estimate 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:
Vertical Datum:
not applicable
Vertical Units:
NA
Depth Datum:
NA
Depth Units:
NA
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.
CTU_NAME: Name of the city, township or unorganized territory.
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.
GEOG_LEVEL_ID: Level of geography.
CTU = Cities, townships, unorganized territories.
GEOG_UNIT_ID: Geographic identifier for the area (Geographic Names Information System [GNIS] codes are available at https://geonames.usgs.gov/domestic/index.html.
INDUSTRY: The name of the employment classification under the North American Industrial Classification System (NAICS).
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:
04/07/2023
Contact Person Information:
Paul E. Hanson,
GIS Specialist
Metropolitan Council
390 Robert Street North
St. Paul,
MN
55101-1805
Phone: 651.602.1642
Email: [email protected]
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. The Download tool allows users to choose subsets of the dataset, such as a city or county.
Section 7: Metadata Reference
Metadata Date:
04/07/2023
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: [email protected]
Metadata Standard Name:
Minnesota Geographic Metadata Guidelines
Metadata Standard Version:
1.2