crash_reports
3 rows where "date" is on date 2022-03-23 and "datetime" is on date 2022-03-23
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-03-23
Time:
10:46
Address:
1600 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Due to a language barrier, I spoke with Opr of MV1 through a language line at the hospital. Opr of MV1 stated he was traveling east on Washington Street. At this time, he attemtped to turn right into the Warren House (1600 Washington Street). While turning, he was struck from behind by vehicle #2, which caused him to spin and back into a bush. Opr of MV1 stated he used his blinkers and slowed down. Opr or MV1 suffered injuries and was trasnported to NWH. MV1 was towed by Tody's. Opr of MV2 stated she was travling east on Washington Street. Opr of MV2 stated MV1 stopped and she did not see a blinker. At this time, MV2 could not stop in time and struck MV1. MV2 suffered damage and was towed by Tody's.
Keywords:
Bus, Hospital
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3431423
Longitude:
-71.2353558
Location:
Case
number:
Date:
2022-03-23
Time:
16:44
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator of Vehicle 1 parked Vehicle 1 in the employee lot at Newton Wellesley Hospital. When she came back out to Vehicle 1, she observed damage to the passenger-side corner of the rear bumper with blue paint transfer. She does not know who caused the damage and security do not have cameras in the area. An incident report was completed for this incident (See Report #22010401)
Keywords:
Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
Case
number:
Date:
2022-03-23
Time:
20:19
Address:
697 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was traveling Westbound on Washington St when he collided with MV#2 exiting the parking lot of Garden Remedies, 697 Washington St. OPMV#1 Stated he was traveling straight on Washington and the other vehicle pulled out of the parking lot into his lane causing them to collide. MV#2 Was exiting the parking lot of Garden Remedies at 697 Washington St when he was struck by MV#1. OPMV#2 Stated he was being let go by the right Westbound lane and when he entered the left Westbound lane that is when he was struck by a vehicle. No injuries/No tows
Keywords:
[]
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3529253
Longitude:
-71.2021966
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);