crash_reports
1 row where "date" is on date 2021-10-16, dcc contains "Lane departure" and latitude = "42.3566909"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-16
Time:
10:13
Address:
WASHINGTON ST & CHANNING ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On October16th, 2021 at approximately 10:13 hours while working N491 I responded to a MV crash in the area of Washington St @ Channing St. On my arrival I located both involved vehicles at the gas station at the corner of Washington St @ Thornton St. Vehicle #1 was a 2018 blue BMW X2, CT REG. AS41177 operated by a Narendra Roy. He stated he was going W/B on Washington St in the far right lane when vehicle #2 entered his lane causing the crash. Vehicle #2 was a blue 2018 Lexus LX570 MA plate HAYATI, operated by a Faten Akar. She stated she was travelling W/B on Washington St in the middle lane when she attempted to change lanes so as to get to a business at #341 Washington St when vehicle #1 struck her vehicle. She further stated prior to the crash she was already half in the other lane when vehicle #1 came from her rear and never saw him.
Keywords:
Bus, Crash
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3566909
Longitude:
-71.1874033
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);