311-ServiceRequest-Boston-2021

@kaggle.doshiharmish_311servicerequestboston2021

Table List

1 table(26.71 MB)

Og 311 Servicerequest 2021

@kaggle.doshiharmish_311servicerequestboston2021.og_311_servicerequest_2021

26.71 MB
273951 rows
29 columns

case_enquiry_id Case Enquiry Id	open_dt Open Dt	target_dt Target Dt	closed_dt Closed Dt	ontime Ontime	case_status Case Status	closure_reason Closure Reason	case_title Case Title	subject Subject	reason Reason	type Type	queue Queue	department Department	submittedphoto Submittedphoto	closedphoto Closedphoto	location Location	fire_district Fire District	pwd_district Pwd District	city_council_district City Council District	police_district Police District	neighborhood Neighborhood	neighborhood_services_district Neighborhood Services District	ward Ward	precinct Precinct	location_street_name Location Street Name	location_zipcode Location Zipcode	latitude Latitude	longitude Longitude	source Source
101003578872	Fri Jan 01 2021 00:06:37 GMT+0000 (Coordinated Universal Time)	Wed Jan 06 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 2021 05:36:42 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : Fri Jan 01 05:36:42 EST 2021 Resolved Barrels left on the sidewalk after pick up	Improper Storage of Trash (Barrels)	Public Works Department	Code Enforcement	Improper Storage of Trash (Barrels)	PWDx_Code Enforcement	PWDx	nan	nan	797 Columbia Rd Dorchester MA 02125	7	03	2	C11	Dorchester	5	Ward 7	0709	797 Columbia Rd	2125	42.3202	-71.0572	Citizens Connect App
101003578875	Fri Jan 01 2021 00:15:47 GMT+0000 (Coordinated Universal Time)	Tue Jan 05 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 02 2021 12:49:26 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : 2021-01-02 12:49:26.16 Case Noted	Parking Enforcement	Transportation - Traffic Division	Enforcement & Abandoned Vehicles	Parking Enforcement	BTDT_Parking Enforcement	BTDT	https://311.boston.gov/media/boston/report/photos/5feeaff505bba4442b2a686e/report.jpg	nan	50 Newton St Brighton MA 02135	11	04	9	D14	Allston / Brighton	15	Ward 22	2211	50 Newton St	2135	42.3569	-71.165	Citizens Connect App
101003578879	Fri Jan 01 2021 00:26:46 GMT+0000 (Coordinated Universal Time)		Mon Jan 04 2021 13:56:41 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : 2021-01-04 13:56:41.667 Case Invalid This case has been closed as there is not enough information to process this request. If you feel this has been closed in error please dial 311 to submit a new request. Sincerely Boston 311 Team	Notification	Mayor's 24 Hour Hotline	Notification	Notification	INFO09_Current Events	INFO	nan	nan	693 Dudley St Dorchester MA 02125	7	03	3	B2	Dorchester	13	13	1305	693 Dudley St	2125	42.3594	-71.0587	Constituent Call
101003578880	Fri Jan 01 2021 00:27:00 GMT+0000 (Coordinated Universal Time)		Thu Mar 18 2021 03:02:40 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed Case Noted	Fire	Mayor's 24 Hour Hotline	Notification	Notification	INFO09_Current Events	INFO	nan	nan	INTERSECTION of Nonquit St & Dudley St Dorchester MA	7	03	3	B2	Dorchester	13	7	0710	INTERSECTION Nonquit St & Dudley St		42.3594	-71.0587	Constituent Call
101003578881	Fri Jan 01 2021 00:36:34 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 2021 05:43:25 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : Fri Jan 01 05:43:25 EST 2021 Resolved Loose trash	Poor Conditions of Property	Public Works Department	Code Enforcement	Poor Conditions of Property	PWDx_Code Enforcement	PWDx	nan	nan	83-93 Stoughton St Dorchester MA 02125	7	03	3	C11	Dorchester	7	Ward 13	1306	83-93 Stoughton St	2125	42.3157	-71.0623	Citizens Connect App
101003578883	Fri Jan 01 2021 00:38:15 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 2021 05:50:34 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : Fri Jan 01 05:50:34 EST 2021 Resolved No violation found	Poor Conditions of Property	Public Works Department	Code Enforcement	Poor Conditions of Property	PWDx_Code Enforcement	PWDx	nan	nan	14 Windermere Rd Dorchester MA 02125	7	03	3	C11	Dorchester	7	Ward 13	1306	14 Windermere Rd	2125	42.3146	-71.0621	Citizens Connect App
101003578887	Fri Jan 01 2021 01:44:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 04 2021 08:48:56 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : 2021-01-04 08:48:56.423 Case Noted Dear Constituent This was an Eversource emergency . I will send my inspector by to double check the work. Sorry for any inconvenience this may have caused you. Regards Rich DiMarzo	Work Hours-Loud Noise Complaints	Public Works Department	Highway Maintenance	Work Hours-Loud Noise Complaints	PWDx_Work Hours-Loud Noise Complaints	PWDx	nan	nan	INTERSECTION of Strathmore Rd & Sutherland Rd Brighton MA	11	04	8	D14	Allston / Brighton	15	21	2115	INTERSECTION Strathmore Rd & Sutherland Rd		42.3594	-71.0587	Constituent Call
101003578889	Fri Jan 01 2021 01:46:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 05 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 02 2021 12:53:10 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : 2021-01-02 12:53:10.46 Case Resolved	Parking Enforcement	Transportation - Traffic Division	Enforcement & Abandoned Vehicles	Parking Enforcement	BTDT_Parking Enforcement	BTDT	nan	nan	INTERSECTION of Elmore St & Kensington St Roxbury MA	9	10B	9	B2	Roxbury	13	12	1203	INTERSECTION Elmore St & Kensington St		42.3594	-71.0587	Constituent Call
101003578890	Fri Jan 01 2021 02:49:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 05 2021 08:30:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 2021 03:17:49 GMT+0000 (Coordinated Universal Time)	ONTIME	Closed	Case Closed. Closed date : Fri Jan 01 03:17:49 EST 2021 Resolved Clean up MVA	Requests for Street Cleaning	Public Works Department	Street Cleaning	Requests for Street Cleaning	PWDx_District 10A: Roxbury	PWDx	nan	nan	INTERSECTION of Wait St & Huntington Ave Boston MA	9	10A	7	B2	Mission Hill	14	10	1003	INTERSECTION Wait St & Huntington Ave		42.3594	-71.0587	Constituent Call
101003578892	Fri Jan 01 2021 03:06:00 GMT+0000 (Coordinated Universal Time)			ONTIME	Open		Loud Parties/Music/People	Boston Police Department	Noise Disturbance	Loud Parties/Music/People	INFO01_GenericeFormforOtherServiceRequestTypes	INFO	nan	nan	INTERSECTION of Elm Hill Ave & Seaver St Dorchester MA	9	10B	9	B2	Roxbury	13	12	1207	INTERSECTION Elm Hill Ave & Seaver St		42.3594	-71.0587	Constituent Call


CREATE TABLE og_311_servicerequest_2021 (
  "case_enquiry_id" BIGINT,
  "open_dt" TIMESTAMP,
  "target_dt" TIMESTAMP,
  "closed_dt" TIMESTAMP,
  "ontime" VARCHAR,
  "case_status" VARCHAR,
  "closure_reason" VARCHAR,
  "case_title" VARCHAR,
  "subject" VARCHAR,
  "reason" VARCHAR,
  "type" VARCHAR,
  "queue" VARCHAR,
  "department" VARCHAR,
  "submittedphoto" VARCHAR,
  "closedphoto" VARCHAR,
  "location" VARCHAR,
  "fire_district" VARCHAR,
  "pwd_district" VARCHAR,
  "city_council_district" VARCHAR,
  "police_district" VARCHAR,
  "neighborhood" VARCHAR,
  "neighborhood_services_district" VARCHAR,
  "ward" VARCHAR,
  "precinct" VARCHAR,
  "location_street_name" VARCHAR,
  "location_zipcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "source" VARCHAR
);