* HOUSING FILE Variable label SCRIPT *This is the imperfect SPSS import file for 2005 U.S. Census Bureau American Community * Survey PUMS data. HOUSING FILE * - - - - - - http://factfinder.census.gov/home/en/acs_pums_2005.html * * Another source of already improved PUMS data is: * http://www.ipums.org/ * * *This script was written by David Huskins, at the Center for Policy Studies at the * University of Akron - A State Data Center * It may be used without restriction, although it is copywritten and may *not be passed off as the work of someone else. *It was written, in pieces, in January & February 2007. * I used the Census Bureau's data dictionary, and mostly recycled their variable names. * LENGTH of labels forced me to abbreviate. I also chose to lengthen and clarify some labels that I thought were ambiguous. * A SPSS script for the POPULATION Records is in the works. * * The Center for Policy Studies is a division of the Institute for Health and Social Policy, a multipurpose research institute. * The Center for Policy Studies is a well established research facility providing quality survey research support to university *researchers, and national, state, community and other public service agencies. In addition to survey research support the *Center also coordinates the University of Akron participation in the Ohio Board of Regents Urban University Program, *and houses the Data Services Manager responsible for our activities as a State Data Center under the auspices * of the state of Ohio Department of Development. * http://www.uakron.edu/centers/cps/ *This file and the data import script to use with it are available on the department's ACS data page. * - http://www3.uakron.edu/src/DataServ/ACS/ * *Most fields imported as TEXT, rather than numbers. Converting them to numbers is easy in SPSS. * Converting them back, after you've lost your leading zeros (vital for GIS) is not easy. * Switching from numbers to text or text to numbers will cause SPSS to blank your value labels. * To avoid this, you may want to keep your original TEXT variable, and create a numeric version right next to it. * * ///////////////////////////////////////////////////////// * * Instructions: * USE this file second. * First. download the 2005 ACS PUMS HOUSING RECORD file you want. This script should work for any State or the national data. * Select CSV (comma separated values) as the format. * Download the files. You'll need to unzip the data files after they are downloaded. Download everything you need before opening anything. * You may want to select a longer and more intuitive file name (including the year, state and type of Census data) or have discrete folders/directories * if you have multiple datasets. Generic names like "datafile.sav" will come back to hurt you later. * Once you have the file(s) where you want them (they will be very large), open SPSS. * Since the datafiles will have the extension of .CSV, SPSS will not see them unless you select ALL *.* as "File Type". * Most software packages look for their own files only by default. SPSS can open a variety of file types. *Click on your data file. * Since it is not an SPSS file, it will open a screen that asks if your file matches a predefined format. * YES, it does. Click browse, and go find the SPSS import script that matches this file. It is: * Huskins_ACS2005-PUMS_Housing-ImportSPSS.tpf * This file will format the variables as they come into SPSS. * -- Click FINISH twice. * * *You will now have a new SPSS file, with variable names, but no variable labels and no value labels. * Open this file (if you're reading printed instructions, and it isn't already open...) * THIS script file - the one you are now reading - will add labels to these new variables for you. * In the Edit pull down menu, click Select All * RUN this script. *Your result should be an SPSS file with all the labels. * SAVE IT. * Good luck. Send CPS any feedback on snags. This file may or may not work with ACS PUMS files for years other than 2005. * * FILE LABEL 'ACS 2005 PUMS Data'. variable label RT 'Record Type (Housing portion of ACS 2005PUMS file)'. variable label SERIALNO 'Housing unit/GQ person serial number'. variable label DIVISION 'Division code'. variable label PUMA 'Public use microdata area code (PUMA)'. variable label REGION 'Region code'. variable label ST 'State FIPS Code - 2 digit'. variable label ADJUST 'Adjustment factor for dollar amounts (6 implied decimal places)'. variable label WGTP 'Housing Weight'. variable label NP 'Number of person records following this housing record'. variable label TYPE 'Type of unit'. variable label ACR 'Lot size'. variable label AGS 'Sales of Agriculture Products'. variable label BDS 'Bedrooms'. variable label BLD 'Units in structure'. variable label BUS 'Business or medical office on property'. variable label CONP 'Condo fee (monthly amount)'. variable label ELEP 'Electricity (monthly cost)'. variable label FS 'Food stamp amount'. variable label FULP 'House heating fuel (yearly cost)'. variable label GASP 'Gas (monthly cost)'. variable label HFL 'House heating fuel'. variable label INSP 'Fire/hazard/flood insurance (yearly amount)'. variable label KIT 'Complete kitchen facilities'. variable label MHP 'Mobile home costs (yearly amount)'. variable label MRGI 'Payment include fire/hazard/flood insurance'. variable label MRGP 'Mortgage payment (monthly amount)'. variable label MRGT 'Payment include real estate taxes'. variable label MRGX 'Mortgage status'. variable label PLM 'Complete plumbing facilities'. variable label RMS 'Rooms'. variable label RNTM 'Meals included in rent'. variable label RNTP 'Monthly rent'. variable label SMP 'Second mortgage payment (monthly amount)'. variable label SRM 'Second residence months'. variable label SRR 'Second residence reason'. variable label SRX 'Second residence checkbox'. variable label TEL 'Telephone in Unit'. variable label TEN 'Tenure'. variable label VACS 'Vacancy status'. variable label VAL 'Property value'. variable label VEH 'Vehicles (1 ton or less) available'. variable label WATP 'Water (yearly cost)'. variable label YBL 'When structure first built'. variable label FES 'Family type and employment status'. variable label FINCP 'Family income'. variable label FPARC 'Family presence and age of related children'. variable label GRNTP 'Gross rent'. variable label GRPIP 'Gross rent as a percentage of household income past 12 months'. variable label HHL 'Household language'. variable label HHT 'Household/family type'. variable label HINCP 'Household income'. variable label HUGCL 'Flag to indicate grandchild living in housing unit'. variable label HUPAC 'Family presence and age of children'. variable label HUPAOC 'HH presence and age of own children'. variable label HUPARC 'HH presence and age of related children'. variable label LNGI 'Linguistic isolation'. variable label MV 'When moved into this house or apartment'. variable label NOC 'Number of own children in household (unweighted)'. variable label NPF 'Number of persons in family (unweighted)'. variable label NPP 'Grandparent headed household with no parent present'. variable label NR 'Presence of nonrelative in household'. variable label NRC 'Number of related children in household (unweighted)'. variable label OCPIP 'Unmarried partner household'. variable label PARTNER 'Unmarried partner household'. variable label PSF 'Presence of subfamilies in Household'. variable label R18 'Presence of persons under 18 years in household (unweighted)'. variable label R60 'Presence of persons 60 years and over in household (unweighted)'. variable label R65 'Presence of persons 65 years and over in household (unweighted)'. variable label RESMODE 'Response mode'. variable label SMOCP 'Selected monthly owner costs'. variable label SMX 'Second mortgage or home equity loan status'. variable label SRNT 'Specified rent unit'. variable label SVAL 'Specified value unit'. variable label TAXP 'Property taxes (yearly amount)'. variable label WIF 'Workers in family during the past 12 months'. variable label WKEXREL 'Work experience of HH and spouse'. variable label WORKSTAT 'Work status of HH or spouse in family households'. variable label FACRP 'Lot size allocation'. variable label FAGSP 'Sales of Agricultural Products allocation'. variable label FBDSP 'Number of bedrooms allocation'. variable label FBLDP 'Units in structure allocation'. variable label FBUSP 'Business or medical office on property allocation'. variable label FCONP 'Condominium fee allocation'. variable label FELEP 'Electricity (monthly cost) allocation'. variable label FFSP 'Food stamp amount (yearly amount) allocation'. variable label FFULP 'House heating fuel (yearly cost) allocation'. variable label FGASP 'Gas (monthly cost) allocation'. variable label FHFLP 'House heating fuel allocation'. variable label FINSP 'Fire, hazard, flood insurance allocation'. variable label FKITP 'Complete kitchen facilities allocation'. variable label FMHP 'Mobile home costs allocation'. variable label FMRGIP 'Payment include fire, hazard, flood insurance'. variable label FMRGP 'Regular mortgage payment allocation'. variable label FMRGTP 'Payment include real estate taxes allocation'. variable label FMRGXP 'Mortgage status allocation'. variable label FMVYP 'When moved into this house or apartment allocation'. variable label FPLMP 'Complete plumbing facilities allocation'. variable label FRMSP 'Rooms allocation'. variable label FRNTMP 'Meals included in rent allocation'. variable label FRNTP 'Monthly rent allocation'. variable label FSMP 'Second mortgage payment allocation'. variable label FSMXHP 'Home equity loan status allocation'. variable label FSMXSP 'Second mortgage status allocation'. variable label FTAXP 'Taxes on property allocation'. variable label FTELP 'Telephones in house allocation'. variable label FTENP 'Tenure allocation'. variable label FVACSP 'Vacancy status allocation'. variable label FVALP 'Value allocation'. variable label FVEHP 'Vehicles available by household allocation'. variable label FWATP 'Water (yearly cost) allocation'. variable label FYBLP 'When structure first built allocation'. variable label WGTP1 'Housing Weight replicate 1'. variable label WGTP2 'Housing Weight replicate 2'. variable label WGTP3 'Housing Weight replicate 3'. variable label WGTP4 'Housing Weight replicate 4'. variable label WGTP5 'Housing Weight replicate 5'. variable label WGTP6 'Housing Weight replicate 6'. variable label WGTP7 'Housing Weight replicate 7'. variable label WGTP8 'Housing Weight replicate 8'. variable label WGTP9 'Housing Weight replicate 9'. variable label WGTP10 'Housing Weight replicate 10'. variable label WGTP11 'Housing Weight replicate 11'. variable label WGTP12 'Housing Weight replicate 12'. variable label WGTP13 'Housing Weight replicate 13'. variable label WGTP14 'Housing Weight replicate 14'. variable label WGTP15 'Housing Weight replicate 15'. variable label WGTP16 'Housing Weight replicate 16'. variable label WGTP17 'Housing Weight replicate 17'. variable label WGTP18 'Housing Weight replicate 18'. variable label WGTP19 'Housing Weight replicate 19'. variable label WGTP20 'Housing Weight replicate 20'. variable label WGTP21 'Housing Weight replicate 21'. variable label WGTP22 'Housing Weight replicate 22'. variable label WGTP23 'Housing Weight replicate 23'. variable label WGTP24 'Housing Weight replicate 24'. variable label WGTP25 'Housing Weight replicate 25'. variable label WGTP26 'Housing Weight replicate 26'. variable label WGTP27 'Housing Weight replicate 27'. variable label WGTP28 'Housing Weight replicate 28'. variable label WGTP29 'Housing Weight replicate 29'. variable label WGTP30 'Housing Weight replicate 30'. variable label WGTP31 'Housing Weight replicate 31'. variable label WGTP32 'Housing Weight replicate 32'. variable label WGTP33 'Housing Weight replicate 33'. variable label WGTP34 'Housing Weight replicate 34'. variable label WGTP35 'Housing Weight replicate 35'. variable label WGTP36 'Housing Weight replicate 36'. variable label WGTP37 'Housing Weight replicate 37'. variable label WGTP38 'Housing Weight replicate 38'. variable label WGTP39 'Housing Weight replicate 39'. variable label WGTP40 'Housing Weight replicate 40'. variable label WGTP41 'Housing Weight replicate 41'. variable label WGTP42 'Housing Weight replicate 42'. variable label WGTP43 'Housing Weight replicate 43'. variable label WGTP44 'Housing Weight replicate 44'. variable label WGTP45 'Housing Weight replicate 45'. variable label WGTP46 'Housing Weight replicate 46'. variable label WGTP47 'Housing Weight replicate 47'. variable label WGTP48 'Housing Weight replicate 48'. variable label WGTP49 'Housing Weight replicate 49'. variable label WGTP50 'Housing Weight replicate 50'. variable label WGTP51 'Housing Weight replicate 51'. variable label WGTP52 'Housing Weight replicate 52'. variable label WGTP53 'Housing Weight replicate 53'. variable label WGTP54 'Housing Weight replicate 54'. variable label WGTP55 'Housing Weight replicate 55'. variable label WGTP56 'Housing Weight replicate 56'. variable label WGTP57 'Housing Weight replicate 57'. variable label WGTP58 'Housing Weight replicate 58'. variable label WGTP59 'Housing Weight replicate 59'. variable label WGTP60 'Housing Weight replicate 60'. variable label WGTP61 'Housing Weight replicate 61'. variable label WGTP62 'Housing Weight replicate 62'. variable label WGTP63 'Housing Weight replicate 63'. variable label WGTP64 'Housing Weight replicate 64'. variable label WGTP65 'Housing Weight replicate 65'. variable label WGTP66 'Housing Weight replicate 66'. variable label WGTP67 'Housing Weight replicate 67'. variable label WGTP68 'Housing Weight replicate 68'. variable label WGTP69 'Housing Weight replicate 69'. variable label WGTP70 'Housing Weight replicate 70'. variable label WGTP71 'Housing Weight replicate 71'. variable label WGTP72 'Housing Weight replicate 72'. variable label WGTP73 'Housing Weight replicate 73'. variable label WGTP74 'Housing Weight replicate 74'. variable label WGTP75 'Housing Weight replicate 75'. variable label WGTP76 'Housing Weight replicate 76'. variable label WGTP77 'Housing Weight replicate 77'. variable label WGTP78 'Housing Weight replicate 78'. variable label WGTP79 'Housing Weight replicate 79'. variable label WGTP80 'Housing Weight replicate 80'. value labels RT 'H' 'PUMS Housing record'. value labels DIVISION 1 'New England (Northeast region)' 2 'Middle Atlantic (Northeast region)' 3 'East North Central (Midwest region)' 4 'West North Central (Midwest region)' 5 'South Atlantic (South region)' 6 'East South Central (South region)' 7 'West South Central (South Region)' 8 'Mountain (West region)' 9 'Pacific (West region) '. value labels REGION 1 'Northeast' 2 'Midwest' 3 'South' 4 'West '. value labels ST 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' 72 'Puerto Rico'. value labels TYPE 1 'Housing unit' 2 'Institutional group quarters' 3 'Noninstitutional group quarters'. value labels NP 01 'One person in household or any person in group quarters)'. value labels ACR 1 'House on less than one acre ' 2 'House on one to less than ten acres ' 3 'House on ten or more acres '. value labels AGS 1 'None ' 2 '$ 1 - $ 999 ' 3 '$ 1000 - $ 2499 ' 4 '$ 2500 - $ 4999 ' 5 '$ 5000 - $ 9999 ' 6 '$10000+ '. value labels BDS 0 'No bedrooms' 1 '1 Bedroom ' 2 '2 Bedrooms ' 3 '3 Bedrooms ' 4 '4 Bedrooms ' 5 '5 or more bedrooms '. value labels BLD 01 'Mobile home or trailer ' 02 'One-family house detached' 03 'One-family house attached' 04 '2 Apartments' 05 '3-4 Apartments' 06 '5-9 Apartments' 07 '10-19 Apartments' 08 '20-49 Apartments' 09 '50 or more apartments' 10 'Boat, RV, van, etc.'. value labels BUS 1 'Yes ' 2 'No '. value labels ELEP 001 'Included in rent or in condo fee ' 002 'No charge or electricity not used' 003 'Electricity (monthly cost) = $3 dollars' 999 'Electricity (monthly cost) = $999 dollars - top coded'. value labels FS 0 'None ' . value labels FULP 0001 'Included in rent or in condo fee ' 0002 'No charge or these fuels not used' 0003 'House heating fuel (yearly cost) - $3' 9999 'House heating fuel (yearly cost) - $9999 - top coded'. value labels GASP 001 'Included in rent or in condo fee ' 002 'Included in electricity payment' 003 'No charge or gas not used' 004 ' Gas (monthly cost) - $4' 999 ' Gas (monthly cost) - $999 (Rounded and top-coded) '. value labels HFL 1 'Utility gas' 2 'Bottled, tank, or LP gas' 3 'Electricity' 4 'Fuel oil, kerosene, etc.' 5 'Coal or coke ' 6 'Wood ' 7 'Solar energy' 8 'Other fuel ' 9 'No fuel used'. value labels INSP 0000 'None ' 0001 'Fire/hazard/flood insurance (yearly amount) - $1' 9999 'Fire/hazard/flood ins. - $9999 (Rounded, top-coded) '. value labels KIT 1 'Yes, has all three facilities' 2 'No' . value labels MHP 00000 'Mobile home costs (yearly amount) $0' 99999 'Mobile home costs (yearly) $99999 (Rounded, top-coded) '. value labels MHP 00000 '$0' 99999 '$99,999 (Rounded and top-coded) '. value labels MRGI 1 'Yes, insurance included in payment' 2 'No, insurance paid separately or no insurance '. value labels MRGP 00001 '$1' 99999 '$99999 (Rounded and top-coded) '. value labels MRGT 1 'Yes, taxes included in payment' 2 'No, taxes paid separately or taxes not required '. value labels MRGX 1 'Mortgage deed of trust, or similar debt' 2 'Contract to purchase' 3 'None '. value labels PLM 1 'Yes, has all three plumbing facilities' 2 'No - incomplete plumbing'. value labels RMS 1 '1 Room ' 2 '2 Rooms ' 3 '3 Rooms ' 4 '4 Rooms ' 5 '5 Rooms ' 6 '6 Rooms ' 7 '7 Rooms ' 8 '8 Rooms ' 9 '9 or more rooms '. value labels RNTM 1 'Yes, meals included in rent' 2 'No, meals not included in rent'. value labels RNTP 00001 '$1 - monthly rent' 99999 '$99999 (Rounded and top-coded) '. value labels SMP 00001 '$1 second mortgage payment' 99999 '$99999 (Rounded and top-coded) '. value labels SRM 1 '1 month in 2nd residence' 2 '2 months in 2nd residence' 3 '3 months in 2nd residence' 4 '4 months in 2nd residence' 5 '5 months in 2nd residence' 6 '6 months in 2nd residence' 7 '7 months in 2nd residence' 8 '8 months in 2nd residence' 9 '9 months in 2nd residence' 10 '10 months in 2nd residence' 11 '11 months in 2nd residence'. value labels SRR 1 'Second residence is: Permanent address' 2 'Second residence is: Seasonal or vacation address ' 3 'Second residence is: To be close to work ' 4 'Second residence is: Attend school or college' 5 'Second residence is: Looking for permanent housing' 6 'Second residence is: Other reason '. value labels SRX 1 'Yes' 2 'No '. value labels TEL 1 'Yes - telephone in unit' 2 'No telephone in unit'. value labels TEN 1 'Owned with mortgage or loan' 2 'Owned free and clear' 3 'Rented for cash rent' 4 'No cash rent '. value labels VACS 1 'For rent' 2 'Rented, not occupied' 3 'For sale only' 4 'Sold, not occupied' 5 'For seasonal/recreational/occasional use' 6 'For migratory workers' 7 'Other vacant '. value labels VAL 01 'Less than $ 10000' 02 '$ 10000 - $ 14999' 03 '$ 15000 - $ 19999' 04 '$ 20000 - $ 24999' 05 '$ 25000 - $ 29999' 06 '$ 30000 - $ 34999' 07 '$ 35000 - $ 39999' 08 '$ 40000 - $ 49999' 09 '$ 50000 - $ 59999' 10 '$ 60000 - $ 69999' 11 '$ 70000 - $ 79999' 12 '$ 80000 - $ 89999' 13 '$ 90000 - $ 99999' 14 '$100000 - $124999' 15 '$125000 - $149999' 16 '$150000 - $174999' 17 '$175000 - $199999' 18 '$200000 - $249999' 19 '$250000 - $299999' 20 '$300000 - $399999' 21 '$400000 - $499999 ' 22 '$500000 - $749999 ' 23 '$750000 - $999999 ' 24 '$1000000+'. value labels VEH 0 'No vehicles' 1 '1 vehicle ' 2 '2 vehicles ' 3 '3 vehicles ' 4 '4 vehicles ' 5 '5 vehicles ' 6 '6 or more vehicles ' . value labels WATP 0001 'Included in rent or in condo fee ' 0002 'No charge' 0003 '$3' 9999 '$9999 (Rounded and top-coded) '. value labels YBL 1 '2005 or later ' 2 '2000 to 2004 ' 3 '1990 to 1999 ' 4 '1980 to 1989 ' 5 '1970 to 1979 ' 6 '1960 to 1969 ' 7 '1950 to 1959 ' 8 '1940 to 1949 ' 9 '1939 or earlier'. value labels FES 1 'Married-couple family: Husb. and wife in LF' 2 'Married-couple family: Husb. in labor force, wife not in LF ' 3 'Married-couple family: Husb. not in LF,wife in LF ' 4 'Married-couple family: Neither Husb. nor wife in LF ' 5 'Other family: Male HH, no wife present in LF ' 6 'Other family: Male HH, no wife presentnot in LF ' 7 'Other family: Female HH, no Husb. present, in LF' 8 'Other family: Female HH, no Husb. present, not in LF '. value labels FINCP 00000000 'No family income' -59999 'Total family income in dollars - negatives possible' 99999999 'Total family income in dollars, topcoded'. value labels FPARC 1 'With related children under 5 years only' 2 'With related children 5 to 17 years only' 3 'With related children under 5 years and 5 to 17 years' 4 'No related children' . value labels GRNTP 0001 '$1 gross rent ' 9999 '$9999 gross rent'. value labels GRPIP 001 'Gross Rent = 1% HH income' 100 'Gross Rent = 100% HH income' 101 'Gross Rent = 101% or more HH income -topcoded '. value labels HHL 1 'Household language: English only' 2 'Household language: Spanish' 3 'Household language: Other Indo-European language' 4 'Household language: Asian or Pacific Island language' 5 'Household language: Other language '. value labels HHT 1 'Married-couple family household' 2 'Male householder, no wife present' 3 'Female householder, no husband present' 4 'Male householder: Living alone' 5 'Male householder, non-family: Not living alone' 6 'Female householder: Living alone' 7 'Female householder, non-family: Not living alone'. value labels HINCP 00000000 'No household income' -59999 'Total household income in dollars - negatives possible' 99999999 'Total household income in dollars, topcoded'. value labels HUGCL 0 'HU does not contain grandchildren' 1 'HU does contain grandchildren '. value labels HUPAC 1 'With children under 6 years only' 2 'With children 6 to 17 years only' 3 'With children under 6 years and 6 to 17 years' 4 'No children '. value labels HUPAOC 1 'Presence of own children under 6 years only' 2 'Presence of own children 6 to 17 years only' 3 'Presence of own children under 6 years and 6 to 17 years' 4 'No own children present '. value labels HUPARC 1 'Presence of related children under 6 years only' 2 'Presence of related children 6 to 17 years only' 3 'Presence of related children under 6 years and 6 to 17 years' 4 'No related children present ' . value labels LNGI 1 'Not linguistically isolated' 2 'Linguistically isolated '. value labels MV 1 '12 months or less ' 2 '13 to 23 months ' 3 '2 to 4 years' 4 '5 to 9 years' 5 '10 to 19 years' 6 '20 to 29 years' 7 '30 years or more '. value labels NOC 00 'No own children ' 01 '1 own child in household' 02 '2 own children in household' 03 '3 own children in household' 04 '4 own children in household' 05 '5 own children in household' 06 '6 own children in household' 07 '7 own children in household' 08 '8 own children in household' 09 '9 own children in household' 10 '10 own children in household' 11 '11 own children in household' 12 '12 own children in household' 13 '13 own children in household' 14 '14 own children in household' 15 '15 own children in household' 16 '16 own children in household' 17 '17 own children in household' 18 '18 own children in household' 19 '19+ own children in household - TOPCODE'. value labels NPF 02 '2 people in family' 03 '3 people in family' 04 '4 people in family' 05 '5 people in family' 06 '6 people in family' 07 '7 people in family' 08 '8 people in family' 09 '9 people in family' 10 '10 people in family' 11 '11 people in family' 12 '12 people in family' 13 '13 people in family' 14 '14 people in family' 15 '15 people in family' 16 '16 people in family' 17 '17 people in family' 18 '18 people in family' 19 '19 people in family' 20 '20+ people in family -Topcode'. value labels NPP 0 'Not a grandparent headed household with no parent present' 1 'Grandparent headed household with no parent present '. value labels NR 0 'No nonrelatives in household ' 1 '1 or more nonrelatives in HH'. value labels NRC 00 'No related children ' 01 '1 related child in household' 02 '2 related children in household' 03 '3 related children in household' 04 '4 related children in household' 05 '5 related children in household' 06 '6 related children in household' 07 '7 related children in household' 08 '8 related children in household' 09 '9 related children in household' 10 '10 related children in household' 11 '11 related children in household' 12 '12 related children in household' 13 '13 related children in household' 14 '14 related children in household' 15 '15 related children in household' 16 '16 related children in household' 17 '17 related children in household' 18 '18 related children in household' 19 '19+ related children in household - TOPCODE'. value labels OCPIP 001 'Selected monthly owner costs = 1% HH income' 100 'Selected monthly owner costs = 100% HH income' 101 'Sel. monthly owner costs = 101%+ HH income -topcoded '. value labels PARTNER 0 'No unmarried partner in household' 1 'Male householder, male partner' 2 'Male householder, female partner' 3 'Female householder, male partner' 4 'Female householder, female partner' . value labels PSF 0 'No subfamilies in household' 1 '1 or more subfamilies in household' . value labels R18 0 'No person under 18 in household' 1 '1 or more persons under 18 in household '. value labels R60 0 'No person 60 and over' 1 '1 person 60 and over' 2 '2 or more persons 60 and over '. value labels R65 0 'No person 65 and over' 1 '1 person 65 and over' 2 '2 or more persons 65 and over '. value labels RESMODE 1 'Mail ' 2 'CATI/CAPI '. value labels SMOCP 00000 'No owner costs ' 00001 '$1 selected monthly owner costs' 99999 '$99,999 selected monthly owner costs - topcoded'. value labels SMX 1 'Yes, a second mortgage' 2 'Yes, a home equity loan' 3 'No second mortgage or home equity loan ' 4 'Both a second mortgage and a home equity loan '. value labels SRNT 0 'Not specified rent unit' 1 'Specified rent unit'. value labels SVAL 0 'Not specified owner unit' 1 'Specified VALUE unit'. value labels TAXP 01 'No property taxes' 02 '$ 1 - $ 49 = yearly property taxes' 03 '$ 50 - $ 99 = yearly property taxes' 04 '$ 100 - $ 149 = yearly property taxes' 05 '$ 150 - $ 199 = yearly property taxes' 06 '$ 200 - $ 249 = yearly property taxes' 07 '$ 250 - $ 299 = yearly property taxes' 08 '$ 300 - $ 349 = yearly property taxes' 09 '$ 350 - $ 399 = yearly property taxes' 10 '$ 400 - $ 449 = yearly property taxes' 11 '$ 450 - $ 499 = yearly property taxes' 12 '$ 500 - $ 549 = yearly property taxes' 13 '$ 550 - $ 599 = yearly property taxes' 14 '$ 600 - $ 649 = yearly property taxes' 15 '$ 650 - $ 699 = yearly property taxes' 16 '$ 700 - $ 749 = yearly property taxes' 17 '$ 750 - $ 799 = yearly property taxes' 18 '$ 800 - $ 849 = yearly property taxes' 19 '$ 850 - $ 899 = yearly property taxes' 20 '$ 900 - $ 949 = yearly property taxes' 21 '$ 950 - $ 999 = yearly property taxes' 22 '$1000 - $1099 = yearly property taxes' 23 '$1100 - $1199 = yearly property taxes' 24 '$1200 - $1299 = yearly property taxes' 25 '$1300 - $1399 = yearly property taxes' 26 '$1400 - $1499 = yearly property taxes' 27 '$1500 - $1599 = yearly property taxes' 28 '$1600 - $1699 = yearly property taxes' 29 '$1700 - $1799 = yearly property taxes' 30 '$1800 - $1899 = yearly property taxes' 31 '$1900 - $1999 = yearly property taxes' 32 '$2000 - $2099 = yearly property taxes' 33 '$2100 - $2199 = yearly property taxes' 34 '$2200 - $2299 = yearly property taxes' 35 '$2300 - $2399 = yearly property taxes' 36 '$2400 - $2499 = yearly property taxes' 37 '$2500 - $2599 = yearly property taxes' 38 '$2600 - $2699 = yearly property taxes' 39 '$2700 - $2799 = yearly property taxes' 40 '$2800 - $2899 = yearly property taxes' 41 '$2900 - $2999 = yearly property taxes' 42 '$3000 - $3099 = yearly property taxes' 43 '$3100 - $3199 = yearly property taxes' 44 '$3200 - $3299 = yearly property taxes' 45 '$3300 - $3399 = yearly property taxes' 46 '$3400 - $3499 = yearly property taxes' 47 '$3500 - $3599 = yearly property taxes' 48 '$3600 - $3699 = yearly property taxes' 49 '$3700 - $3799 = yearly property taxes' 50 '$3800 - $3899 = yearly property taxes' 51 '$3900 - $3999 = yearly property taxes' 52 '$4000 - $4099 = yearly property taxes' 53 '$4100 - $4199 = yearly property taxes' 54 '$4200 - $4299 = yearly property taxes' 55 '$4300 - $4399 = yearly property taxes' 56 '$4400 - $4499 = yearly property taxes' 57 '$4500 - $4599 = yearly property taxes' 58 '$4600 - $4699 = yearly property taxes' 59 '$4700 - $4799 = yearly property taxes' 60 '$4800 - $4899 = yearly property taxes' 61 '$4900 - $4999 = yearly property taxes' 62 '$5000 - $5499 = yearly property taxes' 63 '$5500 - $5999 = yearly property taxes' 64 '$6000 - $6999 = yearly property taxes' 65 '$7000 - $7999 = yearly property taxes' 66 '$8000 - $8999 = yearly property taxes' 67 '$9000 - $9999 = yearly property taxes' 68 '$10,000+ yearly property taxes'. value labels WIF 0 'No workers' 1 '1 worker' 2 '2 workers' 3 '3 or more workers in family '. value labels WKEXREL 1 'Householder and spouse worked FT' 2 'Householder worked FT; spouse worked < FT' 3 'Householder worked FT; spouse did not work' 4 'Householder worked < FT; spouse worked FT' 5 'Householder worked < FT; spouse worked < FT' 6 'Householder worked < FT; spouse did not work' 7 'Householder did not work; spouse worked FT' 8 'Householder did not work; spouse worked < FT' 9 'Householder did not work; spouse did not work' 10 'Male householder worked FT; no spouse present' 11 'Male householder worked < FT; no spouse present' 12 'Male householder did not work; no spouse present' 13 'Female householder worked FT; no spouse present' 14 'Female householder worked < FT; no spouse present' 15 'Female householder did not work; no spouse present '. value labels WORKSTAT 1 'Husb/wife both labor force, both employed/ArmedForces.' 2 'Husb./wife in labor force, Husb. emp/ArmedFcs., wife unemp.' 3 'Husb. labor force,wife not, Husb.emp/ArmedFcs.' 4 'Husb./wife in labor force, Husb. unemp., wife emp/ArmedFcs.' 5 'Husb./wife both labor force, both unemployed' 6 'Husb. labor force, Husb. unemp., wife not labor force ' 7 'Husb. not labor force, wife labor force, wife.emp/ArmedFcs.' 8 'Husb. not labor force, wife labor force, wife.unemp.' 9 'Neither Husb. nor wife labor force ' 10 'Male HHldr. no wife , HHldr.labor force, emp/ArmedFcs.' 11 'Male HHldr. no wife , HHldr.labor force and unemp.' 12 'Male HHldr. no wife , HHldr. Not labor force ' 13 'Fem. HHldr. no Husb., in labor force, emp/ArmedFcs.' 14 'Fem. HHldr. no Husb. In labor force and unemp.' 15 'Fem. HHldr. no Husb. Not in labor force '. value labels FACRP 0 'No ' 1 'Yes'. value labels FAGSP 0 'No ' 1 'Yes'. value labels FBDSP 0 'No ' 1 'Yes'. value labels FBLDP 0 'No ' 1 'Yes'. value labels FBUSP 0 'No ' 1 'Yes'. value labels FCONP 0 'No ' 1 'Yes'. value labels FELEP 0 'No ' 1 'Yes'. value labels FFSP 0 'No ' 1 'Yes'. value labels FFULP 0 'No ' 1 'Yes'. value labels FGASP 0 'No ' 1 'Yes'. value labels FHFLP 0 'No ' 1 'Yes'. value labels FINSP 0 'No ' 1 'Yes'. value labels FKITP 0 'No ' 1 'Yes'. value labels FMHP 0 'No ' 1 'Yes'. value labels FMRGIP 0 'No ' 1 'Yes'. value labels FMRGP 0 'No ' 1 'Yes'. value labels FMRGTP 0 'No ' 1 'Yes'. value labels FMRGXP 0 'No ' 1 'Yes'. value labels FMVYP 0 'No ' 1 'Yes'. value labels FPLMP 0 'No ' 1 'Yes'. value labels FRMSP 0 'No ' 1 'Yes'. value labels FRNTMP 0 'No ' 1 'Yes'. value labels FRNTP 0 'No ' 1 'Yes'. value labels FSMP 0 'No ' 1 'Yes'. value labels FSMXHP 0 'No ' 1 'Yes'. value labels FSMXSP 0 'No ' 1 'Yes'. value labels FTAXP 0 'No ' 1 'Yes'. value labels FTELP 0 'No ' 1 'Yes'. value labels FTENP 0 'No ' 1 'Yes'. value labels FVACSP 0 'No ' 1 'Yes'. value labels FVALP 0 'No ' 1 'Yes'. value labels FVEHP 0 'No ' 1 'Yes'. value labels FWATP 0 'No ' 1 'Yes'. value labels FYBLP 0 'No ' 1 'Yes'.