crash_reports
3 rows where "retrieved" is on date 2021-10-25 and street2 = "WEST WASHINGTON ST"
This data as json, CSV (advanced)
Suggested facets: speed_limit, keywords, 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-13
Time:
09:38
Address:
QUINOBEQUIN RD & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/13/2021 at approx 0938Hrs while assigned to 497 I responded to the area of Washington St and Quinobequin Rd for a report of a 2 car crash. Upon arrival both operators where pulled to the side of the road on Quinobequin Rd. I spoke with the operator of Ma Reg 3FWN51 Alicione Goncalves who stated she had the green light travelling Quinobequin Rd southbound when the pickup truck turned in front of her causing the collision. i spoke with the operator of NH Com Reg RBAC02, Robert Allen who stated he was travelling northbound on Quinobequin Rd , mistakenly though the green light was a green arrow to turn left onto Washington St colliding with Goncalves.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3274875
Longitude:
-71.2531655
Location:
Case
number:
Date:
2021-10-23
Time:
06:19
Address:
JACKSON RD & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV#1 Was traveling Westbound on Washington St then veered of the road and into a light pole at the intersection of Washington St and Jackson Rd. OPMV#1 Stated she fell asleep behind the wheel and was driving to Rhode Island. MV#1 Sustained major damage to the front end and was towed by Tody's Towing.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3549582
Longitude:
-71.1952442
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);