Quarterly Census of Employment and Wages Annual Data: Beginning 2000
data.ny.gov | Last Updated 28 Aug 2023The 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.
This dataset has the following 10 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Area Type | area_type | text | Geographic Boundary Type | County Metropolitan Statistical Area Labor Market Area Metropolitan Division State view top 100 |
| Area | area | text | Geographic Area Name | New York City New York State Hudson Valley Long Island Nassau-Suffolk Metropolitan Division view top 100 |
| Ownership | ownership | text | Private, Federal, State, or Local Government | Private Total, All Ownerships Local Government State Government Federal Government view top 100 |
| NAICS | naics | text | Industrial classification data are classified in accordance with the 2002 North American Industry Classification System (NAICS), which recently replaced the long-standing Standard Industrial Classification (SIC) system. | 92 62 611 238 51 view top 100 |
| NAICS Title | naics_title | text | For data definitions go to the About tab and review the Overview Document | Unclassified Management of Companies and Enterprises Educational Services Professional and Technical Services Executive, Legislative, & Gen Government view top 100 |
| Year | year | number | Year | 2022 2004 2001 2006 2003 view top 100 |
| Establishments | establishments | number | All employers subject to UI laws. | 3 4 5 6 7 view top 100 |
| Average Employment | average_employment | number | Annual Average Employment is the arithmetic mean of the employment reported for all 12 months of the year. | 17 19 16 21 13 view top 100 |
| Total Wage | total_wage | number | Total wages cover all wages and salaries paid to individuals in insured employment. | 38556 1369326 5522657 337813 15451885448 view top 100 |
| Annual Average Salary | annual_average_salary | number | Annual average salary is the sum of the wages for the four quarters of the year (Total Wage) divided by the annual average employment, (Average Employment). | 29934 22517 40301 32984 26020 view top 100 |