crash_reports

1 row where address = "345 WASHINGTON ST" and "retrieved" is on date 2022-05-04

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

22000344

Date:

2022-04-26

Time:

17:01

Address:

345 WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 stated he was attempting to pull into traffic when he made contact with MV2 causing minor damage. MV2 stated he was travelling straight when MV1 pulled out and hit him causing minor damage. No injuries reported & no tows required.

Keywords:

[]

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3568934

Longitude:

-71.1877425

Location:

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