crash_reports
4 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2020-10-14
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-09-23
Time:
16:08
Address:
19 WOODBINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 (Cataldo Ambulance) travelling North on Woodbine St. struck the driver side mirror and driver side rim of MV2 that was parked on the side of the road. MV1 stated there were vehicles parked on both sides of the street. Pictures of the road and of the damage of both vehicles were taken and sent to the IT Bureau to be attached to this report. Driver of MV 1 stated he was unsure if the damage on the vehicle was old or new. Owner of MV 2 was on scene and was given a crash report number for insurance purposes.
Keywords:
Crash, Ems, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3463429
Longitude:
-71.2517603
Location:
Case
number:
Date:
2020-10-05
Time:
12:53
Address:
1763 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/05/20 Sgt Giardina notified me that he was flagged down by a person who wished to remain anonymous that stated they had seen a niisan maxima strike a tree and two trash barrels in front of 1763 Commonwealth Ave. On arrival I saw two City of Newton trash barrels destroyed and a city tree down on its side on the sidewalk. There were skid marks going back out onto the road westbound on Commonwealth Ave. I was able to notify the homeowner, Melissa Woythaoer who stated she was upstairs and never heard anything. Units canvassed the area with negative results. Officer Gaudet took pictures of the damage.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.341503
Longitude:
-71.2385206
Location:
Case
number:
Date:
2020-10-07
Time:
17:53
Address:
11 MOSSFIELD RD
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated she was traveling Westbound of Mossfield Rd when a large tree fell on top of her car. The tree which belongs to 11 Mossfield Rd landed on the hood, windshield and front half of the roof. The impact caused major damage to the vehicle. The occupants were able to exit the vehicle and reported no injuries. Pictures of the incident were taken by me and submitted to IT.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3257898
Longitude:
-71.2411798
Location:
Case
number:
Date:
2020-10-09
Time:
15:13
Address:
2044 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was traveling Westbound on Beacon St when the vehicle in front of her vehicle struck a low hanging tree branch that landed on top of her vehicle. Branch caused minor damage to the windshield. OPMV#1 Stated she was driving behind a truck on Beacon St and when the truck was entering the turn lane to turn right on Washington St a branch from a tree broke off and landed on her car.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3297408
Longitude:
-71.2478316
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);