home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "retrieved" is on date 2022-06-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, 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:
22000418
Date:
2022-05-18
Time:
09:35
Address:
845 WASHINGTON ST
Speed limit:
15
Violation cited:
no
Narrative:
The owner Vehicle #1 stated that he observed fresh damage to the rear of his vehicle. After viewing video he saw that it wa involved in a collision with a vehicle bearing MA Reg. 7MLK30 as it was backing out of a parking space. I was able to contact the operator of Vehicle #2. He stated that as he was backing out of a parking space he sneezed and was not sure if he made contact with Vehicle #1. When he checked the vehicle, he stated that he did not observe any damage. He was informed of Mr. William's claims, and agreed to cooperate.
Keywords:
[]
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.3516966
Longitude:
-71.2078404
Location:
845 Washington St, Newton, MA 02460, USA
Case number:
22000419
Date:
2022-05-18
Time:
11:47
Address:
721 WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
On May 18th, 2022 at approximately 11:47 hours while assigned to N491 I responded to a report of a MV crash in the area of #727 Washington St, Newtonville. On my arrival to the scene there was a MSP trooper on scene that happened to be driving by. Vehicle #1 was a gray 2018 Hyundai Electra, MA plate 3VMR89, operated by Paula R. Lima with heavy damage. Ms Lima stated she was parked facing W/B on Washington St near #721 when she attempted to make a U-Turn to go E/B when she was struck by vehicle #2. Vehicle #2 was a 2016 Jeep Compass, MA. reg 298XH9, operated by a Jevon D. Foster. He stated he was going W/B on Washington St when vehicle #1 pulled out in front of him from a parked position causing him to crash into her vehicle. Both vehicles were towed by Todys and there were no reported injuries.
Keywords:
Crash
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3527483
Longitude:
-71.2031248
Location:
721 Washington St, Newton, MA 02458, USA
Case number:
22000466
Date:
2022-05-30
Time:
20:40
Address:
1201 WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
On Monday, May 30, 2022, at approximately 2240hrs, I responded to 1201 Walnut St. for a report of a hit and run. Upon arrival I met with the Operator of MV1 who stated her vehicle was parked, facing Southbound in front of 1201 Walnut St. for the past hour while she was eating dinner at O'Hara's Pub. Operator stated that when returning to her vehicle she discovered that her drivers side mirror had been struck by an unknown vehicle, sustaining minor damage. Prior to clearing I informed the operator that a report would be generated in regards to the incident. Upon clearing I checked the area for cameras that could of captured the incident, yielding negative results.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3207123
Longitude:
-71.2055244
Location:
1201 Walnut St, Newton, MA 02461, 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 1500.878ms