crash_reports

1 row where "datetime" is on date 2019-06-26, dcc = "["Lane departure"]" and intersection = 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:

1900000661

Date:

2019-06-26

Time:

18:42

Address:

49 BOYLSTON ST

Speed limit:

5

Violation cited:

no

Narrative:

MV1 was parked in the parking stall in front of Tender Greens. An unknown vehicle struck the rear quarter panel of MV1 causing minor paint damage. MV1 was parked from approximately 1645, until approximately 1842 when police were dispatched. No tows were needed and no injuries were recorded. There is a camera directly in front of the vehicles. I spoke to Andy McWilliams (617-405-8400) at Tender Greens who stated the footage would be available for at least two weeks, however was unable to retrieve it at this time.

Keywords:

[]

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3226142

Longitude:

-71.1696843

Location:

49 Boylston St, Chestnut Hill, MA 02467, 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);