crash_reports

1 row where dcc contains "Inattention", latitude = "42.3557988" and "retrieved" is on date 2022-04-21

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

22000297

Date:

2022-04-10

Time:

12:43

Address:

CENTRE ST & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV1 stated she was stopped at the corner of Centre street and Washington Street, waiting for it to be safe to merge onto Washington Street. While stopped MV2 attempted to go around and struck the rear driver side of the vehicle. The operator of MV2 stated traffic was clear and while he attempted to merge onto Washington Street, MV1 stopped and he struck MV1. All parties involved were not injured. MV1 had damage to the rear bumper. MV2 had damage to the front passenger side head light and side.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3557988

Longitude:

-71.1865324

Location:

Centre St & 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);