crash_reports
1 row where date = "2019-07-22" and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-22
Time:
09:00
Address:
AUSTIN ST & LOWELL AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV#1 (International Driving Permit #1318-19-126145 with an active Korean passport expiring on 11/11/2028 with an RMV OLN of SA1730649) stated she was travelling southbound on Lowell Ave at the intersection of Austin St when she was struck by MV#2. MV#1 sustained heavy front end damages. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated she was travelling westbound on Austin St and stopped for the stop sign at the intersection of Lowell Ave. The operator of MV#2 stated she then proceeded through the stop sign and made contact with MV#1. MV#2 sustained heavy damages to its entire right side with front passenger side curtain airbags deployed. There were no reported injuries to the operator of MV#2 or the front passenger. Based on the statements made to me, I issued in hand MA uniform citation #T1268346 to the operator of MV#2 for violation of c89 s9 failure to comply stop sign. Tody's Towing took possession of MV#1 and AAA took possession of MV#2. The operator of MV#2 provided me with a witness's information (Atenia at 617 981-0165). I attempted to contact the witness with negative results and no voicemail.
Keywords:
Airbag, Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3502544
Longitude:
-71.2108899
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);