crash_reports
2 rows where "date" is on date 2019-03-16, keywords contains "Fire" and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-16
Time:
13:15
Address:
DEDHAM ST & PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to the area Dedham St/Parker St for a report of two motor vehicle crash with minor injuries. Upon arrival with Fire/medics I spoke to the oper of v1 Ms. Hollowell who had a shoulder injury due to side impact. She stated she was traveling on Dedham Street (east) applied her left turn signal and was turning left onto Parker Street when v2 went through the stop sign and struck her vehicle. I spoke to the operator of v2 Ms. Kuznetsova who stated she was stopped at the stop sign on Parker St ( south) She stated she accelerated forward turning left (east) onto Dedham St when vehicle one struck into her vehicle. Oper of v1 signed a patient refusal and oper of v2 had no injury. Both parties were unsure of the area in the intersection of impact, all vehicles were moved by the operators prior to my arrival and I could not find any physical characteristics in/ on the roadway to find impact area. Therefore the diagram reflects the damage points on the vehicles but not the impact area on the roadway. All parties advised of the process.
Keywords:
Crash, Fire
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3083463
Longitude:
-71.1982031
Location:
Case
number:
Date:
2019-03-16
Time:
14:49
Address:
CHERRY ST & WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to the area of Cherry Street and Webster Street for a three motor vehicle crash with injuries. Upon arrival along with Sgt. Dempsey, Fire/medics. I spoke with the operator of vehicle one. He stated he was stopped on Webster Street facing westbound a the red traffic signal. He further stated the traffic signal on Webster Street turned green, he accelerated forward. He stated vehicle two traveled north on Cherry Street at a high rate of speed through the red traffic signal. He stated he had no reaction time due to the speed of vehicle two and had impact. I spoke to the operator of vehicle two. He stated he was traveling north on Cherry Street going too fast, he stated he thought it was a school zone so he slowed down and he did not observe the color of the traffic signal. He stated he observed vehicle one come out of the Webster Street at the last second at impact. I spoke with the operator of vehicle three. She stated only remembered being stopped on Cherry Street facing south. She stated she did not remember what color the traffic signal was, just knew she was stopped when she felt heavy impact from vehicle two. Injuries: Oper of V1 none at this time- patient refusal Oper of V2 none at this time - patient refusal Oper of V3 Head laceration and head trauma, transported to Newton- Wellesley Hospital Tody's towing arrived on scene and towed vehicles two, three to their tow lot. All proper paper work was done for a towed vehicle(s). All parties advised of the process. After the vehicles were towed, and the scene was cleared I watched the cycling of the traffic signals in the intersection and observed they were functioning properly. It appears a this time based on statements and physical characteristics of the impact area on the roadway, that vehicle two went through the red light on Cherry Street, which caused the crash.
Keywords:
Crash, Fire, Hospital, School, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.350159
Longitude:
-71.228704
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);

