crash_reports

1 row where "datetime" is on date 2019-05-06 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:

1900000459

Date:

2019-05-06

Time:

10:59

Address:

CHURCH ST & ELDREDGE ST

Speed limit:

25

Violation cited:

no

Narrative:

Oper of motorcycle ( Vehicle #1) stated she was traveling WB on Church Street and while going through intersection at Eldridge Street she moved to the right because of on coming vehicle. She underestimated the size of her sidecar on the motorcycle and sideswiped vehicle #2 which was parked on Church Street. A note was left on vehicle # 2 informing her about report. Sidecar wasn't added to diagram because it is not an option. No injuries. No tickets.

Keywords:

Citation

Dcc:

Over-steering

Report url:

report

Image url:

image

Latitude:

42.3531019

Longitude:

-71.1842085

Location:

Church St & Eldredge 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);