crash_reports

1 row where "datetime" is on date 2021-06-22, dcc contains "Lane departure" and "retrieved" is on date 2021-07-04

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

2100000452

Date:

2021-06-22

Time:

11:28

Address:

200 BOYLSTON ST

Speed limit:

5

Violation cited:

no

Narrative:

Operator of vehicle #1 stated he was attempting to park his vehicle in a parking spot. Operator #1 stated that he hit the gas instead of the brake and drove over a handicap sign that was cemented into the ground. Vehicle #1 then drove over a flower bed before making light contact with the brick parking garage wall. An immediate threat form was filled out by me and faxed to the RMV. Also on scene was Mr. Dan Pham, public safety Officer for Wegmans. There were no injuries. Vehicle #1 was towed by Tody's.

Keywords:

[]

Dcc:

Lane departure, Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3189069

Longitude:

-71.1752159

Location:

200 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);