crash_reports

1 row where "retrieved" is on date 2021-10-25 and street2 = "NORTH LOWELL AVE"

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

2100000816

Date:

2021-10-13

Time:

08:08

Address:

WASHINGTON ST & LOWELL AVE

Speed limit:

35

Violation cited:

no

Narrative:

MV1 proceeding straight ahead on Westbound via Washington Street collided with MV2 negotiating a Northbound turn from Washington Street to Lowell Ave. Collision resulted in MV2 rolling and coming to rest on roof. Operator MV2 was entrapped in vehicle, Officer Tocci able to break the window and assist Operator out of vehicle. Operator MV2 transported to Newton Wellesley Hospital via Medic 2. MV1 and MV2 towed to Tody's. A towed motor vehicle form completed and filed.

Keywords:

Hospital

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3510472

Longitude:

-71.2106128

Location:

Lowell Ave & Washington St, Newton, MA 02460, 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);