Quarterly Census of Employment and Wages (QCEW) Historical Annual Data: 1975 - 2000

data.ny.gov | Last Updated 10 Jun 2019

The Quarterly Census of Employment and Wages (QCEW) program (also known as ES-202) collects employment and wage data from employers covered by New York State's Unemployment Insurance (UI) Law. This program is a cooperative program with the U.S. Bureau of Labor Statistics. QCEW data encompass approximately 97 percent of New York's nonfarm employment, providing a virtual census of employees and their wages as well as the most complete universe of employment and wage data, by industry, at the State, regional and county levels. "Covered" employment refers broadly to both private-sector employees as well as state, county, and municipal government employees insured under the New York State Unemployment Insurance (UI) Act. Federal employees are insured under separate laws, but are considered covered for the purposes of the program. Employee categories not covered by UI include some agricultural workers, railroad workers, private household workers, student workers, the self-employed, and unpaid family workers. QCEW data are similar to monthly Current Employment Statistics (CES) data in that they reflect jobs by place of work; therefore, if a person holds two jobs, he or she is counted twice. However, since the QCEW program, by definition, only measures employment covered by unemployment insurance laws, its totals will not be the same as CES employment totals due to the employee categories excluded by UI. Industry level data from 1975 to 2000 is reflective of the Standard Industrial Classification (SIC) codes.

Tags: employment, payroll, labor statistics, industry, sic, wages

This dataset has the following 11 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
State FIPSstate_fipsnumberThe New York State "FIPS" identifier (36) is embedded in the file for those who wish to merge multi-state data sets. Federal information processing standards codes (FIPS codes) are a standardized set of numeric or alphabetic codes issued by the National Institute of Standards and Technology (NIST) to ensure uniform identification of geographic entities through all federal government agencies.
County FIPScounty_fipstextEach county in New York State has been assigned a numeric "FIPS" code by the Federal Government. These codes are used as the identifiers for the counties in this data set. Their meanings are listed below. Employees working in New York State, who cannot be classified as working in any one county, or who are working at sites that have not yet been classified, or are unknown, are reported in the classification, "Statewide." Also included in this classification are New York State residents employed overseas or out-of-state but electing to be covered by New York State Unemployment Insurance. Total employment in this classification generally numbers approximately 100,000 (approximately 1.25 percent of the total number of workers covered by New York State's Unemployment Insurance). Data users with access to New York State-specific files will find that these county codes differ from those used "in-house" by the New York State Department of Labor. See Data File Layout PDF in the 'About' tab for a translation of the county FIPS numbers.
County NamecountytextCounty name
IndustryindustrytextThe industry code designates the division level of Standard Industrial Classification (SIC). The source for this classification is the "Standard Industrial Classification Manual, 1987," published by the U.S. Office of Management and Budget. The codes assigned to the industry divisions in the data set should not be confused with the "first digit" of the SIC code. Section 537 of the Labor Law requires that information provided by individual employers be kept confidential. Due to this confidentiality requirement, certain industry divisions have been consolidated in this data set. For the majority of the counties in the state, consolidating "Agriculture, Forestry and Fishing" with "Mining" and "Unclassified" yielded employment totals, which could be disclosed, to the public without jeopardizing the confidentiality of individual employer data. However, in a few counties further consolidation was required to obtain a disclosable total. For these counties, a different grouping included "Construction" with "Agriculture," "Mining" and the "Unclassified" group to obtain a releasable total. Therefore, the data sets for most counties have industry 01 but no industry 02. Industry 02 is the grouping for the special cases that required further consolidation. Users should not be alarmed to find that most of the counties have no industry 02.
Industry Titleindustry_titletextThe title associated with the Industry Code. 00 = All Industries; 01 = Agriculture, Mining & Unclassified; 02 = Agriculture, Mining, Construction & Unclassified; 03 = Construction; 04 = Manufacturing; 05 = Transportation & Public Utilities; 06 = Wholesale Trade; 07 = Retail Trade; 08 = Finance, Insurance & Real Estate; 09 = Services; 10 = Public Administration
YearyearnumberThe year is represented by all four digits
Reporting Unitsreporting_unitsnumberThe reporting unit is the economic unit for which data are submitted on the employer's unemployment insurance contribution report, or on a multiple worksite report. The reporting unit is often (though not always) synonymous with the terms "worksite" and "establishment."
Average Employmentaverage_employmentnumberThe average employment is the summed monthly employment, as reported in the ES-202/QCEW, divided by 12.
Average Annual Wagesaverage_annual_wagesnumberThe average wage is the average yearly wage paid to the employees of all the reporting units for the industry division and county as reported in the ES-202/QCEW. It is computed by dividing the total wages for the year by the average monthly employment.
Total Wagestotal_wagesnumberTotal wages is the sum of all remunerations reported by all the reporting units in the ES-202/QCEW for the year.
Average Weekly Wagesaverage_weekly_wagesnumberThe average weekly wage is computed by dividing the total wages for the year by the average monthly employment, and then dividing the result by 52.