crash_reports
1 row where "datetime" is on date 2021-10-28 and latitude = "42.3095933"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-28
Time:
15:22
Address:
244 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 10/28/2021 at approx 1522hrs, while assigned to N-498, I responded to 244 Needham St in Newton for a 2 car MVA. Upon arrival, I observed MV1 resting against a utility pole(305/25) with heavy front end damage. Joyce Samuels, the operator of MV1, was standing outside of her vehicle and complained of chest pains(possibly from her seatbelt). She states that she was traveling NB on Needham St when she suddenly lost control of her vehicle. She said she doesn't know why she lost control. Samuels was transported to NWH by medics and her vehicle was towed by Tody's Towing Service. Eversource was notified to inspect the utility pole. It should be noted I observed no fresh damage to the pole due to the accident.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3095933
Longitude:
-71.2143933
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);