crash_reports
1 row where dcc contains "Unknown", latitude = "42.3510472" and "retrieved" is on date 2022-01-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-15
Time:
11:36
Address:
LOWELL AVE & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-15-22 AT APPROX. 1136HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF LOWELL AVE. AND WASHINGTON ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING E-BOUND ON WASHINGTON ST. SHE APPROACHED THE INTERSECTION AND STATES SHE WAS CUT OFF BY A BLACK SUV ( VEHICLE #5 ) THAT WAS TRAVELING W-BOUND AND TRYING TO TURN LEFT ONTO LOWELL AVE. SHE SWERVED TO AVOID HITTING VEHICLE #5 AND STATES THE NEXT THING SHE REMEMBERS SHE HAD HIT VEHICLE #2 AND WAS TRYING TO GET OUT OF HER VEHICLE BECAUSE SHE THOUGHT IT WAS ON FIRE. OPERATOR OF VEHICLE #2 STATES SHE WAS TRAVELING N-BOUND ON LOWELL AVE AND WAS STOPPED AT THE RED LIGHT. SHE DID NOT SEE VEHICLE #1 COMING AT HER UNTIL SHE WAS ACTUALLY HIT. OPERATOR OF VEHICLE #3 STATES HE WAS TRAVELING N-BOUND ON LOWELL AVE AND WAS STOPPED AT THE RED LIGHT. HE STATES HE NEVER NOTICED VEHICLE #1 UNTIL SHE PUSHED VEHICLE #2 INTO HIM BECAUSE HE WAS FOCUSED ON THE TRAFFIC LIGHT. DRIVER OF VEHICLE #4 STATES HE WAS TRAVELING N-BOUND ON LOWELL AVE AND WAS STOPPED AT THE RED LIGHT BEHIND VEHICLE #3. HE DID NOT NOTICE VEHICLE #1 UNTIL SHE PUSHED VEHICLE #2 INTO THE FRONT OF HIS VEHICLE. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE AND FRONT AIRBAG DEPLOYMENT AND WAS TOWED BY TODYS. OPERATOR OF VEHICLE #1 WAS TRANSPORTED BY MEDICS TO NEWTON WELLESLEY HOSPITAL FOR NON-FATAL INJURY-POSSIBLE. VEHICLE #2 HAD EXTENSIVE LEFT SIDE AND RIGHT SIDE DAMAGE AS WELL AS AIRBAG DEPLOYMENT AND SHATTERED GLASS AND WAS TOWED BY TODYS. BOTH PARTIES IN VEHICLE #2 WERE TRANSPORTED TO NEWTON WELLESLEY HOSPITAL BY THE MEDICS FOR NON-FATAL INJURY- POSSIBLE. VEHICLE #3 HAD LEFT SIDE MOTOR VEHICLE DAMAGE AND WAS TOWED BY TODYS. DRIVER STATED HE HAD NO INJURIES AND SIGNED A PATIENT REFUSAL. VEHICLE #4 HAD LEFT FRONT END DAMAGE AND WAS TOWED BY TODYS. DRIVER REPORTED NO INJURIES AND SIGNED A PATIENT REFUSAL. THE OPERATOR OF VEHICLE #5 ORIGINALLY LEFT THE SCENE AND THEN RETURNED. HE STATED HE WAS TRAVELING W-BOUND ON WASHINGTON AND WAS HALFWAY COMPLETED TURNING LEFT ONTO LOWELL AVE. DRIVER STATES HE INTENDED TO COMPLETE THE TURN ONCE VEHICLE #1 HAD PASSED. HE STATES WHILE WAITING HE SAW VEHICLE #1 TURN RIGHT ABRUPTLY AND SEEMED TO LOSE CONTROL OF THE VEHICLE BEFORE SMASHING INTO VEHICLE #2 AND CAUSING SUBSEQUENT COLLISIONS. VEHICLE #5 HAD NO DAMAGE AND WAS NOT INVOLVED IN THE CRASH. OPERATOR OF VEHICLE #5 REPORTED NO INJURIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Fire, Hospital, Severe
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);