crash_reports

1 row where "datetime" is on date 2019-07-10, dcc contains "Visibility obstructed" and intersection = 0

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

1900000720

Date:

2019-07-10

Time:

13:06

Address:

63 KENWOOD AVE

Speed limit:

25

Violation cited:

no

Narrative:

On 7/10/2019 at approx 1306Hrs while assigned to 497 I responded to 57 Kenwood St for a report of a vehicle backing into a gas light pole. Upon arrival I met with a worker for A Blade of Grass Landscaping Company, Taidy GONZALES. GONZALES stated she was backing her company truck into the driveway of 57 Kenwood Rd when she taped the gas light pole belonging to The City of Newton causing the glass globe to crack. NFD responded and turned the gas off.

Keywords:

Fire

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3356174

Longitude:

-71.2024286

Location:

63 Kenwood Ave, Newton, MA 02459, 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);