crash_reports
2 rows where "date" is on date 2019-11-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-11-06
Time:
08:59
Address:
183 JACKSON RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday, November 6th, 2019, at approximately 0859 hours I, Officer Newton and Officer Boudreau were dispatched to 183 Jackson Rd for a motor vehicle accident. Upon arrival I spoke to the operator of vehicle 1. He stated he was driving Southbound on Jackson Rd when vehicle 2 came into his lane while driving the opposite direction and side swiped him. The operator of vehicle 2 stated he was driving Northbound on Jackson Rd when vehicle 1 came into his lane while driving the opposite direction and sideswiped him. The operator and passenger in vehicle 1 stated they had minor injuries from the collision but did not request any medical assistance. The operator and passengers of vehicle 2 denied any injuries or medical assistance. Both vehicles were able to drive away from the scene safely.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3568377
Longitude:
-71.1955934
Location:
Case
number:
Date:
2019-11-06
Time:
08:17
Address:
LEXINGTON ST & COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was traveling north on Lexington St approaching Commonwealth Ave in the left hand lane. Operator #1 then realized she needed to enter the right hand lane to make a right hand turn onto Commonwealth Ave. According to operator #1, as she was entering the right hand lane, MV#2, who was traveling directly behind her also entered the right hand lane and passed MV#1. While MV#2 passed MV#1 her front bumper was struck and ended up on the street. Operator #1 stated that MV#2 did not stop and the only description is a truck with a trailer. No injuries, no tows.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3478859
Longitude:
-71.247136
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);