crash_reports

1 row where date = "2021-11-02" and "retrieved" is on date 2021-11-16

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

2100000891

Date:

2021-11-02

Time:

16:31

Address:

39 COMMONWEALTH AVE

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was parked in front of 39 Commonwealth ave. Operator stated it was parked at approximately 1330hrs with no damage. Operator of MV1 stated that at approximately 1631 hours they noticed damage to the front driver side wheel well fender. MV1 operator stated that a vehicle was parked in front of his vehicle with extensive damage. I witnessed red paint transfer, but not blue paint transfer on the gray vehicle parked in front of MV1.

Keywords:

Severe

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3399286

Longitude:

-71.1683847

Location:

39 Commonwealth Avenue, 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);