crash_reports

1 row where "datetime" is on date 2021-12-17 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:

2100001059

Date:

2021-12-17

Time:

15:38

Address:

2040 COMMONWEALTH AVE

Speed limit:

5

Violation cited:

no

Narrative:

On 12/17/21 at approximately 1350 hours, I responded to a car accident in the Shaws Parking Lot. MV1 stated that she was pulling out of her spot and cut the wheel too soon and had made contact with MV2. MV2 was parked and unoccupied at the time of the accident. MV2 had minor damage to the drivers front side and MV1 had damage on the passenger side left panel. No tows were needed. No injuries reported.

Keywords:

Crash

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3469722

Longitude:

-71.2448227

Location:

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