crash_reports
4 rows where dcc = "["Visibility obstructed"]" and speed_limit = 20
This data as json, CSV (advanced)
Suggested facets: intersection, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-17
Time:
14:36
Address:
PROSPECT ST
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of MV #1 (MA reg 466xd6) stated she was traveling eastbound on Prospect St. towards Washington St. when her vehicle was struck on the rear driver's side door by MV2. The operator of MV #2 (Pupils reg 108630) stated he was pulling out of the parking lot of the Learning Prep School, 1507 Washington St. when he collided into the passenger side of MV #1. The operator of MV#2 stated they looked in both directions prior to turning westbound onto Prospect St. but a vehicle parked by the school parking lot exit obscured his view of traffic. Heavy damage was observed to the passenger side door of MV#1. Minor damage to the driver side bumper was observed on MV #2. The operator of MV #1 along with her passengers were not injured and declined medical attention. The operator of MV #2 along with the children inside were not injured and declined medical attention. Tody's Towing Service arrived on scene and towed MV #1 from the scene. MV #2 was able to be driven away the scene.
Keywords:
School
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.345081
Longitude:
-71.2327375
Location:
Case
number:
Date:
2021-01-09
Time:
07:27
Address:
1321 WASHINGTON ST
Speed
limit:
20
Violation
cited:
no
Narrative:
ON 1-9-21 AT APPROX. 0727HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE REAR OF 1321 WASHINGTON ( NEWTON POLICE STATION PARKING LOT ) I SPOKE TO THE DRIVER OF VEHICLE #1. DRIVER STATES SHE WAS BACKING HER PERSONAL VEHICLE INTO ONE OF THE PARKING STALLS AT THE REAR OF THE POLICE STATION. SHE STATES WHILE BACKING SHE LIGHTLY TAPPED THE FRONT OF NEWTON POLICE VEHICLE 1309 WITH THE REAR OF HER VEHICLE. DRIVER STATES THERE WAS NO DAMAGE TO HER VEHICLE. THERE WAS A SLIGHT SCRAPE TO THE FRONT FENDER OF NEWTON VEHICLE 1309. DRIVER STATES HER VISIBILTY WAS OBSTRUCTED BY THE SUN SHINING IN THE REAR VIEW MIRROR. WHEN HER REAR PROXIMITY ALARM FAILED TO SOUND SHE THOUGHT SHE HAD CLEARED VEHICLE #2. APPROX. 8 PICTURES WERE TAKEN BY NEWTON 491 ( OFF CONARY ) AND WERE PLACED IN I.T. BOX. DRIVER REPORTED NO INJURIES. DRIVER ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash, Pictures, Solar
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
Case
number:
Date:
2021-09-06
Time:
12:47
Address:
189 WATERTOWN ST
Speed
limit:
20
Violation
cited:
no
Narrative:
On September 6th, 2021 at approximately 12:47 hours while working N491 I responded to the parking lot to Stop and Shop Plaza, #171 Watertown St, for a report of a crash near Planet Fitness. On my arrival I located both involved vehicles near the CVS. Vehicle #1 was a 2015 Honda Civic, MA reg. 7zg316, operator identified as JITENDIA MISHRA. He reported travelling N/B in the parking lot to the plaza when he had to stop due to vehicle #2 had stopped in front of him. Vehicle #2 suddenly backed up into his vehicle hitting his drivers side front. Vehicle #2 was a 2009 black Toyota RAV4, NY plate HFJ2619, operator identified as Madeleine Lesser. She stated she was in the parking lot of the plaza when she observed a car backing out from a parking space in front of her. She then stopped her vehicle and allowed that vehicle to proceed out. She then had to back up a little to allow room for that other vehicle to back out. She never saw vehicle #1 right behind her. She then backed into the drivers side front quarter. There were no tows or injuries to this crash.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3637788
Longitude:
-71.1943201
Location:
Case
number:
Date:
2021-09-08
Time:
13:58
Address:
BEACON ST & PAULSON RD
Speed
limit:
20
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was attempting to take a left hand turn from Paulson Rd. (southbound), onto Beacon St. (eastbound), when motor vehicle 2 (MV2), which was traveling eastbound on Beacon St., crashed into the passengers side of MV1. As a result of the crash MV1 sustained moderate passengers side damage, while MV2 sustained moderate front end drivers side damage.
Keywords:
Crash, Moderate
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.330642
Longitude:
-71.2180604
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);