SCF Combined Extract Data



NVEHIC
total number of vehicles (owned and leased)
Percent
N
Value
Label
13.0
141,935,856
0

36.1
393,964,353
1

34.1
372,127,127
2

11.6
126,542,755
3

3.5
37,957,367
4

1.2
12,650,577
5

0.3
3,326,887
6

0.1
1,242,680
7

0.1
795,331
8

0.0
193,882
9

0.0
514,822
10

0.0
2,839
11

0.0
75,327
12

0.0
129
13

0.0
99
14

0.0
19
24

0.0
29
30

0.0
316
40


100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/columns: 1/890-891


NEWCAR1
number of car/truck/SUV with model year no older than two years before the survey
Percent
N
Value
Label
75.4
823,257,857
0

21.0
229,419,829
1

3.3
36,062,851
2

0.2
2,314,309
3

0.0
241,073
4

0.0
34,131
5

0.0
345
6


100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/893


NEWCAR2
number of car/truck/SUV with model year no older than one year before the survey
Percent
N
Value
Label
83.8
913,998,466
0

14.7
160,017,739
1

1.5
16,510,838
2

0.1
702,694
3

0.0
94,468
4

0.0
6,189
5


100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/895


FARMBUS
compute value of business part of farm net of outstanding mortgages, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: -3433811.40200000-72491304.43099999)
Properties
Data type: numeric
Decimals: 8
Record/columns: 1/897-908


NHNFIN
total nonfinancial assets excluding principal residences, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: -61396356.35-4901854299.66)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1021-1033

DEBTS



HDEBT
Household has any debt
Percent
N
Value
Label
25.0
272,371,806
0
No
75.0
818,958,589
1
Yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1254


DEBT
Total value of debt held by household, 2016 dollars
Text of this Question or Item
Includes principal residence debt (mortgages and HELOCs), other lines 
of credit, debt for other residential property, credit card debt, 
installment loans,and other debt.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-293486997.64)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1241-1252


LATE
Household had any late debt payments in last year
Percent
N
Value
Label
84.2
919,186,557
0
no
15.8
172,143,838
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/236


LATE60
Household had any debt payments more than 60 days past due in last year
Percent
N
Value
Label
94.0
1,025,578,958
0
no
6.0
65,751,436
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/238


HPAYDAY
Household had a payday loan within the past year
Percent
N
Value
Label
98.5
1,074,644,102
0
no
1.5
16,686,293
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/240


MRTHEL
Total value of debt seucred by the primary residence held by household, 2016 dollars
Text of this Question or Item
Includes the following types of loans; mortgages, home equity loans 
and HELOCs secured by the primary residence
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-55343811.16)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1061-1071


NH_MORT
Total value of mortgages and home equity loans secured by the primary residence held by household, 2016 dollars
Text of this Question or Item
Includes all mortgages and home equity loans secured by the primary 
residence
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-35337360.55)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1073-1083


HMORT2
Have junior lien mortgage not used for purchase of primary residence
Percent
N
Value
Label
96.4
1,051,970,616
0
no
3.6
39,359,779
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1104


HPRIM_MORT
Have first lien mortgage on primary residence
Percent
N
Value
Label
58.5
637,918,987
0
no
41.5
453,411,408
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1098


HSEC_MORT
Have junior lien mortgage on primary residence
Percent
N
Value
Label
95.4
1,041,465,635
0
no
4.6
49,864,760
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1100


PURCH1
First lien on primary residence used for purchase of primary residence
Text of this Question or Item
Not available for 1989 and 1992.
Percent
N
Value
Label
79.3
715,582,056
0
no
20.7
186,810,618
1
yes



188,937,720
.
(No Data)

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/2201


PURCH2
Junior lien on primary residence used for purchase of primary residence
Percent
N
Value
Label
99.0
1,080,685,746
0
no
1.0
10,644,648
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1102


REFIN_EVER
Refinanced first lien mortgage on primary residence
Text of this Question or Item
Not available for 1989 and 1992.
Percent
N
Value
Label
78.4
707,348,254
0
no
21.6
195,044,420
1
yes



188,937,720
.
(No Data)

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/2203


HELOC
Total value of home equity lines of credit secured by the primary residence held by the household, 2016 dollars
Text of this Question or Item
Includes only those home equity lines of credit secured by the 
primary residence.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-40068167.65)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1049-1059


HELOC_YN
Currently borrowing on home equity line of credit
Percent
N
Value
Label
91.9
1,002,564,029
0
no
8.1
88,766,365
1
yes

100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/column: 1/1106


RESDBT
Total value of debt for other residential property held by households, 2016 dollars
Text of this Question or Item
Includes land contracts, loans for residential property 
other than the principal residence, misc vacation, and 
installment debt reported for cottage or vacation home. 
Debt for nonresidential real estate is netted out of the 
corresponding assets.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-87547564.66)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1157-1167


