crash_reports

1 row where dcc contains "Unknown", intersection = 0 and "retrieved" is on date 2021-05-24

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

2100000365

Date:

2021-05-20

Time:

18:32

Address:

140 BRANDEIS RD

Speed limit:

30

Violation cited:

no

Narrative:

Operator 1 of MV 1 was pulling out of the parking lot of 140 Brandeis Rd attempting to take a left (w/b ). Operator1 looked right (e/b) and a vehicle let her out of the lot. As Operator1 was pulling out of the lot MV2 collided with the front of her vehicle. Moderate damage to MV1, towed by todys. No injuries to Operator1. Operator 2 of MV 2 was traveling e/b on Brandeis rd by #140. Operator 2 said he saw a vehicle pull out of the lot to take a left and could not stop in time. Operator 2 believes that operator 1 only looked right and did not look left as they were pulling out of the parking lot. Minor damage to MV2. No injuries to operator 2.

Keywords:

Moderate

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3135234

Longitude:

-71.1865424

Location:

140 Brandeis Rd, Newton, MA 02459, 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);