crash_reports
1 row where keywords contains "Rain" and "retrieved" is on date 2021-11-01
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-26
Time:
14:47
Address:
WALNUT ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 10-26-21 AT APPROX. 1447HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WALNUT AND WASHINGTON ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING S-BOUND ON WALNUT AND STOPPED AT THE RED LIGHT. WHILE STOPPED DRIVER STATES HE WAS HIT IN THE REAR BY VEHICLE #2. VEHICLE #2 STATES SHE WAS TRAVELING S-BOUND ON WALNUT ST. WHEN SHE WENT TO STOP SHE APPLIED THE BRAKES AND SLID ON THE WET PAVEMENT ( IT HAD BEEN RAINING FOR 24 HOURS ) AND WAS UNABLE TO AVOID HITTING VEHICLE #1. VEHICLE #1 HAD MINOR RIGHT REAR DAMAGE. VEHICLE #2 HAD LEFT FRONT BUMPER AND CENTER DAMAGE. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE AGENCY. ALL VEHICLES WERE OPERATIONAL AND LEFT THE SCENE WITHOUT ADDITIONAL ASSISTANCE. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Rain
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3516103
Longitude:
-71.2073681
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);