home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2021-09-27, dcc contains "Unknown" and keywords contains "Bus"

✎ 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:
2100000764
Date:
2021-09-27
Time:
15:37
Address:
45 PETTEE ST
Speed limit:
20
Violation cited:
no
Narrative:
On 09/27/2021, while assigned to N503, I, Officer Conary, responded to the area of Pettee Street, Emerson Playground, for a minor MVA involving a school bus. Upon arrival, I met with Operator of MV1 who explained to me that MV2 (school bus) had to leave and continue their bus route. Operator of MV1 was able to provide me with the drivers information. Newton Dispatch also called Eastern Bus to confirm the information. Operator of MV1 was parked Northbound on the left side of the street when MV1 hit her rear left quarter panel. MV2 was pulling off to the side by the park to let students out. Operator of MV1 stated she saw student on the bus and got off. She said there was approximately a handful of students (6 or 7). She believes that they were from the Zervas School on Beacon Street. MV2 was the third bus that pulled up at the park to drop students off. I attempted to call Operator of MV1 with negative results but left a message. I tried to call Eastern Bus Company again with negative results. An email was sent to Regina Moody, City of Newton, who oversees the school buses. The traffic bureau has been notified for follow up. SRO of the Zervas School was notified as well. MV1 was able to be driven from scene, and no injuries were reported. On 10/26/21, I followed up with Regina Mooney with the City of Newton and she was able to comfirm that there were a few students on the bus at the time of the accident. Eastern Bus Company is handling the accident.
Keywords:
Bus, Crash, School
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3136792
Longitude:
-71.2219904
Location:
45 Pettee St, Newton, MA 02464, 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 476.526ms