crash_reports
1 row where "date" is on date 2022-02-28 and latitude = "42.3510472"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2022-02-28
Time:
19:32
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was traveling WESTBOUND on Washington St when MV2 collided with her. MV1 operator stated that she was driving straight through the four-way intersection at Lowell Ave with a green light when MV2 collided with her while they were taking a left turn onto Lowell Ave from Washington St. MV2 operator stated that she was traveling EASTBOUND on Washington St, signaled to turn left onto Lowell Ave and proceeded through the intersection when she felt it was safe. MV2 operator believed that MV1 swerved around the vehicle in front of her signaling to turn left and sped through the intersection at a high rate of speed. MV2 stated that she did not see MV1 coming. MV1 damage was to the driver's side fender and MV2 had minimal damage to its driver side fender as well. No injuries reported and both vehicles were safely operable from the scene.
Keywords:
Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);