* Household Income by Zip 2013.

VARIABLE LABELS
STCODE "Identifies records as STATE vs. ZIP summary level: st = state-level figures; zip = zip-level figures"
STFIPS "2-digit FIPS state code"
STATE "2-character state abbreviation"
STATENAME "State name"
ZIP "5-character ZIP code
(99999 = consolidated small and miscelanious zip areas; 00000 = state-level summary records)"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
AGIGROUP "Adjusted Gross Income Group, 0-6:
(AGI Summary Groups 1-6 assigned by IRS; AGI Summary Group 0 = total of AGI groups 1-6 per NCCS)"
AGISIZE "Adjusted Gross Income Size Description (based on AGIGROUP values)"
AGILEV "Adjusted Gross Income Level (based on AGIGROUP values):
u25= under $25,000; 25to50= $25,000 under $50,000; 50to75= $50,000 under $75,000; 75to100= $75,000 under $100,000; 100to200= $100,000 under $200,000; 200ormore= $200,000 or more; tot= total;"
TotReturns2 "Number of Form 1040 return filings"
TotReturns2Sngl "Number of Form 1040 returns: Filing status is single"
TotReturns2Joint "Number of Form 1040 returns: Filing status is married filing jointly"
TotReturns2HeadHh "Number of Form 1040 returns: Filing status is head of household"
PrepareNum2 "Number of returns with paid preparer signature"
ExempDep2 "Number of dependent exemptions claimed (1040:06c)"
ExempTot2 "Number of exemptions claimed (1040:06d)"
CompNum2 "Number of returns with salaries and wages (1040:7 / 1040A:7 / 1040EZ:1)"
Comp2 "Salaries and wages amount, stated in thousands (1040:7 / 1040A:7 / 1040EZ:1)"
TaxIntNum2 "Number of returns with taxable interest (1040:8a / 1040A:8a / 1040EZ:2)"
TaxInt2 "Taxable interest amount, stated in thousands (1040:8a / 1040A:8a / 1040EZ:2)"
TaxODivNum2 "Number of returns with ordinary dividends (1040:9a / 1040A:9a)"
TaxODiv2 "Ordinary dividends amount, stated in thousands (1040:9a / 1040A:9a)"
TaxQDivNum2 "Number of returns with qualified dividends (1040:9b / 1040A:9b)"
TaxQDiv2 "Qualified dividends amount, stated in thousands (1040:9b / 1040A:9b)
[3] "Qualified dividends" are ordinary dividends received in tax years beginning after 2002 that meet certain conditions and receive preferential tax rates. The maximum qualified dividends tax rate is 15%."
N00700 "Number of returns with state and local income tax refunds (1040:10)"
A00700 "State and local income tax refunds amount, stated in thousands (1040:10)"
SchCProfitNum2 "Number of returns with business or professional net income (less loss) (1040:12)"
SchCProfit2 "Business or professional net income (less loss) amount, stated in thousands (1040:12)"
SchDCapGainsNum2 "Number of returns with net capital gain (less loss) (1040:13 1040A:10)"
SchDCapGains2 "Net capital gain (less loss) amount, stated in thousands (1040:13 1040A:10)"
TaxIraNum2 "Number of returns with taxable individual retirement arrangements distributions (1040:15b / 1040:11b)"
TaxIra2 "Taxable individual retirement arrangements distributions amount, stated in thousands (1040:15b / 1040:11b)"
TaxPenNum2 "Number of returns with taxable pensions and annuities (1040:16b / 1040A:12b)"
TaxPen2 "Taxable pensions and annuities amount, stated in thousands (1040:16b / 1040A:12b)"
SchFProfitNum2 "Number of farm returns (1040:18)"
UnemplNum2 "Number of returns with unemployment compensation (1040:19 / 1040A:13 / 1040EZ:3)"
Unempl2 "Unemployment compensation amount, stated in thousands (1040:19 / 1040A:13 / 1040EZ:3)
[4] Includes the Alaskan permanent fund, reported by residents of Alaska on Forms 1040A and 1040EZ. This fund only applies to statistics in the totals, and the state of Alaska."
TaxSocSecNum2 "Number of returns with taxable Social Security benefits (1040:20b / 1040A:14b)"
TaxSocSec2 "Taxable Social Security benefits amount, stated in thousands (1040:20b / 1040A:14b)"
N26270 "Number of returns with partnership/S-corp net income (less loss) (Schedule E:32)"
A26270 "Partnership/S-corp net income (less loss) amount, stated in thousands (Schedule E:32)"
N02650 "Number of returns with total income (1040:22 / 1040A:15 / 1040EZ:4)"
A02650 "Total income amount, stated in thousands (1040:22 / 1040A:15 / 1040EZ:4)"
N03220 "Number of returns with educator expenses (1040:23 / 1040A:16)"
A03220 "Educator expenses amount, stated in thousands (1040:23 / 1040A:16)"
SepSimpNum2 "Number of returns with self-employment retirement plans (1040:28)"
SepSimp2 "Self-employment retirement plans amount, stated in thousands (1040:28)"
N03270 "Number of returns with self-employment health insurance deduction (1040:29)"
A03270 "Self-employment health insurance deduction amount, stated in thousands (1040:29)"
N03150 "Number of returns with IRA payments (1040:32 / 1040A:17)"
A03150 "IRA payments amount, stated in thousands (1040:32 / 1040A:17)"
N03210 "Number of returns with student loan interest deduction (1040:33 / 1040A:18)"
A03210 "Student loan interest deduction amount, stated in thousands (1040:33 / 1040A:18)"
N03230 "Number of returns with tuition and fees deduction (1040:34 / 1040A:19)"
A03230 "Tuition and fees deduction amount, stated in thousands (1040:34 / 1040A:19)"
N03240 "Number of returns with domestic production activities deduction (1040:35)"
A03240 "Domestic production activities deduction amount, stated in thousands (1040:35)"
N02900 "Number of returns with total statutory adjustments (1040:36 / 1040A:20)"
A02900 "Total statutory adjustments amount, stated in thousands (1040:36 / 1040A:20)"
AGI2 "Adjust gross income (AGI), stated in thousands (1040:37 / 1040A:21 / 1040EZ:4)
[2] Does not include returns with adjusted gross deficit."
SchANum2 "Number of returns with itemized deductions (1040:40)"
SchAItemD2 "Total itemized deductions amount, stated in thousands (1040:40)"
SchAagi2 "Amount of AGI for itemized returns, stated in thousands (1040:37)"
SchASLITaxNum2 "Number of returns with State and local income taxes (Schedule A:5a)"
SchASLITax2 "State and local income taxes amount, stated in thousands (Schedule A:5a)"
SchASLSTaxNum2 "Number of returns with State and local general sales tax (Schedule A:5b)"
SchASLSTax2 "State and local general sales tax amount, stated in thousands (Schedule A:5b)"
SchARETaxNum2 "Number of returns with real estate taxes (Schedule A:6)"
SchARETax2 "Real estate taxes amount, stated in thousands (Schedule A:6)"
SchATaxPaidNum2 "Number of returns with taxes paid (Schedule A:9)"
SchATaxPaid2 "Taxes paid amount, stated in thousands (Schedule A:9)"
SchAMortIntNum2 "Number of returns with mortgage interest paid (Schedule A:10)"
SchAMortInt2 "Mortgage interest paid amount, stated in thousands (Schedule A:10)"
ContNum2 "Number of returns with contributions (Schedule A:19)"
Cont2 "Contributions amount, stated in thousands (Schedule A:19)"
TaxableIncNum2 "Number of returns with taxable income (1040:43 / 1040A:27 / 1040EZ:6)"
TaxableInc2 "Taxable income amount, stated in thousands (1040:43 / 1040A:27 / 1040EZ:6)"
MinTaxNum2 "Number of returns with alternative minimum tax (1040:45)"
MinTax2 "Alternative minimum tax amount, stated in thousands (1040:45)"
N05800 "Number of returns with income tax before credits (1040:46 / 1040A:28 / 1040EZ:10)"
A05800 "Income tax before credits amount, stated in thousands (1040:46 / 1040A:28 / 1040EZ:10)"
N07300 "Number of returns with foreign tax credit (1040:47)"
A07300 "Foreign tax credit amount, stated in thousands (1040:47)"
ChDpCareTaxCrNum2 "Number of returns with child and dependent care credit (1040:48 / 1040A:29)"
ChDpCareTaxCr2 "Child and dependent care credit amount, stated in thousands (1040:48 / 1040A:29)"
N07230 "Number of returns with nonrefundable education credit (1040:49 / 1040A:31)"
A07230 "Nonrefundable education credit amount, stated in thousands (1040:49 / 1040A:31)"
N07240 "Number of returns with retirement savings contribution credit (1040:50 / 1040A:32)"
A07240 "Retirement savings contribution credit amount, stated in thousands (1040:50 / 1040A:32)"
ChildTaxCrNum2 "Number of returns with child tax credit (1040:51 / 1040A:33)"
ChildTaxCr2 "Child tax credit amount, stated in thousands (1040:51 / 1040A:33)"
REnergyTaxCrNum2 "Number of returns with residential energy tax credit (1040:52)"
REnergyTaxCr2 "Residential energy tax credit amount, stated in thousands (1040:52)"
TotTaxCrNum2 "Number of returns with total tax credits (1040:54 / 1040A:34)"
TotTaxCr2 "Total tax credits amount, stated in thousands (1040:54 / 1040A:34)"
IncTaxACNum2 "Number of returns with income tax (1040:55 / 1040A:35 / 1040EZ:10)"
IncTaxAC2 "Income tax amount, stated in thousands (1040:55 / 1040A:35 / 1040EZ:10)
[7] Income tax reflects the amount reported on Form 1040 line 55. It also includes data from Form 1040A and 1040EZ filers."
N09400 "Number of returns with self-employment tax (1040:56)"
A09400 "Self-employment tax amount, stated in thousands (1040:56)"
N85330 "Number of returns with Additional Medicare tax (1040:60a)"
A85330 "Additional Medicare tax amount, stated in thousands (1040:60a)"
N85300 "Number of returns with net investment income tax (1040:60b)"
A85300 "Net investment income tax amount, stated in thousands (1040:60b)"
TotTaxNum2 "Number of returns with tax liability (1040:61 / 1040A:35 / 1040EZ: 10)"
TotTax2 "Total tax liability amount, stated in thousands (1040:61 / 1040A:35 / 1040EZ: 10)
[8] "Total tax liability" differs from "Income tax", in that "Total tax liability" includes the taxes from recapture of certain prior-year credits, tax applicable to individual retirement arrangements (IRA's), social security taxes on self-employment income and on certain tip income, advanced earned income payments, household employment taxes, and certain other taxes listed in the Form 1040 instructions."
EITCNum2 "Number of returns with earned income credit (1040:64a / 1040A:38a / 1040EZ:8b)"
EITC2 "Earned income credit amount, stated in thousands (1040:64a / 1040A:38a / 1040EZ:8b)
[5] Earned income credit includes both the refundable and non-refundable portions. The non-refundable portion could reduce income tax and certain related taxes to zero. The earned income credit amounts in excess of total tax liability, or amounts when there was no tax liability at all, were refundable. See footnote 6 below for explanation of the refundable portion of the earned income credit."
ExEITCNum2 "Number of returns with excess earned income credit (1040:64a / 1040A:38a / 1040EZ:8b)"
ExEITC2 "Excess earned income credit (refundable) amount, stated in thousands (1040:64a / 1040A:38a / 1040EZ:8b)
[6] The refundable portion of the earned income credit equals total income tax minus the earned income credit. If the result is negative, this amount is considered the refundable portion. No other refundable credits were taken into account for this calculation."
AddChildTaxCrNum2 "Number of returns with additional child tax credit (1040:65 / 1040A:39)"
AddChildTaxCr2 "Additional child tax credit amount, stated in thousands (1040:65 / 1040A:39)"
N10960 "Number of returns with refundable education credit (1040:66 / 1040A:40)"
A10960 "Refundable education credit amount, stated in thousands (1040:66 / 1040A:40)"
N10600 "Number of returns with total tax payments (1040:72 / 1040A:41 / 1040EZ:9)"
A10600 "Total tax payments amount, stated in thousands (1040:72 / 1040A:41 / 1040EZ:9)"
TaxRefundAmtNum2 "Number of returns with overpayments refunded (1040:73 / 1040A:42 / 1040EZ:11a)"
TaxRefundAmt2 "Overpayments refunded amount, stated in thousands (1040:73 / 1040A:42 / 1040EZ:11a)
[10] The amount of overpayments the tax filer requested to have refunded."
TaxAmtDueNum2 "Number of returns with tax due at time of filing (1040:76 / 1040A:45 / 1040EZ:12)"
TaxAmtDue2 "Tax due at time of filing amount, stated in thousands (1040:76 / 1040A:45 / 1040EZ:12)
[9] Reflects payments to or withholdings made to "Total tax liability". This is the amount the tax filer owes when the income tax return is filed."
.

.
VALUE LABELS AGIGROUP
"0" "TOTAL"
"1" "$1 under $25,000"
"2" "$25,000 under $50,000"
"3" "$50,000 under $75,000"
"4" "$75,000 under $100,000"
"5" "$100,000 under $200,000"
"6" "$200,000 or more"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
STCODE a3
STFIPS a2
STATE a2
stateName a25
ZIP a5
FIPS a5
AGIGROUP f15.0
AGISIZE a30
AGILEV a9
TotReturns2 f15.0
TotReturns2Sngl f15.0
TotReturns2Joint f15.0
TotReturns2HeadHh f15.0
PrepareNum2 f15.0
ExempDep2 f15.0
ExempTot2 f15.0
AGI2 f15.0
N02650 f15.0
A02650 f15.0
CompNum2 f15.0
Comp2 f15.0
TaxIntNum2 f15.0
TaxInt2 f15.0
TaxODivNum2 f15.0
TaxODiv2 f15.0
TaxQDivNum2 f15.0
TaxQDiv2 f15.0
N00700 f15.0
A00700 f15.0
SchCProfitNum2 f15.0
SchCProfit2 f15.0
SchDCapGainsNum2 f15.0
SchDCapGains2 f15.0
TaxIraNum2 f15.0
TaxIra2 f15.0
TaxPenNum2 f15.0
TaxPen2 f15.0
SchFProfitNum2 f15.0
UnemplNum2 f15.0
Unempl2 f15.0
TaxSocSecNum2 f15.0
TaxSocSec2 f15.0
N26270 f15.0
A26270 f15.0
N02900 f15.0
A02900 f15.0
N03220 f15.0
A03220 f15.0
SepSimpNum2 f15.0
SepSimp2 f15.0
N03270 f15.0
A03270 f15.0
N03150 f15.0
A03150 f15.0
N03210 f15.0
A03210 f15.0
N03230 f15.0
A03230 f15.0
N03240 f15.0
A03240 f15.0
SchANum2 f15.0
SchAItemD2 f15.0
SchAagi2 f15.0
SchASLITaxNum2 f15.0
SchASLITax2 f15.0
SchASLSTaxNum2 f15.0
SchASLSTax2 f15.0
SchARETaxNum2 f15.0
SchARETax2 f15.0
SchATaxPaidNum2 f15.0
SchATaxPaid2 f15.0
SchAMortIntNum2 f15.0
SchAMortInt2 f15.0
ContNum2 f15.0
Cont2 f15.0
TaxableIncNum2 f15.0
TaxableInc2 f15.0
N05800 f15.0
A05800 f15.0
MinTaxNum2 f15.0
MinTax2 f15.0
TotTaxCrNum2 f15.0
TotTaxCr2 f15.0
N07300 f15.0
A07300 f15.0
ChDpCareTaxCrNum2 f15.0
ChDpCareTaxCr2 f15.0
N07230 f15.0
A07230 f15.0
N07240 f15.0
A07240 f15.0
ChildTaxCrNum2 f15.0
ChildTaxCr2 f15.0
REnergyTaxCrNum2 f15.0
REnergyTaxCr2 f15.0
N09400 f15.0
A09400 f15.0
N10600 f15.0
A10600 f15.0
EITCNum2 f15.0
EITC2 f15.0
ExEITCNum2 f15.0
ExEITC2 f15.0
AddChildTaxCrNum2 f15.0
AddChildTaxCr2 f15.0
N10960 f15.0
A10960 f15.0
IncTaxACNum2 f15.0
IncTaxAC2 f15.0
TotTaxNum2 f15.0
TotTax2 f15.0
N85330 f15.0
A85330 f15.0
N85300 f15.0
A85300 f15.0
TaxAmtDueNum2 f15.0
TaxAmtDue2 f15.0
TaxRefundAmtNum2 f15.0
TaxRefundAmt2 f15.0
CONTAGI2 a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.