crash_reports
2 rows where "datetime" is on date 2020-02-22 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:
2020-02-22
Time:
09:26
Address:
15 CYPRESS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated he was travelling on Cypress St N/B and briefly looked into his rear view mirror. #1 stated at that time he rear ended Mv#2 that was stopped in traffic ahead of him. #2 operator stated she was travelling on Cypress St N/B and slowed to a stop for another MV in front of her whom had stopped for a pedestrian in the crosswalk at #15 Cypress. #2 stated at this time she was rear ended by #1. Mvs #1 and #2 both sustained heavy damage to the passenger side front end and passenger side rear end, respectively. Both towed by Tody's towing. No injuries reported.
Keywords:
Crosswalk, Ped
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3285638
Longitude:
-71.1951188
Location:
Case
number:
Date:
2020-02-22
Time:
10:10
Address:
HILLSIDE RD & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she was travelling on Walnut St N/B and looked to her left at a house for sale. #1 stated at that time she rear ended Mv#2 that was stopped in traffic ahead of her. #1 sustained heavy front end damage and was towed by AAA. Mv#2 operator stated he was travelling on Walnut St N/B and slowed to a stop for Mv#3 which came to a stop in front of him for a pedestrian crossing Walnut St at Hillside Rd. #2 stated at that time he was rear ended by #1 and was pushed forward into #3. #2 sustained significant rear end damage and appeared to sustain no damage to the front end. #2 was able to be driven away. Mv#3 operator stated she was travelling on Walnut St N/B at Hillside Rd and slowed to a stop for a pedestrian crossing Walnut St. #3 stated at that time she was rear ended by #2. #3 appeared to sustain no damage to the rear end. No injuries reported.
Keywords:
Ped
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.324184
Longitude:
-71.206984
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);