crash_reports
2 rows where dcc contains "Lane departure", keywords contains "Severe" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-27
Time:
12:51
Address:
CHESTNUT ST & OTIS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-27-2020 AT APPROX. 1251HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF CHESTNUT AND OTIS ST. I SPOKE TO THE OPERATOR OF VEHICLE #1 DRIVER STATES SHE WAS TRAVELING S-BOUND ON CHESTNUT ST. SHE STATES SHE DOES NOT RECALL FADING LEFT GOING OVER THE YELLOW LINE AND BANGING INTO VEHICLE #2. COMP. WAS TRANSPORTED BY MEDIC2 TO NEWTON WELLESLEY HOSPITAL FOR MINOR INJURIES AND TO POSSIBLY DETERMINE WHY SHE BLACKED OUT. VEHICLE #2 STATES HE WAS TRAVELING N-BOUND ON CHESTNUT. HE NOTICED VEHICLE #2 VEER INTO HIS LANE BUT BELIEVED SHE WAS GOING TO READJUST HER VEHICLE. HE STATES WHEN SHE DIDN'T HE WAS UNABLE TO AVOID HITTING HER. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE AND AIRBAG DEPLOYMENTS AND WAS TOWED BY TODYS. VEHICLE #2 HAD EXTENSIVE FRONT END DAMAGE AND WAS TOWED BY TODYS. OPERATOR OF VEHICLE #1 WAS TRANSPORTED TO NEWTON WELLESLEY HOSPITAL FOR MINOR INJURIES AND EVALUATION. OPERATOR OF VEHICLE #2 REPORTED NO INJURIES AND SIGNED A PATIENT REFUSAL. BOTH PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Hospital, Severe
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3449158
Longitude:
-71.2233968
Location:
Case
number:
Date:
2020-07-22
Time:
01:12
Address:
WATERTOWN ST & BRIDGE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 was operating westbound on Watertown St (public way). MV2 was parked on Watertown St in front of 144 Bridge St (public way). MV1 operator struck and side swiped MV2. MV2 sustained extensive damage. MV1 continued westbound on Watertown St and struck a cross walk sign and Newton Fire Department box which both in front of Coletti-Magni Park, and both were destroyed. MV1 hit and hopped the curb of Watertown St in front of Coletti-Magni Park, drove onto the side walk, and hit the fence of Coletti-Magni Park and damaged much of it. MV1 then came at rest on top of the Coletti-Magni Park fence and sustained extensive damage. MV1 operator stated he was not injured at this time and sign a patient refusal with Newton Medics. MV2 was unoccupied. Both MV1 and MV2 were towed by Todys.
Keywords:
Fire, Severe, Walk
Dcc:
Lane departure, Reckless driving
Report
url:
Image
url:
Latitude:
42.3604294
Longitude:
-71.20168
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);