home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Physical impairment" and keywords contains "Ped"

✎ 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:
1900000277
Date:
2019-03-12
Time:
15:49
Address:
2014 WASHINGTON ST
Speed limit:
10
Violation cited:
no
Narrative:
The OP. of MV#1 states she has been having issues with controlling her right leg recently and went to Newton-Wellesley Hospital today to precisely see her doctor about it. As she was pulling up to stop for the Valet, her leg hit the gas pedal instead of the brakes. She steered around pedestrians, went up on the curb, through a frozen snow mound before managing to stop on a roadway towards the other hospital buildings. The OP. of MV#1 understands that she shouldn't be driving for the time being. Immediate Threat Form was faxed to the Driver Control Unit.
Keywords:
Hospital, Ped, Snow
Dcc:
Physical impairment
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, USA
Case number:
2000000276
Date:
2020-04-24
Time:
18:38
Address:
37 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
yes
Narrative:
On Friday 04/24/2020 at approx 1838hrs, while assigned to N-494, I responded to 37 Comm Ave in Newton for MVA involving a pedestrian. Upon arrival, I observed MV1 facing the wrong way in the Comm Ave carriage lane. The pedestrian, Mark Logue, stated he was jogging EB on Comm Ave(carriage lane) on the right side when MV1 hit him from behind. He stated that he fell on his hands and injured his right elbow. Logue also stated that his cell phone screen was cracked due to hitting the pavement. Both parties refused medical treatment. Pictures were taken of injuries and submitted to IT. Operator of MV1 was cited for OUI liquor, neg operation of a MV and wrong way. See incident report #20019822
Keywords:
Citation, Ped, Phone, Pictures
Dcc:
Physical impairment
Report url:
report
Image url:
image
Latitude:
42.3399057
Longitude:
-71.1682955
Location:
37 Commonwealth Avenue, Chestnut Hill, MA 02467, 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 533.123ms