crash_reports
2 rows where "datetime" is on date 2022-05-26 and dcc = "["Unknown"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-26
Time:
07:56
Address:
CENTRE AVE & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV 1 STATED THAT WHILE HE WAS TRYING TO MERGE ONTO CENTRE AVE FROM CENTRE STREET, A LARGE RED TRUCK (TRACTOR TRAILER) WAS TRAVELING IN THE SAME DIRECTION AND TO HIS LEFT. THE TRACTOR TRAILERS RIGHT SIDE SIDESWIPED MV 1 CAUSING MAJOR DAMAGE TO HIS DRIVERS SIDE. THE TRUCK CONTINUED ON HIS WAY AND NO REG PLATE WAS AVAILABLE. THE OPERATOR OF MV 1 WAS ABLE TO GET A PICTURE OF THE TRUCK BUT THE PICTURE DOES NOT SHOW THE REG PLATE OR ANY OTHER DISTINCTIVE DETAILS. NO INJURIES WERE REPORTED AND MV 1 SUSTAINED HEAVY DAMAGE.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2022-05-26
Time:
08:32
Address:
1445 COMMONWEALTH AVE.
Speed
limit:
25
Violation
cited:
no
Narrative:
Newton Police, Fire and Medics were dispatched to Commonwealth. Ave. and Dartmouth St. for Motor Vehicle Collision. Dispatch was advising a vehicle had collided into a poll. Upon arrival, Ofc. observed a Eversource street light poll laying on the grass carriage lane (westbound side). MV#1 was observed facing westbound in the eastbound lane of Commonwealth. Ave with front and side airbags deployed. The operator of MV#1 reported she was traveling westbound on Commonwealth Ave. prior to colliding into the light pole, but states she does not remember the moments prior to the collision.The operator of MV#1 reported she was uninjured, but was transported to Newton-Wellesley Hospital as a precaution. Newton Fire personnel determined the damaged light poll was not a hazard while Eversource was notified regarding their damaged poll. A witness to the collision reported they observed MV#1 traveling westbound on Commonwealth Ave. at approximately 20-25 mph, before it veered off the roadway and into the light poll. After colliding into the light poll MV#1 crossed over the double yellow line into oncoming traffic and hit the curb on the eastbound side of Commonwealth Ave. Pictures of MV#1 and the Eversource light poll were taken on the N493 camera and submitted to the NPD IT bureau. A Request for an Immediate Threat License Suspension/Revocation was faxed over to the Massachusetts RMV on behalf of the Operator of MV#1 due to the circumstances of this collision.
Keywords:
Airbag, Fire, Hospital, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3380576
Longitude:
-71.2252854
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);