crash_reports
3 rows where "datetime" is on date 2022-07-13 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-07-13
Time:
09:27
Address:
275 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED TO ME THAT WHILE TRAVELING IN THE RIGHT LANE ON CENTRE ST NEAR STARBUCKS AND UNKNOWN LARGE 18 WHEEL TRUCK WAS IN THE LEFT LANE BESIDE HER, ENTERED HER LANE AND STRUCK HER VEHICLE ON THE REAR DRIVERS SIDE CAUSING DAMAGE AND PUSHING HER OUT OF HER LANE. THE TRUCK WHICH WAS POSSIBLY MAROON IN COLOR, NEVER STOPPED TO SWAP INFORMATION AND CONTINUED ONTO THE MASS PIKE WESTBOUND. THE OPERATOR STATED HER NECK HURT BUT REFUSED MEDICAL ATTENTION.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-07-13
Time:
12:57
Address:
ELINOR RD & MILDRED RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday 7/13/22 at approximately 1257 Hours while assigned to marked unit n498 I was dispatched to the intersection of Elinor Rd. and Mildred Rd. for a report of a minor motor vehicle crash with no injuries. Upon arrival I spoke with the operator, ELLIOT Barry, of motor vehicle #1 (ma reg 1FJ935) who states he was travelling Westbound on Elinor Rd. when MV#2 pulled out to take a left from Mildred Rd to Elinor Rd. striking the drivers side rear of his vehicle. ELLIOT states he doesn't think MV#2 stopped at the stop sign. After speaking with BARRY I spoke with the operator, SUN Huaihe, of motor vehicle #2 (ma reg 2MWV58). SUN did not speak English so I spoke with him through a friend of his to translate. SUN states he was taking a left from Mildred Rd. onto Elinor Rd. and did not see MV#1 coming until it was to late and struck the vehicle. SUN stated to me that he did stop at the stop sign.
Keywords:
Crash, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.315758
Longitude:
-71.1982727
Location:
Case
number:
Date:
2022-07-13
Time:
17:27
Address:
OTIS STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said he was traveling Northbound on Walnut Street and turned Westbound on to Otis Street. Operator of MV1 said he heard a low hanging wire hit the top of his truck and when he looked in his mirrors he realized the wire had come down. Operator of MV1 pulled to the side of the road to report the down wire. An Eversource truck saw the wire come down and rolled the wire up and out of the road. When the wire went down it caused minor damage to the trailer of the truck and it struck a motor vehicle behind the truck causing minor damage (See incident report 22024800 for damage done to the other vehicle). Both MV1 and MV2 were able to drive away from the scene and there were no injuries. There was no damage done to pole 336/2/1 or pole 78.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3466064
Longitude:
-71.2150674
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);