crash_reports

1 row where "datetime" is on date 2020-01-22 and dcc = "["Unknown"]"

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

2000000086

Date:

2020-01-22

Time:

17:00

Address:

239 WATERTOWN ST

Speed limit:

0

Violation cited:

no

Narrative:

Owner of V1 stated between the hours of 3:00pm and 5:00pm her vehicle was hit by an unknown vehicle. V1 was parked in the parking lot of 239 Watertown Street. The unknown vehicle left the crash and did not leave any information. V1 sustained significant damage to the right rear side of the vehicle. No injuries and no tows.

Keywords:

Crash

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3616588

Longitude:

-71.1959663

Location:

239 Watertown St, Watertown, MA 02472, 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);