crash_reports
2 rows where "datetime" is on date 2022-02-13 and dcc = "["Unknown"]"
This data as json, CSV (advanced)
Suggested facets: 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:
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);