crash_reports

1 row where dcc contains "Unknown", latitude = "42.3596277" and speed_limit = 15

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

2100000144

Date:

2021-02-22

Time:

17:03

Address:

427 WATERTOWN ST

Speed limit:

15

Violation cited:

no

Narrative:

The operator of Vehicle #1 stated that she was sitting in her parked motor vehicle when the rear driver's side was struck by Vehicle #2 causing minor damage. Vehicle #2 then left the area. When I spoke with the operator of Vehicle #2 he stated that was unaware that he struck a vehicle, but "that doesn't mean it didn't happen". He also reported that his vehicle was not damaged. Neither party complained of injury when they were asked. This occured in the rear parking lot of 425 Watertown St.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3596277

Longitude:

-71.203289

Location:

427 Watertown 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);