crash_reports

1 row where "datetime" is on date 2019-12-09, latitude = "42.3548522" and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900001269

Date:

2019-12-09

Time:

15:26

Address:

WASHINGTON ST & LEWIS TER

Speed limit:

35

Violation cited:

no

Narrative:

On 12/9/2019, at 1526 hours, I responded to the intersection of Washington St and Lewis Ter for a two car MVA. Upon arrival, I observed damage to both vehicles front ends. No injuries were reported. The operator of MV1 stated she was on Washington St (WB) attempting to take a left onto Lewis Ter when she collided with MV2 who was traveling EB on Washington St. The operator of MV2 stated he was traveling eastbound on Washington St when MV1 turned in front of him and they collided. It appears that MV2 had the right of way. MV1 was towed from the scene.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3548522

Longitude:

-71.1956673

Location:

Lewis Terrace & 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);