crash_reports
3 rows where "datetime" is on date 2019-07-13, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-13
Time:
10:51
Address:
390 NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS GOING E/B ON NEWTONVILLE AVE WHEN ANOTHER VEHICLE COMING FROM THE OPPOSITE DIRECTION(W/B) AT A HIGH RATE OF SPEED FORCED HER TO SWERVE TO HER RIGHT CAUSING HER TO COLLIDE WITH TWO PARKED VEHICLES IN FRONT OF #390 NEWTONVILLE AVE. OPERATOR#1 FURTHER STATED DUE TO CARS PARKED ON THE E/B SIDE OF NEWTONVILLE AVE IT FORCES EASTBOUND TRAFFIC ONTO THE WRONG SIDE OF THE ROAD TO GET BY. SHE REPORTS THAT SHE WAS HAD NOWHERE TO GO WHEN VEHICLE #2 WAS COMING AT HERE. VEHICLE #2 COULD HAVE YIELDED TO HER VEHICLE. I OBSERVED NUMEROUS LEGALLY PARKED CARS ON THE EAST SIDE OF NEWTONVILLE AVE. HOWEVER FOR TRAFFIC TO DRIVE ON THE EAST SIDE OF NEWTONVILLE AVE THEY HAVE TO DRIVE ON WRONG SIDE TO GET BY. DUE TO NEWTONVILLE AVE BEING A NARROW RD WHEN CARS PARK ON THE EAST SIDE WHICH IS LEGAL THEY(PARKED CARS ) TAKE UP THE WHOLE EAST SIDE OF THE ROAD. BASED ON MS ROSENSWEIG STATEMENT I FEEL SHE HAD THE RIGHT OF WAY. VEHICLE #2 SHOULD HAVE YIELDED SEEING THAT VEHICLE #1 HAD NOWHERE TO GO. THERE WAS NO DESCRIPTION TO THE VEHICLE THAT CAUSED THIS CRASH.
Keywords:
Crash, Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3505456
Longitude:
-71.2034961
Location:
Case
number:
Date:
2019-07-13
Time:
13:14
Address:
1353 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 was parked unoccupied in a marked space in front of 1353 Washington St W/B. An anonymous witness reported #1 was sideswiped there by a light colored MV (#2) bearing partial NH reg 333. I later located Mv#2 a white Subaru NH reg 333 3334, parked in the West Newton Municipal lot directly behind 1353 Washington St. I also met the #2 operator who stated, while pulling out forward, #2 front passenger side bumper sideswiped #1 driver's side rear bumper. Both vehicles sustained minor damage. All parties were advised and satisfied with this investigation and documentation of this collision. No further police action at this time.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3490847
Longitude:
-71.2286499
Location:
Case
number:
Date:
2019-07-13
Time:
17:19
Address:
210 NAHANTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Saturday 7/13/19 at approximately 1719 hours I was dispatched to the parking lot of 210 Nahanton Street for a report of a past hit and run. Upon arrival I spoke to the operator, Rachel Namutebi, who states that she parked her car at 3pm on 7/10/19 and when she came out on 7/11/19 at 11am she noticed that the passengers side door had been struck by another vehicle causing damage to her car. She states she spoke with building security and they stated that the video surveillance does not video that part of the parking lot.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2969814
Longitude:
-71.1958963
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);