home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where date = "2022-05-16" and "retrieved" is on date 2022-05-23

✎ 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:
22000411
Date:
2022-05-16
Time:
18:35
Address:
ADAMS ST & QUIRK CT
Speed limit:
25
Violation cited:
no
Narrative:
A witness stated she observed MV1 strike MV2 which was parked & unoccupied. The witness further stated that MV1 attempted to flee the area. MV2 sustained damage to the drivers side however did not require a tow. While speaking with MV2, the owner of MV3 which was parked 2 spots up reported damage to his drivers side. MV3 stated he did not witness the incident but knows his vehicle was not like that when he parked moments earlier. The operator of MV1 stated he was parked and on the phone speaking to a client when an "elderly woman ran up to me filming saying I hit someone's car and I don't believe I did". MV1 further stated he did not have any damage to his vehicle. I asked MV1 if he struck a black truck (MV3) to which he stated "no, I didn't hit anyone". I asked MV1 why he did not stick around to which he stated "that lady was filming me and I know I didn't hit anything". A canvass of the area for cameras was conducted yielding negative results. Given the size of MV1, it is possible that the operator was unaware he had struck a vehicle. Photos from the witness were turned over to the IT Bureau
Keywords:
Phone, Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3582831
Longitude:
-71.2001121
Location:
Adams St & Quirk Ct, Newton, MA 02458, USA
Case number:
22000412
Date:
2022-05-16
Time:
20:26
Address:
131 CRAFTS ST
Speed limit:
30
Violation cited:
no
Narrative:
MV 1 was traveling southbound on Craft St when he rear ended MV 2. MV 1 sustained major front end damage and the front air bag was deployed. MV 1 was towed by Tody's due to it being disabled. The operator and owner of MV 1, Mr. Alan Green, sustained a head and neck injury and was transported to Newton Wellesley Hospital by Fallon medics. MV 2 was parked in front of 131 Craft St with its hazards on delivering food, when MV 1 rear ended him. MV 2 sustained major rear end damage and was towed by Tody's due to it being disabled. The operator and passenger of MV 2 sustained neck injuries and were transported to Newton Wellesley by Fallon medics. MV 3 was legally parked and unoccupied in front of MV 2 when MV 1 rear ended MV 2 and subsequently rear ended MV 3. MV 3 sustained minor damage to the rear end. A crash report number was left for the uninvolved owner, Ms. Janet Goff, of MV 3.
Keywords:
Crash, Hospital
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3563988
Longitude:
-71.2042851
Location:
131 Crafts St, Newton, MA 02460, 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 304.583ms