crash_reports
1 row where "datetime" is on date 2020-02-08, dcc contains "Reckless driving" and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-08
Time:
09:54
Address:
CENTRE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On February 8th, 2020 at approximately 09:54 hours I responded to the area of Washington St and Centre St for a reported hit & run MV crash. The R/P, called back stating she was now parked waiting for police on Park St near Elmwood Pk. On my arrival the operator of MV #1 stated she was driving E/B on Centre Ave after first exiting the Mass pike when vehicle #2 abruptly changed into her lane striking her passenger side front side tire. Operator #1 observed vehicle 2 which she described as a small grey colored either Honda of Ford continue E/B before observing vehicle #2 turn right onto Park St. Operator #1 thought the driver was going to pull over on Park St but when she followed vehicle 2 to Park St vehicle #2 was gone . Operator further reported that vehicle #2 had noticeable damage to his drivers side front. A bolo was given out to Boston PD.
Keywords:
Crash
Dcc:
Lane departure, Reckless driving
Report
url:
Image
url:
Latitude:
42.329368
Longitude:
-71.1950954
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);