home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Unknown", "retrieved" is on date 2021-01-08 and speed_limit = 15

✎ 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:
2000000733
Date:
2020-12-13
Time:
15:29
Address:
33 BOYLSTON ST
Speed limit:
15
Violation cited:
no
Narrative:
Vehicle #1 was parked in a legal parking spot when Vehicle #2 was attempting to back out of the spot to the right of Vehicle #1. Vehicle #2 clipped the right side of Vehicle #1 with the left side of Vehicle #2. Vehicle #1 had minor damage to the rear fender and a scrape on the right side by the rear tire well. Vehicle #2 has unknown damage. Vehicle #2 left the scene without exchanging any info. Vehicle #1 was unoccupied at the time of the accident. All Vehicle information of Vehicle #2 was given to police by a witness. Witness information has been entered into the crash report.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3227864
Longitude:
-71.1687194
Location:
33 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
2000000767
Date:
2020-12-22
Time:
18:06
Address:
30 TOWER RD
Speed limit:
15
Violation cited:
no
Narrative:
On Tuesday 12/22/2020, at approximately 1730 hours, I, Ofc Donald Murphy, met a party at the front desk in regards to a hit and run incident. I spoke with Andrew Shvetts, who stated his wife Tetianna Shvets's vehicle was struck today in the parking lot of Baza grocery market from 10 am-11 am. The owner of MV 1, Tetianna Shvets was shopping at Baza grocery market while her vehicle, MV 1, was parked in the parking lot. When Tetianna returned to her vehicle there was a note on her windshield stating MV 2 struck her vehicle "possibly" on the right rear side and left the scene. The plate of the vehicle was left on the note as well. There was no contact information of the witness left on the note or any manner of collision. There was minimal damage (a few scratches) on MV 1. Andrew provided photos of the damage to the vehicle and the note left on the windshield.The photos of the damage and note are attached to this report. The plate came back to 79 Wheeler Rd in Newton. I went to the address to follow up with the operator of MV 2. I spoke with the owner and operator of MV 2, Mrs. Lyuba Regelman. Lyuba admitted to shopping at Baza grocery market today. Lyuba denied hitting MV1 and there was no damage to her vehicle I could see that matched the damage from the incident. I will not be seeking charges on Lyuba for leaving the scene because there is no contact information of the witness and there is no matching damage to MV 2.
Keywords:
Pictures
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3102612
Longitude:
-71.2156323
Location:
30 Tower Rd, 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 473.26ms