crash_reports

1 row where "datetime" is on date 2019-02-01, 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:

1900000128

Date:

2019-02-01

Time:

01:37

Address:

97 UNION ST

Speed limit:

25

Violation cited:

no

Narrative:

Motor vehicle 1 (MV1) was parked facing southeast in front of 97 Union Street, when unknown motor vehicle 2 (MV2), sideswiped MV1 and then left the area. As a result of the crash, the passengers side, side view mirror was ripped of MV1. MV2 likely sustained minor drivers side damage. The reporting party, Gianfranco Palestro, heard the collision and believes that MV2 was a dark colored SUV, but was unable to get a license plate number. I was unable to check if any of the local businesses had security cameras that may have captured the crash as they were all closed for the night.

Keywords:

Bus, Crash, Night

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3296714

Longitude:

-71.1934706

Location:

97 Union St, Newton Centre, MA 02459, 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);