crash_reports

Table actions

1 row where keywords contains "Rain" and "retrieved" is on date 2021-08-27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

Case number:
2100000616
Date:
2021-08-20
Time:
08:17
Address:
DERBY ST & WALTHAM ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 8-20-21 AT APPROX. 0817HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WALTHAM AND DERBY I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING S-BOUND ON WALTHAM. HE STOPPED AT THE INTERSECTION TO LET A BICYCLIST CROSS THE STREET AND WHEN HE STOPPED HE WAS HIT IN THE REAR BY VEHICLE #2. VEHICLE #2 STATES SHE WAS TRAVELING S-BOUND ON WALTHAM ST AND HAD STOPPED BEHIND VEHICLE #1. SHE STATES SHE WAS HIT IN THE REAR BY VEHICLE #3 AND THAT PUSHED HER INTO HITTING VEHICLE #1. VEHICLE #3 STATES SHE WAS TRAVELING S-BOUND ON WALTHAM. SHE SAW VEHICLES #1 AND #2 STOP. WHEN SHE WENT TO BRAKE SHE STATES HER VEHICLE SLID ON THE WET SURFACE ( IT HAD RAINED OVERNIGHT ) AND SHE WAS UNABLE TO AVOID HITTING VEHICLE #2. VEHICLE #1 HAD LEFT REAR FENDER DAMAGE. VEHICLE #2 HAD EXTENSIVE FRONT AND REAR END DAMAGE AND WAS TOWED BY TODYS. VEHICLE #3 HAD MINOR FRONT END DAMAGE AND WAS TOWED BY AAA TOWING. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Bike, Crash, Rain, Severe
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3562035
Longitude:
-71.2235141
Location:
Derby St & Waltham St, Newton, MA 02465, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);