crash_reports

1 row where keywords contains "Rain" and "retrieved" is on date 2021-07-07

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

2100000487

Date:

2021-07-02

Time:

22:18

Address:

CENTRE ST & FRANKLIN ST

Speed limit:

25

Violation cited:

yes

Narrative:

Operator of MV1 stated they were driving Northbound on Centre St. when they attempted to take a right turn Eastbound onto Franklin St. Operator of MV1 stated MV2 rear ended their vehicle as they were turning. There was minor damage to the left rear of MV1. Operator of MV2 stated they were driving Northbound on Centre St. when they hit the left rear of MV1. MV2 stated the road was slippery from the rain which caused their vehicle to slide on the roadway. There was minor damage to the left rear of MV1 and front right of MV2. There were no injuries and no tows.

Keywords:

Rain

Dcc:

Followed too closely, Inattention

Report url:

report

Image url:

image

Latitude:

42.3522129

Longitude:

-71.1861035

Location:

Franklin St & Centre 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);