crash_reports

1 row where dcc_code = "[11]", keywords contains "Crash" and "retrieved" is on date 2020-10-06

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

2000000071

Date:

2020-01-18

Time:

19:53

Address:

CHESTNUT ST

Speed limit:

30

Violation cited:

no

Narrative:

MV 1 was traveling north on Chestnut St when she slid into the curb striking a USPS post mail box and stop sign. The operator of MV 1 lost control of the vehicle due to inclimate weather and slid into the side of the road striking the objects. The operator was not injured by the crash. Pictures of the mailbox and stop sign were taken and passed into the Newton Police IT department. The vehicle was towed due to it being disabled on a public way. A towed motor vehicle inventory sheet was filled out and filed. Postal police was notified of the downed box.

Keywords:

Crash, Pictures

Dcc:

Swerving

Report url:

report

Image url:

image

Latitude:

42.3307093

Longitude:

-71.2247899

Location:

Chestnut St, Newton, MA, 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);