crash_reports

1 row where date = "2019-12-17" and keywords contains "Pictures"

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

1900001299

Date:

2019-12-17

Time:

13:58

Address:

OLDE FIELD RD & BOYLSTON ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1(MA reg.8TX383) was traveling eastbound on Boylston Street when she attempted to turn right onto Olde Field Road. MV1 began to slide due to the heavy slush from rain and snow fall. MV1 struck the stop sign on the east side corner. The street sign was knocked over and MV1 had minor damage to the front drivers side bumper No one was injured, damage was minimal and dispatch notified DPW of the damage to the stop sign. Photos were not taken.

Keywords:

Pictures, Rain, Snow

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3188446

Longitude:

-71.192125

Location:

Olde Field Rd & Boylston 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);