crash_reports

1 row where "datetime" is on date 2021-08-15, 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:

2100000608

Date:

2021-08-15

Time:

19:21

Address:

187 SARGENT ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV1 stated she was traveling Westbound on Sargent St. when the glare of the sun temporarily blinded her. As a result, she struck MV2, which was parked unoccupied on the side of the road in front of 187 Sargent St. The operator was evaluated on scene by the medics and signed a patient refusal. MV1 sustained moderate front end damage and was towed from the scene by Tody's. MV2 sustained moderate rear bumper damage and was able to safetly park in the driveway.

Keywords:

Glare, Moderate, Solar

Dcc:

Glare

Report url:

report

Image url:

image

Latitude:

42.3470724

Longitude:

-71.188157

Location:

187 Sargent 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);