crash_reports
4 rows where "date" is on date 2020-03-06 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-03-06
Time:
02:19
Address:
258 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday, March 6, 2020 between approximately 0218 to 0220 hours MV1 was parked at 258 Centre St, Newton. At this time an unknown MV struck MV1 from behind and pushed it approximately 10 feet to the Sunoco Entrance (170 Galen St, Watertown). MV1 sustained heavy rear-end damage and was towed privately by the Sunoco owner with MV1 owner's permission. The Sunoco owners do not have a recording of the crash but has the recording of MV1 being pushed from behind into the camera view. The unknown MV was not seen in the camera recordings. MV1 owner was inside his residence at the time, and no injuries were reported.
Keywords:
Crash, Solar
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3591001
Longitude:
-71.1849675
Location:
Case
number:
Date:
2020-03-06
Time:
09:21
Address:
1317 CENTRE ST
Speed
limit:
20
Violation
cited:
no
Narrative:
Vehicle #1 was traveling South on Centre St. and Vehicle #2 was traveling behind Vehicle #1 on Centre St. Vehicle #1 began to stop due to the traffic stopping in front of her for a pedestrian crossing. Vehicle #2 did not stop in time and struck the rear of Vehicle #1 causing damage to the rear of Vehicle #1. No parties were injured. Medical attention declined. Operator #1 stated she was shaken. Operators were advised how to file their reports. No vehicles were towed. All operators and vehicles were active.
Keywords:
Ped
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3290184
Longitude:
-71.1960471
Location:
Case
number:
Date:
2020-03-06
Time:
13:44
Address:
411 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator #1 stated he was driving w/b on Watertown St just passing the Village Bank, #411 Watertown St when vehicle #2 backed out of the Village Bank parking lot causing the crash. Operator #1 later stated his view was blocked by a truck parked on Watertown St in front of the bank thus he never saw vehicle #2 backing out from the parking lot. Operator #2 stated he was attempting to back out from a parking space at #413 Watertown St when his vehicle was hit by vehicle #1 as he got out onto Watertown St. Operator #2 further reported that his view was obstructed by a truck that was parked facing west on Watertown St in front of the Village Bank. He never saw vehicle #2 coming as he was backing out onto Watertown St.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3600229
Longitude:
-71.2026607
Location:
Case
number:
Date:
2020-03-06
Time:
15:41
Address:
13 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Vehicle #1 was parked in the parking lot behind 16 Boylston St between the hours of noon and 3:20 pm. Owner of Vehicle #1 came out to the vehicle to find it had been struck on the left rear door by another vehicle. No note or witnesses were present. Vehicle #1 had minor damage to the left rear side door and was able to be driven away. Vehicle #1 was unoccupied at the time of the accident.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3233562
Longitude:
-71.1665049
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);