crash_reports
4 rows where "datetime" is on date 2019-10-09, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-09
Time:
07:34
Address:
283 TREMONT ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV#1 was parked in front of 283 Tremont St with front driver side damage. The owner of MV#1 came out at approximately 0730 hours and noticed the damage. It is unknown who the owner or operator of MV#2 is.
Keywords:
[]
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3546709
Longitude:
-71.1796402
Location:
Case
number:
Date:
2019-10-09
Time:
17:17
Address:
169 EAST SIDE PKWY
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV 1 was traveling southbound on East side pkwy when she struck the curb on the right side of the street. At this time she swerved completely across the double yellow lines and struck MV 2 head on. MV 2 was traveling northbound and observed MV 1 cross into his lane and strike him head on. Both operators were evaluated by Cataldo ambulance who cleared with patient refusals. Both vehicles were removed from the scene by Tody's towing. Operator of MV 1 was cited for a marked lanes violation.
Keywords:
Citation, Ems
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.349089
Longitude:
-71.1969107
Location:
Case
number:
Date:
2019-10-09
Time:
20:09
Address:
180 NEEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV1 states that she was traveling northbound on Needham Street with flow of traffic when she struck a pedestrian with the right front corner of her vehicle. The operator of MV1 stated that she did not see the pedestrian in the cross walk until after she hit her and that there was poor lighting in the area. Through the help of coworker from Anthony's Coal Fired Pizza, the victim stated that she was crossing Needham Street in the crosswalk and was almost on the side walk when she was struck by MV1 from behind. MV1 sustained minor front end damage while the victim sustained noticeable injuries and was transported to Newton Wellesley Hospital by Cataldo. Photographs of the scene were taken and submitted to IT to be attached to the report. The operator of MV1 was issued a Massachusetts Uniform Citation (T2079284) for 89-11, failure to yield to a pedestrian in a crosswalk.
Keywords:
Citation, Crosswalk, Fire, Hospital, Ped, Pictures, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3116053
Longitude:
-71.2130334
Location:
Case
number:
Date:
2019-10-09
Time:
23:26
Address:
350 CALIFORNIA ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Upon arrival the Operator of Vehicle #1 was not on scene. Operator of Vehicle #1 returned to the scene a short time later. Operator #1 stated that he was drunk and hit two parked vehicles. Vehicle #1 sustained heavy front end damage and was towed from the scene by Tody's. Vehicle #2 and Vehicle #3 were legally parked on California Street and were sideswiped by Vehicle #1. Both vehicles were unoccupied. Vehicle #2 and #3 sustained heavy rear end damage and were towed from the scene by Tody's. All inventory sheets were completed and filed. Operator of Vehicle #1 was subsequently arrested. Refer to NPD Incident 19043036. No injuries were reported and Newton Medics cleared the scene with a patient refusal by Operator #1.
Keywords:
[]
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3649232
Longitude:
-71.2033104
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);