crash_reports
1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2021-10-11
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-07
Time:
08:57
Address:
WARREN ST & LANGLEY RD
Speed
limit:
30
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED THAT HE WAS STOPPED AT THE INTERSECTION OF WARREN ST AND LANGLEY ROAD. WARREN ST IS A ONE WAY WITH A STOP SIGN. THE OPERATOR THEN STATED HE PRECEDED THROUGH THE INTERSECTION AND WAS STRUCK BY MV#2. THE OPERATOR OF MV#2 STATED HE WAS TRAVELING N-B ON LANGLEY ROAD WHEN MV#1 PULLED OUT IN FRONT OF HIS VEHICLE WHICH CAUSED THE COLLISION. MV#1 AFTER THE IMPACT WAS FORCED UP ONTO THE SIDEWALK DAMAGING A CITY "NO PARKING" SIGN. OFFICER WILSON TOOK PICTURES OF THE CITY PROPERTY DAMAGE. AS THE OPERATOR OF MV#1 WAS BEING EVALUATED BY THE MEDICS I ASKED HIM IF HE HAD ANY INJURIES AND HE STATED HE DID NOT. I THEN INFORMED HIM THAT HE HAD A STOP SIGN AT THE INTERSECTION WHICH HE AGREED BUT STATED HE DID NOT SEE MV#2 WHILE PULLING OUT ONTO LANGLEY ROAD. I INFORMED THE OPERATOR OF MV#1 THAT BASED ON THE STATEMENTS FROM BOTH HIM AND THE OPERATOR OF MV#2, I MADE THE DETERMINATION THAT HE WAS AT FAULT, FAILED TO YIELD, AND THAT OPERATOR OF MV#2 HAD THE RIGHT OF WAY. I INFORMED THE OPERATOR OF MV#1 THAT I WOULD NOT BE ISSUING HIM A CITATION AT THIS TIME. THE OPERATOR OF MV#1 THEN BECAME ARGUMENTATIVE INSIDE THE AMBULANCE STATING TO ME "GET THE HELL AWAY FROM ME I AM DONE WITH YOU". THE OPERATOR OF MV#1 SIGNED A PATIENT REFUSAL AND MV#1 WAS TOWED BY TODY'S. MV#1 HAD MAJOR DAMAGE TO THE DRIVERS REAR, SIDE, AND FRONT, ALONG WITH SIDE AIR BAG DEPLOYMENT. MV#2 HAD DAMAGE TO THE P/S FRONT BUT WAS ABLE TO DRIVE AWAY. IT APPEARED THAT THERE COULD POSSIBLY BE UNDERLINING DAMAGE TO MV#2.
Keywords:
Citation, Crash, Ems, Pictures
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3295817
Longitude:
-71.1904635
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);