crash_reports

1 row where date = "2021-11-10" and "retrieved" is on date 2021-11-16

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

2100000932

Date:

2021-11-10

Time:

17:19

Address:

BOYLSTON ST & CHESTNUT ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 states she was traveling northbound on Chestnut St passing under the overpass bridge to Boylston St in congested traffic when MV2 struck MV1 on the drivers side of the vehicle. MV1 sustained damage to the left side corner panel. No injuries. Operator of MV2 states she was traveling eastbound on the short stretch of road between Quinobequin Rd and Chestnut St. Operator of MV2 states when entering the intersection to turn left onto Chestnut St, MV1 appeared coming from under the over pass bridge causing MV2 to collide with MV1. MV2 sustained front end damage and was towed from the scene. No injuries.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3169482

Longitude:

-71.2257627

Location:

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