crash_reports

1 row where "datetime" is on date 2019-02-21, dcc contains "Followed too closely" and intersection = 0

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

1900000208

Date:

2019-02-21

Time:

18:43

Address:

808 BEACON ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV1 was traveling Eastbound on Beacon St. when she stopped at a crosswalk for a pedestrian to cross and was struck in the rear by MV2. The operator of MV2 was traveling Eastbound on Beacon St. when MV1 came to a stop and she struck MV1 in the rear. She stated she didn't have enough time to react but pressed her brakes down all the way until they locked up and she ultimately struck the vehicle. All parties reported no injuries. MV1 sustained minor damage and was able to be driven away from the scene safely. MV2 sustained moderate/heavy front end damage and was towed from the scene by Tody's.

Keywords:

Crosswalk, Moderate, Ped

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.330038

Longitude:

-71.1938425

Location:

808 Beacon St, Newton, 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);