crash_reports

1 row where "datetime" is on date 2020-12-05, dcc = "["Unknown"]" and keywords contains "Snow"

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

2000000707

Date:

2020-12-05

Time:

16:00

Address:

658 DEDHAM ST

Speed limit:

30

Violation cited:

no

Narrative:

Vehicle 1 was traveling northbound on Dedham St, and slid off the road due to the snow. Vehicle 1 became lodged in between a fire hydrant, and rock wall in front of 658 Dedham St. There was moderate damage to the left and right front of the vehicle. No one was injured. Todys was able to remove the vehicle, and the operator drove it away from the scene. Pictures were taken of the fire hydrant and owners wall. There did not appear to be damage to the fire hydrant.

Keywords:

Fire, Moderate, Pictures, Snow

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3027133

Longitude:

-71.1905008

Location:

658 Dedham 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);