crash_reports
2 rows where dcc_code = "["20"]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-22
Time:
09:08
Address:
241 NEEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 01/22/19 I responded to a three vehicle crash on Needham St. in front on #241- Marshalls Plaza. The operator of veh #1 stated she was driving due West on Needham St. when she looked right at a car waiting to pull out of the parking lot. When she looked back to Needham St., the traffic was stopped and she hit her brakes and snow slid covered her windshield. Operator of veh #1 never saw the impact, but veh #1 struck stopped veh #2 which was pushed into stopped veh #3. Moderate damage to veh #1 and 2 but no damage at all to veh #3. Operator of veh #2 said she was going "2-3 MPH " when she was pushed into veh #3. Operator of veh #3 claimed she was dizzy from the accident and signed a patient refusal from Ambulance #1. Engine #7 was also on scene assisting. Operator of veh #1 was cited in hand Mass citation #T1441211 for Ch 90/ Sec 13- failure to remove snow from vehicle . All vehicles were driven away from the scene.
Keywords:
Citation, Crash, Ems, Moderate, Snow
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3097858
Longitude:
-71.2156787
Location:
Case
number:
Date:
2019-01-29
Time:
08:32
Address:
110 PARKER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Mv#1 operator stated he was at a complete stop on Parker St N/B near #110 idling in backed up traffic. #1 stated he was suddenly rear ended by Mv#2. #1 complained of a burning sensation pain going up his leg possibly related to a previous hip injury. #1 was transported by medics to NWH. #1 sustained significant rear end damage. It was towed by Tody's. #2 operator stated she was travelling on Parker St N/B while looking to her right at travel directions on her phone. #2 stated at that time she rear ended #1 ahead of her. #2 stated she was not injured and signed the patient refusal. #2 towed by Tody's with heavy front end damage.
Keywords:
Phone
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3235716
Longitude:
-71.1937265
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);