( Printable version )

Important
Important

This specification is draft. Feedback is welcome. Please write us at ces.qwi.feedback@census.gov.

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. The contents (schema) are described in lehd_public_use_schema.html.

2. Extends

This version extends v4.0. Any file compliant with LEHD or QWI Schema v4.0 will also be compliant with this schema.

3. Supersedes

For the specified files, this is the first schema.

4. 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]

( naming_convention.csv )

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]_[geohi]_[all,all_aggregations]_[sa]

j2j j2jr j2jod

Certain files are provided in a consolidated format containing multiple aggregations.

4.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.

4.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.

5. Description of Filename Components

5.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

http://lehd.ces.census.gov/data/j2j_beta.html

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.

http://lehd.ces.census.gov/data/#lodes

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).

http://lehd.ces.census.gov/data/#qwi

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

5.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 )

5.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

5.4. fas

( naming_fas.csv )

type Description

f

No firm size or age detail

fa

Tabulations by firm age

fs

Tabulations by firm size

5.5. geocat

( naming_geocat.csv )

type Description

gc

Counties

gm

Metropolitan/Micropolitan

gn

National (50 States + DC)

gs

States

gw

Workforce Investment Areas

5.6. indcat

( naming_indcat.csv )

type Description

n

all industries

ns

NAICS sectors

n3

NAICS subsectors

n4

NAICS industry groups

5.7. owncat

( naming_owncat.csv )

type Description

of

Federal government (QWI Code A01)

op

All Private (QWI Code A05)

oslp

State, local, and private ownership categories (QWI Code A00)

5.8. sa

( naming_sa.csv )

type Description

s

Seasonally adjusted

u

Not seasonally adjusted

5.9. ext

( naming_ext.csv )

type Description

csv

Comma-Separated file

pdf

PDF file (printable)

xls

Excel file (only select output)

xlsx

Excel file (not available for larger files)

6. Changes

6.1. This version from previous releases of V4.1 draft schema documents

  • 2015-02-25: corrected flag values

  • 2015-02-25: documents are now identified by date, not revision

  • 2015-03-10: Correction of the TIGER vintage that is used for geographic references

  • 2015-03-11: Added URL for J2J

  • 2015-03-11: Correction of typo in type naming convention, rename of naming_fipsalpha.csv to naming_geohi.csv to be consistent.

  • 2015-03-17: 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.

  • 2015-04-24: Changes to alternate name of SepSnx and EmpSpv, tentative rate names

  • 2015-04-26: Changes to name of variable schema files (qwipu → qwi), addition of variability variable schema files.

  • 2015-04-28: Fixed small typos in QWI variable short names

  • 2015-05-18: Updated agg_level description, replaced agg_level.csv file

  • 2015-05-22: Fixed minor rendering bug for QWI rate variability names. No change to actual metadata.

  • 2015-06-09: Fixed a minor coding error in label_fipsnum.csv, added a concatenation of geography files as label_geography_all.csv.

  • 2015-08-07: Minor text change for agg_level, modified agg_level file.

  • 2015-08-12: Removed the last 4 rows of variables_j2jod.csv, since they are not on the current beta J2JOD files.

  • 2015-08-25: Added a extension component [ext] to the file naming convention to reflect availability of Excel files (and PDF files)

  • 2016-03-16: Removed extraneous empty lines

  • 2016-04-12: Fixed typo in variables_qwi.csv (FrmJbLsS, EarnHirNS and status variables)

  • 2016-04-12: Incorporated all state-level geography from 4.0.5

  • 2016-04-12: Added additional geo_level for CBSA (complete)

  • 2016-04-12: Added additional agg_level values

  • 2016-04-12: Clarified labels of j2jod identifiers

  • 2016-04-12: Renamed label_geography_all as label_geography

  • 2016-04-12: Added a column geo_level to all label_geography_* files

  • 2016-08-08: Corrected erroneous Oregon geography labels.

6.2. Version 4.1d-draft from 4.0.1

  • added J2J, National QWI spec

  • added geohi category of ALL, US

  • added definitions of variability measures

  • added definitions of rates on separate file

  • added naming convention for additional files

  • added agg_level variable

  • added additional geo_level for CBSA (complete)

  • added SHP files and description thereof

Important
Important

Some of the data products noted above do not exist yet.

This revision: Tue Aug 9 07:59:09 EDT 2016