crash_reports
4 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2022-03-31
Time:
11:38
Address:
2095 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED SHE PARKED HER CAR IN THE STARBUCKS PARKING LOT AND WHILE SHE ENTERED THE STORE TO PICK UP HER COFFEE, AND UNKNOWN MV STRUCK HER FRONT RIGHT BUMPER CAUSING DAMAGE. THERE WERE NO WITNESSES TO THE CRASH AND THE CAMERAS INSIDE STARBUCKS DON'T SHOW WHERE THE ACCIDENT OCCURRED.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3483491
Longitude:
-71.2475839
Location:
Case
number:
Date:
2022-04-08
Time:
15:31
Address:
10 CHAMPA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV2 operator states he was backing his Amazon work truck back to Cottage St and was watching for the low hanging tree branches when he did not see and struck MV1. Minor damage was observed on both vehicles. Both vehicles were damaged on their rear left bumpers. MV1 was parked at the time and unoccupied. The registered owner was notified and given all appropriate information. No injuries on scene and no tows needed.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3130025
Longitude:
-71.218309
Location:
Case
number:
Date:
2022-04-12
Time:
09:15
Address:
197 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday April 12th 2022 at approximately 0915 hours I responded to the area of 197 California Street for a city of Newton fire truck that struck a fire hydrant while responding to an emergency. At the time of the accident the weather was cloudy and the road surface was dry. California Street is owned and maintained by the city of Newton. Upon arrival I spoke with the operator of Newton Fire Engine 1 identified as Joseph Frank. Joseph stated that while attempting to park the fire engine he struck the fire hydrant, causing the fire hydrant to be knocked over and inoperable. Minor damage to the front drivers side of the fire engine was photographed and submitted to the IT Bureau as well as the damaged fire hydrant. No injuries were reported. City of Newton was notified of the damaged hydrant.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
Location:
Case
number:
Date:
2022-04-12
Time:
17:15
Address:
88 HARVARD ST
Speed
limit:
20
Violation
cited:
no
Narrative:
On 4/12/22 I took a Hit and run report at the front desk that occurred at 88 Harvard St. between 4/8/22 and 4/9/22. The owner of MV1 stated that she parked her car in front of her house on 4/8/22 at approx. 1900Hrs. When she came to her car on 4/9/22 at approx. 1600Hrs she noticed that her front right mirror was missing. She stated that she mirror was hit by an unknown MV and was left on the ground broken. There was also as minor scratch on her right door that was caused by the unknown MV. There were no cameras in the area and she is unsure of who might of hit her car.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3496472
Longitude:
-71.2011175
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);