home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "date" is on date 2022-05-20 and "retrieved" is on date 2022-05-25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, hit_run, 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:
22000425
Date:
2022-05-20
Time:
03:32
Address:
275 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 stated she was turning right when her vehicle jumped the curb, hit a light pole, and then struck a support column to 275 Washington St. Operator was evaluated by Fallon & signed a patient refusal. NFD reported no structural damage to the column. MV1 was removed from the scene by Tody's Towing & photos of the scene were forwarded to the IT Bureau. Both the DPW & One Newton Place were notified of the damage to the building & light pole.
Keywords:
Fire, Pictures
Dcc:
Speeding, Inattention
Report url:
report
Image url:
image
Latitude:
42.3581264
Longitude:
-71.185233
Location:
275 Washington St, Newton, MA 02458, USA
Case number:
22000426
Date:
2022-05-20
Time:
08:41
Address:
15 PINE ST
Speed limit:
25
Violation cited:
no
Narrative:
On 05/20/2022 at 0841 I responded to 15 Pine St. for a MVA Hit&Run. An unknown vehicle damage a mirror of a parked vehicle. On scene at 15 Pine st. MA Reg 8TF318; 2019 NISS/ARMADA UTIL. color white, was parked unoccupied at the time of the collision. The vehicle was legally parked on Pine St (public Way) in front of #15 Pine st. The vehicle owner was identified as Morgan, James MA OLN#S73936038. Mr Morgan has video from his Ring doorbell of a possible suspect vehicle. I observed the video which shows a dark blue SUV. The video doesn't have the correct angle showing the impact but the audio distinctly can be heard, an impact with a clear cracking sound as the unknown vehicle passes. A license could not be observed due to the camera angle. The parked vehicle sustained damage to the mirror only. there was no visible damage to the body of the vehicle.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3549334
Longitude:
-71.2357668
Location:
15 Pine St, Newton, MA 02465, USA
Case number:
22000430
Date:
2022-05-20
Time:
20:19
Address:
ELM RD & WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 said he was stopped at the red light and when the light turned green he took his foot off the brake and hit the accelerator. Operator of MV1 said the vehicle in front of him hit it's brake's and he hit the accelerator instead of the brake and struck MV2. Operator of MV2 said he was stopped at the red light and when the light turned green he was struck from behind by MV1 which caused him to strike MV3. Operator of MV3 said he was stopped at the red light and when the light turned green he was struck from behind by MV2. Fallon Medics and Newton Fire responded and evaluated all parties involved. Both occupants inside of MV2 stated they had neck pains but signed a patient refusal. All vehicles were able to drive away from the scene. There was damage done to the front bumper of MV1. There was damage done to the rear bumper, rear driver taillight, and front bumper of MV2. There was damage done to the rear of MV3.
Keywords:
Fire
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3472639
Longitude:
-71.2065995
Location:
Walnut St & Elm Rd, Newton, MA 02460, 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 317.893ms