home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where intersection = 0, keywords contains "Fire" and "retrieved" is on date 2021-03-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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:
2100000164
Date:
2021-03-07
Time:
13:39
Address:
35 CHERRY ST
Speed limit:
25
Violation cited:
yes
Narrative:
The operator of MV#1 stated that he was traveling north on Cherry St when he struck the fire hydrant in front of #35 Cherry St. Upon further questioning, the operator Johnathon Benson stated that he has been diagnosed with a medical condition that sometimes affects his coordination. I asked if he should be driving due to his medical condition and he stated his doctor has suggested he not drive. I then asked if he thought it was his medical condition or another factor which caused the crash. Mr. Benson stated he believes his medical condition is likely what caused the crash. When Mr. Benson exited his MV I noticed a large wet spot on both the front and rear of his pants around the groin/buttocks area. I then asked Mr. Benson if he has had siezures in the past, to which he stated he has. I then asked Mr. Benson if its possible that he may have had a seizure while driving today and he stated it was. Mr. Benson did not sustain any injuries, his MV was towed by Tody's and the Newton Fire Dept. was notified. At this time due to the information Mr. Benson provided and my concern about his/others safety while he operates a MV, I am filing an Immediate Threat with the RMV. On 3/8/21 I mailed citation #T2080897 to Johnathon Benson for operating Tx. Reg. HVY7642, which was unregistered at the time of the crash.
Keywords:
Citation, Crash, Fire
Dcc:
Physical impairment
Report url:
report
Image url:
image
Latitude:
42.3630486
Longitude:
-71.2268864
Location:
35 Cherry St, West Newton, MA 02465, USA
Case number:
2100000173
Date:
2021-03-11
Time:
14:36
Address:
1073 CENTRE STREET
Speed limit:
30
Violation cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that she was traveling Southbound on Centre and slowed down and pulled to side of the road when she saw a City Of Newton Fire Truck with the lights and sirens activated traveling Northbound on Centre Street (The opposite direction). Operator of Motor Vehicle #1 stated that she was then struck by motor vehicle #2 from behind. Operator of Motor Vehicle #2 stated that he was traveling Southbound on Centre Street and saw the City Of Newton Fire Truck traveling Northbound on Centre Street (The opposite direction) in the center lane with its lights and sirens activated however did not realize that the vehicle in front of him was going to stop and struck vehicle #1 from behind. Motor vehicle #1 sustained moderate rear end damage and motor vehicle # 2 sustained major front end damage. Both parties were evaluated by medics and signed medical refusals forms. Motor Vehicle # 2 was towed from the scene by Tody's Towing.
Keywords:
Fire, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.335569
Longitude:
-71.1937159
Location:
1073 Centre St, Newton, MA 02459, 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 312.464ms