crash_reports

1 row where keywords contains "Ice" and "retrieved" is on date 2021-03-11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2100000120

Date:

2021-02-15

Time:

20:39

Address:

MANDALAY RD & WOODCHESTER DR

Speed limit:

25

Violation cited:

no

Narrative:

MV#1 was traveling north on Woodchester Rd, attempting to make a left turn onto the west bound side of Mandalay Rd. Due to freezing conditions and light rain, both of these roads were covered in a layer of ice. When MV#1 attempted to make the left turn, the vehicle slipped around the corner and struck a fire hydrant at the corner of above mentioned roads. City of Newton water department was called out to inspect the hydrant, and N522 arrived on scene and took pictures. Passenger in MV#1 was transported to NWH for possible neck injury. MV#1 was driven off scene by operator.

Keywords:

Fire, Ice, Pictures, Rain

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.339096

Longitude:

-71.17788

Location:

Mandalay Rd & Woodchester Dr, Newton, MA 02467, 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);