crash_reports

1 row where keywords contains "Ped" and "retrieved" is on date 2021-07-13

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

2100000503

Date:

2021-07-11

Time:

11:34

Address:

COMMONWEALTH AVE & IRVING ST

Speed limit:

30

Violation cited:

no

Narrative:

The operator of MV#1 stated he was travelling westbound on Commonwealth Ave and had stopped for some pedestrians crossing at the crosswalk at the intersection of Irving St when he was struck from behind by MV#2. MV#1 sustained moderate damages to its trailer hitch and passenger side exhaust area. There were no reported injuries to the operator of MV#1 or its passengers. The operator of MV#2 stated he was travelling westbound on Commonwealth Ave and could not stop in time and struck MV#1. MV#2 sustained heavy front end damages. There were no reported injuries to the operator of MV#2 or its passenger. MV#2 was parked in front of 551 Commonwealth Ave and arranged for a personal tow.

Keywords:

Crosswalk, Moderate, Ped

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3362127

Longitude:

-71.1893546

Location:

Commonwealth Avenue & Irving St, Newton, MA 02459, 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);