# HMDA Data Challenge - Metadata¶

## Data Files Overview¶

You will find these files in your data directory. Should you require full data lineage for loan, institution or MSA files "upstream" of what is provided here, this data is an extract of the HMDA LAR, TS, and MSA files published by the FFIEC

Data file(s) | Description
--- | ---
2012_to_2014_loans_data.csv | Data on home loans originated within the states where Change Financial Operates. Notes: If you are matching provided data to archival loan data, you should know that we filtered for 1-4 family, owner-occupied home loans with an "originated" action type and that were secured by a first or subordinate lien. You can get more HMDA data from the National Archives or from the online HMDA tool
2012_to_2014_institutions_data.csv | Data about the originating institutions as submitted by the institutions themselves
2013 HMDA Guide.pdf | You may find information from this guide, especially Appendix A, useful when questions about data arise

## Loans Data¶

Some fields below are technically specified as alphanumeric, but in practice are numeric values.

Field | Type | Description
--- | --- | ---
As_of_Year | integer | Year in which loan was originated and for which the data was reported. Keep in mind these are real people reporting data, and often variations can crop up in how they handle each year
Agency_Code | alphanumeric | The agency to which the Respondent_ID "responded" with its information
Agency_Code_Description | string | Expanded form of the agency code for readability.
Respondent_ID | string | When paired with the Agency_Code, provides a unique identifier for the institution that year.
Sequence_Number | integer | Provides a unique identifier corresponding to an application or loan for a given responding insitution. I.e., each application at a responding institution must be assigned its own unique sequence number in a given year.
Loan_Amount_000 | integer | Amount of the loan, in $000's
Applicant_Income_000 | integer | The total income used for decisioning the loan
Loan_Purpose_Description | string | The purpose of the loan is whether it was used for purchasing a home, refinancing an alread-existing loan, or used for "home improvement" purposes. ("Home Improvement" loans have been removed from this data file.)
Loan_Type_Description | string | Specifies whether the loan was "conventional," i.e., not backed by a government-sponsored program or government-insured or government-guaranteed
Lien_Status_Description | string | Lien position of the loan. If first lien position, then this loan carries the least risk if the borrower defaults because the lender has first claims to proceeds from the sale of a some. Subordinate liens carry more risk because they are paid after the lender for the first lien is paid.
State_Code | alphanumeric | Two-digit FIPS code for the state in which the home was located.
State | string | Standard 2-letter postal code for the state based on the State_Code given
County_Code | alphanumeric | Numeric code designating a county within a state in which the home was located
MSA_MD | alphanumeric | code designating a Metropolitan Statistical Area (MSA) / Metropolitan Division (MD) in which the home was located. These codes are periodically updated, and were last updated for HMDA between the 2013 and 2014 reporting years.
MSA_MD_Description | string | a human-readable format for describing MSA's. These map 1:1 with MSA_MD codes
Census_Tract_Number | alphanumeric | Identifier for the census tract in which the home was located
FFIEC_Median_Family_Income | alphanumeric | Median family income for the MSA/MD in which the census tract is located
Tract_to_MSA_MD_Income_Pct | alphanumeric | Percentage of the MSA/MD median Family income for the census tract; 2 decimal places of precsion
Number_of_Owner_Occupied_Units | alphanumeric | Number of units, in the census tract and including condominiums, in which the owner lives
County_Name | alphanumeric | Name of the county as pulled in from the FHFA Conforming Loan Limits as calculated under HERA. Please note that county names are only unique within a state
Conforming_Limit_000 | numeric | Single Unit Conforming Loan limit for the given county.
Conventional_Status | string | Signifies whether a loan type is '1' or not.
Conforming_Status | string | 'Conforming' for loans with amounts less than their county's respective conforming loan limit. "Jumbo" if the loan amount exceeds the county limit
Conventional_Conforming_Flag | string | 'Y' if Conventional_Status is "Conventional" and "Conforming_Status" is "Conforming"

## Institutions Data¶

Field | Type | Description
--- | --- | ---
As_of_Year | integer | Year in which loan was originated and for which the data was reported. Keep in mind these are real people reporting data, and often variations can crop up in how they handle each year
Agency_Code | alphanumeric | The agency to which the Respondent_ID "responded" with its information
Respondent_ID | string | When paired with the Agency_Code, provides a unique identifier for the institution that year
Respondent_Name_TS | string | name of the company providing the HMDA data (and who originated the loan)
Respondent_City_TS | string | City where the originating institution is located.
Respondent_State_TS | string | State where the originating institution is located
Respondent_ZIP_Code | string | State where the originating institution is located
Parent_Name_TS | string | The reported Parent to the responding insitutuion. Parent_Name_TS may refer to another entry within the institution file. Parent_Name_TS may be blank if the responding instution has no parent to report (and hence could be regarded as its own parent in certain circumstances). Finally, a Parent institution may have multiple children institutions within the file. Parent institutions may change with each reporting year.
Parent_City_TS | string | City where the parent institution is located
Parent_State_TS | string | State where the parent institution is located
Parent_ZIP_Code | string | ZIP where the parent institution is located
Assets_000_Panel | int64 | Total assets reported to the "Agency" for the top parent by the top level parent corporation across the nation.