There are at least two resources for looking up past REAC scoring data for all properties.
One, from the REMS Data Base, offers the last three sequential scores and dates up to about the last 6 to 12 months depending on when the data was last updated.
Clicking the image at left will take you to this resource.
If you then click on one of the state names, it will return a PDF file which displays all REAC property scores, sorted by city name then property name. This is less useful (in our opinion) than clicking the link below the chart for REAC Physical Inspections Scores and Release Dates (MS Excel 2003 format). Click the link at left to download this directly. If this does not return a download, go to the page by clicking the image of the page at left, then click the link at the bottom.
The downloaded spreadsheet is a very long spreadsheet displaying ALL properties nationally, but it can be searched, sorted, and filtered using the normal functions of Excel or another spreadsheet program like that included in Open Office to isolate data by Property ID, Property Name, City, State, etc.
We would suggest that housing organizations isolate their own portfolios, by searching or filtering the data to find all their properties, and then flagging them by adding a column and marking the rows containing pertinent data. The spreadsheet can then be sorted on the column containing the flag, and all useless data can then be deleted. This will provide a record of all property scores and inspection dates - useful information to help predict future dates and track past scores throughout the portfolio.
This could also be used to do analysis of property scores and trends by region, and so on, comparing one's own properties to competitive organization scores, rather than deleting that data.
The second great resource for scoring data is at http://www.huduser.org/portal/datasets/pis.html
This page provides a very complete set of historical REAC scoring data going back as far as 2000 for some multifamily properties - data that may not be contained in the resource outlined above - and, often, more than 3 prior scores per property.
The first two download links are the most important, with the first returning all Multifamily scores, and the second returning all Public Housing scores.
The Public Housing download returns an immense spreadsheet, containing more than 12,000 lines of Public Housing scores only going back to 2008. An older version no longer available at this page provided over 25,000 scores going back to 2000, but this data has been removed without explanation.
The Multifamily download still provides over 65,000 lines of Multifamily scores going back to as early as 2000. An earlier version contained over 75,000 lines going back to 1999.
We have archived the earlier versions from the text format files that were available at that time, and may be able to provide them to interested readers, but they were not as useful as the largely improved spreadsheet format available now. They could be converted to spreadsheets, with some considerable difficulty.
This resource may be less useful to managers and owners because each score is recorded in a separate line rather than across a single line for quick reference. This data is more complete, but more difficult to utilize.