crash_reports

1 row where "date" is on date 2019-03-09 and street1 = "EAST WASHINGTON ST."

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

1900000254

Date:

2019-03-09

Time:

01:17

Address:

WASHINGTON ST. & CHURCH ST.

Speed limit:

25

Violation cited:

no

Narrative:

On 03/09/2019, at 0117 hrs, I responded to Washington St. at Church St. for a two car MVA. Upon arrival, I observed both vehicles facing the same direction in the outer eastbound lane of Washington St. MV1 had moderate damage to the front end and MV2 had heavy damage to the rear end. The operator of MV1 stated that as he was approaching MV2 he attempted to slow down but the vehicle accelerated, rear ending MV2. The operator of MV1 stated that moments after the traffic light turned from red to green, MV2 rear ended her. The passenger in MV2 sustained a bruised lip but all involved parties signed patient refusals with Cataldo. Tody's towed MV2.

Keywords:

Moderate

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3558456

Longitude:

-71.1904222

Location:

Church St & Washington 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);