crash_reports
2 rows where "datetime" is on date 2021-02-08, dcc contains "Followed too closely" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-08
Time:
18:07
Address:
1011 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Monday 2/8/2021 at approx 1807hrs, while assigned to N494, I responded to the area of 1011 Centre St in Newton for a 2 vehicle MVA. Operator 1 stated that there was traffic ahead of him and his car was moving slowly when MV2 struck the rear of his car. Operator of MV2 stated that it appeared that MV1 was about to make a turn but did not. She was unable to stop in time before crashing into MV1.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3376442
Longitude:
-71.193564
Location:
Case
number:
Date:
2021-02-08
Time:
19:26
Address:
734 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that her vehicle was struck in the rear as she was stopped at the light at Centre St and Cabot St. The operator of Vehicle #2 stated that he was blinded by headlights from oncoming traffic, and didn't see Vehicle #1 prior to the collision.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3465894
Longitude:
-71.1889228
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);