crash_reports

1 row where "datetime" is on date 2019-11-19 and latitude = "42.3469722"

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

1900001183

Date:

2019-11-19

Time:

19:05

Address:

2040 COMMONWEALTH AVE

Speed limit:

15

Violation cited:

no

Narrative:

Operator of MV1 parked his car in the parking lot and went into the business, when he returned there was damage to the front passenger bumper area. Upon reviewing the cameras I was able to see the operator of MV1 park his vehicle in a space. At approximately 1841 hours MV2, a gray or darker colored Ford F150, pulls across spaces and attempts to go next to MV1. MV2 stops abruptly puts it in reverse and leaves. It appeared as if MV1 was struck by MV2.. It should be noted the camera is in black and white, unable to get any clear images of the license plate of MV2. No injuries reported.

Keywords:

Bus

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3469722

Longitude:

-71.2448227

Location:

2040 Commonwealth Avenue, Auburndale, MA 02466, 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);