crash_reports
2 rows where geocoded_address = "Lowell Ave & Washington St, Newton, MA 02460, USA" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-08
Time:
17:42
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated he was traveling westbound on Washington Street through the intersection of Washington Street and Lowell Ave. While going through the intersection vehicle 2 crashed into vehicle 1 while vehicle 2 was attempting a left turn. The operator of vehicle 2 stated he was on Washington Street and turned left onto Lowell Ave, he did not see vehicle 1 and crashed the front center of his vehicle into the passenger side quarter panel of vehicle 1.
Keywords:
Crash
Dcc:
Improper turn, Inattention
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
Location:
Case
number:
Date:
2021-10-13
Time:
08:08
Address:
WASHINGTON ST & LOWELL AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 proceeding straight ahead on Westbound via Washington Street collided with MV2 negotiating a Northbound turn from Washington Street to Lowell Ave. Collision resulted in MV2 rolling and coming to rest on roof. Operator MV2 was entrapped in vehicle, Officer Tocci able to break the window and assist Operator out of vehicle. Operator MV2 transported to Newton Wellesley Hospital via Medic 2. MV1 and MV2 towed to Tody's. A towed motor vehicle form completed and filed.
Keywords:
Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);