crash_reports
4 rows where "datetime" is on date 2022-07-20 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-07-20
Time:
12:23
Address:
16 HARTFORD ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated she parked her vehicle in the municipal parking lot located at 16 Hartford St. When she returned to her vehicle she observed MV#2 (Parked behind her vehicle) touching her rear bumper. The owner of MV#1 stated she had parked her vehicle approximately 1.5 hours ago and MV#2 was not parked behind her previously. The owner of MV#1 showed me her parking receipt (Parking space #5548) and it displayed a time stamp of 11:19 AM. The owner of MV#2 arrived shortly after and stated to me, "don't give me a ticket. I'm leaving". I stated to the owner of MV#2 that I responded for a vehicle accident and not for a parking violation. I showed the owner of MV#2 that the front of her vehicle was touching the rear of MV#1 and she stated that MV#1 hit her vehicle instead of the other way around. The owner of MV#2 stated she had parked her vehicle (Parking space #5549 ) approximately 40 minutes prior to my arrival but did not have a parking receipt because she never paid for parking. The owner of MV#2 stated she may not have been aware she made contact with MV#1 when she parked her vehicle. Both involved vehicles were unoccupied during this accident. both vehicle owners exchanged information and were advised to notify their insurance providers. There were minor/ non visible damages to the rear end area of MV#1 and minor/ non visible damages to the front end of MV#2.
Keywords:
Citation, Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3210731
Longitude:
-71.2076694
Location:
Case
number:
Date:
2022-07-20
Time:
12:30
Address:
290 GROVE ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Owner states sometime between the evening of July 16, 2022 and the morning of July 17, 2022, his vehicle was parked unoccupied in the parking lot unoccupied next to his residence and was struck on it's drive side by an unknown vehicle. I observed damage to the rear passenger side door/fender area. No cameras are present in the area. No vehicles parked in the lost appeared to have fresh damage. Owner of vehicle was advised.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-07-20
Time:
11:08
Address:
AUSTIN ST & LOWELL AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 stated that he was traveling northbound on Lowell Ave. when he was struck on the passenger side by a vehicle coming from Austin St. MV2 confirmed this and stated that she did not notice the stop sign as she approached the intersection of Austin St. and Lowell Ave. The involved parties exchanged information on site and requested an accident report.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3502544
Longitude:
-71.2108899
Location:
Case
number:
Date:
2022-07-20
Time:
19:40
Address:
31 WEBSTER
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling eastbound on Webster Street when it collided with unoccupied parked MV2. MV1 sustained damage to the front passenger side fender. MV2 sustained damage to the drivers side ranging from the rear of the vehicle to the front. No injuries were reported. MV1 was still operable. Owner of MV2 responded to headquarters after the incident and confirmed her information. MV1 operator showed us her valid driver's license from Uganda. Ms. Kaboyo was advised to obtain a MA driver's license.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3503952
Longitude:
-71.2281458
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);