crash_reports

1 row where "datetime" is on date 2019-02-06, intersection = 0 and keywords contains "Glare"

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

1900000153

Date:

2019-02-06

Time:

20:01

Address:

153 CONCORD ST

Speed limit:

25

Violation cited:

no

Narrative:

The OP. of MV#1 states he was travelling northbound on Concord Street. He is familiar with the road and the medians but due to the rain and the glare it caused with his eye glasses, he miscalculated the curb of the median and struck it.

Keywords:

Glare, Rain

Dcc:

Glare

Report url:

report

Image url:

image

Latitude:

42.3280043

Longitude:

-71.262188

Location:

153 Concord St, Newton, MA 02462, 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);