crash_reports

1 row where date = "2020-12-16" and "retrieved" is on date 2021-01-08

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

2000000744

Date:

2020-12-16

Time:

23:23

Address:

DEDHAM ST & WISWALL RD

Speed limit:

25

Violation cited:

no

Narrative:

Vehicle 1 was travelling eastbound on Dedham St, and took a right turn onto Wiswall Rd, While attempting to make the turn the vehicle slid on the snow, and the back left of the vehicle hit the curb. The air bags were deployed on the left side. I observed minor damage to the back left of the vehicle. No one was injured. The vehicle was towed by Tody's to their lot.

Keywords:

Snow

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.2980951

Longitude:

-71.1848947

Location:

Dedham St & Wiswall Rd, Newton, MA 02459, 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);