|
|
# FHFA
|
|
|
|
|
|
## Provider
|
|
|
|
|
|
* **provider_name**: FHFA
|
|
|
* **provider_longname**: Federal Housing Finance Agency
|
|
|
* **provider URL**: https://www.fhfa.gov
|
|
|
* **region**: US
|
|
|
* **terms of use**: https://www.fhfa.gov/AboutUs/Policies/Pages/Website-Social-Media-Policies.aspx
|
|
|
* **approximate number of datasets**: 2
|
|
|
|
|
|
h
|
|
|
## Data accessibility
|
|
|
|
|
|
* **SDMX: (If yes, links and SDMX releases implemented**: No
|
|
|
* **REST API**: No
|
|
|
* **Bulk Download: No
|
|
|
* **Account**: No
|
|
|
|
|
|
## Desired datasets
|
|
|
|
|
|
* **Description**:
|
|
|
- House Price Index
|
|
|
- Monthly Interest Rate Survey
|
|
|
|
|
|
|
|
|
## Data tree
|
|
|
|
|
|
* **Existence of a hierachy of datasets on web site**: No
|
|
|
* **How to recover the information**: harcode
|
|
|
|
|
|
## Dataset
|
|
|
|
|
|
* **datasetCode**: hpi
|
|
|
* **datasetName**: House Price Index
|
|
|
* **how to download**:
|
|
|
- parse
|
|
|
https://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index-Datasets.aspx
|
|
|
for Master HPI data JSON url
|
|
|
- use that URL to download file
|
|
|
* **how to get release date**: parse
|
|
|
https://www.fhfa.gov/Media/Pages/News-Releases.aspx?k=ContentType%3APublic-Affairs%20AND%20PublicAffairsCategoryOWSCHCS%3A%22News%20Release%22%20AND%20FHFAPublishedDateOWSDATE%3D01%2F01%2F2018%2E%2E12%2F31%2F2018
|
|
|
* **dataset docHref**: https://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index.aspx
|
|
|
* **dataset notes**: no
|
|
|
* **dimension_list**: use JSON fields:
|
|
|
- "type" : "hpi type"
|
|
|
- "flavor" : "hpi flavor"
|
|
|
- "freq": "frequency"
|
|
|
- "level": "level"
|
|
|
- "place" "place" use "place_id" for value code and "place name" for
|
|
|
value label
|
|
|
- for the above the values of the dimensions need to be accumulated
|
|
|
while parsing the file
|
|
|
- except for "place" and "ajd", dimension value codes and labels
|
|
|
are the same
|
|
|
- "adj" "seasonal adjustment {("sa": "seasonaly adjusted"), ("nsa":
|
|
|
"non seasonaly adjusted")}
|
|
|
|
|
|
* **use of attributes**: no
|
|
|
* **attribute_list**: no
|
|
|
* **available frequencies**: monthly quarterly
|
|
|
* **availability of previous updates**: no
|
|
|
* **existence of real time datasets**: no
|
|
|
* **calendar of future updates**: https://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index.aspx#ReleaseDates
|
|
|
|
|
|
## Series
|
|
|
|
|
|
* **Series key**: concatenate type_flavor_place_id_adj_freq
|
|
|
* **Series name**: concatenate values of type, flavor, place name, adj
|
|
|
and freq
|
|
|
* **Series docHref**: no
|
|
|
* **Series notes**: no
|
|
|
* **missing values**: none
|
|
|
* **date format**: field "yr" and field "pr"
|
|
|
* **mixed frequencies in the same dataset**: yes
|
|
|
|
|
|
## Dataset
|
|
|
|
|
|
* **datasetCode**: MIRS
|
|
|
* **datasetName**: Monthly Interest Rate Survey
|
|
|
* **how to download**:
|
|
|
- parse
|
|
|
https://www.fhfa.gov/DataTools/Downloads/Pages/Monthly-Interest-Rate-Data.aspx
|
|
|
for Adjustable Rate Mortgage Index table and for URL to "Complete
|
|
|
history of the index" (at the very end of the page).
|
|
|
- download "Complete history of the index" only at the first acquisition
|
|
|
* **how to get release date**: first row of first column of Adjustable Rate Mortgage Index table
|
|
|
* **dataset docHref**: https://www.fhfa.gov/DataTools/Downloads/Pages/Monthly-Interest-Rate-Data.aspx
|
|
|
* **dataset notes**: no
|
|
|
* **dimension_list**: frequency: "monthly"
|
|
|
* **use of attributes**: no
|
|
|
* **attribute_list**: no
|
|
|
* **available frequencies**: monthly
|
|
|
* **availability of previous updates**: no
|
|
|
* **existence of real time datasets**: no
|
|
|
* **calendar of future updates**: get url in first row 4th colum and
|
|
|
parse for a sentence like "FHFA will release August index values Thursday, September 27, 2018."
|
|
|
|
|
|
## Series
|
|
|
|
|
|
* **Series key**: mirs (only one series in the dataset)
|
|
|
* **Series name**: monthly interest rate survey
|
|
|
* **Series docHref**: no
|
|
|
* **Series notes**: no
|
|
|
* **missing values**: none
|
|
|
* **date format**: month yyyy
|
|
|
* **mixed frequencies in the same dataset**: no
|
|
|
|
|
|
## Updates
|
|
|
|
|
|
* **summary of previous updates**: no
|
|
|
* **regular updates**: no
|
|
|
* **RSS flow**: no
|
|
|
* **best way to monitor updates**: use calendar of future updates
|
|
|
|
|
|
|
|
|
|