crash_reports

1 row where dcc = "["Signs/Signals"]" and "retrieved" is on date 2021-11-29

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

2100000967

Date:

2021-11-21

Time:

14:16

Address:

BOYLSTON ST & QUINOBEQUIN RD

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV#1 stated she was stopped at the stop sign on Boylston St off ramp (Westbound) at the intersection of Quinobequin Rd and proceeded to travel westbound when she was struck by MV#2. MV#1 sustained moderate damages to its front passenger side. There were no reported injuries to the operator of MV#1 or her dog. The operator of MV#2 stated he was travelling southbound on Quinobequin Rd and did not see the stop sign at the intersection of Boylston St and struck MV#1. MV#2 sustained moderate damages to its front driver's side. There were no reported injuries to the operator of MV#2 or its front passenger.

Keywords:

Moderate

Dcc:

Signs/Signals

Report url:

report

Image url:

image

Latitude:

42.317164

Longitude:

-71.2268965

Location:

Quinobequin Rd & Boylston St, Newton, MA 02468, 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);