crash_reports

1 row where date = "2019-11-05" and keywords contains "Rain"

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

1900001144

Date:

2019-11-05

Time:

12:56

Address:

CENTRE ST & CYPRESS ST

Speed limit:

35

Violation cited:

no

Narrative:

Operator 1 stated he was stopped in traffic Southbound on Centre St at Cypress St. While operator 1 was stopped he was struck from behind by vehicle 2. Operator 2 stated he was traveling Southbound on Centre St when the vehicle in front of him stopped suddenly. Due to the rain and slick roadway he was unable to stop in time, striking vehicle 1 from behind. Vehicle 1 sustained minor damage, and vehicle 2 sustained moderate damage and was towed by Tody's. There were no injuries.

Keywords:

Moderate, Rain

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.329368

Longitude:

-71.1950954

Location:

Centre St & Cypress St, Newton, MA 02459, 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);