crash_reports

1 row where "datetime" is on date 2021-12-13, intersection = 0 and keywords contains "Glare"

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

2100001046

Date:

2021-12-13

Time:

15:51

Address:

141 LINWOOD AVE

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV1 stated she turned left from Adams St. onto Linwood Ave (SW). She was temporarily blinded by the glare from the sun, and as a result struck MV2, parked on the side of the road at 141 Linwood Ave. She reported no injuries. MV2 sustained minor damage to the drivers side rear end. MV1 sustained moderate damage to the front bumper and was towed from the scene by Todys.

Keywords:

Glare, Moderate, Solar

Dcc:

Glare

Report url:

report

Image url:

image

Latitude:

42.3621152

Longitude:

-71.2055846

Location:

141 Linwood Ave, 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);