crash_reports

1 row where address = "27 WALNUT ST" and "date" is on date 2019-04-23

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

1900000404

Date:

2019-04-23

Time:

09:02

Address:

27 WALNUT ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of vehicle one stated that while stopped in traffic north bound on Walnut St near number 27 her vehicle was rear ended by vehicle one. Operator of vehicle two stated that while driving north bound on Walnut St near number 27 his foot came off the clutch pedal causing his vehicle to rear end vehicle one. Neither vehicle had damage and both vehicles did not require tows. Neither operator stated that they were injured. I took photos of both vehicles and forward the disk to the NPD's IT bureau. I cited the operator of vehicle two for a violation of City of Newton Ordnance 19/71 , following to close. Walnut St is a public way in the city of Newton.

Keywords:

Citation, Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3582882

Longitude:

-71.2117107

Location:

27 Walnut St, Newton, MA 02460, 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);