crash_reports

1 row where date = "2021-09-30" and "retrieved" is on date 2021-10-25

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

2100000775

Date:

2021-09-30

Time:

19:43

Address:

BOYLSTON ST

Speed limit:

50

Violation cited:

no

Narrative:

Operator of MV1 said she was on the on ramp located at Winchester Street at Boylston Street. Operator of MV1 said she attempted to merge onto Boylston Street when she struck the rear of MV2 at Boylston Street at Walnut Street. Operator of MV2 said he was traveling eastbound on Boylston St and was attempting to turn right onto Walnut St when he was struck from behind by MV2. Both MV1 and MV2 pulled over to Woodcliff road. There is damage to the rear passenger bumper of MV2. There were no injuries and both vehicles were able to drive away from the scene.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.319099

Longitude:

-71.1943518

Location:

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