Name: Housing Code Violations
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Housing Code Violations

Housing Code Enforcement data from 2013 to the present , including violations identified. Update Frequency: Weekly
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:19.322060
Tags: code, enforcement, housing, violation

Tables

Table 1

@usgov.montgomery_county_of_maryland_housing_code_violations.table_1

23.6 MB
876,629 rows
24 columns

CREATE TABLE table_1 (
  "case_number" BIGINT,
  "date_filed" TIMESTAMP,
  "date_assigned" TIMESTAMP,
  "date_closed" TIMESTAMP,
  "disposition" VARCHAR,
  "street_address" VARCHAR,
  "unit_number" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "service_request_number" DOUBLE,
  "service_request_created_date" TIMESTAMP,
  "service_request_closed_time" TIMESTAMP,
  "service_request_status" VARCHAR,
  "violation_id" BIGINT,
  "inspection_date" TIMESTAMP,
  "corrected" TIMESTAMP,
  "location_description" VARCHAR,
  "action" VARCHAR,
  "code_reference" VARCHAR,
  "condition" VARCHAR,
  "item" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);