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,486,242,906 (Range of valid codes: 0.0000000000000-1088.9825218000001)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 13 |
| Record/columns: | 1/1951-1962 |
PIRCONSratio of monthly non-mortgage non-revolving consumer debt payments to monthly income
Total Cases:
1,486,242,906 (Range of valid codes: 0.000000000000000-2139.441535800000111)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 15 |
| Record/columns: | 1/1964-1975 |
PIRREVratio of monthly revolving debt payments to monthly income
Total Cases:
1,486,242,906 (Range of valid codes: 0.000000000000000-1086.940906199999972)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 15 |
| Record/columns: | 1/1977-1988 |
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,486,242,906 (Range of valid codes: 0.000000000000000-2152.607329800000116)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 15 |
| Record/columns: | 1/1938-1949 |
PIR40Household has a PIR higher than 40%
| Percent | N | Value | Label | |
|---|---|---|---|---|
| 91.4 | 1,358,225,793 | 0 | no | |
| 8.6 | 128,017,113 | 1 | yes | |
| 100.0 | 1,486,242,906 | Total |
| Properties | |
|---|---|
| Data type: | numeric |
| Record/column: | 1/1990 |
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,486,242,906 (Range of valid codes: 0.00000000000000-64006.09814200000255)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 14 |
| Record/columns: | 1/1367-1378 |
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,486,242,906 (Range of valid codes: 0.0000000000000000-9251.0499999999992724)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 16 |
| Record/columns: | 1/1354-1365 |
DEBT PAYMENTS
PAYMORT1payments on first mortgage, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-274808.72)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1463-1471 |
PAYMORT2payments on second mortgage, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-134977.45)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1473-1481 |
PAYMORT3payments on third mortgage, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-690548.69)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1483-1491 |
PAYMORTOpayments on other loans, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-54668.95)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1493-1500 |
PAYLOC1payments on first line of credit, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-831727.61)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1502-1510 |
PAYLOC2payments on second line of credit, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-199541.67)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1512-1520 |
PAYLOC3payments on third line of credit, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-264761.17)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1522-1530 |
PAYLOCOpayments on other lines of credit, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-4350509.87)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1532-1541 |
PAYHI1payments on first home improvement loan, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-58465.35)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1543-1550 |
PAYHI2payments on second home improvement loan, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-3064.51)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1552-1558 |
PAYLC1payments on first land contract, 2025 dollars
Text of this Question or Item
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-97405.39)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1560-1567 |
PAYLC2payments on second land contract, 2025 dollars
Text of this Question or Item
Assumed to be interest payments on amount outstanding, at 8 percent APR
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-97947.24)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1569-1576 |
PAYLCOpayments on other land contracts, 2025 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,486,211,864 | 0.00 | ||
| 0.0 | 21 | 0.16 | ||
| 0.0 | 1,515 | 95.39 | ||
| 0.0 | 605 | 102.12 | ||
| 0.0 | 35 | 119.63 | ||
| 0.0 | 17,366 | 598.16 | ||
| 0.0 | 700 | 788.69 | ||
| 0.0 | 1,396 | 797.65 | ||
| 0.0 | 1,336 | 806.61 | ||
| 0.0 | 37 | 933.71 | ||
| 0.0 | 31 | 1035.84 | ||
| 0.0 | 39 | 1648.59 | ||
| 0.0 | 1,774 | 1714.08 | ||
| 0.0 | 155 | 1736.90 | ||
| 0.0 | 5,835 | 2257.97 | ||
| 0.0 | 38 | 2523.95 | ||
| 0.0 | 10 | 5925.49 | ||
| 0.0 | 15 | 6266.41 | ||
| 0.0 | 11 | 8425.57 | ||
| 0.0 | 16 | 10146.39 | ||
| 0.0 | 24 | 12175.67 | ||
| 0.0 | 22 | 12905.57 | ||
| 0.0 | 22 | 17443.65 | ||
| 0.0 | 18 | 28344.97 | ||
| 0.0 | 4 | 523445.74 | ||
| 0.0 | 5 | 524672.25 | ||
| 0.0 | 4 | 530668.50 | ||
| 0.0 | 5 | 534620.58 | ||
| 0.0 | 4 | 537073.59 | ||
| 100.0 | 1,486,242,906 | Total |
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1578-1586 |
PAYORE1payments on first other resdential property, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-490281.54)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1588-1596 |
PAYORE2payments on second other resdential property, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-374277.42)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1598-1606 |
PAYORE3payments on third other resdential property, 2025 dollars
Text of this Question or Item
Only available for 1989, 1992, 1995, 1998, 2001, 2004, and 2007.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-252776.66)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1618-1626 |
PAYOREVpayments on remaining other resdential properties, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-742295.00)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1608-1616 |
PAYVEH1payments on first vehicle, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-8610.67)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1628-1634 |
PAYVEH2payments on second vehicle, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-7828.69)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1636-1642 |
PAYVEH3payments on third vehicle, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-6216.19)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1644-1650 |
PAYVEH4payments on fourth vehicle, 2025 dollars
Text of this Question or Item
Not available for 1989 and 1992.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-4580.15)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1652-1658 |
PAYVEHMpayments on remaining vehicles, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-5046.36)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1660-1666 |
PAYVEO1payment on first other vehicle, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-1246574.91)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1668-1677 |
PAYVEO2payment on second other vehicle, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-378654.94)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1679-1687 |
PAYVEOMpayment on remaining other vehicles, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-139547.02)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1689-1697 |
PAYEDU1payments on first education loan, 2025 dollars
Text of this Question or Item
Not available for 1989.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-18140.15)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1699-1706 |
PAYEDU2payments on second education loan, 2025 dollars
Text of this Question or Item
Not available for 1989.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-7660.65)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1708-1714 |
PAYEDU3payments on third education loan, 2025 dollars
Text of this Question or Item
Not available for 1989.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-3401.28)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1716-1722 |
PAYEDU4payments on fourth education loan, 2025 dollars
Text of this Question or Item
Not available for 1989.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-1995.42)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1724-1730 |
PAYEDU5payments on fifth education loan, 2025 dollars
Text of this Question or Item
Not available for 1989.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-2965.33)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1732-1738 |
PAYEDU6payments on sixth education loan, 2025 dollars
Text of this Question or Item
Not available for 1989.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-3343.11)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1740-1746 |
PAYEDU7payments on seventh education loan, 2025 dollars
Text of this Question or Item
Not available for 1989 and 1992.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-4178.88)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1748-1754 |
PAYILN1payments on first installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-716207.61)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1756-1764 |
PAYILN2payments on second installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-1560116.35)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1766-1775 |
PAYILN3payments on third installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-581436.02)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1777-1785 |
PAYILN4payments on fourth installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-97099.08)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1787-1794 |
PAYILN5payments on fifth installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-80610.56)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1796-1803 |
PAYILN6payments on sixth installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-142900.54)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1805-1813 |
PAYILN7payments on seventh installment loan, 2025 dollars
Text of this Question or Item
Loans for nonresidential property not included. Not available for 1989, and 1992.
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-59862.50)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1815-1822 |
PAYMARGpayments on margin loans, 2025 dollars
Text of this Question or Item
Assumed to be interest payments on balance outstanding, paid at 8 percent APR
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-564910.72)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1824-1832 |
PAYINSpayments on loans against insurance policies, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-36556.39)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1834-1841 |
PAYPEN1payments on loan against first pension plan not previously reported, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-21596.39)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1843-1850 |
PAYPEN2payments on loan against second pension plan not previously reported, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-25793.54)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1852-1859 |
PAYPEN3payments on loan against third pension plan not previously reported, 2025 dollars
Text of this Question or Item
Not available for 2010.
| Percent | N | Value | Label | |
|---|---|---|---|---|
| 100.0 | 1,486,104,677 | 0.00 | ||
| 0.0 | 20,015 | 1.31 | ||
| 0.0 | 7,845 | 1.89 | ||
| 0.0 | 6,805 | 2.39 | ||
| 0.0 | 699 | 11.14 | ||
| 0.0 | 14,605 | 19.95 | ||
| 0.0 | 14,678 | 39.91 | ||
| 0.0 | 18,324 | 59.86 | ||
| 0.0 | 7,112 | 109.92 | ||
| 0.0 | 6,891 | 133.74 | ||
| 0.0 | 7,201 | 140.95 | ||
| 0.0 | 6,943 | 183.21 | ||
| 0.0 | 9,338 | 239.45 | ||
| 0.0 | 15 | 298.27 | ||
| 0.0 | 3,471 | 876.99 | ||
| 0.0 | 1,588 | 1064.92 | ||
| 0.0 | 3,378 | 1425.11 | ||
| 0.0 | 3,564 | 1472.09 | ||
| 0.0 | 1,574 | 1597.38 | ||
| 0.0 | 1,620 | 2035.87 | ||
| 0.0 | 163 | 2198.47 | ||
| 0.0 | 328 | 2975.51 | ||
| 0.0 | 501 | 3732.43 | ||
| 0.0 | 1,571 | 4071.75 | ||
| 100.0 | 1,486,242,906 | Total |
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1861-1867 |
PAYPEN4payments on loan against fourth pension plan not previously reported, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-10962.39)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1869-1876 |
PAYPEN5payments on loan against fifth pension plan not previously reported, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-10994.61)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1878-1885 |
PAYPEN6payments on loan against sixth pension plan not previously reported, 2025 dollars
Text of this Question or Item
Not available for 2010.
| Percent | N | Value | Label | |
|---|---|---|---|---|
| 100.0 | 1,486,175,357 | 0.00 | ||
| 0.0 | 15,502 | 23.86 | ||
| 0.0 | 7,036 | 33.93 | ||
| 0.0 | 3,068 | 120.37 | ||
| 0.0 | 1,223 | 149.03 | ||
| 0.0 | 5,121 | 206.35 | ||
| 0.0 | 5,167 | 240.74 | ||
| 0.0 | 5,122 | 257.94 | ||
| 0.0 | 1,376 | 275.13 | ||
| 0.0 | 5,082 | 292.33 | ||
| 0.0 | 6,812 | 313.21 | ||
| 0.0 | 5,096 | 412.70 | ||
| 0.0 | 6,942 | 1879.27 | ||
| 100.0 | 1,486,242,906 | Total |
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1887-1893 |
REVPAYtotal monthly revolving debt payments, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-4426196.71)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1927-1936 |
MORTPAYtotal monthly mortgage payments, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-778103.06)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1906-1914 |
CONSPAYtotal monthly consumer debt payments, 2025 dollars
Total Cases:
1,486,242,906 (Range of valid codes: 0.00-1780204.19)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1916-1925 |
TPAYTotal value of monthly debt payments, 2025 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,486,242,906 (Range of valid codes: 0.00-4426196.71)
| Properties | |
|---|---|
| Data type: | numeric |
| Decimals: | 2 |
| Record/columns: | 1/1895-1904 |