crash_reports

1 row where date = "2022-05-18" and "retrieved" is on date 2022-05-23

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

22000421

Date:

2022-05-18

Time:

18:30

Address:

FRANKLIN ST & WAVERLEY AVE

Speed limit:

30

Violation cited:

no

Narrative:

MV1 was traveling southbound on Waverly Ave a public way in the city of Newton, and MV2 was stopped at the stop sign on Franklin st also a public way in the city of Newton. MV1 was driving through the intersection of Waverly and Franklin when MV2 pulled out and hit the side of MV1. Operator of MV2 sated there was a blind spot and she could not see MV1.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3492419

Longitude:

-71.1804564

Location:

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