crash_reports
1 row where "datetime" is on date 2021-04-25 and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-25
Time:
10:27
Address:
LAKEVIEW AVE & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 4-25-21 AT APPROX. 1027HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WALNUT ST. AND LAKEVIEW AVE. I SPOKE TO THE DRIVER OF VEHICLE #1. DRIVER STATES SHE WAS STOPPED IN THE INTERSECTION PREPARING TO TURN LEFT ON TO LAKEVIEW AVE. WHEN SHE WAS HIT IN THE REAR BY VEHICLE #2. DRIVER OF VEHICLE #2 STATES HE WAS TRAVELING N-BOUND ON WALNUT. HE STATES PRIOR TO HITTING VEHICLE #1 HE APPLIED THE BRAKE AND SLID ON THE WET SURFACE CAUSED BY THE RAIN AND WAS UNABLE TO AVOID HITTING VEHICLE #1. ALL PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. VEHICLE #1 WAS TOWED BY TODYS WITH EXTENSIVE REAR END DAMAGE. VEHICLE #2 WAS OPERATIONAL BUT HAD FRONT END FENDER DAMAGE. ALL PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT..
Keywords:
Crash, Rain, Severe
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3396518
Longitude:
-71.2068395
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);