crash_reports

1 row where "datetime" is on date 2019-12-17, keywords contains "Rain" and street1 = "SOUTH GROVE ST"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900001298

Date:

2019-12-17

Time:

12:05

Address:

GROVE ST & PIERREPONT RD

Speed limit:

30

Violation cited:

no

Narrative:

Operator of Vehicle # 1 states she was traveling straight ahead at the speed limit (30 mph) (SB) on Grove Street approaching Pierrepont Road when she lost control of the vehicle due to the ice/slush on the roadway. She then veered off to the right side of the road and struck Verizon utility pole number 85/155 with her front end head on at Grove and Pierrepont Rd. I observed heavy front end damage to the front end/passenger side front of the vehicle and it was towed by Tody's. There was no damage to the utility pole. There is a decline in elevation to the roadway in this area and the road conditions were slippery due to the current snowstorm that was producing snow and freezing rain at the time.

Keywords:

Ice, Rain, Snow, Speed

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3320655

Longitude:

-71.2565313

Location:

Pierrepont Rd & Grove St, Newton, MA 02462, 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);