crash_reports

1 row where "date" is on date 2019-03-10, intersection = 0 and keywords contains "Ems"

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

1900000260

Date:

2019-03-10

Time:

11:53

Address:

304 LOWELL AVE

Speed limit:

30

Violation cited:

no

Narrative:

Page Davis states that she pulled over to the side of the road on Lowell Ave for an oncoming ambulance. Davis states that she looked in her mirror to enter the traffic lane. Davis saw vehicle #1 a distance back. Davis then went to enter the traffic lane and she was struck in the left rear by vehicle #1. Hanbo Lin was operating vehicle #1. Lin states that he saw vehicle #2 attempt to merge into traffic. Lin went to step on the brake and his vehicle slid into Davis due to the weather/road conditions. No injuries.

Keywords:

Ems

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3468164

Longitude:

-71.2106433

Location:

304 Lowell Ave, Newton, MA 02460, 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);