crash_reports

1 row where keywords contains "Hospital" and "retrieved" is on date 2021-04-26

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

2100000277

Date:

2021-04-20

Time:

14:16

Address:

254 ADAMS ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 stated she was travelling n/b on Adams St when she "bent over for a snack" subsequently rear ending MV2 (parked). MV1 sustained heavy front end damage and was removed from the scene by Tody's. Operator of MV1 was transported by Fallon Ambulance to St Elizabeth's Hospital complaining of leg pain. MV2 sustained significant rear end damage, however was operable.

Keywords:

Ems, Hospital

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3570025

Longitude:

-71.1982052

Location:

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