crash_reports

1 row where "datetime" is on date 2019-05-11, dcc contains "Other improper action" and intersection = 0

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

1900000481

Date:

2019-05-11

Time:

19:33

Address:

345 WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

Opr of V1 stated he was pulling out of the parking spot onto Washington Street. At this time, he stated he thought he had enough room but did not and struck V2. V1 suffered significant damage to the front right side of the vehicle. V2 was parked in front of V1. The uninvolved owner was not around during the crash , but came to the car eventually. V2 suffered significant damage to the rear right side of the vehicle. No cars were towed and there were no injuries.

Keywords:

Crash

Dcc:

Other improper action

Report url:

report

Image url:

image

Latitude:

42.3569087

Longitude:

-71.1878411

Location:

345 Washington St, Newton, MA 02458, 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);