crash_reports
1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-02-05
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-17
Time:
15:31
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that he was operating Newton Marked Cruiser 491 Eastbound on Washington Street. After stopping at the red light at the intersection of Lowell Ave, he traveled forward and struck the rear bumper of Vehicle #2. Operator #1 was not injured and the cruiser was not damaged. Both vehicles were driven from the scene. Operator of Vehicle #2 stated that she was traveling Eastbound on Washington Street at the intersection of Lowell Ave. After stopping at the red light she began to travel forward when her vehicle was struck from behind by Vehicle #1. Operator #2 stated that she was not injured. Vehicle #2 had minor damage to the rear bumper, which was photographed and submitted to the IT Bureau.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);