crash_reports
4 rows where "datetime" is on date 2019-10-27, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-27
Time:
00:00
Address:
10 OAKWOOD RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV 1 was backing out of the driveway of 11 Oakwood Road and crashed into MV 2 which was parked across the street. There were no injuries to the operator of MV 1, MV 2 was a parked car with no operator. The damage sustaiined to MV 2 was the drivers side door. The damage sustained to MV 1 was the back bumper.
Keywords:
Crash
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.34364
Longitude:
-71.2038442
Location:
Case
number:
Date:
2019-10-27
Time:
13:04
Address:
277 CRAFTS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
OPERATOR OF MV 1 WAS TRAVELING WEST ON CRAFTS STREET WHEN HE STATED HE LOST CONTROL OF HIS VEHICLE WHICH STRUCK MV2 IN THE REAR CAUSING SIGNIFICANT DAMAGE TO THE VEHICLE. DUE TO THE IMPACT, MV 2 WAS PUSHED INTO MV 3 CAUSING MODERATE DAMAGE TO THE REAR OF MV 3. BOTH MV'S 2 AND 3 WERE LEGALLY PARKED AND UNOCCUPIED AT THE TIME OF THE ACCIDENT. WE WERE ABLE TO NOTIFY BOTH OWNERS OF THE PARKED VEHICLES WHO WERE INSIDE F.A. DAY ATTENDING THE CHINESE LANGUAGE SCHOOL. MV1 AND MV 2 WERE TOWED FROM THE SCENE BY TODYS. OPERATOR OF MV 1 WAS ISSUED IN HAND MA UNIFORM CITATION T2079841 FOR 89/4A MARKED LANES.
Keywords:
Citation, Crash, Moderate, School
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3586048
Longitude:
-71.2106201
Location:
Case
number:
Date:
2019-10-27
Time:
18:15
Address:
854 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
I was dispatched to 854 Beacon St, Newton, MA for an overturned motor vehicle accident. I arrived on scene and saw Vehicle #1 (MA reg 9AS213) overturned on its driver's side with the female operator/registered owner trapped inside. Newton Fire arrived on scene and mechanically removed the operator out of the motor vehicle. Prior to where Vehicle #1 was overturned I observed Vehicle #2 (MA reg 615FF6) with rear bumper damage and a snapped rear axle. Vehicle #2 was unoccupied. Operator of Vehicle #1 was transported to Newton-Wellesley Hospital for treatment by Newton Medics. Both motor vehicles were towed by Tody's and inventory sheets were completed and filed. I spoke with the Operator of Vehicle #1 at Newton-Wellesley Hospital. Operator stated that she does not remember what happened before the crash and that she only remembers waking up in her car. I told her that her car was towed and a report is on file. Ofc Selig spoke with the registered owner of Vehicle #2 and notified her of the incident. Based on my investigation it appears that Vehicle #1 struck the rear of Vehicle #2 and the operator over steered causing the vehicle to overturn onto the driver's side.
Keywords:
Crash, Fire, Hospital
Dcc:
Over-steering, Inattention
Report
url:
Image
url:
Latitude:
42.330261
Longitude:
-71.1965808
Location:
Case
number:
Date:
2019-10-27
Time:
19:49
Address:
181 LEXINGTON ST
Speed
limit:
20
Violation
cited:
no
Narrative:
Vehicle 1 owner stated that he parked the car in his designated parking spot in the back of 181 Lexington St apartments. He returned home from work around 430pm with no damage on his vehicle. At approximately 1930hrs he went out to take the trash and noticed his vehicle had damage. No note was left with no information on other vehicle. Checked the area with negative results of other vehicles with damage.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3551907
Longitude:
-71.2433377
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);