Troubled Properties Analysis

Montgomery County DHCA classifies properties as Troubled, At-Risk, and Compliant through scheduled property code inspections. In general, a “Troubled Property” is a multifamily rental property with numerous and or severe “health and safety” housing code violations. The full Fiscal Year 2024 Troubled Property report for properties inspected between July 1, 2023 and June 30, 2024, is available at

https://www.montgomerycountymd.gov/dhca/director/TroubledProperties.html.

This report provides the results and classifications of the properties inspected and identifies the properties to be inspected in the following Fiscal Year. FY24 Data will be uploaded to Data Montgomery in the coming weeks.

Executive Regulation 05-17 provides a methodology for designating certain multifamily rental housing units as "Troubled Properties" These "Troubled Properties" are subject to at least annual housing code inspections and must develop and implement a corrective action plan. This dataset provides housing code inspection results along with scores for both severity and quantity of violations.

Updated Annually.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"montgomerycountymd-gov/troubled-properties-analysis-bw2r-araf\".\"troubled_properties_analysis\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.