****** LEHD Public Use CSV Naming Schema v4.1-draft - CSV Naming Convention ****** Lars Vilhuber 11 March 2015 Table of Contents JavaScript must be enabled in your browser to display the table of contents. ( Printable_version ) Important This document is not an official Census Bureau publication. It is [Important] 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 Quarterly Workforce Indicators (QWI) data from the Longitudinal Employer-Household Dynamics Program 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].csv **** 4.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. **** 4.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. ***** 5. Description of Filename Components ***** **** 5.1. Types **** ( naming_type.csv ) type Description Explanation url qwi Quarterly Workforce The Quarterly Workforce http:// Indicators Public Use Indicators (QWI) are a lehd.ces.census.gov/ Counts (QWIPU) set of economic data/#qwi 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). lodes LEHD Origin-Destination LEHD Origin-Destination http:// Employment Statistics Employment Statistics lehd.ces.census.gov/ (LODES) (LODES) used by data/#lodes 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. j2j Job-to-Job Flows Counts Counts of hires and tbd (J2J) separations, to and from employment and non- employment, summed across all establishments j2jod Job-to-Job Flows Origin- Origin and destination tbd Destination flows and earnings, tabulated by the destination establishment j2jr Job-to-Job Flows Rates Hiring and separation tbd rates, to and from employment and nonemployment, summed across all establishments qwir Quarterly Workforce Rates for flow variables tbd Indicators Public Use in the Quarterly Rates Workforce Indicators (QWI) qwiv Quarterly Workforce Variability measures for tbd Indicators Variability Quarterly Workforce Measures Indicators (QWI) **** 5.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 )) us National data (50 states + DC) **** 5.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 **** 5.4. fas **** ( naming_fas.csv ) type Description f All firm sizes and ages 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 fg 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 6. Changes **** 6.1. This version from previous releases of this document **** * 2015-02-25: corrected flag values * 2015-02-25: documents are now identified by date, not revision **** 6.2. Version 4.1-draft from 4.0 **** * added J2J, National QWI spec [Important] Important Some of the data products noted above do not exist yet. This revision: Wed Mar 11 22:04:42 EDT 2015 =============================================================================== Last updated 2015-03-11 22:04:42 EDT