crash_reports

1 row where "datetime" is on date 2019-10-23, dcc contains "Unknown" and keywords contains "Bus"

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

1900001083

Date:

2019-10-23

Time:

14:40

Address:

191 DEDHAM ST

Speed limit:

20

Violation cited:

no

Narrative:

Operator of MV1 stated she was parked facing Northbound on Dedham Street in front of Country Side School when a School Bus (Bus #354) struck her driver side mirror. Operator of MV1 stated she attempted to stop the bus but was unsuccessful. Operator of MV1 stated the bus was last seen traveling toward Needham Street. Operator of MV1 stated she was not injured. MV1 had minor damage to the driver side mirror. A voicemail was left for the Eastern Bus Company Newton office to identify the driver of the Bus.

Keywords:

Bus, School

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3136849

Longitude:

-71.203148

Location:

191 Dedham 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);