crash_reports
2 rows where "retrieved" is on date 2022-05-31 and speed_limit = 35
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-05-18
Time:
05:43
Address:
1450 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
I responded to the area of 1450 Washington St for a report of an MVA/no injuries. I arrived on location and spoke with both operators. V1; NH Reg 9763AP, 2018 PTRB Truck color white. V1 operator; Ronald Cambria MA OLN#S29121402. V2; MA CON Reg W56789, 2020 Chev/PU color orange. V2 operator, Tony Bizarro MA OLN#S57968875. The two vehicles had a minor collision as they were both traveling parallel/ same direction eastbound on Washington St. V1 operator stated he was attempting to change lanes left to right. V2 was hit in the rear drivers side just behind the wheel well. minor damage was sustained. V1 sustained scratches along the front passenger side tire rim. There were no injuries reported as a result of the collision. Towing service was not required for either vehicle..
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3465495
Longitude:
-71.2315075
Location:
Case
number:
Date:
2022-05-19
Time:
15:27
Address:
261 NAHANTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Based on observations, and statements made, the following occoured. M/V#1 was attempting to pull out of 261 Nahanton St., and turn left (east) on Nahanton St. Traffic heading west on Nahanton St. was stopped, and provided enough room for M/V#1 to pull out. As it began to enter the eastbound lane the operator accelerated and was struck by M/V#2 which was travelling east in Nahanton. M/V#1 was then spun around, and struck M/V#3 which was stopped in traffic traveling west.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.2985028
Longitude:
-71.1989141
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);