crash_reports
2 rows where "datetime" is on date 2021-03-08 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-08
Time:
12:49
Address:
25 ARMORY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 03/08/2021 at 1249hrs I responded to 25 Armory St for a motor vehicle crash involving a city of Newton owned motor vehicle. Vehicle 1 described as city of Newton Fire Engine #4 (MA Fire Reg 444) backed into Vehicle 2 which was parked and unoccupied facing northbound on Armory St. As a result of the impact Vehicle 1 sustained little to no visible damage, Vehicle 2 sustained minor damage to the passenger side front bumper. No injuries were reported on scene. No tows were required. Photographs were taken and submitted to the NPD IT Bureau.
Keywords:
Crash, Fire, Pictures
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3503557
Longitude:
-71.2198091
Location:
Case
number:
Date:
2021-03-08
Time:
16:51
Address:
ADAMS ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Monday, March 8th 2021, at approximately 4:51pm, I, Officer Brooks, responded to the intersection of Washington street and Adams street for an auto pedestrian accident. The vehicle involved was described as a 4 door blue sedan and had fled the scene northbound on Adams street. The injured party was not able to provide any further description of the vehicle or operator, and no witnesses were present. I spoke with Traivon King who was the party that had been struck by the vehicle. He stated he was walking eastbound on Washington street, and had the cross walk signal to cross over Adams street. The blue sedan was traveling westbound on Washington street and turned northbound on Adams street ignoring the crosswalk signal. King stated he was struck on the right side of his body and knocked to the ground. The operator of the car stopped briefly and stated the sun had been in his eyes before driving away. King complained of pain to his right arm, and was transported by Fallon ambulance services to NWH. It should be noted it was day light, the weather was clear, and King was wearing a green plaid jacket, a plaid hat, and blue jeans. Due to the fact the vehicle had fled the scene and the victim was aready being tended to by the medics photos were not taken.
Keywords:
Crash, Crosswalk, Ems, Ped, Pictures, Solar, Walk
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3548522
Longitude:
-71.1956673
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);