crash_reports
1 row where "date" is on date 2021-08-22, dcc_code = "[10]" and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-22
Time:
23:17
Address:
414 WALTHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Upon arrivial, I observed Vehicle 1 crashed into a tree at the corner of Waltham St and Orchard Ave. The vehicle appeared to travel southbound on Waltham street and crossed the double yellow line and collided with a tree. I observed heavy front end damage to the vehicle and the tree. The vehicle was unoccupied, and the right passenger air bag had gone off. Two witnesses, Gonzalo Milet and Can Erbil both stated they heard the crash and saw two male parties running down Orchard Ave towards Adella Ave and Watertown St. While multiple other units were checking the area they located male parties, Jonathan Sajquin Carey and Cristian Vargars at the corner of Adella Ave and Watertown St. Both parties were unsteady on their feet. Mr. Sajquin Carey stated that he was the operator. He was issued Massachusetts Uniform citations T1445449 and T1445449. See incident report # 21036126. Vehicle 1 was towed by Tody's towing.
Keywords:
Citation, Crash, Tree
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3528974
Longitude:
-71.2239627
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);