crash_reports
2 rows where keywords contains "Ems" and latitude = "42.3308369"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-26
Time:
22:32
Address:
BEACON ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 states she was driving westbound on Beacon St. She states she was driving through a green light at Walnut St, when her vehicle was struck on the passenger side by MV2. MV2 was traveling southbound and went through a red light prior to colliding with MV1. Operator of MV2 stated she was "at fault". She was issued in hand MA citation #T1444149 for 89/9, Fail to Stop, Yield. Both vehicles were towed by Todys. Initially both parties refused medical attention. After the accident was cleared, Operator of MV2 admitted the accident was a suicide attempt. She was transported to NWH voluntarily by Cataldo EMS.
Keywords:
Citation, Crash, Ems
Dcc:
Signs/Signals, Emotional
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
Location:
Case
number:
Date:
2019-11-22
Time:
17:18
Address:
WALNUT ST & BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator MV1 of stated that he was traveling Southbound on Walnut St attempting to turn left and travel Eastbound on Beacon St when MV 2 attempted to pass MV 1 and side swiped the right side of MV 1. The operator of MV 2 stated that MV 2 was attempting to take a left onto Beacon St and MV 1 attempted to illegally pass MV 2 on the left hand side causing a collision. Fire and EMS responded as well but there were no injuries sustained to either party. MV 2 was towed by Tody's due to it being disabled on a public way.
Keywords:
Ems, Fire
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
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);