crash_reports
1 row where "datetime" is on date 2019-09-17 and keywords = "["Crash"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-17
Time:
18:25
Address:
COURT ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
At approximately 1825HRs on Tuesday, September 17, 2019, I was dispatched to the intersection of Washington St. at Court St. for a report of a two car crash with minor injuries. Upon arrival, I spoke with the operator of motor vehicle 1 (MA Passenger: 64G720), who stated through a third party interpreter, that he was driving "on the big road (Washington St. Westbound) and was hit." The operator of motor vehicle 2 (MA Passenger:8WH577), stated that she was traveling southbound on Court St. and stopped at the stop sign with the intent to make a left hand turn onto Washington St. (eastbound). At this time, she observed motor vehicle 1 traveling towards her with its right hand turn signal activated to take a right hand turn on Court St. (northbound). Motor vehicle 1 began to execute said turn, but as it was partially on Court St., changed directions and began to again attempt to travel westbound on Washington St., striking motor vehicle 2 as it was at the stop sign. Motor vehicle 1 sustained damage to its front right bumper area. Motor vehicle 2 sustained damage to its front left side bumper area. The operator of motor vehicle 1 was uninjured. The operator of motor vehicle 2 is pregnant and signed a patient refusal after speaking with Newton Medics. Both vehicles left the scene under their own power and I cleared without incident.
Keywords:
Crash
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.353006
Longitude:
-71.2012145
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);