crash_reports

Table actions

1 row where address = "769 WATERTOWN ST", dcc contains "Visibility obstructed" and keywords contains "Crash"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2000000488
Date:
2020-08-31
Time:
09:06
Address:
769 WATERTOWN ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 8-31-20 AT APPROX. 0906HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 774 WATERTOWN ST I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS EXITING HER DRIVEWAY FROM 774 WATERTOWN ST. HER VISIBILITY WAS OBSTRUCTED BY THE CITY OF NEWTON ROAD CREW WHO WAS WORKING IN FRONT OF 794 WATERTOWN ST. AS SHE EDGED OUT SHE WAS HIT ON THE LEFT SIDE QTR. PANEL BY VEHICLE #2. VEHICLE #2 DRIVER STATES HE WAS TRAVELING E-BOUND ON WATERTOWN ST. WHILE TRAVELING HE DID NOT SEE VEHICLE #1 UNTIL IT WAS TOO LATE TO AVOID HITTING HER IN THE LEFT SIDE. VEHICLE #1 HAD LEFT SIDE QTR. PANEL DAMAGE. VEHICLE #2 HAD FRONT END DAMAGE AND WAS TOWED BY TODYS. BOTH PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. BOTH PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.353197
Longitude:
-71.2167293
Location:
769 Watertown St, Newton, MA 02460, 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);