crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-09-26
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-09-14
Time:
11:31
Address:
141 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The owner of veh #1 stated she parked her vehicle in the parking lot of #141 Needham St (Sierra Trading Post & T.J. Maxx) at approximately 11:00. When she returned around 11:30, she noticed her rear drivers side quarter panel had been struck by a white vehicle. It appears the other vehicle struck her car as it was either pulling in or out of the parking space. I searched the lot for the other vehicle but was unable to locate it. I then went inside the Sierra Trading Post and spoke with the manager regarding security cameras. He stated that neither his store nor T.J. Maxx had cameras facing the parking lot.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
Location:
Case
number:
Date:
2021-09-16
Time:
16:40
Address:
45 WILLIAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of Vehicle 1,Mary Malloy, stated that at approximately 1630hrs she heard a loud bang out in front of 45 William Street. Malloy stated she went out front and observed a blue dump truck driving southbound on William Street. Malloy said she was unable to see any writing on the vehicle. Malloy said she saw there was damage done to her vehicle. The front driver side bumper was hanging off and there was scratches starting from the rear driver door all the way up to the front driver side door causing the driver side mirror to be taken off as well. Malloy was visiting her friend, Barbara Harteln, who lives at 45 William Street. Harteln has a ring camera which catches the blue dump truck driving southbound on William Street. However Harteln informed me the camera did not pick up Malloy's vehicle being struck. I provided Harteln with my department email and advised her to send me the footage from her ring camera. I canvassed the neighborhood and was unable to find any other cameras near 45 William Street. I provided Malloy with the crash report number to this incident and advised her to contact her insurance company and to take photographs of her vehicle. Malloy said she was going to contact AAA to come and tow the vehicle to a dealership near her house in Hingham.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3574819
Longitude:
-71.2354718
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);