crash_reports

1 row where dcc = "["Visibility obstructed"]", hit_run = 0 and speed_limit = 5

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

2100000774

Date:

2021-09-29

Time:

17:31

Address:

1200 BEACON ST

Speed limit:

5

Violation cited:

no

Narrative:

Operator of MV1 states he was backing up MV1 when he struck MV2, which was in his blind spot. MV2 was parked and unoccupied. Very minor damage to MV1 rear bumper. MV2 sustained damage to the left driver's side door. No injuries.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3311133

Longitude:

-71.2132723

Location:

1200 Beacon St, Waban, MA 02468, 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);