crash_reports

1 row where date = "2019-03-12" and dcc contains "Lane departure"

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

1900000276

Date:

2019-03-12

Time:

15:24

Address:

1241 CENTRE ST

Speed limit:

30

Violation cited:

yes

Narrative:

Operator 1 was attempting to parallel park in a parking space in front of 1241 Centre St when she was sideswiped by MV2 who was attempting to pass her. No injuries reported. MV1 sustained minor rear drivers side damage. MV2 fled the scene prior to my arrival. NPD located the vehicle at the owners residence which had matching damage and paint transfer on the front passenger side. Multiple attempts were made to contact the owner with negative results, he will be mailed Mass Uniform Citation #T1440739 for leaving the scene ( property damage) and marked lane violation.

Keywords:

Citation

Dcc:

Lane departure, Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3307248

Longitude:

-71.1948758

Location:

1241 Centre 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);