crash_reports

1 row where dcc contains "Visibility obstructed" and latitude = "42.3204602"

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

1900000662

Date:

2019-06-26

Time:

21:46

Address:

CENTRE ST & WALNUT ST

Speed limit:

30

Violation cited:

no

Narrative:

Operator 1 stated he was responding to an emergency call with lights and sirens heading northbound on Center Street. He stopped at the intersection at a red light before proceeding through. He stated he checked both directions and then proceeded ahead and struck the side of vehicle 2. He stated that he did not see vehicle 2. Operator 2 stated that he was heading northbound on Walnut street and had a green light. He stated that he proceeded through the intersection and did not see vehicle 1 and was struck on the drivers side. Photos taken by Officer Brooks of both vehicles

Keywords:

Pictures

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3204602

Longitude:

-71.2050785

Location:

Centre St & Walnut St, Newton, MA 02461, 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);