crash_reports

1 row where "datetime" is on date 2019-05-07, dcc contains "Followed too closely" and intersection = 0

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

1900000468

Date:

2019-05-07

Time:

17:03

Address:

580 WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

Vehicle one was stopped in traffic when vehicle two rear ended vehicle one. Vehicle two stated she looked down at the radio quick and then rear ended vehicle one. vehicle one was transporting two male parties while working for LYFT. Both male parties of vehicle one were transported to Newton Wellesley Hospital.

Keywords:

Hospital

Dcc:

Followed too closely, Inattention

Report url:

report

Image url:

image

Latitude:

42.3542305

Longitude:

-71.1975358

Location:

580 Washington St, Newton, MA 02458, 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);