crash_reports
2 rows where intersection = 0, keywords contains "Pictures" and "retrieved" is on date 2021-02-09
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-27
Time:
02:53
Address:
55 SACO ST
Speed
limit:
15
Violation
cited:
no
Narrative:
MV 1 was plowing the parking lot of 55 Saco St when he struck the left rear of MV 2. MV 2 was parked in a parking spot and struck by MV 1. MV 1 sustained no damage to the truck or plow. MV 2 sustained minor damage to the left rear light and bumper. MV 1 is a plow truck owned by the City of Newton. Photos were taken of both vehicles and the scene with the camera in N495 and turned into IT.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3078942
Longitude:
-71.2206419
Location:
Case
number:
Date:
2021-02-01
Time:
11:07
Address:
34 CRAFTS ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On Friday, January 29, 2021, Mr. Jose Bonilla (S73276930) stated he was operating a 2016 Thomas School bus (MA: SB40311) owned by Eastern Bus Company at the intersection of Crafts Street and the driveway to 34 Crafts Street, Newton. Crafts Street is a public way maintained by the City of Newton. Mr. Bonilla stated he proceeded to take a right turn onto Crafts Street from the driveway and the passenger side of his vehicle made contact with a fire hydrant. The crash caused the hydrant to fall to the roadway. No injuries reported. City noticed of damage. Photos of damage were submitted to the IT Bureau.
Keywords:
Bus, Crash, Fire, Pictures, School
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3547176
Longitude:
-71.2009798
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);