crash_reports

1 row where "datetime" is on date 2019-03-06, 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:

1900000245

Date:

2019-03-06

Time:

17:53

Address:

785 CENTRE ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 was traveling southbound on Centre Street. She stated there was heavy stop and go traffic. MV2 struck the rear of her vehicle when she came to a complete stop as she passed 785 Centre Street. Operator of MV2 said he did not how close he was to MV1 and rear ended the vehicle. Both parties were uninjured and declined medical attention. MV1 had minor rear end damage and MV2 had moderate front end damage. Both vehicles were able to be driven from the scene.

Keywords:

Moderate

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.345917

Longitude:

-71.1916379

Location:

785 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);