Go to top or bottom of previous codebook page

SCF Combined Extract Data

RATIOS

PIRMORTratio of monthly mortgage payments to monthly income
Total Cases: 1,219,972,825 (Range of valid codes: 0.0000000000000-1087.2857587999999)
Properties
Data type: numeric
Decimals: 13
Record/columns: 1/1880-1891
PIRCONSratio of monthly non-mortgage non-revolving consumer debt payments to monthly income
Total Cases: 1,219,972,825 (Range of valid codes: 0.000000000000000-2136.334591899999850)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1893-1904
PIRREVratio of monthly revolving debt payments to monthly income
Total Cases: 1,219,972,825 (Range of valid codes: 0.000000000000000-917.910865220000005)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1906-1917
PIRTOTALRatio of monthly debt payments to monthly income
Text of this Question or Item 
See definition of TPAY for types of debt payments included in PIRTOTAL
Total Cases: 1,219,972,825 (Range of valid codes: 0.000000000000000-2149.481266299999788)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1867-1878
PIR40Household has a PIR higher than 40%
Percent N Value Label
91.2 1,112,218,700 0 no
8.8 107,754,125 1 yes

100.0 1,219,972,825
Total
Properties
Data type: numeric
Record/column: 1/1919
DEBT2INCRatio of total debt to total income
Text of this Question or Item 
If no income, an arbitraty value of 10 is assigned
Total Cases: 1,219,972,825 (Range of valid codes: 0.00000000000000-64008.37297799999942)
Properties
Data type: numeric
Decimals: 14
Record/columns: 1/1299-1310
LEVRATIORatio of total debt to total assets
Text of this Question or Item 
See definition of DEBT and ASSET for more information
Total Cases: 1,219,972,825 (Range of valid codes: 0.0000000000000000-4166.6666666999999507)
Properties
Data type: numeric
Decimals: 16
Record/columns: 1/1286-1297

DEBT PAYMENTS

PAYMORT1payments on first mortgage, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-216634.84)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1395-1403
PAYMORT2payments on second mortgage, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-106357.24)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1405-1413
PAYMORT3payments on third mortgage, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-544350.89)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1415-1423
PAYMORTOpayments on other loans, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-43093.99)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1425-1432
PAYLOC1payments on first line of credit, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-625697.40)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1434-1442
PAYLOC2payments on second line of credit, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-157318.20)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1444-1452
PAYLOC3payments on third line of credit, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-208664.46)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1454-1462
PAYLOCOpayments on other lines of credit, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-3429878.09)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1464-1473
PAYHI1payments on first home improvement loan, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-46093.22)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1475-1482
PAYHI2payments on second home improvement loan, 2019 dollars
Percent N Value Label
99.9 1,219,223,078 0.00
0.0 52,613 17.88
0.0 17,860 53.18
0.0 23,874 58.91
0.0 11,724 148.90
0.0 17,610 159.54
0.0 69,785 179.01
0.0 35,327 212.71
0.0 11,881 216.91
0.0 31,943 217.01
0.0 20,134 218.78
0.0 20,446 219.63
0.0 18,882 230.47
0.0 34,801 238.67
0.0 21,466 283.78
0.0 25,709 298.34
0.0 16,068 298.83
0.0 24,887 314.56
0.0 45,214 406.70
0.0 4,686 420.00
0.0 18,292 430.00
0.0 3,141 497.24
0.0 51,368 500.00
0.0 19,886 530.21
0.0 32,680 550.48
0.0 8,406 566.21
0.0 25,556 584.26
0.0 25,954 1469.00
0.0 21,288 1728.17
0.0 14,042 1851.62
0.0 3,239 2170.11
0.0 20,988 2415.97

100.0 1,219,972,825
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1484-1490
PAYLC1payments on first land contract, 2019 dollars
Text of this Question or Item 
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-76781.91)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1492-1499
PAYLC2payments on second land contract, 2019 dollars
Text of this Question or Item 
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-77208.36)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1501-1508
PAYLCOpayments on other land contracts, 2019 dollars
Text of this Question or Item 
Assumed to be interest payments on amount outstanding, at 8 percent APR
Percent N Value Label
100.0 1,219,941,784 0.00
0.0 21 0.13
0.0 1,515 75.18
0.0 605 80.52
0.0 35 94.32
0.0 17,366 471.59
0.0 700 621.78
0.0 1,396 628.84
0.0 1,336 635.91
0.0 37 736.14
0.0 31 816.65
0.0 39 1299.74
0.0 1,774 1351.15
0.0 155 1368.61
0.0 5,835 1779.19
0.0 38 1989.87
0.0 10 4670.90
0.0 15 4939.64
0.0 11 6641.64
0.0 16 7998.12
0.0 24 9597.74
0.0 22 10171.18
0.0 22 13747.75
0.0 18 22343.54
0.0 4 412539.81
0.0 5 413506.45
0.0 4 418232.24
0.0 5 421346.96
0.0 4 423280.24

