crash_reports

1 row where dcc = "["Other improper action"]", keywords contains "Speed" 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), keywords (array), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

22000478

Date:

2022-06-01

Time:

15:55

Address:

175 EVELYN RD

Speed limit:

25

Violation cited:

no

Narrative:

MV1 and MV2 backed into each other while exiting their driveways. MV1 unintentionally continued in reverse at high rate of speed into Mary Ellen RD. MV1 then shifted into drive and accelerated into a City of Newton tree on Evelyn RD. Driver MV1 transported to NWH with small cut to her lip and pain in her right ankle. Driver MV2 and occupant declined medical attention. City of Newton Tree inspected by Urban Forestry. Urban Forestry cautioned off the area but stated the tree was not expected to fall. An immediate threat report was filed with the Department of Motor vehicles for the operator of MV1

Keywords:

Speed, Tree

Dcc:

Other improper action

Report url:

report

Image url:

image

Latitude:

42.3363681

Longitude:

-71.2184865

Location:

175 Evelyn Rd, Waban, MA 02468, 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);