crash_reports

1 row where "datetime" is on date 2019-11-20, dcc contains "Physical impairment" and hit_run = 0

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

1900001189

Date:

2019-11-20

Time:

21:27

Address:

140 BRANDEIS RD

Speed limit:

25

Violation cited:

no

Narrative:

MV 1 was traveling eastbound on Brandeis Rd and struck a bush and the curb in front of Newton South High School. The front right tire was popped and left rear tire was popped. There was also significant damage to the undercarriage of the vehicle. Due to the vehicle being disabled on school grounds, it was towed by Tody's towing. Inventory sheet completed and filed. Refer to NPD incident 19050207. A city bush and curb was damaged from the accident noted in the crash diagram and property section.

Keywords:

Bus, Crash, School

Dcc:

Reckless driving, Physical impairment

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);