crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-11-01
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date)
Case
number:
Date:
2021-10-25
Time:
09:41
Address:
455 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Monday 10/25/2021 at approx 0941hrs, while assigned to N-498, I responded to the area of 455 Nahanton St for a single vehicle MVA. There, I observed MV1 pulled over on the side of the road facing EB. Operator of MV1 states she was traveling EB on Nahanton St and soon after crossing the bridge into Newton, a deer ran in front of her vehicle and collided with it. With little time to react and with wet road conditions she could not avoid striking the deer. It should be noted that the deer could not be located and was witnessed going back into Nahanton Woods. I observed that MV1 sustained a cracked front windshield and a broken driver side mirror. There was what appeared to be deer fur on the driver side door and mirror.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2999309
Longitude:
-71.2079747
Location:
Case
number:
Date:
2021-10-26
Time:
18:17
Address:
420 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was stopped waiting behind a line of cars for the redlight in front of 420 Watertown st when MV2 rear ended MV1 and left the scene without providing any iinformation. Operator of MV1 was evaluated by medics and signed a refusal. No vehicles were towed.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3593914
Longitude:
-71.2027985
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);