crash_reports
2 rows where intersection = 0 and "retrieved" is on date 2021-03-30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-17
Time:
15:13
Address:
147 LOWELL AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated he as traveling northbound on Lowell Ave and as he was approaching 147 Lowell Ave, a car was coming in the opposite direction. There were cars parked legally on both sides of the road. As a MV was driving southbound, it had to cross double yellow to pass, Operator of MV1 moved over to the right and struck the parked MV2. Due to airbag deployment, I requested the medics. The operator of MV1 was transported to NWH. He appeared to be confused. The passenger in MV1 was not injured. MV1 was towed by Todys. MV2 was parked in a legal spot and called for a private tow.
Keywords:
Airbag
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3522945
Longitude:
-71.210339
Location:
Case
number:
Date:
2021-03-17
Time:
17:39
Address:
721 WASHINGTON ST
Speed
limit:
40
Violation
cited:
no
Narrative:
MV1 was traveling WESTBOUND on Washington St in the middle westbound lane when it was struck by MV2 exiting a parking lot. MV1 was t-boned on its passenger side by MV2. MV1 sustained heavy damage to its passenger door and rear passenger wheel, deeming it unsafe to drive. MV2 was exiting the parking lot of 723 Washington St, did not see MV1 coming and struck the vehicle, damaging his driver's side front. No injuries reported. Tody's towed MV1.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3527483
Longitude:
-71.2031248
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);