crash_reports

1 row where "datetime" is on date 2019-07-17, 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:

1900000736

Date:

2019-07-17

Time:

16:35

Address:

CENTRE ST & COMMONWEALTH AVE

Speed limit:

30

Violation cited:

no

Narrative:

On Wednesday 7/17/2019 at approx 1635hrs, while assigned to N-494, I responded to the intersection of Comm Ave @ Centre St for a 2 car MVA. Operator of MV1 states she was traveling EB on Comm Ave. She states that while attempting to travel straight across the intersection MV2 cut right in front her striking the front passenger side of MV1. Operator of MV2 states that she was traveling WB on Comm Ave as she approached the intersection. She states that she didn't see incoming cars as she attempting to take a left onto Centre St. She states that MV1 "came out of nowhere" and must have been speeding." Operator of MV2 was cited for failing to yield right of way traffic MGL c89 s9. Citation #T1444757

Keywords:

Citation, Speed

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3365124

Longitude:

-71.1932597

Location:

Commonwealth Avenue & Centre St, Newton, MA 02459, 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);