home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Emotional" and keywords contains "Citation"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date), retrieved (date), keywords (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000425
Date:
2019-04-26
Time:
22:32
Address:
BEACON ST & WALNUT ST
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of MV1 states she was driving westbound on Beacon St. She states she was driving through a green light at Walnut St, when her vehicle was struck on the passenger side by MV2. MV2 was traveling southbound and went through a red light prior to colliding with MV1. Operator of MV2 stated she was "at fault". She was issued in hand MA citation #T1444149 for 89/9, Fail to Stop, Yield. Both vehicles were towed by Todys. Initially both parties refused medical attention. After the accident was cleared, Operator of MV2 admitted the accident was a suicide attempt. She was transported to NWH voluntarily by Cataldo EMS.
Keywords:
Citation, Crash, Ems
Dcc:
Signs/Signals, Emotional
Report url:
report
Image url:
image
Latitude:
42.3308369
Longitude:
-71.2070206
Location:
Beacon St & Walnut St, Newton, MA 02461, USA
Case number:
22000402
Date:
2022-05-15
Time:
03:23
Address:
CENTRE ST & SARGENT ST
Speed limit:
30
Violation cited:
yes
Narrative:
-MV#1 was traveling north when OpMv#1 drove off the roadway and onto the exterior wall of 717 Centre Street. OpMv#1 then left the scene. -Wit#1 stated he heard the crash, he came outside his house and he discovered Mv#1 on the wall surrounding the property. He next stated that OpMv#1 told him that he fell asleep behind the wheel. He stated the OpMv#1 called someone to make arrangements to be picked up. He stated a few minutes later he observed OpMv#1 get into an SUV, leaving the scene and the vehicle mounted on the wall without leaving any information. -OpMv#1 came to the station later that morning and stated he was in an argument with his girlfriend and went for a drive. He stated he had worked all day, fell asleep behind the wheel, got scared, so, he left the scene of the collision and the vehicle behind. -Upon my arrival on the scene I observed Mv#1 off the roadway, over the sidewalk and mounted on the property wall outside of 717 Centre Street. I conducted an inspection of the vehicle and I observed the vehicle was unlocked, there were no passengers in the vehicle, the registration was on the passenger seat and I did not observe any damage to the ignition which may indicate to the car being stolen. After the vehicle was removed by Tody's Towing, I observed the stones on the wall had been shifted and many stone broken off from the cement. I took pictures of the damages to both Mv#1 and the adjacent property. -Mv#1 was towed from the scene by Tody's and OpMv#1 was cited and will be summonsed to court for Leaving the Scene of Property Damage.
Keywords:
Citation, Crash, Pictures
Dcc:
Emotional
Report url:
report
Image url:
image
Latitude:
42.3470298
Longitude:
-71.1891713
Location:
Sargent St & Centre 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 1482.206ms