crash_reports
2 rows where latitude = "42.3510472" and street2 = "WEST WASHINGTON ST"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-08
Time:
17:42
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated he was traveling westbound on Washington Street through the intersection of Washington Street and Lowell Ave. While going through the intersection vehicle 2 crashed into vehicle 1 while vehicle 2 was attempting a left turn. The operator of vehicle 2 stated he was on Washington Street and turned left onto Lowell Ave, he did not see vehicle 1 and crashed the front center of his vehicle into the passenger side quarter panel of vehicle 1.
Keywords:
Crash
Dcc:
Improper turn, Inattention
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
Location:
Case
number:
Date:
2021-10-22
Time:
16:14
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 stated she had a green light when MV2 "ran the red light" subsequently striking MV1 causing front end damage. MV2 stated he was "coming over the hill and the sun made the light look green" subsequently striking MV1 causing minor damage. No tows were required & no injuries were reported.
Keywords:
Solar
Dcc:
Visibility obstructed
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);