crash_reports

1 row where "datetime" is on date 2019-01-03 and street1 = "WEST 30 ADELLA AVE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900000010

Date:

2019-01-03

Time:

13:02

Address:

30 ADELLA AVE

Speed limit:

25

Violation cited:

no

Narrative:

Operator of vehicle one stated that while driving westbound on Adella Ave the rear driver's side of his vehicle struck the front driver's side mirror of vehicle two. There was no damage to either vehicle. Vehicle two was parked unoccupied in front of 30 Adella Ave at an angle.There was another unoccupied vehicle parked across from 30 Adella Ave further constricting the roadway. Both occupants of vehicle one stated that they were not injured. Photos of both vehicles were taken and the disk was downloaded by the N PD's IT bureau. Adella Ave is a pubilc way in the City of Newton.

Keywords:

Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3521573

Longitude:

-71.2217011

Location:

30 Adella Ave, Newton, MA 02465, 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);