crash_reports

1 row where "retrieved" is on date 2021-12-06 and speed_limit = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2100001005

Date:

2021-12-01

Time:

15:14

Address:

BOYLSTON ST & ELLIOT ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 operator states he was pulling onto Rt.9, Boylston St EB, waiting for an opening to enter traffic when the operator of MV2 rear ended his vehicle. MV2 operator states he was pulling onto Rt.9 Boylston St EB when he spotted and opening and thought MV1 would also enter traffic. When MV1 did not proceed onto Rt.9, MV2 operator rear ended MV1. No injuries reported. No vehicles towed.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3187859

Longitude:

-71.2125276

Location:

Elliot St & Boylston St, Newton, MA 02461, 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);