About this Dataset

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.
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:11.532235
Tags: analysis, building, code, distress, housing, inspection, property, severity, troubled, violation

Tables

Table 1

@usgov.montgomery_county_of_maryland_troubled_properties_analysis.table_1

69.05 kB
620 rows
21 columns

CREATE TABLE table_1 (
  "license_number" BIGINT,
  "community_name" VARCHAR,
  "n__street_address" VARCHAR  -- Street Address,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "case_number" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "first_inspection_date" TIMESTAMP,
  "next_inspection_date" VARCHAR,
  "inspection_frequency" DOUBLE,
  "compliant" BIGINT,
  "unit_count" BIGINT,
  "units_inspected" BIGINT,
  "average_violations_per_unit" DOUBLE,
  "severity_index" DOUBLE,
  "no_violations_observed" BIGINT,
  "infested_units_percentage" DOUBLE,
  "units_with_mold" DOUBLE,
  "analysis_rating" VARCHAR,
  "location" VARCHAR
);