OTHLOC
Total value of other lines of credit held by household, 2016 dollars
Text of this Question or Item
Consists of  lines of credit other than those secured by the primary 
residence.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-293486997.64)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1108-1119


CCBAL
Total value of credit card balances held by household, 2016 dollars
Text of this Question or Item
Credit card balances consist of the amount outstanding on all credit 
cards and revolving store accounts after the last payment.  Balances 
do not include purchases made since the last account statement
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-286029.71)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1169-1177


INSTALL
Total value of installment loans held by household, 2016 dollars
Text of this Question or Item
Installment loans consist of loans for vehicles, education loans 
and other installment type loans (such as loans for durables or 
hospital bills).
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-290957110.47)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1203-1214


EDN_INST
Total value of education loans held by household, 2016 dollars
Text of this Question or Item
Includes education loans that are currently in deferment and 
loans in scheduled repayment period.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-699337.59)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1193-1201


VEH_INST
Total value of vehicle loans held by household, 2016 dollars
Text of this Question or Item
Installment loans for all types of vehicles (cars, trucks, 
SUVs, motorcycles, boats, airplanes, etc.).
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-46660000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1181-1191


OTH_INST
Total value of other installment loans held by household, 2016 dollars
Text of this Question or Item
Miscellaneous installment loans, such as those for durables or medical bills. 
Does not include loans for vehicles and education loans.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-290957110.47)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1216-1227


ODEBT
Total value of other debts held by household, 2016 dollars
Text of this Question or Item
Includes loans against pensions, loans against life insurance, margin 
loans, and miscellaneous loans.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-57900750.90)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1229-1239


LLOAN1
Total balance of household loans where the lender is a commercial bank, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-290957110.47)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1995-2006


LLOAN2
Total balance of household loans where the lender is saving and loan, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-13399476.70)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2008-2018


LLOAN3
Total balance of household loans where the lender is credit union, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-10633262.70)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2020-2030


LLOAN4
Total balance of household loans where the lender is finance, loan or leasing company, or inc debt consolidator, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-22802142.86)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2032-2042


LLOAN5
Total balance of household loans where the lender is a brokerage and/or life insurancer, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-58227311.13)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2044-2054


LLOAN6
Total balance of household loans where the lender is a real estate company, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-86856734.19)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2056-2066


LLOAN7
Total balance of household loans where the lender is an individual, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-39837354.41)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2068-2078


LLOAN8
Total balance of household loans where the lender is an other nonfinancial, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-122492533.50)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2080-2091


LLOAN9
Total balance of household loans where the lender is government, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-7630174.42)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2093-2102


LLOAN10
Total balance of household loans where the lender is a store and/or a credit card, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-880653.17)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2104-2112


LLOAN11
Total balance of household loans where the lender is a pension, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-1492193.83)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2114-2123


LLOAN12
Total balance of household loans where the lender is other, unclassifiable, or foreign, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-78550781.46)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/2125-2135


PLOAN1
Total value of aggregate loan balance by loan purpose: home purchase, cottage, vacation property, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-88353349.33)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1904-1914


PLOAN2
Total value of aggregate loan balance by loan purpose: home improvement, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-32572595.93)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1916-1926


PLOAN3
Total value of aggregate loan balance by loan purpose: vehicles, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-46660000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1928-1938


PLOAN4
Total value of aggregate loan balance by loan purpose: goods and services, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-148670000.00)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1940-1951


PLOAN5
Total value of aggregate loan balance by loan purpose: investments and mortgage loans for other real estate, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-290957110.47)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1953-1964


PLOAN6
Total value of aggregate loan balance by loan purpose: education and professional expenses, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-27850136.63)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1966-1976


PLOAN7
Total value of aggregate loan balance by loan purpose: other unclassifiable loans, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-67082742.32)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1978-1988


PLOAN8
Total value of aggregate loan balance by loan purpose: not used in public data, 2016 dollars
Percent
N
Value
Label
100.0
1,091,330,394
0


100.0
1,091,330,394


Total
Properties
Data type: numeric
Record/columns: 1/1990-1993


MORT1
Amount owed on mortgage 1, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-86856734.19)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1121-1131


MORT2
Amount owed on mortgage 2, 2016 dollars
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-38100887.42)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1133-1143


MORT3
Amount owed on mortgage 3, 2016 dollars
Text of this Question or Item
Available only for 1989, 1992, 1995, 1998, 2001, 2004, and 2007.
Total Cases: 1,091,330,394 (Range of valid codes: 0.00-37428544.28)
Properties
Data type: numeric
Decimals: 2
Record/columns: 1/1145-1155