crash_reports

1 row where keywords = "["Ems", "Pictures"]" and "retrieved" is on date 2021-11-16

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

2100000926

Date:

2021-11-09

Time:

20:57

Address:

312 OTIS ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was parked in front of 312 Otis St for a medical call and was struck by MV2 in a sideswipe manner. Operator 2 states he was backing the ambulance into the driveway of 312 Otis St when he struck MV1. Minimal damage to the rear drivers quarter panel of MV1 and minimal damage to MV2 rear passenger quarter panel. No injuries reported and photos taken to be attached to this report.

Keywords:

Ems, Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3450274

Longitude:

-71.2207178

Location:

312 Otis St, West Newton, MA 02465, 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);