crash_reports
1 row where "datetime" is on date 2021-11-23, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-23
Time:
14:08
Address:
25 PEARL ST
Speed
limit:
20
Violation
cited:
no
Narrative:
On November 23rd, 2021 at approximately 14:08 hours while working N491 I responded to #25 Pearl St for a report of a MV crash with airbag deployment. On my arrival I located the involved vehicle a 2021 black Cadillac, Ma reg. K9195 with extensive damage on the property of a four unit condominium complex that abuts #275 Centre St(Plaza). The operator who was standing outside her vehicle was identified as Margaret Cloherty. She appeared uninjured from this crash. She reported the following: She first entered the parking lot to #275 Centre St which has several different businesses. As she drove through the parking lot her vehicle suddenly began to accelerate. She attempted to brake but her vehicle continued straight through the parking lot continuing to accelerate before finally crashing through a wooden fence and onto the property to #21 to #27 Pearl ST. Ms Cloherty was evaluated by the Medics but refused to by transported to the hospital. She signed a patient refusal form. Her vehicle which appeared to be totaled was towed from the scene by Todys. The property owner of the fence was identified as Steve Knapp 508-958-1906 was contacted by police. He will be provided a copy of this report of his insurance.
Keywords:
Airbag, Bus, Crash, Hospital, Severe
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3585652
Longitude:
-71.1862132
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);