crash_reports

1 row where keywords contains "Walk" and "retrieved" is on date 2021-07-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:

2100000522

Date:

2021-07-17

Time:

11:42

Address:

31 KEEFE AVE

Speed limit:

25

Violation cited:

no

Narrative:

On Saturday 7/7/2021 at approx 1142hrs, while assigned to N495, I responded to 39 Keefe Ave in Newton for a single car MVA. There I met the operator of MV1 show stated that he accidently struck a city fire hydrant with his company truck (Verizon). The hydrant itself did not appear damaged. However, it was dislodged from the side walk and no longer secured by its bolts. The Newton water dept was notified and responded.

Keywords:

Crash, Fire, Walk

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3107965

Longitude:

-71.2257474

Location:

31 Keefe Ave, Newton, MA 02464, 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);