crash_reports

1 row where "datetime" is on date 2019-11-09, dcc contains "Inattention" and speed_limit = 35

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900001156

Date:

2019-11-09

Time:

09:02

Address:

24 COMMONWEALTH AVE

Speed limit:

35

Violation cited:

no

Narrative:

Operator of MV1 (Penn. Reg. CKM160) states she was driving east bound on Commonwealth Ave in the left lane when MV2 turned into the right side of her MV. Operator of MV2 (Mass. Reg. 2NB453) states she was driving east bound on Commonwealth Ave in the right lane when she turned left into MV1. Operator of MV2 states she was looking at the cars ahead and did not notice MV1 when she attempted to turn left.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3397085

Longitude:

-71.1675041

Location:

24 Commonwealth Avenue, Chestnut Hill, MA 02467, 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);