An official website of the United States government
United States Department of Labor
United States Department of Labor
The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information,
make sure you're on a federal government site.
The site is secure.
The
https:// ensures that you are connecting to the official website and that any
information you provide is encrypted and transmitted securely.
Quarterly Census of Employment and Wages
SHARE ON:
QCEW Open Data Access
QCEW provides a collection of CSV files designed to allow third party programmers, developers, and organizations to retrieve published QCEW data in CSV format. This page provides links to QCEW CSV file documentation as well as to sample code in several languages. This resource provides access to all QCEW data for the most recent 5 years. For access to zipped files for all years, see https://www.bls.gov/cew/downloadable-data-files.htm
QCEW CSV files are sliced by industry, by area, and by establishment size-class. An industry slice contains all the records associated with the industry for a single time period. An area slice contains all the records associated with the area for a single time period. A size slice contains all records published within a specific size class for the first quarter of a specified year. All published QCEW data are provided by each set of slices. Slices contain pre-calculated location quotients. For more information, please see the location quotients page, https://www.bls.gov/cew/about-data/location-quotients-explained.htm
QCEW data slices can be directly accessed from various programming languages. QCEW has provided simple examples in several languages. These examples are intended to be stepping stones for advanced data users and software developers. These examples are provided as is and may be outdated. Some modification may be necessary to successfully retrieve data.
QCEW's Data Viewer interface uses these same CSV files to build custom HTML tables based on selected criteria. A link to the Data Viewer is provided below.
- QCEW Open Data Access: CSV Data Slices
Provides details about the different types of data-slice files. - QCEW Open Data Access: Sample Code
Provides data access examples in several different programming languages. - QCEW Data Viewer
Builds custom HTML tables using the CSV Data Slices as input.
Last Modified Date: October 24, 2023