crash_reports

1 row where "datetime" is on date 2019-02-21, dcc = "["Failed to yield"]" and keywords contains "Citation"

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

1900000209

Date:

2019-02-21

Time:

21:15

Address:

LEWIS ST & NEWTONVILLE AVE

Speed limit:

25

Violation cited:

yes

Narrative:

The operator of Vehicle #1 stated that he stopped, prior to proceeding through the Stop Sign Southbound at Lewis St, and Newtonville Ave prior to colliding with the bicyclist. The bicyclist stated that he was travelling Westbound on Newtonville Ave prior to colliding with Vehicle #1. Vehicle #1 was cited for a violation of M.G.L. Ch.89/S.9-Stop Sign. It should be noted that the bicyclist was wearing a helmet, and a rear flasher, however wore no other bright, or reflective clothing. All parties declined medical attention. Pictures of the scene were taken by me, and placed in the IT box.

Keywords:

Bike, Citation, Helmet, Pictures

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3528551

Longitude:

-71.1966008

Location:

Lewis St & Newtonville Ave, 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);