crash_reports
3 rows where dcc contains "Unknown" and "retrieved" is on date 2022-02-23
This data as json, CSV (advanced)
Suggested facets: date, intersection, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-02-13
Time:
18:56
Address:
241 COUNTRY CLUB RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 operator was travelling down hill on Countryside Rd when vehicle controls were lost and MV1 drove onto 241 Countryside Rd front lawn. Road conditions include snowing at the time of incident and slippery roads due to snow and ice. MV1 operator was able to remove vehicle from front lawn. no injuries reported. Homeowner, Richard Goldstone will speak with homeowners insurance about possible damage to lawn.
Keywords:
Ice, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3022406
Longitude:
-71.1892477
Location:
Case
number:
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:
Image
url:
Latitude:
42.3333408
Longitude:
-71.1719303
Location:
Case
number:
Date:
2022-02-16
Time:
18:10
Address:
CENTRE AVE & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 Operator states he was traveling straight ahead eastbound from the off ramp of I-90 interstate when he came to the rotary and rear ended MV2. MV1 sustained minor damage to the front left of the vehicle. MV2 Operator states he was stopped in traffic due to the traffic light when he was rear ended by MV1. MV2 sustained minor damage to the rear right of the vehicle. No injuries, no tows.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2924747
Longitude:
-71.0641639
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);