crash_reports

1 row where "datetime" is on date 2020-07-17 and dcc contains "Reckless driving"

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

2000000389

Date:

2020-07-17

Time:

17:14

Address:

CENTRE ST & WASHINGTON ST

Speed limit:

30

Violation cited:

yes

Narrative:

MV 1 stated she was stopped at a red light when she was rear ended by MV 2 who fled the scene (no visible damage). MV 2 stated he did not get into an accident, and appeared to be confused about what we were talking about (no visible damage). Two witnesses confirmed MV 1's account of the incident. MV 2 was cited for unlicensed operation and leaving the scene of property damage. See incident report #20034517.

Keywords:

Citation, Crash

Dcc:

Reckless driving, Inattention

Report url:

report

Image url:

image

Latitude:

42.3557988

Longitude:

-71.1865324

Location:

Centre St & Washington 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);