crash_reports

1 row where keywords contains "Hospital" and "retrieved" is on date 2022-06-24

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

22000515

Date:

2022-06-12

Time:

01:36

Address:

2401 COMMONWEALTH AVE

Speed limit:

35

Violation cited:

no

Narrative:

The OP. of MV#1 stated he was travelling westbound on Commonwealth Ave. when he ran out of gas. His vehicle then started rolling backward and he collided with the guard rail. The OP. of MV#1 appeared to be confused so medics responded. Initial evaluation is low blood sugar causing confusion. MV#1 was towed by Tody's of West Newton. The OP. of MV#1 was transported to Newton-Wellesley Hospital and Springwell will be contacted. No damage to guard rail.

Keywords:

Hospital

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.344638

Longitude:

-71.2598115

Location:

2401 Commonwealth Ave, Auburndale, MA 02466, 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);