crash_reports

1 row where "datetime" is on date 2019-11-04 and dcc_code = "[9]"

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

1900001135

Date:

2019-11-04

Time:

16:04

Address:

99 FAXON ST

Speed limit:

25

Violation cited:

no

Narrative:

On Monday 11/4/2019 at approx 1604hrs, while assigned to N-494, I responded to 99 Faxon St for a past MVA. Operator of MV1 stated that he was traveling NB on Faxon St and immediately stopped when he heard his car strike something. He noticed his passenger side mirror was cracked but did not realize he struck MV2 which was legally parked on the street. Owner of MV2 stated that her vehicle was parked on Faxon St in front of her house when the accident occurred.

Keywords:

Crash

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3616352

Longitude:

-71.1988086

Location:

99 Faxon 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);