crash_reports

1 row where dcc contains "Visibility obstructed" and "retrieved" is on date 2021-10-28

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

2100000854

Date:

2021-10-22

Time:

16:14

Address:

LOWELL AVE & WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 stated she had a green light when MV2 "ran the red light" subsequently striking MV1 causing front end damage. MV2 stated he was "coming over the hill and the sun made the light look green" subsequently striking MV1 causing minor damage. No tows were required & no injuries were reported.

Keywords:

Solar

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3510472

Longitude:

-71.2106128

Location:

Lowell Ave & Washington St, Newton, MA 02460, 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);