home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where date = "2020-12-02" and "retrieved" is on date 2021-01-08

✎ 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:
2000000689
Date:
2020-12-02
Time:
09:35
Address:
1321 WASHINGTON ST
Speed limit:
15
Violation cited:
no
Narrative:
On Wednesday, December 02, 2020, while assigned to Traffic unit N525, I was traveling Westbound through the rear parking lot of 1321 Washington Street at approximately 0905 hours. As I was traveling through the lot, I observed Parking Control unit 1308 backing (S) out of a parking spot ahead of me to my right. Parking Control unit 1308 is a City of Newton owned vehicle (MA MVN: MP1308). I stopped my vehicle in the roadway to allow 1308 to continue backing out of their parking spot. As 1308 continued to backing, the rear driver side bumper area of the vehicle crashed into the front passenger side bumper/fender area of Parking Control unit 1309 (MA MVN: MP5E). Parking Control unit 1309 was parked (W) in the roadway unoccupied. I observed no damage to either vehicle. The operator of Parking Control unit 1308 exited her vehicle and was identified as Parking Control Officer Angela Foley. PCO Foley stated she was backing her vehicle out of its parking spot and did not see 1309 parked behind her. PCO Foley stated the vehicle was in her blind spot. PCO Foley was asked if she was injured as a result of the crash. PCO Foley stated she was not. Photos were taken of both vehicles to document the crash and submitted to the IT Bureau.
Keywords:
Crash, Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
1321 Washington St, Newton, MA 02465, 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 291.422ms