home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "retrieved" is on date 2021-06-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, 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:
2100000400
Date:
2021-06-04
Time:
20:02
Address:
CONCORD ST & WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
The operator of vehicle 1 stated that he was turning left onto Concord Street from Washington Street and had a green left turn arrow. Vehicle 2 came through the intersection and crashed into the passenger side of his vehicle. This caused major damage to the vehicle. The operator of vehicle 2 stated he was traveling West on Washington Street and had a green light when going through the intersection. He then crashed into vehicle 1 who was taking a left turn onto Concord Street. This caused major damage to the front of vehicle 2.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3253683
Longitude:
-71.2576928
Location:
Concord St & Washington St, Newton, MA 02462, USA
Case number:
2100000423
Date:
2021-06-13
Time:
19:33
Address:
2322 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On Sunday June 13, 2021 at approximately 1933 hours I was dispatched to 2322 Washington for a two car MVA with no injuries. MV1 operator stated she was operating eastbound on Washington St (a public way) driving the speed limit. MV1 operator stated she observed MV2 on the westbound side of Washington St attempt to turn left into Starbucks (2322 Washington St). MV1 operator stated by the time she saw MV2 cut across in front of her and into her lane, it was too late and MV1 struck the passenger side of MV2. MV2 operator stated the same story. MV2 operator said she was also going the speed limit on Washington St westbound and attempted to turn left into Starbucks but misjudged MV1's speed, causing the MVA. MV1 sustained extensive total front end damage and was towed by Tody's. MV1 operator requested an evaluation by Newton Medics and was transported to Newton-Wellesley Hospital. MV2 sustained extensive and total passenger side damage and was towed by Tody's. MV2 operator reported no injuries.
Keywords:
Hospital, Severe, Solar, Speed
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3254451
Longitude:
-71.2564178
Location:
2322 Washington St, Newton, MA 02462, USA
Case number:
2100000424
Date:
2021-06-14
Time:
08:19
Address:
401 WATERTOWN ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 (ma reg 2SH825) stated she was parked in front of 401 Watertown Street when she attempted to merge into traffic from a parking spot. While pulling out of the spot her front bumper was struck by a motor vehicle traveling WB on Watertown Street. Operator of MV2 (ma reg 1KXG58) stated he was traveling WB on Watertown Street when his front passenger side wheel and side board struck the front driver's side of MV1. The side board caught the front bumper and ripped it off. Both vehicles suffered minor damage and were able to drive away from the scene safely. Medic 5 was called to the scene for a report of minor injuries. Both parties signed medical refusals.
Keywords:
[]
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3602807
Longitude:
-71.2024286
Location:
401 Watertown St, Newton, MA 02458, 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 389.889ms