crash_reports
4 rows where dcc_code = "[20]", intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-19
Time:
00:04
Address:
134 MT VERNON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1, a 1999 Ford Explorer, MA Reg: 7ZT136, collided with a tree on city property just outside of 134 Mt Vernon St. Operator, Jarrod Stomberg, immediately told me that he looked down at his phone to make a phone call and in that moment, ran off the road and hit the tree. There was airbag deployment. Jarrod signed a refusal with the medics and was driven home by a family member. He was issued in hand MA Citation T1441780 for 90/13B - Texting While Driving. The vehicle was towed by Tody's Towing. Pictures were taken of the scene and placed into ITs box.
Keywords:
Airbag, Citation, Phone, Pictures, Tree
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3486199
Longitude:
-71.2152611
Location:
Case
number:
Date:
2020-08-26
Time:
14:11
Address:
106 LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The witness stated she was travelling southbound on Lexington St a few vehicles behind MV#1 and observed MV#1 veered towards the northbound travel lane and striking the city tree and retaining wall of 106 Lexington St. The witness then pulled over and assisted the operator of MV#1. The operator of MV#1 stated she was travelling southbound on Lexington St and was "multi tasking" inside her vehicle when she veered off into the northbound travel lane, jumped the curb onto the sidewalk and got wedged in between a city tree and the retaining wall of 106 Lexington St. The operator of MV#1 was not injured but could not exit her vehicle because the doors were wedged in between the tree and retaining wall. MV#1 sustained heavy front end damages, broken front passenger window, front passenger wheel and deployed driver's side airbag. The operator of MV#1 stated she was not injured and was evaluated by Newton Paramedics and signed a patient refusal. The operator of MV#1 was coherent and appeared to be of sound mind and health. I transported the operator of MV#1 to her home and Tody's Towing took possession of her vehicle. Traffic unit 535 took photographs of the damaged city tree.
Keywords:
Airbag, Pictures, Tree
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3563955
Longitude:
-71.2401015
Location:
Case
number:
Date:
2021-06-05
Time:
01:03
Address:
436 LOWELL AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 states she was traveling southbound on Lowell Ave., following her GPS. Operator of MV1 states she must have looked at her GPS then struck a parked vehicle, MV2. Thus causing MV1 to roll over onto its roof, deploying both front and side airbags. The operator of MV1 was treated for minor cuts and scrapes then transported to NWH for an evaluation. Todys towed MV1. MV2 was legally parked and unattended, Owner of MV2 to be notified.
Keywords:
Airbag
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3426126
Longitude:
-71.2113193
Location:
Case
number:
Date:
2021-10-06
Time:
17:48
Address:
1112 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator 1 states he was stopped in traffic on Centre St, when he was rear ended by vehicle 2. Operator 2 states she was in stop and go traffic and was traveling northbound while "changing the radio" when she collided into the rear of vehicle 1. There was minor damage to the rear bumper of vehicle 1, and significant damage to the back right wheel well. There was heavy front end damage to vehicle 2, and the front airbag was deployed. Vehicle 2 was towed by Tody's Towing. Both operator 1 and 2 signed patient refusals with Fallon Medics.
Keywords:
Airbag
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3342298
Longitude:
-71.1931463
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);