QWI Public Use data ============================================================ Author: Lars Vilhuber (virtualrdc@cornell.edu) Ian Schmutte $Id: QWI-cheatsheet.txt 547 2014-10-29 03:57:52Z vilhu001 $ ============================================================ QWI Public use files have a variety of file structures. They differ in their geographic and industry classifiers. However, each file contains the complete time series for a set of unique identifiers: state [demography] [geography] [industry] ownercode Each class variable also has an associated formatted variable, with suffix 'fm', with equivalent content. Example: the file qwi_ca_wia_metro_naics3_all.csv has state=CA demography = wia (WIA-related age categories x sex) geography = metro (Core-based Statistical Areas) industry = naics3 (NAICS sub-sectors) ownercode= ALL (A00) and the unique record identifier on this file is state, ownercode, metro, naics3, agegrp, sex, year, quarter. Universe -------- All files ending in _pri: All private jobs for which state law requires UI contributions to be made. All files ending in _all: Above, plus state and local government jobs. _wia_, _rh_, _fa_, _fs_ : Individuals holding jobs in the relevant job category, 14-99 years old ( except as conditioned by the age variables, below) _se_ : As above, but only individuals 25 and older. Files and record identifiers ------------------------------------------------------------ common : state year quarter ownercode ownerfm [demography] _rh_ : ethnicity ethnicityfm race racefm _wia_ : agegrp agegrpfm sex sexfm _se_ : education educationfm sex sexfm [geography] [industry] _county_naics3 : qwi_geo county countyfm qwi_ind naics3 naics3fm _county_naics4 : qwi_geo county countyfm qwi_ind naics4 naics4fm _county_naicssec : qwi_geo county countyfm qwi_ind naicssec naicssecfm _metro_naics3 : qwi_geo metro metrofm qwi_ind naics3 naics3fm _metro_naics4 : qwi_geo metro metrofm qwi_ind naics4 naics4fm _metro_naicssec : qwi_geo metro metrofm qwi_ind naicssec naicssecfm _naics3 : qwi_ind naics3 naics3fm _naics4 : qwi_ind naics4 naics4fm _wib_naics3 : qwi_geo wib wibfm qwi_ind naics3 naics3fm _wib_naics4 : qwi_geo wib wibfm qwi_ind naics4 naics4fm _wib_naicssec : qwi_geo wib wibfm qwi_ind naicssec naicssecfm Definitions in file names ------------------------------------------------------------ - Demographic or firm characteristics - wia = Workforce Investment Act. Refers to the age categories used. Has gender x age tabulations. rh = Race and Hispanic status se = Education x gender tabulations fa = Firm age tabulations fs = Firm size tabulations - Geographic level of detail - wib = Workforce Investment Board. A geographic area under WIA county = US counties metro = Refers to Core Based Statistical Areas, previously Metropolitan Statistical Areas (msa) 2008 geography is used. See http://www.census.gov/population/metro/files/lists/2008/List1.txt - Industry detail - naics = North American Industry Classification System. Different levels are denoted: - naicssec (NAICS Sectors), - naics3 (3-digit NAICS) and - naics4 (4-digit NAICS). The 2007 NAICS classification is used. - Ownership - all = All ownership categories, excluding federal workers (BLS codes: 2,3,5; QWI code A00) private= Only privately owned firms (BLS codes: 5, QWI code A05) Generic Record Identifiers (SAS lengths, from wia_county_naicssec) ------------------------------------------------------------ 2 state Char 2 Group: FIPS state numeric code 3 year Num 8 Time: Year 4 quarter Num 8 Time: Quarter 5 qwi_geo Char 11 Group: QWI Geocode 6 county Char 3 Group: FIPS County code 7 countyfm Char 64 Group: FIPS County name 8 qwi_ind Char 7 Group: QWI NAICS Industry Code 9 naicssec Char 5 Group: NAICS Sector code 10 naicssecfm Char 113 Group: NAICS Sector name 11 ownercode Char 3 Group: Ownership group code 12 ownerfm Char 15 Group: Ownership group name Demographic Variables (SAS lengths, from _county_naicssec) ------------------------------------------------------------ 13 sex Char 1 Group: Gender code 14 sexfm Char 15 Group: Gender name 15 agegrp Char 3 Group: Age group code (wia) 16 agegrpfm Char 5 Group: Age group name (wia) 17 education Char 2 Group: education code 18 educationfm Char 20 Group: education name 19 ethnicity Char 2 Group: ethnicity code 20 ethnicityfm Char 20 Group: ethnicity name 21 race Char 2 Group: education code 22 racefm Char 20 Group: education name Firm characteristic Variables (SAS lengths, from _county_naicssec) ------------------------------------------------------------ 13 firmage Char 1 Group: firmage code 14 firmagefm Char 29 Group: firmage name 15 firmsize Char 1 Group: firmsize code 16 firmsizefm Char 11 Group: firmsize name QWI formats: naicssec naicssecfm -------------------------------------------------------- 00 All NAICS Sectors 11 11 Agriculture, Forestry, Fishing and Hunting 21 21 Mining, Quarrying, and Oil and Gas Extraction 22 22 Utilities 23 23 Construction 31-33 31-33 Manufacturing 42 42 Wholesale Trade 44-45 44-45 Retail Trade 48-49 48-49 Transportation and Warehousing 51 51 Information 52 52 Finance and Insurance 53 53 Real Estate and Rental and Leasing 54 54 Professional, Scientific, and Technical Services 55 55 Management of Companies and Enterprises 56 56 Administrative and Support and Waste Management and Remediation Services 61 61 Educational Services 62 62 Health Care and Social Assistance 71 71 Arts, Entertainment, and Recreation 72 72 Accommodation and Food Services 81 81 Other Services (except Public Administration) 92 92 Public Administration ownercode ownerfm -------------------------------------------------------- A00 All (1-5) A05 Private (5) sex sexfm ---------------------- 0 Male and Female 1 Male 2 Female agegrp agegrpfm -------------------- A00 14-99 A01 14-18 A02 19-21 A03 22-24 A04 25-34 A05 35-44 A06 45-54 A07 55-64 A08 65-99 education educationfm ------------------------- E0 All Education Groups Together (1-4) E1 Less than high school E2 High school or equivalent, no college E3 Some college or Associate degree E4 Bachelor's degree or advanced degree ethnicity ethnicityfm ------------------------- H0 All (Any Ethinicity) H1 Hispanic or Latino H2 Not Hispanic or Latino race racefm ---------------------- R0 All Races Together (1-6) R1 American Indian or Alaska Native Alone R2 Asian Alone R3 Black or African American Alone R4 Native Hawaiian or Other Pacific Islander Alone R5 White Alone R6 Two or More Race Groups firmage firmagefm ----------------------- 0 All [0-max] 1 0-1 (startups) 2 2-3 3 4-5 4 6-10 5 11+ (including left censored) firmsize firmsizefm ----------------------- 0 All [0-max] 1 0-19 2 20-49 3 50-249 4 250-499 5 500+ Data quality flags (start with s, followed by name of variable) --------------------------------------------------------------- -2 no data available in this category for this quarter -1 data not available to compute this estimate 0 zero employment estimated or zero estimated denominator in a ratio, zero released 1 OK 5 Value suppressed because it does not meet US Census Bureau publication standards. 9 data significantly distorted, distorted value released