crash_reports

1 row where "datetime" is on date 2019-06-27, dcc contains "Visibility obstructed" and intersection = 0

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

1900000665

Date:

2019-06-27

Time:

12:52

Address:

199 BOYLSTON ST

Speed limit:

30

Violation cited:

no

Narrative:

VEHICLE OPERATOR WAS DRIVING THROUGH THE PARKING LOT OF THE CHESTNUT HILL MALL. ALL OF A SUDDEN A BUG FLEW INTO HER EYE, SHE TRIED TO RUB HER EYE AND AT THAT TIME SHE STRUCK A CEMENT LIGHT POLE FOUNDATION ON MALL PROPERTY. VEHICLE HAD AIR BAG DEPLOYMENT, VEHICLE OPERATOR TRANSPORTED TO NEWTON WELLESLEY HOSPITAL WITH SHOULDER PAIN. VEHICLE TOWED BY TODYS TOWING OF NEWTON. CEMENT POLE FOUNDATION HAD NO DAMAGE.

Keywords:

Hospital

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3215125

Longitude:

-71.1756718

Location:

199 Boylston St, Chestnut Hill, MA 02467, 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);