crash_reports
2 rows where "datetime" is on date 2021-09-09, 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-09-09
Time:
15:00
Address:
355 CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On September9th, 2021 at approximately 15:05 hours while working N491 I responded to #355 Craft St for a report of a 3 vehicle crash. On my arrival I located all involved MV'S. Vehicle #1 was a White Toyota Sienna, Comcast truck, commercial plate ME 6c5966, operated by a Stefan Alexa. He reported going N/B on Craft St when vehicle #2 suddenly stopped in front of him. His vehicle then rear ended vehicle #2 which got forced into vehicle #3. Vehicle #2 was a 2007 Grey SUV Amada, Ma reg. 6HX124, operated by a Maria Chilel. She reported going N/B on Craft St when vehicle #3 suddenly stopped in front of her. She then stopped her vehicle. However her Vehicle was then rear ended by vehicle #1 which caused her to be forced into the rear of vehicle #3. Vehicle #3 was a white chev pick up truck MA Reg.5APV80, operated by a Louise Paolini. She stated that she was travelling N/B on Craft St when a vehicle in front of her suddenly stopped. She was able to stop her vehicle but was rear ended by vehicle #2. She later learned that vehicle #2 was forced into her vehicle after she was rear ended by vehicle #1. There were no injuries or tows due to this crash.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3598967
Longitude:
-71.2137527
Location:
Case
number:
Date:
2021-09-09
Time:
14:56
Address:
976 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling southbound on Centre St in traffic near the intersection of Centre St @ Ward St. MV2 was also traveling southbound on Centre St. MV2 operator stated due to the road way conditions of rain, her tires did not catch the roadway and when she applied the breaks her tires slipped due to the rain. MV2 attempted to stop but was not able to and rear ended MV1.
Keywords:
Rain
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3388534
Longitude:
-71.1925894
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);