crash_reports

1 row where "datetime" is on date 2020-04-24, intersection = 0 and keywords contains "Pictures"

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

2000000276

Date:

2020-04-24

Time:

18:38

Address:

37 COMMONWEALTH AVE

Speed limit:

30

Violation cited:

yes

Narrative:

On Friday 04/24/2020 at approx 1838hrs, while assigned to N-494, I responded to 37 Comm Ave in Newton for MVA involving a pedestrian. Upon arrival, I observed MV1 facing the wrong way in the Comm Ave carriage lane. The pedestrian, Mark Logue, stated he was jogging EB on Comm Ave(carriage lane) on the right side when MV1 hit him from behind. He stated that he fell on his hands and injured his right elbow. Logue also stated that his cell phone screen was cracked due to hitting the pavement. Both parties refused medical treatment. Pictures were taken of injuries and submitted to IT. Operator of MV1 was cited for OUI liquor, neg operation of a MV and wrong way. See incident report #20019822

Keywords:

Citation, Ped, Phone, Pictures

Dcc:

Physical impairment

Report url:

report

Image url:

image

Latitude:

42.3399057

Longitude:

-71.1682955

Location:

37 Commonwealth Avenue, Chestnut Hill, MA 02467, 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);