crash_reports

1 row where dcc contains "Physical impairment" and keywords contains "Tree"

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

22000655

Date:

2022-07-19

Time:

16:39

Address:

PARK ST & WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

It is believed the operator of MV1 suffered a medical episode, subsequently crossing all 3 lanes of traffic, jumping the curb and striking a city tree. Tody's Towing responded and removed the vehicle without incident. Fallon Ambulance transported the operator of MV1 to St Elizabeth's Hospital for an evaluation. See Incident Report 22025503 for further information.

Keywords:

Ems, Hospital, Tree

Dcc:

Physical impairment

Report url:

report

Image url:

image

Latitude:

 

Longitude:

 

Location:

None

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