crash_reports

Table actions

1 row where dcc contains "Over-steering" and latitude = "42.3469722"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000541
Date:
2021-07-23
Time:
08:44
Address:
2040 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
ON 7-23-21 AT APPROX. 0844HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 2040 COMMONWEALTH AVE. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS PULLING OUT ONTO COMM AVE FROM THE LOADING DOCK TRYING TO ANGLE BACK IN BETTER. HE STATES WHILE EXITING HE CUT THE TRAILER TOO TIGHT AND HIT VEHICLE #2 THAT WAS PARKED ON COMM AVE. THE OWNER OF VEHICLE #2 HEARD THE CRASH AND CAME OUT TO INSPECT HIS VEHICLE. THERE WAS MINOR SCRAPES ON THE LEFT SIDE TRAILER OF VEHICLE #1. THERE WAS LEFT FRONT END DAMAGE AND A BROKEN LEFT DRIVER SIDE WINDSHIELD ON VEHICLE #2. BOTH PARTIES REPORTED NO INJURIES AND NEITHER VEHICLE WAS TOWED. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, 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);