crash_reports
1 row where "datetime" is on date 2019-06-05, intersection = 0 and keywords contains "Severe"
This data as json, CSV (advanced)
Suggested facets: 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:
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);