crash_reports

1 row where intersection = 0, keywords contains "Pictures" and "retrieved" is on date 2021-05-24

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

2100000371

Date:

2021-05-22

Time:

22:16

Address:

242 OTIS ST

Speed limit:

25

Violation cited:

yes

Narrative:

MV1 was driving EASTbound on Otis St when the operator, Philip Dare, drove into a fence belonging to 242 Otis Street. Operator showed signed of impairment and was arrested for OUI Liquor, Marked Lanes, and Negligent Operation. MV1 was towed by Tody's. MV1 sustained heavy front end and undercarriage damage. No injuries were reported by Dare. Medics and Fire arrived at the scene and Fire made the scene safe with yellow caution tape and cleared debris. Pictures taken of the damage, refer to NPD Incident #21022013.

Keywords:

Fire, Impairment, Pictures

Dcc:

Reckless driving, Physical impairment

Report url:

report

Image url:

image

Latitude:

42.3457125

Longitude:

-71.2173959

Location:

242 Otis St, West 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);