crash_reports

1 row where dcc_code = "[3]" and "retrieved" is on date 2021-10-05

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

2100000773

Date:

2021-09-29

Time:

11:05

Address:

BEACON ST & HAMMOND ST

Speed limit:

25

Violation cited:

no

Narrative:

Vehicle 1 was traveling westbound on Beacon St approaching the intersection of Hammond St when vehicle 2 cut in front of him from the left turn lane and they crashed. Operator of vehicle 2 stated she was traveling westbound on Beacon St approaching Hammond St and was in the left turn lane when she stated she put on her right blinker and cut in front of vehicle 1 which was to her right in the other lane. At this time she collided with vehicle 1. Neither operator reported any injuries. Neither vehicle required any tows.

Keywords:

Crash

Dcc:

Signs/Signals

Report url:

report

Image url:

image

Latitude:

42.3328654

Longitude:

-71.1727828

Location:

Beacon St & Hammond St, Newton, MA 02467, 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);