crash_reports
2 rows where dcc = "["Other improper action", "Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-04-12
Time:
22:02
Address:
145 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states she was traveling southbound on Lexington St driving MA 6YC616 and simply did not see a legally parked car on the side of the road in front of #145 Lexington St. Operator made contact with the left rear side of vehicle #2, MA 9LA119. She then lost control and veered left then right, making contact with vehicle #3 MA 6LX318 before coming to a stop on the grass of 145 Lexington St. Vehicle #3 sustained minor damage to the right rear bumper area and was also parked legally. Operator #1 signed a patient refual and vehicle #1 was towed by Tody's with significant front end damage ( inventory form filled out). The owners of vehicles #2 and #3 were on scene and were provided with this report number.
Keywords:
[]
Dcc:
Other improper action, Unknown
Report
url:
Image
url:
Latitude:
42.3557274
Longitude:
-71.2418991
Location:
Case
number:
Date:
2020-10-19
Time:
19:30
Address:
450 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 was driving northbound on Lexington St behind a white box truck (vehicle #2) when she observed the truck strike a large branch from a city tree in front of 450 Lexington St. The branch fell onto the hood of vehicle #1, and the truck continued north without stopping. I observed slight damage to the front of vehicle #1 however a tow was not needed. Medics responded and documented a patient refusal from operator #1. This incident was called in by detail Officer B. Keefe, who was working a National Grid detail at this location (one lane was blocked off by cones but there was still a full travel lane being utilized for northbound traffic). A plate could not be obtained by anybody on scene due to the crash occurring so quickly. It is believed that there was black lettering on the truck, however what it said is unknown. Forestry was notified to remove the branch from the roadway.
Keywords:
Crash, Tree
Dcc:
Other improper action, Unknown
Report
url:
Image
url:
Latitude:
42.3466096
Longitude:
-71.2461099
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);