crash_reports

Table actions

1 row where dcc contains "Lane departure", intersection = 0 and "retrieved" is on date 2021-11-29

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000968
Date:
2021-11-21
Time:
12:22
Address:
72 HIGHLAND ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 1-21-21 AT APPROX. 122HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT 72 HIGHLAND ST. I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES SOMETIME BETWEEN 1030-1230HR. SOMEONE HIT HIS MOTOR VEHICLE WHILE IT WAS PARKED IN FRONT OF 72 HIGHLAND ST. THE ACCIDENT CAUSED DAMAGE TO THE OWNERS LEFT REAR VIEW MIRROR. THE GLASS OF THE MIRROR REMAINED INTACT BUT THE MIRROR CAME UNHINGED. OWNER STATES THERE WAS NO WITNESSES TO THE ACCIDENT. THE OWNER OF 72 HIGHLAND TOLD THE OWNER OF VEHICLE #1 HE WOULD REVIEW HIS VIDEO FOOTAGE TO SEE IF HE HAS FOOTAGE OF THE ACCIDENT AND WOULD UPDATE IF ANYTHING WAS CAPTURED. OWNER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3467933
Longitude:
-71.2258655
Location:
72 Highland St, West 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);