crash_reports

1 row where "datetime" is on date 2020-02-17, dcc = "["Reckless driving"]" and intersection = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2000000164

Date:

2020-02-17

Time:

19:56

Address:

BRIDGE ST & CALIFORNIA ST

Speed limit:

25

Violation cited:

no

Narrative:

Opr of V1 was stopped on Bridge Street waiting for the traffic light to turn green. Opr of V1 observed a black SUV taking a right hand turn off of California Street on to Bridge Street. Opr of V1 stated the unknown SUV took the turn too wide, made contact with his vehicle, and took off towards Watertown, MA. V1 sustained damage to the entire left side. V1 was not towed. Opr of V1 was not injured. I canvassed the area with negative results.

Keywords:

[]

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3651423

Longitude:

-71.2043931

Location:

Bridge St & California 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);