home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Unknown"]", intersection = 0 and "retrieved" is on date 2021-11-29

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
2100000963
Date:
2021-11-20
Time:
19:41
Address:
3 BORDER ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was unoccupied and parked facing westbound on Border St. The owner of MV1 came out and noticed damage on the left rear of the vehicle. It appears as if an unknown MV struck the vehicle then left the area.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3493025
Longitude:
-71.2297173
Location:
3 Border St, Newton, MA 02465, USA
Case number:
2100000974
Date:
2021-11-22
Time:
16:39
Address:
WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 stated she was in the right lane on Washington St going around the rotary heading towards Centre St when the vehicle to her left tried to merge in her lane and struck the left side of her vehicle. The collision forced MV1 to strike the curb of the island on her right side and also damage the rims on the passenger side. Operator of MV1 then stopped at the red light and got out of the vehicle and the operator of MV2 told her she would pull over. Operator of MV2 began driving on Centre St and operator of MV1 believed she was not going to pull over so she called the police and left the scene. Operator of MV2 was able to meet myself and operator of MV1 at Dunking Donuts located at 343 Washington St. Operator of MV2 stated she was in the left lane when MV1 tried to merge into her lane. MV1 struck her vehicle and operator of MV2 believed MV1 was going to follow her to a safe location to exchange paper work. Operator of MV2 states she pulled off onto a side street and MV1 continued to drive straight. Operator of MV2 was not going to call the police and was going to just contact her insurance company. No parties needed medical attention. Neither vehicle required a tow.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3498391
Longitude:
-71.2179998
Location:
Washington St, Newton, MA, USA
Case number:
2100000978
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:
report
Image url:
image
Latitude:
42.3585652
Longitude:
-71.1862132
Location:
25 Pearl St, Newton, MA 02458, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 290.186ms