crash_reports

1 row where "datetime" is on date 2019-12-16 and latitude = "42.3306338"

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

1900001293

Date:

2019-12-16

Time:

10:57

Address:

2014 WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

Operator of vehicle 1 stated he was in the right lane of the eastbound side of Washington St with his right blinker on waiting to turn right into 2000 Washington St. As he proceeded to turn right vehicle 2 came from his left around the front of his car clipping the front end. Operator of vehicle 2 stated he saw vehicle 1 stopped ahead of him but did not notice his turn signal on and thought he was just stopped so he attempted to go around him from the left lane and collided with him. Neither operator reported any injuries and neither vehicle required a tow.

Keywords:

[]

Dcc:

Improper turn

Report url:

report

Image url:

image

Latitude:

42.3306338

Longitude:

-71.2464373

Location:

2014 Washington 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);