crash_reports

1 row where date = "2019-08-29" and latitude = "42.3181167"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900000888

Date:

2019-08-29

Time:

17:17

Address:

978 BOYLSTON ST

Speed limit:

5

Violation cited:

no

Narrative:

Owner of MV1 states he parked his vehicle in the lot at 978 Boylston St between 1600 and 1715, during that time someone struck the rear drivers side of his vehicle. A review of the video provided by CVS did not show conclusively anyone striking the vehicle. Minor damage sustained to MV1 and it was driven from the scene.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3181167

Longitude:

-71.211237

Location:

978 Boylston St, Newton, 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);