Description: Revision of (example for cleaning data in class) Samples selected: 2018 ACS Note: Density of the full data file: 1.0% Density of your extract: 1.0% File Type: rectangular Case Selection: No Variable Columns Len 2018 YEAR H 1-4 4 X SAMPLE H 5-10 6 X SERIAL H 11-18 8 X CBSERIAL H 19-31 13 X HHWT H 32-41 10 X CLUSTER H 42-54 13 X STATEFIP H 55-56 2 X STRATA H 57-68 12 X GQ H 69 1 X PERNUM P 70-73 4 X PERWT P 74-83 10 X SEX P 84 1 X AGE P 85-87 3 X YRMARR P 88-91 4 X EDUC P 92-93 2 X EDUCD P 94-96 3 X Variable Availability Key: All Years X - available in this sample All Years . - not available in this sample RECTYPE Record type 1 Household 2 Person YEAR Census year 1850 1850 1860 1860 1870 1870 1880 1880 1900 1900 1910 1910 1920 1920 1930 1930 1940 1940 1950 1950 1960 1960 1970 1970 1980 1980 1990 1990 2000 2000 2001 2001 2002 2002 2003 2003 2004 2004 2005 2005 2006 2006 2007 2007 2008 2008 2009 2009 2010 2010 2011 2011 2012 2012 2013 2013 2014 2014 2015 2015 2016 2016 2017 2017 2018 2018 SAMPLE IPUMS sample identifier 201804 2014-2018, PRCS 5-year 201803 2014-2018, ACS 5-year 201802 2018 PRCS 201801 2018 ACS 201704 2013-2017, PRCS 5-year 201703 2013-2017, ACS 5-year 201702 2017 PRCS 201701 2017 ACS 201604 2012-2016, PRCS 5-year 201603 2012-2016, ACS 5-year 201602 2016 PRCS 201601 2016 ACS 201504 2011-2015, PRCS 5-year 201503 2011-2015, ACS 5-year 201502 2015 PRCS 201501 2015 ACS 201404 2010-2014, PRCS 5-year 201403 2010-2014, ACS 5-year 201402 2014 PRCS 201401 2014 ACS 201306 2009-2013, PRCS 5-year 201305 2009-2013, ACS 5-year 201304 2011-2013, PRCS 3-year 201303 2011-2013, ACS 3-year 201302 2013 PRCS 201301 2013 ACS 201206 2008-2012, PRCS 5-year 201205 2008-2012, ACS 5-year 201204 2010-2012, PRCS 3-year 201203 2010-2012, ACS 3-year 201202 2012 PRCS 201201 2012 ACS 201106 2007-2011, PRCS 5-year 201105 2007-2011, ACS 5-year 201104 2009-2011, PRCS 3-year 201103 2009-2011, ACS 3-year 201102 2011 PRCS 201101 2011 ACS 201008 2010 Puerto Rico 10% 201007 2010 10% 201006 2006-2010, PRCS 5-year 201005 2006-2010, ACS 5-year 201004 2008-2010, PRCS 3-year 201003 2008-2010, ACS 3-year 201002 2010 PRCS 201001 2010 ACS 200906 2005-2009, PRCS 5-year 200905 2005-2009, ACS 5-year 200904 2007-2009, PRCS 3-year 200903 2007-2009, ACS 3-year 200902 2009 PRCS 200901 2009 ACS 200804 2006-2008, PRCS 3-year 200803 2006-2008, ACS 3-year 200802 2008 PRCS 200801 2008 ACS 200704 2005-2007, PRCS 3-year 200703 2005-2007, ACS 3-year 200702 2007 PRCS 200701 2007 ACS 200602 2006 PRCS 200601 2006 ACS 200502 2005 PRCS 200501 2005 ACS 200401 2004 ACS 200301 2003 ACS 200201 2002 ACS 200101 2001 ACS 200008 2000 Puerto Rico 1% 200007 2000 1% 200006 2000 Puerto Rico 1% sample (old version) 200005 2000 Puerto Rico 5% 200004 2000 ACS 200003 2000 Unweighted 1% 200002 2000 1% sample (old version) 200001 2000 5% 199007 1990 Puerto Rico 1% 199006 1990 Puerto Rico 5% 199005 1990 Labor Market Area 199004 1990 Elderly 199003 1990 Unweighted 1% 199002 1990 1% 199001 1990 5% 198007 1980 Puerto Rico 1% 198006 1980 Puerto Rico 5% 198005 1980 Detailed metro/non-metro 198004 1980 Labor Market Area 198003 1980 Urban/Rural 198002 1980 1% 198001 1980 5% 197009 1970 Puerto Rico Neighborhood 197008 1970 Puerto Rico Municipio 197007 1970 Puerto Rico State 197006 1970 Form 2 Neighborhood 197005 1970 Form 1 Neighborhood 197004 1970 Form 2 Metro 197003 1970 Form 1 Metro 197002 1970 Form 2 State 197001 1970 Form 1 State 196002 1960 5% 196001 1960 1% 195001 1950 1% 194002 1940 100% database 194001 1940 1% 193004 1930 100% database 193003 1930 Puerto Rico 193002 1930 5% 193001 1930 1% 192003 1920 100% database 192002 1920 Puerto Rico sample 192001 1920 1% 191004 1910 100% database 191003 1910 1.4% sample with oversamples 191002 1910 1% 191001 1910 Puerto Rico 190004 1900 100% database 190003 1900 1% sample with oversamples 190002 1900 1% 190001 1900 5% 188003 1880 100% database 188002 1880 10% 188001 1880 1% 187003 1870 100% database 187002 1870 1% sample with black oversample 187001 1870 1% 186003 1860 100% database 186002 1860 1% sample with black oversample 186001 1860 1% 185002 1850 100% database 185001 1850 1% STATEFIP State (FIPS code) 01 Alabama 02 Alaska 04 Arizona 05 Arkansas 06 California 08 Colorado 09 Connecticut 10 Delaware 11 District of Columbia 12 Florida 13 Georgia 15 Hawaii 16 Idaho 17 Illinois 18 Indiana 19 Iowa 20 Kansas 21 Kentucky 22 Louisiana 23 Maine 24 Maryland 25 Massachusetts 26 Michigan 27 Minnesota 28 Mississippi 29 Missouri 30 Montana 31 Nebraska 32 Nevada 33 New Hampshire 34 New Jersey 35 New Mexico 36 New York 37 North Carolina 38 North Dakota 39 Ohio 40 Oklahoma 41 Oregon 42 Pennsylvania 44 Rhode Island 45 South Carolina 46 South Dakota 47 Tennessee 48 Texas 49 Utah 50 Vermont 51 Virginia 53 Washington 54 West Virginia 55 Wisconsin 56 Wyoming State groups (1980 Urban/rural sample): 61 Maine-New Hampshire-Vermont 62 Massachusetts-Rhode Island 63 Minnesota-Iowa-Missouri-Kansas-Nebraska-S.Dakota-N.Dakota 64 Maryland-Delaware 65 Montana-Idaho-Wyoming 66 Utah-Nevada 67 Arizona-New Mexico 68 Alaska-Hawaii 72 Puerto Rico 97 Military/Mil. Reservation 99 State not identified GQ Group quarters status 0 Vacant unit Households: 1 Households under 1970 definition 2 Additional households under 1990 definition Group Quarters: 3 Group quarters--Institutions 4 Other group quarters 5 Additional households under 2000 definition 6 Fragment SEX Sex 1 Male 2 Female AGE Age 000 Less than 1 year old 001 1 002 2 003 3 004 4 005 5 006 6 007 7 008 8 009 9 010 10 011 11 012 12 013 13 014 14 015 15 016 16 017 17 018 18 019 19 020 20 021 21 022 22 023 23 024 24 025 25 026 26 027 27 028 28 029 29 030 30 031 31 032 32 033 33 034 34 035 35 036 36 037 37 038 38 039 39 040 40 041 41 042 42 043 43 044 44 045 45 046 46 047 47 048 48 049 49 050 50 051 51 052 52 053 53 054 54 055 55 056 56 057 57 058 58 059 59 060 60 061 61 062 62 063 63 064 64 065 65 066 66 067 67 068 68 069 69 070 70 071 71 072 72 073 73 074 74 075 75 076 76 077 77 078 78 079 79 080 80 081 81 082 82 083 83 084 84 085 85 086 86 087 87 088 88 089 89 090 90 (90+ in 1980 and 1990) 091 91 092 92 093 93 094 94 095 95 096 96 097 97 098 98 099 99 100 100 (100+ in 1960-1970) 101 101 102 102 103 103 104 104 105 105 106 106 107 107 108 108 109 109 110 110 111 111 112 112 (112+ in the 1980 internal data) 113 113 114 114 115 115 (115+ in the 1990 internal data) 116 116 117 117 118 118 119 119 120 120 121 121 122 122 123 123 124 124 125 125 126 126 129 129 130 130 135 135 EDUC Educational attainment [general version] 00 N/A or no schooling 01 Nursery school to grade 4 02 Grade 5, 6, 7, or 8 03 Grade 9 04 Grade 10 05 Grade 11 06 Grade 12 07 1 year of college 08 2 years of college 09 3 years of college 10 4 years of college 11 5+ years of college EDUCD Educational attainment [detailed version] 000 N/A or no schooling 001 N/A 002 No schooling completed 010 Nursery school to grade 4 011 Nursery school, preschool 012 Kindergarten 013 Grade 1, 2, 3, or 4 014 Grade 1 015 Grade 2 016 Grade 3 017 Grade 4 020 Grade 5, 6, 7, or 8 021 Grade 5 or 6 022 Grade 5 023 Grade 6 024 Grade 7 or 8 025 Grade 7 026 Grade 8 030 Grade 9 040 Grade 10 050 Grade 11 060 Grade 12 061 12th grade, no diploma 062 High school graduate or GED 063 Regular high school diploma 064 GED or alternative credential 065 Some college, but less than 1 year 070 1 year of college 071 1 or more years of college credit, no degree 080 2 years of college 081 Associate's degree, type not specified 082 Associate's degree, occupational program 083 Associate's degree, academic program 090 3 years of college 100 4 years of college 101 Bachelor's degree 110 5+ years of college 111 6 years of college (6+ in 1960-1970) 112 7 years of college 113 8+ years of college 114 Master's degree 115 Professional degree beyond a bachelor's degree 116 Doctoral degree 999 Missing