crash_reports

1 row where "date" is on date 2022-05-12, "retrieved" is on date 2022-05-16 and speed_limit = 30

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

22000389

Date:

2022-05-12

Time:

01:39

Address:

255 WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 was traveling straight ahead down Washington St a public way in the City of Newton when MV2 tried to merge into MV1'S lane and hit the back right driver side door of MV1. Operator of MV2 stated she did not see MV1 traveling next to beside her. There were no injuries and neither car was towed.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3578474

Longitude:

-71.1840263

Location:

255 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);