crash_reports
1 row where "datetime" is on date 2022-01-27, dcc contains "Lane departure" and latitude = "42.3169482"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-27
Time:
07:42
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 1/27/22 at approximately 0742 hours while assigned to marked unit n498 I was dispatched to the intersection of Boylston Street and Chestnut Street for a report of a minor motor vehicle crash with no injuries. Upon arrival I spoke with the operator, LOUISSANT Carmelle, of motor vehicle #2 (ma reg 1ZAK94). LOUISSANT states she was stopped at the stop sign on Boylston Street at the intersection of Chestnut Street preparing to take a left turn onto Chestnut Street. LOUISSANT states before moving a large box truck was turning left onto Boylston Street westbound and the rear of the box truck crossed into her lane of travel striking the front drivers side of her vehicle. After speaking with LOUISSANT I spoke with the operator, FERNANDEZ Albert, of motor vehicle #1 (ma commercial reg T40813). FERNANDEZ states as he was turning left on to Boylston Street LOUISSANT was attempting to pull into the intersection striking the rear drivers side of his box truck.
Keywords:
Crash
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
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);