crash_reports

1 row where "datetime" is on date 2019-02-02 and keywords contains "Ice"

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

1900000135

Date:

2019-02-02

Time:

00:14

Address:

PLEASANT ST & TYLER TER

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV#1 stated that she was driving west on Tyler Ter, approaching Pleasant St. Operator stated that she lost control of the vehicle when she hit a patch of ice. Operator stated that she then went across Pleasant St and struck the sidewalk, and came to rest in the driveway of 126 Pleasant St. Airbags deployed, medics were called to the scene, and all parties cleared with a patient refusal. MV#1 was towed by Todys.

Keywords:

Airbag, Ice

Dcc:

Swerving

Report url:

report

Image url:

image

Latitude:

42.331723

Longitude:

-71.199404

Location:

Tyler Terrace & Pleasant 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);