Important
This document is not an official Census Bureau publication. It is compiled from publicly accessible information by Lars Vilhuber (Labor Dynamics Institute, Cornell University). Feedback is welcome. Please write us at lars.vilhuber@cornell.edu. |
1. Purpose
The public-use data from the Longitudinal Employer-Household Dynamics Program, including the Quarterly Workforce Indicators (QWI) and Job-to-Job Flows (J2J), are available for download with the following data schema. These data are available as Comma-Separated Value (CSV) files through the LEHD website’s Data page at http://lehd.ces.census.gov/data/ and through LED Extraction Tool at http://ledextract.ces.census.gov/.
This document describes the file naming schema for LEHD-provided CSV files.
2. Schema for Data File Contents
The contents (schema) for LEHD data files are described in lehd_public_use_schema.html. The contents (schema) for shapefiles are described in lehd_shapefiles.html.
3. Extends
This version reimplements some features from V4.0. Many files compliant with LEHD or QWI Schema v4.0 will also be compliant with this schema, but compatibility is not guaranteed.
4. Supersedes
This version supersedes V4.0.5, for files released as of RXXXX.
5. Basic Schema
All files are preceded by a file type definition, followed by additional information on the aggregation level of the file, or some other identifier.
[TYPE]_[DETAILS].[EXT]
type | Used By | Description |
---|---|---|
[type]_[id] |
qwix |
CSV files queried from the LED Extraction Tool at http://ledextract.ces.census.gov/. |
[type]_[geohi]_[demo]_[fas]_[geocat]_[indcat]_[ownercat]_[sa] |
qwi qwir qwiv qwivr j2j j2jr j2jod |
Common convention for currently provided files. |
[type]\_[geocat] |
shapefiles |
ZIP files containing data for shapefiles |
5.1. QWIPU from the LED Extraction Tool
Files downloaded through the LED Extraction Tool at http://ledextract.ces.census.gov/ follow the following naming convention:
[type]_[id].[EXT]
where [id]
is the Request ID (a unique string of characters) generated every time Submit Request'' is clicked. The ID references each query submission made to the database.
5.2. Other files
Files downloaded from the LEHD website at http://lehd.ces.census.gov/data follow the following naming convention:
[type]_[geohi]_[demo]_[fas]_[geocat]_[indcat]_[ownercat]_[sa].[EXT]
where each component is described in more detail below. Schema files detailing legal values for each component can be downloaded from this website.
6. Description of Filename Components
6.1. Types
( naming_type.csv )
type | Description | Explanation | url |
---|---|---|---|
j2j |
Job-to-Job Flows Counts (J2J) |
Counts of hires and separations, to and from employment and non-employment, summed across all establishments |
tbd |
j2jod |
Job-to-Job Flows Origin-Destination |
Origin and destination flows and earnings, tabulated by the destination establishment |
tbd |
j2jr |
Job-to-Job Flows Rates |
Hiring and separation rates, to and from employment and nonemployment, summed across all establishments |
|
lodes |
LEHD Origin-Destination Employment Statistics (LODES) |
LEHD Origin-Destination Employment Statistics (LODES) used by OnTheMap. Version 7 and higher of LODES was enumerated by 2010 census blocks. Version 6 and lower of LODES were enumerated with 2000 census blocks. |
|
qwi |
Quarterly Workforce Indicators Public Use Counts (QWIPU) |
The Quarterly Workforce Indicators (QWI) are a set of economic indicators including employment, job creation, earnings, and other measures of employment flows. The QWI are reported using detailed firm characteristics (geography, industry, age, size) and worker demographics information (sex, age, education, race, ethnicity). |
|
qwir |
Quarterly Workforce Indicators Public Use Rates |
Rates for flow variables in the Quarterly Workforce Indicators (QWI) |
tbd |
qwirv |
Quarterly Workforce Indicators Variability Measures for Rates |
Variability measures for rates in the Quarterly Workforce Indicators (QWI) |
tbd |
qwiv |
Quarterly Workforce Indicators Variability Measures |
Variability measures for Quarterly Workforce Indicators (QWI) |
tbd |
lehd_shp |
LEHD Shapefiles |
Shapefiles are used to provide mapping functionality in QWI Explorer and Job-to-Job Explorer |
lehd_shapefiles.html |
6.2. geohi
( naming_geohi.csv )
This component is based on the alphabetic FIPS state code equivalent to the numeric FIPS code in label_fipsnum.csv, based on FIPS PUB 5-2. It is expanded to encompass additional codes denoting national coverage, or a collection of states.
type | Description |
---|---|
all |
Collection of all available states |
us |
National data (50 states + DC) |
st |
Any legal 2-character state postal code (see naming_geohi.csv ) |
6.3. demo
( naming_demo.csv )
type | Description |
---|---|
d |
No demographic detail |
rh |
Race by Ethnicity tabulations |
sa |
Sex by Age tabulations |
se |
Sex by Education tabulations |
6.4. fas
( naming_fas.csv )
type | Description |
---|---|
f |
No firm size or age detail |
fa |
Tabulations by firm age |
fs |
Tabulations by firm size |
6.5. geocat
type | Description |
---|---|
gb |
Metropolitan/Micropolitan (complete) |
gc |
Counties |
gm |
Metropolitan/Micropolitan |
gn |
National (50 States + DC) |
gs |
States |
gw |
Workforce Investment Areas |
6.6. indcat
type | Description |
---|---|
n |
all industries |
ns |
NAICS sectors |
n3 |
NAICS subsectors |
n4 |
NAICS industry groups |
6.7. owncat
type | Description |
---|---|
of |
Federal government (QWI Code A01) |
op |
All Private (QWI Code A05) |
oslp |
State, local, and private ownership categories (QWI Code A00) |
6.9. ext
( naming_ext.csv )
type | Description |
---|---|
csv |
Comma-Separated file |
PDF file (printable) |
|
xls |
Excel file (only select output) |
xlsx |
Excel file (not available for larger files) |
7. Changes
For a description of how schema files are versioned, see main directory.
7.1. This version (revisions)
-
2016-09-26: Initial release
-
2016-10-06: Fixed a rendering issue with an empty column.
-
2016-10-06: Modified the label for firm age and firm size to contain mention of "Not Available For Public-Sector Firms"
-
2016-10-06: Changed description of agg_level
-
2017-03-06: Removed two variables from variables_j2jod.csv that were not actually on the CSV file
-
2017-03-06: Corrected bad reference to release RXXXX, which should have been R2016Q4
-
2017-03-07: Corrected naming of files inside shapefile ZIP files
7.2. Version 4.1 from 4.0.5
-
2016-08-08: Implemented select changes from V4.1d-draft: Key changes are
-
Changed structure of state-level geography labels (flat directory structure)
-
Describes National QWI files and J2J files (both of which are still in beta), added J2J, National QWI spec
-
added additional geo_level for CBSA (complete), additional description, sources in label_geo_level.csv
-
2016-08-10: Added description,definition of SHP files
-
2016-08-11: Modified Indicator Names for J2J variable metadata.
-
2016-08-31: adjusted AL, AR, GA, IA, KY, LA, MN, MS, NM, PA, TN, TX metropolitan areas for 2016 geo vintage
7.2.1. In more detail
-
added geohi category of ALL, US, add naming_geohi.csv
-
added naming convention for additional files
-
added agg_level variable
-
Changes to name of variable schema files (qwipu → qwi), addition of variability and rate variable schema files.
-
Addition of a column identifying the type of variable on QWI
-
Renamed file from QWIPU_Data_Schema.pdf to lehd_public_use_schema.pdf
-
Addition of variable schema description for J2J
-
Added a extension component [ext] to the file naming convention to reflect availability of Excel files (and PDF files)
-
Updated documentation-generating scripts to the latest. Documents are now identified by date, not revision
-
Added a concatenation of geography files as label_geography.csv.
-
Added a column geo_level to all label_geography_* files
-
Changed fipsnum to force readin of FIPS as character, include geo_level, US.
-
Added additional legal values for firmage and firmsize, as used by J2J
-
Added Federal government to files (for National QWI)
-
Clarified description of filenaming components
-
Sundry small additional changes, building out the schema
-
Changing of naming convention for to-be-released files based on federal government from fg → of. At this time, no such files have been released.
Important
Some of the data products noted above do not exist yet. |