crash_reports
1 row where "datetime" is on date 2021-03-12, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-12
Time:
15:53
Address:
CENTRAL ST & GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator Diego Colindres states he was stopped at the stop sign located on Central St westbound at Grove St. As he proceeded through the sign to drive onto Grove St, a female jogger ran out into the street from the sidewalk in front of 16 Grove. Colindres reports he did not see the jogger until his front bumper made contact with the jogger's leg, which in turn knocked her to the ground. The jogger then got up, said she was ok, and tried to continue on her way. Colindres asked her to stay on scene and wait for emergency personnel, to which she obliged. It should be noted that there are bushes located in front of 16 Grove St which substantially hinder the view of the sidewalk for vehicles approaching Grove from Central. Jogger Rachel Coffin confirmed that she was crossing Central St heading southbound on Grove St when she was hit by vehicle #1. Coffin was not sure if she stopped prior to crossing the street, and did not see the vehicle until contact was made. She does recall that the vehicle was traveling at a slow rate of speed when she was struck. Coffin's attire consisted of dark colored shorts, a navy t-shirt, and white sneakers. I observed a light red area on Coffin's outer left thigh consistent with the height of vehicle #1's front bumper. She was tended to by the medics and declined transport, repeatedly saying that she just wanted to get back to school (Lasell) and do her homework. Due to Coffin's uncooperativeness and multiple requests to leave the scene, pictures of her minor injury were not taken. There was no visible damage to vehicle #1. Traffic responded, however Coffin wished to leave prior to arrival.
Keywords:
Bus, Pictures, School, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3454654
Longitude:
-71.2462928
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);