home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "retrieved" is on date 2022-01-24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, hit_run, violation_cited, 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:
2100001062
Date:
2021-12-18
Time:
20:48
Address:
CRAFTS ST & FESSENDEN ST
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of MV1 stated he was traveling straight and hit MV2. Operator MV1 sustained minor injures and was transported to NWH. MV1 sustained damage and was towed by Tody's. Operator of MV1 was charged and given Massachusetts uniform citation (T1448307) see report #20152278. Operator of MV2 stated he was stopped waiting for the green light and was hit from behind. All occupants of MV2 signed patient refusals. MV2 sustained damage but was not towed.
Keywords:
Citation
Dcc:
Reckless driving, Other improper action
Report url:
report
Image url:
image
Latitude:
42.3596868
Longitude:
-71.2148342
Location:
Fessenden St & Crafts St, Newton, MA 02460, USA
Case number:
22000059
Date:
2022-01-21
Time:
20:30
Address:
1175 WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
On 01/22/2022, while assigned to West Newton, I, Officer Conary, met with the Operator of MV1 in the lobby for a report of a past hit and run. Operator of MV1 explained to me that on 01/21/2022, she parked MV1 on Walnut Street in front of 1175 at the parking meters. Approximately after an hour or two, she returned to MV1 and saw that there was damage to the front bumper. I did not respond to the accident. MV1 was able to be driven from scene.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3214071
Longitude:
-71.2062807
Location:
1175 Walnut St, Newton Highlands, MA 02461, USA
Case number:
22000061
Date:
2022-01-22
Time:
18:25
Address:
195 ADAMS ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 said he was traveling south bound on Adams street and a vehicle traveling north bound had it's high beams on. Operator of MV1 said this caused him to pull quickly to the right and he could not see initially. Operator of MV1 said he struck MV2 which was parked in front of 195 Adams Street. MV1 had damage to the front passenger bumper. MV2 had damage to the rear driver side bumper. There were no injuries and MV1 was towed away by Tody's. Owner of MV2 arranged for his vehicle to be towed privately. A towed motor vehicle form was filled out and placed in its proper location.
Keywords:
[]
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3582404
Longitude:
-71.2003053
Location:
195 Adams St, Newton, MA 02458, 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 353.191ms