crash_reports

1 row where "datetime" is on date 2019-07-26 and dcc = "["Failed to yield", "Inattention"]"

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

1900000769

Date:

2019-07-26

Time:

13:46

Address:

CENTRAL ST & GROVE ST

Speed limit:

25

Violation cited:

no

Narrative:

operator 1 stated he was travelling through the intersection from Auburn St on to Central St. when vehicle two possibly ran the red light crashing into him. Operator of vehicle 2 stated she was travelling straight on Grove St and does not remember seeing the lights and thought she had the right of way. There were no injuries due to this accident and neither vehicle was towed.

Keywords:

Crash

Dcc:

Failed to yield, Inattention

Report url:

report

Image url:

image

Latitude:

42.3454654

Longitude:

-71.2462928

Location:

Central St & Grove St, Newton, MA 02466, 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);