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,351,279,215 (Range of valid codes: 0.0000000000000-1088.9825218000001)
Properties
Data type: numeric
Decimals: 13
Record/columns: 1/1909-1920
PIRCONSratio of monthly non-mortgage non-revolving consumer debt payments to monthly income
Total Cases: 1,351,279,215 (Range of valid codes: 0.000000000000000-2139.441535800000111)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1922-1933
PIRREVratio of monthly revolving debt payments to monthly income
Total Cases: 1,351,279,215 (Range of valid codes: 0.000000000000000-919.440716670000029)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1935-1946
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,351,279,215 (Range of valid codes: 0.000000000000000-2152.607329800000116)
Properties
Data type: numeric
Decimals: 15
Record/columns: 1/1896-1907
PIR40Household has a PIR higher than 40%
Percent N Value Label
91.4 1,234,922,109 0 no
8.6 116,357,106 1 yes

100.0 1,351,279,215
Total
Properties
Data type: numeric
Record/column: 1/1948
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,351,279,215 (Range of valid codes: 0.00000000000000-64006.09814200000255)
Properties
Data type: numeric
Decimals: 14
Record/columns: 1/1325-1336
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,351,279,215 (Range of valid codes: 0.0000000000000000-4166.6666666999999507)
Properties
Data type: numeric
Decimals: 16
Record/columns: 1/1312-1323

DEBT PAYMENTS

PAYMORT1payments on first mortgage, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-251109.41)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1421-1429
PAYMORT2payments on second mortgage, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-123337.09)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1431-1439
PAYMORT3payments on third mortgage, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-630996.25)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1441-1449
PAYMORTOpayments on other loans, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-49954.34)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1451-1458
PAYLOC1payments on first line of credit, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-760000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1460-1468
PAYLOC2payments on second line of credit, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-182333.33)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1470-1478
PAYLOC3payments on third line of credit, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-241928.35)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1480-1488
PAYLOCOpayments on other lines of credit, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-3975324.96)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1490-1499
PAYHI1payments on first home improvement loan, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-53423.34)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1501-1508
PAYHI2payments on second home improvement loan, 2022 dollars
Percent N Value Label
99.9 1,350,299,797 0.00
0.0 52,613 20.72
0.0 40,521 30.00
0.0 17,860 61.67
0.0 23,874 68.29
0.0 11,724 172.67
0.0 17,610 185.01
0.0 116,183 200.00
0.0 69,785 207.50
0.0 35,327 246.67
0.0 11,881 251.40
0.0 31,943 251.61
0.0 20,134 253.61
0.0 20,446 254.57
0.0 18,882 267.12
0.0 34,801 276.67
0.0 21,466 329.02
0.0 1,726 340.00
0.0 25,709 345.84
0.0 16,068 346.43
0.0 6,919 350.00
0.0 24,887 364.67
0.0 64,323 400.00
0.0 45,214 471.38
0.0 4,686 486.87
0.0 18,292 498.46
0.0 3,141 576.40
0.0 51,368 579.60
0.0 19,886 614.61
0.0 32,680 638.17
0.0 8,406 656.40
0.0 25,556 677.40
0.0 25,954 1703.18
0.0 21,288 2003.40
0.0 14,042 2146.50
0.0 3,239 2516.05
0.0 20,988 2800.23

100.0 1,351,279,215
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1510-1516
PAYLC1payments on first land contract, 2022 dollars
Text of this Question or Item 
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-89005.21)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1518-1525
PAYLC2payments on second land contract, 2022 dollars
Text of this Question or Item 
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-89500.34)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1527-1534
PAYLCOpayments on other land contracts, 2022 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,351,248,173 0.00
0.0 21 0.15
0.0 1,515 87.17
0.0 605 93.32
0.0 35 109.32
0.0 17,366 546.58
0.0 700 720.67
0.0 1,396 728.86
0.0 1,336 737.05
0.0 37 853.19
0.0 31 946.51
0.0 39 1506.42
0.0 1,774 1566.26
0.0 155 1587.11
0.0 5,835 2063.24
0.0 38 2306.28
0.0 10 5414.48
0.0 15 5726.00
0.0 11 7698.95
0.0 16 9271.38
0.0 24 11125.65
0.0 22 11792.61
0.0 22 15939.32
0.0 18 25900.52
0.0 4 478304.15
0.0 5 479424.88
0.0 4 484904.02
0.0 5 488515.28
0.0 4 490756.74

