crash_reports

1 row where intersection = 0, keywords contains "Glare" and "retrieved" is on date 2021-01-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:

2100000041

Date:

2021-01-25

Time:

07:30

Address:

297 DERBY ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 stated he was sitting in his parked vehicle when MV2 struck the rear driver side of his vehicle. Operator of MV2 stated she was traveling eastbound on Derby St. when she struck the rear of MV1 with the passenger side of her vehicle. Operator of MV2 stated the glare from the sun played a part in the accident. All operators refused medical treatment. MV1 sustained major damage to the rear, driver side bumper. MV2 sustained major damage to the front passenger side bumper. Operator of MV2 stated she will call for a private tow, MV2 was operable and moved to a legal parking spot. MV1 was parked legally on Derby Street.

Keywords:

Crash, Glare, Solar

Dcc:

Glare, Inattention

Report url:

report

Image url:

image

Latitude:

42.3607095

Longitude:

-71.2358895

Location:

297 Derby St, Waltham, MA 02453, 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);