crash_reports

1 row where geocoded_address = "Quinobequin Rd & Washington St, Newton, MA 02462, USA" and "retrieved" is on date 2021-10-25

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

2100000817

Date:

2021-10-13

Time:

09:38

Address:

QUINOBEQUIN RD & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

On 10/13/2021 at approx 0938Hrs while assigned to 497 I responded to the area of Washington St and Quinobequin Rd for a report of a 2 car crash. Upon arrival both operators where pulled to the side of the road on Quinobequin Rd. I spoke with the operator of Ma Reg 3FWN51 Alicione Goncalves who stated she had the green light travelling Quinobequin Rd southbound when the pickup truck turned in front of her causing the collision. i spoke with the operator of NH Com Reg RBAC02, Robert Allen who stated he was travelling northbound on Quinobequin Rd , mistakenly though the green light was a green arrow to turn left onto Washington St colliding with Goncalves.

Keywords:

Crash

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3274875

Longitude:

-71.2531655

Location:

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