crash_reports

1 row where dcc = "["Too fast for conditions", "Swerving"]" 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:

2100000122

Date:

2021-02-16

Time:

01:19

Address:

135 WARWICK RD

Speed limit:

20

Violation cited:

no

Narrative:

The operator of Vehicle #1 stated that as he was travelling Northbound on Warwick Rd he lost control of his vehicle in the ice and collided with the tree. The vehicle sustained front end damage. The operator declined medical attention when it was offered.

Keywords:

Ice, Tree

Dcc:

Too fast for conditions, Swerving

Report url:

report

Image url:

image

Latitude:

42.3559213

Longitude:

-71.2171338

Location:

135 Warwick Rd, 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);