( Printable version )

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.

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

2. 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].csv

2.1. QWIPU from the LED Extraction Tool

CSV files downloaded through the LED Extraction Tool at http://ledextract.ces.census.gov/ follow the following naming convention:

[type]_[id].csv

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.

2.2. Other files

Full CSV 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]

where each component is described in more detail below. Schema files detailing legal values for each component can be downloaded from this website.

3. Description of Filename Components

3.1. Types

( naming_type.csv )

type Description Explanation url

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

3.2. fipsalpha

( naming_fipsalpha.csv )

This component is the alphabetic FIPS state code equivalent to the numeric FIPS code in label_fipsnum.csv, based on FIPS PUB 5-2.

type Description

st

Any legal 2-character state postal code (see naming_fipsalpha.csv ))

3.3. demo

( naming_demo.csv )

type Description

d

All demographics

rh

Race by Ethnicity tabulations

sa

Sex by Age tabulations

se

Sex by Education tabulations

3.4. fas

( naming_fas.csv )

type Description

f

All firm sizes and ages

fa

Tabulations by firm age

fs

Tabulations by firm size

3.5. geocat

( naming_geocat.csv )

type Description

gc

Counties

gm

Metropolitan/Micropolitan

gn

National (50 States + DC)

gs

States

gw

Workforce Investment Areas

3.6. indcat

( naming_indcat.csv )

type Description

n

all industries

ns

NAICS sectors

n3

NAICS subsectors

n4

NAICS industry groups

3.7. owncat

( naming_owncat.csv )

type Description

fg

Federal government (QWI Code A01)

op

All Private (QWI Code A05)

oslp

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

3.8. sa

( naming_sa.csv )

type Description

s

Seasonally adjusted

u

Not seasonally adjusted

This version: : 607 $