crash_reports
4 rows where "datetime" is on date 2022-06-20 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-20
Time:
12:33
Address:
331 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 6-20-22 AT APPROX. 1233HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 331 WALNUT ST. I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES SOMETIME BETWEEN 1215HRS-1233HRS WHILE HIS VEHICLE WAS PARKED IN FRONT 0F331 WALNUT ST. SOMEONE HAD HIT HIS FRONT LEFT BUMPER OF HIS MOTOR VEHICLE CAUSING DAMAGE. THERE WERE NO WITNESSES IN THE AREA AND NO ONE HAD LEFT A NOTE. VEHICLE #1 HAD LEFT FRONT BUMPER DAMAGE. OWNER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3497031
Longitude:
-71.2071277
Location:
Case
number:
Date:
2022-06-20
Time:
13:42
Address:
124 LANGLEY RD
Speed
limit:
35
Violation
cited:
no
Narrative:
On June 20, 2022 at approximately 1342 hours, I responded to 124 Langley Rd for a report of an MVA. Upon arrival, I spoke with owner of MV2 who stated a man named Patrick Fabrizio saw MV1 strike their MV and continue down the road(see Patricks witness statement). The owner of MV2 stated their vehicle was parked outside of 124 Langley Rd when the incident occurred. I observed damage to the driver's side mirror. Patrick was able to take a photo of MV1 plate and I was able to contact the owner and coordinate an exchange of information among the Owners. Owner of MV1 states she was driving WB on Langley Rd when she struck MV2 side mirror. No injuries or tows to be reported.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3287678
Longitude:
-71.1893408
Location:
Case
number:
Date:
2022-06-20
Time:
15:05
Address:
300 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Operator of MV1 was parking in a parking spot outside of Pressed Cafe located at 300 Needham St. Operator believed she was in Park but was actually in Drive. Operator mistakenly pressed on the gas and accelerated over the curb and through a large window and ended up inside of Pressed Cafe. Operator and her daughter, Brynn Bryant, were trapped in the vehicle and freed by NFD. Operator and Brynn were transported to Newton Wellesley Hospital. The other 2 passengers, Gabe Cohen and Marc Andrew, were not trapped and declined any medical attention and left the scene after speaking with the medics. MV1 was towed by Todys. Nobody inside Pressed Cafe was injured. John Faggiano was standing next to where the car went through the building but declined any medical attention. Pictures and a video of the accident from the security system was sent to IT to attach to the report.
Keywords:
Crash, Fire, Hospital, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-06-20
Time:
17:24
Address:
COMMONWEALTH AVE & LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1, MV2, and MV3 were all driving EASTBOUND on Commonwealth Ave in the left turn only lane to turn onto Lexington St Northbound. All vehicles were stopped at a red light when a 4th vehicle struck MV3 with such force that MV3 collided with MV2 and MV2 collided with MV1. MV4 left the scene immediately after the collision. Drivers from all three vehicles were unable to give information on the vehicle that fled the scene speeding EASTBOUND on Commonwealth Ave. MV1 sustained minimal damage to the rear bumper. MV2 & MV3 sustained minimal damage to both front and rear bumpers. Passenger from MV2 was checked by medics for reports of whiplash and signed a refusal. All vehicles were driveable after the incident.
Keywords:
Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
Longitude:
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);