crash_reports

1 row where date = "2021-06-15", "retrieved" is on date 2021-07-04 and speed_limit = 25

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

2100000433

Date:

2021-06-15

Time:

16:30

Address:

WASHINGTON ST & WAVERLEY AVE

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV1 stated he stopped at the stop sign on Waverly Ave, proceeded to pull onto Washington Street, westbound, when he struck MV2 on the rear driver side of the vehicle. The operator of MV2 stated she was traveling westbound on Washington Street, approaching Waverly Ave. As she was turning left onto Waverly Ave, MV1 pulled out on Washington Street. MV1 had minor damage to the front bumped. MV2 had moderate damage to the passenger side and rim. Also the rear bumper was hanging off. Both operators stated they were not injured and were able to operate the vehicles once all paper work was gathered.

Keywords:

Moderate

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3554062

Longitude:

-71.1785475

Location:

Waverley Ave & 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);