crash_reports

1 row where dcc contains "Unknown", keywords contains "Bus" and "retrieved" is on date 2022-03-02

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

22000157

Date:

2022-02-16

Time:

08:02

Address:

1141 WALNUT ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of Vehicle #1 stated that her vehicle began to slide as the road turned in the area of 1141 Walnut St. This caused her to end up striking the parking mater, and driving onto the lawn of the property at 1141 Walnut St. The vehicle caused possible damage to buses in front, as well as the lawn area.

Keywords:

Bus

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3223594

Longitude:

-71.2071857

Location:

1141 Walnut St, Newton Highlands, MA 02461, 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);