About this Dataset

Quarterly Census Of Employment And Wages (QCEW)

The Quarterly Census of Employment and Wages (QCEW) Program is a Federal-State cooperative program between the U.S. Department of Labor’s Bureau of Labor Statistics (BLS) and the California EDD’s Labor Market Information Division (LMID). The QCEW program produces a comprehensive tabulation of employment and wage information for workers covered by California Unemployment Insurance (UI) laws and Federal workers covered by the Unemployment Compensation for Federal Employees (UCFE) program.

The QCEW program serves as a near census of monthly employment and quarterly wage information by 6-digit industry codes from the North American Industry Classification System (NAICS) at the national, state, and county levels. At the national level, the QCEW program publishes employment and wage data for nearly every NAICS industry. At the state and local area level, the QCEW program publishes employment and wage data down to the 6-digit NAICS industry level, if disclosure restrictions are met. In accordance with the BLS policy, data provided to the Bureau in confidence are used only for specified statistical purposes and are not published. The BLS withholds publication of Unemployment Insurance law-covered employment and wage data for any industry level when necessary to protect the identity of cooperating employers.

Data from the QCEW program serve as an important input to many BLS programs. The Current Employment Statistics and the Occupational Employment Statistics programs use the QCEW data as the benchmark source for employment. The UI administrative records collected under the QCEW program serve as a sampling frame for the BLS establishment surveys.

In addition, the data serve as an input to other federal and state programs. The Bureau of Economic Analysis (BEA) of the Department of Commerce uses the QCEW data as the base for developing the wage and salary component of personal income.

The U.S. Department of Labor’s Employment and Training Administration (ETA) and California's EDD use the QCEW data to administer the Unemployment Insurance program. The QCEW data accurately reflect the extent of coverage of California’s UI laws and are used to measure UI revenues; national, state and local area employment; and total and UI taxable wage trends.

The U.S. Department of Labor’s Bureau of Labor Statistics publishes new QCEW data in its County Employment and Wages news release on a quarterly basis. The BLS also publishes a subset of its quarterly data through the Create Customized Tables system, and full quarterly industry detail data at all geographic levels.
Organization: State of California
Last updated: 2023-11-03T13:09:22.185513
Tags: county, employment, establishments, industry, naics-code, qcew, wages

Tables

Data Dictionary - QCEW 2023-2024 Q3

@usgov.ca_gov_quarterly_census_of_employment_and_wages_qcew_a6fea.data_dictionary_qcew_2023_2024_q3

5.51 KB
15 rows
4 columns


CREATE TABLE data_dictionary_qcew_2023_2024_q3 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

QCEW 2008-2011

@usgov.ca_gov_quarterly_census_of_employment_and_wages_qcew_a6fea.qcew_2008_2011

19.69 MB
1003975 rows
15 columns


CREATE TABLE qcew_2008_2011 (
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "year" BIGINT,
  "quarter" VARCHAR,
  "ownership" VARCHAR,
  "naics_level" DOUBLE,
  "naics_code" VARCHAR,
  "industry_name" VARCHAR,
  "establishments" BIGINT,
  "average_monthly_employment" BIGINT,
  "n_1st_month_emp" BIGINT,
  "n_2nd_month_emp" BIGINT,
  "n_3rd_month_emp" BIGINT,
  "total_wages_all_workers" DOUBLE,
  "average_weekly_wages" DOUBLE
);

QCEW 2012-2015

@usgov.ca_gov_quarterly_census_of_employment_and_wages_qcew_a6fea.qcew_2012_2015

19.87 MB
999458 rows
15 columns


CREATE TABLE qcew_2012_2015 (
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "year" BIGINT,
  "quarter" VARCHAR,
  "ownership" VARCHAR,
  "naics_level" BIGINT,
  "naics_code" VARCHAR,
  "industry_name" VARCHAR,
  "establishments" BIGINT,
  "average_monthly_employment" BIGINT,
  "n_1st_month_emp" BIGINT,
  "n_2nd_month_emp" BIGINT,
  "n_3rd_month_emp" BIGINT,
  "total_wages_all_workers" DOUBLE,
  "average_weekly_wages" DOUBLE
);

QCEW 2016-2019

@usgov.ca_gov_quarterly_census_of_employment_and_wages_qcew_a6fea.qcew_2016_2019

20.1 MB
1009955 rows
15 columns


CREATE TABLE qcew_2016_2019 (
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "year" BIGINT,
  "quarter" VARCHAR,
  "ownership" VARCHAR,
  "naics_level" BIGINT,
  "naics_code" VARCHAR,
  "industry_name" VARCHAR,
  "establishments" BIGINT,
  "average_monthly_employment" BIGINT,
  "n_1st_month_emp" BIGINT,
  "n_2nd_month_emp" BIGINT,
  "n_3rd_month_emp" BIGINT,
  "total_wages_all_workers" DOUBLE,
  "average_weekly_wages" DOUBLE
);

QCEW 2020-2022

@usgov.ca_gov_quarterly_census_of_employment_and_wages_qcew_a6fea.qcew_2020_2022

15.96 MB
798464 rows
15 columns


CREATE TABLE qcew_2020_2022 (
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "year" BIGINT,
  "time_period" VARCHAR,
  "ownership" VARCHAR,
  "naics_level" BIGINT,
  "naics_code" VARCHAR,
  "industry_name" VARCHAR,
  "establishments" BIGINT,
  "average_monthly_employment" BIGINT,
  "n_1st_month_emp" BIGINT,
  "n_2nd_month_emp" BIGINT,
  "n_3rd_month_emp" BIGINT,
  "total_wages_all_workers" DOUBLE,
  "average_weekly_wages" BIGINT
);