crash_reports
3 rows where date = "2020-12-22" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-22
Time:
11:56
Address:
1357 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that she was traveling Westbound on Washington Street and as she was slowing down for the red light was struck from behind by motor vehicle #2. Motor vehicle #1 sustained moderate rear end damage. Operator of Motor Vehicle #2 stated that he was traveling Westbound on Washington Street and due to the glare of the sun struck motor vehicle #1 from behind. Motor vehicle #2 sustained moderate front end damage. There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Crash, Glare, Moderate, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3489391
Longitude:
-71.2286452
Location:
Case
number:
Date:
2020-12-22
Time:
16:03
Address:
415 PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling southbound on Parker Street when she began to get drowsy and she believes she turned the steering wheel to the right, which caused her to strike a tree and roll over onto the snow bank. MV1 was upright on its side when a passerby assisted the operator in getting out through the passenger side door. Operator of MV1 sustained no visible injuries and was evaluated by Cataldo and transported to NWH. Bobby Donahue of Tody's Towing towed the vehicle which had damage moderate damage.
Keywords:
Moderate, Snow, Tree
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3132574
Longitude:
-71.1963487
Location:
Case
number:
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:
Image
url:
Latitude:
42.3102612
Longitude:
-71.2156323
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);