100.0 1,351,279,215
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1536-1544
PAYORE1payments on first other resdential property, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-448000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1546-1554
PAYORE2payments on second other resdential property, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-342000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1556-1564
PAYORE3payments on third other resdential property, 2022 dollars
Text of this Question or Item 
Only available for 1989, 1992, 1995, 1998, 2001, 2004, and 2007.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-230977.38)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1576-1584
PAYOREVpayments on remaining other resdential properties, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-678280.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1566-1574
PAYVEH1payments on first vehicle, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-7868.09)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1586-1592
PAYVEH2payments on second vehicle, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-7153.55)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1594-1600
PAYVEH3payments on third vehicle, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-5680.11)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1602-1608
PAYVEH4payments on fourth vehicle, 2022 dollars
Text of this Question or Item 
Not available for 1989 and 1992.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-4185.16)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1610-1616
PAYVEHMpayments on remaining vehicles, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-4611.17)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1618-1624
PAYVEO1payment on first other vehicle, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-1139071.16)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1626-1635
PAYVEO2payment on second other vehicle, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-346000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1637-1645
PAYVEOMpayment on remaining other vehicles, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-127512.58)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1647-1655
PAYEDU1payments on first education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-16575.76)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1657-1664
PAYEDU2payments on second education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-7000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1666-1672
PAYEDU3payments on third education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-3107.95)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1674-1680
PAYEDU4payments on fourth education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-1823.33)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1682-1688
PAYEDU5payments on fifth education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-2709.60)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1690-1696
PAYEDU6payments on sixth education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-3054.80)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1698-1704
PAYEDU7payments on seventh education loan, 2022 dollars
Text of this Question or Item 
Not available for 1989 and 1992.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-3818.50)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1706-1712
PAYILN1payments on first installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-654442.36)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1714-1722
PAYILN2payments on second installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-1425573.01)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1724-1733
PAYILN3payments on third installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-531293.38)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1735-1743
PAYILN4payments on fourth installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-88725.33)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1745-1752
PAYILN5payments on fifth installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-73658.76)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1754-1761
PAYILN6payments on sixth installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-130576.89)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1763-1771
PAYILN7payments on seventh installment loan, 2022 dollars
Text of this Question or Item 
Loans for nonresidential property not included. Not available for 1989, and 1992.
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-54700.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1773-1780
PAYMARGpayments on margin loans, 2022 dollars
Text of this Question or Item 
Assumed to be interest payments on balance outstanding, paid at 8 percent APR
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-516193.22)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1782-1790
PAYINSpayments on loans against insurance policies, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-33403.80)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1792-1799
PAYPEN1payments on loan against first pension plan not previously reported, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-19733.93)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1801-1808
PAYPEN2payments on loan against second pension plan not previously reported, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-23569.12)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1810-1817
PAYPEN3payments on loan against third pension plan not previously reported, 2022 dollars
Text of this Question or Item 
Not available for 2010.
Percent N Value Label
100.0 1,351,140,987 0.00
0.0 20,015 1.20
0.0 7,845 1.73
0.0 6,805 2.18
0.0 699 10.18
0.0 14,605 18.23
0.0 14,678 36.47
0.0 18,324 54.70
0.0 7,112 100.44
0.0 6,891 122.20
0.0 7,201 128.79
0.0 6,943 167.41
0.0 9,338 218.80
0.0 15 272.55
0.0 3,471 801.36
0.0 1,588 973.08
0.0 3,378 1302.21
0.0 3,564 1345.14
0.0 1,574 1459.62
0.0 1,620 1860.30
0.0 163 2008.88
0.0 328 2718.90
0.0 501 3410.55
0.0 1,571 3720.60

100.0 1,351,279,215
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1819-1825
PAYPEN4payments on loan against fourth pension plan not previously reported, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-10017.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1827-1834
PAYPEN5payments on loan against fifth pension plan not previously reported, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-10046.45)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1836-1843
PAYPEN6payments on loan against sixth pension plan not previously reported, 2022 dollars
Text of this Question or Item 
Not available for 2010.
Percent N Value Label
100.0 1,351,211,667 0.00
0.0 15,502 21.80
0.0 7,036 31.01
0.0 3,068 109.99
0.0 1,223 136.18
0.0 5,121 188.55
0.0 5,167 219.98
0.0 5,122 235.69
0.0 1,376 251.40
0.0 5,082 267.12
0.0 6,812 286.20
0.0 5,096 377.11
0.0 6,942 1717.20

100.0 1,351,279,215
Total
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1845-1851
REVPAYtotal monthly revolving debt payments, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-4044484.61)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1885-1894
MORTPAYtotal monthly mortgage payments, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-711000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1864-1872
CONSPAYtotal monthly consumer debt payments, 2022 dollars
Total Cases: 1,351,279,215 (Range of valid codes: 0.00-1626680.63)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1874-1883
TPAYTotal value of monthly debt payments, 2022 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,351,279,215 (Range of valid codes: 0.00-4044484.61)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1853-1862
Go to Next Page of Codebook