crash_reports

1 row where "date" is on date 2019-06-18, hit_run = 0 and speed_limit = 0

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

1900000625

Date:

2019-06-18

Time:

02:51

Address:

160 BOYLSTON ST

Speed limit:

0

Violation cited:

yes

Narrative:

Operator 1 of MV1 stated she attempted to put her MV in reverse and the vehicle went forward instead. MV1 collided with the building at 160 Boylston St. Major damage to MV 1. Towed by Todys towing. Operator 1 citated for c90 s24 Leaving the scene of property damage. Reference incident report #19024881.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3195309

Longitude:

-71.1736296

Location:

160 Boylston St, Brookline, MA 02445, 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);