home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where date = "2019-04-02"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, hit_run, 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:
1900000333
Date:
2019-04-02
Time:
08:30
Address:
PARKER ST & BOYLSTON ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 a City of Newton school bus was stopped southbound on Parker St at Rte 9 east to turn left onto the ramp. MV2 began passing the bus on the right when the bus turned left onto the ramp. The right rear corner of the bus struck the front left wheel well of MV2. I took pictures of the damage to MV2 and TOT IT. I spoke with Regina Moody of transportation and she put me in contact with the driver of a bus who was in the area at the time of the MVA. On Thursday I met with Joseph Montuna who was in the area at the time of the MVA. His bus is 362. The side of his bus says Eastern Bus Company. It does not say Newton Public Schools anywhere visible. I looked at the right rear of the bus that would have come into contact with the MV. There was not even a smudge on the bumper. I am not positive that this is the bus involved. I have attempted to contact MV2 for clarification to positively ID the correct bus. The number provided goes directly to VM which is full. It is possible that this was a non Newton school bus involved that I am unable to identify.
Keywords:
Bus, Pictures, School
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.319099
Longitude:
-71.1943518
Location:
Parker St & Boylston St, Newton, MA 02459, USA
Case number:
1900000334
Date:
2019-04-02
Time:
11:59
Address:
6 WINDSOR RD
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was parked unoccupied in a spot on the street. MV2 backed into MV1. MV2 stated that MV1 was completely in his blind spot and he did not see it while backing. I took pictures of the damage to the MVs and TOT IT.
Keywords:
Pictures
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3269192
Longitude:
-71.2307731
Location:
6 Windsor Rd, Waban, MA 02468, USA
Case number:
1900000335
Date:
2019-04-02
Time:
18:18
Address:
WASHINGTON ST & 2 NORTH I95N
Speed limit:
35
Violation cited:
no
Narrative:
The operator of vehicle 1 stated she was turning right onto Washington Street from the I95N off ramp when she was rear-ended, this caused minor damage to the bumper and exhaust of her vehicle. She did not get a good look at the other vehicle and it did not stop.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3251001
Longitude:
-71.2590923
Location:
2 Washington St, Wellesley, MA 02481, 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 456.661ms