crash_reports

1 row where address = "ADAMS AVE & SHERIDAN ST" and "date" is on date 2019-11-22

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900001197

Date:

2019-11-22

Time:

14:28

Address:

ADAMS AVE & SHERIDAN ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of vehicle 1 was traveling eastbound on Adams Ave when she felt her vehicle start to pull to the right causing her to hit a utility pole. She stated it felt as if she lost steering. The vehicle was towed by Todys. Eversource was notified to inspect the pole. Operator reported no injuries and refused medical treatment.

Keywords:

[]

Dcc:

Defective equipment

Report url:

report

Image url:

image

Latitude:

42.358025

Longitude:

-71.233201

Location:

Adams Ave & Sheridan St, 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);