crash_reports

1 row where dcc = "["Physical impairment"]" and speed_limit = 10

✎ 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

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);