crash_reports
3 rows where intersection = 0 and "retrieved" is on date 2021-03-15
This data as json, CSV (advanced)
Suggested facets: date, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-09
Time:
08:51
Address:
269 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On March 9th, 2021 at approximately 08:51 hours while working N491 I responded to the area of #265 Watertown St for a report of a MV crash with possible entrapment. On my arrival I located a black Chev Suburban MA reg 6hy959 crashed into a tree in front of #269 Watertown St The operator, later identified as Rachel Franchi, dob 05/10/1981 was still inside the vehicle. She was bleeding from her forehead. I attempted to talk with her but she appeared dazed and confused. I spoke with a witness, identified as Sarah Plesh. She reported traveling W/B on Watertown St when she observed the Black Suburban who had been coming E/B suddenly veer off the road and crash into a tree. Witness stopped her vehicle and exited to check on the condition of the driver. She observed the operator whom she thought to be having a medical emergency. Witness then noticed a small child in the back seat. The car doors were all locked but witness was able to get the child to unlock the doors. Witness then removed the child from the car and held him to police arrived on scene. Operator had to be coaxed out of her vehicle with the assistance of medical personnel. She was later transported to Newton Wellesley by Fallon Ambulance. Tody towed the vehicle. Pictures of the damaged city tree were taken by SGT Fleming and later emailed to the IT bureau. Father of child, Robert Franchi arrived on scene and took custody of the child,Julian, dob12/12/2015. He didn't appear to have suffered any injuries from this crash.
Keywords:
Crash, Ems, Pictures, Tree
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3614824
Longitude:
-71.1975905
Location:
Case
number:
Date:
2021-03-09
Time:
14:13
Address:
153 BROOKLINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was stopped/slowed in traffic facing northbound, with its left turn signal activated as if it was taking a left onto Ballpate Hill Rd., when motor vehicle 2 (MV2), which was also traveling northbound, attempted to pass on the right. As MV2 was about to pass MV1, MV1 made a right hand turn towards the driveway of 153 Brookline St. As a result, MV2 crashed into the passengers side of MV1. MV1 sustained moderated passengers side damage, while MV2 sustained moderate front end damage.
Keywords:
Crash, Moderate
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3048505
Longitude:
-71.175046
Location:
Case
number:
Date:
2021-03-12
Time:
15:46
Address:
1321 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator 1 was backing into a parking space behind 1321 Washington St when she struck unoccupied cruiser 492. Minor damage to the rear drivers quarter panel of N492. Minor damage to the rear passenger quarter panel of N526. No injuries reported, both vehicles were able to be driven from the scene.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
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);