crash_reports

1 row where dcc contains "Lane departure" and "retrieved" is on date 2022-05-04

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

22000320

Date:

2022-04-20

Time:

11:07

Address:

GROVE ST & QUINOBEQUIN RD

Speed limit:

25

Violation cited:

no

Narrative:

On 4/20/2022 at approx 1107Hrs while assigned to 497 I responded to the area of Grove St and Quinobequin Rd for a report of a two car crash w/o injury. Upon arrival I met with delivery driver, William James who stated , Co Reg 4070816, when a blue Ford Focus Ma Reg 1VXZ52 being operated by Michael Bradley attempted to cut him off, jumping the island to take the left off of Grove St causing Bradleys mirror to damage the mid rear side of the delivery van. There were clear tire tracks through the mud on the island tracking on the roadway to confirm this. William stated Michael did stop and exchange but stated he was in a rush to get to an appointment and left prior to police arrival.

Keywords:

Crash

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3317122

Longitude:

-71.2570443

Location:

Quinobequin Rd & Grove 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);