crash_reports
1 row where dcc = "["Other improper action"]" and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-26
Time:
09:46
Address:
459 AUBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
-Ped#1 was crossing Auburn Street southbound when she was struck by MV#1. MV#1 left the scene of the collision and did not leave any contact information. -Ped#1 stated she was crossing Auburn Street, after signaling the crosswalk. She stated she was in the crosswalk when MV#1 kept driving. Ped#1 stated she jumped back wards to avoid being struck,however, she clipped on the left ankle. She identified the driver as an old man. -I next spoke to Wit#1 and her statements regarding the collision coincided with Ped#1 Wit one went on to describe MV#1 as a dark gray Prius; that it pulled into the MBTA parking lot after PED#1 went to get her residency manager; and lastly she observed MV#1 leave the scene of the collision. Wit#1 stated she did not get the registration for MV#1. -Ped#1 was transported to Newton-Wellesley Hospital for a minor injury to her left foot where she was struck by MV#1 while jumping out of the way. There was no cameras nor other witnesses found at this time.
Keywords:
Crosswalk, Hospital
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3457448
Longitude:
-71.252178
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);