crash_reports

1 row where date = "2022-06-07" and "retrieved" is on date 2022-06-21

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

22000497

Date:

2022-06-07

Time:

16:40

Address:

CENTRE ST & WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

MV1 stated they were in the middle lane (turns left onto Washington St) when MV2 "who was to the left of me" (lane goes left onto the Mass Pike) drove into me causing minor damage. MV2 stated she was in the middle lane (that turns left onto Washington St) when "they were the lane to my right and hit me" causing minor damage. No injuries reported & no tow's required.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3557988

Longitude:

-71.1865324

Location:

Centre St & 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);