crash_reports

1 row where keywords contains "Ice" and "retrieved" is on date 2022-02-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:

22000123

Date:

2022-02-08

Time:

22:26

Address:

MILL ST & MORTON ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling eastbound on Mill St when bearing to the left to continue straight on Mill St. MV1 Operator lost control of the vehicle due to black ice on the road way. MV1 came to a stop in a snowbank at Mill St and Morton St. Todys came and removed the vehicle.

Keywords:

Ice, Snow

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3417317

Longitude:

-71.2009859

Location:

Morton St & Mill St, Newton, MA 02460, 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);