crash_reports

1 row where dcc contains "Visibility obstructed", intersection = 0 and "retrieved" is on date 2021-02-09

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

2100000038

Date:

2021-01-21

Time:

19:51

Address:

2240 COMMONWEALTH AVE

Speed limit:

30

Violation cited:

no

Narrative:

On 1/21/21 at approximately 1950 hours, I responded to 2240 Commonwealth Ave for a car into a tree with entrapment. On arrival, I observed MA reg 457RC6 into a tree. Firefighters used jaws of life to gain access to the operator. Operator stated he was driving westbound and his windshield was fogging up and could not see. He stated that he saw the oncoming traffic and swerved and hit the tree. The operator suffered minor injuries and was transported to Mass General. The vehicle was towed by Todys.

Keywords:

Fire, Tree

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3469166

Longitude:

-71.2536165

Location:

2240 Commonwealth Avenue, 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);