crash_reports

1 row where keywords contains "Impairment", "retrieved" is on date 2021-06-21 and street2 = "NORTH HANCOCK ST"

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

2100000417

Date:

2021-06-11

Time:

15:17

Address:

GROVE ST & HANCOCK ST

Speed limit:

25

Violation cited:

no

Narrative:

Driver of vehicle#1 stated he was driving northbound on Hancock St when he fell asleep behind the wheel. He hit a telephone pole just prior to the intersection of Hancock St and Grove St. I observed Major damage to the passenger side front of the vehicle . Driver did not appear to be impaired and was not injured. Driver called his own towing company and the van was towed from the scene. Driver was transporting flowers to a wedding and called an Uber to take the flowers. After his van was towed he took his own Uber from the scene. Verizon was notified to check on the telephone pole.

Keywords:

Impairment

Dcc:

Fatigue/Sleep

Report url:

report

Image url:

image

Latitude:

42.3410832

Longitude:

-71.2509202

Location:

Hancock St & Grove St, Newton, MA 02466, 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);