crash_reports

1 row where dcc = "["Other improper action"]" and keywords contains "Night"

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

2000000303

Date:

2020-05-23

Time:

15:42

Address:

167 PARMENTER RD

Speed limit:

30

Violation cited:

no

Narrative:

On Saturday, May 23rd at approximately 1540 hours, I responded to 167 Parmenter Rd for a hit & run accident. Reporting person Bradley Bankman stated his daughter in law's vehicle has been parked out in front of his house since last night. This afternoon he noticed fresh damage to the front left end of the vehicle. I observed the vehicle (Mass Reg # 4520NG, 1994 Toyota Coroll Blue) parked in front of the house with a dent on the left front end of the vehicle. Bradley stated he doesn't know which vehicle caused the damage. There are no cameras and no one witnessed the hit & run.

Keywords:

Crash, Night

Dcc:

Other improper action

Report url:

report

Image url:

image

Latitude:

42.3605836

Longitude:

-71.2318521

Location:

167 Parmenter Rd, 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);