home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where keywords = "["Pictures"]" and "retrieved" is on date 2022-07-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, hit_run, 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:
22000438
Date:
2022-05-22
Time:
21:21
Address:
BOYLSTON ST & CHESTNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV1 stated she was traveling northbound on Chestnut Street approaching Boylston Street intersection. As she approached the intersection, MV2 failed to stop at the stop sign and crossed the intersection, hitting MV1. The operator of MV1 stated MV2 pulled over and the operator of MV2 and the passenger began to speak Chinese and take photos of the damage. After taking photos MV2 drove away. The operator of MV1 was not injured. MV1 had damage to the front bumper. Traffic Bureau update (Officer Gaudet): I attempted to make contact with the registered owner of MV2, Ping Wei Want, with a negative result. A "Hit and Run" inquiry was mailed to their registered address.
Keywords:
Pictures
Dcc:
Signs/Signals
Report url:
report
Image url:
image
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Boylston St & Chestnut St, Newton, MA 02464, USA
Case number:
22000547
Date:
2022-06-20
Time:
13:42
Address:
124 LANGLEY RD
Speed limit:
35
Violation cited:
no
Narrative:
On June 20, 2022 at approximately 1342 hours, I responded to 124 Langley Rd for a report of an MVA. Upon arrival, I spoke with owner of MV2 who stated a man named Patrick Fabrizio saw MV1 strike their MV and continue down the road(see Patricks witness statement). The owner of MV2 stated their vehicle was parked outside of 124 Langley Rd when the incident occurred. I observed damage to the driver's side mirror. Patrick was able to take a photo of MV1 plate and I was able to contact the owner and coordinate an exchange of information among the Owners. Owner of MV1 states she was driving WB on Langley Rd when she struck MV2 side mirror. No injuries or tows to be reported.
Keywords:
Pictures
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3287678
Longitude:
-71.1893408
Location:
124 Langley Rd, Newton, MA 02459, USA
Case number:
22000595
Date:
2022-07-03
Time:
15:37
Address:
MILL ST & MORTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 said she was traveling Eastbound on Mill Street. Operator of MV1 said she looked down for a second then when she looked up she did not have enough time to stop and struck the Utility pole (Pole 28/23). There was very minor damage to the Utility pole. There was air bag deployment and Fallon Medics came and evluated Operator of MV1. Operator of MV1 signed a patient refusal. There was heavy front end damage to MV1 and MV1 was towed away by Todys. I filled out a towed motor vehicle sheet and took pictures of the Utility pole.
Keywords:
Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None

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.344ms