crash_reports

1 row where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2021-09-17

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

2100000683

Date:

2021-09-09

Time:

14:56

Address:

976 CENTRE ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling southbound on Centre St in traffic near the intersection of Centre St @ Ward St. MV2 was also traveling southbound on Centre St. MV2 operator stated due to the road way conditions of rain, her tires did not catch the roadway and when she applied the breaks her tires slipped due to the rain. MV2 attempted to stop but was not able to and rear ended MV1.

Keywords:

Rain

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3388534

Longitude:

-71.1925894

Location:

976 Centre St, Newton Centre, MA 02459, 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);