crash_reports

1 row where "date" is on date 2019-10-11, dcc_code = "[10]" and keywords contains "Crash"

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

1900001035

Date:

2019-10-11

Time:

15:14

Address:

CHESTNUT ST & ELLIOT ST

Speed limit:

30

Violation cited:

yes

Narrative:

Vehicle 2 was stopped at the red light on Chestnut St at Elliot St, facing northbound. Vehicle 1 was travelling eastbound on Elliot St, and turning right onto Chestnut St. The front drivers side of vehicle 1 struck the middle driver's side of vehicle 2, while making the turn. Vehicle 1 fled the scene, while vehicle 2 chased after them to Williams St. Once on scene, I observed moderate damage to the front drivers side of vehicle 1, and moderate damage to the center drivers side of vehicle 2. No one was inured due to the accident. No vehicles towed.

Keywords:

Crash, Moderate

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3128144

Longitude:

-71.2246681

Location:

Chestnut St & Elliot 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);