home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "date" is on date 2021-07-24, hit_run = 0 and speed_limit = 0

✎ 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:
2100000543
Date:
2021-07-24
Time:
09:09
Address:
138 NEEDHAM ST
Speed limit:
0
Violation cited:
no
Narrative:
On 7/24/21, Newton Police were dispatched to the Dunkin Donuts parking lot (138 Needham St.) for a motor vehicle accident. Upon arrival, MV#1 was observed wedged, facing southbound inside the parking space between MV#2 and MV#3 with heavy front end damage. MV#2 was observed with damage to its rear end, while MV#3 had apparent damage to its driver side passenger door and side panel. Both MV#2 and MV#3 were parked, unoccupied prior to the collision. The operator of MV#1 stated she was reversing out of her parking space across the parking lot, when her brakes malfunctioned causing her to strike MV#2 before striking MV#3.The operator of MV#1 reported no injuries. Damage to all vehicles were consistent with MV#1 reversing into MV#2's rear end before striking MV#3's driver side. MV#1 was towed away by Tody's Towing, while MV#2 and MV#3 were able to be driven from the scene.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3128381
Longitude:
-71.212082
Location:
138 Needham 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 588.001ms