crash_reports
2 rows where "datetime" is on date 2019-12-23 and keywords contains "Ped"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-23
Time:
08:32
Address:
WALNUT ST & AUSTIN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator #1 stated he was going S/B on Walnut St and was slowing to a stop as he approached the intersection of Austin St due to traffic stopped ahead for pedestrians crossing the street. Howeveras vehicle #1 was slowing down as he approached the stopped traffic, Vehicle #2 came out of the other side of Walnut St, N//B side and struck his vehicle on his rear drivers side as he was attempting to turn left, S/B onto Walnut St. Operator #2 stated he came out from Newtonville Ave and was crossing the N/B side of Walnut St attempting to go S/B on Walnut St when he crashed into vehicle #1 as he was turning left(S/B) onto Walnut St. Operator #2 further stated he never saw vehicle #1 coming prior to making his turn. However he did state he saw the two vehicles stopped further south by Austin St.
Keywords:
Crash, Ped
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3505802
Longitude:
-71.2069457
Location:
Case
number:
Date:
2019-12-23
Time:
19:19
Address:
807 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
On 12/23/19, at 1919 hours, I responded to the area of 807 Washington St. for pedestrian struck by a motor vehicle. Upon arrival with Cataldo Medics and Newton Fire, I observed Catherine Chapman being treated in the westbound lane a few feet in front of a 2010 Hyundai Elantra (MA Reg. 4KH 743). The vehicle had a shattered windshield. Ms. Chapman appeared to be wearing a dark colored jacket and dark pants. The operator of the motor vehicle, Emily Shuman, stated she was traveling westbound in the outside lane when Ms. Chapman stepped in front of her car from the eastbound lane. I also spoke with a witness, Malcolm Robinson, who stated Ms. Chapman was crossing the street from the eastbound lanes with two other people. The other two people stopped in the middle of the street but Ms. Chapman kept walking and was struck. The other two people were Victor Polk and Halimah Polk, both of which confirmed the witness statement. Ms. Chapman was transported by Cataldo to Brigham & Womens Hospital with non-life threatening injuries. Todys towed the vehicle and pictures of the scene were submitted to IT.
Keywords:
Fire, Hospital, Ped, Pictures, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3519457
Longitude:
-71.2064132
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);