crash_reports
1 row where keywords contains "Helmet" and "retrieved" is on date 2021-12-13
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-12-06
Time:
18:42
Address:
CHESTNUT ST & HIGHLAND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motorcyclist, Benjamin Stern, stated that he was traveling EASTBOUND when a motor vehicle struck him on his right side. He was stopped at the stop sign (4-way) and waited for his turn to go. When he felt it was safe to proceed, he entered the intersection. MV1, Katerina Ciccarone, stated she was traveling NORTHBOUND on Chestnut St, stopped at the stop sign and proceeded into the intersection when she felt it was safe to do so. She did not see the motorcyclist and the motorcyclist did not see her. MV1 had a junvenile passenger in the backseat behind the driver's seat belted in his child safety seat. No injuries were reported and STERN signed a refusal with the medics as he suffered from a nose bleed. STERN was wearing his helmet at the time of the crash.The motorcycle was towed by Tody's as there was heavy right side damage. MV1 was driveable and there was light front end damage.
Keywords:
Crash, Helmet
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3439588
Longitude:
-71.2233214
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);