100.0 1,219,972,825
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1510-1518
PAYORE1payments on first other resdential property, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-349160.57)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1520-1528
PAYORE2payments on second other resdential property, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-228668.07)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1530-1538
PAYORE3payments on third other resdential property, 2019 dollars
Text of this Question or Item 
Only available for 1989, 1992, 1995, 1998, 2001, 2004, and 2007.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-199285.41)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1550-1558
PAYOREVpayments on remaining other resdential properties, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-585079.87)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1540-1548
PAYVEH1payments on first vehicle, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-6787.89)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1560-1566
PAYVEH2payments on second vehicle, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-6168.72)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1568-1574
PAYVEH3payments on third vehicle, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-4900.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1576-1582
PAYVEH4payments on fourth vehicle, 2019 dollars
Text of this Question or Item 
Not available for 1989 and 1992.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-3610.58)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1584-1590
PAYVEHMpayments on remaining vehicles, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-3977.91)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1592-1598
PAYVEO1payment on first other vehicle, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-982659.40)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1600-1608
PAYVEO2payment on second other vehicle, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-165411.03)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1610-1618
PAYVEOMpayment on remaining other vehicles, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-110000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1620-1628
PAYEDU1payments on first education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-14301.65)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1630-1637
PAYEDU2payments on second education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-4507.15)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1639-1645
PAYEDU3payments on third education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-2681.56)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1647-1653
PAYEDU4payments on fourth education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-1572.80)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1655-1661
PAYEDU5payments on fifth education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-2337.04)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1663-1669
PAYEDU6payments on sixth education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-2635.61)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1671-1677
PAYEDU7payments on seventh education loan, 2019 dollars
Text of this Question or Item 
Not available for 1989 and 1992.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-3294.51)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1679-1685
PAYILN1payments on first installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-564577.49)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1687-1695
PAYILN2payments on second installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-1229950.62)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1697-1706
PAYILN3payments on third installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-458338.73)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1708-1716
PAYILN4payments on fourth installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-76544.31)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1718-1725
PAYILN5payments on fifth installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-63546.22)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1727-1734
PAYILN6payments on sixth installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-112650.11)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1736-1744
PAYILN7payments on seventh installment loan, 2019 dollars
Text of this Question or Item 
Loans for nonresidential property not included. Not available for 1989, and 1992.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-47183.86)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1746-1753
PAYMARGpayments on margin loans, 2019 dollars
Text of this Question or Item 
Assumed to be interest payments on balance outstanding, paid at 8 percent APR
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-445299.22)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1755-1763
PAYINSpayments on loans against insurance policies, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-28805.09)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1765-1772
PAYPEN1payments on loan against first pension plan not previously reported, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-17017.16)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1774-1781
PAYPEN2payments on loan against second pension plan not previously reported, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-20335.25)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1783-1790
PAYPEN3payments on loan against third pension plan not previously reported, 2019 dollars
Text of this Question or Item 
Not available for 2010.
Percent N Value Label
100.0 1,219,834,597 0.00
0.0 20,015 1.03
0.0 7,845 1.49
0.0 6,805 1.88
0.0 699 8.78
0.0 14,605 15.73
0.0 14,678 31.46
0.0 18,324 47.18
0.0 7,112 86.65
0.0 6,891 105.40
0.0 7,201 111.10
0.0 6,943 144.42
0.0 9,338 188.74
0.0 15 235.16
0.0 3,471 691.27
0.0 1,588 839.40
0.0 3,378 1123.31
0.0 3,564 1160.35
0.0 1,574 1259.10
0.0 1,620 1604.73
0.0 163 1733.08
0.0 328 2345.38
0.0 501 2942.01
0.0 1,571 3209.47

100.0 1,219,972,825
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1792-1798
PAYPEN4payments on loan against fourth pension plan not previously reported, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-8640.87)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1800-1806
PAYPEN5payments on loan against fifth pension plan not previously reported, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-8666.67)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1808-1814
PAYPEN6payments on loan against sixth pension plan not previously reported, 2019 dollars
Text of this Question or Item 
Not available for 2010.
Percent N Value Label
100.0 1,219,905,277 0.00
0.0 15,502 18.81
0.0 7,036 26.75
0.0 3,068 94.90
0.0 1,223 117.49
0.0 5,121 162.68
0.0 5,167 189.80
0.0 5,122 203.35
0.0 1,376 216.91
0.0 5,082 230.47
0.0 6,812 246.88
0.0 5,096 325.36
0.0 6,942 1481.29

100.0 1,219,972,825
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1816-1822
REVPAYtotal monthly revolving debt payments, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-3489548.48)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1856-1865
MORTPAYtotal monthly mortgage payments, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-587910.90)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1835-1843
CONSPAYtotal monthly consumer debt payments, 2019 dollars
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-1403461.52)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1845-1854
TPAYTotal value of monthly debt payments, 2019 dollars
Text of this Question or Item 
Includes payments on credit cards, mortgages, home equity loans, 
home equity lines of credit, other home improvement loans, loans 
for other residential real estate, vehicle loans, education loans, 
installment loans, margin loans, loans against the cash value of 
life insurance, pension loans and other miscellaneous loans.
Total Cases: 1,219,972,825 (Range of valid codes: 0.00-3489548.48)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1824-1833
Go to Next Page of Codebook