crash_reports
2 rows where keywords contains "Hospital" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-10-22
Time:
07:52
Address:
WASHINGTON ST & WALSINGHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/22/2021, at approx 0752Hrs, while assigned to 497, I responded to 2071 Washington St for a report of a past hit and run with property damage. Upon arrival I observed the tire tracks leading from the right westbound lane leading over the curb , knocking over a chain link fence and post . There were tire ruts into the side yard of 2071 Washington St, an there was a End of Reduced Salt sign and post wedged into the ground of the homeowners side yard. I spoke with the property owner , Ali Shamser who stated at approx midnight he heard a loud bang, and looked out his window , saw nothing in the road but did not think to look down into his side yard. Ali's home is across the street from Newton Wellesley Hospital and next to Route 128 as well as on a very busy road so he is used to hearing crashes and sirens regularly. Ali stated at approx 0745Hrs when he left his home to take his children to school he noticed his damaged fence and yard. Ali has no cameras, across the street is Newton Wellesley Hospital and his neighbor adjacent on Walsingham St has his property surrounded by a 6 foot vinyl fence.
Keywords:
Bus, Crash, Hospital, School
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3304958
Longitude:
-71.2480961
Location:
Case
number:
Date:
2021-11-03
Time:
02:34
Address:
COMMONWEALTH AVE & CROSBY RD
Speed
limit:
35
Violation
cited:
yes
Narrative:
Upon arrival, vehicle 1 was rolled over and facing Eastbound in the Westbound lane. There was extensive damage all over the vehicle and it was leaking fluids. It appears that vehicle 1 was traveling Westbound on Commonwealth Ave and struck a tree and then crashed into the guard rail causing it to roll over. There was damage to a city tree and damage to the guard rail. Operator 1 stated (through translation from Officer Acuna), he was traveling Eastbound on Commonwealth Ave at approximately 25 MPH when he was looking at his GPS and his brakes gave out causing him to crash. When asked again, his story changed and he was not sure what direction he was traveling in. Newton Fire was able to retrieve operator 1's cell phone in the vehicle which was on a loop playing videos on instagram. Operator 1 was transported to Beth Israel Hospital by Fallon Ambulance. Tody's towed vehicle 1 and pictures were taken of the damage to city property and will be submitted to the IT Bureau to be attached to this report. Operator 1 was served in hand, Massachusetts Uniform Citation: T1445611 for the following: Ch. 89 s. 4A - Marked Lanes Violation Ch. 90 s.13B- Electronic Device Use While Operating a Motor Vehicle
Keywords:
Citation, Crash, Ems, Fire, Hospital, Phone, Pictures, Severe, Tree
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3372401
Longitude:
-71.1743446
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);