crash_reports
3 rows where "datetime" is on date 2021-11-20 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-20
Time:
13:12
Address:
121 WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Newton Police were dispatched to the area of 120 Waltham St. on 11/20/21 at 1312 hrs, for a motor vehicle accident. The operator of MV#2 stated she made a 3-Point Turn crossing over the double yellow line from the northbound lane into the southbound lane. As MV#2 was making this turn into the southbound lane MV#1 collided into the front passenger bumper of MV#2. Damage was observed to MV#2's front passenger bumper while MV#1 sustained damage to its driver side rear passenger door and side panel. No injuries were reported and vehicle were driven from the scene.
Keywords:
Crash
Dcc:
Improper turn, Unknown
Report
url:
Image
url:
Latitude:
42.3623159
Longitude:
-71.2250308
Location:
Case
number:
Date:
2021-11-20
Time:
16:48
Address:
BONNYBROOK RD & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 stated she was on Bonnybrook Road, waiting to make a left turn onto Chestnut Street. The road work in the area and the barrels they have put up has limited her vision of oncoming vehicles. When she didn't see any oncoming vehicles, she made her left turn and collided with MV#2. She stopped at the intersection but MV#2 paused for a bit before continuing to drive away. She was only able to describe MV#2 as a black work truck type vehicle. N495 canvassed the area and couldn't locate any vehicles involved in the accident.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3346616
Longitude:
-71.2241981
Location:
Case
number:
Date:
2021-11-20
Time:
19:41
Address:
3 BORDER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was unoccupied and parked facing westbound on Border St. The owner of MV1 came out and noticed damage on the left rear of the vehicle. It appears as if an unknown MV struck the vehicle then left the area.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3493025
Longitude:
-71.2297173
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);