crash_reports

1 row where dcc contains "Swerving" and "retrieved" is on date 2020-12-27

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

2000000748

Date:

2020-12-17

Time:

21:56

Address:

230 CENTRAL ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling westbound on Central Street and lost control due to the snow on the road. MV1 swerved off the road and drove through a snow bank and traveled through the fence in front of 230 Central Street. Operator of MV1 stated he saw a parked car on the right hand side of the road too late which caused him to swerve. The owner of 230 Central Street, Barbara Sullivan, was notified about the damage to the fence in the front of her building. No injuries were sustained during the crash.

Keywords:

Crash, Snow

Dcc:

Swerving, Over-steering

Report url:

report

Image url:

image

Latitude:

42.345221

Longitude:

-71.2500673

Location:

230 Central St, Auburndale, 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);