crash_reports
1 row where "datetime" is on date 2019-08-07, intersection = 0 and keywords contains "Tree"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-07
Time:
09:43
Address:
144 EAST SIDE PKWY
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of vehicle # 1 stated she was travelling Northbound on East side parkway. Operator #1 stated as she approached a curb bump out that narrowed the roadway, an oncoming unkown(no description) vehicle sped up around a parked vehicle and entered vehicle # 1's travel lane. Operator #1 was forced to swerve to the right to avoid a collision . The cargo portion of the truck collided with a large branch of a city tree overhanging the road which then uprooted the tree. Photos of the crash were taken by traffic. Eversource responded to the scene and the tree was removed by the city. The home owner of 152 East side Parkway was not home at the time of the incident. I spoke to the home owner Mr. Hans Hinteregger on 08/19/2019. Mr. Hinteregger stated that his residence sustained damage when the power line was pulled from the side of his house. The crash drawing and property information has been updated with the homeowners information.
Keywords:
Crash, Pictures, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.34935
Longitude:
-71.1964416
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);