crash_reports
1 row where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2021-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-09
Time:
13:45
Address:
437 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Driver #1 stated she was driving southbound in front of 437 Centre St in slow traffic when Driver #2 rear ended her. She stated Driver #2 got out of the vehicle, looked at her car and stated he did not see any damage. She asked for his license and registration which he declined to provide. Driver #2 then drove away. Vehicle #1 suffered minor damage to the rear and was driven from the scene. Driver #1 was able to provide me with a picture of the vehicle license plate and a description of Driver #2 which matches the RMV image of the registered owner of Vehicle #2. I attempted to locate a number for Driver #2 with negative results. I also contacted Waltham PD for information for Driver #2 and they were unable to provide anything further. I mailed Driver #2 Citation #2081383 for Chapter 90 Section 24 Leaving the Scene of Property Damage.
Keywords:
Citation, Pictures
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3554145
Longitude:
-71.1864033
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);