crash_reports

1 row where "datetime" is on date 2019-04-11 and speed_limit = 10

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

1900000367

Date:

2019-04-11

Time:

17:41

Address:

287 AUBURN ST

Speed limit:

10

Violation cited:

no

Narrative:

Owner of MV1 reports he came out to the parking lot and observed new damage to the drivers rear door of his MV. MV1 was parked at approximatley 0900 hours and the damage was observed at 1700 hours. I observed damage to the drivers side rear door of MV1. I also observed broken red plastic on the ground, consistent with a broken taillight from being backed into by another MV. Owner of MV1 is going to check with his boss to see if cameras from his workplace capture the parking lot. No other cameras were visible in the parking lot area.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3468186

Longitude:

-71.2468033

Location:

287 Auburn St, 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);