crash_reports
2 rows where dcc contains "Emotional", "retrieved" is on date 2020-10-06 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-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:
2020-07-22
Time:
06:54
Address:
165 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Based on observations and statements made, the following occoured. M/V#1 was traveling east on Needham St. when the operator abruptly turned left to enter 165 Neddham St. M/V#2 was traveling behind M/V#1, and collided with the left rear of M/V#1 as it turned left.
Keywords:
[]
Dcc:
Emotional, Unknown
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
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);