crash_reports

1 row where dcc = "["Fatigue/Sleep"]", "retrieved" is on date 2022-05-16 and speed_limit = 30

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

22000361

Date:

2022-05-03

Time:

00:13

Address:

1526 COMMONWEALTH AVE

Speed limit:

30

Violation cited:

no

Narrative:

MV1 was traveling WESTBOUND when the operator, Gabriel Jabbar, found himself falling asleep behind the wheel. Mr. Jabbar had been driving to Boston from Missouri for two days straight. MV1 sustained heavy front end damage as it collided head on with a tree on the median inbetween the Commonwealth Ave carriage road and Commonwealth Ave. Tody's towed the vehicle. Mr. Jabbar signed a refusal with the medics.

Keywords:

Tree

Dcc:

Fatigue/Sleep

Report url:

report

Image url:

image

Latitude:

42.3388502

Longitude:

-71.2290908

Location:

1526 Commonwealth Ave, West Newton, MA 02465, 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);