crash_reports

1 row where dcc contains "Wrong way", "retrieved" is on date 2022-04-27 and street1 = "WEST 197 CALIFORNIA ST"

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

22000321

Date:

2022-04-20

Time:

07:21

Address:

197 CALIFORNIA ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 stated they were travelling w/b on California St when MV2 "was right behind me, crossed the double yellow lines to pass me, nearly went head on with someone else, cut back and hit the front of my car" causing minor damage. MV2 was described as a Silver Infiniti that fled on Bridge St towards Watertown. A canvass of the area was conducted yielding negative results. No tow was required and no injuries were reported.

Keywords:

[]

Dcc:

Wrong way, Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3651092

Longitude:

-71.1963023

Location:

197 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);