A One Year Sample

Overview

In this section, we provide a consolidated dataset pertaining to the Year 2018. The data is derived from Fannie Mae’s July 27, 2023 release of its Single-Family Loan Performance primary dataset. We provide several different versions / formats of this dataset. The first version consists of all loans appearing in Fannie Mae’s dataset that were acquired during 2018. The second version consists of all loans that originated in 2018 (including those acquired later than 2018). The version consists of only 30-year mortgages that orginated in 2018. The datasets are consolidated into one row per loan as desctibed in the Data Consolidation section. Each dataset is provided in a compressed / uncompressed delimited/feather file formats.

Loans acquired in 2018

This dataset consists of 1,834,469 loans.

Download delimited <.csv> flat file (delimiter: “|”)

  • Uncompressed (~525MB) filename: <2018_acquired_consolidated.csv>
  • Compressed (~105MB) filename: <2018_acquired_consolidated_csv.zip>

Download feather <.feather> file

  • Uncompressed (~205MB) filename: <2018_acquired_consolidated.feather>
  • Compressed (~115MB) filename: <2018_acquired_consolidated_feather.zip>

Loans originated in 2018

This dataset consists of 1,788,020 loans.

Download delimited <.csv> flat file (delimiter: “|”)

  • Uncompressed (~560MB) filename: <2018_originated_consolidated.csv>
  • Compressed (~115MB) filename: <2018_originated_consolidated_csv.zip>

Download feather <.feather> file

  • Uncompressed (~270MB) filename: <2018_originated_consolidated.feather>
  • Compressed (~135MB) filename: <2018_originated_consolidated_feather.zip>

30-year loans originated in 2018

This dataset consists of 1,514,613 loans.

Download delimited <.csv> flat file (delimiter: “|”)

  • Uncompressed (~485MB) filename: <2018_originated_30year_consolidated.csv>
  • Compressed (~100MB) filename: <2018_originated_30year_consolidated_csv.zip>

Download feather <.feather> file

  • Uncompressed (~235MB) filename: <2018_originated_30year_consolidated.feather>
  • Compressed (~115MB) filename: <2018_originated_30year_consolidated_feather.zip>