crash_reports
1 row where date = "2021-02-17", dcc contains "Inattention" and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-17
Time:
17:59
Address:
RACHEL RD & WINCHESTER ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV1 stated she was stopped at the stop sign on Winchester streetat Rachel Road and her vehicle was rear ended. The operator of MV2 states that she looked down for a second and rear ended MV1. Both operators and the passenger of MV1 were uninjured. MV1 sustained minor rear end damage and was driven from the seen while MV2 sustained minor front end damage and was left parked at the scene. It was determined that the operator of MV2, Jillian Ziedman, had a suspended license. MV2 was legally parked to be picked up by a licensed driver and Ms. Ziedman was picked up by her employer. I provided Ms. Ziedman Massachusetts Uniform Citation T2080143 for 90-23 Operating a Motor Vehicle with a Suspended License. A court packet was completed and placed in the court prosecutors mailbox.
Keywords:
Citation
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3064293
Longitude:
-71.2056837
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);