crash_reports
5 rows where "datetime" is on date 2019-03-02 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-02
Time:
03:31
Address:
194 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV#1 stated while traveling westbound on Commonwealth Ave he closed his eyes for a few moments causing his vehicle to veer to the right. MV#1 drove up on the curb and struck a overhanging street light. MV#1 sustained heavy front end damage as well as uprooting the overhanging street light. Operator of MV#1 stated he had minor injuries and signed a patient refusal. Operator of MV#1 was given the following roadside tests, due to the time and circumstances of the incident. Horizontal Gaze Nystagmus - Pass One Leg Stand - Pass Walk And Turn - Pass Operator of MV#1 showed no signs of impairment. Through my training and experience I calculated MV#1 had speeds of approximately +50MPH. Tody's towed the MV, a towed MV inventory form was completed. Pictures taken on scene submitted to IT.
Keywords:
Impairment, Pictures, Speed, Walk
Dcc:
Speeding, Lane departure
Report
url:
Image
url:
Latitude:
42.3369434
Longitude:
-71.1738848
Location:
Case
number:
Date:
2019-03-02
Time:
08:38
Address:
272 WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 stated that she was traveling east on Webster St when her MV began to swerve in the snow and she couldn't control it. MV#1 then struck the curb and a telephone pole. MV towed by Tody's.
Keywords:
Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3487717
Longitude:
-71.2386722
Location:
Case
number:
Date:
2019-03-02
Time:
09:47
Address:
885 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
OPER OF MV#1 STATED THAT HE WAS TRAVELLING SB ON CENTRE ST (#855), WHEN HIS VEHICLE LOST TRACTION ON THE SNOW COVERED ROAD, AND SPUN OUT STRIKING A TREE. MV#1 SUSTAINED HEAVY FRONT END DAMAGE WITH AIR BAG DEPLOYMENT, AND WAS TOWED FROM THE SCENE. OPER OF MV#1 WAS ISSUED MA CITATION T1440992 FOR OPERATING AN UNREGISTERED VEHICLE ON A PUBLIC WAY.
Keywords:
Citation, Snow, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3433232
Longitude:
-71.1938657
Location:
Case
number:
Date:
2019-03-02
Time:
10:34
Address:
99 FLORENCE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was travelling northbound on Florence St when he was struck from behind by MV#2. MV#1 sustained moderate damages to its rear end. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated he was travelling southbound on Florence St and could not stop in time (due to the snowy road conditions) and struck MV#1. MV#2 sustained minor front end damages. There were no reported injuries to the operator of MV#2.
Keywords:
Moderate, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3178158
Longitude:
-71.1775763
Location:
Case
number:
Date:
2019-03-02
Time:
23:59
Address:
5 WEST ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On March 3rd, 2019, while assigned to N491 I, Ofc Stake was dispatched to the West Street Tavern parking lot for a report of a past Hit & Run. Upon my arrival I met with the reporting party Roman Vassilenko. Vassilenko stated that he witnessed a red truck back into the front driver side bumper of his vehicle (Ma Reg 5LZ216) and exit the parking lot, no known direction of travel was provided. Vassilenko's vehicle was parked in the rear parking lot, facing eastbound. I canvassed the area with negative results. I provided Vassilenko with a report number and advised him to contact his insurance company. There was minor damage to the driver side bumper and minor scratches on the bumper and driver side mirror. I observed red paint on the bumper and mirror as well. The owner of West Street Tavern, Karl Roche spoke with Vassilenko and stated he will contact Vassilenko if there is any information he can provide.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3602744
Longitude:
-71.2010893
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);