crash_reports

1 row where keywords contains "Ped" and "retrieved" is on date 2021-05-07

✎ 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:

2100000298

Date:

2021-04-30

Time:

15:41

Address:

ELM ST & WEBSTER ST

Speed limit:

25

Violation cited:

no

Narrative:

Vehicle 1 was taking a left hand turn onto Elm St, from Webster St. The operator of vehicle 1 stated that the sun was in his eyes, and he could not see well. He decided to take the turn very slow. Vehicle 1 struck a pedestrian, who was already out in the crosswalk with the front of his vehicle. The pedestrian was complaining about pain in her left leg. She was evaluated by Medic 2, and transported to NWH. I observed no damage to vehicle 1.

Keywords:

Crosswalk, Ped, Solar

Dcc:

Glare

Report url:

report

Image url:

image

Latitude:

42.34987

Longitude:

-71.229876

Location:

Elm St & Webster St, Newton, MA 02465, 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);