Housing Code Violations

Montgomery County of Maryland

@usgov.montgomery_county_of_maryland_housing_code_violations

Table List

1 table(22.51 MB)

Table 1

@usgov.montgomery_county_of_maryland_housing_code_violations.table_1

22.51 MB
876629 rows
24 columns

case_number Case Number	date_filed Date Filed	date_assigned Date Assigned	date_closed Date Closed	disposition Disposition	street_address Street Address	unit_number Unit Number	city City	zip_code Zip Code	service_request_number Service Request Number	service_request_created_date Service Request Created Date	service_request_closed_time Service Request Closed Time	service_request_status Service Request Status	violation_id Violation ID	inspection_date Inspection Date	corrected Corrected	location_description Location Description	action Action	code_reference Code Reference	condition Condition	item Item	latitude Latitude	longitude Longitude	location Location
144917	Wed Nov 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Nov 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Violations Corrected	11550 STEWART LN	C1	SILVER SPRING	20904	1353102605	Wed Feb 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	399073	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Bedroom 2	Repair/Replace	26-9(a)(4)	General Condition	Blind/ Curtain Rod	39.045274524	-76.984167237	(39.0453, -76.9842)
147579	Mon May 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Triennial Completed	10225 FREDERICK AVE	810	KENSINGTON	20895	1359664070	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	423601	Wed Jun 27 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Balcony	Repair/Replace	26-9(a)(2)	Screen	Door	39.024679988	-77.069487396	(39.0247, -77.0695)
143705	Mon Sep 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Violations Corrected	4308 FERRARA CT		SILVER SPRING	20906	1337647626	Mon Sep 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	383586	Tue Sep 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Exterior	Remove and maintain grounds	26-9(a)(8)	General Condition	Solid Waste	39.051056153	-77.084446761	(39.0511, -77.0844)
146577	Mon Mar 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Violations Corrected	19773 CRYSTAL ROCK DR	22	GERMANTOWN	20874	1356490001	Tue Apr 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	417482	Wed May 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Bathroom 2	Repair/Replace	26-9(c)(1)	Operating Hardware	Bathtub/ Shower	39.180572648	-77.261921418	(39.1806, -77.2619)
144805	Fri Nov 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Triennial Completed	14175 CASTLE BLVD	102	SILVER SPRING	20904	1353504561	Wed Feb 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	395459	Thu Jan 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Bathroom 2	Unclog	26-9(c)(1)	General Condition	Sink	39.085899245	-76.940226756	(39.0859, -76.9402)
147970	Fri May 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Violations Corrected	12305 MIDDLE RD		SILVER SPRING	20906	1385209672	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	416252	Mon May 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Exterior	Paint (clean/scrape/prep as necessary)	26-9(b)(3)	Siding	Walls/ Ceiling - Exterior			(0.0, 0.0)
140730	Mon May 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Violations Corrected	19 CROSS LAUREL CT		GERMANTOWN	20876	1319179360	Fri May 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	371189	Thu May 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Basement	Install/ Provide	26-6(a)	Cover Plate	Electrical Outlet	39.190145707	-77.228625478	(39.1901, -77.2286)
137708	Fri Oct 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Mar 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	TP Annual Inspection Completed	7401 NEW HAMPSHIRE AVE	807	TAKOMA PARK	20912	1309058763	Wed Jan 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	356774	Wed Dec 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Bathroom 1	Replace	26-9(a)(4)	Doors	Cabinet/ Vanity	38.983272018	-76.987208186	(38.9833, -76.9872)
144805	Fri Nov 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Triennial Completed	14175 CASTLE BLVD	102	SILVER SPRING	20904	1353504561	Wed Feb 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed	395838	Fri Jan 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Kitchen	Repair/Replace	26-9(a)(4)	Burners	Stove/ Oven	39.085899245	-76.940226756	(39.0859, -76.9402)
146178	Thu Feb 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Triennial Completed	7347 WISCONSIN AVE	303	BETHESDA	20814					406786	Fri Mar 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Bathroom 1	Paint (clean/scrape/prep as necessary)	26-9(a)(4)	Doors	Cabinet/ Vanity	38.98327124	-77.093410236	(38.9833, -77.0934)


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
);