crash_reports

1 row where dcc = "["Failed to yield"]", intersection = 0 and "retrieved" is on date 2021-03-02

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

2100000126

Date:

2021-02-16

Time:

21:48

Address:

220 BOYLSTON ST

Speed limit:

15

Violation cited:

no

Narrative:

On Tuesday 2/16/21 at approximately 2148 hours while assigned to unit n499 and driving thru the parking lot behind Seasons 52 (220 Boylston Street). I was flagged down by a motorist stating he was just involved in a minor motor vehicle crash. Operator, (FIGARO Ribiar), states he was travelling thru the parking lot coming down the aisle between Starbucks and Seasons 52 when a motor vehicle backed into him striking his vehicle on the drivers side rear tire. Operator, (KHANARINA Larisa), states she looked both ways prior to backing out of her parking spot but did not see FIGARO's vehicle coming and she proceeded to back into the vehicle. No injuries were reported.

Keywords:

Crash

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3197333

Longitude:

-71.1761359

Location:

220 Boylston St, 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);