crash_reports
2 rows where dcc_code = "[99]", speed_limit = 10 and time = "08:30"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-28
Time:
08:30
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated she came out of work at NWH at 0730hrs and noticed the passenger front of her vehicle was damaged. She stated that she parked her vehicle in the that space at 2330hrs the night before. I observed significant damage to the passenger front of the vehicle. It should be noted that I did not observe and parts on the ground or any debris indicating that the accident occurred in that location. The headlight was totally shattered out and there were missing parts from vehicle. There was also a fluid trail that appeared to be leaking from the front passenger side. This trail indicated that the vehicle was driven and backed in to the parking space after the collision took place. Based on my training and experience I do not believe that vehicle was struck in that location as a hit and run. There were no cameras in the area. The owner requested her own tow for the vehicle. I submitted a photo of the claimed hit and run scene to the IT bureau and it was attached to this accident report.
Keywords:
Crash, Night, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Case
number:
Date:
2021-07-13
Time:
08:30
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 7/13/2021 at approx 0858HRS while assigned to 497 I responded to Newton Wellesley Hospital, West Entrance 2014 Washington St for a report of a hit and run in the parking lot. Upon arrival I met with Heather Devoe who stated she had parked her husbands 2018 Chevy Tahoe Ma Reg 7775BK in the parking lot at approx 0830HRS, upon her return at approx 0855HRS she discovered minor damage to her rear driver side bumper. The bumper had minor dark transfer of either dark paint or tire . Heather stated she had observed a dark sedan very close to her when she parked but had no other information. Heather spoke with NWH Security who stated they would check their cameras and see if they found anything.
Keywords:
Hospital
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);