****** LEHD Public Use CSV Naming Schema V4.1-rc3 - CSV Naming Convention ****** Lars Vilhuber 26 September 2016 Table of Contents JavaScript must be enabled in your browser to display the table of contents. ( 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. ***** 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] ( 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]_ qwi qwir qwiv qwivr j2j Common convention for [fas]_[geocat]_[indcat]_ j2jr j2jod currently provided files. [ownercat]_[sa] [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 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 http:// rates, to and from lehd.ces.census.gov/ employment and data/j2j_beta.html nonemployment, summed across all establishments 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. 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). qwir Quarterly Workforce Rates for flow variables tbd Indicators Public Use in the Quarterly Rates Workforce Indicators (QWI) qwirv Quarterly Workforce Variability measures for tbd Indicators Variability rates in the Quarterly Measures for Rates Workforce Indicators (QWI) qwiv Quarterly Workforce Variability measures for tbd Indicators Variability Quarterly Workforce Measures Indicators (QWI) lehd_shp LEHD Shapefiles Shapefiles are used to lehd_shapefiles.html provide mapping functionality in QWI Explorer and Job-to-Job Explorer **** 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 **** ( naming_geocat.csv ) 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 **** ( naming_indcat.csv ) type Description n all industries ns NAICS sectors n3 NAICS subsectors n4 NAICS industry groups **** 6.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) **** 6.8. sa **** ( naming_sa.csv ) type Description s Seasonally adjusted u Not seasonally adjusted **** 6.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) 7. Changes For a description of how schema files are versioned, see main_directory. **** 7.1. This version (revisions) **** * 2016-08-08: Initial release **** 7.2. Version 4.1-rc1 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) e5dbe97 * 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 1eb399f,27a2674 * 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 89617e3 * added naming convention for additional filesb * added agg_level variable 89617e3, 2149623 * Changes to name of variable schema files (qwipu → qwi), addition of variability and rate variable schema files. 89617e3 * Addition of a column identifying the type of variable on QWI 89617e3 * Renamed file from QWIPU_Data_Schema.pdf to lehd_public_use_schema.pdf 89617e3 * Addition of variable schema description for J2J 1a57250 * Added a extension component [ext] to the file naming convention to reflect availability of Excel files (and PDF files) d9f8387 f7cc524 * Updated documentation-generating scripts to the latest. Documents are now identified by date, not revision 8136f0c * Added a concatenation of geography files as label_geography.csv. 8136f0c, 39ecfc9 * Added a column geo_level to all label_geography_* files a32bb4c * Changed fipsnum to force readin of FIPS as character, include geo_level, US. a32bb4c * Added additional legal values for firmage and firmsize, as used by J2J a32bb4c * Added Federal government to files (for National QWI) 942dd0a, 1654288 * Clarified description of filenaming components 8888529, 8d580f6 * Sundry small additional changes, building out the schema 28d7c6f * 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. 3a0975e **** 7.3. Version 4.1-rc2 from 4.1-rc1 **** * 2016-08-10: Added description,definition of SHP files * 2016-08-11: Modified Indicator Names for J2J variable metadata. **** 7.4. Version 4.1-rc3 from 4.1-rc2 **** * 2016-08-31: adjusted AL, AR, GA, IA, KY, LA, MN, MS, NM, PA, TN, TX metropolitan areas for 2016 geo vintage For additional details, please consult the previous draft versions: * ../V4.1-draft * ../V4.1b-draft * ../V4.1c-draft * ../V4.1d-draft [Important] Important Some of the data products noted above do not exist yet. This revision: Mon Sep 26 20:39:47 EDT 2016 =============================================================================== Last updated 2016-09-26 20:39:47 EDT