crash_reports

1 row where "datetime" is on date 2019-06-07 and speed_limit = 10

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

1900000589

Date:

2019-06-07

Time:

11:23

Address:

200 BOYLSTON ST

Speed limit:

10

Violation cited:

no

Narrative:

MV1 was driving northbound in the parking lot when MV2 backed out of a parking spot striking MV1 in the right rear door and quarter panel. Oper 1 stated he was driving in the lot when MV2 struck the right rear of the car. Oper 2 stated she was backing out of he spot when she struck MV1 she stated she did not see MV1 prior to the accident. pictures were taken by and forwarded to IT

Keywords:

Crash, Pictures

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3191343

Longitude:

-71.1756718

Location:

200 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);