2018-01-30
ZCTA and Metro Area Excel Data Download
All of the raw files, derived data, results, and code are included in this repository. However, if you would like to re-run the entire analysis you can open the file makefile.R where you can install all the required packages and execute all the other scripts to download files, clean data, and create the results table as a CSV and the graph as a PNG. The Metro area and ZCTA data files from the results folder are included in the Excel file linked above, which also has links to the report and column descriptions.
Each individual step in the analysis is documented with comments throughout the code, and there is a higher-level methodology at the end of the brief.
| Affordable Units | Share of Units Affordable | ||||||
|---|---|---|---|---|---|---|---|
| Total Rental Units | FMR | Small Area FMR | FMR | Small Area FMR | Absolute Difference (Small Area FMR - FMR) | Percentage Change (Small Area FMR - FMR/FMR) | |
| All SAFMR Areas | 6,400,441 | 2,500,661 | 2,723,176 | 39.1% | 42.5% | 222,515 | 8.9% |
| Atlanta-Sandy Springs-Roswell, GA HUD Metro FMR Area | 584,755 | 240,664 | 267,765 | 41.2% | 45.8% | 27,101 | 11.3% |
| Bergen-Passaic, NJ HUD Metro FMR Area | 170,781 | 57,675 | 64,241 | 33.8% | 37.6% | 6,566 | 11.4% |
| Charlotte-Concord-Gastonia, NC-SC HUD Metro FMR Area | 214,574 | 86,395 | 94,177 | 40.3% | 43.9% | 7,782 | 9% |
| Chicago-Joliet-Naperville, IL HUD Metro FMR Area | 870,900 | 324,163 | 343,921 | 37.2% | 39.5% | 19,758 | 6.1% |
| Colorado Springs, CO HUD Metro FMR Area | 71,519 | 25,781 | 28,470 | 36.0% | 39.8% | 2,689 | 10.4% |
| Dallas, TX HUD Metro FMR Area | 564,569 | 218,961 | 246,297 | 38.8% | 43.6% | 27,337 | 12.5% |
| Fort Lauderdale, FL HUD Metro FMR Area | 213,688 | 79,774 | 87,189 | 37.3% | 40.8% | 7,415 | 9.3% |
| Fort Worth-Arlington, TX HUD Metro FMR Area | 240,719 | 98,612 | 111,475 | 41.0% | 46.3% | 12,863 | 13% |
| Gary, IN HUD Metro FMR Area | 63,166 | 27,636 | 26,386 | 43.8% | 41.8% | -1,250 | -4.5% |
| Hartford-West Hartford-East Hartford, CT HUD Metro FMR Area | 121,203 | 49,104 | 48,484 | 40.5% | 40.0% | -620 | -1.3% |
| Jackson, MS HUD Metro FMR Area | 50,227 | 20,724 | 21,217 | 41.3% | 42.2% | 493 | 2.4% |
| Jacksonville, FL HUD Metro FMR Area | 145,936 | 58,417 | 64,203 | 40.0% | 44.0% | 5,786 | 9.9% |
| Monmouth-Ocean, NJ HUD Metro FMR Area | 75,795 | 30,634 | 29,115 | 40.4% | 38.4% | -1,519 | -5% |
| North Port-Sarasota-Bradenton, FL MSA | 76,418 | 32,035 | 31,087 | 41.9% | 40.7% | -948 | -3% |
| Palm Bay-Melbourne-Titusville, FL MSA | 51,246 | 18,925 | 22,381 | 36.9% | 43.7% | 3,456 | 18.3% |
| Philadelphia-Camden-Wilmington, PA-NJ-DE-MD MSA | 581,531 | 240,731 | 245,718 | 41.4% | 42.3% | 4,987 | 2.1% |
| Pittsburgh, PA HUD Metro FMR Area | 220,210 | 87,734 | 88,737 | 39.8% | 40.3% | 1,002 | 1.1% |
| Sacramento--Roseville--Arden-Arcade, CA HUD Metro FMR Area | 229,769 | 93,206 | 97,508 | 40.6% | 42.4% | 4,302 | 4.6% |
| San Antonio-New Braunfels, TX HUD Metro FMR Area | 242,058 | 84,650 | 108,635 | 35.0% | 44.9% | 23,986 | 28.3% |
| San Diego-Carlsbad, CA MSA | 429,988 | 168,800 | 177,962 | 39.3% | 41.4% | 9,162 | 5.4% |
| Tampa-St. Petersburg-Clearwater, FL MSA | 330,210 | 135,180 | 142,669 | 40.9% | 43.2% | 7,489 | 5.5% |
| Urban Honolulu, HI MSA | 102,358 | 34,525 | 41,486 | 33.7% | 40.5% | 6,961 | 20.2% |
| Washington-Arlington-Alexandria, DC-VA-MD HUD Metro FMR Area | 612,177 | 235,311 | 273,627 | 38.4% | 44.7% | 38,316 | 16.3% |
| West Palm Beach-Boca Raton, FL HUD Metro FMR Area | 136,643 | 51,030 | 60,431 | 37.3% | 44.2% | 9,402 | 18.4% |
