crash_reports

1 row where dcc contains "Inattention", "retrieved" is on date 2022-04-06 and speed_limit = 35

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

22000270

Date:

2022-04-04

Time:

17:12

Address:

THORNTON ST & WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

MV1 stated he was turning right from Thornton St onto Washington St and trying to get into the left lane when he made contact with MV2. MV2 stated she was travelling straight ahead on Washington St when MV1 struck her vehicle. Both vehicles were towed from the scene and the operator of MV2 was transported to Newton Wellesley Hospital for pain to her right arm.

Keywords:

Hospital

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3564751

Longitude:

-71.1883202

Location:

Thornton St & Washington St, Newton, MA 02458, 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);