crash_reports

1 row where "datetime" is on date 2019-01-25 and keywords contains "Ice"

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

1900000111

Date:

2019-01-25

Time:

13:42

Address:

43 GATE HOUSE RD

Speed limit:

10

Violation cited:

no

Narrative:

Operator 1 states she pulled into the driveway of 43 Gatehouse Rd. while pulling in her vehicle slid on a sheet of ice and slid into the garage. Tody's towing was called to remove the car from the garage. The vehicle and garage sustained minor damage and there were no injuries.

Keywords:

Ice

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3324596

Longitude:

-71.1643234

Location:

43 Gate House Rd, Chestnut Hill, 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);