ny-gov/quarterly-census-of-employment-and-wages-annual-shc7-xcbw
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 1 month ago

Quarterly Census of Employment and Wages Annual Data: Beginning 2000

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/quarterly-census-of-employment-and-wages-annual-shc7-xcbw\".\"quarterly_census_of_employment_and_wages_annual\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • quarterly_census_of_employment_and_wages_annual
     
     
     
     
     
Upstream Metadata