crash_reports

Table actions

1 row where "datetime" is on date 2022-02-13 and geocoded_address = "325 Beacon St, Chestnut Hill, MA 02467, USA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

Case number:
22000148
Date:
2022-02-13
Time:
17:44
Address:
325 BEACON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 was parked out front of 325 Beacon St. when they believe MV2 hit the left rear end of their vehicle. There was no visible damage to the vehicle, no injuries, and no witnesses. MV2 took off from the scene. I attempted to get in contact with MV2 yielding negative results. To be further investigated. Traffic Bureau update (Officer Gaudet): I attempted to make contact with the registered owner of MV2, Ms. Lilya Polenov (S41505700), with a negative result. A "Hit and Run" inquiry was mailed to Ms. Polenov. Ms. Polenov contacted me on Friday, February 18, 2022, regarding this crash. Ms. Polenov stated that she was not operating her vehicle at the time fo the crash. Ms. Polenov stated she beleives her elderly father in law was operating the vehicle. Ms. Polenov stated she will speak with him and contact me with more information.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3333408
Longitude:
-71.1719303
Location:
325 Beacon St, Chestnut Hill, MA 02467, 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);