crash_reports
3 rows where "datetime" is on date 2019-08-07, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, 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:
Case
number:
Date:
2019-08-07
Time:
17:07
Address:
400 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 states she was traveling eastbound on Washington St behind vehicle2 when that vehicle stopped quickly due to another vehicle in front of her coming to a quick stop. As a result vehicle 1 rear ended vehicle 2. Both operators stated there was another vehicle in front of them that stopped quickly causing a chain reaction. Neither driver was injured. Neither vehicle required a tow.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3559661
Longitude:
-71.18448
Location:
Case
number:
Date:
2019-08-07
Time:
11:40
Address:
2014 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 8/7/2019 at approx 1140hrs while assigned to 497 I responded to 2014 Washington St, NWH west entrance for a report of a two car crash without injuries. Upon arrival I spoke with the operators of Ma Reg 2GF281 Kira WIRSIG and Ma Reg LV56933 Yevhen ROITBERH. WIRSIG stated she was travelling straight ahead in the right EB lane when ROITBERH turned right into her vehicle from the left EB lane causing the collision. ROITBERH stated he was turning right into NWH from the right EB lane when WIRSIG attempted to pass him on the right . WIRSIGS passenger Christopher BERRY agreed with her version. ROITBERH had photos on his phone of his vehicle in the right lane turning into NWH which he claims show he had the right of way.
Keywords:
Crash, Phone, Pictures
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);