crash_reports

1 row where keywords contains "Ped" and "retrieved" is on date 2021-03-02

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

2100000127

Date:

2021-02-16

Time:

22:45

Address:

241 CHURCH ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of Vehicle #1 stated that she slid into the fence at 234 Church St as she attempted to navigate the bend in the road. The collision damaged a fence at 234 Church St, as well as a crosswalk sign at the intersection of Church St, and Oakland St. The sign and fence were moved to the side of the pedestrian way as best as it could, and the city was notified to remove the debris. The owner of the property, Mr. Steven Carter, was made aware. The vehicle sustained front end damage. The operator declined medical attention when it was offered.

Keywords:

Crosswalk, Ped

Dcc:

Swerving

Report url:

report

Image url:

image

Latitude:

42.3549706

Longitude:

-71.1891781

Location:

241 Church 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);