crash_reports
3 rows where keywords contains "School" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-05
Time:
10:35
Address:
TIGER DR
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 6-5-19 AT APPROX. 1035HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT TIGER DRIVE I SPOKE TO THE OPERATOR OF VEHICLE #1. SHE STATES SHE WAS WORKING AS A UBER DRIVER AND GIVING A RIDE TO PASSENGER ( ARSEMA KIFLE ). SHE STATES SHE PULLED TO THE RIGHT AND PARKED HER VEHICLE TO LET HER PASSENGER EXIT. BEFORE HER PASSENGER COULD GET OUT SHE WAS HIT IN THE REAR BY VEHICLE #2 AND PUSHED FORWARD INTO THE EVERSOURCE TELEPHONE POLE ON THE SIDEWALK.OPERATOR OF VEHICLE #2 STATES HE WAS TRAVELING S-BOUND ON WALNUT BEHIND VEHICLE #1. HE STATES VEHICLE #1 STOPPED ABRUPTLY AND HE WAS UNABLE TO AVOID HITTING HER. VEHICLE #1 HAD EXTENSIVE REAR AND FRONT END DAMAGE AND WAS TOWED BY TODYS. VEHICLE #2 HAD EXTENSIVE FRONT END DAMAGE AND MULTIPLE AIR BAG DEPLOYMENT AND WAS ALSO TOWED BY TODYS. OPERATOR OF VEHICLE #1 WAS TRANSPORTED TO NEWTON WELLESLEY HOSPITAL FOR POSSIBLE WRIST INJURY. PASSENGER WAS ALSO TRANSPORTED TO CHECK FOR POSSIBLE INJURIES. OPERATOR AND PASSENGER OF VEHICLE #2 WERE EXAMINED BY MEDICS AND BOTH REFUSED MEDICAL TREATMENT. BOTH OCCUPANTS OF VEHICLE #2 HAD CUTS ON LEGS AND WRISTS ASSOCIATED WITH AIRBAG DEPLOYMENT. THEY WERE ESCORTED TO SCHOOL BY NEWTON NORTH STAFF TO BE EVALUATED BY THE SCHOOL NURSE. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Airbag, Crash, Hospital, School, Severe
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3450748
Longitude:
-71.2065446
Location:
Case
number:
Date:
2020-02-02
Time:
14:10
Address:
165 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 02/02/20 at approximately 14:10 I met with Bobson Berleus who parked his fathers car (Mass Reg#542DV3 -2003 Toyota Camry Grey) in a parking spot outside of Boston Ballet School at around 06:00 while he went to work inside T.J. Maxx. When Berleus returned to the vehicle at around 14:00, he found that it had been struck on the front drivers side fender. I spoke with Stop & Shop Manager Jim Boucher (where Berleus also works) and he was going to look at security footage of today and try to see if he could locate the accident. There are no cameras from the Ballet School in the direction where Berleus parked. ************************UPDATE*************************** As of my 02/09/20 at approximately 11:00, I have yet to hear back from Manager Jim Boucher or anyone else from Stop & Shop. I will now consider this investigation closed unless I am contacted in the future with new information.
Keywords:
Crash, School
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2022-03-10
Time:
14:30
Address:
24 PROSPECT PL
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that he observed a vehicle coming from behind that he tried to avoid a collision with. This then led to the collision with Vehicle #2. The operator of Vehicle #2 stated that she was travelling her School Bus van westbound on Prospect Pl when her vehicle was struck on the passenger side by Vehicle #1 as he attempted to pass her. Vehicle #2 was carrying 4 students, all parties involved were checked by medics before being released to their parents. Vehicle #1 was towed by Tody's Towing Co., and Vehicle #1 was parked for a private tow at a later time.
Keywords:
Bus, School
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3467503
Longitude:
-71.233074
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);