home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where latitude = "42.3510472" and street1 = "LOWELL AVE"

✎ 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:
22000190
Date:
2022-02-28
Time:
19:32
Address:
LOWELL AVE & WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 was traveling WESTBOUND on Washington St when MV2 collided with her. MV1 operator stated that she was driving straight through the four-way intersection at Lowell Ave with a green light when MV2 collided with her while they were taking a left turn onto Lowell Ave from Washington St. MV2 operator stated that she was traveling EASTBOUND on Washington St, signaled to turn left onto Lowell Ave and proceeded through the intersection when she felt it was safe. MV2 operator believed that MV1 swerved around the vehicle in front of her signaling to turn left and sped through the intersection at a high rate of speed. MV2 stated that she did not see MV1 coming. MV1 damage was to the driver's side fender and MV2 had minimal damage to its driver side fender as well. No injuries reported and both vehicles were safely operable from the scene.
Keywords:
Speed
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3510472
Longitude:
-71.2106128
Location:
Lowell Ave & Washington St, Newton, MA 02460, USA
Case number:
22000647
Date:
2022-07-18
Time:
18:30
Address:
LOWELL AVE & WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Newton Police and Fire were dispatched to Lowell Ave. at Washington St. for a reported motor vehicle collision with minor injury. Upon arrival, Ofc. observed MV#1 stopped, facing northbound in the southbound lane of Lowell Ave. Damage was observed to MV#1's front bumper. The operator of MV#1 was still in the operator's position within the vehicle and was requesting medical attention for a medical emergency. Fire and Medical personal tended to the operator of MV#1 prior to transporting her to a local hospital. MV#2, which had been moved out of the roadway prior to officer arrival had heavy damage to its front end and needed to be removed by Tody's Tow service. The operator of MV#2 was not injured. Witness's to collision reported MV#1 "rolled" through intersection and collided "head on" with MV#2. MV#2 stated he was stopped, attempting to cross southbound through intersection, when he observed MV#1 proceed towards him, colliding "head on" into front of his vehicle.
Keywords:
Fire, Hospital
Dcc:
Illness
Report url:
report
Image url:
image
Latitude:
42.3510472
Longitude:
-71.2106128
Location:
Lowell Ave & Washington St, Newton, MA 02460, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 345.878ms