crash_reports

1 row where address = "40 PARK ST" and date = "2019-12-20"

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

1900001322

Date:

2019-12-20

Time:

23:33

Address:

40 PARK ST

Speed limit:

30

Violation cited:

yes

Narrative:

MV 1 was traveling Northbound on Park St when she drove off the road and crashed into a telephone pole at 40 Park St. Park St is a public way in Newton. There was major damage to the front center, front left, and front right of MV 1. Powerlines covered the vehicle and entrapped the operator. The operator of MV was arrested for OUI (see incident report 19055618) Tody's towed the vehicle.

Keywords:

Crash

Dcc:

Lane departure, Other improper action

Report url:

report

Image url:

image

Latitude:

42.3554507

Longitude:

-71.1819377

Location:

40 Park St, Newton, MA 02458, 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);